protected void Button1_Click(object sender, EventArgs e) { VPBLL.Vendor.VenderHelper vhelp = new VPBLL.Vendor.VenderHelper(); List<VPBLL.Vendor.ABiVendor> vendorList = vhelp.getABiVendor(this.vendorName.Value, this.taxNumber.Value); if (vendorList != null && vendorList.Count > 0) { VPBLL.Vendor.ABiVendor vendor = vendorList[0]; VPBLL.Users.UsersHelper uhelp = new VPBLL.Users.UsersHelper(); List<VPBLL.Users.ABiAdminUsers>userList=uhelp.getUsers(vendor.VendorCode); if (userList != null && userList.Count > 0) { VPBLL.Users.ABiAdminUsers user = VPBLL.Users.ABiAdminUsers.FromABiVendor(vendor); VPBLL.Users.ABiAdminUsers user1 = userList[0]; user.ABi_Admin_Users_ID = user1.ABi_Admin_Users_ID; user.Password = user.Password.Substring(user.Password.Length - 6, 6); user.PwdLastChanged = user.PwdLastChanged.AddDays(-91); uhelp.updateUsersPassWord(user, true); ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('密码初始化成功,请尽快修改密码');</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('该供应商未开设帐号');</script>"); } } else { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('无相关信息');</script>"); } }
protected void btnDVDeactive_Click(object sender, EventArgs e) { int nRet = new VPBLL.Vendor.VenderHelper().DeactiveVendor(lblDVVendorCode.Text, UserID); if (nRet > 0) { lblDVErrorMessage.Text = "供应商状态更新成功"; lblDVErrorMessage.ForeColor = System.Drawing.Color.Green; lblDVErrorMessage.Visible = true; var vendor = new VPBLL.Vendor.VenderHelper().getVendor(lblDVVendorCode.Text); if (vendor != null) { lblDVVendorCode.Text = vendor.VendorCode; lblDVVendorName.Text = vendor.VendorName; lblDVTaxNumber.Text = vendor.TaxNumber; lblDVIndustryCode.Text = vendor.IndustryCode; cbDVIsActive.Checked = vendor.Active == "1"; btnDVDeactive.Enabled = cbDVIsActive.Checked; } } else if (nRet == -1) { lblDVErrorMessage.Text = "未找到该供应商"; lblDVErrorMessage.ForeColor = System.Drawing.Color.Red; lblDVErrorMessage.Visible = true; } else if (nRet == -2) { lblDVErrorMessage.Text = "未找到该供应商用户,该供应商未激活或不存在!"; lblDVErrorMessage.ForeColor = System.Drawing.Color.Red; lblDVErrorMessage.Visible = true; } }
protected void Button1_Click(object sender, EventArgs e) { VPBLL.Company.CompanyHelper cHelper = new VPBLL.Company.CompanyHelper(); VPBLL.Vendor.VenderHelper vHelper=new VPBLL.Vendor.VenderHelper(); List<VPBLL.Company.ABiCompany> companyList = cHelper.getCompanyByCode(this.companyCode.Value); if (companyList != null && companyList.Count > 0)//判定是否有该公司 { List<VPBLL.Vendor.ABiVendor> vendorList = vHelper.getABiVendorByCode(this.vendorCode.Value); if (vendorList == null || vendorList.Count == 0) { VPBLL.Vendor.ABiVendor vendor = new VPBLL.Vendor.ABiVendor(); vendor.VendorCode = this.vendorCode.Value; vendor.VendorName = this.vendorName.Value; vendor.TaxNumber = this.taxNumber.Value; vendor.IndustryCode = this.industryCode.Value; vendor.DateCreated = Convert.ToDateTime(DateTime.Now); vendor.DateModified = Convert.ToDateTime(DateTime.Now); vendor.Blocking = ""; vendor.Deletion = ""; vHelper.addVendor(vendor);//保存vendor vendorList = vHelper.getABiVendorByCode(this.vendorCode.Value);//获取到新的venderID vendor = vendorList[0]; VPBLL.Vendor.AbiBankAccount bank = new VPBLL.Vendor.AbiBankAccount(); bank.ABi_Vendor_ID = vendor.ABi_Vendor_ID; bank.BankCode = this.bankCode.Value; bank.BankName = this.bankName.Value; bank.BankAccount = this.bankAccount.Value; bank.ReceiverName = this.receiverName.Value; vHelper.addBankAccount(bank); VPBLL.Company.ABiCompany company = companyList[0]; VPBLL.Vendor.ABiVendor_Company vendor_Company = new VPBLL.Vendor.ABiVendor_Company(); vendor_Company.ABi_Vendor_ID = vendor.ABi_Vendor_ID; vendor_Company.ABi_Company_ID = Convert.ToInt32(company.ID); vendor_Company.Blocking =""; vendor_Company.Deletion = ""; vendor_Company.PaymentTerm = this.paymentTerm.Value; vHelper.addVendorCompany(vendor_Company); ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('保存成功');back();</script>"); } else ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('该供应商已存在')</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('该公司编号无效')</script>"); } }
private void Bind() { if (Request.QueryString["vendorCode"] != null && string.IsNullOrEmpty(Request.QueryString["vendorCode"].ToString()) == false) { VPBLL.Vendor.VenderHelper vhelp = new VPBLL.Vendor.VenderHelper(); List<VPBLL.Vendor.ABiVendor> vendorList = vhelp.getABiVendorByCode(Request.QueryString["vendorCode"].ToString()); if(vendorList!=null&&vendorList.Count>0) { VPBLL.Vendor.ABiVendor vendor=vendorList[0]; VPBLL.Users.ABiAdminUsers users=VPBLL.Users.ABiAdminUsers.FromABiVendor(vendor); VPBLL.Users.UsersHelper uhelp=new VPBLL.Users.UsersHelper(); if (String.IsNullOrEmpty(users.Password) || users.Password.Length <= 6) { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('纳税人识别号为空或不正确');back();</script>"); return; } //users.Password = users.Password.Substring(users.Password.Length - 6, 6); uhelp.addUsers(users);//添加帐户 vendor.Active = "1"; vhelp.updateVendorActive(vendor);//标识该vendor已经激活 List<VPBLL.Users.ABiAdminUsers> uList = uhelp.getUsers(users.Username); if (uList != null && uList.Count > 0) { users = uList[0]; VPBLL.Roles.ABiAdminUsersRoles roles = new VPBLL.Roles.ABiAdminUsersRoles(); roles.ABi_Admin_Users_ID = users.ABi_Admin_Users_ID; roles.ABi_Admin_Roles_ID = 4; VPBLL.Roles.AdminUsersRolesHelper rhelp = new VPBLL.Roles.AdminUsersRolesHelper(); rhelp.addUsersRoles(roles); ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('帐号添加成功');back();</script>"); } else ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('用户添加失败');back();</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('未知的编号');back();</script>"); } } else { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('非正常请求');back();</script>"); } }
public void ProcessRequest(HttpContext context) { try { int userId = -1; int roleId = -1; String strUId = context.Request.QueryString["apiuid"]; String strRId = context.Request.QueryString["apirid"]; if (!String.IsNullOrEmpty(strUId) && !String.IsNullOrEmpty(strRId)) { userId = int.Parse(strUId); roleId = int.Parse(strRId); } else { VPBLL.BasePage bp = new VPBLL.BasePage(); bp.CheckUser(HttpContext.Current.Request.Cookies["LastLogin"], context); userId = bp.UserID; roleId = bp.RoleID; } String act = context.Request.QueryString["act"]; bool bExport = ("1" == context.Request.QueryString["be"]); VPBLL.DataTable.FormatedList fl = new VPBLL.DataTable.FormatedList(); switch (act) { case "1"://GRReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.GR.ABiGR>(context.Request); var helper = new VPBLL.GR.GRHelper(); var list = helper.GetGR(new VPBLL.GR.GRHelper.QueryCondition() { GRNumber = context.Request.QueryString["gn"], MoveType = context.Request.QueryString["mt"], VendorCode = context.Request.QueryString["vc"], PONumber = context.Request.QueryString["pn"], DateStart = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), UserID = userId, IsExport = bExport, RoleID = roleId }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "2": //GRIVReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.GR.ABiGRIV>(context.Request); var helper = new VPBLL.GR.GRHelper(); var list = helper.GetGRIV(new VPBLL.GR.GRHelper.QueryCondition() { IVNumber = context.Request.QueryString["iv"], VendorCode = context.Request.QueryString["vc"], DateStart = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), PONumber = context.Request.QueryString["pn"], UserID = userId, IsExport = bExport }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "3": //POReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.PO.ABiPO>(context.Request); var helper = new VPBLL.PO.POHelper(); var list = helper.getPO(new VPBLL.PO.POHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], CompanyName = context.Request.QueryString["cn"], VendorCode = context.Request.QueryString["vc"], MeterialNumber = context.Request.QueryString["mn"], PONumber = context.Request.QueryString["pn"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), UserID = userId, IsExport = bExport, RoleID = roleId }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "4": //POIVReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.PO.ABiPOIV>(context.Request); var helper = new VPBLL.PO.POHelper(); var list = helper.getPOIV(new VPBLL.PO.POHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], CompanyName = context.Request.QueryString["cn"], VendorCode = context.Request.QueryString["vc"], MeterialNumber = context.Request.QueryString["mn"], PONumber = context.Request.QueryString["pn"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), UserID = userId, IsExport = bExport }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "5": //POStatusReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.PO.ABiPOStatus>(context.Request); var helper = new VPBLL.PO.POHelper(); var list = helper.getPOStatus(new VPBLL.PO.POHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], CompanyName = context.Request.QueryString["cn"], VendorCode = context.Request.QueryString["vc"], MeterialNumber = context.Request.QueryString["mn"], PONumber = context.Request.QueryString["pn"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), UserID = userId, IsExport = bExport }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "6": //IVReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.IV.ABiIV>(context.Request); var helper = new VPBLL.IV.IVHelper(); var list = helper.getIV(new VPBLL.IV.IVHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], VendcorName = context.Request.QueryString["vn"], VendorCode = context.Request.QueryString["vc"], InvoiceNumber = context.Request.QueryString["in"], IsTolerance = context.Request.QueryString["it"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), PaymentStatus = context.Request.QueryString["ps"], UserID = userId, IsExport = bExport, RoleID = roleId }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "7": //IVCompletedReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.IV.ABiIVCompleted>(context.Request); var helper = new VPBLL.IV.IVHelper(); var list = helper.getIVCompleted(new VPBLL.IV.IVHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], VendcorName = context.Request.QueryString["vn"], VendorCode = context.Request.QueryString["vc"], InvoiceNumber = context.Request.QueryString["in"], IsTolerance = context.Request.QueryString["it"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), UserID = userId, IsExport = bExport }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "8": //IVPendingReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.IV.ABiIVPending>(context.Request); var helper = new VPBLL.IV.IVHelper(); var list = helper.getIVPending(new VPBLL.IV.IVHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], VendcorName = context.Request.QueryString["vn"], VendorCode = context.Request.QueryString["vc"], InvoiceNumber = context.Request.QueryString["in"], IsTolerance = context.Request.QueryString["it"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToDateTime(context.Request.QueryString["ed"]), Buys = context.Request.QueryString["b"], UserID = userId, IsExport = bExport }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "9": //GR_NewIV.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.GR.ABiNewIV>(context.Request); var helper = new VPBLL.GR.GRHelper(); var list = helper.getNewIV(new VPBLL.GR.GRHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], GRNumber = context.Request.QueryString["gn"], PONumber = context.Request.QueryString["pn"], DateStart = ToDateTime(context.Request.QueryString["ds"]), DateEnd = ToDateTime(context.Request.QueryString["de"]), PODateStart = ToDateTime(context.Request.QueryString["pds"]), PODateEnd = ToDateTime(context.Request.QueryString["pde"]), VendorCode = context.Request.QueryString["vc"], UserID = userId, IsExport = bExport, RoleID = roleId }); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "10": //IVRemark.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.IV.ABiIVRemark>(context.Request); var helper = new VPBLL.IV.IVHelper(); int invoiceId; if (int.TryParse(context.Request.QueryString["id"], out invoiceId)) { var list = helper.getIVRemarkGR(invoiceId, userId); fl = parser.Parse(list.AsQueryable(), bExport); } } break; case "11": //IVDetail.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.IV.ABiIVDetail>(context.Request); var helper = new VPBLL.IV.IVHelper(); int invoiceId; if (int.TryParse(context.Request.QueryString["id"], out invoiceId)) { var list = helper.getInvoiceDetail(invoiceId, userId); fl = parser.Parse(list.AsQueryable(), bExport); } } break; case "21"://VendorCompanyReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.Vendor.ABiVendorCompany>(context.Request); var helper = new VPBLL.Vendor.VenderHelper(); string seachCode = context.Request.QueryString["vc"]; if (roleId == 4) { VPBLL.Users.UsersHelper uhelper = new VPBLL.Users.UsersHelper(); List<VPBLL.Users.ABiAdminUsers> uList = uhelper.getUsersByID(userId); if (uList != null && uList.Count > 0) { seachCode = uList[0].Username; } } var list = helper.getABiVendorCompany(new VPBLL.Vendor.VenderHelper.QueryCondition() { VendorCode = seachCode, VendorName = context.Request.QueryString["vn"], TaxNumber = context.Request.QueryString["tn"], CompanyCode = context.Request.QueryString["cc"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToMaxDateTime(context.Request.QueryString["ed"]), //DateBegin = Convert.ToDateTime("2001-01-01 00:00:00"), //DateEnd = Convert.ToDateTime("2020-01-01 00:00:00"), UserID=userId, RoleID=roleId }); list.AsQueryable(); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "22"://CompanyReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.Company.ABiCompany>(context.Request); var helper = new VPBLL.Company.CompanyHelper(); var list = helper.getABiCompany(new VPBLL.Company.CompanyHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], CompanyName = context.Request.QueryString["cn"], }); list.AsQueryable(); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "23"://PlantReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.Plant.ABiPlant>(context.Request); var helper = new VPBLL.Plant.PlantHelper(); var list = helper.getABiPlant(new VPBLL.Plant.PlantHelper.QueryCondition() { PlantCode = context.Request.QueryString["pc"] }); list.AsQueryable(); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "24"://VendorActiveReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.Vendor.ABiVendorReport>(context.Request); var helper = new VPBLL.Vendor.VenderHelper(); var list = helper.getABiVendorActive(new VPBLL.Vendor.VenderHelper.QueryCondition() { VendorCode = context.Request.QueryString["vc"], VendorName = context.Request.QueryString["vn"], TaxNumber = context.Request.QueryString["tn"], DateBegin = ToDateTime(context.Request.QueryString["sd"]), DateEnd = ToMaxDateTime(context.Request.QueryString["ed"]) //DateBegin = Convert.ToDateTime("2001-01-01 00:00:00"), //DateEnd = Convert.ToDateTime("2020-01-01 00:00:00") }); list.AsQueryable(); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "25"://UsersReport.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.Users.ABiUsersRoles>(context.Request); var helper = new VPBLL.Users.UsersHelper(); string UserName = context.Request.QueryString["un"]; var list = helper.getABiUsersRoles(new VPBLL.Users.UsersHelper.QueryCondition() { UserName = context.Request.QueryString["un"], Name = context.Request.QueryString["nm"], Status = context.Request.QueryString["st"], ABi_Admin_Roles_ID = context.Request.QueryString["ro"] }); list.AsQueryable(); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "26"://UsersCompany.aspx { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.Users.UsersCompany>(context.Request); var helper = new VPBLL.Company.CompanyHelper(); var list = helper.getUsersCompany(new VPBLL.Company.CompanyHelper.QueryCondition() { CompanyCode = context.Request.QueryString["cc"], CompanyName = context.Request.QueryString["cn"], ABi_Admin_Users_ID = context.Request.QueryString["Admin_Users_ID"], Type = context.Request.QueryString["type"] }); list.AsQueryable(); fl = parser.Parse(list.AsQueryable(), bExport); } break; case "30": { var parser = new VPBLL.DataTable.DataTableParser<VPBLL.Vendor.ABiVendor>(context.Request); var helper = new VPBLL.Vendor.VenderHelper(); String cc = context.Request.QueryString["cc"]; String ia = context.Request.QueryString["ia"]; String hi = context.Request.QueryString["hi"]; var list = helper.getVenders(ia, cc, hi); list.AsQueryable(); fl = parser.Parse(list.AsQueryable(), bExport); } break; } if (fl != null) { if (!bExport) { context.Response.ContentType = "application/json"; context.Response.Write(fl.ToJSON()); } else { context.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); context.Response.ContentType = "application/ms-excel"; context.Response.Charset = "GB2312"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode("export" + ".xls", System.Text.Encoding.GetEncoding("GB2312")).ToString()); context.Response.Write(fl.ToCVS()); } } } catch (Exception ex) { logger.LogError("", ex); } }
protected void ImageButton1_Click(object sender, EventArgs e) { string userName = this.userName.Value; string passWord = this.userPwd.Value; VPBLL.Users.UsersHelper helper = new VPBLL.Users.UsersHelper(); #if DEBUG List<VPBLL.Users.ABiAdminUsers> list = helper.getUsers(userName); #else List<VPBLL.Users.ABiAdminUsers> list = helper.getUsers(userName, passWord); #endif if (list != null && list.Count > 0 && list[0].Status) { VPBLL.Users.ABiAdminUsers user = list[0]; if (user.LoginStatus == "1" && user.LastLogin >= DateTime.Now.AddMinutes(-15)&&user.IPAddress!=Request.UserHostAddress) { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('该帐号处于登陆状态')</script>"); } else { VPBLL.Roles.AdminUsersRolesHelper roleHelper = new VPBLL.Roles.AdminUsersRolesHelper(); List<VPBLL.Roles.ABiAdminUsersRoles> roleList = roleHelper.getUsersRolesByUserID(user.ABi_Admin_Users_ID); if (roleList != null && roleList.Count > 0) { user.LoginStatus = "1"; user.LastLogin = DateTime.Now; user.IPAddress = Request.UserHostAddress; helper.updateUsersLastLogin(user); //保存userID到cookie HttpCookie newcookie = new HttpCookie("UserID"); newcookie.Value = user.ABi_Admin_Users_ID.ToString(); newcookie.Expires = DateTime.Now.AddHours(1); Response.Cookies.Add(newcookie); //Session["UserID"] = user.ABi_Admin_Users_ID; //保存userName到cookie newcookie = new HttpCookie("Name"); newcookie.Value = Server.UrlEncode(user.Name); newcookie.Expires = DateTime.Now.AddHours(1); Response.Cookies.Add(newcookie); //Session["Name"] = Server.UrlEncode(user.Name); //保存LastLogin到cookie user.LastLogin = DateTime.Now; newcookie = new HttpCookie("LastLogin"); newcookie.Value = user.LastLogin.ToString(); newcookie.Expires = DateTime.Now.AddHours(1); Response.Cookies.Add(newcookie); helper.updateUsersLastLogin(user); //Session["LastLogin"] = user.LastLogin.ToString(); //保存角色编号 VPBLL.Roles.ABiAdminUsersRoles role = roleList[0]; newcookie = new HttpCookie("RoleID"); newcookie.Value = role.ABi_Admin_Roles_ID.ToString(); newcookie.Expires = DateTime.Now.AddHours(1); Response.Cookies.Add(newcookie); //Session["RoleID"] = role.ABi_Admin_Roles_ID; newcookie = new HttpCookie("NeedResetPwd"); newcookie.Value = user.NeedResetPwd.ToString(); newcookie.Expires = DateTime.Now.AddHours(1); Response.Cookies.Add(newcookie); //Session["NeedResetPwd"] = user.NeedResetPwd; String warningMsg = ""; String act = "0"; if (role.ABi_Admin_Roles_ID == 4) {//Vendor int nPendGRCount = new VPBLL.GR.GRHelper().getGRNewIVCount(user.ABi_Admin_Users_ID); if (nPendGRCount > 0) { //warningMsg = String.Format("您有{0}收货待开发票,为确保付款及时性,发票请于付款到期日至少45自然日前送达BSC(付款到期日=发票开票日与PO收货日孰晚+账期)"); warningMsg = String.Format("您有{0}收货待开发票,为确保付款及时性,发票请于付款到期日至少45自然日前送达BSC(付款到期日=发票开票日与PO收货日孰晚+账期)", nPendGRCount); act = "4"; } } else if (role.ABi_Admin_Roles_ID == 1) { int inactiveVendorCount = new VPBLL.Vendor.VenderHelper().getInactiveVendorCount(); if (inactiveVendorCount > 0) { warningMsg = String.Format("您有{0}供应商待激活", inactiveVendorCount); act = "1"; } } ScriptManager.RegisterStartupScript(Page, GetType(), "", String.Format("ValidateIEversion('Index.aspx', '{0}', {1},'{2}');", warningMsg, role.ABi_Admin_Roles_ID,act), true); } else { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('该帐户未授权')</script>"); } } } else { if (list != null && list.Count > 0 && !list[0].Status) { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('用户未激活,请与管理员联系')</script>"); } else { ClientScript.RegisterStartupScript(GetType(), "alertpwd", "<script>alert('您必须指定一个有效的用户名和密码')</script>"); } } }
public override DataSet Import(System.Data.DataSet ds) { var failedRows = new DataSet(); if (ds != null && ds.Tables.Count > 0) { DataTable dtFailed = new DataTable("Failed_Imported"); DataColumn[] columns = new DataColumn[ds.Tables[0].Columns.Count + 1]; for (int i = 0; i < ds.Tables[0].Columns.Count; ++i) { columns[i] = new DataColumn(ds.Tables[0].Columns[i].ColumnName); } columns[ds.Tables[0].Columns.Count] = new DataColumn("错误原因"); dtFailed.Columns.AddRange(columns); BuildHeader(ds.Tables[0].Columns); VPBLL.Vendor.VenderHelper vHelper = new VPBLL.Vendor.VenderHelper(); VPBLL.Vendor.ABiVendor vendor = new VPBLL.Vendor.ABiVendor(); VPBLL.Company.CompanyHelper cHelper = new VPBLL.Company.CompanyHelper(); for (int i = 0; i < ds.Tables[0].Rows.Count; ++i) { vendor.VendorCode = GetFieldValue(ds.Tables[0].Rows[i], "供应商代码").ToString(); vendor.VendorName = GetFieldValue(ds.Tables[0].Rows[i], "供应商名称").ToString(); List<VPBLL.Vendor.ABiVendor> vendorList = vHelper.getABiVendorByCode(vendor.VendorCode); string companyCode = GetFieldValue(ds.Tables[0].Rows[i], "公司代码").ToString(); List<VPBLL.Company.ABiCompany> companyList = cHelper.getCompanyByCode(companyCode); if (String.IsNullOrEmpty(vendor.VendorCode) || String.IsNullOrEmpty(vendor.VendorName)) { List<object> row = new List<object>(ds.Tables[0].Rows[i].ItemArray); row.Add(String.Format("供应商编号为空或供应商名称为空{0},{1}", vendor.VendorCode, vendor.VendorName)); dtFailed.Rows.Add(row.ToArray()); } else if(string.IsNullOrEmpty(companyCode)) { List<object> row = new List<object>(ds.Tables[0].Rows[i].ItemArray); row.Add(String.Format("公司编号为空{0},{1}", companyCode)); dtFailed.Rows.Add(row.ToArray()); } else if (companyList == null || companyList.Count == 0) { List<object> row = new List<object>(ds.Tables[0].Rows[i].ItemArray); row.Add(String.Format("未找到该公司{0},{1}", companyCode)); dtFailed.Rows.Add(row.ToArray()); } else { VPBLL.Company.ABiCompany company = companyList[0]; try { vendor.TaxNumber = GetFieldValue(ds.Tables[0].Rows[i], "纳税人识别号").ToString(); vendor.IndustryCode = GetFieldValue(ds.Tables[0].Rows[i], "所属行业").ToString(); vendor.DateCreated = Convert.ToDateTime(DateTime.Now); vendor.DateModified = Convert.ToDateTime(DateTime.Now); vendor.Blocking = ""; vendor.Deletion = ""; if (vendorList == null || vendorList.Count == 0)//新增vendor { vHelper.addVendor(vendor);//保存vendor vendorList = vHelper.getABiVendorByCode(vendor.VendorCode);//获取到新的venderID vendor = vendorList[0]; VPBLL.Vendor.AbiBankAccount bank = new VPBLL.Vendor.AbiBankAccount(); bank.ABi_Vendor_ID = vendor.ABi_Vendor_ID; bank.BankCode = GetFieldValue(ds.Tables[0].Rows[i], "供应商开户行").ToString(); bank.BankName = GetFieldValue(ds.Tables[0].Rows[i], "供应商开户名称").ToString(); bank.BankAccount = GetFieldValue(ds.Tables[0].Rows[i], "供应商银行帐号").ToString(); bank.ReceiverName = GetFieldValue(ds.Tables[0].Rows[i], "收款人名称").ToString(); vHelper.addBankAccount(bank); VPBLL.Vendor.ABiVendor_Company vendor_Company = new VPBLL.Vendor.ABiVendor_Company(); vendor_Company.ABi_Vendor_ID = vendor.ABi_Vendor_ID; vendor_Company.ABi_Company_ID = Convert.ToInt32(company.ID); vendor_Company.Blocking = ""; vendor_Company.Deletion = ""; vendor_Company.PaymentTerm = GetFieldValue(ds.Tables[0].Rows[i], "付款周期").ToString(); vHelper.addVendorCompany(vendor_Company); } else { vHelper.updateVendor(vendor); VPBLL.Vendor.AbiBankAccount bank = new VPBLL.Vendor.AbiBankAccount(); vendorList = vHelper.getABiVendorByCode(vendor.VendorCode);//获取到新的venderID vendor = vendorList[0]; bank.ABi_Vendor_ID = vendor.ABi_Vendor_ID; bank.BankCode = GetFieldValue(ds.Tables[0].Rows[i], "供应商开户行").ToString(); bank.BankName = GetFieldValue(ds.Tables[0].Rows[i], "供应商开户名称").ToString(); bank.BankAccount = GetFieldValue(ds.Tables[0].Rows[i], "供应商银行帐号").ToString(); bank.ReceiverName = GetFieldValue(ds.Tables[0].Rows[i], "收款人名称").ToString(); List<AbiBankAccount> bankList = vHelper.getABiBankAccount(bank.ABi_Vendor_ID, bank.BankCode); if (bankList == null || bankList.Count == 0) vHelper.addBankAccount(bank); else vHelper.updateBankAccount(bank); VPBLL.Vendor.ABiVendor_Company vendor_Company = new VPBLL.Vendor.ABiVendor_Company(); vendor_Company.ABi_Vendor_ID = vendor.ABi_Vendor_ID; vendor_Company.ABi_Company_ID = Convert.ToInt32(company.ID); vendor_Company.PaymentTerm = GetFieldValue(ds.Tables[0].Rows[i], "付款周期").ToString(); vHelper.addVendorCompany(vendor_Company); } } catch (Exception ex) { var row = new List<object>(ds.Tables[0].Rows[i].ItemArray); #if DEBUG row.Add(String.Format("出现异常错误:{0}", ex.Message)); #else row.Add(String.Format("出现异常错误")); #endif dtFailed.Rows.Add(row.ToArray()); logger.LogError(String.Format("Failed VendorImport({0},{1})", vendor.VendorCode, vendor.VendorName), ex); } } } failedRows.Tables.Add(dtFailed); } return failedRows; }
public void ProcessRequest(HttpContext context) { String act = ""; String resultMsg = ""; try { act = context.Request.Params["act"]; if (HttpContext.Current.Request.Cookies["UserID"] == null) { resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.User_Need_ReLogin, "登陆已失效,请重新登陆").ToMessage(); } else { int userId = Convert.ToInt32(HttpContext.Current.Request.Cookies["UserID"].Value); switch (act) { case "1": //GR_NewIV.aspx String refGRNumList = context.Request.Params["rgn"]; String refGRItemList = context.Request.Params["rgin"]; String invoiceNumber = context.Request.Params["ivn"]; String strInvoiceDate = context.Request.Params["ivd"]; String strTaxAmount = context.Request.Params["ivt"]; String strTotalAmount = context.Request.Params["iva"]; String strVendorRemark = context.Request.Params["vr"]; String poNumList = context.Request.Params["pn"]; String poINList = context.Request.Params["pin"]; DateTime invoiceDate = new DateTime(); double taxAmount; double totalAmount; if (String.IsNullOrEmpty(invoiceNumber) || !(!String.IsNullOrEmpty(strInvoiceDate) && DateTime.TryParse(strInvoiceDate, out invoiceDate)) || !(!String.IsNullOrEmpty(strTaxAmount) && double.TryParse(strTaxAmount, out taxAmount)) || !(!String.IsNullOrEmpty(strTotalAmount) && double.TryParse(strTotalAmount, out totalAmount))) { resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.New_Invoice_Error_IVInformation_Wrong, "发票输入信息不正确").ToMessage(); break; } if (String.IsNullOrEmpty(refGRItemList) || String.IsNullOrEmpty(refGRItemList) || String.IsNullOrEmpty(poNumList) || String.IsNullOrEmpty(poINList) || refGRItemList.Split(',').Length != refGRItemList.Split(',').Length) { resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.New_Invoice_Error_GRInformation_Wrong, "收货信息错误").ToMessage(); break; } var result = new VPBLL.GR.GRHelper().createNewIV(userId, refGRNumList, refGRItemList, poNumList, poINList, invoiceNumber, invoiceDate, taxAmount, totalAmount, strVendorRemark); resultMsg = result.ToMessage(); logger.LogInfo(String.Format("NewIV(userId:{0}, refGRNumbers:'{1}', refGRItemNumber'{2}', invoiceNumber:{3}, invoiceDate:{4}) = {5}", userId, refGRNumList, refGRItemList, invoiceNumber, invoiceDate, resultMsg)); if (result.ResponseCode == 1) { try { String subject = "开发票超容差,请备注"; String vendorCode = new VPBLL.Users.UsersHelper().getUsersByID(userId).First().Username; String vendorName = new VPBLL.Vendor.VenderHelper().getABiVendorByCode(vendorCode).First().VendorName; String content = new VPBLL.GR.GRHelper().GetEmailContent(int.Parse(result.ResponseMessage), 3, userId, invoiceNumber, vendorCode, vendorName); List<KeyValuePair<String, String>> buyers = new VPBLL.Vendor.VenderHelper().getBuyerOfCompany(result.ResponseMessage, 3); if (buyers.Count > 0) { var mh = new VPBLL.MailHelper(); mh.EmainSend((from o in buyers select o.Value).ToArray(), content, subject); } } catch (Exception ex) { logger.LogError(String.Format("开票超容差发送email失败"), ex); } } break; case "2": { VPBLL.BasePage bp = new VPBLL.BasePage(); if (bp.RoleID != 5) { resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.User_NoPermission, "用户无权限").ToMessage(); } else { String ivId = context.Request.Params["ivd"]; String payAmount = context.Request.Params["pa"]; String payDate = context.Request.Params["dp"]; String mdIV = context.Request.Params["in"]; resultMsg = new VPBLL.IV.IVHelper().updateInvoice(int.Parse(ivId), mdIV, DateTime.Parse(payDate), double.Parse(payAmount)).ToMessage(); logger.LogInfo(String.Format("updateInvoice(invoiceId'{0}', PayDate'{1}', PayAmount'{2}'). UserID:{3}", ivId, payDate, payAmount, bp.UserID)); } } break; case "3": { VPBLL.BasePage bp = new VPBLL.BasePage(); if (bp.RoleID != 5) { resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.User_NoPermission, "用户无权限").ToMessage(); } else { string grNumber = context.Request.Params["gn"]; string grItemNumber = context.Request.Params["gin"]; int nRow = new VPBLL.GR.GRHelper().deleteGR(grNumber, grItemNumber); resultMsg = String.Format("{0}&{1}", nRow > 0 ? 0 : -300, nRow.ToString()); logger.LogInfo(String.Format("deleteGR(userID={0}, grNumber={1}, grItemNumber={2}) = {3}", bp.UserID, grNumber, grItemNumber, nRow)); } } break; case "4": { VPBLL.BasePage bp = new VPBLL.BasePage(); if (bp.RoleID != 5) { resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.User_NoPermission, "用户无权限").ToMessage(); } else { string grNumber = context.Request.Params["pn"]; string grItemNumber = context.Request.Params["pin"]; int nRow = new VPBLL.PO.POHelper().deletePO(grNumber, grItemNumber); resultMsg = String.Format("{0}&{1}", nRow > 0 ? 0 : -300, nRow.ToString()); logger.LogInfo(String.Format("deleteGR(userID={0}, poNumber={1}, poItemNumber={2}) = {3}", bp.UserID, grNumber, grItemNumber, nRow)); } } break; case "5": { VPBLL.BasePage bp = new VPBLL.BasePage(); if (bp.RoleID != 5) { resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.User_NoPermission, "用户无权限").ToMessage(); } else { string strgrinfo = context.Request.Params["gn"]; string strpoinfo = context.Request.Params["po"]; string gn = strgrinfo.Split(',')[0]; string gin = strgrinfo.Split(',')[1]; string pn = strpoinfo.Split(',')[0]; string pin = strpoinfo.Split(',')[1]; int nDelRow = new VPBLL.GR.GRHelper().deleteGRNew(gn, gin, pn, pin, userId); resultMsg = String.Format("{0}&{1}", nDelRow > 0 ? 0 : -300, nDelRow.ToString()); logger.LogInfo(String.Format("deleteGRNew(userID={0}, gn={1}, po={2}) = {3}", bp.UserID, strgrinfo, strpoinfo, nDelRow)); } } break; } } } catch (Exception ex) { logger.LogError(this, ex); resultMsg = new VPBLL.ResponseInfo(VPBLL.eResponseCode.SystemError, ex.Message).ToMessage();//"-550&未知错误"; } context.Response.ContentType = "text/plain"; context.Response.Write(resultMsg); }
protected void btnDVVendorSearch_Click(object sender, EventArgs e) { String vendorCode = txtDVVendorCode.Text; if (!String.IsNullOrWhiteSpace(vendorCode)) { lblDVErrorMessage.Visible = false; var vendor = new VPBLL.Vendor.VenderHelper().getVendor(vendorCode); if (vendor != null) { lblDVVendorCode.Text = vendor.VendorCode; lblDVVendorName.Text = vendor.VendorName; lblDVTaxNumber.Text = vendor.TaxNumber; lblDVIndustryCode.Text = vendor.IndustryCode; cbDVIsActive.Checked = vendor.Active == "1"; btnDVDeactive.Enabled = cbDVIsActive.Checked; tabDVResult.Visible = true; } else { tabDVResult.Visible = false; lblDVErrorMessage.Text = "未找到该供应商"; lblDVErrorMessage.ForeColor = System.Drawing.Color.Red; lblDVErrorMessage.Visible = true; btnDVDeactive.Enabled = false; tabDVResult.Visible = false; } } }