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