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