示例#1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                foreach (var m in comList)
                {
                    m.ComCode += "," + m.ComSimpName;
                }
                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComCode = "-1", ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();
                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                user = userSer.getAllUserByPOList();
                user.Insert(0, new VAN_OA.Model.User()
                {
                    LoginName = "全部", Id = -1
                });

                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";
            }
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                //主单
                List <Sell_Cai_OrderInHouseListModel> pOOrderList = new List <Sell_Cai_OrderInHouseListModel>();
                this.gvMain.DataSource = pOOrderList;
                this.gvMain.DataBind();


                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                if (QuanXian_ShowAll(SysObj.Sell_OrderInHouseList) == false)
                {
                    ViewState["showAll"] = false;
                    var model = Session["userInfo"] as User;
                    user.Insert(0, model);
                }
                else
                {
                    user = userSer.getAllUserByPOList();
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = -1
                    });
                }
                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";
            }
        }
示例#3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                TB_ModelService modelService = new TB_ModelService();
                var             _modelList   = modelService.GetListArray("");
                _modelList.Insert(0, new TB_Model {
                    Id = -1, ModelName = "全部"
                });
                ddlModel.DataSource = _modelList;
                ddlModel.DataBind();
                ddlModel.DataTextField  = "ModelName";
                ddlModel.DataValueField = "ModelName";

                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                foreach (var m in comList)
                {
                    m.ComSimpName += "," + m.Id + "," + m.ComCode;
                }
                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComSimpName = "-1", ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();
                //主单
                List <Sell_OrderInHouse> pOOrderList = new List <Sell_OrderInHouse>();
                this.gvMain.DataSource = pOOrderList;
                this.gvMain.DataBind();

                //子单
                List <Sell_OrderInHouses> orders = new List <Sell_OrderInHouses>();
                gvList.DataSource = orders;
                gvList.DataBind();
                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                if (QuanXian_ShowAll(SysObj.Sell_OrderInHouseList) == false)
                {
                    ViewState["showAll"] = false;
                    var model = Session["userInfo"] as User;
                    user.Insert(0, model);
                }
                else
                {
                    user = userSer.getAllUserByPOList();
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = -1
                    });
                }
                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                TB_ModelService modelService = new TB_ModelService();
                var             _modelList   = modelService.GetListArray("");
                _modelList.Insert(0, new TB_Model {
                    Id = -1, ModelName = "全部"
                });
                ddlModel.DataSource = _modelList;
                ddlModel.DataBind();
                ddlModel.DataTextField  = "ModelName";
                ddlModel.DataValueField = "ModelName";

                if (!NewShowAll_textName("签呈单档案管理", "编辑"))
                {
                    gvList.Columns[0].Visible = false;
                    btnAdd.Visible            = false;
                }
                if (!NewShowAll_textName("签呈单档案管理", "删除"))
                {
                    gvList.Columns[1].Visible = false;
                }

                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();

                user = userSer.getAllUserByLoginName("");
                user.Insert(0, new Model.User {
                    LoginName = "全部"
                });
                ddlHandler.DataSource = user;
                ddlHandler.DataBind();
                ddlHandler.DataTextField  = "LoginName";
                ddlHandler.DataValueField = "LoginName";

                var aeList = userSer.getAllUserByPOList("");
                aeList.Insert(0, new Model.User {
                    LoginName = "全部"
                });
                ddlAE.DataSource = aeList;
                ddlAE.DataBind();
                ddlAE.DataTextField  = "LoginName";
                ddlAE.DataValueField = "LoginName";

                List <Contract> contractList = new List <Contract>();
                this.gvList.DataSource = contractList;
                this.gvList.DataBind();

                if (Request["PONO"] != null)
                {
                    txtPONo.Text = Request["PONO"].ToString();
                    Show();
                }
            }
        }
示例#5
0
        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;
//                }
            }
        }
