void UCFetchMaterialView_InvalidOrActivationEvent(object sender, EventArgs e)
{
string strmsg = string.Empty;
List <SQLObj> listSql = new List <SQLObj>();
SQLObj obj = new SQLObj();
obj.cmdType = CommandType.Text;
Dictionary <string, ParamObj> dicParam = new Dictionary <string, ParamObj>();
dicParam.Add("fetch_id", new ParamObj("fetch_id", strRescueId, SysDbType.VarChar, 40)); //单据ID
dicParam.Add("update_by", new ParamObj("update_by", HXCPcClient.GlobalStaticObj.UserID, SysDbType.VarChar, 40)); //修改人Id
dicParam.Add("update_name", new ParamObj("update_name", HXCPcClient.GlobalStaticObj.UserName, SysDbType.VarChar, 40)); //修改人姓名
dicParam.Add("update_time", new ParamObj("update_time", Common.LocalDateTimeToUtcLong(HXCPcClient.GlobalStaticObj.CurrentDateTime).ToString(), SysDbType.BigInt)); //修改时间
if (strStatus != Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
strmsg = "作废";
dicParam.Add("info_status", new ParamObj("info_status", DataSources.EnumAuditStatus.Invalid, SysDbType.VarChar, 40));//单据状态
}
else
{
strmsg = "激活";
string OnStatus = "";
DataTable dvt = DBHelper.GetTable("获得前一个状态", "tb_maintain_fetch_material_BackUp", "info_status", "fetch_id='" + strRescueId + "'", "", "order by update_time desc");
if (dvt.Rows.Count > 0)
{
DataRow dr = dvt.Rows[0];
OnStatus = CommonCtrl.IsNullToString(dr["info_status"]);
if (OnStatus == Convert.ToInt32(DataSources.EnumAuditStatus.Invalid).ToString())
{
DataRow dr1 = dvt.Rows[1];
OnStatus = CommonCtrl.IsNullToString(dr1["info_status"]);
}
}
OnStatus = !string.IsNullOrEmpty(OnStatus) ? OnStatus : Convert.ToInt32(DataSources.EnumAuditStatus.DRAFT).ToString();
dicParam.Add("info_status", new ParamObj("info_status", OnStatus, SysDbType.VarChar, 40));//单据状态
}
obj.sqlString = "update tb_maintain_fetch_material set info_status=@info_status,update_by=@update_by,update_name=@update_name,update_time=@update_time where fetch_id=@fetch_id";
obj.Param = dicParam;
listSql.Add(obj);
if (MessageBoxEx.Show("确认要" + strmsg + "吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
if (DBHelper.BatchExeSQLMultiByTrans("更新单据状态为" + strmsg + "", listSql))
{
MessageBoxEx.Show("" + strmsg + "成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
uc.BindPageData();
deleteMenuByTag(this.Tag.ToString(), "UCFetchMaterialView");
}
else
{
MessageBoxEx.Show("" + strmsg + "失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// 保存、提交方法
/// </summary>
/// <param name="strMessage">提示信息</param>
/// <param name="Estatus">单据操作状态</param>
private void SaveOrSubmitMethod(string strMessage, DataSources.EnumAuditStatus Estatus)
{
try
{
#region 必要的判断
if (string.IsNullOrEmpty(txtCarNO.Text.Trim()))
{
MessageBoxEx.Show("车牌号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
return;
}
if (string.IsNullOrEmpty(txtCustomNO.Text.Trim()))
{
MessageBoxEx.Show("客户编码不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
return;
}
if (string.IsNullOrEmpty(txtCustomName.Caption.Trim()))
{
MessageBoxEx.Show("客户名称不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
return;
}
if (!string.IsNullOrEmpty(txtContactPhone.Caption.Trim()))//联系人手机
{
if (!Validator.IsMobile(txtContactPhone.Caption.Trim()))
{
MessageBoxEx.Show("联系人手机号码格式错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
#endregion
if (MessageBoxEx.Show("确认要" + strMessage + "吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
{
return;
}
List <SQLObj> listSql = new List <SQLObj>();
SaveOrderInfo(listSql, Estatus);
SaveMaterialsData(listSql, strId);
if (DBHelper.BatchExeSQLMultiByTrans(opName, listSql))
{
MessageBoxEx.Show("" + strMessage + "成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.None);
uc.BindPageData();
deleteMenuByTag(this.Tag.ToString(), this.uc.Name);
}
else
{
MessageBoxEx.Show("" + strMessage + "失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch (Exception ex)
{
MessageBoxEx.Show("" + strMessage + "失败！" + ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
