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