示例#6
0
        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();
                }
            }
        }
示例#7
0
        protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
        {
            string where = "";
            if (ddlCompany.Text != "-1")
            {
                where = string.Format(" and tb_User.CompanyCode =(select ComCode from TB_Company where id={0})", ddlCompany.Text);
            }
            List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();

            VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
            user = userSer.getAllUserByPOList(where);
            user.Insert(0, new VAN_OA.Model.User()
            {
                LoginName = "选择", Id = -1
            });

            ddlUser.DataSource = user;
            ddlUser.DataBind();
            ddlUser.DataTextField  = "LoginName";
            ddlUser.DataValueField = "Id";
        }
示例#8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                Session["CGPONo"] = null;
                List <CG_POOrder> cars = new List <CG_POOrder>();
                this.gvList.DataSource = cars;
                this.gvList.DataBind();

                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();

                user = userSer.getAllUserByPOList();
                user.Insert(0, new VAN_OA.Model.User()
                {
                    LoginName = "全部", Id = -1
                });
                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";
            }
        }
示例#9
0
        protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
        {
            string where = "";
            if (ddlCompany.Text != "-1")
            {
                where = string.Format(" and tb_User.CompanyCode ='{0}'", ddlCompany.Text.Split(',')[0]);
            }
            List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();

            VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();

            if (ddlUser.Text == "-1")//显示所有用户
            {
            }
            else if (ddlUser.Text == "0")//显示部门信息
            {
                var model = Session["userInfo"] as User;
                where += string.Format(" and loginIPosition='{0}' ", model.LoginIPosition);
            }
            else
            {
                var model = Session["userInfo"] as User;
                where += string.Format(" and tb_User.ID={0}", model.Id);
            }

            user = userSer.getAllUserByPOList(where);
            user.Insert(0, new VAN_OA.Model.User()
            {
                LoginName = "全部", Id = -1
            });

            ddlUser.DataSource = user;
            ddlUser.DataBind();
            ddlUser.DataTextField  = "LoginName";
            ddlUser.DataValueField = "Id";
        }
        protected void ddlCompany_SelectedIndexChanged(object sender, EventArgs e)
        {
            string where = "";
            List <VAN_OA.Model.User> user = new List <VAN_OA.Model.User>();

            if (ddlCompany.Text != "-1")
            {
                where = string.Format(" and tb_User.CompanyCode ='{0}'", ddlCompany.Text);
                if (ViewState["WFScanDepartList"] != null && Convert.ToBoolean(ViewState["WFScanDepartList"]) == true)
                {
                    where += string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]);
                }
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                user = userSer.getAllUserByPOList(where);
                user.Insert(0, new VAN_OA.Model.User()
                {
                    LoginName = "", Id = -1
                });
            }
            ddlUser.DataSource = user;
            ddlUser.DataBind();
            ddlUser.DataTextField  = "LoginName";
            ddlUser.DataValueField = "LoginName";
        }
