private void Closed()
{
string strPoID = this.txtPoID.Text.Trim();
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
if (StoBusi.PoSotckMainClose(strPoID, ls1.strOperName))
{
this.SetSuccMsgPageBydir("采购订单完成成功！", "Storage/wfmPoStock.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("采购订单完成时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private DataTable SeachGoods()
{
DataTable dtout = new DataTable();
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
string strGoodType = this.ddlGoodType.SelectedValue;
string strGoodName = this.txtGoodName.Text.Trim();
if (strGoodType == "全部")
{
strGoodType = "";
}
if (!(strGoodType == "" && strGoodName == ""))
{
dtout = StoBusi.ChartSeachGoods(strGoodType, strGoodName);
}
return(dtout);
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBy2dir("查询错误，请重试！");
return(dtout);
}
}
protected DataTable Query(string strAcctMonth, string strGoodsID)
{
DataTable dtout = new DataTable();
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
dtout = StoBusi.GetGoodsChart(strAcctMonth, strGoodsID);
if (dtout == null)
{
this.SetErrorMsgPageBy2dir("查询出错，请重试！");
return(dtout);
}
else
{
return(dtout);
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBy2dir("查询错误，请重试！");
return(dtout);
}
}
protected void btnRelativeMakeToReceive_Click(object sender, System.EventArgs e)
{
if (Session["ToReceive"] != null)
{
DataTable dtIn = (DataTable)Session["ToReceive"];
if (dtIn.Rows.Count > 0)
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (!StoBusi.RelativeMakeToReceive(dtIn))
{
this.SetErrorMsgPageBydir("关联错误，请重试！");
return;
}
else
{
Session.Remove("ToReceive");
this.SetSuccMsgPageBydir("关联成功！", "Storage/wfmMakeBillRelativeReceive.aspx");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("关联错误，请重试！");
return;
}
}
}
}
private void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
{
string strSerial = e.Item.Cells[0].Text.Trim();
if (strSerial == "")
{
this.SetErrorMsgPageBydirHistory("找不到要删除的数据！");
return;
}
else
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.SaleLoseDelete(strSerial))
{
this.SetSuccMsgPageBydir("删除损耗记录成功！", "Storage/wfmSaleLoseQuery.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("删除损耗记录时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
}
private void btnQuery_Click(object sender, System.EventArgs e)
{
string strMonth = this.ddlMonth.SelectedItem.Text;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataTable dtout = StoBusi.GetStockPlanQuery(strMonth);
if (dtout == null)
{
this.SetErrorMsgPageBydir("²éѯ³ö´í£¬ÇëÖØÊÔ£¡");
return;
}
else
{
dtout.TableName = "²É¹º¼Æ»®±í";
Session["QUERY"] = dtout;
}
UcPageView1.MyDataGrid.PageSize = 20;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("²éѯ´íÎó£¬ÇëÖØÊÔ£¡");
return;
}
}
protected void btnFind_Click(object sender, System.EventArgs e)
{
string strProviderCode = this.txtProviderCode.Text.Trim();
if (strProviderCode == "")
{
this.SetErrorMsgPageBydirHistory("请输入供应商编码！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
string strProviderName = StoBusi.IsExistProvider(strProviderCode);
if (strProviderName == "")
{
this.txtProviderName.Text = "";
this.txtProviderName.Enabled = true;
}
else
{
this.txtProviderName.Text = strProviderName;
this.txtProviderName.Enabled = false;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void dgbind()
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
DataTable dtout = StoBusi.GetProviderToGoods(this.txtProviderID.Text.Trim(), this.txtProviderName.Text.Trim());
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
this.TableConvert(dtout, "采购计量单位", "ComputationUnit");
dtout.TableName = "供应商供应货品清单";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
}
UcPageView1.MyDataGrid.PageSize = 10;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
protected void btnAllOK_Click(object sender, System.EventArgs e)
{
DataTable dtLoseList = (DataTable)Session["NewLoseList"];
if (dtLoseList == null || dtLoseList.Rows.Count == 0 || this.DataGrid1.Items.Count == 0)
{
this.SetErrorMsgPageBydirHistory("没有录入任何损耗信息，请先录入！");
return;
}
else
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.NewSaleLoseAdd(dtLoseList))
{
this.SetSuccMsgPageBydir("报损成功！", "Storage/wfmSaleLoseQuery.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("报损时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
}
protected void btnNewPlan_Click(object sender, System.EventArgs e)
{
DataTable dtDetail = (DataTable)Session["PalnDetail"];
if (dtDetail.Rows.Count == 0)
{
this.SetErrorMsgPageBydirHistory("采购计划产品为空，请先添加产品！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.NewStockPlanAdd(dtDetail))
{
this.SetSuccMsgPageBydir("新采购计划录入成功！", "Storage/wfmStockPlan.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("新采购计划录入时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void ddlProduct_SelectedIndexChanged(object sender, System.EventArgs e)
{
string strProductCode = this.ddlProduct.SelectedValue;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
string strUnit = StoBusi.GetGoodsUnit(strProductCode);
if (strUnit == null || strUnit == "")
{
this.txtUnit.Text = "不存在";
}
else
{
this.txtUnit.Text = strUnit;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btnSendOK_Click(object sender, System.EventArgs e)
{
DataTable dtSendReceiveID = (DataTable)Session["SendReceiveID"];
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
string strOperDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString();
if (StoBusi.UpdateBatchBillOfReceiveSend(dtSendReceiveID, ls1.strOperName, strOperDate))
{
this.SetSuccMsgPageBydir("领料单发货成功！", "Storage/wfmBillOfReceive.aspx");
}
else
{
this.SetErrorMsgPageBydir("领料单发货时发生错误，请重试！");
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
}
}
private void dgbind(string strGoodsName)
{
if (strGoodsName != "货品")
{
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
DataTable dtout = StoBusi.GetGoodsToProvider(strGoodsName);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
dtout.TableName = "货品对应供应商清单";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
}
UcPageView1.MyDataGrid.PageSize = 10;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
}
// private void Checking()
// {
// string strPoID=this.txtPoID.Text.Trim();
// Hashtable htapp=(Hashtable)Application["appconf"];
// string strcons=(string)htapp["cons"];
// StoBusi=new BusiComm.StorageBusi(strcons);
// try
// {
// CMSMStruct.LoginStruct ls1=(CMSMStruct.LoginStruct)Session["Login"];
// if(StoBusi.IsExistPoStockDetailStateUncheck(strPoID))
// {
// this.Popup("该采购订单下还有未审核通过的子订单，请先审核子订单！");
// return;
// }
//
// if(StoBusi.PoSotckMainChecked(strPoID,ls1.strOperName))
// {
// this.SetSuccMsgPageBydir("采购订单完整审核成功！","Storage/wfmPoStock.aspx");
// return;
// }
// else
// {
// this.SetErrorMsgPageBydir("采购订单完整审核时发生错误，请重试！");
// return;
// }
// }
// catch(Exception er)
// {
// this.clog.WriteLine(er);
// this.SetErrorMsgPageBydir("查询错误，请重试！");
// return;
// }
// }
private void Execing()
{
string strPoID = this.txtPoID.Text.Trim();
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (!StoBusi.IsExistPoStockDetailStock(strPoID))
{
this.Popup("该订单下没有任何明细，请添加订单明细！");
return;
}
if (StoBusi.PoSotckMainExecing(strPoID))
{
this.SetSuccMsgPageBydir("采购订单开始执行成功！", "Storage/wfmPoStock.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("采购订单开始执行时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected DataTable Query(string strDept, string strAcctMonth)
{
DataTable dtout = new DataTable();
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
dtout = StoBusi.GetDailySaleChart(strAcctMonth, strDept);
if (dtout == null)
{
this.Popup("查询出错，请重试！");
return(dtout);
}
else
{
return(dtout);
}
}
catch (Exception)
{
this.Popup("查询错误，请重试！");
return(dtout);
}
}
// private void DataGrid1_CancelCommand(object source, DataGridCommandEventArgs e)
// {
// this.DataGrid1.EditItemIndex=-1;
// this.DataGrid1.DataSource=(DataTable)Session["QUERY"];
// this.DataGrid1.DataBind();
// }
//
// private void DataGrid1_EditCommand(object source, DataGridCommandEventArgs e)
// {
// this.DataGrid1.EditItemIndex=e.Item.ItemIndex;
// this.DataGrid1.DataSource=(DataTable)Session["QUERY"];
// this.DataGrid1.DataBind();
// }
//
// private void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
// {
// DataTable dttmp=(DataTable)Session["QUERY"];
// Session.Remove("QUERY");
// double SystemCount=Math.Round(double.Parse(e.Item.Cells[13].Text),2);
// double RealCount=Math.Round(double.Parse(((TextBox)e.Item.Cells[14].Controls[0]).Text.Trim()),2);
//
// dttmp.Rows[e.Item.ItemIndex]["cnnRealCount"]=RealCount.ToString();
// dttmp.Rows[e.Item.ItemIndex]["cnnDifferentCount"]=(SystemCount-RealCount).ToString();
// Session["QUERY"]=dttmp;
// this.DataGrid1.EditItemIndex=-1;
// this.DataGrid1.DataSource=(DataTable)Session["QUERY"];
// this.DataGrid1.DataBind();
// }
private void btnCheckOk_Click(object sender, System.EventArgs e)
{
if (this.Textbox2.Text.Trim() == "")
{
this.SetErrorMsgPageBydirHistory("Å̵ãÈ˲»ÄÜΪ¿Õ£¡");
return;
}
string strDeptID = this.ddlDept.SelectedValue;
string strDate = DateTime.Now.ToShortDateString();
string strWeather = this.Textbox1.Text.Trim();
string strCheckOper = this.Textbox2.Text.Trim();
string strManager = this.Textbox3.Text.Trim();
string strProductType = this.ddlProductType.SelectedValue;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
string strOperDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString();
Hashtable htPara = new Hashtable();
htPara.Add("strDeptID", strDeptID);
htPara.Add("strDate", strDate);
htPara.Add("strWeather", strWeather);
htPara.Add("strCheckOper", strCheckOper);
htPara.Add("strManager", strManager);
htPara.Add("strOperName", ls1.strOperName);
htPara.Add("strOperDate", strOperDate);
htPara.Add("strProductType", strProductType);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.DayCheckFinal(htPara, (DataTable)Session["QUERY"]))
{
this.DataGrid1.Columns[14].Visible = true;
this.DataGrid1.Columns[15].Visible = false;
this.btnCheckOk.Enabled = false;
this.btnEdit.Enabled = false;
this.btnEdit.Text = "±à¼";
this.SetSuccMsgPageBydir("Å̵ã³É¹¦£¡", "Storage/wfmSaleDailyCheck.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("Å̵ãʱ·¢Éú´íÎó£¬ÇëÖØÊÔ£¡");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("²éѯ´íÎó£¬ÇëÖØÊÔ£¡");
return;
}
}
private void btMod_Click(object sender, System.EventArgs e)
{
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
CMSMStruct.PoStockMainStruct psm1 = new CMSMStruct.PoStockMainStruct();
psm1.strPoID = this.txtPoID.Text.Trim();
psm1.strPrvdCode = this.ddlProvider.SelectedValue;
psm1.strAddress = this.txtAddress.Text.Trim();
psm1.strComments = this.txtComments.Text.Trim();
psm1.strPlanCycle = this.txtPlanCycle.Text.Trim();
psm1.strModer = ls1.strOperName;
if (psm1.strPoID == "" || psm1.strPoID.Length != 13)
{
this.Popup("采购订单号不正确！");
return;
}
if (psm1.strPrvdCode == "")
{
this.Popup("供应商不能为空！");
return;
}
if (psm1.strPlanCycle == "")
{
this.Popup("采购周期不能为空！");
return;
}
CMSMStruct.PoStockMainStruct psmold = (CMSMStruct.PoStockMainStruct)Session["psmold"];
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if ((psm1.strPrvdCode != psmold.strPrvdCode || psm1.strPlanCycle != psmold.strPlanCycle) && StoBusi.IsExistPoProviderCycle(psm1.strPrvdCode, psm1.strPlanCycle))
{
this.Popup("该供应商在本采购周期下已经有订单，不能修改！");
return;
}
if (StoBusi.ModPoSotckMainInfo(psm1, psmold))
{
this.SetSuccMsgPageBydir("修改采购订单主表内容成功！", "Storage/wfmPoStock.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("修改采购订单主表内容时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void DataGrid2_DeleteCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
string strReceiveID = e.Item.Cells[0].Text;
DataTable dtSendReceiveID = (DataTable)Session["SendReceiveID"];
for (int s = 0; s < dtSendReceiveID.Rows.Count; s++)
{
if (dtSendReceiveID.Rows[s]["cnnReceiveSerialNo"].ToString() == strReceiveID)
{
dtSendReceiveID.Rows[s].Delete();
break;
}
}
Session.Remove("SendReceiveID");
Session["SendReceiveID"] = dtSendReceiveID;
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataTable dtout = StoBusi.GetBillOfReceiveTempDetail(dtSendReceiveID);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
dtout.TableName = "领料单";
Session.Remove("SendReceiveDetail");
Session["SendReceiveDetail"] = dtout;
if (dtout.Rows.Count > 0)
{
this.btnPrint.Enabled = true;
}
else
{
this.btnPrint.Enabled = false;
}
}
this.DataGrid2.DataSource = (DataTable)Session["SendReceiveID"];
this.DataGrid2.DataBind();
this.DataGrid3.DataSource = (DataTable)Session["SendReceiveDetail"];
this.DataGrid3.DataBind();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
}
protected void btMod_Click(object sender, System.EventArgs e)
{
string strProductCode = this.txtProductCode.Text.Trim();
string strProductName = this.txtProductName.Text.Trim();
string strUnit = this.txtUnit.Text.Trim();
string strBatch = this.ddlBatch.SelectedValue;
string strStartDate = strBeginDate;
string strCount = this.txtCount.Text.Trim();
string strSumFee = this.txtSumFee.Text.Trim();
string strMonth = this.txtMonth.Text.Trim();
if (strCount == "" || !Regex.IsMatch(strCount, @"^[+|-]{0,1}(\d*)\.{0,1}\d{0,}$"))
{
this.SetErrorMsgPageBydirHistory("数量必须是数字！");
return;
}
if (strSumFee == "" || !Regex.IsMatch(strSumFee, @"^[+|-]{0,1}(\d*)\.{0,1}\d{0,}$"))
{
this.SetErrorMsgPageBydirHistory("费用必须是数字！");
return;
}
Hashtable htpara = new Hashtable();
htpara.Add("strProductCode", strProductCode);
htpara.Add("strProductName", strProductName);
htpara.Add("strUnit", strUnit);
htpara.Add("strBatch", strBatch);
htpara.Add("strStartDate", strStartDate);
htpara.Add("strCount", strCount);
htpara.Add("strSumFee", strSumFee);
htpara.Add("strMonth", strMonth);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.UpdateSotckPlanBatch(htpara))
{
this.SetSuccMsgPageBydir("修改成功！", "Storage/wfmStockPlan.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("修改采购计划时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btAdd_Click(object sender, System.EventArgs e)
{
CMSMStruct.ProviderStruct ps1 = new CMSMStruct.ProviderStruct();
ps1.strPrvdCode = this.txtProviderCode.Text.Trim();
ps1.strPrvdName = this.txtProviderName.Text.Trim();
ps1.strPrvdAbbName = this.txtProviderAbbName.Text.Trim();
ps1.strPrvdCredit = this.ddlCredit.SelectedValue;
ps1.strPrvdQualification = this.txtQualification.Text.Trim();
ps1.strActiveFlag = this.ddlActiveFlag.SelectedValue;
ps1.strPrvdLinkName = this.txtLinkName.Text.Trim();
ps1.strPrvdPhone = this.txtLinkPhone.Text.Trim();
ps1.strPrvdFax = this.txtFax.Text.Trim();
ps1.strPrvdEmail = this.txtEmail.Text.Trim();
ps1.strPostCode = this.txtPostCode.Text.Trim();
ps1.strAddress = this.txtAddress.Text.Trim();
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
ps1.strPrvdCreater = ls1.strOperName;
ps1.strOperName = ls1.strOperName;
if (ps1.strPrvdName == "" || ps1.strPrvdName.Length > 20)
{
this.Popup("供应商名称不能为空或长度过长！");
return;
}
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
string strcount = StoBusi.IsExistProvider(ps1.strPrvdName);
if (strcount != "0")
{
this.Popup("该供应商名称已经存在，请使用不同的名称！");
return;
}
if (StoBusi.NewProviderAdd(ps1))
{
this.SetSuccMsgPageBydir("新增供应商档案成功！", "Storage/wfmProviderDetail.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("新增供应商档案时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void DataGrid1_UpdateCommand(object source, DataGridCommandEventArgs e)
{
DataTable dttmp = (DataTable)Session["QUERY"];
Session.Remove("QUERY");
double StatdardSafeLowCount = Math.Round(double.Parse(((TextBox)e.Item.Cells[6].Controls[0]).Text.Trim()), 2);
double StatdardSafeUpCount = Math.Round(double.Parse(((TextBox)e.Item.Cells[7].Controls[0]).Text.Trim()), 2);
string strProductCode = e.Item.Cells[2].Text.Trim();
DataTable dtproduct = (DataTable)Application["AllMaterial"];
DataView dview = dtproduct.DefaultView;
dview.RowFilter = "vcCommCode='" + strProductCode + "'";
double StatdardCount = Math.Round(double.Parse(dview[0]["cnnStatdardCount"].ToString()), 2);
double SafeLowCount = Math.Round(StatdardSafeLowCount * StatdardCount, 2);
double SafeUpCount = Math.Round(StatdardSafeUpCount * StatdardCount, 2);
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
string strDeptID = e.Item.Cells[0].Text.Trim();
Hashtable htPara = new Hashtable();
htPara.Add("strDeptID", strDeptID);
htPara.Add("strProductCode", strProductCode);
htPara.Add("SafeLowCount", SafeLowCount.ToString());
htPara.Add("SafeUpCount", SafeUpCount.ToString());
htPara.Add("strOperName", ls1.strOperName);
htPara.Add("strOperDate", DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString());
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.UpdateProductSafeCount(htPara))
{
dttmp.Rows[e.Item.ItemIndex]["cnnSafeCount"] = StatdardSafeLowCount.ToString();
dttmp.Rows[e.Item.ItemIndex]["cnnSafeUpCount"] = StatdardSafeUpCount.ToString();
Session["QUERY"] = dttmp;
this.DataGrid1.EditItemIndex = -1;
this.DataGrid1.DataSource = (DataTable)Session["QUERY"];
this.DataGrid1.DataBind();
}
else
{
this.SetErrorMsgPageBydir("更新安全库存失败！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btnQuery_Click(object sender, System.EventArgs e)
{
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
string strProviderID = this.ddlProvider.SelectedValue;
if (strProviderID == "")
{
this.SetErrorMsgPageBydir("供应商不能为空！");
return;
}
Hashtable htPara = new Hashtable();
htPara.Add("strProviderID", strProviderID);
htPara.Add("strBeginDate", strBeginDate);
htPara.Add("strEndDate", strEndDate);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataTable dtout = StoBusi.GetBillOfEnterStorage(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
dtout.TableName = "进仓单";
Session["QUERY"] = dtout;
}
UcPageView1.MyDataGrid.PageSize = 20;
DataView dvOut = new DataView(dtout);
this.UcPageView1.MyDataSource = dvOut;
this.UcPageView1.BindGrid();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btnValidEnter_Click(object sender, System.EventArgs e)
{
if (this.lblAssignID.Text.Trim() == "")
{
this.SetErrorMsgPageBydir("生产序号错误，请重新查询！");
return;
}
DataTable dtIn = (DataTable)Session["QUERY"];
if (dtIn == null || dtIn.Rows.Count == 0)
{
this.SetErrorMsgPageBydirHistory("没有任何需要验收的分货单内容，请检查生产序号是否正确！");
return;
}
string strDeptID = this.ddlValidDept.SelectedValue;
string strAssignID = this.lblAssignID.Text.Trim();
string strReceiveOper = this.txtReceiveOper.Text.Trim();
string strValidDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString();
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
Hashtable htPara = new Hashtable();
htPara.Add("strDeptID", strDeptID);
htPara.Add("strAssignID", strAssignID);
htPara.Add("strReceiveOper", strReceiveOper);
htPara.Add("strValidDate", strValidDate);
htPara.Add("strOperID", ls1.strOperName);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.AssignToValidEnterFinal(htPara, dtIn))
{
this.SetSuccMsgPageBydir("订单验收入库成功！", "Storage/wfmBillValidEnter.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("订单验收入库时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btMod_Click(object sender, System.EventArgs e)
{
CMSMStruct.ProviderStruct ps1 = new CMSMStruct.ProviderStruct();
ps1.strPrvdCode = this.txtProviderCode.Text.Trim();
ps1.strPrvdName = this.txtProviderName.Text.Trim();
ps1.strPrvdAbbName = this.txtProviderAbbName.Text.Trim();
ps1.strAddress = this.txtAddress.Text.Trim();
ps1.strPostCode = this.txtPostCode.Text.Trim();
ps1.strPrvdPhone = this.txtLinkPhone.Text.Trim();
ps1.strPrvdFax = this.txtFax.Text.Trim();
ps1.strPrvdEmail = this.txtEmail.Text.Trim();
ps1.strPrvdLinkName = this.txtLinkName.Text.Trim();
ps1.strPrvdCredit = this.ddlCredit.SelectedValue;
ps1.strPrvdQualification = this.txtQualification.Text.Trim();
ps1.strActiveFlag = this.ddlActiveFlag.SelectedValue;
CMSMStruct.LoginStruct ls1 = (CMSMStruct.LoginStruct)Session["Login"];
ps1.strOperName = ls1.strOperName;
if (ps1.strPrvdCode == "" || ps1.strPrvdCode.Length >= 10)
{
this.SetErrorMsgPageBydirHistory("供应商编码不能为空或长度过长！");
return;
}
if (ps1.strPrvdName == "" || ps1.strPrvdName.Length > 20)
{
this.SetErrorMsgPageBydirHistory("供应商名称不能为空或长度过长！");
return;
}
CMSMStruct.ProviderStruct psold = (CMSMStruct.ProviderStruct)Session["psold"];
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.ModProviderInfo(ps1, psold))
{
this.SetSuccMsgPageBydir("修改供应商资料成功！", "Storage/wfmProvider.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("修改供应商资料时发生错误，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void DBBind()
{
string strPoID = this.txtPoID.Text.Trim();
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataSet dsout = StoBusi.GetPoStockDetailSum(strPoID);
if (dsout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
this.TableConvert(dsout.Tables["detail"], "cnvcDeptName", "NewDept");
this.TableConvert(dsout.Tables["detail"], "cnvcRowState", "tbNameCodeToStorage", "vcCommSign='PoState'");
this.TableConvert(dsout.Tables["detail"], "cnvcGroupName", "ComputationGroup");
this.TableConvert(dsout.Tables["detail"], "cnvcStockUnit", "ComputationUnit");
Session["podetailtomod"] = dsout.Tables["detail"];
DataView dvOut1 = new DataView(dsout.Tables["detail"]);
this.Datagrid2.PageSize = 10;
this.Datagrid2.EditItemIndex = -1;
this.Datagrid2.DataSource = dvOut1;
this.Datagrid2.DataBind();
foreach (DataGridItem dgi in this.Datagrid2.Items)
{
if (dgi.Cells[13].Text.Trim() == "完成")
{
((Button)dgi.Cells[19].Controls[0]).Visible = false;
((Button)dgi.Cells[20].Controls[0]).Visible = false;
}
}
this.TableConvert(dsout.Tables["sum"], "计量单位组", "ComputationGroup");
this.TableConvert(dsout.Tables["sum"], "单位", "ComputationUnit");
UcPageView1.MyDataGrid.Caption = "采购订单汇总表";
UcPageView1.MyDataGrid.PageSize = 20;
DataView dvOut2 = new DataView(dsout.Tables["sum"]);
this.UcPageView1.MyDataSource = dvOut2;
this.UcPageView1.BindGrid();
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
private void btnQuery_Click(object sender, System.EventArgs e)
{
string strSendSerial = this.txtSendSerial.Text.Trim();
if (strSendSerial == "")
{
this.SetErrorMsgPageBydirHistory("出货单号不能为空！");
return;
}
DataTable dtSendLog = new DataTable("dtSendLog");
dtSendLog.Columns.Add("cnnSendSerialNo");
DataRow dr = dtSendLog.NewRow();
dr["cnnSendSerialNo"] = strSendSerial;
dtSendLog.Rows.Add(dr);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataTable dtout = StoBusi.GetBillOfReceiveSendPrint(strSendSerial);
if (dtout == null)
{
this.btnPrint.Enabled = false;
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
dtout.TableName = "dtSendDetail";
Session.Remove("BillPrint");
DataSet dsout = new DataSet("领料发货单");
dsout.Tables.Add(dtout.Copy());
dsout.Tables.Add(dtSendLog);
Session["BillPrint"] = dsout;
this.btnPrint.Enabled = true;
}
this.DataGrid1.DataSource = dtout;
this.DataGrid1.DataBind();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btnBatchConfirm_Click(object sender, System.EventArgs e)
{
CheckBox chk1;
string strserial = "";
int confirmcount = 0;
foreach (DataGridItem oitem in this.DataGrid1.Items)
{
chk1 = (CheckBox)oitem.FindControl("chkLose");
if (chk1.Checked)
{
strserial += oitem.Cells[1].Text.Trim() + ",";
confirmcount++;
}
}
if (strserial.Length > 0)
{
strserial = strserial.Substring(0, strserial.Length - 1);
string strConfirmOper = this.txtConfirmOper.Text.Trim();
string strConfirmDate = DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToLongTimeString();
Hashtable htPara = new Hashtable();
htPara.Add("strLoseSerial", strserial);
htPara.Add("strConfirmOper", strConfirmOper);
htPara.Add("strConfirmDate", strConfirmDate);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
if (StoBusi.UpdateLoseConfirm(htPara))
{
this.SetSuccMsgPageBydir("损耗确认成功，本次共确认：" + confirmcount.ToString() + "条损耗记录！", "Storage/wfmDestroyConfirm.aspx");
return;
}
else
{
this.SetErrorMsgPageBydir("损耗确认失败，请重试！");
return;
}
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
}
private void btnQuery_Click(object sender, System.EventArgs e)
{
string strDeptID = this.ddlValidDept.SelectedValue;
string strAssignID = this.txtAssignID.Text.Trim();
if (strAssignID == "")
{
this.SetErrorMsgPageBydirHistory("生产序号不能为空！");
return;
}
Hashtable htPara = new Hashtable();
htPara.Add("strDeptID", strDeptID);
htPara.Add("strAssignID", strAssignID);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataTable dtout = StoBusi.GetAssignToValidEnter(htPara);
if (dtout == null)
{
this.lblAssignID.Text = "";
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
this.TableConvert(dtout, "cnvcShipDeptID", "NewDept");
this.TableConvert(dtout, "cnvcProductType", "tbNameCodeToStorage", "vcCommSign='PRODUCTTYPE'");
this.lblAssignID.Text = strAssignID;
dtout.TableName = "验收信息表";
DataTable dtexcel = dtout.Copy();
Session["QUERY"] = dtout;
}
// this.DataGrid1.PageSize = 30;
this.DataGrid1.DataSource = dtout;
this.DataGrid1.DataBind();
}
catch (Exception er)
{
this.lblAssignID.Text = "";
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btnQuery_Click(object sender, System.EventArgs e)
{
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
string strOutDept = this.ddlOutDept.SelectedValue;
string strInDept = this.ddlInDept.SelectedValue;
Hashtable htPara = new Hashtable();
htPara.Add("strOutDept", strOutDept);
htPara.Add("strInDept", strInDept);
htPara.Add("strBeginDate", strBeginDate);
htPara.Add("strEndDate", strEndDate);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataTable dtout = StoBusi.GetProductMoveLog(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
this.TableConvert(dtout, "cnvcOutDeptID", "NewDept", "vcCommSign='SalesRoom'");
this.TableConvert(dtout, "cnvcInDeptID", "NewDept", "vcCommSign='SalesRoom'");
this.TableConvert(dtout, "cnvcBillState", "tbNameCodeToStorage", "vcCommSign='MOVE_OS'");
dtout.TableName = "调拨单";
}
this.DataGrid1.DataSource = dtout;
this.DataGrid1.DataBind();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
protected void btQuery_Click(object sender, System.EventArgs e)
{
Session.Remove("QUERY");
strBeginDate = Request.Form["txtBegin"].ToString();
strEndDate = Request.Form["txtEnd"].ToString();
if (strBeginDate == "" || strEndDate == "" || strBeginDate == null || strEndDate == null)
{
this.SetErrorMsgPageBydir("时间不能为空，请重新选择时间！");
return;
}
string strDeptID = this.ddlDept.SelectedValue;
string strLoseType = this.ddlLoseType.SelectedValue;
Hashtable htPara = new Hashtable();
htPara.Add("strDeptID", strDeptID);
htPara.Add("strBeginDate", strBeginDate);
htPara.Add("strEndDate", strEndDate);
htPara.Add("strLoseType", strLoseType);
Hashtable htapp = (Hashtable)Application["appconf"];
string strcons = (string)htapp["cons"];
StoBusi = new BusiComm.StorageBusi(strcons);
try
{
DataTable dtout = StoBusi.GetLoseDaySale(htPara);
if (dtout == null)
{
this.SetErrorMsgPageBydir("查询出错，请重试！");
return;
}
else
{
dtout.TableName = "销售报损表";
Session["QUERY"] = dtout;
}
this.DataGrid1.PageSize = 20;
this.DataGrid1.DataSource = dtout;
this.DataGrid1.DataBind();
}
catch (Exception er)
{
this.clog.WriteLine(er);
this.SetErrorMsgPageBydir("查询错误，请重试！");
return;
}
}
