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_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.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) { 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(); } } }
public string[] GetUserName(string prefixText, int count) { List <VAN_OA.Model.User> userLists = userSer.getAllUserByLoginName(string.Format(" and (loginName like '%{0}%' or loginId LIKE '%{0}%') ", prefixText.Trim())); string[] strUsers = new string[userLists.Count]; for (int i = 0; i < userLists.Count; i++) { strUsers[i] = userLists[i].LoginName; } return(strUsers); }
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) { 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 ='{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(); user = userSer.getAllUserByLoginName(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["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 (!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 (!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 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 (!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 (!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) { 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 (!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 (!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"; 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_Post> poseModels = new List <tb_Post>(); this.gvList.DataSource = poseModels; 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 = "LoginName"; List <VAN_OA.Model.User> aeList = new List <VAN_OA.Model.User>(); 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; } if (showAll == true) { aeList = userSer.getAllUserByPOList(); aeList.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { aeList = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); aeList.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; aeList.Insert(0, model); } ddlAE.DataSource = aeList; ddlAE.DataBind(); ddlAE.DataTextField = "LoginName"; ddlAE.DataValueField = "Id"; } }
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_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()); } }
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"; 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"; 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 (QuanXian_ShowAll("商业BI图表") == false) { ViewState["showAll"] = false; showAll = false; ddlCompany.Enabled = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("商业BI图表", 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"; 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 <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"; for (var i = 2012; i <= DateTime.Now.Year; i++) { ddlYear.Items.Add(new ListItem { Value = i.ToString(), Text = i.ToString() }); ddlNextYear.Items.Add(new ListItem { Value = i.ToString(), Text = i.ToString() }); } ddlYear.SelectedValue = DateTime.Now.Year.ToString(); } }
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 (!base.IsPostBack) { DataTable cardInfo = DBHelp.getDataTable("select '' as CardNo union select BusNo as CardNo from Base_BusInfo"); ddlCardNo.DataSource = cardInfo; ddlCardNo.DataBind(); ddlCardNo1.DataSource = cardInfo; ddlCardNo1.DataBind(); List <TB_BusCardRecord> BusCardRecordList = new List <TB_BusCardRecord>(); this.gvCardRecordList.DataSource = BusCardRecordList; this.gvCardRecordList.DataBind(); List <TB_BusCardUse> BusCardUseList = new List <TB_BusCardUse>(); this.gvCardNOUse.DataSource = BusCardUseList; this.gvCardNOUse.DataBind(); List <VAN_OA.Model.User> aeList = new List <VAN_OA.Model.User>(); 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; } VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { aeList = userSer.getAllUserByPOList(); aeList.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { aeList = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); aeList.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; aeList.Insert(0, model); } ddlAE.DataSource = aeList; ddlAE.DataBind(); ddlAE.DataTextField = "LoginName"; ddlAE.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) { gvCardRecordList.Columns[1].Visible = false; gvCardNOUse.Columns[1].Visible = false; } } if (NewShowAll_textName("公交卡充值/使用记录", "编辑") == false) { gvCardNOUse.Columns[0].Visible = false; gvCardRecordList.Columns[0].Visible = false; } if (NewShowAll_textName("公交卡充值/使用记录", "删除") == false) { gvCardNOUse.Columns[1].Visible = false; gvCardRecordList.Columns[1].Visible = false; } #endregion 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"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { txtStartTime.Text = (DateTime.Now.Year - 1) + "-1-1"; List <TB_BasePoType> basePoTypeList = new TB_BasePoTypeService().GetListArray(""); basePoTypeList.Add(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(SysObj.JXC_REPORTTotalList) == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTTotalList, 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"; // 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 (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); 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 (!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 (!base.IsPostBack) { int month = DateTime.Now.Month; int year = DateTime.Now.Year; List <ListItem> allYears = new List <ListItem>(); allYears.Add(new ListItem { Text = (2011).ToString(), Value = (2011).ToString() }); allYears.Add(new ListItem { Text = (2012).ToString(), Value = (2012).ToString() }); allYears.Add(new ListItem { Text = (2013).ToString(), Value = (2013).ToString() }); allYears.Add(new ListItem { Text = (2014).ToString(), Value = (2014).ToString() }); allYears.Add(new ListItem { Text = (2015).ToString(), Value = (2015).ToString() }); allYears.Add(new ListItem { Text = (2016).ToString(), Value = (2016).ToString() }); allYears.Add(new ListItem { Text = (2017).ToString(), Value = (2017).ToString() }); allYears.Add(new ListItem { Text = (2018).ToString(), Value = (2018).ToString() }); allYears.Add(new ListItem { Text = (2019).ToString(), Value = (2019).ToString() }); allYears.Add(new ListItem { Text = (2020).ToString(), Value = (2020).ToString() }); allYears.Add(new ListItem { Text = (2021).ToString(), Value = (2021).ToString() }); allYears.Add(new ListItem { Text = (2022).ToString(), Value = (2022).ToString() }); ddlSelectYears.DataSource = allYears; ddlSelectYears.DataBind(); ddlSelectYears.SelectedValue = year.ToString(); if (1 <= month && month <= 3) { ddlJidu.Text = "1"; } else if (4 <= month && month <= 6) { ddlJidu.Text = "2"; } else if (7 <= month && month <= 9) { ddlJidu.Text = "3"; } else if (10 <= month && month <= 12) { ddlJidu.Text = "4"; } 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()); ddlINSIDE.DataSource = user; ddlINSIDE.DataBind(); ddlINSIDE.DataTextField = "LoginName"; ddlINSIDE.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 (!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(); } } } }