示例#11
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                for (int i = 2012; i <= DateTime.Now.Year; i++)
                {
                    ddlYear.Items.Add(new ListItem {
                        Value = i.ToString(), Text = i.ToString()
                    });
                }
                ddlYear.SelectedValue = (DateTime.Now.Year).ToString();

                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                List <VAN_OA.Model.User>  user    = userSer.getAllUserByPOList("");
                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "LoginName";

                if (base.Request["Id"] != null)
                {
                    this.btnAdd.Visible = false;
                    AEPromiseTotal model = this.aEPromiseTotalService.GetModel(Convert.ToInt32(base.Request["Id"]));
                    ddlUser.Text             = model.AE;
                    ddlYear.Text             = model.YearNo.ToString();
                    txtAddGuestProfit.Text   = model.AddGuestProfit.ToString();
                    txtAddGuetSellTotal.Text = model.AddGuetSellTotal.ToString();
                    txtPromiseProfit.Text    = model.PromiseProfit.ToString();
                    txtPromiseSellTotal.Text = model.PromiseSellTotal.ToString();
                }
                else
                {
                    this.btnUpdate.Visible = false;
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                TB_ModelService modelService = new TB_ModelService();
                var             _modelList   = modelService.GetListArray("");
                _modelList.Insert(0, new TB_Model {
                    Id = -1, ModelName = "全部"
                });
                ddlModel.DataSource = _modelList;
                ddlModel.DataBind();
                ddlModel.DataTextField  = "ModelName";
                ddlModel.DataValueField = "ModelName";

                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                foreach (var m in comList)
                {
                    m.ComSimpName += "," + m.Id + "," + m.ComCode;
                }
                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComSimpName = "-1", ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();

                var fpTypeBaseInfoService = new FpTypeBaseInfoService();
                gooQGooddList_1 = fpTypeBaseInfoService.GetListArray("");
                gooQGooddList_1.Insert(0, new FpTypeBaseInfo()
                {
                    FpType = "全部"
                });

                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                if (NewShowAll_textName("采购订单列表2", "查看所有") == false)
                {
                    ViewState["showAll"] = false;
                    var model = Session["userInfo"] as User;
                    user.Insert(0, model);
                }
                else
                {
                    user = userSer.getAllUserByPOList();
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = -1
                    });
                }
                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";
                if (NewShowAll_textName("采购订单列表2", "禁止含税设置") == false)
                {
                    gvMain.Columns[0].Visible = false;
                    btnSave.Visible           = false;
                }
                else
                {
                    gvMain.Columns[1].Visible = false;
                }

                if (NewShowAll_textName("采购订单列表2", "可导出") == false)
                {
                    btnExcel.Visible = false;
                }

                //主单
                List <vAllCaiOrderList> pOOrderList = new List <vAllCaiOrderList>();
                this.gvMain.DataSource = pOOrderList;
                this.gvMain.DataBind();

                //发票类型
                dllSelectFPstye.DataSource     = gooQGooddList_1;
                dllSelectFPstye.DataTextField  = "FpType";
                dllSelectFPstye.DataValueField = "FpType";
                dllSelectFPstye.DataBind();
                //
            }
        }
示例#13
0
        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();
                    }
                }
            }
        }
