/// <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 BindData()
{
QSMBLL qsmBLL = new QSMBLL(CurrentFactoryID);
IList <QSMInfo> qsmList = new List <QSMInfo>();
string strWhere = " 1=1 ";
if (tb_DateStart.Text.Trim() != "")
{
strWhere += " and datediff(d,ent_Date,'" + tb_DateStart.Text + "') <= 0 ";
}
if (tb_DateEnd.Text.Trim() != "")
{
strWhere += " and datediff(d,ent_Date,'" + tb_DateEnd.Text + "') >= 0";
}
if (tb_CustName.Text.Trim() != "")
{
strWhere += " and cust_name like '%" + tb_CustName.Text.Trim() + "'";
}
qsmList = qsmBLL.FindBySql(strWhere);
GridView1.DataSource = qsmList;
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
FactoryID = String.IsNullOrEmpty(Request.QueryString["FID"]) ? 98 : int.Parse(Request.QueryString["FID"]);
did = String.IsNullOrEmpty(Request.QueryString["did"]) ? 0 : int.Parse(Request.QueryString["did"]);
type = String.IsNullOrEmpty(Request.QueryString["type"]) ? "view" : Request.QueryString["type"];
try
{
this.UserAD = CurrentUser.UserADAcount;
}
catch
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('用户AD丢失！');</script>");
Response.End();
}
QSMBLL qsmbll = new QSMBLL(FactoryID);
qsminfo = qsmbll.getQSMInfoByrkey(did);
if (type == "view")
{
if (!HasRight(XmlSource.GetRightIndex("VIEW")) || !HasRight(XmlSource.GetRightIndex("QSM")))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('您没有查看此页面的权限！');</script>");
Response.End();
}
div_sp.Visible = false;
CAR_Content.AutoConfigure = CuteEditor.AutoConfigure.None;
CAR_Content.ActiveTab = CuteEditor.TabType.View;
CAR_Content.ShowBottomBar = false;
Info_Content.AutoConfigure = CuteEditor.AutoConfigure.None;
Info_Content.ActiveTab = CuteEditor.TabType.View;
Info_Content.ShowBottomBar = false;
CONF_Content.AutoConfigure = CuteEditor.AutoConfigure.None;
CONF_Content.ActiveTab = CuteEditor.TabType.View;
CONF_Content.ShowBottomBar = false;
InitPage(qsminfo);
}
else if (type == "approval")
{
if (qsminfo.STATUS == 0 || qsminfo.STATUS == 1 || qsminfo.STATUS == 14)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('此单未在审批中！');</script>");
Response.End();
}
Check();
InitPage(qsminfo);
}
}
}
/// <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("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
}
/// <summary>
/// 将信息写入库
/// </summary>
private int Writedata(int status)
{
QSMBLL qsmbll = new QSMBLL(CurrentFactoryID);
QSMInfo qsminfo = new QSMInfo();
if (did == 0)
{
qsminfo.RKEY = 0;
qsminfo.SERIALNO = qsmbll.GetSerialNo();
}
else
{
qsminfo = qsmbll.getQSMInfoByrkey(did);
if (qsminfo.STATUS == 14)
{
string strTemp = qsminfo.SERIALNO;
qsminfo = new QSMInfo();
qsminfo.RKEY = did;
qsminfo.SERIALNO = strTemp;
}
}
qsminfo.ENT_DATE = DateTime.Now;
qsminfo.ENT_USER = CurrentUser.UserADAcount;
qsminfo.CUST_CODE = CustCode.Value;
qsminfo.CUST_NAME = CustName.Text;
qsminfo.FACTORY_NAME = factoryList.SelectedItem.Text;
try { qsminfo.HAPPEN_DATE = Convert.ToDateTime(Happen_Date.Text); }
catch { qsminfo.HAPPEN_DATE = DateTime.Now; }
qsminfo.CUST_MATERIALNO = cust_MaterialNo.Text;
qsminfo.INTERALNO = interalNo.Text;
try { qsminfo.REQUIRE_DATE = Convert.ToDateTime(require_Date.Text); }
catch { }
qsminfo.TOUSU_LEVEL = tousu_level.SelectedItem.Text;
qsminfo.TOUSU_TYPE = tousu_type.SelectedItem.Text;
try { qsminfo.CHUHUO_QTY = decimal.Parse(chuhuo_qty.Text); }
catch { qsminfo.CHUHUO_QTY = 0; }
try { qsminfo.JIANCHA_QTY = decimal.Parse(jiancha_qty.Text); }
catch { qsminfo.JIANCHA_QTY = 0; }
try { qsminfo.BULIANG_QTY = decimal.Parse(buliang_qty.Text); }
catch { qsminfo.BULIANG_QTY = 0; }
try
{
qsminfo.BULIANGBILI = decimal.Parse(buliangbili.Text.Trim().Replace("%", ""));
}
catch { qsminfo.BULIANGBILI = 0; }
qsminfo.BULIANGDC = buliangDC.Text;
try { qsminfo.ZAIXIAN_QTY = decimal.Parse(zaixian_qty.Text); }
catch { qsminfo.ZAIXIAN_QTY = 0; }
try { qsminfo.KUCUN_QTY = decimal.Parse(kucun_qty.Text); }
catch { qsminfo.KUCUN_QTY = 0; }
if (tuihuo_status_ck1.Checked == true)
{
qsminfo.TUIHUO_STATUS = 0;
qsminfo.TUIHUO_QTY = 0;
}
else if (tuihuo_status_ck2.Checked == true)
{
qsminfo.TUIHUO_STATUS = 1;
try { qsminfo.TUIHUO_QTY = decimal.Parse(tuihuo_qty.Text); }
catch { qsminfo.TUIHUO_QTY = 0; }
}
qsminfo.HAPPEN_ADDRESS = int.Parse(happen_address.SelectedValue);
if (tijiao_status_ck1.Checked == true)
{
qsminfo.TIJIAO_STATUS = 0;
}
else if (tijiao_status_ck2.Checked == true)
{
qsminfo.TIJIAO_STATUS = 1;
if (tijiao_type_ck1.Checked == true)
{
qsminfo.TIJIAO_TYPE = 1;
}
else if (tijiao_type_ck2.Checked == true)
{
qsminfo.TIJIAO_TYPE = 2;
}
else if (tijiao_type_ck3.Checked == true)
{
qsminfo.TIJIAO_TYPE = 3;
}
}
qsminfo.NOTES = notes.Text;
qsminfo.CAR_CONTENT = CAR_Content.Text;
qsminfo.STATUS = status;
int a = 0;
if (did == 0)
{
a = qsmbll.add(qsminfo);
}
else
{
a = qsmbll.Update(qsminfo);
}
if (a != 0)
{
return(-1);
}
return(int.Parse(qsminfo.RKEY.ToString()));
}
