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_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 <CG_POOrder> pOOrderList = new List <CG_POOrder>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); bool showAll = true; if (QuanXian_ShowAll(SysObj.CG_OrderList) == false) { ViewState["showAll"] = false; showAll = false; } if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll(SysObj.CG_OrderList, 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.getAllUserByLoginName(""); 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"; } }
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) { 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(""); ddlContract_Brokerage.DataSource = user; ddlContract_Brokerage.DataBind(); ddlContract_Brokerage.DataTextField = "LoginName"; ddlContract_Brokerage.DataValueField = "LoginName"; if (base.Request["Id"] != null) { this.btnAdd.Visible = false; Contract model = this.contractSer.GetModel(Convert.ToInt32(base.Request["Id"])); this.ddlContract_Type.Text = model.Contract_Type.ToString(); this.ddlContract_Use.Text = model.Contract_Use; this.txtContract_No.Text = model.Contract_No; this.txtContract_Unit.Text = model.Contract_Unit; this.txtContract_Name.Text = model.Contract_Name; this.txtContract_Summary.Text = model.Contract_Summary; this.txtContract_Total.Text = model.Contract_Total.ToString(); this.txtContract_Date.Text = model.Contract_Date.ToString(); this.txtContract_PageCount.Text = model.Contract_PageCount.ToString(); this.txtContract_BCount.Text = model.Contract_BCount.ToString(); this.txtPONo.Text = model.PONo; this.txtAE.Text = model.AE; this.ddlContract_Brokerage.Text = model.Contract_Brokerage; if (model.Contract_IsSign) { rabContract_IsSignB.Checked = true; } this.ddlContract_Local.Text = model.Contract_Local; this.ddlContract_Year.Text = model.Contract_Year.ToString(); this.ddlContract_Month.Text = model.Contract_Month.ToString(); this.txtContract_Remark.Text = model.Contract_Remark; txtContract_AllCount.Text = model.Contract_AllCount.ToString(); lblContract_ProNo.Text = model.Contract_ProNo; cbContract_IsRequire.Checked = model.Contract_IsRequire; if (model.Contract_IsRequire) { lbtnSelectPONo.Visible = false; } Contract_OldType.Value = model.Contract_Type.ToString(); } else { this.btnUpdate.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 Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { setBaiFenBi(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName(""); ddlAE.DataSource = user; ddlAE.DataBind(); ddlAE.DataTextField = "LoginName"; ddlAE.DataValueField = "Id"; ddlINSIDE.DataSource = user; ddlINSIDE.DataBind(); ddlINSIDE.DataTextField = "LoginName"; ddlINSIDE.DataValueField = "Id"; if (Request["type"] != null) { ddlAE.Enabled = true; VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User; if (use.LoginName == "王鸣") { txtGuestName.ReadOnly = false; } } if (base.Request["Id"] != null) { this.btnAdd.Visible = false; ShowInfo(Convert.ToInt32(base.Request["Id"])); } else { int CreateUser = Convert.ToInt32(Session["currentUserId"]); try { ddlAE.SelectedValue = CreateUser.ToString(); } catch (Exception) { } this.btnUpdate.Visible = false; btnCopy.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName(""); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; A_ProInfoService proSer = new A_ProInfoService(); List <A_ProInfo> pros = proSer.GetListArray(""); ddlProType.DataSource = pros; ddlProType.DataBind(); ddlProType.DataTextField = "pro_Type"; ddlProType.DataValueField = "pro_Id"; if (base.Request["ID"] != null) { cbAll.Visible = false; this.btnAdd.Visible = false; tb_ConsignorService conSer = new tb_ConsignorService(); tb_Consignor consi = conSer.GetListArray(" con_Id=" + base.Request["ID"])[0]; ddlProType.SelectedItem.Value = consi.proId.ToString(); if (consi.fromTime != null) { txtFrom.Text = Convert.ToDateTime(consi.fromTime).ToShortDateString(); } if (consi.toTime != null) { txtTo.Text = Convert.ToDateTime(consi.toTime).ToShortDateString(); } // txtconsignor.Text = consi.Consignor_Name; cbYouXiao.Checked = consi.ifYouXiao; ddlUser.Text = consi.consignor.ToString(); } else { this.btnUpdate.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { 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()); ddlAE.DataSource = user; ddlAE.DataBind(); ddlAE.DataTextField = "LoginName"; ddlAE.DataValueField = "Id"; WebQuerySessin Sess = new WebQuerySessin(Query); //加载SESSION中的数据 if (Session[Query] != null) { //QueryEForms QuerySession.QueryGuestTrack QGuestTrack = Session[Query] as QuerySession.QueryGuestTrack; if (QGuestTrack == null) { return; } if (QGuestTrack.FromTime != "") { txtFrom.Text = QGuestTrack.FromTime; } if (QGuestTrack.ToTime != "") { txtTo.Text = QGuestTrack.ToTime; } if (QGuestTrack.GuestName != "") { txtGuestName.Text = QGuestTrack.GuestName; } Show(); } else { List <TB_GuestTrack> TB_GuestTracks = new List <TB_GuestTrack>(); this.gvList.DataSource = TB_GuestTracks; this.gvList.DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName(""); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName_ID"; ddlUser.DataValueField = "Id"; A_RoleService roleSer = new A_RoleService(); List <A_Role> roles = roleSer.GetModelList(""); this.ddlRoles.DataSource = roles; this.ddlRoles.DataBind(); ddlRoles.DataTextField = "A_RoleName"; ddlRoles.DataValueField = "A_RoleId"; if (base.Request["ID"] != null) { this.btnAdd.Visible = false; A_Role_User roleUser = roleUserSer.GetModelGetModel(Convert.ToInt32(base.Request["ID"])); foreach (ListItem item in ddlRoles.Items) { if (item.Text == roleUser.RoleName) { item.Selected = true; break; } } //ddlRoles.SelectedItem.Text = roleUser.RoleName; ddlUser.Text = roleUser.UserId.ToString(); cbAll.Visible = false; txtRole_User_Index.Text = roleUser.Role_User_Index.ToString(); ddlRowState.Text = roleUser.RowState.ToString(); } else { this.btnUpdate.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { 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 <SupplierToInvoiceView> pOOrderList = new List <SupplierToInvoiceView>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); this.gvAdvancePayment.DataSource = pOOrderList; this.gvAdvancePayment.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.getAllUserByLoginName(""); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; ddlAdvUserList.DataSource = user; ddlAdvUserList.DataBind(); ddlAdvUserList.DataTextField = "LoginName"; ddlAdvUserList.DataValueField = "Id"; if (Request["error"] != null) { txtSupplier.Text = Request["error"]; // base.ClientScript.RegisterStartupScript(base.GetType(), null, "<script>alert('提交失败,供应商['" + Request["error"] + "']有在执行中的支付单,请排队等候');</script>"); } } }
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) { List <tb_OverTime> tb_OverServices = new List <tb_OverTime>(); this.gvList.DataSource = tb_OverServices; 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.getAllUserByLoginName(""); 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["Comm_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.getAllUserByLoginName(""); 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) { bool showAll = true; if (SysObj.IfShowAll("人事考核", Session["currentUserId"], "") == false) { ViewState["showAll"] = false; showAll = false; } var user = new List <VAN_OA.Model.User>(); var userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByLoginName(""); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } 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()); } }
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 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 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_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 (!base.IsPostBack) { for (var i = 1; i < 100; i++) { ddlL_Month.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); } 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(""); ddlHandler.DataSource = user; ddlHandler.DataBind(); ddlHandler.DataTextField = "LoginName"; ddlHandler.DataValueField = "LoginName"; if (base.Request["Id"] != null) { this.btnAdd.Visible = false; Petitions model = this.petitionsSer.GetModel(Convert.ToInt32(base.Request["Id"])); txtName.Text = model.Name; this.ddlType.Text = model.Type; this.lblNumber.Text = model.Number; this.txtGuestName.Text = model.GuestName; this.txtSalesUnit.Text = model.SalesUnit; this.txtSummary.Text = model.Summary; this.txtTotal.Text = model.Total.ToString(); this.txtSignDate.Text = model.SignDate.ToString(); this.txtSumPages.Text = model.SumPages.ToString(); this.txtSumCount.Text = model.SumCount.ToString(); this.txtBCount.Text = model.BCount.ToString(); this.txtPONo.Text = model.PoNo; this.txtAE.Text = model.AE; this.ddlHandler.Text = model.Handler; this.ddlLocal.Text = model.Local; this.ddlL_Year.Text = model.L_Year.ToString(); this.ddlL_Month.Text = model.L_Month.ToString(); this.txtRemark.Text = model.Remark; cbIsRequire.Checked = model.IsRequire; if (model.IsRequire) { lbtnSelectPONo.Visible = false; } if (model.IsColse) { rabIsColseB.Checked = true; } hfYear.Value = model.L_Year.ToString(); var supplierList = new CAI_POCaiService().GetLastSupplier(string.Format("'{0}'", model.PoNo)); txtSalesUnit.Text = string.Join(",", supplierList.Select(t => t.Supplier).ToArray()); txtTotal.Text = supplierList.Sum(t => t.Total).ToString(); } else { ddlHandler.Text = "王汉中"; this.btnUpdate.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { btnReSet.Visible = false; VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); List <VAN_OA.Model.User> user = userSer.getAllUserByLoginName(""); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; Session["ProInvs"] = null; gvList.Columns[0].Visible = false; gvList.Columns[1].Visible = false; btnSave.Enabled = false; btnCancel.Enabled = false; plProInvs.Visible = false; btnEdit.Visible = false; if (base.Request["ProId"] != null) { //加载基本数据 VAN_OA.Model.User use = Session["userInfo"] as VAN_OA.Model.User; txtName.Text = use.LoginName; tb_EFormService eformSer = new tb_EFormService(); if (Request["allE_id"] == null)//单据增加 { gvList.Columns[0].Visible = true; gvList.Columns[1].Visible = true; plProInvs.Visible = true; //检查自己是否在请假单中流程设置中,来确定自己下一个审批人 lblResult.Visible = false; lblYiJian.Visible = false; ddlResult.Visible = false; txtResultRemark.Visible = false; //加载初始数据 List <Tb_ProjectInvs> proInvsList = new List <Tb_ProjectInvs>(); Session["ProInvs"] = proInvsList; ViewState["ProInvsCount"] = proInvsList.Count; gvList.DataSource = proInvsList; gvList.DataBind(); if (eformSer.ifHasNodes(Convert.ToInt32(Request["ProId"]))) { //获取审批人 int ids = 0; List <A_Role_User> roleUserList = eformSer.getUsers(Convert.ToInt32(Session["currentUserId"].ToString()), Convert.ToInt32(Request["ProId"]), out ids); ViewState["ids"] = ids; if (roleUserList != null) { ddlPers.DataSource = roleUserList; ddlPers.DataBind(); ddlPers.DataTextField = "UserName"; ddlPers.DataValueField = "UserId"; } else { lblPer.Visible = false; ddlPers.Visible = false; } } else { lblPer.Visible = false; ddlPers.Visible = false; } } else//单据审批 { ViewState["ProInvsIds"] = ""; //加载已经审批的数据 tb_EFormsService eformsSer = new tb_EFormsService(); List <VAN_OA.Model.EFrom.tb_EForms> eforms = eformsSer.GetListArray(string.Format(" e_Id in (select id from tb_EForm where proId={0} and allE_id={1})", Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); if (eforms.Count > 0) { string mess = @"<table cellpadding='0' cellspacing='0' width='100%' bordercolorlight='#999999' bordercolordark='#FFFFFF' border='1' ><tr><td colspan='6' style=' height:20px; background-color:#336699; color:White;'>流程图</td></tr>"; for (int i = 0; i < eforms.Count; i++) { string per = ""; if (eforms[i].consignor != null && eforms[i].consignor != 0) { per = eforms[i].Consignor_Name + "(委托人:" + eforms[i].Audper_Name + ")"; } else { per = eforms[i].Audper_Name; } mess += string.Format("<tr><td align='center'>第{0}步</td><td>序号{0}:{1}</td><td><span style='color:red;'>{2}</span>[<span style='color:blue;'>{3} {4}</span>]<br/>意见:{5}</td></tr>", i + 1, eforms[i].RoleName , per, eforms[i].resultState, eforms[i].doTime, eforms[i].idea); } mess += "</table>"; lblMess.Text = mess; } #region 加载 请假单数据 Tb_ProjectInvService paProInvSer = new Tb_ProjectInvService(); Tb_ProjectInvsService sonProInvSer = new Tb_ProjectInvsService(); Tb_ProjectInv pProModel = paProInvSer.GetModel(Convert.ToInt32(Request["allE_id"])); txtName.Text = pProModel.LoginName; txtCreateTime.Text = pProModel.CreateTime.Value.ToString("yyyy-MM-dd"); txtProName.Text = pProModel.ProName; txtProNo.Text = pProModel.ProNo; ddlProState.Text = pProModel.State; lblProInvState.Text = ddlProState.Text; lblProNo.Text = pProModel.ProNo; if (pProModel.State == "已完工") { lblProInvState.ForeColor = System.Drawing.Color.Red; } if (pProModel.State == "未完工") { } try { ddlUser.SelectedValue = pProModel.GuestId.ToString(); } catch (Exception) { } List <Tb_ProjectInvs> proInvsList = sonProInvSer.GetListArray(" 1=1 and PId=" + Request["allE_id"]); setTotal(proInvsList); Session["ProInvs"] = proInvsList; ViewState["ProInvsCount"] = proInvsList.Count; gvList.DataSource = proInvsList; gvList.DataBind(); #endregion //判断单据是否已经结束 if (eformSer.ifFinish(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { btnSub.Visible = false; lblPer.Visible = false; ddlPers.Visible = false; lblResult.Visible = false; lblYiJian.Visible = false; ddlResult.Visible = false; txtResultRemark.Visible = false; setEnable(false); btnReSet.Visible = true; } else { //是否为审核人 if (eformSer.ifAudiPer(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); lblPer.Visible = false; ddlPers.Visible = false; } else { int ids = 0; List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids); ViewState["ids"] = ids; if (roleUserList != null) { ddlPers.DataSource = roleUserList; ddlPers.DataBind(); ddlPers.DataTextField = "UserName"; ddlPers.DataValueField = "UserId"; } setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); } } else { //是否为代理人 if (eformSer.ifAudiPerByUserName(Convert.ToInt32(Session["currentUserId"]), Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { ViewState["ifConsignor"] = true; if (eformSer.ifLastNode(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))) { lblPer.Visible = false; ddlPers.Visible = false; setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); } else { int ids = 0; List <A_Role_User> roleUserList = eformSer.getUserToAdu(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]), out ids); ViewState["ids"] = ids; if (roleUserList != null) { ddlPers.DataSource = roleUserList; ddlPers.DataBind(); ddlPers.DataTextField = "UserName"; ddlPers.DataValueField = "UserId"; } setEnable(eformSer.ifEdit(Convert.ToInt32(Request["ProId"]), Convert.ToInt32(Request["allE_id"]))); } } else { btnSub.Visible = false; lblPer.Visible = false; ddlPers.Visible = false; lblResult.Visible = false; lblYiJian.Visible = false; ddlResult.Visible = false; txtResultRemark.Visible = false; setEnable(false); } } //判断是不是自己填写的单子 if (pProModel.UserId.ToString() == base.Session["currentUserId"].ToString()) { gvList.Columns[0].Visible = true; gvList.Columns[1].Visible = true; btnEdit.Visible = true; plProInvs.Visible = true; setEnable(true); } } } } } }
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 (!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 <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 (!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"; //加载基本信息 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"; 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(); } } } }