示例#14
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                foreach (var m in comList)
                {
                    m.ComSimpName += "," + m.Id + "," + m.ComCode;
                }
                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComSimpName = "-1", ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();

                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                var aeUsers = userSer.getAllUserByPOList();
                aeUsers.Insert(0, new VAN_OA.Model.User {
                    Id = -1, LoginName = "全部"
                });
                ddlAEUsers.DataSource = aeUsers;
                ddlAEUsers.DataBind();
                ddlAEUsers.DataTextField  = "LoginName";
                ddlAEUsers.DataValueField = "Id";

                if (Session["printUrl"] != null)
                {
                    string url = Session["printUrl"].ToString();
                    Session["printUrl"] = null;
                    Response.Write(string.Format("<script>window.open('{0}','_blank')</script>", url));
                }

                WebQuerySessin Sess = new WebQuerySessin(Query);

                A_ProInfoService proSer = new A_ProInfoService();
                List <A_ProInfo> pros   = this.proSer.GetListArray("");
                pros.Insert(0, new A_ProInfo());
                ddlProType.DataSource = pros;
                ddlProType.DataBind();

                ddlProType.DataTextField  = "pro_Type";
                ddlProType.DataValueField = "pro_Id";

                //加载SESSION中的数据
                if (Session[Query] != null)
                {
                    //QueryEForms
                    QuerySession.QueryEForm QEForm = Session[Query] as QuerySession.QueryEForm;
                    if (QEForm == null)
                    {
                        return;
                    }

                    if (QEForm.ProTypeId != 0)
                    {
                        try
                        {
                            ddlProType.Text = QEForm.ProTypeId.ToString();
                        }
                        catch (Exception)
                        {
                        }
                    }
                    if (QEForm.FromTime != "")
                    {
                        txtFrom.Text = QEForm.FromTime;
                    }

                    if (QEForm.ToTime != "")
                    {
                        txtTo.Text = QEForm.ToTime;
                    }


                    if (QEForm.Apper != "")
                    {
                        txtApper.Text = QEForm.Apper;
                    }

                    if (QEForm.WeiTuo != "")
                    {
                        txtWeiTuo.Text = QEForm.WeiTuo;
                    }
                    if (QEForm.E_No != "")
                    {
                        txtNo.Text = QEForm.E_No;
                    }

                    if (QEForm.E_No != "")
                    {
                        txtNo.Text = QEForm.E_No;
                    }

                    select();
                }
                else
                {
                    tb_EFormService eformSer  = new tb_EFormService();
                    List <tb_EForm> allEForms = eformSer.GetListArray_ToDo("", "", Convert.ToInt32(Session["currentUserId"]));

                    string allIds = "", proIds = "", fukuandan = "0,", yufukuandan = "0,";
                    for (int i = 0; i < allEForms.Count; i++)
                    {
                        allIds += allEForms[i].allE_id.ToString() + ",";
                        proIds += allEForms[i].proId.ToString() + ",";

                        if (allEForms[i].ProTyleName == "供应商付款单")
                        {
                            fukuandan += allEForms[i].allE_id + ",";
                        }
                        if (allEForms[i].ProTyleName == "供应商预付款单")
                        {
                            yufukuandan += allEForms[i].allE_id + ",";
                        }
                    }

                    allIds = allIds.Trim(',');
                    proIds = proIds.Trim(',');

                    fukuandan   = fukuandan.Trim(',');
                    yufukuandan = yufukuandan.Trim(',');


                    if (fukuandan != "" || yufukuandan != "")
                    {
                        var superSer = new TB_SupplierAdvancePaymentService();
                        SupplierInvoice_Names = superSer.GetSupplierName(yufukuandan, fukuandan);
                    }


                    if (allIds != "")
                    {
                        allAllWform = eformSer.GetView_AllEformList(proIds, allIds);
                    }

                    AspNetPager1.RecordCount = allEForms.Count;
                    this.gvList.PageIndex    = AspNetPager1.CurrentPageIndex - 1;
                    this.gvList.DataSource   = allEForms;
                    this.gvList.DataBind();
                }
            }
        }
示例#15
0
        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();
            }
        }
示例#16
0
        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();
                }
            }
        }
示例#17
0
        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();
                    }
                }
            }
        }
示例#18
0
        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();
                }
            }
        }
示例#19
0
        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();
                }
            }
        }
示例#20
0
        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();
                    }
                }
            }
        }
示例#22
0
        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();
                        }
                    }
                }
            }
        }
示例#23
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                comList.Add(new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();

                if (Session["Company"] != null)
                {
                    ddlCompany.Text = Session["Company"].ToString();
                }
                bool showAll = true;
                if (QuanXian_ShowAll("报价单列表") == false)
                {
                    ViewState["showAll"] = false;
                    showAll = false;
                }
                bool WFScanDepartList = true;
                if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("报价单列表", Session["currentUserId"], "WFScanDepartList") == true)
                {
                    ViewState["WFScanDepartList"] = false;
                    WFScanDepartList = false;
                }
                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                if (showAll == true)
                {
                    user = userSer.getAllUserByPOList();
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = -1
                    });
                }
                else if (WFScanDepartList == true)
                {
                    user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = 0
                    });
                }
                else
                {
                    var model = Session["userInfo"] as User;
                    user.Insert(0, model);
                }

                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";
                if (Request["QuoteNo"] != null)
                {
                    txtProno.Text = Request["QuoteNo"];
                    Show();
                }
                else
                {
                    List <tb_QuotePrice> quotePriceList = new List <tb_QuotePrice>();
                    this.gvList.DataSource = quotePriceList;
                    this.gvList.DataBind();
                }
            }
        }
