Пример #1
0
        /// <summary>
        ///   GridView数据导入方法
        /// </summary>
        private void LoadData()
        {
            List <MMS_PurchasePlanContent> infoList = new List <MMS_PurchasePlanContent>();

            //调用业务层方法取采购计划单列表
            infoList = PurchasePlanService.Instance.GetAllInfo();
            RM.Busines.DAL.RM_UserInfo_Dal daluser = new Busines.DAL.RM_UserInfo_Dal();


            //取所有的字典信息
            List <Base_DictionaryInfo> dictList = DictionaryInfoService.Instance.GetAllInfo();

            var query = from info in infoList
                        where ((info.AuditFlag == null || info.AuditFlag == false) && info.PayMode == "2" && info.PurchaseMan.Contains(RequestSession.GetSessionUser().UserAccount.ToString().Trim())) || (info.PayMode == "1" && info.InvoiceType.Contains(RequestSession.GetSessionUser().UserAccount.ToString().Trim()))
                        select new
            {
                id = info.ID,
                info.PurchaseBillCode,
                info.PurchaseMan,
                info.PurchaseDate,
                info.InvoiceCode,
                info.DeptName,
                info.AuditFlag,
                info.PayMode,
                Operator = daluser.GetUserInfo(info.Operator).Rows[0]["User_Name"].ToString().Trim()
            };
            DataTable dt = DataTableHelper.CopyToDataTable(query);


            ControlBindHelper.BindRepeaterList(dt, this.rp_Item);
            //dgvInfo.DataKeyNames = new[] {"ID"}; //设置GridView数据主键
            //dgvInfo.DataSource = query.ToList(); //设置GridView数据源
            //dgvInfo.DataBind();
        }