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; }