示例#24
0
        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();
                    }
                }
            }
        }
示例#25
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                foreach (var m in comList)
                {
                    m.ComSimpName += "," + m.Id + "," + m.ComCode;
                }
                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComSimpName = "-1", ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();

                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                List <VAN_OA.Model.User>  user    = userSer.getAllUserByLoginName("");
                user.Insert(0, new VAN_OA.Model.User {
                    Id = -1, LoginName = "全部"
                });
                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";
                var aeUsers = userSer.getAllUserByPOList();
                aeUsers.Insert(0, new VAN_OA.Model.User {
                    Id = -1, LoginName = "全部"
                });
                ddlAEUsers.DataSource = aeUsers;
                ddlAEUsers.DataBind();
                ddlAEUsers.DataTextField  = "LoginName";
                ddlAEUsers.DataValueField = "Id";

                #region 是否有删除功能
                if (Session["currentUserId"] != null)
                {
                    VAN_OA.Dal.TB_AdminDeleteService deleteSer = new VAN_OA.Dal.TB_AdminDeleteService();
                    if (deleteSer.CheckIsExistByUserId(Convert.ToInt32(Session["currentUserId"])) == false)
                    {
                        gvList.Columns[1].Visible = false;
                    }
                }
                #endregion


                WebQuerySessin Sess = new WebQuerySessin("QueryEForms");

                gvList.PagerSettings.Mode = PagerButtons.NumericFirstLast;


                A_ProInfoService proSer = new A_ProInfoService();
                List <A_ProInfo> pros   = this.proSer.GetListArray("");
                pros.Insert(0, new A_ProInfo());

                pros.Insert(pros.FindIndex(t => t.pro_Type == "销售发票"), new A_ProInfo {
                    pro_Id = -2, pro_Type = "销售发票+销售发票修改"
                });
                pros.Insert(pros.FindIndex(t => t.pro_Type == "销售发票") - 1, new A_ProInfo {
                    pro_Id = -3, pro_Type = "供应商付款单+供应商预付款单"
                });
                ddlProType.DataSource = pros;
                ddlProType.DataBind();

                ddlProType.DataTextField  = "pro_Type";
                ddlProType.DataValueField = "pro_Id";

                //加载SESSION中的数据
                if (Session["QueryEForms"] != null)
                {
                    //QueryEForms
                    QuerySession.QueryEForm QEForm = Session["QueryEForms"] as QuerySession.QueryEForm;
                    if (QEForm == null)
                    {
                        return;
                    }

                    if (QEForm.ProTypeId != 0)
                    {
                        try
                        {
                            ddlProType.Text = QEForm.ProTypeId.ToString();
                        }
                        catch (Exception)
                        {
                        }
                    }
                    if (QEForm.FromTime != "")
                    {
                        txtFrom.Text = QEForm.FromTime;
                    }

                    if (QEForm.ToTime != "")
                    {
                        txtTo.Text = QEForm.ToTime;
                    }
                    if (QEForm.State != "")
                    {
                        ddlState.Text = QEForm.State;
                    }

                    if (QEForm.Apper != "")
                    {
                        foreach (ListItem m in ddlUser.Items)
                        {
                            if (m.Text == QEForm.Apper)
                            {
                                m.Selected = true;
                                break;
                            }
                        }
                        //ddlUser.SelectedItem.Text = QEForm.Apper;
                    }

                    if (QEForm.Auper != "")
                    {
                        txtAuper.Text = QEForm.Auper;
                    }

                    if (QEForm.WatingAuper != "")
                    {
                        txtWating.Text = QEForm.WatingAuper;
                    }

                    if (QEForm.E_No != "")
                    {
                        txtNo.Text = QEForm.E_No;
                    }
                    if (QEForm.PONO != "")
                    {
                        txtPONo.Text = QEForm.PONO;
                    }
                    if (QEForm.GuestName != "")
                    {
                        txtGuestName.Text = QEForm.GuestName;
                    }


                    txtSPForm.Text = QEForm.SPForm;
                    txtSPTo.Text   = QEForm.SPTo;
                    select();
                }
                else
                {
                    tb_EFormService eformSer  = new tb_EFormService();
                    List <tb_EForm> allEForms = new List <tb_EForm>();// eformSer.GetListArray_1("");

                    this.gvList.DataSource = allEForms;
                    this.gvList.DataBind();
                }
            }
        }
