/// <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; } InvoiceOperationRule rule = new InvoiceOperationRule(); InvoiceOperation entity = new InvoiceOperation(); entity.ID = HTDataID; entity.SelectByID(); if (entity.PreHXQty != 0) { this.ShowMessage("已有核销数据,不允许提交"); return; } rule.RSubmit(HTDataID, 0); FCommon.AddDBLog(this.Text, FormStatus.撤消提交.ToString(), "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 删除 /// </summary> public override void EntityDelete() { InvoiceOperationRule rule = new InvoiceOperationRule(); InvoiceOperation entity = EntityGet(); rule.RDelete(entity); }
/// <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; } InvoiceOperationRule rule = new InvoiceOperationRule(); rule.RSubmit(HTDataID, 1); 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() { InvoiceOperationRule rule = new InvoiceOperationRule(); gridView1.GridControl.DataSource = rule.RShow(HTDataConditionStr, ProcessGrid.GetQueryField(gridView1).Replace("SelectFlag", "0 SelectFlag")); gridView1.GridControl.Show(); }
/// <summary> /// 新增 /// </summary> public override int EntityAdd() { InvoiceOperationRule rule = new InvoiceOperationRule(); InvoiceOperation entity = EntityGet(); InvoiceOperationDts[] entitydts = EntityDtsGet(); InvoiceYOperationDts[] entityDts2 = EntityDtsGet2(); if (!ismx) { if (entity.KPType == (int)EnumKPType.预开票) { ProcEntitySaveData2(entity, entityDts2); } else { ProcEntitySaveData(entity, entitydts); } if (SysConvert.ToInt32(drpKPType.EditValue) == (int)EnumKPType.期初开票) { entity.TotalAmount = SysConvert.ToDecimal(txtTotalAmount.Text.Trim()); entity.TotalQty = SysConvert.ToDecimal(txtTotalQty.Text.Trim()); entity.TotalTaxAmount = SysConvert.ToDecimal(entity.TotalAmount - entity.TotalAmount / 1.17m, 5); } } else { entity.TotalAmount = SysConvert.ToDecimal(txtTotalAmount.Text.Trim()); entity.TotalQty = SysConvert.ToDecimal(txtTotalQty.Text.Trim()); } entity.SubmitFlag = this.HTSubmitFlagInsertGet(); entity.TotalTaxAmount = SysConvert.ToDecimal(entity.TotalAmount - entity.TotalAmount / 1.17m, 5); rule.RAdd(entity, entitydts, entityDts2); return(entity.ID); }
/// <summary> /// 绑定Grid /// </summary> public override void BindGrid() { InvoiceOperationRule rule = new InvoiceOperationRule(); DataTable dt = rule.RShow(HTDataConditionStr + " AND KPType=" + SysString.ToDBString((int)EnumKPType.正常开票) + " ORDER BY ID,Seq", ProcessGrid.GetQueryField(gridView1).Replace("NoHXAmount", "0.00 NoHXAmount")); string sql = "SELECT * FROM UV1_Finance_InvoiceYOperationDts WHERE 1=1"; sql += HTDataConditionStr + " AND KPType=" + SysString.ToDBString((int)EnumKPType.预开票); sql += " ORDER BY ID,Seq"; DataTable Ydt = SysUtils.Fill(sql); for (int i = 0; i < Ydt.Rows.Count; i++) { DataRow dr = dt.NewRow(); dr["ID"] = SysConvert.ToInt32(Ydt.Rows[i]["ID"]); dr["Seq"] = SysConvert.ToInt32(Ydt.Rows[i]["Seq"]); dr["SubmitFlag"] = SysConvert.ToInt32(Ydt.Rows[i]["SubmitFlag"]); dr["MakeOPID"] = SysConvert.ToString(Ydt.Rows[i]["MakeOPID"]); dr["MakeOPID"] = SysConvert.ToString(Ydt.Rows[i]["MakeOPID"]); dr["FormNo"] = SysConvert.ToString(Ydt.Rows[i]["FormNo"]); dr["KPName"] = SysConvert.ToString(Ydt.Rows[i]["KPName"]); dr["VendorName"] = SysConvert.ToString(Ydt.Rows[i]["VendorAttn"]); dr["VendorID"] = SysConvert.ToString(Ydt.Rows[i]["VendorID"]); dr["InvoiceNO"] = SysConvert.ToString(Ydt.Rows[i]["InvoiceNO"]); dr["ItemCode"] = SysConvert.ToString(Ydt.Rows[i]["ItemCode"]); dr["GoodsCode"] = SysConvert.ToString(Ydt.Rows[i]["GoodsCode"]); dr["ColorNum"] = SysConvert.ToString(Ydt.Rows[i]["ColorNum"]); dr["ColorName"] = SysConvert.ToString(Ydt.Rows[i]["ColorName"]); dr["DInvoiceQty"] = SysConvert.ToDecimal(Ydt.Rows[i]["Qty"]); dr["DInvoiceSinglePrice"] = SysConvert.ToDecimal(Ydt.Rows[i]["SinglePrice"]); dr["DInvoiceAmount"] = SysConvert.ToDecimal(Ydt.Rows[i]["Amount"]); dr["DInvoiceTaxAmount"] = SysConvert.ToDecimal(Ydt.Rows[i]["DInvoiceTaxAmount"]); dr["TotalAmount"] = SysConvert.ToDecimal(Ydt.Rows[i]["TotalAmount"]); dr["PayAmount"] = SysConvert.ToDecimal(Ydt.Rows[i]["PayAmount"]); dt.Rows.Add(dr); } foreach (DataRow dr in dt.Rows) { dr["NoHXAmount"] = SysConvert.ToDecimal(dr["TotalAmount"]) - SysConvert.ToDecimal(dr["PayAmount"]); if (SysConvert.ToInt32(dr["Seq"]) > 1) { dr["NoHXAmount"] = DBNull.Value; dr["TotalAmount"] = DBNull.Value; dr["PayAmount"] = DBNull.Value; } } DataView dv = dt.DefaultView; dv.Sort = "FormNo DESC"; DataTable dto = dv.ToTable(); gridView1.GridControl.DataSource = dto; gridView1.GridControl.Show(); }
/// <summary> /// 绑定数据明细 /// </summary> public void BindGridInvoiceDts() { InvoiceOperationRule rule = new InvoiceOperationRule(); DataTable dt = rule.RShowPay(GetCondtioInvoiceDt() + " ORDER BY FormDate", ProcessGrid.GetQueryField(gridView2).Replace("NOHXAmount", "0.00 NOHXAmount")); foreach (DataRow dr in dt.Rows) { dr["NOHXAmount"] = SysConvert.ToDecimal(dr["TotalAmount"]) - SysConvert.ToDecimal(dr["PayAmount"]); } DataTable dtDts = dt; gridView2.GridControl.DataSource = dtDts; gridView2.GridControl.Show(); }
/// <summary> /// 核销操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPreHXExcute_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 (saveIOFormDtsID == 0) { this.ShowMessage("请选择对账记录"); return; } if (SysConvert.ToDecimal(txtPreHXQty.Text.Trim()) == 0) { this.ShowMessage("请输入核销数量"); txtPreHXQty.Focus(); return; } InvoiceOperationRule rule = new InvoiceOperationRule(); InvoiceOperation entity = EntityGet(); InvoiceOperationDts entitydts = EntityDtsGetOne(); rule.RHX(entity, entitydts); FCommon.AddDBLog(this.Text, "核销", "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); this.BindGrid(); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 修改 /// </summary> public override void EntityUpdate() { InvoiceOperationRule rule = new InvoiceOperationRule(); InvoiceOperation entity = EntityGet(); InvoiceYOperationDts[] entityDts = EntityDtsGet(); decimal totalqty = 0; decimal totalamount = 0; for (int i = 0; i < entityDts.Length; i++) { totalqty += entityDts[i].Qty; totalamount += entityDts[i].Amount; } entity.TotalQty = totalqty; entity.TotalAmount = totalamount; entity.TotalTaxAmount = SysConvert.ToDecimal(entity.TotalAmount - entity.TotalAmount / 1.17m, 5); rule.RUpdate2(entity, entityDts); }
/// <summary> /// 撤销核销操作 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPreHXCancelExcute_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; } int dtsID = SysConvert.ToInt32(gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "DtsID")); if (dtsID == 0) { this.ShowMessage("请选择核销记录"); return; } if (DialogResult.Yes != ShowConfirmMessage("确认撤销核销本条记录?")) { return; } InvoiceOperationRule rule = new InvoiceOperationRule(); InvoiceOperation entity = EntityGet(); rule.RHXCancel(entity, dtsID); FCommon.AddDBLog(this.Text, "撤销核销", "ID:" + HTDataID, ""); this.SetPosStatus(HTDataID); this.BindGrid(); } catch (Exception E) { this.ShowMessage(E.Message); } }