/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); gridView1.GridControl.DataSource = rule.RShowDtsPackBT(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); gridView1.GridControl.Show(); }
/// <summary> /// 撤销提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnSubmitCancel_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; } IOForm entity = new IOForm(); entity.ID = HTDataID; entity.SelectByID(); if (entity.ReadFlag == 1) { this.ShowMessage("该单据已阅不能撤销提交"); return; } IOFormRule rule = new IOFormRule(); rule.RSubmit(HTDataID, (int)ConfirmFlag.未提交); FCommon.AddDBLog(this.Text, FormStatus.撤消提交.ToString(), "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); HTDataConditionStr += "GROUP BY FormNo,"; HTDataConditionStr += "FormDate,ItemCode,DtsOrderFormNo,"; HTDataConditionStr += "WHNM,FormNM,ColorNum,ColorName,MWidth,"; HTDataConditionStr += "MWeight,SinglePrice,ID,ItemName,ItemStd,ItemModel"; DataTable dt = rule.RShowDtsTotal(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("Amount", "SUM(Amount) Amount").Replace("Qty", "SUM(Qty) Qty")); //if (m_DZFlag == 1) //{ // SetDZGridView(dt); //} //if (m_InvoiceFlag == 1) //{ // SetInvoiceGridView(dt); //} for (int i = 0; i < dt.Rows.Count; i++) { if (list.Contains(SysConvert.ToString(dt.Rows[i]["ID"]))) { dt.Rows[i]["SelectFlag"] = 1; } } //SetWHQty(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 撤销提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnSubmitCancel_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 (!CheckLastUpdateDay(txtFormDate.DateTime)) { return; } IOFormRule rule = new IOFormRule(); rule.RSubmit(HTDataID, (int)ConfirmFlag.未提交); FCommon.AddDBLog(this.Text, FormStatus.撤消提交.ToString(), "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 删除 /// </summary> public override void EntityDelete() { IOFormRule rule = new IOFormRule(); IOForm entity = EntityGet(); rule.RDelete(entity); }
/// <summary> /// 撤销提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnSubmitCancel_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 (!HTSubmitCheck(FormStatus.提交)) //{ // return; //} //HTSubmit(HTDataTableName, HTDataID.ToString()); IOFormRule rule = new IOFormRule(); rule.RSubmit(HTDataID, (int)ConfirmFlag.未提交); FCommon.AddDBLog(this.Text, FormStatus.提交.ToString(), "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
private void BindGrid() { if (HTFormStatus != FormStatus.新增 && HTFormStatus != FormStatus.修改) { IOFormRule rule = new IOFormRule(); gridView2.GridControl.DataSource = rule.RShowDts(GetCondition(), ProcessGrid.GetQueryField(gridView2)); gridView2.GridControl.Show(); } }
/// <summary> /// 修改 /// </summary> public override void EntityUpdate() { IOFormRule rule = new IOFormRule(); IOForm entity = EntityGet(); IOFormDts[] entitydts = EntityDtsGet(); entity.SubmitFlag = this.HTSubmitFlagUpdateGet(); rule.RUpdate(entity, entitydts); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); DataTable dt = rule.RShowDtsPack(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SQty", "0.00 SQty")); SetGridView(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 新增 /// </summary> public override int EntityAdd() { IOFormRule rule = new IOFormRule(); IOForm entity = EntityGet(); IOFormDts[] entitydts = EntityDtsGet(); entity.SubmitFlag = this.HTSubmitFlagInsertGet(); rule.RAdd(entity, entitydts); return(entity.ID); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("DtsVendorName", "'' DtsVendorName")); if (SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6425)))//查询带出订单客户 { SetGirdDataSource(dt); } gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 撤销提交及删除单据 /// </summary> /// <param name="entity"></param> /// <param name="sqlTrans"></param> void RAutoDeleteWHForm(FabricWHOutForm entity, IDBTransAccess sqlTrans) { string sql = string.Empty; IOForm entitywh = new IOForm(sqlTrans); entitywh.ID = entity.AutoIOFormID; if (entitywh.SelectByID()) { IOFormRule rulewh = new IOFormRule(); rulewh.RSubmit(entitywh.ID, (int)YesOrNo.No, sqlTrans); rulewh.RDelete(entitywh, sqlTrans); } }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("AQty", "ISNULL(Qty,0)+ISNULL(YQQty,0) AQty").Replace("NOKPQty", "0.00 NOKPQty").Replace("NoKPAmount", "0.00 NoKPAmount")); SetGrid(dt); if (chkYKP.Checked) { SetGrid2(dt); } gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); DataTable dt = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("DZFlagStr", "'' DZFlagStr").Replace("DZRemark", "'' DZRemark").Replace("NoDZQty", "0.00 NoDZQty").Replace("InvoiceFlagStr", "'' InvoiceFlagStr").Replace("InvoiceRemark", "'' InvoiceRemark")); if (m_DZFlag == 1) { SetDZGridView(dt); } if (m_InvoiceFlag == 1) { SetInvoiceGridView(dt); } SetWHQty(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
/// <summary> /// 修改 /// </summary> public override void EntityUpdate() { IOFormRule rule = new IOFormRule(); IOForm entity = EntityGet(); IOFormDts[] entitydts = EntityDtsGet(); decimal TotalQty = 0; decimal TotalAmount = 0; for (int i = 0; i < entitydts.Length; i++) { TotalQty += SysConvert.ToDecimal(entitydts[i].Qty); TotalAmount += SysConvert.ToDecimal(entitydts[i].Amount); } entity.TotalQty = TotalQty; entity.TotalAmount = TotalAmount; entity.SubmitFlag = this.HTSubmitFlagUpdateGet(); rule.RUpdate(entity, entitydts); }
/// <summary> /// 新增 /// </summary> public override int EntityAdd() { IOFormRule rule = new IOFormRule(); IOForm entity = EntityGet(); IOFormDts[] entitydts = EntityDtsGet(); decimal TotalQty = 0; decimal TotalAmount = 0; for (int i = 0; i < entitydts.Length; i++) { TotalQty += SysConvert.ToDecimal(entitydts[i].Qty); TotalAmount += SysConvert.ToDecimal(entitydts[i].Amount); } entity.TotalQty = TotalQty; entity.TotalAmount = TotalAmount; entity.SubmitFlag = this.HTSubmitFlagInsertGet(); rule.RAdd(entity, entitydts); return(entity.ID); }
/// <summary> /// 提交 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> public override void btnSubmit_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 (!CheckCorrect()) { return; } IOFormRule rule = new IOFormRule(); string o_ErrorMsg = string.Empty; if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6402))) //非 成品仓库不使用码单模式 { if (!rule.RCheckCorrectPackData(HTDataID, out o_ErrorMsg)) // 如果校验不通过 { this.ShowMessage(o_ErrorMsg); return; } } rule.RSubmit(HTDataID, (int)ConfirmFlag.已提交); FCommon.AddDBLog(this.Text, FormStatus.提交.ToString(), "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 打印共用条码 /// </summary> /// <returns></returns> bool btnPrintAbount(int p_ReportPrintType) { this.BaseFocusLabel.Focus(); DevComponents.DotNetBar.ComboBoxItem ci = this.ToolBarCItemGet(-1, ToolButtonName.drpPrintFile.ToString()); if (ci.SelectedItem == null) { this.ShowMessage("请选择报表模板"); return(false); } int tempReportID = SysConvert.ToInt32(((DevComponents.Editors.ComboItem)ci.SelectedItem).Tag); if (tempReportID == 1) { this.ShowMessage("请选择报表模板"); return(false); } IOFormRule rule = new IOFormRule(); DataTable dt = rule.RShowDts(HTDataConditionStr, "*"); SetGrid(dt); DataTable dtnew = dt.Clone(); if (gridView1.RowFilter != string.Empty) { DataRow[] rows = dt.Select(gridView1.RowFilter); foreach (DataRow row in rows) { dtnew.ImportRow(row); } } else { dtnew = dt; } FastReportX.ReportRunTable(tempReportID, p_ReportPrintType, dtnew); return(true); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { IOFormRule rule = new IOFormRule(); string sql = "SELECT * FROM ("; sql += "SELECT "; sql += "0 SelectFlag,'' DZFlagStr,'' DZRemark,("; sql += " CASE WHEN Unit='RMB/M' OR Unit='USD/M' THEN (ABS(ISNULL(Qty,0))-ABS(ISNULL(DZQty,0))) "; sql += " WHEN Unit='RMB/KG' OR Unit='USD/KG' THEN (ABS(ISNULL(Weight,0))-ABS(ISNULL(DZQty,0))) "; sql += " WHEN Unit='RMB/Y' OR Unit='USD/Y' THEN (ABS(ISNULL(Yard,0))-ABS(ISNULL(DZQty,0))) "; sql += " ELSE NULL END) NoDZQty,'' InvoiceFlagStr,'' InvoiceRemark"; sql += ",*"; sql += " FROM UV1_WH_IOFormDts) A "; sql += " WHERE 1=1 "; sql += HTDataConditionStr; DataTable dt = SysUtils.Fill(sql); //rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag").Replace("DZFlagStr", "'' DZFlagStr").Replace("DZRemark", "'' DZRemark").Replace("NoDZQty", "0.00 NoDZQty").Replace("InvoiceFlagStr", "'' InvoiceFlagStr").Replace("InvoiceRemark", "'' InvoiceRemark").Replace(",Qty," ,",ISNULL(Qty,0)-ISNULL(YQQty,0) AS Qty,")); if (m_DZFlag == 1) { SetDZGridView(dt); } if (m_InvoiceFlag == 1) { SetInvoiceGridView(dt); } for (int i = 0; i < dt.Rows.Count; i++) { if (list.Contains(SysConvert.ToString(dt.Rows[i]["ID"]))) { dt.Rows[i]["SelectFlag"] = 1; } } SetWHQty(dt); gridView1.GridControl.DataSource = dt; gridView1.GridControl.Show(); }
public void btnLoadYY_Click(object sender, EventArgs e) { if (!FCommon.RightCheck(this.FormID, this.RightFormID, this.FormListAID, this.FormListBID, RightSub.权限0)) { this.ShowMessage("没有此权限,请联系管理员"); return; } int row = gridView1.FocusedRowHandle; ButtonItem btn = (ButtonItem)sender; IOFormRule rule = new IOFormRule(); IOForm entity = new IOForm(); entity.ID = HTDataID; entity.SelectByID(); if (btn.Text == "撤销已阅") { if (entity.ReadFlag == 0) { this.ShowMessage("该出库单还未阅,无需撤销"); return; } entity.ReadFlag = 0; rule.RUpdate(entity); } if (btn.Text == "已阅") { if (entity.ReadFlag == 1) { this.ShowMessage("该出库单已阅,无需再阅"); return; } entity.ReadFlag = 1; rule.RUpdate(entity); } ID = entity.ID; btnQuery_Click(null, null); }
/// <summary> /// 创建单据 /// </summary> /// <param name="entity"></param> /// <param name="sqlTrans"></param> /// <returns></returns> IOForm RAutoCreateWHForm(FabricWHOutForm entity, IDBTransAccess sqlTrans) { IOForm entitywh = new IOForm(sqlTrans); FabricProcess entityjg = new FabricProcess(sqlTrans); entityjg.ID = entity.MainID; entityjg.SelectByID(); #region 赋值出入库单据主实体 /*赋值出入库单据主实体 Begin*/ SaleProcedureRule rulesalePro = new SaleProcedureRule(); int saleProcedureID = rulesalePro.GetSaleProcedureByWOTypeID(entityjg.ProcessTypeID);//加工业务单据类型ID string sql = string.Empty; sql = "SELECT JGFormListID FROM Enum_SaleProcedure WHERE ID=" + saleProcedureID; DataTable dtSalePro = sqlTrans.Fill(sql);//配置表 if (dtSalePro.Rows.Count != 0) { entitywh.SubType = SysConvert.ToInt32(dtSalePro.Rows[0]["JGFormListID"]); FormListRule ruleformlist = new FormListRule(); entitywh.HeadType = ruleformlist.GetFormListIDBySubTypeID(entitywh.SubType, sqlTrans); } else { throw new Exception("业务单据类型配置异常"); } entitywh.WHID = entity.WHID; entitywh.WHOP = ParamConfig.LoginName; entitywh.VendorID = entityjg.DyeFactorty;//加工厂 entitywh.FormDate = DateTime.Now.Date; entitywh.WHType = entity.WHID; entitywh.SpecialNo = entity.FormNo;//源单据号;自动扣料的单据号 FormNoControlRule formconrule = new FormNoControlRule(); entitywh.FormNo = formconrule.RGetWHFormNo(entitywh.SubType, "", sqlTrans); /*赋值出入库单据主实体End */ #endregion #region 赋值出入库单据明细实体 /*赋值出入库单据明细实体 Begin*/ sql = "SELECT * FROM WO_FabricWHOutFormDts WHERE MainID=" + entity.ID; DataTable dtDts = sqlTrans.Fill(sql); IOFormDts[] entityDtswh = new IOFormDts[dtDts.Rows.Count]; if (dtDts.Rows.Count == 0) { throw new Exception("没有数据明细,不应进行数据保存"); } for (int i = 0; i < dtDts.Rows.Count; i++) { entityDtswh[i] = new IOFormDts(); entityDtswh[i].Seq = i + 1; entityDtswh[i].WHID = dtDts.Rows[i]["WHID"].ToString(); entityDtswh[i].SectionID = dtDts.Rows[i]["SectionID"].ToString(); entityDtswh[i].SBitID = dtDts.Rows[i]["SBitID"].ToString(); entityDtswh[i].ItemCode = dtDts.Rows[i]["ItemCode"].ToString(); entityDtswh[i].ItemName = dtDts.Rows[i]["ItemName"].ToString(); entityDtswh[i].ItemStd = dtDts.Rows[i]["ItemStd"].ToString(); entityDtswh[i].ItemModel = dtDts.Rows[i]["ItemModel"].ToString(); entityDtswh[i].Batch = dtDts.Rows[i]["Batch"].ToString(); entityDtswh[i].VendorBatch = dtDts.Rows[i]["VendorBatch"].ToString(); entityDtswh[i].ColorNum = dtDts.Rows[i]["ColorNum"].ToString(); entityDtswh[i].ColorName = dtDts.Rows[i]["ColorName"].ToString(); entityDtswh[i].JarNum = dtDts.Rows[i]["JarNum"].ToString(); entityDtswh[i].PieceQty = SysConvert.ToInt32(dtDts.Rows[i]["PieceQty"]); entityDtswh[i].Remark = dtDts.Rows[i]["Remark"].ToString(); entityDtswh[i].Qty = SysConvert.ToDecimal(dtDts.Rows[i]["Qty"]); entityDtswh[i].Unit = dtDts.Rows[i]["Unit"].ToString(); entityDtswh[i].Weight = SysConvert.ToDecimal(dtDts.Rows[i]["Weight"]); entityDtswh[i].SinglePrice = SysConvert.ToDecimal(dtDts.Rows[i]["SinglePrice"]); entityDtswh[i].DYPrice = SysConvert.ToDecimal(dtDts.Rows[i]["DYPrice"]); entityDtswh[i].Amount = SysConvert.ToDecimal(dtDts.Rows[i]["Amount"]); entityDtswh[i].GoodsCode = dtDts.Rows[i]["GoodsCode"].ToString(); entityDtswh[i].GoodsLevel = dtDts.Rows[i]["GoodsLevel"].ToString(); entityDtswh[i].VColorNum = dtDts.Rows[i]["VColorNum"].ToString(); entityDtswh[i].VColorName = dtDts.Rows[i]["VColorName"].ToString(); entityDtswh[i].VItemCode = dtDts.Rows[i]["VItemCode"].ToString(); entityDtswh[i].MWeight = dtDts.Rows[i]["MWeight"].ToString(); entityDtswh[i].MWidth = dtDts.Rows[i]["MWidth"].ToString(); entityDtswh[i].WeightUnit = dtDts.Rows[i]["WeightUnit"].ToString(); entityDtswh[i].PackDts = dtDts.Rows[i]["PackDts"].ToString(); //entityDtswh[i].DtsSO = dtDts.Rows[i]["DtsSO"].ToString(); //entityDtswh[i].DtsOrderFormNo = dtDts.Rows[i]["DtsOrderFormNo"].ToString(); entityDtswh[i].DtsInVendorID = dtDts.Rows[i]["DtsInVendorID"].ToString(); entityDtswh[i].InSO = dtDts.Rows[i]["InSO"].ToString(); entityDtswh[i].InOrderFormNo = dtDts.Rows[i]["InOrderFormNo"].ToString(); entityDtswh[i].InSaleOPID = dtDts.Rows[i]["InSaleOPID"].ToString(); entityDtswh[i].MLType = SysConvert.ToInt32(dtDts.Rows[i]["MLType"]); //entityDtswh[i].LoadDtsID = SysConvert.ToInt32(dtDts.Rows[i]["LoadDtsID"]); entityDtswh[i].LoadDtsID = SysConvert.ToInt32(dtDts.Rows[i]["ID"]); //明细表ID entityDtswh[i].DtsSO = entityjg.FormNo; //关联单据 entityDtswh[i].DtsOrderFormNo = dtDts.Rows[i]["DtsSO"].ToString(); //订单号 } decimal TotalQty = 0; decimal TotalAmount = 0; for (int i = 0; i < entityDtswh.Length; i++) { TotalQty += SysConvert.ToDecimal(entityDtswh[i].Qty); TotalAmount += SysConvert.ToDecimal(entityDtswh[i].Amount); } entitywh.TotalQty = TotalQty; entitywh.TotalAmount = TotalAmount; /*赋值出入库单据明细实体 End*/ #endregion IOFormRule rulewh = new IOFormRule(); rulewh.RAdd(entitywh, entityDtswh, sqlTrans);//保存主从数据 #region 保存孙表数据 /*赋值出入库单据码单明细数据 Begin*/ sql = "SELECT TOP 1 ID FROM WO_FabricWHOutFormDtsPack WHERE MainID=" + SysString.ToDBString(entity.ID); DataTable dtPackCheck = sqlTrans.Fill(sql); if (dtPackCheck.Rows.Count != 0)//如果有码单明细表示需要保存码单明细值 { sql = "SELECT LoadDtsID,ID,Seq FROM WH_IOFormDts WHERE MainID=" + SysString.ToDBString(entitywh.ID); dtPackCheck = sqlTrans.Fill(sql); for (int i = 0; i < dtPackCheck.Rows.Count; i++) { int LoadDtsID = SysConvert.ToInt32(dtPackCheck.Rows[i]["LoadDtsID"]); int Seq = SysConvert.ToInt32(dtPackCheck.Rows[i]["Seq"]); int ID = SysConvert.ToInt32(dtPackCheck.Rows[i]["ID"]); int SubSeq = 1; if (LoadDtsID > 0) { sql = "SELECT * FROM WO_FabricWHOutFormDtsPack WHERE DID=" + SysString.ToDBString(LoadDtsID); DataTable dtfh = sqlTrans.Fill(sql); for (int j = 0; j < dtfh.Rows.Count; j++) { IOFormDtsPackRule rulePack = new IOFormDtsPackRule(); IOFormDtsPack entityPack = new IOFormDtsPack(); entityPack.MainID = entitywh.ID; entityPack.Seq = Seq; entityPack.DID = ID; entityPack.SubSeq = SubSeq; entityPack.BoxNo = SysConvert.ToString(dtfh.Rows[j]["BoxNo"]); entityPack.Remark = SysConvert.ToString(dtfh.Rows[j]["BoxNo"]); entityPack.Qty = SysConvert.ToDecimal(dtfh.Rows[j]["Qty"]); SubSeq++; rulePack.RAdd(entityPack, sqlTrans); } } } } /*赋值出入库单据码单明细数据 End*/ #endregion rulewh.RSubmit(entitywh.ID, (int)YesOrNo.Yes, sqlTrans);//提交 return(entitywh); }
void work_DoWork(object sender, DoWorkEventArgs e) { IOFormRule rule = new IOFormRule(); GridView1Table = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); }