protected void updateWarehouse() { MSYS.Web.StoreService.StoreServiceInterfaceService service = new MSYS.Web.StoreService.StoreServiceInterfaceService(); service.getMaterialWarehouseListCompleted += new getMaterialWarehouseListCompletedEventHandler(wareHouseUpdate_Completed); service.getMaterialWarehouseListAsync(); }
public DataTable queryStorage(string year, string matername, string category, string matertype, string place, string warehouse) { MSYS.Web.StoreService.StoreServiceInterfaceService service = new MSYS.Web.StoreService.StoreServiceInterfaceService(); tWaOnhand[] lists = service.getMatOnhandNoPageList(year, matername, category, matertype, place, warehouse); DataTable data = new DataTable(); data.Columns.Add("物料名称"); data.Columns.Add("物料编码"); data.Columns.Add("仓库"); data.Columns.Add("货位号"); data.Columns.Add("类别"); data.Columns.Add("类型"); data.Columns.Add("产地"); data.Columns.Add("库存(kg)"); data.Columns.Add("使用叶组"); data.Columns.Add("件数"); data.Columns.Add("单重(kg)"); foreach (tWaOnhand mat in lists) { string[] paras = new string[] { mat.materName, mat.materCode, mat.warehouseName, mat.clocationid, mat.typeCode, mat.categoryCode, mat.provinceCode, mat.pkOnhandnum, mat.formulaName, mat.matPack, mat.pack }; data.Rows.Add(paras); } return(data); }
protected void btnSearch_Click(object sender, EventArgs e) { string year = txtYear.Text.ToString().Trim(); string materialName = txtname.Text.ToString().Trim(); string province = txtprovince.Text.ToString().Trim(); string warehouse = txtwarehouse.SelectedValue.ToString().Trim(); string type = txttype.SelectedValue.ToString().Trim(); string category = txtcatgory.SelectedValue.ToString().Trim(); MSYS.Web.StoreService.StoreServiceInterfaceService service = new MSYS.Web.StoreService.StoreServiceInterfaceService(); tWaOnhand[] lists = service.getOnhandNoBjPageList(materialName.ToString(), "", type.ToString(), category.ToString(), year.ToString(), province.ToString(), warehouse.ToString()); System.Diagnostics.Debug.WriteLine(year); System.Diagnostics.Debug.WriteLine(materialName); System.Diagnostics.Debug.WriteLine(province); System.Diagnostics.Debug.WriteLine(warehouse); DataTable data = new DataTable(); data.Columns.Add("ID"); data.Columns.Add("物料编码"); data.Columns.Add("物料名称"); //data.Columns.Add("物料编码"); data.Columns.Add("仓库"); data.Columns.Add("货位号"); data.Columns.Add("类型"); data.Columns.Add("类别"); data.Columns.Add("产地"); data.Columns.Add("库存(kg)"); data.Columns.Add("使用叶组"); data.Columns.Add("件数"); data.Columns.Add("单重(kg)"); /*if (lists == null || lists.Length == 0) * { * System.Diagnostics.Debug.WriteLine("无数据"); * GridView1.DataSource = data; * GridView1.DataBind(); * return; * * }*/ if (lists == null) { GridView1.DataSource = null; GridView1.DataBind(); return; } foreach (tWaOnhand mat in lists) { string[] paras = new string[] { mat.id.ToString(), mat.materCode, mat.mName, mat.warehouseName, mat.locationName, mat.materCategory, mat.materType, mat.provinceCode, mat.sumonhand.ToString(), mat.formulaName, mat.matPack, mat.pack }; data.Rows.Add(paras); } GridView1.DataSource = data; GridView1.DataBind(); }
public tWaOnhand queryMater(string materCode) { MSYS.Web.StoreService.StoreServiceInterfaceService service = new MSYS.Web.StoreService.StoreServiceInterfaceService(); tWaOnhand[] lists = service.getOnhandNoBjPageList("", materCode, "", "", "", "", ""); if (lists == null) { return(null); } return(lists[0]); /* * tWaOnhand test = new tWaOnhand(); * test.mName = "贵州长梗"; * test.cwarehouseid = "03"; * test.locationName = "货位03"; * test.warehouseName = "原料库"; * test.sumonhand = 2500000; * return test;*/ }
public string InOrOut(string PZ_code, string name, string nameno)//出入库单据号及当前操作人员 { MSYS.Web.StoreService.StoreServiceInterfaceService service = new MSYS.Web.StoreService.StoreServiceInterfaceService(); MSYS.DAL.DbOperator opt = new MSYS.DAL.DbOperator(); string query = "select t.*,r.name as creator,s.name as modifier,q.formula_code from ht_strg_materia t left join ht_svr_user r on r.id = t.creator_id left join ht_svr_user s on s.id = t.modify_id left join ht_qa_mater_formula q on q.prod_code = substr(t.monthplanno,9,7) where t.ORDER_SN = '" + PZ_code + "'"; DataSet data = opt.CreateDataSetOra(query); if (data != null && data.Tables[0].Rows.Count > 0) { DataRow row = data.Tables[0].Rows[0]; materInAndOutVO r = new materInAndOutVO(); r.loginname = nameno; r.loginname = row["creator_id"].ToString(); r.name = row["creator"].ToString(); r.planNo = row["MONTHPLANNO"].ToString(); r.prodCode = row["MONTHPLANNO"].ToString().Substring(8, 7); try { string masql = "select xy_prod_code from ht_pub_prod_design where prod_code = '" + r.prodCode + "'"; DataSet mads = opt.CreateDataSetOra(masql); r.prodCode = mads.Tables[0].Rows[0][0].ToString(); } catch { System.Diagnostics.Debug.WriteLine("查询xyprodcode失败"); } if (row["SHIFT_CODE"].ToString() != null && row["SHIFT_CODE"].ToString() != "") { r.shiftCode = this.shift_dic[row["SHIFT_CODE"].ToString()]; } if (row["TEAM_CODE"].ToString() != null && row["TEAM_CODE"].ToString() != "") { r.teamCode = this.team_dic[row["TEAM_CODE"].ToString()]; } // if(row["FDATE"].ToString() != null && row["FDATE"].ToString() != "") // r.FDate =Convert.ToDateTime( row["FDATE"].ToString()); r.createId = row["CREATOR_ID"].ToString(); //string sqlid = "select loginname from ht_svr_user where id = '" + r.createId + "'"; //r.createId = opt.CreateDataSetOra(sqlid).Tables[0].Rows[0][0].ToString(); // r.loginname = r.createId; r.creator = row["creator"].ToString(); r.modifyId = row["Modify_ID"].ToString(); r.modifyMan = row["modifier"].ToString(); r.bomType = "1"; r.modifyTime = row["MODIFY_TIME"].ToString(); if (row["STRG_TYPE"].ToString() == "0") { r.vouNo = "YLLY" + row["ORDER_SN"].ToString().Substring(2); } if (row["STRG_TYPE"].ToString() == "1") { r.vouNo = "YLLT" + row["ORDER_SN"].ToString().Substring(2); } if (row["BATCHNUM"].ToString() != null && row["BATCHNUM"].ToString() != "") { r.batchNumber = Convert.ToDouble(row["BATCHNUM"].ToString()); } if (row["CABOSUM"].ToString() != null && row["CABOSUM"].ToString() != "") { r.caboSum = Convert.ToDouble(row["CABOSUM"].ToString()); } //if (row["PEICESSUM"].ToString() != null && row["PEICESSUM"].ToString() != "") //r.piecesSum = Convert.ToDouble(row["PEICESSUM"].ToString()); r.remark = row["REMARK"].ToString(); if (row["PEICESSUM"].ToString() != null && row["PEICESSUM"].ToString() != "") { r.piecesSum = Convert.ToDouble(row["PEICESSUM"].ToString()); } if (row["STRG_TYPE"].ToString() != null && row["STRG_TYPE"].ToString() != "") { r.inoutType = this.MIOT[row["STRG_TYPE"].ToString()]; } r.cwarehouseid = row["WARE_HOUSE_ID"].ToString(); if (row["FORMULA_CODE"].ToString() != null && row["FORMULA_CODE"].ToString() != "") { r.formulaId = Convert.ToInt64(row["formula_code"].ToString()); } List <tShopMaterInoutSubVO> s = new List <tShopMaterInoutSubVO>(); //DataSet details = opt.CreateDataSetOra("select t.*,r.material_name from ht_strg_mater_sub t left join ht_pub_materiel r on r.material_code = t.mater_code where t.main_code = '" + PZ_code + "' and t.is_del = '0'"); DataSet details = opt.CreateDataSetOra("select t.*,r.material_name from ht_strg_mater_sub t left join ht_pub_materiel r on r.material_code = t.mater_code where t.main_code = '" + PZ_code + "' and t.is_del = '0'"); if (details != null && details.Tables[0].Rows.Count > 0) { foreach (DataRow drow in details.Tables[0].Rows) { tWaOnhand info = queryMater(drow["MATER_CODE"].ToString()); // if(drow["MATER_FLAG"].ToString() == "SP" || drow["MATER_FLAG"].ToString() == "碎片") // continue; tShopMaterInoutSubVO sub = new tShopMaterInoutSubVO(); if (info != null) { sub.materName = info.mName.ToString();//接口 if (info.cwarehouseid != null) { sub.warehouseCode = info.cwarehouseid.ToString();//从接口获得 r.cwarehouseid = sub.warehouseCode; sub.warehouseName = info.warehouseName.ToString(); } if (info.locationName != null) { sub.materLocation = info.locationName.ToString(); } //if (row["STRG_TYPE"].ToString() == "0" && (Convert.ToDouble(info.sumonhand) < Convert.ToDouble(drow["ORIGINAL_DEMAND"].ToString()))) //{ // return "notenough" + info.materName.ToString(); //} } sub.mainId = drow["MAIN_CODE"].ToString(); sub.materCode = drow["MATER_CODE"].ToString(); //sub.materName = drow["material_name"].ToString();//接口 sub.materType = drow["MATER_FLAG"].ToString();// sub.unitCode = drow["UNIT_CODE"].ToString(); // sub.unitName = drow["TEAM_CODE"].ToString(); sub.occurQty = drow["ORIGINAL_DEMAND"].ToString(); sub.remark = drow["REMARK"].ToString(); //sub.warehouseCode = drow["WAREHOUSECODE"].ToString();//从接口获得 sub.packingNumbers = drow["PACKNUM"].ToString(); sub.substance = drow["SUBSTANCE"].ToString(); sub.oddQty = drow["ODDQTY"].ToString(); sub.materName = drow["MATERIAL_NAME"].ToString(); s.Add(sub); } } r.subList = s.ToArray(); DateTime d = new DateTime(); string date = date = DateTime.Now.ToString("yyyy-MM-dd"); return(service.yuanliaoInAndOut4ws_03(r, date, r.batchNumber).status); // return ""; } else { return("Falied"); } }