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 (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <InvoiceReport> invoiceList = new List <InvoiceReport>(); this.gvList.DataSource = invoiceList; this.gvList.DataBind(); txtPOFrom.Text = DateTime.Now.AddYears(-1).Year + "-1-1"; var user = new List <VAN_OA.Model.User>(); var userSer = new VAN_OA.Dal.SysUserService(); user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='记录' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='到款对比') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) > 0) // { // lblQuanXian.Text = "1"; // gvList.Columns[6].Visible = false; // } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; 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 (!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 (!IsPostBack) { //TB_CompanyService comSer = new TB_CompanyService(); //var comList = comSer.GetListArray(""); //comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComCode = "-1", ComName = "全部" }); //ddlCompany.DataSource = comList; //ddlCompany.DataBind(); Province_CityService proList = new Province_CityService(); var proviceList = proList.ProvinceList(); ddlProvince.DataSource = proviceList; ddlProvince.DataBind(); 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"; var user = new List <Model.User>(); var userSer = new Dal.SysUserService(); //主单 var pOOrderList = new List <CG_POOrderService>(); gvMain.DataSource = pOOrderList; gvMain.DataBind(); 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"; billTypeList = new Invoice_BillTypeService().GetListArray(" IsStop=0"); personList = new Invoice_PersonService().GetListArray(" IsStop=0"); warnList = new Base_UseTypeService().GetListArray("Type=1"); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); this.gvModel.DataSource = modelService.GetListArray("");; this.gvModel.DataBind(); txtYuGuDaoKuan_1.Text = DateTime.Now.ToString("yyyy-MM-dd"); 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(); //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTTotalList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} 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 (NewShowAll_textName("项目预收账款系统", "可导出")) { btnExcel.Visible = true; } else { btnExcel.Visible = false; } 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_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); var user = new List <Model.User>(); var userSer = new 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 }); } if (!NewShowAll_textName("预期报销单列表", "编辑")) { gvList.Columns[0].Visible = false; } if (!NewShowAll_textName("预期报销单列表", "编辑发票号")) { gvList.Columns[1].Visible = false; btnExcel.Visible = false; } else { btnExcel.Visible = true; } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; var dispatchList = new List <Tb_DispatchList>(); gvList.DataSource = dispatchList; gvList.DataBind(); 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) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //主单 List <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTTotalList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} //System.Wen.HttpUtility.HtmlEncode. List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (QuanXian_ShowAll("项目费用汇总统计") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); if (Session["currentUserId"] != null) { List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (VAN_OA.JXC.SysObj.IfShowAll("出库发票清单", Session["currentUserId"], "ShowAll") == false) { var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; List <SellFPReport> list = new List <SellFPReport>(); gvMain.DataSource = list; gvMain.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> gooQGooddList = fpTypeBaseInfoService.GetListArray(""); gooQGooddList.Insert(0, new FpTypeBaseInfo { FpType = "全部", Id = 0 }); dllFPstye.DataSource = gooQGooddList; dllFPstye.DataBind(); dllFPstye.DataTextField = "FpType"; dllFPstye.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='可导出' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='出库发票清单') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("出库发票清单", "可导出")) { Button1.Visible = true; } else { Button1.Visible = false; } if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); cbIsSpecial.Checked = false; Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); if (Session["currentUserId"] != null) { //List<VAN_OA.Model.User> user = new List<VAN_OA.Model.User>(); //VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); //if (VAN_OA.JXC.SysObj.IfShowAll("项目未采购清单", Session["currentUserId"], "ShowAll") == false) //{ // ViewState["showAll"] = false; // var model = Session["userInfo"] as User; // user.Insert(0, model); //} //else //{ // user = userSer.getAllUserByPOList(); // user.Insert(0, new VAN_OA.Model.User() {LoginName = "全部", Id = -1}); //} bool showAll = true; if (QuanXian_ShowAll("项目未采购清单") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("项目未采购清单", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; List <CaiNotRuView> list = new List <CaiNotRuView>(); gvMain.DataSource = list; gvMain.DataBind(); if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_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 (!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"; 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"; 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(); gvDiXiao.DataSource = new List <SupplierToInvoiceView>(); gvDiXiao.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> gooQGooddList = fpTypeBaseInfoService.GetListArray(""); gooQGooddList.Insert(0, new FpTypeBaseInfo { Id = -1, FpType = "全部" }); gooQGooddList.Add(new FpTypeBaseInfo { Id = -2, FpType = "不含税" }); dllFPstye.DataSource = gooQGooddList; dllFPstye.DataBind(); dllFPstye.DataTextField = "FpType"; dllFPstye.DataValueField = "Id"; 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; } var sql = @"select CreateName from ( select CreateName from TB_SupplierAdvancePayment union select CreateName from TB_SupplierInvoice) AS TB WHERE CreateName<>'ADMIN' ORDER BY CreateName "; List <ListItem> createList = new List <ListItem>(); createList.Add(new ListItem { Text = "全部", Value = "全部" }); createList.Add(new ListItem { Text = "不含Admin", Value = "不含Admin" }); foreach (DataRow dr in DBHelp.getDataTable(sql).Rows) { createList.Add(new ListItem { Text = dr[0].ToString(), Value = dr[0].ToString() }); } ddlCreateName.DataSource = createList; ddlCreateName.DataBind(); if (Request["Ids"] != null) { ddlStatue.Text = "通过"; ddlType.Text = "0"; Show(); } else { if (Request["PayIds"] != null) { ddlStatue.Text = "通过"; ddlType.Text = "1"; Show(); } else { //主单 List <SupplierToInvoiceView> pOOrderList = new List <SupplierToInvoiceView>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_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 <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 <CashFlowReport> poseModels = new List <CashFlowReport>(); 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.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_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 <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 <CashFlow> poseModels = new List <CashFlow>(); this.gvList.DataSource = poseModels; this.gvList.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"; 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 <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"; #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) { gvMain.Columns[1].Visible = false; } } #endregion if (Request["Ids"] != null) { Show(); } else { if (Request["PayIds"] != null) { Show(); } else { //主单 List <SupplierToInvoiceView> pOOrderList = new List <SupplierToInvoiceView>(); this.gvMain.DataSource = pOOrderList; this.gvMain.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"; 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"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComCode = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //主单 var pOOrderList = new List <CG_POOrderService>(); gvMain.DataSource = pOOrderList; gvMain.DataBind(); // 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) { btnSelect.Visible = false; } // 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) { btnCancel.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.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); var fpTypeBaseInfoService = new FpTypeBaseInfoService(); gooQGooddList_1 = fpTypeBaseInfoService.GetListArray(""); gooQGooddList_1.Insert(0, new FpTypeBaseInfo() { FpType = "全部" }); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (NewShowAll_textName("采购订单列表2", "查看所有") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (NewShowAll_textName("采购订单列表2", "禁止含税设置") == false) { gvMain.Columns[0].Visible = false; btnSave.Visible = false; } else { gvMain.Columns[1].Visible = false; } if (NewShowAll_textName("采购订单列表2", "可导出") == false) { btnExcel.Visible = false; } //主单 List <vAllCaiOrderList> pOOrderList = new List <vAllCaiOrderList>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //发票类型 dllSelectFPstye.DataSource = gooQGooddList_1; dllSelectFPstye.DataTextField = "FpType"; dllSelectFPstye.DataValueField = "FpType"; dllSelectFPstye.DataBind(); // } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; 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_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("销售退货未采退列表_新") == 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"; // var 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) { ViewState["cbIsSelected"] = false; btnSave.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"; 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) { 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 <TB_ToInvoice> poseModels = new List <TB_ToInvoice>(); 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(); // 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) { 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 }); } // 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) { gvList.Columns[0].Visible = false; } if (NewShowAll_textName("到款单列表", "删除") == false) { gvList.Columns[1].Visible = false; } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["ishebing"] != null) { cbPOHeBing.Checked = true; } if (Request["PONo"] != null) { txtPONO.Text = Request["PONo"].ToString(); ddlNoSpecial.Text = "-1"; Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <InvoiceReport> invoiceList = new List <InvoiceReport>(); this.gvList.DataSource = invoiceList; this.gvList.DataBind(); txtPOFrom.Text = DateTime.Now.AddYears(-1).Year + "-1-1"; //var user = new List<VAN_OA.Model.User>(); //var userSer = new VAN_OA.Dal.SysUserService(); //user = userSer.getAllUserByPOList(); //user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); //ddlUser.DataSource = user; //ddlUser.DataBind(); //ddlUser.DataTextField = "LoginName"; //ddlUser.DataValueField = "Id"; List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (VAN_OA.JXC.SysObj.NewShowAll_Name("发票比对", Session["currentUserId"], "ShowAll") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; if (Request["PONo"] != null) { isSelect = true; txtPONo.Text = Request["PONo"]; txtPOFrom.Text = ""; cbIsSpecial.Checked = false; AspNetPager1.CurrentPageIndex = 1; Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; 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 (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; if (Session["currentUserId"] != null) { TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (VAN_OA.JXC.SysObj.IfShowAll("入库未出清单", Session["currentUserId"], "ShowAll") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; List <RuSellReport> list = new List <RuSellReport>(); gvMain.DataSource = list; gvMain.DataBind(); if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); ddlPoType.Text = "2"; cbRuZero.Checked = true; Show(); } if (Request["X"] != null) { Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!base.IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; DataTable carInfos = DBHelp.getDataTable("select ''as CarNO union select CarNO from TB_CarInfo"); ddlCarNo.DataSource = carInfos; ddlCarNo.DataBind(); ddlCarNo.Text = ""; GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; ddlGuestTypeList1.DataSource = dalList; ddlGuestTypeList1.DataBind(); ddlGuestTypeList1.DataTextField = "GuestType"; ddlGuestTypeList1.DataValueField = "GuestType"; ddlGuestProList1.DataSource = proList; ddlGuestProList1.DataBind(); ddlGuestProList1.DataTextField = "GuestProString"; ddlGuestProList1.DataValueField = "GuestPro"; //List<VAN_OA.Model.User> user = new List<VAN_OA.Model.User>(); //VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); //user = userSer.getAllUserByPOList(); //user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); //ddlUser.DataSource = user; //ddlUser.DataBind(); //ddlUser.DataTextField = "LoginName"; //ddlUser.DataValueField = "Id"; bool showAll = true; if (QuanXian_ShowAll("用车统计") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("用车统计", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; ddlAE.DataSource = user; ddlAE.DataBind(); ddlAE.DataTextField = "LoginName"; ddlAE.DataValueField = "Id"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); dllCompayList.DataSource = comList; dllCompayList.DataBind(); List <TB_UseCarDetail> UseCarServices = new List <TB_UseCarDetail>(); this.gvList.DataSource = UseCarServices; this.gvList.DataBind(); List <tb_UseCar> UseCarServices_Si = new List <tb_UseCar>(); this.GvSi.DataSource = UseCarServices_Si; this.GvSi.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; //加载基本信息 ddlNumber.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlRow.Items.Add(new ListItem { Text = "全部", Value = "" }); ddlCol.Items.Add(new ListItem { Text = "全部", Value = "" }); //货架号:1.全部 缺省 2….51 1,..50 for (int i = 1; i < 51; i++) { ddlNumber.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); //层数:1.全部 缺省 2….21 1,2,3…20 //部位:1.全部 缺省 2….21 1,2,3…20 if (i <= 21) { ddlRow.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); ddlCol.Items.Add(new ListItem { Text = i.ToString(), Value = i.ToString() }); } } TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); Dal.BaseInfo.TB_HouseInfoService houseSer = new VAN_OA.Dal.BaseInfo.TB_HouseInfoService(); List <Model.BaseInfo.TB_HouseInfo> houseList = houseSer.GetListArray(""); houseList.Insert(0, new VAN_OA.Model.BaseInfo.TB_HouseInfo()); ddlHouse.DataSource = houseList; ddlHouse.DataBind(); ddlHouse.DataTextField = "houseName"; ddlHouse.DataValueField = "id"; //主单 List <CAI_OrderInHouse> pOOrderList = new List <CAI_OrderInHouse>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <CAI_OrderInHouses> orders = new List <CAI_OrderInHouses>(); gvList.DataSource = orders; gvList.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (QuanXian_ShowAll(SysObj.CAI_OrderInHouseList) == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); //主单 List <Sell_OrderFPBack> pOOrderList = new List <Sell_OrderFPBack>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <Sell_OrderFPBacks> orders = new List <Sell_OrderFPBacks>(); gvList.DataSource = orders; gvList.DataBind(); if (Session["currentUserId"] != null) { // string sql = // string.Format( // @"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='发票单签回列表') and sys_Object.AutoID is not null", // Session["currentUserId"]); if (QuanXian_ShowAll("发票单签回列表") == false) { ViewState["showAll"] = false; } else { user = userSer.getAllUserByPOList(); } // string sql = // string.Format( // @"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='发票单签回列表') and sys_Object.AutoID is not null", // Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("发票单签回列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.Sell_OrderPFBackList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); if (Request["Type"] != null) { ddlType.Text = Request["Type"].ToString(); } cbIsSpecial.Checked = false; Show(); } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); //主单 List <Sell_OrderFP> pOOrderList = new List <Sell_OrderFP>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); //子单 List <Sell_OrderFPs> orders = new List <Sell_OrderFPs>(); gvList.DataSource = orders; gvList.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); if (QuanXian_ShowAll("销售发票列表") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("销售发票列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } if (NewShowAll_textName("销售发票列表", "删除") == false) { gvMain.Columns[2].Visible = false; } //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.Sell_OrderPFList, Session["currentUserId"]) == false) //{ // ViewState["showAll"] = false; //} var fpTypeBaseInfoService = new FpTypeBaseInfoService(); List <FpTypeBaseInfo> fpTypeList = fpTypeBaseInfoService.GetListArray(""); fpTypeList.Insert(0, new FpTypeBaseInfo { FpType = "全部", Id = -1 }); fpTypeList.Add(new FpTypeBaseInfo { Id = 999, FpType = "" }); fpTypeList.Add(new FpTypeBaseInfo { Id = 1000, FpType = "其他" }); ddlFPType.DataSource = fpTypeList; ddlFPType.DataBind(); ddlFPType.DataTextField = "FpType"; ddlFPType.DataValueField = "Id"; ddlFPType.Items[fpTypeList.Count - 2].Attributes.Add("style", "background-color: red"); GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); if (Request["Type"] != null) { ddlType.Text = Request["Type"].ToString(); } Show(); } if (Request["InvoiceNo"] != null) { txtFPNo.Text = Request["InvoiceNo"].ToString(); Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='查看所有' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='支付单列表') and sys_Object.AutoID is not null", Session["currentUserId"]); if (QuanXian_ShowAll("预付款发票列表") == false) { ViewState["showAll"] = false; var model = Session["userInfo"] as User; user.Insert(0, model); } else { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='不能编辑' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='预付款发票列表') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("预付款发票列表", "不能编辑") == false) { gvMain.Columns[0].Visible = false; } if (Request["Ids"] != null) { ddlStatue.Text = "通过"; Show(); } else { if (Request["PayIds"] != null) { ddlStatue.Text = "通过"; Show(); } else { if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"]; ddlFpState.Text = "1"; Show(); } else { //主单 List <SupplierToInvoiceView> pOOrderList = new List <SupplierToInvoiceView>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_ModelService modelService = new TB_ModelService(); var _modelList = modelService.GetListArray(""); _modelList.Insert(0, new TB_Model { Id = -1, ModelName = "全部" }); ddlModel.DataSource = _modelList; ddlModel.DataBind(); ddlModel.DataTextField = "ModelName"; ddlModel.DataValueField = "ModelName"; TB_CompanyService comSer = new TB_CompanyService(); var comList = comSer.GetListArray(""); foreach (var m in comList) { m.ComSimpName += "," + m.Id + "," + m.ComCode; } comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company() { ComSimpName = "-1", ComName = "全部" }); ddlCompany.DataSource = comList; ddlCompany.DataBind(); List <TB_BasePoType> basePoTypeList = new TB_BasePoTypeService().GetListArray(""); basePoTypeList.Insert(0, new TB_BasePoType { BasePoType = "全部", Id = -1 }); ddlPOTyle.DataSource = basePoTypeList; ddlPOTyle.DataBind(); ddlPOTyle.DataTextField = "BasePoType"; ddlPOTyle.DataValueField = "Id"; GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService(); var dalList = dal.GetListArray(""); dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo { GuestType = "全部" }); ddlGuestTypeList.DataSource = dalList; ddlGuestTypeList.DataBind(); ddlGuestTypeList.DataTextField = "GuestType"; ddlGuestTypeList.DataValueField = "GuestType"; GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService(); var proList = guestProBaseInfodal.GetListArray(""); proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo { GuestPro = -2 }); ddlGuestProList.DataSource = proList; ddlGuestProList.DataBind(); ddlGuestProList.DataTextField = "GuestProString"; ddlGuestProList.DataValueField = "GuestPro"; //主单 List <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>(); this.gvMain.DataSource = pOOrderList; this.gvMain.DataBind(); bool showAll = true; if (QuanXian_ShowAll("工程技术派工统计报表") == false) { ViewState["showAll"] = false; showAll = false; } bool WFScanDepartList = true; if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("工程技术派工统计报表", Session["currentUserId"], "WFScanDepartList") == true) { ViewState["WFScanDepartList"] = false; WFScanDepartList = false; } List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>(); VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService(); if (showAll == true) { user = userSer.getAllUserByPOList(); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = -1 }); } else if (WFScanDepartList == true) { user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"])); user.Insert(0, new VAN_OA.Model.User() { LoginName = "全部", Id = 0 }); } else { var model = Session["userInfo"] as User; user.Insert(0, model); } ddlUser.DataSource = user; ddlUser.DataBind(); ddlUser.DataTextField = "LoginName"; ddlUser.DataValueField = "Id"; // string sql = string.Format(@"select COUNT(*) from role_sys_form left join sys_Object on sys_Object.FormID=role_sys_form.sys_form_Id and sys_Object.roleId=role_sys_form.role_Id and textName='可导出' //where role_Id in (select roleId from Role_User where userId={0}) and sys_form_Id in(select formID from sys_form where displayName='销售报表汇总') and sys_Object.AutoID is not null", Session["currentUserId"]); // if (Convert.ToInt32(DBHelp.ExeScalar(sql)) <= 0) if (NewShowAll_textName("工程技术派工统计报表", "可导出")) { btnExcel.Visible = true; } else { btnExcel.Visible = false; } if (!NewShowAll_textName("工程技术派工统计报表", "编辑")) { gvMain.Columns[0].Visible = false; } string sql = string.Format("select loginName,ID from tb_User where loginIPosition='技术部' AND loginStatus='在职' and loginName<>'';"); List <User> getUsers = userSer.getUserReportTos(sql); getUsers = getUsers.FindAll(T => string.IsNullOrEmpty(T.LoginName) == false); getUsers.Insert(0, new Model.User { Id = -1, LoginName = "全部" }); getUsers.Add(new User { Id = -1000, LoginName = "其他" }); ddlPaiGong.DataSource = getUsers; ddlPaiGong.DataBind(); ddlPaiGong.DataTextField = "LoginName"; ddlPaiGong.DataValueField = "Id"; if (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); ddlIsSpecial.Text = "-1"; Show(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { TB_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(); //txtStartTime.Text = (DateTime.Now.Year - 1) + "-1-1"; txtStartTime.Text = DateTime.Now.AddYears(-1).AddDays(-150).ToString("yyyy-MM-dd"); 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("销售业绩帐期考核") == 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 (Request["PONo"] != null) { txtPONo.Text = Request["PONo"].ToString(); Show(); } TB_ProjectCostService _projectCostService = new TB_ProjectCostService(); var projectCosts = _projectCostService.GetListArray(""); if (projectCosts.Count > 0) { var model = projectCosts[0]; txtZhangQi.Text = model.ZhangQi.ToString(); txtCeSuanDian.Text = model.CeSuanDian.ToString(); txtMonthLiLv.Text = model.MonthLiLv.ToString(); } List <TB_BasePoType> new_basePoTypeList = new TB_BasePoTypeService().GetListArray(""); cbListPoType.DataSource = new_basePoTypeList; cbListPoType.DataBind(); cbListPoType.DataTextField = "BasePoType"; cbListPoType.DataValueField = "Id"; } }