public bool GetAllProductGYLineList(Mes_ProductGYLineInfo model, ref List <Mes_ProductGYLineInfo> lst, ref string ErrMsg)
{
string strSql = string.Empty;
//strSql = "select * from Mes_GYLine where 1=1 and isdel=1 and rownum < 100 ";
strSql = "select * from Mes_GYLine where 1=1 and isdel=1 ";
string strAnd = " and ";
#region where
strSql += strAnd;
strSql += " isMoban = " + model.isMoban + " ";
if (!string.IsNullOrEmpty(model.gyLineID))
{
strSql += strAnd;
strSql += " gyLineID Like '" + model.gyLineID + "%' ";
}
if (!string.IsNullOrEmpty(model.cpCode))
{
strSql += strAnd;
strSql += " cpCode Like '" + model.cpCode + "%' ";
}
if (!string.IsNullOrEmpty(model.cpName))
{
strSql += strAnd;
strSql += " cpName Like '" + model.cpName + "%' ";
}
if (model.DateFrom.HasValue)
{
strSql += strAnd;
strSql += " CreateTime >= " + model.DateFrom.Value.Date.ToOracleTimeString() + " ";
}
if (model.DateTo.HasValue)
{
strSql += strAnd;
strSql += " CreateTime <= " + model.DateTo.Value.Date.AddDays(1).ToOracleTimeString() + " ";
}
if (!string.IsNullOrEmpty(model.Creater))
{
strSql += strAnd;
strSql += " Creater Like '" + model.Creater + "%' ";
}
//strSql += " order by id desc ";
strSql += " order by gyLineID ";
#endregion
try
{
lst = new List <Mes_ProductGYLineInfo>();
//GYD
using (IDataReader dr = dbFactory.ExecuteReader(CommandType.Text, strSql))
{
while (dr.Read())
{
Mes_ProductGYLineInfo entityGYLine = new Mes_ProductGYLineInfo();
entityGYLine.ID = dr["ID"].ToInt32();
entityGYLine.gyLineID = dr["gyLineID"].ToDBString();
entityGYLine.machineType = dr["machineType"].ToDBString();
entityGYLine.bbID = dr["bbID"].ToDBString();
entityGYLine.gybbID = dr["gybbID"].ToDBString();
entityGYLine.cpCode = dr["cpCode"].ToDBString();
entityGYLine.cpName = dr["cpName"].ToDBString();
entityGYLine.gyLineName = dr["gyLineName"].ToDBString();
entityGYLine.isNew = dr["isNew"].ToInt32();
entityGYLine.capacity = dr["capacity"].ToDecimal();
entityGYLine.cptype = dr["cptype"].ToDBString();
entityGYLine.Qty = dr["Qty"].ToInt32();
entityGYLine.isMoban = dr["isMoban"].ToInt32();
entityGYLine.remark = dr["remark"].ToDBString();
entityGYLine.Creater = dr["Creater"].ToDBString();
entityGYLine.CreateTime = dr["CreateTime"].ToDateTime();
entityGYLine.isDel = dr["isDel"].ToInt32();
lst.Add(entityGYLine);
}
}
if (lst.Count <= 0)
{
ErrMsg = "no data!";
return(false);
}
return(true);
}
catch (Exception ex)
{
ErrMsg = ex.Message;
return(false);
}
}
public bool GetAllProductGYLineList(Mes_ProductGYLineInfo model, ref List <Mes_ProductGYLineInfo> lst, ref string ErrMsg)
{
Mes_ProductGY_DB mdb = new Mes_ProductGY_DB();
return(mdb.GetAllProductGYLineList(model, ref lst, ref ErrMsg));
}