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 DALPacking
|
{
|
public IList<Packing> GetPackingList(Packing Json, ref PageInfo pageInfo)
|
{
|
try
|
{
|
|
IList<Packing> list = new List<Packing>();
|
StringBuilder strSql = new StringBuilder();
|
List<SqlParam> para = new List<SqlParam>();
|
strSql.Append("Select * from View_S_Packing ");
|
|
|
if (Json.PackingCode != null && Json.PackingCode != "")
|
{
|
if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
|
strSql.Append("PackingCode like '%' + @PackingCode + '%' ");
|
para.Add(new SqlParam("@PackingCode", Json.PackingCode));
|
}
|
|
if (Json.PackingName != null && Json.PackingName != "")
|
{
|
if (para.Count < 1) strSql.Append("where "); else strSql.Append(" and ");
|
strSql.Append("PackingName like '%' + @PackingName + '%' ");
|
para.Add(new SqlParam("@PackingName", Json.PackingName));
|
}
|
|
if (para.Count < 1) strSql.Append("where IsDel = 0"); else strSql.Append(" and IsDel = 0");
|
|
|
SqlParam[] param = null;
|
if (para != null)
|
param = para.ToArray();
|
|
|
DataTable dt = DataFactory.SqlDataBase().GetPageList(strSql.ToString(), param, "CreateTime", "DESC", ref pageInfo);
|
|
list = ModelConvertHelper<Packing>.DataTableToModel(dt);
|
|
return list;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
public Packing GetModel(string PackingCode)
|
{
|
try
|
{
|
Packing us = null;
|
StringBuilder strSql = new StringBuilder();
|
strSql.Append("Select * from S_Packing where ");
|
strSql.Append("PackingCode = @PackingCode ");
|
|
SqlParam[] para = new SqlParam[]
|
{
|
new SqlParam("@PackingCode", PackingCode),
|
};
|
|
IDataReader dt = DataFactory.SqlDataBase().GetDataReaderBySQL(strSql, para);
|
|
us = ModelConvertHelper<Packing>.ReaderToModel(dt);
|
|
return us;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
public bool IsExist(string PackingCode, string value)
|
{
|
bool result = false;
|
try
|
{
|
string[] para = new string[] { value };
|
int dt = DataFactory.SqlDataBase().IsExist("S_Packing", PackingCode, para);
|
if (dt > 0) result = true;
|
return result;
|
}
|
catch
|
{
|
throw new NotImplementedException();
|
}
|
}
|
public bool Add(Packing model, string loginUser)
|
{
|
bool result = false;
|
try
|
{
|
Hashtable ht = new Hashtable();
|
|
ht["PackingCode"] = "'" + model.PackingCode + "'";
|
ht["PackingName"] = "'" + model.PackingName + "'";
|
|
ht["CreateUser"] = "'" + loginUser + "'";
|
ht["CreateTime"] = "getdate()";
|
ht["Demo"] = "'" + model.Demo + "'";
|
ht["Long"] = "'" + model.Long + "'";
|
|
ht["Wide"] = "'" + model.Wide + "'";
|
ht["High"] = "'" + model.High + "'";
|
ht["Volume"] = "'" + model.Volume + "'";
|
ht["IsDel"] = 0;
|
int _ret = DataFactory.SqlDataBase().InsertByHashtableNullParam("S_Packing", ht);
|
|
if (_ret == 1) result = true;
|
|
return result;
|
|
}
|
catch
|
{
|
return result;
|
}
|
}
|
public bool Update(Packing model)
|
{
|
bool result = false;
|
try
|
{
|
Hashtable ht = new Hashtable();
|
|
ht["PackingName"] = string.IsNullOrEmpty(model.PackingName) ? "''" : "'" + model.PackingName + "'";
|
ht["Demo"] = string.IsNullOrEmpty(model.Demo) ? "''" : "'" + model.Demo + "'";
|
ht["Long"] = string.IsNullOrEmpty(model.Long) ? "''" : "'" + model.Long + "'";
|
ht["Wide"] = string.IsNullOrEmpty(model.Wide) ? "''" : "'" + model.Wide + "'";
|
ht["High"] = string.IsNullOrEmpty(model.High) ? "''" : "'" + model.High + "'";
|
ht["Volume"] = string.IsNullOrEmpty(model.Volume) ? "''" : "'" + model.Volume + "'";
|
|
string PackingCode = "'" + model.PackingCode + "'";
|
|
int _ret = DataFactory.SqlDataBase().UpdateByHashtable("S_Packing", "PackingCode", PackingCode, ht);
|
|
if (_ret == 1) result = true;
|
|
return result;
|
|
}
|
catch
|
{
|
return result;
|
}
|
}
|
public bool BatchDelete(string[] PackingCode)
|
{
|
bool result = false;
|
try
|
{
|
int dt = DataFactory.SqlDataBase().IsExist("S_Packing", "PackingCode", PackingCode);
|
if (dt >= PackingCode.Length)
|
{
|
int i = 0;
|
while (i < PackingCode.Length)
|
{
|
StringBuilder sql = new StringBuilder();
|
sql.Append("update S_Packing set IsDel=1 where PackingCode='" + PackingCode[i] + "'");
|
int _ret = DataFactory.SqlDataBase().ExecuteBySql(sql);
|
if (_ret >= PackingCode.Length) result = true;
|
i++;
|
}
|
}
|
return result;
|
|
}
|
catch
|
{
|
return result;
|
}
|
}
|
}
|
}
|
