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 <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(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.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(); 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"; 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"; 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(); 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(); } } }