/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void btnLoad_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { frmLoadOrder frm = new frmLoadOrder(); frm.CheckFlag2 = 1; frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { //SetGridView1();// 防止一个采购单出现两个合同的数据 for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews2(str); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnLoad_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { frmLoadOrder frm = new frmLoadOrder(); frm.Double = true; string sql = string.Empty; sql += " AND DtsID NOT IN (SELECT LoadID FROM UV1_Sale_ProductionNoticeDts)"; frm.NoLoadCondition = sql; frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 加载销售合同 加载坯布订单 /// </summary> private void WHLoadSaleOrderFormPB() { if (SysConvert.ToString(drpVendorID.EditValue) == "") { this.ShowMessage("请选择单位"); drpVendorID.Focus(); return; } frmLoadOrder frm = new frmLoadOrder(); frm.VendorID = SysConvert.ToString(drpVendorID.EditValue); string sql = string.Empty; frm.NoLoadCondition = sql; frm.ExtraCondition = " and FAid = 1 ";//加载坯布的订单 frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } WHLoadSaleOrderFormSetWHPB(str); } }
private void txtSO_DoubleClick(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { frmLoadOrder frm = new frmLoadOrder(); string sql = string.Empty; sql += " AND FormNo NOT IN(SELECT SO FROM Sale_SaleOrderJS WHERE 1=1 "; sql += ")"; sql += " AND ISNULL(OrderStepID,0)=8"; sql += " AND SubmitFlag=1"; frm.NoLoadCondition = sql; frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public void btnLoad2_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { if (SysConvert.ToString(drpVendorID.EditValue) == "") { this.ShowMessage("请选择往来单位"); drpVendorID.Focus(); return; } if (SysConvert.ToInt32(drpKPType.EditValue) != (int)EnumKPType.预开票) { this.ShowMessage("开票类型请选择预开票"); drpKPType.Focus(); return; } if (SysConvert.ToInt32(drpDZType.EditValue) == (int)EnumDZType.销售) { frmLoadOrder frm = new frmLoadOrder(); frm.CheckFlag2 = 1; frm.VendorID = SysConvert.ToString(drpVendorID.EditValue); frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { //SetGridView1();// 防止一个采购单出现两个合同的数据 for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews2(str); } } if (SysConvert.ToInt32(drpDZType.EditValue) == (int)EnumDZType.采购) { WHLoadItemBuyForm(); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnLoad_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { frmLoadOrder frm = new frmLoadOrder(); if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(702)))//染整加工单支持加载多订单 { frm.Double = true; } string sql = string.Empty; sql += " AND FormNo+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(OrderFormNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_WO_FabricProcessDts"; if (saveNoLoadCheckDayNum != 0) { sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd")); } sql += " and ProcessTypeID =" + (int)EnumProcessType.染纱加工单 + " )";//染整 //sql += ")"; frm.NoLoadCondition = sql; frm.CheckFlag = 1; frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { //SetGridView1();// 防止一个采购单出现两个合同的数据 for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); gridViewRowChanged1(gridView1); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLoadSO_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { frmLoadOrder frm = new frmLoadOrder(); string sql = string.Empty; //sql += " AND FormNo+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(OrderFormNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_WO_FabricProcessDts"; sql += " AND FormNo NOT IN(SELECT ISNULL(DtsSO,'') DtsSO FROM UV1_WO_FabricProcessDts"; if (saveNoLoadCheckDayNum != 0) { sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd")); } sql += " and ProcessTypeID = 2 )";//织造类型 frm.NoLoadCondition = sql; frm.CheckFlag = 1; frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { //SetGridView1();// 防止一个采购单出现两个合同的数据 for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); gridViewRowChanged1(gridView1); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnLoadSO_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { //if (SysConvert.ToString(drpVendorID.EditValue) == "") //{ // this.ShowMessage("请选择客户"); // drpVendorID.Focus(); // return; //} frmLoadOrder frm = new frmLoadOrder(); frm.VendorID = SysConvert.ToString(drpVendorID.EditValue); frm.NoLoadCondition = " and DtsID not in (select isnull(LoadDtsID,0) from WO_TowelProductionPlanDts )"; frm.CheckFlag = 1; frm.ExtraCondition = " and ProductTypeID = 1";//加载毛巾订单 frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { //SetGridView1();// 防止一个采购单出现两个合同的数据 for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnLoad_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { frmLoadOrder frm = new frmLoadOrder(); string sql = string.Empty; //sql += " AND FormNo+ItemCode+ColorNum+ColorName NOT IN(SELECT ISNULL(OrderFormNo+ItemCode+ColorNum+ColorName,'') OrderFormNo FROM UV1_Buy_ItemBuyFormDts"; //if (saveNoLoadCheckDayNum != 0) //{ // sql += " WHERE FormDate BETWEEN " + SysString.ToDBString(DateTime.Now.AddDays(0 - saveNoLoadCheckDayNum).ToString("yyyy-MM-dd")) + " AND " + SysString.ToDBString(DateTime.Now.ToString("yyyy-MM-dd")); //} //sql += ")"; sql += " AND OrderStepID=" + SysString.ToDBString((int)EnumOrderStep.新单); frm.NoLoadCondition = sql; frm.ExtraCondition = " and ProductTypeID = 1 ";//类型是毛巾的订单 frm.CheckFlag = 1; frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { SetGridView1();// 防止一个采购单出现两个合同的数据 for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
private void LoadSaleOrder() { frmLoadOrder frm = new frmLoadOrder(); frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); } }
/// <summary> /// 加载 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnLoad_Click(object sender, EventArgs e) { try { if (HTFormStatus == FormStatus.新增 || HTFormStatus == FormStatus.修改) { if (SysConvert.ToString(drpVendorID.EditValue) == "") { this.ShowMessage("请选择单位"); drpVendorID.Focus(); return; } frmLoadOrder frm = new frmLoadOrder(); frm.VendorID = SysConvert.ToString(drpVendorID.EditValue); frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { //SetGridView1();// 防止一个采购单出现两个合同的数据 for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); } setItemNews(str); } } } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 合同检索 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnHTSearch_Click(object sender, EventArgs e) { try { if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.新增)) { this.ShowMessage("你没有此操作权限"); return; } if (HTDataID == 0) { this.ShowMessage("请定位主记录"); return; } if (HTDataSubmitFlag != (int)YesOrNo.Yes) { this.ShowMessage("单据未提交,不能操作"); return; } if (SysConvert.ToInt32(drpRecPayType.EditValue) == (int)EnumRecPayType.收款)//加载销售合同 { frmLoadOrder frm = new frmLoadOrder(); string sql = string.Empty; frm.NoLoadCondition = sql; frm.VendorID = SysConvert.ToString(drpVendorID.EditValue); frm.ShowDialog(); string str = string.Empty; if (frm.OrderID != null && frm.OrderID.Length != 0) { for (int i = 0; i < frm.OrderID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.OrderID[i]); break;//只加载一个合同号 } setItemNewsSaleHT(str); } } else if (SysConvert.ToInt32(drpRecPayType.EditValue) == (int)EnumRecPayType.付款)//加载采购合同 { frmLoadItemBuy frm = new frmLoadItemBuy(); frm.VendorID = SysConvert.ToString(drpVendorID.EditValue); string sql = string.Empty; frm.NoLoadCondition = sql; frm.ShowDialog(); string str = string.Empty; if (frm.ItemBuyID != null && frm.ItemBuyID.Length != 0) { for (int i = 0; i < frm.ItemBuyID.Length; i++) { if (str != string.Empty) { str += ","; } str += SysConvert.ToString(frm.ItemBuyID[i]); break;//只加载一个合同号 } setItemNewsBuyHT(str); } } } catch (Exception E) { this.ShowMessage(E.Message); } }