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