/// <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);
}
}
