using Commom.Utility;
|
using Common;
|
using Model;
|
using System;
|
using System.Collections;
|
using System.Collections.Generic;
|
using System.Data;
|
using System.Linq;
|
using System.Text;
|
using System.Threading.Tasks;
|
|
namespace BLL.DAL
|
{
|
public class DALBrand
|
{
|
public IList<Brand> GetList(AjaxBrandList Json, ref PageInfo pageInfo)
|
{
|
try
|
{
|
IList<Brand> list = new List<Brand>();
|
StringBuilder strSql = new StringBuilder();
|
List<SqlParam> para = new List<SqlParam>();
|
strSql.Append("Select * from View_Brand_UserInfo where IsDel=0");
|
|
if (Json.BrandCode != null && Json.BrandCode != "")
|
{
|
strSql.Append(" and BrandCode like '%" + Json.BrandCode + "%' ");
|
}
|
if (Json.BrandName != null && Json.BrandName != "")
|
{
|
strSql.Append(" and BrandName like '%" +Json.BrandName + "%' ");
|
}
|
|
SqlParam[] param = null;
|
if (para != null)
|
{
|
param = para.ToArray();
|
}
|
|
DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "CreatTime", "Desc", ref pageInfo);
|
return ModelConvertHelper<Brand>.DataTableToModel(dt);
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
public bool Add(Brand model, string loginUser)
|
{
|
bool result = false;
|
try
|
{
|
Hashtable ht = new Hashtable();
|
|
ht["BrandCode"] = model.BrandCode.AddQuotes();
|
ht["BrandName"] = "'" + model.BrandName + "'";
|
ht["CreatTime"] = "Getdate()";
|
ht["CreatUser"] = "'" + loginUser + "'";
|
ht["Demo"] = "'" + model.Demo + "'";
|
|
int _ret = DataFactory.SqlDataBase().InsertByHashtableNullParam("Brand", ht);
|
|
if (_ret == 1) result = true;
|
|
return result;
|
|
}
|
catch
|
{
|
return result;
|
}
|
}
|
//修改品牌
|
public bool Update(Brand model,string loginUser)
|
{
|
bool result = false;
|
try
|
{
|
Hashtable ht = new Hashtable();
|
ht["BrandName"] = string.IsNullOrEmpty(model.BrandName) ? "''" : "'" + model.BrandName + "'";
|
ht["Demo"] = string.IsNullOrEmpty(model.Demo) ? "''" : "'" + model.Demo + "'";
|
ht["UpdateTime"] = "getdate()";
|
ht["UpdateUser"] = loginUser.AddQuotes();
|
|
string ID = "'" + model.ID + "'";
|
|
int _ret = DataFactory.SqlDataBase().UpdateByHashtable("Brand", "ID", ID, ht);
|
if (_ret == 1) result = true;
|
|
return result;
|
}
|
catch
|
{
|
return result;
|
}
|
}
|
//逻辑删除
|
public bool BatchDelete(string[] ID)
|
{
|
bool result = false;
|
try
|
{
|
int dt = DataFactory.SqlDataBase().IsExist("Brand", "ID", ID);
|
if (dt >= ID.Length)
|
{
|
int i = 0;
|
while (i < ID.Length)
|
{
|
StringBuilder sql = new StringBuilder();
|
sql.Append("update Brand set IsDel=1 where ID='" + ID[i] + "'");
|
int _ret = DataFactory.SqlDataBase().ExecuteBySql(sql);
|
if (_ret >= ID.Length) result = true;
|
i++;
|
}
|
|
}
|
return result;
|
|
}
|
catch
|
{
|
return result;
|
}
|
}
|
//编辑查询
|
public Brand GetModel(string ID)
|
{
|
try
|
{
|
Brand us = null;
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("Select * from Brand where ");
|
strSql.Append("ID = @ID ");
|
|
SqlParam[] para = new SqlParam[]
|
{
|
new SqlParam("@ID", ID),
|
};
|
|
IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);
|
us = ModelConvertHelper<Brand>.ReaderToModel(dt);
|
|
return us;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
|
public bool IsExist(string sqlWhere)
|
{
|
return DataFactory.SqlDataBase().IsExist("brand", sqlWhere);
|
}
|
|
public bool IsExist(Brand model)
|
{
|
bool result = false;
|
try
|
{
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("select count(id) from Brand where BrandName = " + model.BrandName.AddQuotes());
|
strSql.Append(" and id != " + model.ID + ";");
|
DataRow row = DataFactory.SqlDataBase().GetDataRowBySQL(strSql);
|
if (row[0].ToString() == "0")
|
{
|
result = true;
|
}
|
|
return result;
|
}
|
catch (Exception)
|
{
|
|
return result;
|
}
|
}
|
|
//物料查询品牌下拉框
|
public IList<Brand> GetBrandList(string bdName)
|
{
|
try
|
{
|
|
IList<Brand> ls = new List<Brand>();
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("select ID,BrandCode,BrandName,guid from Brand where IsDel !=1");
|
if (!string.IsNullOrEmpty(bdName))
|
{
|
strSql.Append(" and BrandName like '%" + bdName + "%'");
|
}
|
strSql.Append(" order by ID;");
|
|
IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql);
|
ls = ModelConvertHelper<Brand>.DataReaderToModel(dt);
|
|
return ls;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
}
|
}
|
