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