示例#26
0
        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();
                }
            }
        }
示例#27
0
        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();
                }
            }
        }
示例#28
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                foreach (var m in comList)
                {
                    m.ComSimpName += "," + m.Id + "," + m.ComCode;
                }
                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComSimpName = "-1", ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();

                //txtStartTime.Text = (DateTime.Now.Year - 1) + "-1-1";


                List <TB_BasePoType> basePoTypeList  = new TB_BasePoTypeService().GetListArray("");
                List <TB_BasePoType> basePoTypeList1 = new TB_BasePoTypeService().GetListArray("");
                cbKaoList.DataSource = basePoTypeList1;
                cbKaoList.DataBind();
                cbKaoList.DataTextField  = "BasePoType";
                cbKaoList.DataValueField = "Id";

                basePoTypeList.Insert(0, new TB_BasePoType {
                    BasePoType = "全部", Id = -1
                });
                ddlPOTyle.DataSource = basePoTypeList;
                ddlPOTyle.DataBind();
                ddlPOTyle.DataTextField  = "BasePoType";
                ddlPOTyle.DataValueField = "Id";



                GuestTypeBaseInfoService dal = new GuestTypeBaseInfoService();
                var dalList = dal.GetListArray("");
                dalList.Insert(0, new VAN_OA.Model.BaseInfo.GuestTypeBaseInfo {
                    GuestType = "全部"
                });
                ddlGuestTypeList.DataSource = dalList;
                ddlGuestTypeList.DataBind();
                ddlGuestTypeList.DataTextField  = "GuestType";
                ddlGuestTypeList.DataValueField = "GuestType";

                GuestProBaseInfoService guestProBaseInfodal = new GuestProBaseInfoService();
                var proList = guestProBaseInfodal.GetListArray("");
                proList.Insert(0, new VAN_OA.Model.BaseInfo.GuestProBaseInfo {
                    GuestPro = -2
                });
                ddlGuestProList.DataSource = proList;
                ddlGuestProList.DataBind();
                ddlGuestProList.DataTextField  = "GuestProString";
                ddlGuestProList.DataValueField = "GuestPro";

                //主单
                List <JXC_REPORTTotal> pOOrderList = new List <JXC_REPORTTotal>();
                this.gvMain.DataSource = pOOrderList;
                this.gvMain.DataBind();

                //if (VAN_OA.JXC.SysObj.IfShowAll(SysObj.JXC_REPORTTotalList, Session["currentUserId"]) == false)
                //{
                //    ViewState["showAll"] = false;
                //}


                bool showAll = true;
                if (QuanXian_ShowAll("销售KPI 量化指标") == false)
                {
                    ViewState["showAll"] = false;
                    showAll = false;
                }



                bool WFScanDepartList = true;
                if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("销售KPI 量化指标", Session["currentUserId"], "WFScanDepartList") == true)
                {
                    ViewState["WFScanDepartList"] = false;
                    WFScanDepartList = false;
                }

                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                if (showAll == true)
                {
                    user = userSer.getAllUserByPOList();
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = -1
                    });
                }
                else if (WFScanDepartList == true)
                {
                    user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = 0
                    });
                }
                else
                {
                    var model = Session["userInfo"] as User;
                    user.Insert(0, model);
                }

                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";

                if (Request["PONo"] != null)
                {
                    txtPONo.Text = Request["PONo"].ToString();
                    Show();
                }
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                List <WFAEPromiseTotal> _list = new List <WFAEPromiseTotal>();
                this.gvList.DataSource = _list;
                this.gvList.DataBind();

                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");

                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComCode = "-1", ComName = "全部"
                });

                for (int i = 2012; i <= DateTime.Now.Year; i++)
                {
                    ddlYear.Items.Add(new ListItem {
                        Value = i.ToString(), Text = i.ToString()
                    });
                }
                ddlYear.SelectedValue = (DateTime.Now.Year).ToString();

                if (NewShowAll_textName("销售指标", "编辑") == false)
                {
                    gvList.Columns[1].Visible = false;
                    btnAdd.Visible            = false;
                }
                if (NewShowAll_textName("销售指标", "删除") == false)
                {
                    gvList.Columns[2].Visible = false;
                }
                bool showAll = true;

                if (NewShowAll_textName("销售指标", "查看所有"))
                {
                    ViewState["showAll"] = false;
                    showAll = false;
                }

                bool WFScanDepartList = true;
                if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("销售指标", Session["currentUserId"], "WFScanDepartList") == true)
                {
                    ViewState["WFScanDepartList"] = false;
                    WFScanDepartList = false;
                }
                List <VAN_OA.Model.User>  user    = new List <User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                if (showAll == true)
                {
                    user = userSer.getAllUserByPOList();
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = -1
                    });
                }
                else if (WFScanDepartList == true)
                {
                    user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = 0
                    });
                }
                else
                {
                    var model = Session["userInfo"] as User;
                    user.Insert(0, model);
                    ddlCompany.Enabled = false;
                }

                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "LoginName";

                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();
            }
        }
