Beispiel #1
0
        /// <summary>
        /// 根据给定的主表编号,返回明细表的实体列表。
        /// </summary>
        /// <param name="iStockID">主表编号</param>
        /// <returns></returns>
        public List <lgk.Model.tb_StockBuy> GetModelList(string strWhere)
        {
            StringBuilder strSql = new StringBuilder();
            List <lgk.Model.tb_StockBuy> myList = new List <lgk.Model.tb_StockBuy>();

            DataSet ds = dal.GetList(strWhere);

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(myList);
            }

            lgk.Model.tb_StockBuy model;
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                model = new lgk.Model.tb_StockBuy();

                if (row["StockBuyID"] != null && row["StockBuyID"].ToString() != "")
                {
                    model.StockBuyID = long.Parse(row["StockBuyID"].ToString());
                }
                if (row["UserID"] != null && row["UserID"].ToString() != "")
                {
                    model.UserID = long.Parse(row["UserID"].ToString());
                }
                if (row["Amount"] != null && row["Amount"].ToString() != "")
                {
                    model.Amount = decimal.Parse(row["Amount"].ToString());
                }
                if (row["SurplusSum"] != null && row["SurplusSum"].ToString() != "")
                {
                    model.SurplusSum = decimal.Parse(row["SurplusSum"].ToString());
                }
                if (row["BuyDate"] != null && row["BuyDate"].ToString() != "")
                {
                    model.BuyDate = DateTime.Parse(row["BuyDate"].ToString());
                }
                if (row["IsBuy"] != null && row["IsBuy"].ToString() != "")
                {
                    model.IsBuy = int.Parse(row["IsBuy"].ToString());
                }
                if (row["Status"] != null && row["Status"].ToString() != "")
                {
                    model.Status = int.Parse(row["Status"].ToString());
                }
                myList.Add(model);
            }

            return(myList);
        }
Beispiel #2
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(lgk.Model.tb_StockBuy model)
 {
     return(dal.Update(model));
 }
Beispiel #3
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public long Add(lgk.Model.tb_StockBuy model)
 {
     return(dal.Add(model));
 }