private static void mailDetail(int usrId, string strProjetTag, string payNum, Xm_db xmDataCont) { //var usr_autority = //from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId //where (auth.UsrId == usrId || // auth.AuthorityId == 25) && // auth.UsrAuEnd > DateTime.Now //select usr; //int flag = 0x2000; var usr_autority = from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId where (usr.UsrId == usrId || ((usr.TotleAuthority & (UInt32)AuthAttributes.pay_receiptExamine) != 0)) && usr.EndTime > DateTime.Now //where (usr.UsrId == usrId || // usr.TotleAuthority.ToAuthAttr().HasOneFlag(AuthAttributes.pay_receiptExamine)) && // usr.EndTime > DateTime.Now select usr; foreach (var usr in usr_autority) { BeckSendMail.getMM().NewMail(usr.UsrEmail, "mis系统票务通知", strProjetTag + "的付款申请已完成" + payNum + ",请尽快完成后续工作"); } }
private void examine(string okOrNot) { if (inputCheck()) { DataRow sessionDr = Session["seldSelfReceipt"] as DataRow; string strReceiptId = sessionDr["receiptId"].ToString(); string strReceiptComment = txtReceiptComment.Text.Trim(); DataSet dst = new DataSet(); ReceiptApplyProcess rap = new ReceiptApplyProcess(dst); rap.SelfReceiptExamine(strReceiptId, okOrNot, strReceiptComment); Xm_db xmDataCont = Xm_db.GetInstance(); int usrId = int.Parse(sessionDr["usrId"].ToString()); var usrInfo = from usr in xmDataCont.Tbl_usr where usr.UsrId == usrId && usr.EndTime > DateTime.Now select usr; string projetTag = sessionDr["projectTag"].ToString(); if (okOrNot.Equals(bool.TrueString)) { //int flag = 0x80; var usr_autority = from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId where (usr.TotleAuthority & (UInt32)AuthAttributes.pay_receiptOk) != 0 && usr.EndTime > DateTime.Now select usr; //where usr.TotleAuthority.ToAuthAttr().HasOneFlag(AuthAttributes.pay_receiptOk) && // usr.EndTime > DateTime.Now //select usr; foreach (var usr in usr_autority) { BeckSendMail.getMM().NewMail(usr.UsrEmail, "mis系统票务通知", "开票申请已通过审批,请尽快完成后续工作" + System.Environment.NewLine + Request.Url.toNewUrlForMail("/Main/paymentReceiptManager/receiptOk.aspx")); } BeckSendMail.getMM().NewMail(usrInfo.First().UsrEmail, "mis系统票务通知", projetTag + "的开票申请已通过审批,请尽快完成后续工作"); } else { BeckSendMail.getMM().NewMail(usrInfo.First().UsrEmail, "mis系统票务通知", projetTag + "的开票申请暂缓,请尽快完成后续工作"); } Response.Redirect("~/Main/infoViewManager/receiptView.aspx"); } }
private static void sendMail(System.Nullable <int> mainContractId, IQueryable <View_mainContract_project_usr> ViewMainContract_project_usr) { var emailDetail = ViewMainContract_project_usr.First(elm => elm.MainContractId == mainContractId); string usrEmail = emailDetail.UsrEmail; string projectTag = emailDetail.ProjectTag; string num = emailDetail.SelfReceivingPercent.ToString("p"); //DataTable dtSources = projectStepEdit.Distinct().ToDataTable(); BeckSendMail.getMM().NewMail(usrEmail, "mis系统票务通知", projectTag + "项目总共收到客户付款额" + num); }
private static void sendMail(System.Nullable <int> mainContractId, Xm_db xmDataCont, string num) { var emailDetail = from mainContract in xmDataCont.Tbl_mainContract join project in xmDataCont.Tbl_projectTagInfo on mainContract.ProjectTagId equals project.ProjectTagId join applyment_user in xmDataCont.Tbl_applyment_user on project.ProjectTagId equals applyment_user.ProjectTagId join user in xmDataCont.Tbl_usr on applyment_user.UsrId equals user.UsrId where mainContract.MainContractId == mainContractId select new { user.UsrEmail, project.ProjectTag }; string usrEmail = emailDetail.First().UsrEmail; string projectTag = emailDetail.First().ProjectTag; //string num = emailDetail.SelfReceivingPercent.ToString("p"); //string num = ViewsSubContract_supplier.First(elm => elm.SubContractId == subContractId).ReceiptPercent.ToString("p"); //DataTable dtSources = projectStepEdit.Distinct().ToDataTable(); BeckSendMail.getMM().NewMail(usrEmail, "mis系统票务通知", projectTag + "项目总共收到客户付款额" + num); }
private void mailDetail(string accessOrNot, DataRow sessionDr, Xm_db xmDataCont) { //var usr_autority = //from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId //where auth.AuthorityId == 22 && // auth.UsrAuEnd > DateTime.Now //select usr; //int flag = 0x400; var usr_autority = from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId where (usr.TotleAuthority & (UInt32)AuthAttributes.productDetail) != 0 && usr.EndTime > DateTime.Now select usr; //where usr.TotleAuthority.ToAuthAttr().HasOneFlag(AuthAttributes.productDetail) && // usr.EndTime > DateTime.Now //select usr; string strProductTag = sessionDr["productTag"].ToString(); string strProductName = sessionDr["productName"].ToString(); string strAccessOrNot = string.Empty; if (accessOrNot.Equals(bool.TrueString)) { strAccessOrNot = "检验通过"; } else { strAccessOrNot = "检验未通过"; } foreach (var usr in usr_autority) { BeckSendMail.getMM().NewMail(usr.UsrEmail, "mis系统货物检验通知", "编号为" + strProductTag + "的" + strProductName + strAccessOrNot + ",等待您为其定义产品属性" + System.Environment.NewLine + Request.Url.toNewUrlForMail("/Main/stockInfoManager/productStockView/productStockDetail.aspx")); } }
private void applyOk(string num, Xm_db xmDataCont) { //int flag = 0x2000; var usr_autority = from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId where (usr.TotleAuthority & (UInt32)AuthAttributes.pay_receiptExamine) != 0 && usr.EndTime > DateTime.Now select usr; //where usr.TotleAuthority.ToAuthAttr().HasOneFlag(AuthAttributes.pay_receiptExamine) && // usr.EndTime > DateTime.Now //select usr; foreach (var usr in usr_autority) { BeckSendMail.getMM().NewMail(usr.UsrEmail, "mis系统票务审批通知", "申请付款" + num + System.Environment.NewLine + Request.Url.toNewUrlForMail("/Main/infoViewManager/paymentInfo/paymentView.aspx")); } Response.Redirect("~/Main/paymentReceiptManager/paymentApply.aspx"); }
protected void btnOk_Click(object sender, EventArgs e) { GridViewRow gvr = selfReceiptGV.SelectedRow; int index = gvr.DataItemIndex; DataTable dt = Session["dtSources"] as DataTable; string strReceiptId = dt.Rows[index]["receiptId"].ToString(); int usrId = int.Parse(dt.Rows[index]["usrId"].ToString()); string projetTag = dt.Rows[index]["projectTag"].ToString(); //string receiptNum = dt.Rows[index]["receiptPercent"].ToString(); string strReceiptPercent = dt.Rows[index]["receiptPercent"].ToString(); string strMainContractId = dt.Rows[index]["mainContractId"].ToString(); string strProjetTagId = dt.Rows[index]["projectTagId"].ToString(); //string strFilter = // " receiptId = " + "'" + strReceiptId + "'"; //dt.DefaultView.RowFilter = strFilter; //DataTable doneTable = dt.DefaultView.ToTable("addTable"); //dt.Clear(); //ReceiptApplyProcess rap = Session["ReceiptApplyProcess"] as ReceiptApplyProcess; //rap.MyDst.Tables.Add(doneTable); //rap.SelfReceiptDone(); Xm_db xmDataCont = Xm_db.GetInstance(); int receiptId = int.Parse(strReceiptId); float receiptPercent = float.Parse(strReceiptPercent); int mainContractId = int.Parse(strMainContractId); int projectTagId = int.Parse(strProjetTagId); string receiptNum = receiptPercent.ToString("p"); xmDataCont.SelfReceipt_done(receiptId, receiptPercent, mainContractId, projectTagId); //var usr_autority = // from usr in xmDataCont.Tbl_usr // join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId // where (auth.UsrId == usrId || // auth.AuthorityId == 25) && // auth.UsrAuEnd > DateTime.Now // select usr; //int flag = 0x2000; var usr_autority = from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId where (usr.UsrId == usrId || ((usr.TotleAuthority & (UInt32)AuthAttributes.pay_receiptExamine) != 0)) && usr.EndTime > DateTime.Now select usr; //where (usr.UsrId == usrId || // usr.TotleAuthority.ToAuthAttr().HasOneFlag(AuthAttributes.pay_receiptExamine)) && // usr.EndTime > DateTime.Now //select usr; foreach (var usr in usr_autority) { BeckSendMail.getMM().NewMail(usr.UsrEmail, "mis系统票务通知", projetTag + "的开票申请已完成" + receiptNum + ",请尽快完成后续工作"); } var viewMainReceipt = from mainReceipt in xmDataCont.View_mainReceipt where mainReceipt.EndTime > DateTime.Now && mainReceipt.IsAccept.Equals(bool.TrueString) && mainReceipt.DoneTime > DateTime.Now select mainReceipt; DataTable taskTable = viewMainReceipt.ToDataTable(); //rap.RealSelfReceiptView(); //DataTable taskTable = rap.MyDst.Tables["view_mainReceipt"].DefaultView.ToTable(); //string end = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss.fff"); //strFilter = // " isAccept = " + "'" + bool.TrueString + "'" + // " and doneTime > " + "'" + end + "'"; string strFilter = string.Empty; dt_modify(taskTable, strFilter); Session["dtSources"] = taskTable.DefaultView.ToTable(); selfReceiptGV.SelectedIndex = -1; selfReceiptGV.Enabled = true; selfReceiptGV.Columns[12].Visible = true; selfReceiptGV.DataSource = Session["dtSources"]; selfReceiptGV.DataBind(); btnOk.Visible = false; btnNo.Visible = false; }
protected void btnOk_Click(object sender, EventArgs e) { if (inputCheck()) { string strProductId = ddlProduct.SelectedValue; string strProductTag = txtProductTag.Text.Trim(); string strSupplierId = ddlSupplier.SelectedValue; string strUsrId = ddlEngineer.SelectedValue; DataRow productInRow = null; DataColumn colProductId = new DataColumn("productId", System.Type.GetType("System.String")); DataColumn colProductTag = new DataColumn("productTag", System.Type.GetType("System.String")); DataColumn colSupplierId = new DataColumn("supplierId", System.Type.GetType("System.String")); DataColumn colUsrId = new DataColumn("usrId", System.Type.GetType("System.String")); DataTable productInTable = new DataTable("addTable"); productInTable.Columns.Add(colProductId); productInTable.Columns.Add(colProductTag); productInTable.Columns.Add(colSupplierId); productInTable.Columns.Add(colUsrId); productInRow = productInTable.NewRow(); productInRow["productId"] = strProductId; productInRow["productTag"] = strProductTag; productInRow["supplierId"] = strSupplierId; productInRow["usrId"] = strUsrId; productInTable.Rows.Add(productInRow); #region dataset DataSet dataSet = new DataSet(); dataSet.Tables.Add(productInTable); #endregion ProductStockProcess psp = new ProductStockProcess(dataSet); //psp.DoCheckProductStock(); //int rowRtn = psp.IntRtn; string error = psp.Add_includeError(); if (string.IsNullOrEmpty(error)) { Xm_db xmDataCont = Xm_db.GetInstance(); int usrId = int.Parse(strUsrId); var usrInfo = from usr in xmDataCont.Tbl_usr where usr.UsrId == usrId && usr.EndTime > DateTime.Now select usr; string strProductName = ddlProduct.SelectedItem.Text; BeckSendMail.getMM().NewMail(usrInfo.First().UsrEmail, "mis系统入库通知", "编号为" + strProductTag + "的" + strProductName + "等待您的校验" + System.Environment.NewLine + Request.Url.toNewUrlForMail("/Main/stockInfoManager/productCheckView.aspx")); Response.Redirect("~/Main/DefaultMainSite.aspx"); } else { this.txtProductTag.Text = error; } } }
protected void outView_Click(object sender, EventArgs e) { GridViewRow gvr = (sender as LinkButton).Parent.Parent as GridViewRow; int index = gvr.DataItemIndex; DataTable dt = Session["view_project_need_product"] as DataTable; string projectTagId = dt.Rows[index]["projectTagId"].ToString(); string productPurposeRelationId = dt.Rows[index]["productPurposeRelationId"].ToString(); string subContractProductId = dt.Rows[index]["subContractProductId"].ToString(); string productStockId = dt.Rows[index]["productStockId"].ToString(); string strProductName = dt.Rows[index]["productName"].ToString(); string strProductTag = dt.Rows[index]["productTag"].ToString(); DataSet ds = new DataSet(); ds.Tables.Add(dt.DefaultView.ToTable("addTable")); SellProductProcess spp = new SellProductProcess(ds); spp.MyDst.Tables["addTable"].Clear(); DataRow dr = spp.MyDst.Tables["addTable"].NewRow(); dr["projectTagId"] = projectTagId; dr["productPurposeRelationId"] = productPurposeRelationId; dr["subContractProductId"] = subContractProductId; dr["productStockId"] = productStockId; spp.MyDst.Tables["addTable"].Rows.Add(dr); dt.Clear(); spp.Add(); Xm_db xmDataCont = Xm_db.GetInstance(); //var usr_autority = // from usr in xmDataCont.Tbl_usr // join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId // where auth.AuthorityId == 20 && // auth.UsrAuEnd > DateTime.Now // select usr; //int flag = 0x100; var usr_autority = from usr in xmDataCont.Tbl_usr //join auth in xmDataCont.View_usr_autority on usr.UsrId equals auth.UsrId where (usr.TotleAuthority & (UInt32)AuthAttributes.stockManager) != 0 && usr.EndTime > DateTime.Now select usr; //where usr.TotleAuthority.ToAuthAttr().HasOneFlag(AuthAttributes.stockManager) && // usr.EndTime > DateTime.Now //select usr; foreach (var usr in usr_autority) { BeckSendMail.getMM().NewMail(usr.UsrEmail, "mis系统出货准备通知", "编号为" + strProductTag + "的" + strProductName + ",等待您为其办理出货手续" + System.Environment.NewLine + Request.Url.toNewUrlForMail("/Main/stockInfoManager/productStockView/productStockDetail.aspx")); } lblNoOut.Visible = false; btnNullRtn.Visible = false; sellProductGV.Visible = true; projectNeedGV.Visible = false; ProductPurposeRelationProcess pprpView = Session["ProductPurposeRelationProcess"] as ProductPurposeRelationProcess; pprpView.RealProductPurposeRelationView(); DataTable productStockRelationTable = pprpView.MyDst.Tables["view_productStockRelation"].DefaultView.ToTable(); string strFilter = " productPurpose = " + "'" + "forSell".ToString() + "'"; productStockRelationTable.DefaultView.RowFilter = strFilter; Session["dtSources"] = productStockRelationTable.DefaultView.ToTable(); sellProductGV.DataSource = Session["dtSources"]; sellProductGV.DataBind(); }