public static OrderPrintSystem.Model.ProOrdersDetailMOD GetModelByWhere(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 orderDetailId,orderNum,proType,proNum,ProPrice,withWorkNo,printTime,printType,printCount,PiHao,PlanSendTime,ProductAddress,SGDCount from proOrdersDetail ");
strSql.Append(" where 1=1 " + strWhere);
OrderPrintSystem.Model.ProOrdersDetailMOD model = new OrderPrintSystem.Model.ProOrdersDetailMOD();
SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString());
if (reader.Read())
{
if (reader["orderDetailId"] != null && reader["orderDetailId"].ToString() != "")
{
model.orderDetailId = int.Parse(reader["orderDetailId"].ToString());
}
if (reader["orderNum"] != null)
{
model.orderNum = reader["orderNum"].ToString();
}
if (reader["proType"] != null)
{
model.proType = reader["proType"].ToString();
}
if (reader["proNum"] != null && reader["proNum"].ToString() != "")
{
model.proNum = int.Parse(reader["proNum"].ToString());
}
if (reader["ProPrice"] != null && reader["ProPrice"].ToString() != "")
{
model.ProPrice = decimal.Parse(reader["ProPrice"].ToString());
}
if (reader["withWorkNo"] != null)
{
model.withWorkNo = reader["withWorkNo"].ToString();
}
if (reader["printTime"] != null && reader["printTime"].ToString() != "")
{
model.printTime = DateTime.Parse(reader["printTime"].ToString());
}
if (reader["printType"] != null)
{
model.printType = reader["printType"].ToString();
}
if (reader["printCount"] != null && reader["printCount"].ToString() != "")
{
model.printCount = int.Parse(reader["printCount"].ToString());
}
if (reader["PiHao"] != null && reader["PiHao"].ToString() != "")
{
model.PiHao = reader["PiHao"].ToString();
}
if (reader["PlanSendTime"] != null && reader["PlanSendTime"].ToString() != "")
{
model.PlanSendTime = Convert.ToDateTime(reader["PlanSendTime"].ToString());
}
if (reader["ProductAddress"] != null && reader["ProductAddress"].ToString() != "")
{
model.ProductAddress = reader["ProductAddress"].ToString();
}
if (reader["SGDCount"] != null && reader["SGDCount"].ToString() != "")
{
model.SGDCount = Convert.ToInt32(reader["SGDCount"].ToString());
}
reader.Close();
return model;
}
else
{
reader.Close();
return null;
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public static OrderPrintSystem.Model.ProOrdersDetailMOD GetModel(string proType, string orderNum)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 PrintSGDCount from proOrdersDetail ");
strSql.Append(" where proType='" + proType + "' and orderNum='" + orderNum + "'");
OrderPrintSystem.Model.ProOrdersDetailMOD model = new OrderPrintSystem.Model.ProOrdersDetailMOD();
SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString());
if (reader.Read())
{
if (reader["PrintSGDCount"] != null && reader["PrintSGDCount"].ToString() != "")
{
model.PrintSGDCount = int.Parse(reader["PrintSGDCount"].ToString());
}
}
reader.Close();
return model;
}
