/// <summary>
/// 拒绝
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void button_shenpi_no_Click(object sender, ImageClickEventArgs e)
{
QSMBLL qsmbll = new QSMBLL(FactoryID);
CARLogBLL logbll = new CARLogBLL(FactoryID);
qsminfo.STATUS = 14;
qsmbll.Update(qsminfo);
LogInfo loginfo = new LogInfo();
if (ApprovalTable.Rows.Count > 0)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[0]["rkey"].ToString()));
loginfo.sp_end_date = DateTime.Now;
loginfo.sp_content = SP_Content.Text;
loginfo.status = 2;
logbll.UpdateData(loginfo);
}
string sp_user = qsminfo.ENT_USER;
string subject = "客户投诉单，未通过审批。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
string body = url;
XmlSource.SendEmail(sp_user, subject, body);
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('提交成功！');window.opener = null;window.close();</script>");
button_shenpi_yes.Enabled = false;
button_shenpi_no.Enabled = false;
}
protected void Check()
{
string sqllog = "select * from CAR_Table_LOG where SN_PTR=" + did.ToString() + " and Status = 0 and sn_type = 'QSM' order by sp_step";
CARLogBLL logBll = new CARLogBLL(FactoryID);
ApprovalTable = logBll.GetDataSet(sqllog);
if (ApprovalTable.Rows.Count > 0)
{
if (ApprovalTable.Rows[0]["SP_User"].ToString() != UserAD && !CurrentUser.RightIsAdmin)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('您没有审批此单的权限！');</script>");
div_sp.Visible = false;
Response.End();
}
SP_Step = int.Parse(ApprovalTable.Rows[0]["sp_step"].ToString());
SP_Total_Step = int.Parse(ApprovalTable.Rows[0]["SP_Total_Step"].ToString());
}
CAR_Content.AutoConfigure = CuteEditor.AutoConfigure.None;
CAR_Content.ActiveTab = CuteEditor.TabType.View;
CAR_Content.ShowBottomBar = false;
if (SP_Step == SP_Total_Step)
{
div_center.Visible = true;
Info_Content.AutoConfigure = CuteEditor.AutoConfigure.None;
Info_Content.ActiveTab = CuteEditor.TabType.View;
Info_Content.ShowBottomBar = false;
}
else
{
div_center.Visible = false;
}
}
protected void BindData()
{
CARDataBLL dataBll = new CARDataBLL(CurrentFactoryID);
DataInfo dataInfo = dataBll.GetByKey(did);
if (dataInfo.status == 0)
{
Response.Write("<script>alert('未发启审批!');</script>");
return;
}
CARLogBLL logBll = new CARLogBLL(CurrentFactoryID);
DataTable tb = new DataTable();
string sql = "select SP_Step ,SP_User,Status,SP_Content from [CAR_Table_LOG] where sn_ptr = " + did.ToString() + " and sn_type = '" + type + "' order by SP_Step";
tb = logBll.GetDataSet(sql);
if (tb.Rows.Count == 0)
{
Response.Write("<script>alert('无数据!');window.opener = null;window.close();</script>");
return;
}
foreach (DataRow row in tb.Rows)
{
row["sp_user"] = GetUserName(row["sp_user"].ToString());
}
GridView1.DataSource = tb;
GridView1.DataBind();
}
/// <summary>
/// 拒绝
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void button_shenpi_no_Click(object sender, ImageClickEventArgs e)
{
CARDataBLL dataBll = new CARDataBLL(FactoryID);
CARLogBLL logbll = new CARLogBLL(FactoryID);
DataInfo datainfo = new DataInfo();
datainfo = dataBll.GetByKey(did);
datainfo.status = 14;//拒绝
dataBll.UpdateData(datainfo);
LogInfo loginfo = new LogInfo();
if (ApprovalTable.Rows.Count > 0)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[0]["rkey"].ToString()));
loginfo.sp_end_date = DateTime.Now;
loginfo.sp_content = SP_Content.Text;
loginfo.status = 2;
logbll.UpdateData(loginfo);
}
string sp_user = datainfo.nowuser;
string subject = "8D form，未通过审批。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
string body = url;
XmlSource.SendEmail(sp_user, subject, body);
Response.Write("<script language='javaScript'>alert('操作成功');window.opener = null;window.close();</script>");//无提示关闭页面
button_shenpi_yes.Enabled = false;
button_shenpi_no.Enabled = false;
}
/// <summary>
/// 审批通过
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void button_shenpi_yes_Click(object sender, ImageClickEventArgs e)
{
SABLL saBLL = new SABLL(FactoryID);
CARLogBLL logbll = new CARLogBLL(FactoryID);
LogInfo loginfo = new LogInfo();
#region data
if (SP_Step == SP_Total_Step)
{
saInfo.STATUS = 1;
saInfo.CLOSE_DATE = DateTime.Now;
}
saBLL.Update(saInfo);
#endregion
#region log
if (ApprovalTable.Rows.Count >= 1)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[0]["rkey"].ToString()));
loginfo.sp_end_date = DateTime.Now;
loginfo.sp_content = SP_Content.Text;
loginfo.status = 1;
logbll.UpdateData(loginfo);
if (ApprovalTable.Rows.Count >= 2)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[1]["rkey"].ToString()));
loginfo.sp_start_date = DateTime.Now;
logbll.UpdateData(loginfo);
}
}
#endregion
#region mail
string sp_user = "";
string subject = "";
string body = "";
if (ApprovalTable.Rows.Count == 1)
{
if (SP_Step == SP_Total_Step)
{
sp_user = saInfo.ENT_USER;
subject = "不良品确认单，审批通过。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
else
{
sp_user = ApprovalTable.Rows[1]["sp_user"].ToString();
subject = "有新的不良品确认单，请审批。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
XmlSource.SendEmail(sp_user, subject, body);
}
#endregion
Response.Write("<script language='javaScript'>alert('操作成功');window.opener = null;window.close();</script>");//无提示关闭页面
button_shenpi_yes.Enabled = false;
button_shenpi_no.Enabled = false;
}
protected void Check()
{
string sqllog = "select * from CAR_Table_LOG where SN_PTR=" + did.ToString() + " and sn_type = 'SA' and Status = 0 order by sp_step";
CARLogBLL logBll = new CARLogBLL(FactoryID);
ApprovalTable = logBll.GetDataSet(sqllog);
if (ApprovalTable.Rows.Count > 0)
{
if (ApprovalTable.Rows[0]["SP_User"].ToString() != UserAD && !CurrentUser.RightIsAdmin)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('您没有审批此单的权限！');</script>");
div_sp.Visible = false;
Response.End();
}
SP_Step = int.Parse(ApprovalTable.Rows[0]["sp_step"].ToString());
SP_Total_Step = int.Parse(ApprovalTable.Rows[0]["SP_Total_Step"].ToString());
}
}
private int Writelog(int sn_ptr)
{
CARLogBLL logBll = new CARLogBLL(CurrentFactoryID);
DataTable tb_temp = new DataTable();
tb_temp = logBll.GetDataSet("select rkey from CAR_Table_LOG where SN_PTR = " + sn_ptr.ToString());
int a = 0;
for (int i = 0; i < tb_temp.Rows.Count; i++)
{
a = logBll.DelData(int.Parse(tb_temp.Rows[i][0].ToString()));
if (a != 0)
{
return(-1);
}
}
if (ApprovalTable.Rows.Count > 0)
{
for (int j = 0; j < ApprovalTable.Rows.Count; j++)
{
LogInfo logInfo = new LogInfo();
logInfo.sn_ptr = sn_ptr;
logInfo.sn_type = "";
logInfo.sp_total_step = ApprovalTable.Rows.Count;
if (j == 0)
{
logInfo.sp_start_date = DateTime.Now;
//logInfo.sp_end_date
}
logInfo.sp_type = 1;
logInfo.sp_step = j + 1;
logInfo.sp_user = ApprovalTable.Rows[j][2].ToString();
//logInfo.sp_content
logInfo.status = 0;
a = logBll.AddData(logInfo);
if (a != 0)
{
return(-1);
}
}
}
return(0);
}
/// <summary>
/// 审批通过
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void button_shenpi_yes_Click(object sender, ImageClickEventArgs e)
{
QSMBLL qsmbll = new QSMBLL(FactoryID);
CARLogBLL logbll = new CARLogBLL(FactoryID);
LogInfo loginfo = new LogInfo();
#region data
if (SP_Step == SP_Total_Step)
{
qsminfo.CONF_CONTENT = CONF_Content.Text;
qsminfo.STATUS = 1;
qsminfo.CLOSE_DATE = DateTime.Now;
qsmbll.Update(qsminfo);
}
else
{
try { qsminfo.DCJIAOHUO_QTY = decimal.Parse(dcjiaohuo_qty.Text); }
catch { qsminfo.DCJIAOHUO_QTY = 0; }
if (zaitu_status_ck1.Checked)
{
qsminfo.ZAITU_STATUS = 0;
qsminfo.ZAITU_QTY = 0;
}
if (zaitu_status_ck2.Checked)
{
qsminfo.ZAITU_STATUS = 1;
try { qsminfo.ZAITU_QTY = decimal.Parse(zaitu_qty.Text); }
catch { qsminfo.ZAITU_QTY = 0; }
}
if (chuli_status_ck1.Checked)
{
qsminfo.ZAITUCHULI_TYPE = 1;
}
if (chuli_status_ck2.Checked)
{
qsminfo.ZAITUCHULI_TYPE = 2;
}
if (chuli_status_ck3.Checked)
{
qsminfo.ZAITUCHULI_TYPE = 3;
}
if (changleikuchun_status_ck1.Checked)
{
qsminfo.CANGCUN_STATUS = 0;
qsminfo.CANGCUNCHULI_TYPE = 0;
}
if (changleikuchun_status_ck2.Checked)
{
qsminfo.CANGCUN_STATUS = 1;
if (chuli_type_ck1.Checked)
{
qsminfo.CANGCUNCHULI_TYPE = 1;
}
if (chuli_type_ck2.Checked)
{
qsminfo.CANGCUNCHULI_TYPE = 2;
}
if (chuli_type_ck3.Checked)
{
qsminfo.CANGCUNCHULI_TYPE = 3;
}
if (chuli_type_ck4.Checked)
{
qsminfo.CANGCUNCHULI_TYPE = 4;
}
}
qsminfo.INFO_CONTENT = Info_Content.Text;
if (ApprovalTable.Rows.Count == SP_Total_Step)
{
qsminfo.FIRST_REPLY_DATE = DateTime.Now;
}
if (ApprovalTable.Rows.Count == 2)//倒数第二次审批
{
qsminfo.LAST_REPLY_DATE = DateTime.Now;
}
qsmbll.Update(qsminfo);
}
#endregion
#region log
if (ApprovalTable.Rows.Count >= 1)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[0]["rkey"].ToString()));
loginfo.sp_end_date = DateTime.Now;
loginfo.sp_content = SP_Content.Text;
loginfo.status = 1;
logbll.UpdateData(loginfo);
if (ApprovalTable.Rows.Count >= 2)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[1]["rkey"].ToString()));
loginfo.sp_start_date = DateTime.Now;
logbll.UpdateData(loginfo);
}
}
#endregion
#region mail
string sp_user = "";
string subject = "";
string body = "";
if (ApprovalTable.Rows.Count == 1)
{
if (SP_Step == SP_Total_Step)
{
sp_user = qsminfo.ENT_USER;
subject = "客户投诉单，审批通过。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
}
else
{
sp_user = ApprovalTable.Rows[1]["sp_user"].ToString();
subject = "有新的客户投诉单，请审批。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
XmlSource.SendEmail(sp_user, subject, body);
#endregion
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('提交成功！');window.opener = null;window.close();</script>");
button_shenpi_yes.Enabled = false;
button_shenpi_no.Enabled = false;
}
protected void Initialize()
{
#region 判断用户权限
if (!HasRight(XmlSource.GetRightIndex("BD")))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('你没有权限进入此页面！');</script>");
Response.End();
return;
}
#endregion
#region 初始化界面
Init_Company(1);
did = String.IsNullOrEmpty(Request.QueryString["did"]) ? 0 : int.Parse(Request.QueryString["did"]);
if (did > 0)
{
dataInfo = new CARDataBLL(CurrentFactoryID).GetByKey(did);
if (dataInfo.op_type != 1)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('非法访问！');</script>");
Response.End();
return;
}
if (dataInfo.status == 0 || dataInfo.status == 14) //未审批、未发启
{
div_AppListEdit.Style.Remove("display");
div_AppListShow.Style.Add("display", "none");
//div_AppListEdit.Visible = true;
//div_AppListShow.Visible = false;
#region 审批信息
ApprovalTable = new CARLogBLL(CurrentFactoryID).GetDataSet("select sp_step as 步骤,'' as 审批人,sp_user as 帐号 from CAR_Table_LOG where sn_type='' and SN_PTR=" + dataInfo.rkey.ToString() + " order by sp_step");
GridView1.DataSource = ApprovalTable;
GridView1.DataBind();
#endregion
}
else //已经发送审批,不可更改
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
//ibtn_Cancel.Enabled = false; 取消按钮不实现任何功能
div_AppListShow.Style.Remove("display");
div_AppListEdit.Style.Add("display", "none");
//div_AppListEdit.Visible = false;
//div_AppListShow.Visible = true;
#region 审批信息
tb_ApprovalInfo = new CARLogBLL(CurrentFactoryID).GetDataSet("select sp_step,sp_user,sp_end_date,status,sp_content from CAR_Table_LOG where SN_PTR=" + dataInfo.rkey.ToString() + " order by sp_step");
for (int i = 0; i < tb_ApprovalInfo.Rows.Count; i++)
{
tb_ApprovalInfo.Rows[i][1] = GetUserName(tb_ApprovalInfo.Rows[i][1].ToString());
}
GridView2.DataSource = tb_ApprovalInfo;
GridView2.DataBind();
#endregion
}
#region 申请信息
Required_Date.Text = dataInfo.required_date.ToString();
try { Serial_No.Items.FindByText(dataInfo.serial_no).Selected = true; }
catch { }
Happen_Date.Text = dataInfo.happen_date.ToString();
From_Comp.Items.FindByText(dataInfo.from_comp).Selected = true;
CAR_Comp.Items.FindByText(dataInfo.car_comp).Selected = true;
Issued_User.Text = dataInfo.issued_user;
Issued_APP.Text = dataInfo.issued_app;
Received_User.Text = dataInfo.received_user;
CAR_Content.Text = Server.HtmlDecode(dataInfo.car_content);
#endregion
}
#endregion
#region 根据权限来控制页面功能
if (!HasRight(XmlSource.GetRightIndex("EDIT")))
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
if (did > 0)
{
if (dataInfo.nowuser != CurrentUser.UserADAcount && !CurrentUser.RightIsAdmin)//如果当前用户不是发启人,就只能查看
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
}
#endregion
#region 文件路径
string id = System.Web.HttpContext.Current.User.Identity.Name.Replace("FOUNDERPCB\\", "");
id = id + @"/" + System.DateTime.Now.Date.ToShortDateString();
//Response.Write("id" + id);
//建立用户目录
string path = Server.MapPath(@"uploads/" + id);
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);//在指定路径下新建一个文件夹
}
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityMediaGalleryPath(path);
CAR_Content.SetSecurityFlashGalleryPath(path);
CAR_Content.SetSecurityFilesGalleryPath(path);
#endregion
}
private int Writelog(int sn_ptr)
{
DataRow[] rows = tb_SA.Select("custName <>'' and custCode <> ''");
SAListBLL salistBll = new SAListBLL(CurrentFactoryID);
salistBll.DeteleByKey(did);
for (int b = 0; b < rows.Length; b++)
{
SAList sa = new SAList();
sa.sn_ptr = sn_ptr;
sa.custCode = tb_SA.Rows[b]["custCode"].ToString();
sa.custName = tb_SA.Rows[b]["custName"].ToString();
try { sa.recordDateTime = Convert.ToDateTime(tb_SA.Rows[b]["recordDateTime"].ToString()); }
catch { }
sa.founderMaterilNo = tb_SA.Rows[b]["founderMaterilNo"].ToString();
sa.custPartNo = tb_SA.Rows[b]["custPartNo"].ToString();
sa.cycleValue = tb_SA.Rows[b]["cycleValue"].ToString();
sa.happenAddress = tb_SA.Rows[b]["happenAddress"].ToString();
sa.LOT = tb_SA.Rows[b]["LOT"].ToString();
sa.ET = tb_SA.Rows[b]["ET"].ToString();
sa.T = tb_SA.Rows[b]["T"].ToString();
sa.reason = tb_SA.Rows[b]["reason"].ToString();
sa.mateialType = tb_SA.Rows[b]["mateialType"].ToString();
sa.results = tb_SA.Rows[b]["results"].ToString();
try { sa.quantity = decimal.Parse(tb_SA.Rows[b]["quantity"].ToString()); }
catch { sa.quantity = 0; }
try { sa.signDate = Convert.ToDateTime(tb_SA.Rows[b]["signDate"].ToString()); }
catch { }
sa.signingPerson = tb_SA.Rows[b]["signingPerson"].ToString();
sa.factoryName = tb_SA.Rows[b]["factoryName"].ToString();
try { sa.discountPrice = decimal.Parse(tb_SA.Rows[b]["discountPrice"].ToString()); }
catch { }
try { sa.discountAmount = decimal.Parse(tb_SA.Rows[b]["discountAmount"].ToString()); }
catch { }
salistBll.Add(sa);
}
CARLogBLL logBll = new CARLogBLL(CurrentFactoryID);
DataTable tb_temp = new DataTable();
tb_temp = logBll.GetDataSet("select rkey from CAR_Table_LOG where sn_type = 'SA' and SN_PTR = " + sn_ptr.ToString());
int a = 0;
for (int i = 0; i < tb_temp.Rows.Count; i++)
{
a = logBll.DelData(int.Parse(tb_temp.Rows[i][0].ToString()));
if (a != 0)
{
return(-1);
}
}
if (ApprovalTable.Rows.Count > 0)
{
for (int j = 0; j < ApprovalTable.Rows.Count; j++)
{
LogInfo logInfo = new LogInfo();
logInfo.sn_ptr = sn_ptr;
logInfo.sn_type = "SA";
logInfo.sp_total_step = ApprovalTable.Rows.Count;
if (j == 0)
{
logInfo.sp_start_date = DateTime.Now;
//logInfo.sp_end_date
}
logInfo.sp_type = 1;
logInfo.sp_step = j + 1;
logInfo.sp_user = ApprovalTable.Rows[j][2].ToString();
//logInfo.sp_content
logInfo.status = 0;
a = logBll.AddData(logInfo);
if (a != 0)
{
return(-1);
}
}
}
return(0);
}
protected void Initialize()
{
lnk_CSS.Href = Request.Path.Substring(0, Request.Path.LastIndexOf('/')) + "/CSS/GV.css";
#region 判断用户权限
if (!HasRight(XmlSource.GetRightIndex("SA")))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('你没有权限进入此页面！');</script>");
Response.End();
return;
}
#endregion
#region 初始化界面
did = String.IsNullOrEmpty(Request.QueryString["did"]) ? 0 : int.Parse(Request.QueryString["did"]);
#region gridview3数据绑定
tb_SA = new CARDataBLL(CurrentFactoryID).GetDataSet("select * from CAR_Table_SAList where sn_ptr = " + did.ToString());
if (tb_SA.Rows.Count < row_Number)
{
for (int i = 0; i < row_Number - tb_SA.Rows.Count;)
{
DataRow row = tb_SA.NewRow();
for (int j = 0; j < tb_SA.Columns.Count; j++)
{
row[j] = DBNull.Value;
}
tb_SA.Rows.Add(row);
}
}
GridView3.DataSource = tb_SA;
GridView3.DataBind();
#endregion
if (did > 0)
{
saInfo = new SABLL(CurrentFactoryID).getSAInfoByrkey(did);
CAR_Content.Text = Server.HtmlDecode(saInfo.CAR_CONTENT);
CAR_Content.ActiveTab = CuteEditor.TabType.View;
if (saInfo.STATUS != 0 && saInfo.STATUS != 14)//审批中或审批完成
{
CAR_Content.AutoConfigure = CuteEditor.AutoConfigure.None;
CAR_Content.ShowBottomBar = false;
}
if (saInfo.STATUS == 0 || saInfo.STATUS == 14) //未审批、未发启或审批拒绝
{
div_AppListEdit.Visible = true;
#region 审批信息
ApprovalTable = new CARLogBLL(CurrentFactoryID).GetDataSet("select sp_step as 步骤,'' as 审批人,sp_user as 帐号 from CAR_Table_LOG where sn_type = 'SA' and SN_PTR=" + saInfo.RKEY.ToString() + " order by sp_step");
for (int i = 0; i < ApprovalTable.Rows.Count; i++)
{
ApprovalTable.Rows[i][1] = GetUserName(ApprovalTable.Rows[i][2].ToString());
}
GridView1.DataSource = ApprovalTable;
GridView1.DataBind();
#endregion
}
else //已经发送审批,不可更改
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
div_AppListEdit.Visible = false;
}
#region 申请信息
#endregion
}
#endregion
#region 根据权限来控制页面功能
if (!HasRight(XmlSource.GetRightIndex("EDIT")))
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
if (did > 0)
{
if (saInfo.ENT_USER != CurrentUser.UserADAcount && !CurrentUser.RightIsAdmin)//如果当前用户不是发启人,就只能查看
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
}
#endregion
#region 文件路径
string id = System.Web.HttpContext.Current.User.Identity.Name.Replace("FOUNDERPCB\\", "");
id = id + @"/" + System.DateTime.Now.Date.ToShortDateString();
//Response.Write("id" + id);
//建立用户目录
string path = Server.MapPath(@"uploads/" + id);
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);//在指定路径下新建一个文件夹
}
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityMediaGalleryPath(path);
CAR_Content.SetSecurityFlashGalleryPath(path);
CAR_Content.SetSecurityFilesGalleryPath(path);
#endregion
}
/// <summary>
/// 审批通过
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void button_shenpi_yes_Click(object sender, ImageClickEventArgs e)
{
CARDataBLL dataBll = new CARDataBLL(FactoryID);
CARLogBLL logbll = new CARLogBLL(FactoryID);
DataInfo datainfo = new DataInfo();
LogInfo loginfo = new LogInfo();
#region data
datainfo = dataBll.GetByKey(did);
if (SP_Step == 1 && datainfo.serial_no.Trim().Length < 5) //第一步审批之后获得单号
{
datainfo.serial_no = dataBll.getSerialNo(datainfo.serial_no);
}
if (SP_Step == SP_Total_Step)
{
datainfo.conf_content = CONF_Content.Text;
datainfo.conf_user = CONF_User.Text.Trim();
try{ datainfo.conf_user_date = Convert.ToDateTime(CONF_User_Date.Text.Trim()); }
catch {}
datainfo.conf_app = CONF_APP.Text;
try{ datainfo.conf_app_date = Convert.ToDateTime(CONF_APP_Date.Text.Trim()); }
catch {}
datainfo.status = 1;
dataBll.UpdateData(datainfo);
}
else
{
datainfo.interim_action = Interim_Action.Text;
try { datainfo.ia_date = Convert.ToDateTime(IA_Date.Text.Trim()); }
catch { }
datainfo.info_content = Info_Content.Text;
try { datainfo.Info_Date = Convert.ToDateTime(Info_Date.Text.Trim()); }
catch { }
datainfo.corrective_action = Corrective_Action.Text;
try { datainfo.ca_date = Convert.ToDateTime(CA_Date.Text.Trim()); }
catch { }
datainfo.ipca = IPCA.Text;
try { datainfo.ipca_date = Convert.ToDateTime(IPCA_Date.Text.Trim()); }
catch {}
datainfo.atpr = ATPR.Text;
try { datainfo.atpr_date = Convert.ToDateTime(IPCA_Date.Text.Trim()); }
catch { }
if (SOP_Status_ck_2.Checked == true)
{
datainfo.sop_status = 1;
datainfo.sop_name = SOP_Name.Text.Trim();
}
else if (SOP_Status_ck_1.Checked == true)
{
datainfo.sop_status = 0;
}
datainfo.z_app = Z_APP.Text.Trim();
datainfo.z_user = Z_User.Text.Trim();
try { datainfo.sop_date = Convert.ToDateTime(SOP_Date.Text.Trim()); }
catch { }
dataBll.UpdateData(datainfo);
}
#endregion
#region log
if (ApprovalTable.Rows.Count >= 1)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[0]["rkey"].ToString()));
loginfo.sp_end_date = DateTime.Now;
loginfo.sp_content = SP_Content.Text;
loginfo.status = 1;
logbll.UpdateData(loginfo);
if (ApprovalTable.Rows.Count >= 2)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[1]["rkey"].ToString()));
loginfo.sp_start_date = DateTime.Now;
logbll.UpdateData(loginfo);
}
}
#endregion
#region mail
string sp_user = "";
string subject = "";
string body = "";
if (ApprovalTable.Rows.Count == 1)
{
if (SP_Step == SP_Total_Step)
{
sp_user = datainfo.nowuser;
subject = "8D form，审批通过。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
}
else
{
sp_user = ApprovalTable.Rows[1]["sp_user"].ToString();
subject = "8D form，请审批。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
XmlSource.SendEmail(sp_user, subject, body);
#endregion
Response.Write("<script language='javaScript'>alert('操作成功');window.opener = null;window.close();</script>");//无提示关闭页面
button_shenpi_yes.Enabled = false;
button_shenpi_no.Enabled = false;
}
/// <summary>
/// 审批通过
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void button_shenpi_yes_Click(object sender, ImageClickEventArgs e)
{
CARDataBLL dataBll = new CARDataBLL(FactoryID);
CARLogBLL logbll = new CARLogBLL(FactoryID);
DataInfo datainfo = new DataInfo();
LogInfo loginfo = new LogInfo();
datainfo = dataBll.GetByKey(did);
if (SP_Step == 1 && datainfo.serial_no.Trim().Length < 5) //第一步审批之后获得单号
{
datainfo.serial_no = dataBll.getSerialNo(datainfo.serial_no);
}
if (SP_Step == SP_Total_Step)
{
if (CONF_Status_1.Checked == true)
{
datainfo.conf_status = 1;
}
else if (CONF_Status_2.Checked == true)
{
datainfo.conf_status = 2;
}
else if (CONF_Status_3.Checked == true)
{
datainfo.conf_status = 3;
}
datainfo.conf_content = CONF_Content.Text;
datainfo.status = 1;
dataBll.UpdateData(datainfo);
}
else
{
if (Info_Type_1.Checked == true)
{
datainfo.info_type_1 = 1;
}
if (Info_Type_2.Checked == true)
{
datainfo.info_type_2 = 1;
}
if (Info_Type_3.Checked == true)
{
datainfo.info_type_3 = 1;
}
if (Info_Type_4.Checked == true)
{
datainfo.info_type_4 = 1;
}
if (Info_Type_5.Checked == true)
{
datainfo.info_type_5 = 1;
}
datainfo.info_content = Info_Content.Text;
datainfo.interim_action = Interim_Action.Text;
datainfo.IA_APP = IA_APP.Text;
datainfo.IA_USER = IA_User.Text;
try { datainfo.ia_date = Convert.ToDateTime(IA_Date.Text.Trim()); }
catch { }
datainfo.ipca = IPCA.Text;
datainfo.IPCA_APP = IPCA.Text;
datainfo.IPCA_USER = IPCA_User.Text;
try { datainfo.ipca_date = Convert.ToDateTime(IPCA_Date.Text.Trim()); }
catch {}
datainfo.levels = Levels.Text;
if (SOP_Status_2.Checked == true)
{
datainfo.sop_status = 1;
datainfo.sop_name = SOP_Name.Text.Trim();
}
else
{
datainfo.sop_status = 0;
datainfo.sop_name = "";
}
datainfo.sop_content = SOP_Content.Text.Trim();
try { datainfo.sop_date = Convert.ToDateTime(SOP_Date.Text.Trim()); }
catch { }
datainfo.together_write = Together_Write.Text;
dataBll.UpdateData(datainfo);
}
if (ApprovalTable.Rows.Count >= 1)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[0]["rkey"].ToString()));
loginfo.sp_end_date = DateTime.Now;
loginfo.sp_content = SP_Content.Text;
loginfo.status = 1;
logbll.UpdateData(loginfo);
if (ApprovalTable.Rows.Count >= 2)
{
loginfo = logbll.GetByKey(int.Parse(ApprovalTable.Rows[1]["rkey"].ToString()));
loginfo.sp_start_date = DateTime.Now;
logbll.UpdateData(loginfo);
}
}
string sp_user = "";
string subject = "";
string body = "";
if (ApprovalTable.Rows.Count == 1)
{
if (SP_Step == SP_Total_Step)
{
sp_user = datainfo.nowuser;
subject = "HSF异常处理，审批通过。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
}
else
{
sp_user = ApprovalTable.Rows[1]["sp_user"].ToString();
subject = "有新的HSF异常处理，请审批。";
string url = System.Configuration.ConfigurationManager.AppSettings["url"].ToString();
body = url;
}
XmlSource.SendEmail(sp_user, subject, body);
Response.Write("<script language='javaScript'>alert('操作成功');window.opener = null;window.close();</script>");//无提示关闭页面
button_shenpi_yes.Enabled = false;
button_shenpi_no.Enabled = false;
}
protected void Initialize()
{
#region 判断用户权限
if (!HasRight(XmlSource.GetRightIndex("QSM")))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('对不起，你没有权限访问此页面！');</script>");
Response.End();
return;
}
#endregion
#region 初始化界面
did = String.IsNullOrEmpty(Request.QueryString["did"]) ? 0 : int.Parse(Request.QueryString["did"]);
if (did > 0)
{
QSMInfo qsminfo = new QSMBLL(CurrentFactoryID).getQSMInfoByrkey(did);
if (qsminfo.STATUS == 0 || qsminfo.STATUS == 14) //未审批、未发启 注意:不显示gridview2(审批记录)
{
div_AppListEdit.Visible = true;
div_AppListShow.Visible = false;
#region 审批信息
ApprovalTable = new CARLogBLL(CurrentFactoryID).GetDataSet("select sp_step as 步骤,'' as 审批人,sp_user as 帐号 from CAR_Table_LOG where SN_PTR=" + qsminfo.RKEY.ToString() + " and sn_type = 'QSM' order by sp_step");
for (int i = 0; i < ApprovalTable.Rows.Count; i++)
{
ApprovalTable.Rows[i][1] = GetUserName(ApprovalTable.Rows[i][2].ToString());
}
GridView1.DataSource = ApprovalTable;
GridView1.DataBind();
#endregion
}
else //已经发送审批,不可更改
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
//ibtn_Cancel.Enabled = false; 取消按钮不实现任何功能
div_AppListEdit.Visible = false;
div_AppListShow.Visible = false;
#region 审批信息
tb_ApprovalInfo = new CARLogBLL(CurrentFactoryID).GetDataSet("select sp_step,sp_user,sp_end_date,status,sp_content from CAR_Table_LOG where SN_PTR=" + qsminfo.RKEY.ToString() + " and sn_type = 'QSM' order by sp_step");
GridView2.DataSource = tb_ApprovalInfo;
GridView2.DataBind();
#endregion
}
#region 申请信息
Serial_No.Text = qsminfo.SERIALNO;
CustName.Text = qsminfo.CUST_NAME;
CustCode.Value = qsminfo.CUST_CODE;
factoryList.Items.FindByText(qsminfo.FACTORY_NAME).Selected = true;
Happen_Date.Text = qsminfo.HAPPEN_DATE.ToString();
cust_MaterialNo.Text = qsminfo.CUST_MATERIALNO;
interalNo.Text = qsminfo.INTERALNO;
require_Date.Text = qsminfo.REQUIRE_DATE.ToString();
CAR_Content.Text = Server.HtmlDecode(qsminfo.CAR_CONTENT);
chuhuo_qty.Text = qsminfo.CHUHUO_QTY.ToString();
jiancha_qty.Text = qsminfo.JIANCHA_QTY.ToString();
buliang_qty.Text = qsminfo.BULIANG_QTY.ToString();
buliangbili.Text = qsminfo.BULIANGBILI.ToString() + "%";
buliangDC.Text = qsminfo.BULIANGDC;
zaixian_qty.Text = qsminfo.ZAITU_QTY.ToString();
kucun_qty.Text = qsminfo.KUCUN_QTY.ToString();
try { tousu_level.Items.FindByText(qsminfo.TOUSU_LEVEL).Selected = true; }
catch { }
try { tousu_type.Items.FindByText(qsminfo.TOUSU_TYPE).Selected = true; }
catch { }
if (Convert.ToInt32(qsminfo.TUIHUO_STATUS) == 0)
{
tuihuo_status_ck1.Checked = true;
tuihuo_status_ck2.Checked = false;
tuihuo_qty.Text = "0";
}
else if (Convert.ToInt32(qsminfo.TUIHUO_STATUS) == 1)
{
tuihuo_status_ck1.Checked = false;
tuihuo_status_ck2.Checked = true;
tuihuo_qty.Text = qsminfo.TUIHUO_QTY.ToString();
}
try { happen_address.Items.FindByValue(qsminfo.HAPPEN_ADDRESS.ToString()).Selected = true; }
catch { }
if (Convert.ToInt32(qsminfo.TIJIAO_STATUS) == 0)
{
tijiao_status_ck1.Checked = true;
tijiao_status_ck2.Checked = false;
}
else if (Convert.ToInt32(qsminfo.TIJIAO_STATUS) == 1)
{
tijiao_status_ck1.Checked = false;
tijiao_status_ck2.Checked = true;
if (Convert.ToInt32(qsminfo.TIJIAO_TYPE) == 1)
{
tijiao_type_ck1.Checked = true;
tijiao_type_ck2.Checked = false;
tijiao_type_ck3.Checked = false;
}
else if (Convert.ToInt32(qsminfo.TIJIAO_TYPE) == 2)
{
tijiao_type_ck1.Checked = false;
tijiao_type_ck2.Checked = true;
tijiao_type_ck3.Checked = false;
}
else if (Convert.ToInt32(qsminfo.TIJIAO_TYPE) == 3)
{
tijiao_type_ck1.Checked = false;
tijiao_type_ck2.Checked = false;
tijiao_type_ck3.Checked = true;
}
}
notes.Text = qsminfo.NOTES;
#endregion
}
else //新建QSM
{
tuihuo_status_ck2.Checked = true;
happen_address.Items[0].Selected = true;
tijiao_status_ck2.Checked = true;
tijiao_type_ck1.Checked = true;
}
#endregion
#region 根据权限来控制页面功能
if (!HasRight(XmlSource.GetRightIndex("EDIT")))
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
if (did > 0)
{
if (qsminfo.ENT_USER != CurrentUser.UserADAcount && !CurrentUser.RightIsAdmin)//如果当前用户不是发启人,就只能查看
{
sendApproval.Enabled = false;
ibtn_Save.Enabled = false;
}
}
#endregion
#region 文件路径
string id = System.Web.HttpContext.Current.User.Identity.Name.Replace("FOUNDERPCB\\", "");
id = id + @"/" + System.DateTime.Now.Date.ToShortDateString();
//Response.Write("id" + id);
//建立用户目录
string path = Server.MapPath(@"uploads/" + id);
if (!System.IO.Directory.Exists(path))
{
System.IO.Directory.CreateDirectory(path);//在指定路径下新建一个文件夹
}
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityImageGalleryPath(path);
CAR_Content.SetSecurityMediaGalleryPath(path);
CAR_Content.SetSecurityFlashGalleryPath(path);
CAR_Content.SetSecurityFilesGalleryPath(path);
#endregion
}
