Example #1
0
        /// <summary>
        /// 获得数据列表
        /// </summary>
        /// <returns></returns>
        public static List <SupplyInfo> GetList()
        {
            string cacheKey = GetCacheKey();

            //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取
            if (CachedEntityCommander.IsTypeRegistered(typeof(SupplyInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
            {
                return(CachedEntityCommander.GetCache(cacheKey) as List <SupplyInfo>);
            }
            else
            {
                List <SupplyInfo> list       = new List <SupplyInfo>();
                SupplyCollection  collection = new  SupplyCollection();
                Query             qry        = new Query(Supply.Schema);
                collection.LoadAndCloseReader(qry.ExecuteReader());
                foreach (Supply supply in collection)
                {
                    SupplyInfo supplyInfo = new SupplyInfo();
                    LoadFromDAL(supplyInfo, supply);
                    list.Add(supplyInfo);
                }
                //生成缓存
                if (CachedEntityCommander.IsTypeRegistered(typeof(SupplyInfo)))
                {
                    CachedEntityCommander.SetCache(cacheKey, list);
                }
                return(list);
            }
        }
Example #2
0
        //数据持久化
        internal static void  SaveToDb(SupplyInfo pSupplyInfo, Supply pSupply, bool pIsNew)
        {
            pSupply.SupplyId   = pSupplyInfo.supplyId;
            pSupply.SupplyName = pSupplyInfo.supplyName;
            pSupply.SheetNum   = pSupplyInfo.sheetNum;
            pSupply.IsNew      = pIsNew;
            string UserName = SubsonicHelper.GetUserName();

            try
            {
                pSupply.Save(UserName);
            }
            catch (Exception ex)
            {
                LogManager.getInstance().getLogger(typeof(SupplyInfo)).Error(ex);
                if (ex.Message.Contains("插入重复键"))               //违反了唯一键
                {
                    throw new AppException("此对象已经存在");          //此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示
                }
                throw new AppException("保存失败");
            }
            pSupplyInfo.supplyId = pSupply.SupplyId;
            //如果缓存存在,更新缓存
            if (CachedEntityCommander.IsTypeRegistered(typeof(SupplyInfo)))
            {
                ResetCache();
            }
        }
Example #3
0
        /// <summary>
        /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据
        /// </summary>
        /// <param name="pPageIndex">页数</param>
        /// <param name="pPageSize">每页列表</param>
        /// <param name="pOrderBy">排序</param>
        /// <param name="pSortExpression">排序字段</param>
        /// <param name="pRecordCount">列表行数</param>
        /// <returns>数据分页</returns>
        public static List <SupplyInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
        {
            if (pPageIndex <= 1)
            {
                pPageIndex = 1;
            }
            List <SupplyInfo> list = new List <SupplyInfo>();

            Query q = Supply.CreateQuery();

            q.PageIndex = pPageIndex;
            q.PageSize  = pPageSize;
            q.ORDER_BY(pSortExpression, pOrderBy.ToString());
            SupplyCollection collection = new  SupplyCollection();

            collection.LoadAndCloseReader(q.ExecuteReader());

            foreach (Supply supply  in collection)
            {
                SupplyInfo supplyInfo = new SupplyInfo();
                LoadFromDAL(supplyInfo, supply);
                list.Add(supplyInfo);
            }
            pRecordCount = q.GetRecordCount();

            return(list);
        }
Example #4
0
 /// <summary>
 /// 复制一个对象,采用硬编码的方式,避免反射的低效
 /// </summary>
 /// <param name="pIndustryTypeInfoFrom"></param>
 /// <param name="pIndustryTypeInfoTo"></param>
 public static void Copy(SupplyInfo pSupplyInfoFrom, SupplyInfo pSupplyInfoTo)
 {
     pSupplyInfoTo.SupplyId   = pSupplyInfoFrom.supplyId;
     pSupplyInfoTo.SupplyName = pSupplyInfoFrom.supplyName;
     pSupplyInfoTo.SheetNum   = pSupplyInfoFrom.sheetNum;
     pSupplyInfoTo.Loaded     = pSupplyInfoFrom.Loaded;
 }
Example #5
0
 //从后台获取数据
 internal static void  LoadFromDAL(SupplyInfo pSupplyInfo, Supply pSupply)
 {
     pSupplyInfo.supplyId   = pSupply.SupplyId;
     pSupplyInfo.supplyName = pSupply.SupplyName;
     pSupplyInfo.sheetNum   = pSupply.SheetNum;
     pSupplyInfo.Loaded     = true;
 }
Example #6
0
 /// <summary>
 /// 批量装载
 /// </summary>
 internal static void LoadFromDALPatch(List <SupplyInfo> pList, SupplyCollection pCollection)
 {
     foreach (Supply supply in pCollection)
     {
         SupplyInfo supplyInfo = new SupplyInfo();
         LoadFromDAL(supplyInfo, supply);
         pList.Add(supplyInfo);
     }
 }
Example #7
0
        public SupplyInfo GetSupplyInfoById(int SupplyId)
        {
            SupplyInfo supplyInfo = null;             //

            try
            {
                supplyInfo = new SupplyInfo(SupplyId);
            }
            catch (AppException)
            {
                return(null);
            }

            return(supplyInfo);
        }
Example #8
0
        public SupplyInfo GetSupplyInfoById(int SupplyId)
        {
            SupplyInfo supplyInfo  = null;//
            try
            {
                 supplyInfo = new SupplyInfo(SupplyId);

            }
            catch (AppException)
            {
                return null;
            }

            return  supplyInfo;
        }
Example #9
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     if (PageInit())
     {
         try
         {
             SupplyInfo sp = new SupplyInfo();
             sp.SheetNum = txtSheetNum.Text.ToString();
             sp.SupplyName = txtName.Text.ToString();
             sp.Save();
             Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script language='javascript'>alert('��ӳɹ���');</script>");
         }
         catch (Exception Ex)
         {
             ClientScript.RegisterStartupScript(this.GetType(), "Save", "alert('���ʧ�ܣ�" + Ex.Message + "');", true);
         }
     }
 }
Example #10
0
 protected void ddlAuto_SelectedIndexChanged(object sender, EventArgs e)
 {
     string strtoday = DateTime.Now.ToString("yyyyMMdd").Substring(2);
     if (ddlContractType.SelectedItem.Text == "���ۺ�ͬ")
     {
         ClientInfo client = new ClientInfo(Convert.ToInt32(ddlAuto.SelectedValue));
         if (SheetNums.IsNumOfContract(client.ClientName.ToString()))
         {
             txtContractNum.Text = SheetNums.NumOfContract("XS", client.SheetNum.ToString(), strtoday, client.ClientName.ToString());
         }
         else
         {
             txtContractNum.Text = "XS" + client.SheetNum.ToString() + strtoday + "001";
         }
     }
     else if (ddlContractType.SelectedItem.Text == "�ɹ���ͬ")
     {
         SupplyInfo supply = new SupplyInfo(Convert.ToInt32(ddlAuto.SelectedValue));
         if (SheetNums.IsNumOfContract(supply.SheetNum.ToString()))
         {
             txtContractNum.Text = SheetNums.NumOfContract("CG", supply.SheetNum.ToString(), strtoday, supply.SheetNum.ToString());
         }
         else
         {
             txtContractNum.Text = "CG" + supply.SheetNum.ToString() + strtoday + "001";
         }
     }
     else if (ddlContractType.SelectedItem.Text == "��")
     {
         SupplyInfo supply = new SupplyInfo(Convert.ToInt32(ddlAuto.SelectedValue));
         string sheetnum = supply.SheetNum.ToString();
         if (SheetNums.IsNumOfContract(supply.SheetNum.ToString()))
         {
             txtContractNum.Text = SheetNums.NumOfContract("XY", sheetnum, strtoday, supply.SheetNum.ToString());
         }
         else
         {
             txtContractNum.Text = "XY" + supply.SheetNum.ToString() + strtoday + "001";
         }
     }
 }
Example #11
0
 private void LoadFromId(int supplyId)
 {
     if (CachedEntityCommander.IsTypeRegistered(typeof(SupplyInfo)))
     {
         SupplyInfo supplyInfo = Find(GetList(), supplyId);
         if (supplyInfo == null)
         {
             throw new AppException("未能在缓存中找到相应的键值对象");
         }
         Copy(supplyInfo, this);
     }
     else
     {
         Supply supply = new Supply(supplyId);
         if (supply.IsNew)
         {
             throw new AppException("尚未初始化");
         }
         LoadFromDAL(this, supply);
     }
 }
Example #12
0
 /// <summary>
 /// 批量装载
 /// </summary>
 internal static void LoadFromDALPatch(List< SupplyInfo> pList, SupplyCollection pCollection)
 {
     foreach (Supply supply in pCollection)
     {
         SupplyInfo supplyInfo = new SupplyInfo();
         LoadFromDAL(supplyInfo, supply );
         pList.Add(supplyInfo);
     }
 }
Example #13
0
 /// <summary>
 /// 复制为另一个对象
 /// </summary>
 /// <param name="pIndustryTypeInfoTo"></param>
 public void CopyTo(SupplyInfo pSupplyInfoTo)
 {
     Copy(this,  pSupplyInfoTo);
 }
Example #14
0
 //从后台获取数据
 internal static void LoadFromDAL(SupplyInfo pSupplyInfo, Supply  pSupply)
 {
     pSupplyInfo.supplyId = pSupply.SupplyId;
      		pSupplyInfo.supplyName = pSupply.SupplyName;
      		pSupplyInfo.sheetNum = pSupply.SheetNum;
     pSupplyInfo.Loaded=true;
 }
Example #15
0
 /// <summary>
 /// 获得数据列表
 /// </summary>
 /// <returns></returns>
 public static List<SupplyInfo> GetList()
 {
     string cacheKey = GetCacheKey();
     //本实体已经注册成缓存实体,并且缓存存在的时候,直接从缓存取
     if (CachedEntityCommander.IsTypeRegistered(typeof(SupplyInfo)) && CachedEntityCommander.GetCache(cacheKey) != null)
     {
         return CachedEntityCommander.GetCache(cacheKey) as List< SupplyInfo>;
     }
     else
     {
         List< SupplyInfo>  list =new List< SupplyInfo>();
         SupplyCollection  collection=new  SupplyCollection();
         Query qry = new Query(Supply.Schema);
         collection.LoadAndCloseReader(qry.ExecuteReader());
         foreach(Supply supply in collection)
         {
             SupplyInfo supplyInfo= new SupplyInfo();
             LoadFromDAL(supplyInfo,supply);
             list.Add(supplyInfo);
         }
       	//生成缓存
         if (CachedEntityCommander.IsTypeRegistered(typeof(SupplyInfo)))
         {
             CachedEntityCommander.SetCache(cacheKey, list);
         }
         return list;
     }
 }
Example #16
0
        /// <summary>
        /// 获得分页列表,无论是否是缓存实体都从数据库直接拿取数据
        /// </summary>
        /// <param name="pPageIndex">页数</param>
        /// <param name="pPageSize">每页列表</param>
        /// <param name="pOrderBy">排序</param>
        /// <param name="pSortExpression">排序字段</param>
        /// <param name="pRecordCount">列表行数</param>
        /// <returns>数据分页</returns>
        public static List<SupplyInfo> GetPagedList(int pPageIndex,int pPageSize,SortDirection pOrderBy,string pSortExpression,out int pRecordCount)
        {
            if(pPageIndex<=1)
            pPageIndex=1;
            List< SupplyInfo> list = new List< SupplyInfo>();

            Query q = Supply .CreateQuery();
            q.PageIndex = pPageIndex;
            q.PageSize = pPageSize;
            q.ORDER_BY(pSortExpression,pOrderBy.ToString());
            SupplyCollection  collection=new  SupplyCollection();
             	collection.LoadAndCloseReader(q.ExecuteReader());

            foreach (Supply  supply  in collection)
            {
                SupplyInfo supplyInfo = new SupplyInfo();
                LoadFromDAL(supplyInfo,   supply);
                list.Add(supplyInfo);
            }
            pRecordCount=q.GetRecordCount();

            return list;
        }
Example #17
0
 public object  SaveSupplyInfo(SupplyInfo supplyInfo)
 {
     supplyInfo.Save();
     return(supplyInfo.SupplyId);
 }
Example #18
0
 /// <summary>
 /// 复制一个对象,采用硬编码的方式,避免反射的低效
 /// </summary>
 /// <param name="pIndustryTypeInfoFrom"></param>
 /// <param name="pIndustryTypeInfoTo"></param>
 public static void Copy(SupplyInfo pSupplyInfoFrom, SupplyInfo pSupplyInfoTo)
 {
     pSupplyInfoTo.SupplyId = pSupplyInfoFrom.supplyId;
      		pSupplyInfoTo.SupplyName = pSupplyInfoFrom.supplyName;
      		pSupplyInfoTo.SheetNum = pSupplyInfoFrom.sheetNum;
     pSupplyInfoTo.Loaded=pSupplyInfoFrom.Loaded;
 }
Example #19
0
 public List <SupplyInfo> GetPagedList(int pPageIndex, int pPageSize, SortDirection pOrderBy, string pSortExpression, out int pRecordCount)
 {
     return(SupplyInfo.GetPagedList(pPageIndex, pPageSize, pOrderBy, pSortExpression, out pRecordCount));
 }
Example #20
0
 public List <SupplyInfo> GetSupplyInfoList()
 {
     return(SupplyInfo.GetList());
 }
Example #21
0
 public object SaveSupplyInfo(SupplyInfo supplyInfo)
 {
     supplyInfo.Save();
     return supplyInfo . SupplyId;
 }
Example #22
0
 /// <summary>
 /// 复制为另一个对象
 /// </summary>
 /// <param name="pIndustryTypeInfoTo"></param>
 public void CopyTo(SupplyInfo pSupplyInfoTo)
 {
     Copy(this, pSupplyInfoTo);
 }
Example #23
0
 //数据持久化
 internal static void SaveToDb(SupplyInfo pSupplyInfo, Supply  pSupply,bool pIsNew)
 {
     pSupply.SupplyId = pSupplyInfo.supplyId;
      		pSupply.SupplyName = pSupplyInfo.supplyName;
      		pSupply.SheetNum = pSupplyInfo.sheetNum;
     pSupply.IsNew=pIsNew;
     string UserName = SubsonicHelper.GetUserName();
     try
     {
         pSupply.Save(UserName);
     }
     catch(Exception ex)
     {
         LogManager.getInstance().getLogger(typeof(SupplyInfo)).Error(ex);
         if(ex.Message.Contains("插入重复键"))//违反了唯一键
         {
             throw new AppException("此对象已经存在");//此处等待优化可以从唯一约束中直接取出提示来,如果没有的话,默认为原始的出错提示
         }
         throw new AppException("保存失败");
     }
     pSupplyInfo.supplyId = pSupply.SupplyId;
     //如果缓存存在,更新缓存
     if (CachedEntityCommander.IsTypeRegistered(typeof(SupplyInfo)))
     {
         ResetCache();
     }
 }
Example #24
0
        public void DeleteById(SupplyInfo pSupplyInfo)
        {
            SupplyInfo supplyInfo = new SupplyInfo(pSupplyInfo.SupplyId);

            supplyInfo.Delete();
        }
Example #25
0
 public void DeleteById(SupplyInfo pSupplyInfo)
 {
     SupplyInfo supplyInfo = new SupplyInfo(pSupplyInfo.SupplyId);
     supplyInfo.Delete();
 }