/// <summary>
/// 设置
/// </summary>
public override void EntitySet()
{
DBForm entity = new DBForm();
entity.ID = HTDataID;
bool findFlag = entity.SelectByID();
HTDataFormNo = entity.FormNo;
txtFormNo.Text = entity.FormNo.ToString();
txtFormDate.DateTime = entity.FormDate;
drpVendorID.EditValue = entity.VendorID;
drpWHID.EditValue = entity.WHID;
drpTargetWHID.EditValue = entity.TargetWHID;
//drpFormListDBID.EditValue = entity.FormListDBID;
txtTotalQty.Text = entity.TotalQty.ToString();
txtRemark.Text = entity.Remark;
txtOutWHFormNo.Text = entity.OutWHFormNo;
txtInWHFormNo.Text = entity.InWHFormNo;
HTDataSubmitFlag = entity.SubmitFlag;
HTDataDelFlag = entity.DelFlag;
if (!findFlag)
{
}
BindGridDts();
//SetIOFormDetail();
//BindPack();
}
/// <summary>
/// 获得实体
/// </summary>
/// <returns></returns>
private DBForm EntityGet()
{
DBForm entity = new DBForm();
entity.ID = HTDataID;
entity.SelectByID();
entity.FormNo = txtFormNo.Text.Trim();
entity.FormDate = txtFormDate.DateTime.Date;
entity.VendorID = SysConvert.ToString(drpVendorID.EditValue);
entity.WHID = SysConvert.ToString(drpWHID.EditValue);
entity.TargetWHID = SysConvert.ToString(drpTargetWHID.EditValue);
entity.FormListDBID = SysConvert.ToInt32(drpFormListDBID.EditValue);
entity.Remark = txtRemark.Text.Trim();
return(entity);
}
private void frmOutWHEdit_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
if (HTDataID > 0)
{
DBForm entity = new DBForm();
entity.ID = HTDataID;
entity.SelectByID();
if (entity.SubmitFlag == 0)
{
if (DialogResult.Yes != ShowConfirmMessage(this.Text + Environment.NewLine + "没有提交单据,是否确认关闭窗体"))
{
e.Cancel = true;
}
}
}
}
catch (Exception E)
{
this.ShowMessage(E.Message);
}
}
/// <summary>
/// 审核
/// </summary>
/// <param name="p_FormID">单据ID</param>
/// <param name="p_Type">0/1/2/3:弃审/审核</param>
public void RSubmit(int p_FormID, int p_Type, IDBTransAccess sqlTrans)
{
try
{
int p_TempType = p_Type;//处理状态
string sql = string.Empty;
DBForm entity = new DBForm(sqlTrans);
entity.ID = p_FormID;
entity.SelectByID();
if (!RSubmitCheckJS(entity.FormDate, sqlTrans))
{
throw new Exception("不允许操作，此单据日期之后已经有结算数据");
}
if (entity.SubmitFlag == p_Type)//如果相同异常
{
throw new Exception("单据状态重复设置，请关闭程序重新打开操作");
}
int p_AuditFlag = 0;
//sql = "SELECT FillDataTypeID,AuditFlag,WHQtyPosID,CheckQtyPer1,CheckQtyFrom,CheckQtyPer2,DZFlag FROM Enum_FormList WHERE ID=" + SysString.ToDBString(entity.SubType);
//DataTable dtFormList = sqlTrans.Fill(sql);
//if (dtFormList.Rows.Count != 0)
//{
//p_AuditFlag = SysConvert.ToInt32(dtFormList.Rows[0]["AuditFlag"]);
if (p_AuditFlag == 0)//不需要审核
{
switch (p_Type)
{
case (int)ConfirmFlag.未提交:
//p_Type=(int)ConfirmFlag.未提交;
break;
case (int)ConfirmFlag.已提交:
p_Type = (int)ConfirmFlag.审核通过;
break;
case (int)ConfirmFlag.审核通过:
// p_Type=(int)ConfirmFlag.审核通过;
break;
case (int)ConfirmFlag.审核拒绝:
p_Type = (int)ConfirmFlag.未提交;
break;
}
}
#region 提交
sql = "UPDATE WH_IOForm SET SubmitFlag=" + SysString.ToDBString(p_Type);
if (p_Type == (int)ConfirmFlag.审核通过 || p_Type == (int)ConfirmFlag.审核拒绝)
{
sql += ",SubmitOPID=" + SysString.ToDBString(ParamConfig.LoginName) + ",SubmitTime=" + SysString.ToDBString(DateTime.Now);
}
sql += " WHERE ID=" + p_FormID.ToString();//更新单据主表审核状态
sqlTrans.ExecuteNonQuery(sql);
//IOFormDtsRule ruledts = new IOFormDtsRule();
//ruledts.RSubmit(p_FormID, TempSubmitType, dtFormList.Rows[0], sqlTrans);//操作子表库存
#endregion
if (entity.SubmitFlag == p_Type)//如果相同异常
{
throw new Exception("单据状态重复设置，请关闭程序重新打开操作");
}
}
catch (BaseException)
{
throw;
}
catch (Exception E)
{
throw new BaseException(E.Message);
}
}