/// <summary> /// 查询所有未检验的订单 /// </summary> public List <VAN_OA.Model.JXC.CAI_POCaiView> GetListViewCai_POOrders_Cai_POOrderChecks_View(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" GoodAreaNumber,[ProNo],[PONo] ,[POName],[PODate],[POPayStype],[POTotal],[GuestName],[AE] "); strSql.Append(",[INSIDE],[GuestNo],[Ids],[Id],[Num],[GoodId],[totalOrderNum],[lastSupplier],[lastPrice],[GoodNo],[GoodName],[GoodSpec]"); strSql.Append(",[GoodModel],[GoodUnit],[GoodTypeSmName],[CaiGou],loginName,LastTruePrice"); strSql.Append(" from Cai_POOrders_Cai_POOrderChecks_View "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } strSql.Append(" order by ids desc"); List <VAN_OA.Model.JXC.CAI_POCaiView> list = new List <VAN_OA.Model.JXC.CAI_POCaiView>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { Model.JXC.CAI_POCaiView model = new VAN_OA.Model.JXC.CAI_POCaiView(); object ojb; model.GoodAreaNumber = dataReader["GoodAreaNumber"].ToString(); model.PONo = dataReader["PONo"].ToString(); ojb = dataReader["GuestNo"]; if (ojb != null && ojb != DBNull.Value) { model.GuestNo = ojb.ToString(); } ojb = dataReader["ProNo"]; if (ojb != null && ojb != DBNull.Value) { model.ProNo = ojb.ToString(); } ojb = dataReader["GuestName"]; if (ojb != null && ojb != DBNull.Value) { model.GuestName = ojb.ToString(); } ojb = dataReader["AE"]; if (ojb != null && ojb != DBNull.Value) { model.AE = ojb.ToString(); } ojb = dataReader["INSIDE"]; if (ojb != null && ojb != DBNull.Value) { model.INSIDE = ojb.ToString(); } ojb = dataReader["POName"]; if (ojb != null && ojb != DBNull.Value) { model.POName = ojb.ToString(); } ojb = dataReader["PODate"]; if (ojb != null && ojb != DBNull.Value) { model.PODate = Convert.ToDateTime(ojb); } ojb = dataReader["POTotal"]; if (ojb != null && ojb != DBNull.Value) { model.POTotal = Convert.ToDecimal(ojb); } ojb = dataReader["POPayStype"]; if (ojb != null && ojb != DBNull.Value) { model.POPayStype = ojb.ToString(); } model.POCaiId = Convert.ToInt32(dataReader["Ids"]); ojb = dataReader["Num"]; if (ojb != null && ojb != DBNull.Value) { model.Num = Convert.ToDecimal(ojb); } ojb = dataReader["totalOrderNum"]; if (ojb != null && ojb != DBNull.Value) { model.totalOrderNum = Convert.ToDecimal(ojb); } model.ResultNum = model.Num - model.totalOrderNum; ojb = dataReader["lastPrice"]; if (ojb != null && ojb != DBNull.Value) { model.Price = Convert.ToDecimal(ojb); } model.Total = model.Price * model.ResultNum; ojb = dataReader["LastSupplier"]; if (ojb != null && ojb != DBNull.Value) { model.Supplier = ojb.ToString(); } ojb = dataReader["GoodNo"]; if (ojb != null && ojb != DBNull.Value) { model.GoodNo = ojb.ToString(); } ojb = dataReader["GoodName"]; if (ojb != null && ojb != DBNull.Value) { model.GoodName = ojb.ToString(); } ojb = dataReader["GoodSpec"]; if (ojb != null && ojb != DBNull.Value) { model.GoodSpec = ojb.ToString(); } ojb = dataReader["GoodModel"]; if (ojb != null && ojb != DBNull.Value) { model.Good_Model = ojb.ToString(); } ojb = dataReader["GoodUnit"]; if (ojb != null && ojb != DBNull.Value) { model.GoodUnit = ojb.ToString(); } ojb = dataReader["GoodTypeSmName"]; if (ojb != null && ojb != DBNull.Value) { model.GoodTypeSmName = ojb.ToString(); } ojb = dataReader["loginName"]; if (ojb != null && ojb != DBNull.Value) { model.loginName = ojb.ToString(); } ojb = dataReader["GoodId"]; if (ojb != null && ojb != DBNull.Value) { model.GoodId = Convert.ToInt32(ojb); } ojb = dataReader["LastTruePrice"]; if (ojb != null && ojb != DBNull.Value) { model.LastTruePrice = Convert.ToDecimal(ojb); } model.CaiGou = dataReader["CaiGou"].ToString(); list.Add(model); } } } return(list); }
/// <summary> /// 查询所有未检验的订单 /// </summary> public List <VAN_OA.Model.JXC.CAI_POCaiView> GetListView(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select "); strSql.Append(" * "); strSql.Append(" from CAI_Order_Supplier_View "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } List <VAN_OA.Model.JXC.CAI_POCaiView> list = new List <VAN_OA.Model.JXC.CAI_POCaiView>(); using (SqlConnection conn = DBHelp.getConn()) { conn.Open(); SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn); using (SqlDataReader dataReader = objCommand.ExecuteReader()) { while (dataReader.Read()) { Model.JXC.CAI_POCaiView model = new VAN_OA.Model.JXC.CAI_POCaiView(); object ojb; model.PONo = dataReader["PONo"].ToString(); model.BusType = dataReader["BusType"].ToString(); ojb = dataReader["GuestNo"]; if (ojb != null && ojb != DBNull.Value) { model.GuestNo = ojb.ToString(); } ojb = dataReader["ProNo"]; if (ojb != null && ojb != DBNull.Value) { model.ProNo = ojb.ToString(); } ojb = dataReader["GuestName"]; if (ojb != null && ojb != DBNull.Value) { model.GuestName = ojb.ToString(); } ojb = dataReader["AE"]; if (ojb != null && ojb != DBNull.Value) { model.AE = ojb.ToString(); } ojb = dataReader["INSIDE"]; if (ojb != null && ojb != DBNull.Value) { model.INSIDE = ojb.ToString(); } ojb = dataReader["POName"]; if (ojb != null && ojb != DBNull.Value) { model.POName = ojb.ToString(); } ojb = dataReader["PODate"]; if (ojb != null && ojb != DBNull.Value) { model.PODate = Convert.ToDateTime(ojb); } ojb = dataReader["POTotal"]; if (ojb != null && ojb != DBNull.Value) { model.POTotal = Convert.ToDecimal(ojb); } ojb = dataReader["POPayStype"]; if (ojb != null && ojb != DBNull.Value) { model.POPayStype = ojb.ToString(); } model.POCaiId = Convert.ToInt32(dataReader["POCaiId"]); ojb = dataReader["Num"]; if (ojb != null && ojb != DBNull.Value) { model.Num = Convert.ToInt32(ojb); } ojb = dataReader["lastPrice"]; if (ojb != null && ojb != DBNull.Value) { model.Price = Convert.ToDecimal(ojb); } model.Total = model.Price * model.Num; ojb = dataReader["LastSupplier"]; if (ojb != null && ojb != DBNull.Value) { model.Supplier = ojb.ToString(); } ojb = dataReader["GoodNo"]; if (ojb != null && ojb != DBNull.Value) { model.GoodNo = ojb.ToString(); } ojb = dataReader["GoodName"]; if (ojb != null && ojb != DBNull.Value) { model.GoodName = ojb.ToString(); } ojb = dataReader["GoodSpec"]; if (ojb != null && ojb != DBNull.Value) { model.GoodSpec = ojb.ToString(); } ojb = dataReader["GoodModel"]; if (ojb != null && ojb != DBNull.Value) { model.Good_Model = ojb.ToString(); } ojb = dataReader["GoodUnit"]; if (ojb != null && ojb != DBNull.Value) { model.GoodUnit = ojb.ToString(); } ojb = dataReader["GoodTypeSmName"]; if (ojb != null && ojb != DBNull.Value) { model.GoodTypeSmName = ojb.ToString(); } ojb = dataReader["GoodId"]; if (ojb != null && ojb != DBNull.Value) { model.GoodId = Convert.ToInt32(ojb); } list.Add(model); } } } return(list); }