protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComCode += "," + m.ComSimpName; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComCode = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //主单 List <Sell_Cai_OrderInHouseListModel> pOOrderList = new List <Sell_Cai_OrderInHouseListModel>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (QuanXian_ShowAll(SysObj.Sell_OrderInHouseList) == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //主单 List <Sell_OrderInHouse> pOOrderList = new List <Sell_OrderInHouse>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <Sell_OrderInHouses> orders = new List <Sell_OrderInHouses>(); gvList.DataSource = orders; gvList.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (QuanXian_ShowAll(SysObj.Sell_OrderInHouseList) == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; if (!NewShowAll_textName("签呈单档案管理", "编辑")) { gvList.Columns[0].Visible = false; btnAdd.Visible = false; } if (!NewShowAll_textName("签呈单档案管理", "删除")) { gvList.Columns[1].Visible = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); user = userSer.getAllUserByLoginName(""); user.Insert(0, new Model.User { LoginName = "全部" }); ddlHandler.DataSource = user; ddlHandler.DataBind(); ddlHandler.DataTextField = "LoginName"; ddlHandler.DataValueField = "LoginName"; var aeList = userSer.getAllUserByPOList(""); aeList.Insert(0, new Model.User { LoginName = "全部" }); ddlAE.DataSource = aeList; ddlAE.DataBind(); ddlAE.DataTextField = "LoginName"; ddlAE.DataValueField = "LoginName"; List <Contract> contractList = new List <Contract>(); this.gvList.DataSource = contractList; this.gvList.DataBind(); if (Request["PONO"] != null) { txtPONo.Text = Request["PONO"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <InvoiceReport> invoiceList = new List <InvoiceReport>(); this.gvList.DataSource = invoiceList; this.gvList.DataBind(); txtPOFrom.Text = DateTime.Now.AddYears(-1).Year + "-1-1"; var user = new List <VAN_OA.Model.User>(); var userSer = new VAN_OA.Dal.SysUserService(); user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='记录' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='到款对比') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) > 0) // { // lblQuanXian.Text = "1"; // gvList.Columns[6].Visible = false; // } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; List <Invoice> invoiceList = new List <Invoice>(); this.gvList.DataSource = invoiceList; this.gvList.DataBind(); if (VAN_OA.JXC.SysObj.NewShowAll_textName("项目发票销帐", Session["currentUserId"], "销帐可编辑") == false) { ViewState["cbIsIsorder"] = false; btnIsSelected.Visible = false; gvList.Columns[0].Visible = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (QuanXian_ShowAll("项目发票销帐") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["InvoiceNo"] != null) { txtInvoiceNo.Text = Request["InvoiceNo"].ToString(); Show(); } } }
protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e) { string where = ""; if (ddlCompany.Text != "-1") { where = string.Format(" and tb_User.CompanyCode =(select ComCode from TB_Company where id={0})", ddlCompany.Text); } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); user = userSer.getAllUserByPOList(where); user.Insert(0, new VAN_OA.Model.User() { LoginName = "选择", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { Session["CGPONo"] = null; List <CG_POOrder> cars = new List <CG_POOrder>(); this.gvList.DataSource = cars; this.gvList.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; } }
protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e) { string where = ""; if (ddlCompany.Text != "-1") { where = string.Format(" and tb_User.CompanyCode ='{0}'", ddlCompany.Text.Split(',')[0]); } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (ddlUser.Text == "-1")//显示所有用户 { } else if (ddlUser.Text == "0")//显示部门信息 { var model = Session["userInfo"] as User; where += string.Format(" and loginIPosition='{0}' ", model.LoginIPosition); } else { var model = Session["userInfo"] as User; where += string.Format(" and tb_User.ID={0}", model.Id); } user = userSer.getAllUserByPOList(where); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; }
protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e) { string where = ""; List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); if (ddlCompany.Text != "-1") { where = string.Format(" and tb_User.CompanyCode ='{0}'", ddlCompany.Text); if (ViewState["WFScanDepartList"] != null && Convert.ToBoolean(ViewState["WFScanDepartList"]) == true) { where += string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]); } VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); user = userSer.getAllUserByPOList(where); user.Insert(0, new VAN_OA.Model.User() { LoginName = "", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "LoginName"; }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { for (int i = 2012; i <= DateTime.Now.Year; i++) { ddlYear.Items.Add(new ListItem { Value = i.ToString(), Text = i.ToString() }); } ddlYear.SelectedValue = (DateTime.Now.Year).ToString(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); List <VAN_OA.Model.User> user = userSer.getAllUserByPOList(""); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "LoginName"; if (base.Request["Id"] != null) { this.btnAdd.Visible = false; AEPromiseTotal model = this.aEPromiseTotalService.GetModel(Convert.ToInt32(base.Request["Id"])); ddlUser.Text = model.AE; ddlYear.Text = model.YearNo.ToString(); txtAddGuestProfit.Text = model.AddGuestProfit.ToString(); txtAddGuetSellTotal.Text = model.AddGuetSellTotal.ToString(); txtPromiseProfit.Text = model.PromiseProfit.ToString(); txtPromiseSellTotal.Text = model.PromiseSellTotal.ToString(); } else { this.btnUpdate.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); gooQGooddList_1 = fpTypeBaseInfoService.GetListArray(""); gooQGooddList_1.Insert(0, new FpTypeBaseInfo() { FpType = "全部" }); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (NewShowAll_textName("采购订单列表2", "查看所有") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (NewShowAll_textName("采购订单列表2", "禁止含税设置") == false) { gvMain.Columns[0].Visible = false; btnSave.Visible = false; } else { gvMain.Columns[1].Visible = false; } if (NewShowAll_textName("采购订单列表2", "可导出") == false) { btnExcel.Visible = false; } //主单 List <vAllCaiOrderList> pOOrderList = new List <vAllCaiOrderList>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //发票类型 dllSelectFPstye.DataSource = gooQGooddList_1; dllSelectFPstye.DataTextField = "FpType"; dllSelectFPstye.DataValueField = "FpType"; dllSelectFPstye.DataBind(); // } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; if (Session["currentUserId"] != null) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (VAN_OA.JXC.SysObj.IfShowAll("入库未出清单", Session["currentUserId"], "ShowAll") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; List <RuSellReport> list = new List <RuSellReport>(); gvMain.DataSource = list; gvMain.DataBind(); if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); ddlPoType.Text = "2"; cbRuZero.Checked = true; Show(); } if (Request["X"] != null) { Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); var aeUsers = userSer.getAllUserByPOList(); aeUsers.Insert(0, new VAN_OA.Model.User { Id = -1, LoginName = "全部" }); ddlAEUsers.DataSource = aeUsers; ddlAEUsers.DataBind(); ddlAEUsers.DataTextField = "LoginName"; ddlAEUsers.DataValueField = "Id"; if (Session["printUrl"] != null) { string url = Session["printUrl"].ToString(); Session["printUrl"] = null; Response.Write(string.Format("<script>window.open('{0}','_blank')</script>", url)); } WebQuerySessin Sess = new WebQuerySessin(Query); A_ProInfoService proSer = new A_ProInfoService(); List <A_ProInfo> pros = this.proSer.GetListArray(""); pros.Insert(0, new A_ProInfo()); ddlProType.DataSource = pros; ddlProType.DataBind(); ddlProType.DataTextField = "pro_Type"; ddlProType.DataValueField = "pro_Id"; //加载SESSION中的数据 if (Session[Query] != null) { //QueryEForms QuerySession.QueryEForm QEForm = Session[Query] as QuerySession.QueryEForm; if (QEForm == null) { return; } if (QEForm.ProTypeId != 0) { try { ddlProType.Text = QEForm.ProTypeId.ToString(); } catch (Exception) { } } if (QEForm.FromTime != "") { txtFrom.Text = QEForm.FromTime; } if (QEForm.ToTime != "") { txtTo.Text = QEForm.ToTime; } if (QEForm.Apper != "") { txtApper.Text = QEForm.Apper; } if (QEForm.WeiTuo != "") { txtWeiTuo.Text = QEForm.WeiTuo; } if (QEForm.E_No != "") { txtNo.Text = QEForm.E_No; } if (QEForm.E_No != "") { txtNo.Text = QEForm.E_No; } select(); } else { tb_EFormService eformSer = new tb_EFormService(); List <tb_EForm> allEForms = eformSer.GetListArray_ToDo("", "", Convert.ToInt32(Session["currentUserId"])); string allIds = "", proIds = "", fukuandan = "0,", yufukuandan = "0,"; for (int i = 0; i < allEForms.Count; i++) { allIds += allEForms[i].allE_id.ToString() + ","; proIds += allEForms[i].proId.ToString() + ","; if (allEForms[i].ProTyleName == "供应商付款单") { fukuandan += allEForms[i].allE_id + ","; } if (allEForms[i].ProTyleName == "供应商预付款单") { yufukuandan += allEForms[i].allE_id + ","; } } allIds = allIds.Trim(','); proIds = proIds.Trim(','); fukuandan = fukuandan.Trim(','); yufukuandan = yufukuandan.Trim(','); if (fukuandan != "" || yufukuandan != "") { var superSer = new TB_SupplierAdvancePaymentService(); SupplierInvoice_Names = superSer.GetSupplierName(yufukuandan, fukuandan); } if (allIds != "") { allAllWform = eformSer.GetView_AllEformList(proIds, allIds); } AspNetPager1.RecordCount = allEForms.Count; this.gvList.PageIndex = AspNetPager1.CurrentPageIndex - 1; this.gvList.DataSource = allEForms; this.gvList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; DataTable carInfos = DBHelp.getDataTable("select ''as CarNO union select CarNO from TB_CarInfo"); ddlCarNo.DataSource = carInfos; ddlCarNo.DataBind(); ddlCarNo.Text = ""; GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; ddlGuestTypeList1.DataSource = dalList; ddlGuestTypeList1.DataBind(); ddlGuestTypeList1.DataTextField = "GuestType"; ddlGuestTypeList1.DataValueField = "GuestType"; ddlGuestProList1.DataSource = proList; ddlGuestProList1.DataBind(); ddlGuestProList1.DataTextField = "GuestProString"; ddlGuestProList1.DataValueField = "GuestPro"; //List<VAN_OA.Model.User> user = new List<VAN_OA.Model.User>(); //VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); //user = userSer.getAllUserByPOList(); //user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); //ddlUser.DataSource = user; //ddlUser.DataBind(); //ddlUser.DataTextField = "LoginName"; //ddlUser.DataValueField = "Id"; bool showAll = true; if (QuanXian_ShowAll("用车统计") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("用车统计", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; ddlAE.DataSource = user; ddlAE.DataBind(); ddlAE.DataTextField = "LoginName"; ddlAE.DataValueField = "Id"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); dllCompayList.DataSource = comList; dllCompayList.DataBind(); List <TB_UseCarDetail> UseCarServices = new List <TB_UseCarDetail>(); this.gvList.DataSource = UseCarServices; this.gvList.DataBind(); List <tb_UseCar> UseCarServices_Si = new List <tb_UseCar>(); this.GvSi.DataSource = UseCarServices_Si; this.GvSi.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <InvoiceReport> invoiceList = new List <InvoiceReport>(); this.gvList.DataSource = invoiceList; this.gvList.DataBind(); txtPOFrom.Text = DateTime.Now.AddYears(-1).Year + "-1-1"; //var user = new List<VAN_OA.Model.User>(); //var userSer = new VAN_OA.Dal.SysUserService(); //user = userSer.getAllUserByPOList(); //user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); //ddlUser.DataSource = user; //ddlUser.DataBind(); //ddlUser.DataTextField = "LoginName"; //ddlUser.DataValueField = "Id"; List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (VAN_OA.JXC.SysObj.NewShowAll_Name("发票比对", Session["currentUserId"], "ShowAll") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["PONo"] != null) { isSelect = true; txtPONo.Text = Request["PONo"]; txtPOFrom.Text = ""; cbIsSpecial.Checked = false; AspNetPager1.CurrentPageIndex = 1; Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); if (Session["currentUserId"] != null) { List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (VAN_OA.JXC.SysObj.IfShowAll("出库发票清单", Session["currentUserId"], "ShowAll") == false) { var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; List <SellFPReport> list = new List <SellFPReport>(); gvMain.DataSource = list; gvMain.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> gooQGooddList = fpTypeBaseInfoService.GetListArray(""); gooQGooddList.Insert(0, new FpTypeBaseInfo { FpType = "全部", Id = 0 }); dllFPstye.DataSource = gooQGooddList; dllFPstye.DataBind(); dllFPstye.DataTextField = "FpType"; dllFPstye.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='可导出' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='出库发票清单') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("出库发票清单", "可导出")) { Button1.Visible = true; } else { Button1.Visible = false; } if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); cbIsSpecial.Checked = false; Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //主单 List <Sell_OrderFP> pOOrderList = new List <Sell_OrderFP>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <Sell_OrderFPs> orders = new List <Sell_OrderFPs>(); gvList.DataSource = orders; gvList.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); if (QuanXian_ShowAll("销售发票列表") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("销售发票列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } if (NewShowAll_textName("销售发票列表", "删除") == false) { gvMain.Columns[2].Visible = false; } //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.Sell_OrderPFList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> fpTypeList = fpTypeBaseInfoService.GetListArray(""); fpTypeList.Insert(0, new FpTypeBaseInfo { FpType = "全部", Id = -1 }); fpTypeList.Add(new FpTypeBaseInfo { Id = 999, FpType = "" }); fpTypeList.Add(new FpTypeBaseInfo { Id = 1000, FpType = "其他" }); ddlFPType.DataSource = fpTypeList; ddlFPType.DataBind(); ddlFPType.DataTextField = "FpType"; ddlFPType.DataValueField = "Id"; ddlFPType.Items[fpTypeList.Count - 2].Attributes.Add("style", "background-color: red"); GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); if (Request["Type"] != null) { ddlType.Text = Request["Type"].ToString(); } Show(); } if (Request["InvoiceNo"] != null) { txtFPNo.Text = Request["InvoiceNo"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //主单 List <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTTotalList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} //System.Wen.HttpUtility.HtmlEncode. List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (QuanXian_ShowAll("项目费用汇总统计") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; //加载基本信息 ddlNumber.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlRow.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlCol.Items.Add(new ListItem { Text = "全部", Value = "" }); //货架号:1.全部 缺省 2….51 1,..50 for (int i = 1; i < 51; i++) { ddlNumber.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); //层数:1.全部 缺省 2….21 1,2,3…20 //部位:1.全部 缺省 2….21 1,2,3…20 if (i <= 21) { ddlRow.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); ddlCol.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); } } TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); Dal.BaseInfo.TB_HouseInfoService houseSer = new VAN_OA.Dal.BaseInfo.TB_HouseInfoService(); List <Model.BaseInfo.TB_HouseInfo> houseList = houseSer.GetListArray(""); houseList.Insert(0, new VAN_OA.Model.BaseInfo.TB_HouseInfo()); ddlHouse.DataSource = houseList; ddlHouse.DataBind(); ddlHouse.DataTextField = "houseName"; ddlHouse.DataValueField = "id"; //主单 List <CAI_OrderInHouse> pOOrderList = new List <CAI_OrderInHouse>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <CAI_OrderInHouses> orders = new List <CAI_OrderInHouses>(); gvList.DataSource = orders; gvList.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (QuanXian_ShowAll(SysObj.CAI_OrderInHouseList) == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); //主单 List <Sell_OrderFPBack> pOOrderList = new List <Sell_OrderFPBack>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <Sell_OrderFPBacks> orders = new List <Sell_OrderFPBacks>(); gvList.DataSource = orders; gvList.DataBind(); if (Session["currentUserId"] != null) { // string sql = // string.Format( // @"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='发票单签回列表') and sys_Object.AutoID is not null", // Session["currentUserId"]); if (QuanXian_ShowAll("发票单签回列表") == false) { ViewState["showAll"] = false; } else { user = userSer.getAllUserByPOList(); } // string sql = // string.Format( // @"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='发票单签回列表') and sys_Object.AutoID is not null", // Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("发票单签回列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.Sell_OrderPFBackList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); if (Request["Type"] != null) { ddlType.Text = Request["Type"].ToString(); } cbIsSpecial.Checked = false; Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='支付单列表') and sys_Object.AutoID is not null", Session["currentUserId"]); if (QuanXian_ShowAll("预付款发票列表") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='预付款发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("预付款发票列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } if (Request["Ids"] != null) { ddlStatue.Text = "通过"; Show(); } else { if (Request["PayIds"] != null) { ddlStatue.Text = "通过"; Show(); } else { if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"]; ddlFpState.Text = "1"; Show(); } else { //主单 List <SupplierToInvoiceView> pOOrderList = new List <SupplierToInvoiceView>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); comList.Add(new VAN_OA.Model.BaseInfo.TB_Company() { ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); if (Session["Company"] != null) { ddlCompany.Text = Session["Company"].ToString(); } bool showAll = true; if (QuanXian_ShowAll("报价单列表") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("报价单列表", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["QuoteNo"] != null) { txtProno.Text = Request["QuoteNo"]; Show(); } else { List <tb_QuotePrice> quotePriceList = new List <tb_QuotePrice>(); this.gvList.DataSource = quotePriceList; this.gvList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); if (Session["currentUserId"] != null) { //List<VAN_OA.Model.User> user = new List<VAN_OA.Model.User>(); //VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); //if (VAN_OA.JXC.SysObj.IfShowAll("项目未采购清单", Session["currentUserId"], "ShowAll") == false) //{ // ViewState["showAll"] = false; // var model = Session["userInfo"] as User; // user.Insert(0, model); //} //else //{ // user = userSer.getAllUserByPOList(); // user.Insert(0, new VAN_OA.Model.User() {LoginName = "全部", Id = -1}); //} bool showAll = true; if (QuanXian_ShowAll("项目未采购清单") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("项目未采购清单", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; List <CaiNotRuView> list = new List <CaiNotRuView>(); gvMain.DataSource = list; gvMain.DataBind(); if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName(""); user.Insert(0, new VAN_OA.Model.User { Id = -1, LoginName = "全部" }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; var aeUsers = userSer.getAllUserByPOList(); aeUsers.Insert(0, new VAN_OA.Model.User { Id = -1, LoginName = "全部" }); ddlAEUsers.DataSource = aeUsers; ddlAEUsers.DataBind(); ddlAEUsers.DataTextField = "LoginName"; ddlAEUsers.DataValueField = "Id"; #region 是否有删除功能 if (Session["currentUserId"] != null) { VAN_OA.Dal.TB_AdminDeleteService deleteSer = new VAN_OA.Dal.TB_AdminDeleteService(); if (deleteSer.CheckIsExistByUserId(Convert.ToInt32(Session["currentUserId"])) == false) { gvList.Columns[1].Visible = false; } } #endregion WebQuerySessin Sess = new WebQuerySessin("QueryEForms"); gvList.PagerSettings.Mode = PagerButtons.NumericFirstLast; A_ProInfoService proSer = new A_ProInfoService(); List <A_ProInfo> pros = this.proSer.GetListArray(""); pros.Insert(0, new A_ProInfo()); pros.Insert(pros.FindIndex(t => t.pro_Type == "销售发票"), new A_ProInfo { pro_Id = -2, pro_Type = "销售发票+销售发票修改" }); pros.Insert(pros.FindIndex(t => t.pro_Type == "销售发票") - 1, new A_ProInfo { pro_Id = -3, pro_Type = "供应商付款单+供应商预付款单" }); ddlProType.DataSource = pros; ddlProType.DataBind(); ddlProType.DataTextField = "pro_Type"; ddlProType.DataValueField = "pro_Id"; //加载SESSION中的数据 if (Session["QueryEForms"] != null) { //QueryEForms QuerySession.QueryEForm QEForm = Session["QueryEForms"] as QuerySession.QueryEForm; if (QEForm == null) { return; } if (QEForm.ProTypeId != 0) { try { ddlProType.Text = QEForm.ProTypeId.ToString(); } catch (Exception) { } } if (QEForm.FromTime != "") { txtFrom.Text = QEForm.FromTime; } if (QEForm.ToTime != "") { txtTo.Text = QEForm.ToTime; } if (QEForm.State != "") { ddlState.Text = QEForm.State; } if (QEForm.Apper != "") { foreach (ListItem m in ddlUser.Items) { if (m.Text == QEForm.Apper) { m.Selected = true; break; } } //ddlUser.SelectedItem.Text = QEForm.Apper; } if (QEForm.Auper != "") { txtAuper.Text = QEForm.Auper; } if (QEForm.WatingAuper != "") { txtWating.Text = QEForm.WatingAuper; } if (QEForm.E_No != "") { txtNo.Text = QEForm.E_No; } if (QEForm.PONO != "") { txtPONo.Text = QEForm.PONO; } if (QEForm.GuestName != "") { txtGuestName.Text = QEForm.GuestName; } txtSPForm.Text = QEForm.SPForm; txtSPTo.Text = QEForm.SPTo; select(); } else { tb_EFormService eformSer = new tb_EFormService(); List <tb_EForm> allEForms = new List <tb_EForm>();// eformSer.GetListArray_1(""); this.gvList.DataSource = allEForms; this.gvList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <TB_BasePoType> basePoTypeList = new TB_BasePoTypeService().GetListArray(""); basePoTypeList.Insert(0, new TB_BasePoType { BasePoType = "全部", Id = -1 }); ddlPOTyle.DataSource = basePoTypeList; ddlPOTyle.DataBind(); ddlPOTyle.DataTextField = "BasePoType"; ddlPOTyle.DataValueField = "Id"; TB_GoodsTypeService typeSer = new TB_GoodsTypeService(); List <TB_GoodsType> allType = typeSer.GetListArray(""); allType.Insert(0, new TB_GoodsType()); ddlGoodType.DataSource = allType; ddlGoodType.DataBind(); ddlGoodType.DataTextField = "GoodTypeName"; ddlGoodType.DataValueField = "GoodTypeName"; TB_GoodsSmTypeService goodsSmTypeSer = new TB_GoodsSmTypeService(); List <TB_GoodsSmType> goodsSmTypeList = goodsSmTypeSer.GetListArrayToddl(""); goodsSmTypeList.Insert(0, new TB_GoodsSmType()); ddlGoodSmType.DataSource = goodsSmTypeList; ddlGoodSmType.DataBind(); ddlGoodSmType.DataTextField = "GoodTypeSmName"; ddlGoodSmType.DataValueField = "GoodTypeSmName"; //主单 List <JXC_REPORT> pOOrderList = new List <JXC_REPORT>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); bool showAll = true; if (QuanXian_ShowAll(SysObj.JXC_REPORTList) == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTList, Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User> (); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["IsSpecial"] != null) { ddlIsSpecial.Text = Request["IsSpecial"].ToString(); } if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <TB_BasePoType> basePoTypeList = new TB_BasePoTypeService().GetListArray(""); basePoTypeList.Insert(0, new TB_BasePoType { BasePoType = "全部", Id = -1 }); ddlPOTyle.DataSource = basePoTypeList; ddlPOTyle.DataBind(); ddlPOTyle.DataTextField = "BasePoType"; ddlPOTyle.DataValueField = "Id"; GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; //主单 List <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); bool showAll = true; if (QuanXian_ShowAll("工程技术派工统计报表") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("工程技术派工统计报表", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='可导出' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售报表汇总') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("工程技术派工统计报表", "可导出")) { btnExcel.Visible = true; } else { btnExcel.Visible = false; } if (!NewShowAll_textName("工程技术派工统计报表", "编辑")) { gvMain.Columns[0].Visible = false; } string sql = string.Format("select loginName,ID from tb_User where loginIPosition='技术部' AND loginStatus='在职' and loginName<>'';"); List <User> getUsers = userSer.getUserReportTos(sql); getUsers = getUsers.FindAll(T => string.IsNullOrEmpty(T.LoginName) == false); getUsers.Insert(0, new Model.User { Id = -1, LoginName = "全部" }); getUsers.Add(new User { Id = -1000, LoginName = "其他" }); ddlPaiGong.DataSource = getUsers; ddlPaiGong.DataBind(); ddlPaiGong.DataTextField = "LoginName"; ddlPaiGong.DataValueField = "Id"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); ddlIsSpecial.Text = "-1"; Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //txtStartTime.Text = (DateTime.Now.Year - 1) + "-1-1"; List <TB_BasePoType> basePoTypeList = new TB_BasePoTypeService().GetListArray(""); List <TB_BasePoType> basePoTypeList1 = new TB_BasePoTypeService().GetListArray(""); cbKaoList.DataSource = basePoTypeList1; cbKaoList.DataBind(); cbKaoList.DataTextField = "BasePoType"; cbKaoList.DataValueField = "Id"; basePoTypeList.Insert(0, new TB_BasePoType { BasePoType = "全部", Id = -1 }); ddlPOTyle.DataSource = basePoTypeList; ddlPOTyle.DataBind(); ddlPOTyle.DataTextField = "BasePoType"; ddlPOTyle.DataValueField = "Id"; GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; //主单 List <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTTotalList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} bool showAll = true; if (QuanXian_ShowAll("销售KPI 量化指标") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("销售KPI 量化指标", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { List <WFAEPromiseTotal> _list = new List <WFAEPromiseTotal>(); this.gvList.DataSource = _list; this.gvList.DataBind(); TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComCode = "-1", ComName = "全部" }); for (int i = 2012; i <= DateTime.Now.Year; i++) { ddlYear.Items.Add(new ListItem { Value = i.ToString(), Text = i.ToString() }); } ddlYear.SelectedValue = (DateTime.Now.Year).ToString(); if (NewShowAll_textName("销售指标", "编辑") == false) { gvList.Columns[1].Visible = false; btnAdd.Visible = false; } if (NewShowAll_textName("销售指标", "删除") == false) { gvList.Columns[2].Visible = false; } bool showAll = true; if (NewShowAll_textName("销售指标", "查看所有")) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("销售指标", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); ddlCompany.Enabled = false; } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "LoginName"; ddlCompany.DataSource = comList; ddlCompany.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComCode += "," + m.ComSimpName; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComCode = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); bool showAll = true; if (SysObj.IfShowAll("销售月考核", Session["currentUserId"], "ShowAll") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("销售月考核", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; ds = new DataSet(); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); } }