/// <summary> /// 删除 /// </summary> public override void EntityDelete() { DBFormRule rule = new DBFormRule(); DBForm entity = EntityGet(); rule.RDelete(entity); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { DBFormRule rule = new DBFormRule(); gridView1.GridControl.DataSource = rule.RShowDts(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1)); gridView1.GridControl.Show(); }
/// <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; //} //sc 出库提交前校验细码与库存细码是否对上 if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6402)))//非 成品仓库不使用码单模式 { for (int i = 0; i < ucFabView1.UCDataSource.Rows.Count; i++) { string sql = "SELECT Qty FROM WH_PackBox WHERE BoxNo = " + SysString.ToDBString(SysConvert.ToString((ucFabView1.UCDataSource.Rows[i]["BoxNo"]))); DataTable dt = SysUtils.Fill(sql); if (dt.Rows.Count != 0) { if (SysConvert.ToDecimal(ucFabView1.UCDataSource.Rows[i]["Qty"]) != SysConvert.ToDecimal(dt.Rows[0]["Qty"])) { this.ShowMessage("此细码:" + SysConvert.ToString(ucFabView1.UCDataSource.Rows[i]["BoxNo"]) + " 已开过匹,与库存细码对应不上,请检查!"); return; } } } } DBFormRule rule = new DBFormRule(); if (!SysConvert.ToBoolean(ProductParamSet.GetIntValueByID(6402)))//非 成品仓库不使用码单模式 { string o_ErrorMsg = string.Empty; 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> public override void EntityUpdate() { DBFormRule rule = new DBFormRule(); DBForm entity = EntityGet(); DBFormDts[] 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.SubmitFlag = this.HTSubmitFlagUpdateGet(); rule.RUpdate(entity, entitydts); }
/// <summary> /// 新增 /// </summary> public override int EntityAdd() { DBFormRule rule = new DBFormRule(); DBForm entity = EntityGet(); DBFormDts[] 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.SubmitFlag = this.HTSubmitFlagInsertGet(); rule.RAdd(entity, entitydts); return(entity.ID); }
/// <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; } //if (!CheckCorrect()) //{ // return; //} DBFormRule rule = new DBFormRule(); rule.RSubmit(HTDataID, (int)ConfirmFlag.未提交); FCommon.AddDBLog(this.Text, FormStatus.撤消提交.ToString(), "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); } catch (Exception E) { this.ShowMessage(E.Message); } }