示例#30
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                TB_CompanyService comSer = new TB_CompanyService();
                var comList = comSer.GetListArray("");
                foreach (var m in comList)
                {
                    m.ComCode += "," + m.ComSimpName;
                }
                comList.Insert(0, new VAN_OA.Model.BaseInfo.TB_Company()
                {
                    ComCode = "-1", ComName = "全部"
                });
                ddlCompany.DataSource = comList;
                ddlCompany.DataBind();

                bool showAll = true;
                if (SysObj.IfShowAll("销售月考核", Session["currentUserId"], "ShowAll") == false)
                {
                    ViewState["showAll"] = false;
                    showAll = false;
                }

                bool WFScanDepartList = true;
                if (showAll == false && VAN_OA.JXC.SysObj.IfShowAll("销售月考核", Session["currentUserId"], "WFScanDepartList") == true)
                {
                    ViewState["WFScanDepartList"] = false;
                    WFScanDepartList = false;
                }

                List <VAN_OA.Model.User>  user    = new List <VAN_OA.Model.User>();
                VAN_OA.Dal.SysUserService userSer = new VAN_OA.Dal.SysUserService();
                if (showAll == true)
                {
                    user = userSer.getAllUserByPOList();
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = -1
                    });
                }
                else if (WFScanDepartList == true)
                {
                    user = userSer.getAllUserByLoginName(string.Format(" and loginIPosition in (select loginIPosition from tb_User where id={0}) and loginIPosition<>''", Session["currentUserId"]));
                    user.Insert(0, new VAN_OA.Model.User()
                    {
                        LoginName = "全部", Id = 0
                    });
                }
                else
                {
                    var model = Session["userInfo"] as User;
                    user.Insert(0, model);
                }
                ddlUser.DataSource = user;
                ddlUser.DataBind();
                ddlUser.DataTextField  = "LoginName";
                ddlUser.DataValueField = "Id";

                ds = new DataSet();
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
                ds.Tables.Add(new DataTable());
            }
        }