void 图号型号_m_OnCompleteSearch() { DataRow drTemp = this.图号型号.DataResult; if (drTemp != null) { customDataGridView1.CurrentRow.Cells["物品名称"].Value = drTemp["物品名称"]; customDataGridView1.CurrentRow.Cells["规格"].Value = drTemp["规格"]; customDataGridView1.CurrentRow.Cells["物品ID"].Value = drTemp["序号"]; customDataGridView1.CurrentRow.Cells["单位"].Value = drTemp["单位"]; ((DataGridViewTextBoxShowCell)customDataGridView1.CurrentRow.Cells["批次号"]).m_EndSql = " and 物品ID = " + (int)drTemp["序号"]; IBasicGoodsServer goodsService = SCM_Level01_ServerFactory.GetServerModule <IBasicGoodsServer>(); F_GoodsAttributeRecord record = goodsService.GetGoodsAttirbuteRecord(Convert.ToInt32(drTemp["序号"]), Convert.ToInt32(CE_GoodsAttributeName.来料须依据检验结果入库)); if (record != null) { customDataGridView1.CurrentRow.Cells["检验报告"].Value = Convert.ToBoolean(record.AttributeValue); } } }
public List <View_Business_WarehouseInPut_RequisitionDetail> GetListViewDetail_OrderForm(string billNo, List <string> listOrderForm) { List <View_Business_WarehouseInPut_RequisitionDetail> listResult = new List <View_Business_WarehouseInPut_RequisitionDetail>(); string orderFormNum = ""; foreach (string item in listOrderForm) { orderFormNum += "'" + item + "',"; } orderFormNum = orderFormNum.Substring(0, orderFormNum.Length - 1); string strSql = " select a.订单号, b.物品ID , b.图号型号, b.物品名称 ,b.规格, " + " a.供货单位, b.订货数量, c.单位 from View_B_OrderFormInfo as a " + " inner join View_B_OrderFormGoods as b on a.订单号 = b.订单号 " + " inner join View_F_GoodsPlanCost as c on b.物品ID = c.序号 where a.订单号 in (" + orderFormNum + ")"; DataTable dtTemp = GlobalObject.DatabaseServer.QueryInfo(strSql); foreach (DataRow dr in dtTemp.Rows) { View_Business_WarehouseInPut_RequisitionDetail tempLnq = new View_Business_WarehouseInPut_RequisitionDetail(); tempLnq.单据号 = billNo; tempLnq.单位 = dr["单位"].ToString(); tempLnq.供应商 = dr["供货单位"].ToString(); tempLnq.关联业务 = dr["订单号"].ToString(); tempLnq.物品ID = (int)dr["物品ID"]; tempLnq.图号型号 = dr["图号型号"].ToString(); tempLnq.物品名称 = dr["物品名称"].ToString(); tempLnq.规格 = dr["规格"].ToString(); tempLnq.数量 = (decimal)dr["订货数量"]; IBasicGoodsServer goodsService = SCM_Level01_ServerFactory.GetServerModule <IBasicGoodsServer>(); F_GoodsAttributeRecord record = goodsService.GetGoodsAttirbuteRecord(tempLnq.物品ID, Convert.ToInt32(CE_GoodsAttributeName.来料须依据检验结果入库)); if (record != null) { tempLnq.检验报告 = Convert.ToBoolean(record.AttributeValue); } listResult.Add(tempLnq); } return(listResult); }