//退回 protected void btnNo_Click(object sender, EventArgs e) { try { #region //驳回最后步骤操作 Mod_ApproveCon mod = new Mod_ApproveCon(); mod.UPSTEPID = "0"; //步骤 mod.FILE_STATUS = "1"; //办结 mod.FILEID = ltlFileID.Text; mod.STEPID = ltlStepID.Text; mod.CON_STATUS = "0";//待办 mod.CON_NO = ltlTaskID.Text; mod.C_EMP_ID = ltlUserID.Text; if (fileinfo.UpdateBackLastSetp(mod)) { ProAdd("驳回"); } #endregion } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
public AjaxResult GetConOK([FromBody] dynamic Json) { #region //参数 string fileID = Json.fileID; //文件ID string content = Json.content; //批语 string nextApprEmpID = Json.nextApprEmpID; //下一步骤审批人ID,注意:多人审批"#"隔开,如(张三ID#李四) #endregion #region //数据操作 string jg = string.Empty; Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID); Mod_TS_USER modUser = GetUserID(); string nextStep = tmb_flowstep.GetNextStep(modFile.C_FLOW_ID, modFile.C_STEP_ID); if (nextStep == "0") { #region //最后步骤操作 Mod_ApproveCon mod = new Mod_ApproveCon(); mod.C_EMP_ID = modUser.C_ID; mod.NEXTSTEPID = nextStep; mod.FILE_STATUS = "1"; mod.FILEID = fileID; mod.CON_STATUS = "2"; mod.CON_NO = modFile.C_TASK_ID; if (tmf_fileinfo.UpdateLastStep(mod)) { jg = ProAdd("批准", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID); } #endregion } else { #region //下一步骤操作 if (tmb_file_next_emp.UpdateNextSetp(fileID, modFile.C_STEP_ID, nextStep, nextApprEmpID, modUser.C_ID)) { jg = ProAdd("批准", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID); } #endregion } AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; result.Result = jg; #endregion return(result); }
/// <summary> /// 线材资源-驳回最后步骤操作 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool UpdateBackLastSetp_ROLL(Mod_ApproveCon mod) { ArrayList strSql = new ArrayList(); //更新文件事务状态为办结 strSql.Add("UPDATE TMF_FILEINFO SET C_STEP_ID='" + mod.UPSTEPID + "',N_STATUS='" + mod.FILE_STATUS + "' where C_ID='" + mod.FILEID + "'"); //删除步骤记录 strSql.Add("delete from TMB_FILE_NEXT_EMP where C_FILE_ID ='" + mod.FILEID + "'"); //更新状态 strSql.Add("update TMC_ROLL_APPLY set C_STATUS='" + mod.CON_STATUS + "',C_APPROVEID='" + mod.C_EMP_ID + "' where C_ID='" + mod.CON_NO + "'"); return(DbHelperOra.ExecuteSqlTran(strSql)); }
protected void btnOk_Click(object sender, EventArgs e) { try { string nextStep = hidNextSetpID.Value;//下一步骤 if (nextStep == "0") { #region //最后步骤操作 Mod_ApproveCon mod = new Mod_ApproveCon(); mod.C_EMP_ID = ltlUserID.Text; //当前审批人 mod.NEXTSTEPID = nextStep; //下一步骤 mod.FILE_STATUS = "1"; // 办结 mod.FILEID = ltlFileID.Text; mod.CON_STATUS = "2"; //审核通过 mod.CON_NO = ltlTaskID.Text; mod.STEPID = ltlStepID.Text; //当前步骤 mod.JYRESULT = txtQUALITY_RESULT.Value; //质量检验结果 mod.PFMONEY = Convert.ToDecimal(txtPFMONEY.Value == "" ? "0" : txtPFMONEY.Value); mod.PFDATE = Convert.ToDateTime(txtPFDATE.Value == "" ? DateTime.Now.ToString() : txtPFDATE.Value); if (fileinfo.UpdateLastStep_QUA(mod)) { ProAdd("批准"); } #endregion } else { #region //下一步骤操作 if (tmb_file_next_emp.UpdateNextSetp(ltlFileID.Text, ltlStepID.Text, nextStep, hidEmpID.Value, ltlUserID.Text)) { ProAdd("批准"); } #endregion } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 最后批准步骤操作 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool UpdateLastStep(Mod_ApproveCon mod) { ArrayList strSql = new ArrayList(); //更新文件事务状态为办结 strSql.Add("UPDATE TMF_FILEINFO SET C_STEP_ID='" + mod.NEXTSTEPID + "',N_STATUS='" + mod.FILE_STATUS + "' where C_ID='" + mod.FILEID + "'"); //更新合同审批记录//更新合同状态 strSql.Add("update TMO_CON set C_APPROVEID='" + mod.C_EMP_ID + "',D_APPROVEDATE=to_date('" + DateTime.Now + "','yyyy-mm-dd hh24:mi:ss'),N_STATUS=" + mod.CON_STATUS + " where C_CON_NO='" + mod.CON_NO + "' "); //更新订单状态 strSql.Add("UPDATE TMO_CON_ORDER SET N_STATUS=" + mod.CON_STATUS + " WHERE C_SFPJ='N' and C_CON_NO='" + mod.CON_NO + "'"); //删除步骤记录 strSql.Add("delete from TMB_FILE_NEXT_EMP where C_FILE_ID='" + mod.FILEID + "'"); return(DbHelperOra.ExecuteSqlTran(strSql)); }
/// <summary> /// 线材资源-最后批准步骤操作 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool UpdateLastStep_ROLL(Mod_ApproveCon mod) { ArrayList strSql = new ArrayList(); //更新文件事务状态为办结 strSql.Add("UPDATE TMF_FILEINFO SET C_STEP_ID='" + mod.NEXTSTEPID + "',N_STATUS='" + mod.FILE_STATUS + "' where C_ID='" + mod.FILEID + "'"); //更新线材资源审批记录//更新线材资源状态 string str = $@"update TMC_ROLL_APPLY set C_APPROVEID='{ mod.C_EMP_ID }',C_STATUS='{mod.CON_STATUS}' where C_ID='{mod.CON_NO }'"; strSql.Add(str); //删除步骤记录 strSql.Add("delete from TMB_FILE_NEXT_EMP where C_FILE_ID='" + mod.FILEID + "'"); return(DbHelperOra.ExecuteSqlTran(strSql)); }
/// <summary> /// 质量异议-最后批准步骤操作 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool UpdateLastStep_QUA(Mod_ApproveCon mod) { ArrayList strSql = new ArrayList(); //更新文件事务状态为办结 strSql.Add("UPDATE TMF_FILEINFO SET C_STEP_ID='" + mod.NEXTSTEPID + "',N_STATUS='" + mod.FILE_STATUS + "' where C_ID='" + mod.FILEID + "'"); //更新质量审批记录//更新质量状态 string str = $@"update TMQ_QUA_MAIN set C_APPROVEID='{ mod.C_EMP_ID }',N_STATUS={mod.CON_STATUS},C_QUALITY_RESULT='{ mod.JYRESULT }',N_AMOUNT={mod.PFMONEY},D_COMPENSATION_DT=TO_DATE('{mod.PFDATE}','yyyy-mm-dd hh24:mi:ss') where C_ID='{mod.CON_NO }'"; strSql.Add(str); //删除步骤记录 strSql.Add("delete from TMB_FILE_NEXT_EMP where C_FILE_ID='" + mod.FILEID + "'"); return(DbHelperOra.ExecuteSqlTran(strSql)); }
//批准 protected void btnOk_Click(object sender, EventArgs e) { try { string nextStep = hidNextSetpID.Value;//下一步骤 if (nextStep == "0") { #region //最后步骤操作 Mod_ApproveCon mod = new Mod_ApproveCon(); mod.C_EMP_ID = ltlUserID.Text; //当前审批人 mod.NEXTSTEPID = nextStep; //下一步骤 mod.FILE_STATUS = "1"; // 办结 mod.FILEID = ltlFileID.Text; mod.CON_STATUS = "4"; //审核通过 mod.CON_NO = ltlTaskID.Text; mod.STEPID = ltlStepID.Text; //当前步骤 if (fileinfo.UpdateLastStep(mod)) { ProAdd("批准"); } #endregion } else { #region //下一步骤操作 if (tmb_file_next_emp.UpdateNextSetp(ltlFileID.Text, ltlStepID.Text, nextStep, hidEmpID.Value, ltlUserID.Text)) { ProAdd("批准"); } #endregion } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
public AjaxResult GetConBack([FromBody] dynamic Json) { #region //参数 string fileID = Json.fileID; //文件ID string content = Json.content; //批语 #endregion #region //数据操作 string jg = string.Empty; Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID); Mod_TS_USER modUser = GetUserID(); #region //驳回最后步骤操作 Mod_ApproveCon mod = new Mod_ApproveCon(); mod.UPSTEPID = "0"; mod.FILE_STATUS = "1"; mod.FILEID = fileID; mod.STEPID = modFile.C_STEP_ID; mod.CON_STATUS = "0"; mod.CON_NO = modFile.C_TASK_ID; mod.C_EMP_ID = modUser.C_ID; if (tmf_fileinfo.UpdateBackLastSetp(mod)) { jg = ProAdd("驳回", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID); } #endregion AjaxResult result = new AjaxResult(); result.Code = DoResult.Success; result.Result = jg; #endregion return(result); }
protected void btnOk_Click(object sender, EventArgs e) { try { string nextStep = hidNextSetpID.Value;//下一步骤 if (nextStep == "0") { #region //先判定是否资源调配成功 bool result = true; //判断当前发运数量已超出可发运量 string stlgrd = string.Empty; #region //初始化DataTable DataTable dt = new DataTable(); dt.Columns.Add("matCode", typeof(string)); //物料编码 dt.Columns.Add("stdCode", typeof(string)); //执行标准 dt.Columns.Add("area", typeof(string)); //区域 dt.Columns.Add("pack", typeof(string)); //包装 dt.Columns.Add("lev", typeof(string)); //等级 dt.Columns.Add("custname", typeof(string)); //客户名称 dt.Columns.Add("conno", typeof(string)); //合同号 dt.Columns.Add("stlgrd", typeof(string)); //钢种 dt.Columns.Add("wgt", typeof(string)); //重量 #endregion List <Mod_TMC_ROLL_DEPLOY_LOG> list = new List <Mod_TMC_ROLL_DEPLOY_LOG>(); for (int i = 0; i < rptList.Items.Count; i++) { HtmlInputCheckBox cbxselect = (HtmlInputCheckBox)rptList.Items[i].FindControl("cbxselect"); Literal ltlbatch = (Literal)rptList.Items[i].FindControl("ltlbatch"); //批次号 Literal ltlmatcode = (Literal)rptList.Items[i].FindControl("ltlmatcode"); //物料编码 Literal ltlstlgrd = (Literal)rptList.Items[i].FindControl("ltlstlgrd"); //钢种 Literal ltlspec = (Literal)rptList.Items[i].FindControl("ltlspec"); //规格 Literal ltlsalearea = (Literal)rptList.Items[i].FindControl("ltlsalearea"); //销售区域 Literal ltlstdcode = (Literal)rptList.Items[i].FindControl("ltlstdcode"); //执行标准 Literal ltlpack = (Literal)rptList.Items[i].FindControl("ltlpack"); //包装要求 Literal ltllev = (Literal)rptList.Items[i].FindControl("ltllev"); //质量等级 Literal ltlN_WGT = (Literal)rptList.Items[i].FindControl("ltlN_WGT"); //重量 Literal ltlneedarea = (Literal)rptList.Items[i].FindControl("ltlneedarea"); //需求区域 Literal ltlneedcust = (Literal)rptList.Items[i].FindControl("ltlneedcust"); //需求客户 Literal ltlneedcon = (Literal)rptList.Items[i].FindControl("ltlneedcon"); //需求合同 Literal ltlzycust = (Literal)rptList.Items[i].FindControl("ltlzycust"); //原资源客户 Literal ltlzycon = (Literal)rptList.Items[i].FindControl("ltlzycon"); //原资源合同 #region //插入值 if (ts_dic.GetAreaFlag(ltlsalearea.Text) == "N") //获取区域是否按客户发运Y/N { DataRow[] dr2 = dt.Select("matCode='" + ltlmatcode.Text + "' and stdCode='" + ltlstdcode.Text + "' and area='" + ltlsalearea.Text + "' and pack='" + ltlpack.Text + "' and lev='" + ltllev.Text + "'"); if (dr2.Length <= 0) { dt.Rows.Add(new object[] { ltlmatcode.Text, ltlstdcode.Text, ltlsalearea.Text, ltlpack.Text, ltllev.Text, "", "", ltlstlgrd.Text, ltlN_WGT.Text }); } else { foreach (var item in dr2) { item["wgt"] = Convert.ToString(Convert.ToDecimal(item["wgt"]) + Convert.ToDecimal(ltlN_WGT.Text)); } } } else { DataRow[] dr2 = dt.Select("matCode='" + ltlmatcode.Text + "' and stdCode='" + ltlstdcode.Text + "' and area='" + ltlsalearea.Text + "' and pack='" + ltlpack.Text + "' and lev='" + ltllev.Text + "' and custname='" + ltlzycust.Text + "' and conno='" + ltlzycon.Text + "'"); if (dr2.Length <= 0) { dt.Rows.Add(new object[] { ltlmatcode.Text, ltlstdcode.Text, ltlsalearea.Text, ltlpack.Text, ltllev.Text, ltlzycust.Text, ltlzycon.Text, ltlstlgrd.Text, ltlN_WGT.Text }); } else { foreach (var item in dr2) { item["wgt"] = Convert.ToString(Convert.ToDecimal(item["wgt"]) + Convert.ToDecimal(ltlN_WGT.Text)); } } } #endregion #region //参数 Mod_TMC_ROLL_DEPLOY_LOG modLog = new Mod_TMC_ROLL_DEPLOY_LOG(); modLog.C_ROLL_PROCID = cbxselect.Value; modLog.C_BATCH_NO = ltlbatch.Text; modLog.C_MAT_CODE = ltlmatcode.Text; modLog.C_STL_GRD = ltlstlgrd.Text; modLog.C_SPEC = ltlspec.Text; modLog.C_OLDAREA = ltlsalearea.Text; //原资源区域 modLog.C_NEWAREA = ltlneedarea.Text; //需求区域 modLog.C_OLDCUST = ltlzycust.Text; //原资源客户 modLog.C_NEWCUST = ltlneedcust.Text; //需求客户信息 modLog.C_OLDCON = ltlzycon.Text; //原资源合同 modLog.C_NEWCON = ltlneedcon.Text; //需求合同 modLog.C_EMPID = ltlUserID.Text; modLog.C_EMPNAME = ltlUserName.Text; modLog.C_STD_CODE = ltlstdcode.Text; modLog.C_JUDGE_LEV = ltllev.Text; modLog.C_PACK = ltlpack.Text; list.Add(modLog); #endregion } #region //在途量/库存量 for (int i = 0; i < dt.Rows.Count; i++) { if (ts_dic.GetAreaFlag(dt.Rows[i]["area"].ToString()) == "N")//获取区域是否按客户发运Y/N { //判断当前发运数量已超出可发运量 if (!tmo_order.IsFy(Convert.ToDecimal(dt.Rows[i]["wgt"].ToString()), dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString())) { stlgrd = dt.Rows[i]["stlgrd"].ToString(); result = false; break; } } else { //判断当前发运数量已超出可发运量 if (!tmo_order.IsFy(Convert.ToDecimal(dt.Rows[i]["wgt"].ToString()), dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString(), dt.Rows[i]["custname"].ToString(), dt.Rows[i]["conno"].ToString())) { stlgrd = dt.Rows[i]["stlgrd"].ToString(); result = false; break; } } } //if (dt.Rows.Count > 0) //{ // for (int i = 0; i < dt.Rows.Count; i++) // { // DataTable dtfyzt = tmo_order.ZTWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString()).Tables[0]; // if (dtfyzt.Rows.Count > 0)//在途量 // { // ztwgt += Convert.ToDecimal(dtfyzt.Compute("sum(N_FYWGT)", "true"));//合计在途量 // } // DataTable dtkc = tmo_order.KCWGT(dt.Rows[i]["matCode"].ToString(), dt.Rows[i]["stdCode"].ToString(), dt.Rows[i]["area"].ToString(), dt.Rows[i]["pack"].ToString(), dt.Rows[i]["lev"].ToString()).Tables[0]; // if (dtkc.Rows.Count > 0)//库存量 // { // if (!string.IsNullOrEmpty(dtkc.Rows[0]["N_WGT"].ToString())) // { // kcwgt += Convert.ToDecimal(dtkc.Rows[0]["N_WGT"]);//合计在途量 // } // } // } //} #endregion if (result) { if (tmc_roll_deploy_log.InsertRoll_Proc3(list)) //执行调配资源 { #region //最后步骤操作 Mod_ApproveCon mod = new Mod_ApproveCon(); mod.C_EMP_ID = ltlUserID.Text; //当前审批人 mod.NEXTSTEPID = nextStep; //下一步骤 mod.FILE_STATUS = "1"; // 办结 mod.FILEID = ltlFileID.Text; mod.CON_STATUS = "2"; //审核通过 mod.CON_NO = ltlTaskID.Text; mod.STEPID = ltlStepID.Text; //当前步骤 if (fileinfo.UpdateLastStep_ROLL(mod)) { ProAdd("批准"); } #endregion } } else { string msg = stlgrd + ",存在发运单占用该资源"; txtContent.Text = msg; WebMsg.MessageBox(stlgrd + ",存在发运单占用该资源,请点击驳回!"); } #endregion } else { #region //下一步骤操作 if (tmb_file_next_emp.UpdateNextSetp(ltlFileID.Text, ltlStepID.Text, nextStep, hidEmpID.Value, ltlUserID.Text)) { ProAdd("批准"); } #endregion } } catch (Exception ex) { WebMsg.MessageBox(ex.Message); } }
/// <summary> /// 线材资源-驳回最后步骤操作 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool UpdateBackLastSetp_ROLL(Mod_ApproveCon mod) { return(dal.UpdateBackLastSetp_ROLL(mod)); }
/// <summary> /// 线材资源-最后批准步骤操作 /// </summary> /// <param name="mod"></param> /// <returns></returns> public bool UpdateLastStep_ROLL(Mod_ApproveCon mod) { return(dal.UpdateLastStep_ROLL(mod)); }