public AjaxResult GetQualBack([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();
//删除当前步骤与下一步骤
if (tmb_file_next_emp.BackSetp(fileID, "0", "0", "0"))
{
//更新当前审批人/时间/状态
if (tmq_quality_main.UpdateCheckEmp(modFile.C_TASK_ID, modUser.C_ID, "0", DateTime.Now))
{
jg = ProAdd("驳回", content, modUser.C_NAME, modUser.C_ID, modFile.C_STEP_ID, fileID);
}
}
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = jg;
#endregion
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (BaseUser != null)
{
ltlUserID.Text = BaseUser.Id;
ltlUserName.Text = BaseUser.Name;
if (!string.IsNullOrEmpty(Request.QueryString["ID"]) && !string.IsNullOrEmpty(Request.QueryString["task"]) && !string.IsNullOrEmpty(Request.QueryString["flow"]) && !string.IsNullOrEmpty(Request.QueryString["step"]) && !string.IsNullOrEmpty(Request.QueryString["flag"]))
{
ltlFileID.Text = Request.QueryString["ID"];
ltlTaskID.Text = Request.QueryString["task"];
ltlFlowID.Text = Request.QueryString["flow"];
ltlStepID.Text = Request.QueryString["step"];
ltlFlag.Text = Request.QueryString["flag"];
div_check.Visible = Request.QueryString["flag"] == "0" ? true : false;
Mod_TMF_FILEINFO mod = fileinfo.GetModel(ltlFileID.Text);
if (mod != null)
{
ltlContent.Text = mod.C_CONTENT;
}
GetFlowProc(); //加载审批记录
GetQuality(); //加载质量异议
GetFile(); //加载质量附件
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (BaseUser != null)
{
ltlUserID.Text = BaseUser.Id;
ltlUserName.Text = BaseUser.Name;
if (!string.IsNullOrEmpty(Request.QueryString["ID"]) && !string.IsNullOrEmpty(Request.QueryString["task"]) && !string.IsNullOrEmpty(Request.QueryString["flow"]) && !string.IsNullOrEmpty(Request.QueryString["step"]) && !string.IsNullOrEmpty(Request.QueryString["flag"]))
{
ltlFileID.Text = Request.QueryString["ID"];
ltlTaskID.Text = Request.QueryString["task"];
ltlFlowID.Text = Request.QueryString["flow"];
ltlStepID.Text = Request.QueryString["step"];
ltlFlag.Text = Request.QueryString["flag"];
div_check.Visible = Request.QueryString["flag"] == "0" ? true : false;
orderdata = tmo_order.GetOrderList(ltlTaskID.Text).Tables[0]; //订单池订单列表
plandata = tmp_plan.GetPlanList(ltlTaskID.Text).Tables[0]; //日计划
GetConInfo(); //加载合同信息
GetFlowProc(); //加载审批记录
Mod_TMF_FILEINFO mod = fileinfo.GetModel(ltlFileID.Text);
if (mod != null)
{
ltlContent.Text = mod.C_CONTENT;
}
}
}
}
}
/// <summary>
/// 质量异议审批
/// </summary>
/// <param name="modFile">文件</param>
/// <param name="modNextEmp">步骤操作人</param>
/// <returns></returns>
public bool ApproveQua(Mod_TMF_FILEINFO modFile, Mod_TMB_FILE_NEXT_EMP modNextEmp)
{
ArrayList arraySql = new ArrayList();
#region //文件
string ID = Guid.NewGuid().ToString("N");
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMF_FILEINFO(");
strSql.Append("C_ID,");
strSql.Append("C_FLOW_ID,");
strSql.Append("C_EMP_ID,");
strSql.Append("C_TITLE,");
strSql.Append("C_CONTENT,");
strSql.Append("N_TYPE,");
strSql.Append("C_TASK_ID,");
strSql.Append("C_STEP_ID");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'" + ID + "',");
strSql.Append("'" + modFile.C_FLOW_ID + "',");
strSql.Append("'" + modFile.C_EMP_ID + "',");
strSql.Append("'" + modFile.C_TITLE + "',");
strSql.Append("'" + modFile.C_CONTENT + "',");
strSql.Append("" + modFile.N_TYPE + ",");
strSql.Append("'" + modFile.C_TASK_ID + "',");
strSql.Append("'" + modFile.C_STEP_ID + "'");
strSql.Append(")");
arraySql.Add(strSql.ToString());
#endregion
#region //更新质量异议反馈
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update TMQ_QUA_MAIN set ");
strSql2.Append("C_FLOWID='" + modFile.C_FLOW_ID + "', ");
strSql2.Append("N_STATUS=1, "); //1审批中
strSql2.Append("C_CUST_MAKING='" + modFile.C_EMP_ID + "',"); //制单人
strSql2.Append("D_CUST_MAKING_DT=to_date('" + DateTime.Now + "','yyyy-mm-dd hh24:mi:ss'),"); //制单时间
strSql2.Append("C_APPROVEID='" + modNextEmp.C_NEXT_EMP_ID + "' "); //审批人
strSql2.Append(" where C_ID='" + modFile.C_TASK_ID + "' ");
arraySql.Add(strSql2.ToString());
#endregion
#region//步骤操作人
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("insert into TMB_FILE_NEXT_EMP(");
strSql3.Append("C_FILE_ID,");
strSql3.Append("C_NEXT_EMP_ID,");
strSql3.Append("C_STEP_ID");
strSql3.Append(")");
strSql3.Append(" values (");
strSql3.Append("'" + ID + "',");
strSql3.Append("'" + modNextEmp.C_NEXT_EMP_ID + "',");
strSql3.Append("'" + modNextEmp.C_STEP_ID + "'");
strSql3.Append(")");
arraySql.Add(strSql3.ToString());
#endregion
return(DbHelperOra.ExecuteSqlTran(arraySql));
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMF_FILEINFO DataRowToModel(DataRow row)
{
Mod_TMF_FILEINFO model = new Mod_TMF_FILEINFO();
if (row != null)
{
if (row["C_ID"] != null)
{
model.C_ID = row["C_ID"].ToString();
}
if (row["C_FLOW_ID"] != null)
{
model.C_FLOW_ID = row["C_FLOW_ID"].ToString();
}
if (row["C_EMP_ID"] != null)
{
model.C_EMP_ID = row["C_EMP_ID"].ToString();
}
if (row["C_TITLE"] != null)
{
model.C_TITLE = row["C_TITLE"].ToString();
}
if (row["C_CONTENT"] != null)
{
model.C_CONTENT = row["C_CONTENT"].ToString();
}
if (row["C_FILEURL"] != null)
{
model.C_FILEURL = row["C_FILEURL"].ToString();
}
if (row["N_STATUS"] != null && row["N_STATUS"].ToString() != "")
{
model.N_STATUS = decimal.Parse(row["N_STATUS"].ToString());
}
if (row["D_SB_DT"] != null && row["D_SB_DT"].ToString() != "")
{
model.D_SB_DT = DateTime.Parse(row["D_SB_DT"].ToString());
}
if (row["C_REMARK"] != null)
{
model.C_REMARK = row["C_REMARK"].ToString();
}
if (row["N_TYPE"] != null && row["N_TYPE"].ToString() != "")
{
model.N_TYPE = decimal.Parse(row["N_TYPE"].ToString());
}
if (row["C_TASK_ID"] != null)
{
model.C_TASK_ID = row["C_TASK_ID"].ToString();
}
if (row["C_STEP_ID"] != null)
{
model.C_STEP_ID = row["C_STEP_ID"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMF_FILEINFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update TMF_FILEINFO set ");
strSql.Append("C_FLOW_ID=:C_FLOW_ID,");
strSql.Append("C_EMP_ID=:C_EMP_ID,");
strSql.Append("C_TITLE=:C_TITLE,");
strSql.Append("C_CONTENT=:C_CONTENT,");
strSql.Append("C_FILEURL=:C_FILEURL,");
strSql.Append("N_STATUS=:N_STATUS,");
strSql.Append("D_SB_DT=:D_SB_DT,");
strSql.Append("C_REMARK=:C_REMARK,");
strSql.Append("N_TYPE=:N_TYPE,");
strSql.Append("C_TASK_ID=:C_TASK_ID,");
strSql.Append("C_STEP_ID=:C_STEP_ID");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_FLOW_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TITLE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONTENT", OracleDbType.Varchar2, 500),
new OracleParameter(":C_FILEURL", OracleDbType.Varchar2, 200),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":D_SB_DT", OracleDbType.Date),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_TASK_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STEP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_FLOW_ID;
parameters[1].Value = model.C_EMP_ID;
parameters[2].Value = model.C_TITLE;
parameters[3].Value = model.C_CONTENT;
parameters[4].Value = model.C_FILEURL;
parameters[5].Value = model.N_STATUS;
parameters[6].Value = model.D_SB_DT;
parameters[7].Value = model.C_REMARK;
parameters[8].Value = model.N_TYPE;
parameters[9].Value = model.C_TASK_ID;
parameters[10].Value = model.C_STEP_ID;
parameters[11].Value = model.C_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 质量异议审批
/// </summary>
/// <param name="modFile">文件</param>
/// <param name="modNextEmp">步骤操作人</param>
/// <returns></returns>
public bool ApproveQua(Mod_TMF_FILEINFO modFile, Mod_TMB_FILE_NEXT_EMP modNextEmp)
{
ArrayList arraySql = new ArrayList();
#region //文件
string ID = Guid.NewGuid().ToString("N");
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMF_FILEINFO(");
strSql.Append("C_ID,");
strSql.Append("C_FLOW_ID,");
strSql.Append("C_EMP_ID,");
strSql.Append("C_TITLE,");
strSql.Append("C_CONTENT,");
strSql.Append("N_TYPE,");
strSql.Append("C_TASK_ID,");
strSql.Append("C_STEP_ID");
strSql.Append(")");
strSql.Append(" values (");
strSql.Append("'" + ID + "',");
strSql.Append("'" + modFile.C_FLOW_ID + "',");
strSql.Append("'" + modFile.C_EMP_ID + "',");
strSql.Append("'" + modFile.C_TITLE + "',");
strSql.Append("'" + modFile.C_CONTENT + "',");
strSql.Append("" + modFile.N_TYPE + ",");
strSql.Append("'" + modFile.C_TASK_ID + "',");
strSql.Append("'" + modFile.C_STEP_ID + "'");
strSql.Append(")");
arraySql.Add(strSql.ToString());
#endregion
#region //更新质量异议反馈
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update TMC_ROLL_APPLY set ");
strSql2.Append("C_STATUS='1', "); //1审批中
strSql2.Append("C_APPROVEID='" + modNextEmp.C_NEXT_EMP_ID + "' "); //审批人
strSql2.Append(" where C_ID='" + modFile.C_TASK_ID + "' ");
arraySql.Add(strSql2.ToString());
#endregion
#region//步骤操作人
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("insert into TMB_FILE_NEXT_EMP(");
strSql3.Append("C_FILE_ID,");
strSql3.Append("C_NEXT_EMP_ID,");
strSql3.Append("C_STEP_ID");
strSql3.Append(")");
strSql3.Append(" values (");
strSql3.Append("'" + ID + "',");
strSql3.Append("'" + modNextEmp.C_NEXT_EMP_ID + "',");
strSql3.Append("'" + modNextEmp.C_STEP_ID + "'");
strSql3.Append(")");
arraySql.Add(strSql3.ToString());
#endregion
return(DbHelperOra.ExecuteSqlTran(arraySql));
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (BaseUser != null)
{
try
{
ltlUserID.Text = BaseUser.Id;
ltlUserName.Text = BaseUser.Name;
if (!string.IsNullOrEmpty(Request.QueryString["ID"]) && !string.IsNullOrEmpty(Request.QueryString["flag"]))
{
ltlFileID.Text = Request.QueryString["ID"];
ltlFlag.Text = Request.QueryString["flag"];
Mod_TMF_FILEINFO modFile = fileinfo.GetModel(Request.QueryString["ID"]);
ltlTaskID.Text = modFile.C_TASK_ID;
hidTask.Value = modFile.C_TASK_ID;
ltlFlowID.Text = modFile.C_FLOW_ID;
ltlStepID.Text = modFile.C_STEP_ID;
GetConInfo(); //加载合同信息
GetFlowProc(); //加载审批记录
//GetPlanWGT();//区域计划量
Mod_TMF_FILEINFO mod = fileinfo.GetModel(ltlFileID.Text);
if (mod != null)
{
ltlContent.Text = mod.C_CONTENT;
}
div_check.Visible = ltlFlag.Text == "0" ? true : false;
hidNextSetpID.Value = flowstep.GetNextStep(ltlFlowID.Text, ltlStepID.Text);
//最后步骤操作
if (hidNextSetpID.Value == "0")
{
trNextEmp.Visible = false;
}
else
{
trNextEmp.Visible = true;
}
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
var vUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (vUser == null)
{
WebMsg.CheckUserLogin();
return;
}
else
{
ltlUserID.Text = vUser.Id;
ltlUserName.Text = vUser.Name;
if (!string.IsNullOrEmpty(Request.QueryString["ID"]) && !string.IsNullOrEmpty(Request.QueryString["flag"]))
{
ltlFileID.Text = Request.QueryString["ID"];
ltlFlag.Text = Request.QueryString["flag"];
Mod_TMF_FILEINFO modFile = fileinfo.GetModel(ltlFileID.Text);
if (modFile != null)
{
GetInfo(modFile.C_TASK_ID);//基本信息
hid.Value = modFile.C_TASK_ID;
ltlTaskID.Text = modFile.C_TASK_ID;
ltlFlowID.Text = modFile.C_FLOW_ID;
ltlStepID.Text = modFile.C_STEP_ID;
GetFlowProc();//加载审批记录
div_check.Visible = ltlFlag.Text == "0" ? true : false;
hidNextSetpID.Value = flowstep.GetNextStep(ltlFlowID.Text, ltlStepID.Text);
//最后步骤操作
if (hidNextSetpID.Value == "0")
{
trNextEmp.Visible = false;
}
else
{
trNextEmp.Visible = true;
}
}
}
}
}
}
public AjaxResult GetQualityStl_GRD([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
#endregion
#region //数据操作
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(tmq_quality_stl_grd.GetQUALITY_STL_GRD(modFile.C_TASK_ID).Tables[0]);
#endregion
return(result);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMF_FILEINFO model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into TMF_FILEINFO(");
strSql.Append("C_ID,C_FLOW_ID,C_EMP_ID,C_TITLE,C_CONTENT,C_FILEURL,N_STATUS,D_SB_DT,C_REMARK,N_TYPE,C_TASK_ID,C_STEP_ID)");
strSql.Append(" values (");
strSql.Append(":C_ID,:C_FLOW_ID,:C_EMP_ID,:C_TITLE,:C_CONTENT,:C_FILEURL,:N_STATUS,:D_SB_DT,:C_REMARK,:N_TYPE,:C_TASK_ID,:C_STEP_ID)");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_FLOW_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_EMP_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_TITLE", OracleDbType.Varchar2, 100),
new OracleParameter(":C_CONTENT", OracleDbType.Varchar2, 500),
new OracleParameter(":C_FILEURL", OracleDbType.Varchar2, 200),
new OracleParameter(":N_STATUS", OracleDbType.Decimal, 1),
new OracleParameter(":D_SB_DT", OracleDbType.Date),
new OracleParameter(":C_REMARK", OracleDbType.Varchar2, 200),
new OracleParameter(":N_TYPE", OracleDbType.Decimal, 1),
new OracleParameter(":C_TASK_ID", OracleDbType.Varchar2, 100),
new OracleParameter(":C_STEP_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = model.C_ID;
parameters[1].Value = model.C_FLOW_ID;
parameters[2].Value = model.C_EMP_ID;
parameters[3].Value = model.C_TITLE;
parameters[4].Value = model.C_CONTENT;
parameters[5].Value = model.C_FILEURL;
parameters[6].Value = model.N_STATUS;
parameters[7].Value = model.D_SB_DT;
parameters[8].Value = model.C_REMARK;
parameters[9].Value = model.N_TYPE;
parameters[10].Value = model.C_TASK_ID;
parameters[11].Value = model.C_STEP_ID;
int rows = DbHelperOra.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public AjaxResult GetQualOK([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 //最后步骤操作
if (tmf_fileinfo.UpdateStepStatus(nextStep, 1, fileID)) //更新文件事务状态为办结
{
////更新当前审批人/时间/状态
tmq_quality_main.UpdateCheckEmp(modFile.C_TASK_ID, modUser.C_ID, "2", DateTime.Now);
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);
}
public AjaxResult GetQualityInfo([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
#endregion
#region //数据操作
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
Mod_TMQ_QUALITY_MAIN mod = tmq_quality_main.GetModel(modFile.C_TASK_ID);
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = SerializationHelper.JsonSerialize(mod);
#endregion
return(result);
}
//提交申请
protected void btnok_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidEmpID.Value))
{
//文件
Mod_TMF_FILEINFO modFile = new Mod_TMF_FILEINFO();
modFile.C_FLOW_ID = dropFlow.SelectedValue;//流程
modFile.C_EMP_ID = ltlUserID.Text;
modFile.C_TITLE = txtTitle.Text;
modFile.C_CONTENT = txtContent.Text;
modFile.N_TYPE = 0;
modFile.C_TASK_ID = "";
modFile.C_STEP_ID = hidSetpID.Value;//步骤
//步骤操作人
Mod_TMB_FILE_NEXT_EMP modNextEmp = new Mod_TMB_FILE_NEXT_EMP();
modNextEmp.C_FILE_ID = ID;
modNextEmp.C_NEXT_EMP_ID = hidEmpID.Value;
modNextEmp.C_STEP_ID = hidSetpID.Value;
//if (tmo_con.ApproveCon(modFile, modNextEmp))
//{
// WebMsg.MessageBox("提交成功", "ConList.aspx");
//}
//else
//{
// WebMsg.MessageBox("提交失败");
//}
}
else
{
WebMsg.MessageBox("请选择下一处理人");
}
}
catch (Exception ex)
{
WebMsg.MessageBox(ex.Message);
}
}
public AjaxResult GetNextStepApprEmp([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
#endregion
#region //数据操作
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
string nextStep = "0";
if (modFile.C_STEP_ID != "0")
{
nextStep = tmb_flowstep.GetNextStep(modFile.C_FLOW_ID, modFile.C_STEP_ID);
}
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = SerializationHelper.Dtb2Json(ts_user_role.GetCheckEmp(nextStep).Tables[0]);
#endregion
return(result);
}
public AjaxResult GetNextStep([FromBody] dynamic Json)
{
#region //参数
string fileID = Json.fileID; //文件ID
#endregion
#region //数据操作
Mod_TMF_FILEINFO modFile = tmf_fileinfo.GetModel(fileID);
string nextStep = "0";
if (modFile.C_STEP_ID != "0")
{
nextStep = tmb_flowstep.GetNextStep(modFile.C_FLOW_ID, modFile.C_STEP_ID);
}
AjaxResult result = new AjaxResult();
result.Code = DoResult.Success;
result.Result = nextStep;
#endregion
return(result);
}
//提交审批
protected void btnSave_Click(object sender, EventArgs e)
{
var BaseUser = (NF.Framework.CurrentUser)HttpContext.Current.Session["CurrentUser"];
if (BaseUser != null)
{
string stepID = flowstep.GetFirstStep(dropFlow.SelectedValue);//获取流程第一步骤
if (!string.IsNullOrEmpty(stepID))
{
//插入新数据
Mod_TMF_FILEINFO mod = new Mod_TMF_FILEINFO();
mod.C_FLOW_ID = dropFlow.SelectedValue;
mod.C_EMP_ID = ltlUserID.Text;
mod.C_TITLE = txtTitle.Text;
mod.C_CONTENT = txtContent.Text;
mod.N_TYPE = 0;
mod.C_TASK_ID = ltlConN0.Text;
mod.C_STEP_ID = stepID;
mod.D_SB_DT = DateTime.Now;
if (fileinfo.Add(mod)) //插入文件事务
{
#region //更新合同/明细状态
if (con.UpdateConStatus(1, ltlConN0.Text)) //更新合同
{
if (condetails.UpdateStatus(1, ltlConN0.Text)) //更新合同明细
{
WebMsg.MessageBox("提交成功", "ConList.aspx");
}
}
#endregion
}
}
else
{
WebMsg.MessageBox("当前没有流程节点，请联系管理员");
return;
}
}
}
//提交审批
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
if (!string.IsNullOrEmpty(hidEmpID.Value))
{
//文件
Mod_TMF_FILEINFO modFile = new Mod_TMF_FILEINFO();
modFile.C_FLOW_ID = dropFlow.SelectedValue;//流程
modFile.C_EMP_ID = ltlUserID.Text;
modFile.C_TITLE = txtTitle.Text;
modFile.N_TYPE = 2; //资源
modFile.C_TASK_ID = hidQualityID.Value;
modFile.C_STEP_ID = hidSetpID.Value; //步骤
//步骤操作人
Mod_TMB_FILE_NEXT_EMP modNextEmp = new Mod_TMB_FILE_NEXT_EMP();
modNextEmp.C_FILE_ID = ID;
modNextEmp.C_NEXT_EMP_ID = hidEmpID.Value;
modNextEmp.C_STEP_ID = hidSetpID.Value;
if (tmc_roll_apply.ApproveQua(modFile, modNextEmp))
{
WebMsg.MessageBox("提交成功", "myRoll.aspx");
}
else
{
WebMsg.MessageBox("提交失败");
}
}
else
{
WebMsg.MessageBox("请选择下一处理人");
}
}
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);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Mod_TMF_FILEINFO GetModel(string C_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select C_ID,C_FLOW_ID,C_EMP_ID,C_TITLE,C_CONTENT,C_FILEURL,N_STATUS,D_SB_DT,C_REMARK,N_TYPE,C_TASK_ID,C_STEP_ID from TMF_FILEINFO ");
strSql.Append(" where C_ID=:C_ID ");
OracleParameter[] parameters =
{
new OracleParameter(":C_ID", OracleDbType.Varchar2, 100)
};
parameters[0].Value = C_ID;
Mod_TMF_FILEINFO model = new Mod_TMF_FILEINFO();
DataSet ds = DbHelperOra.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mod_TMF_FILEINFO model)
{
return(dal.Update(model));
}
/// <summary>
/// 质量异议审批
/// </summary>
/// <param name="modFile">文件</param>
/// <param name="modNextEmp">步骤操作人</param>
/// <returns></returns>
public bool ApproveQua(Mod_TMF_FILEINFO modFile, Mod_TMB_FILE_NEXT_EMP modNextEmp)
{
return(dal.ApproveQua(modFile, modNextEmp));
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(Mod_TMF_FILEINFO model)
{
return(dal.Add(model));
}
