/// <summary> /// 更新一条数据 /// </summary> public bool Update(StockInfo_Item model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update Shop_StockInfo_Item set "); strSql.Append("StockInfoId=@StockInfoId,"); strSql.Append("ShopNumber=@ShopNumber,"); strSql.Append("Size=@Size,"); strSql.Append("Color=@Color,"); strSql.Append("Number=@Number,"); strSql.Append("CreateBy=@CreateBy,"); strSql.Append("CreateDate=@CreateDate,"); strSql.Append("UpdateBy=@UpdateBy,"); strSql.Append("UpdateDate=@UpdateDate"); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@StockInfoId", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ShopNumber", SqlDbType.VarChar, 100), new SqlParameter("@Size", SqlDbType.VarChar, 20), new SqlParameter("@Color", SqlDbType.VarChar, 50), new SqlParameter("@Number", SqlDbType.Int, 4), new SqlParameter("@CreateBy", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@UpdateBy", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UpdateDate", SqlDbType.DateTime), new SqlParameter("@Id", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = model.StockInfoId; parameters[1].Value = model.ShopNumber; parameters[2].Value = model.Size; parameters[3].Value = model.Color; parameters[4].Value = model.Number; parameters[5].Value = model.CreateBy; parameters[6].Value = model.CreateDate; parameters[7].Value = model.UpdateBy; parameters[8].Value = model.UpdateDate; parameters[9].Value = model.Id; int rows = _db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public StockInfo_Item DataRowToModel(DataRow row) { StockInfo_Item model = new StockInfo_Item(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = new Guid(row["Id"].ToString()); } if (row["StockInfoId"] != null && row["StockInfoId"].ToString() != "") { model.StockInfoId = new Guid(row["StockInfoId"].ToString()); } if (row["ShopNumber"] != null) { model.ShopNumber = row["ShopNumber"].ToString(); } if (row["Size"] != null) { model.Size = row["Size"].ToString(); } if (row["Color"] != null) { model.Color = row["Color"].ToString(); } if (row["Number"] != null && row["Number"].ToString() != "") { model.Number = int.Parse(row["Number"].ToString()); } if (row["CreateBy"] != null && row["CreateBy"].ToString() != "") { model.CreateBy = new Guid(row["CreateBy"].ToString()); } if (row["CreateDate"] != null && row["CreateDate"].ToString() != "") { model.CreateDate = DateTime.Parse(row["CreateDate"].ToString()); } if (row["UpdateBy"] != null && row["UpdateBy"].ToString() != "") { model.UpdateBy = new Guid(row["UpdateBy"].ToString()); } if (row["UpdateDate"] != null && row["UpdateDate"].ToString() != "") { model.UpdateDate = DateTime.Parse(row["UpdateDate"].ToString()); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(StockInfo_Item model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Shop_StockInfo_Item("); strSql.Append("Id,StockInfoId,ShopNumber,Size,Color,Number,CreateBy,CreateDate,UpdateBy,UpdateDate)"); strSql.Append(" values ("); strSql.Append("@Id,@StockInfoId,@ShopNumber,@Size,@Color,@Number,@CreateBy,@CreateDate,@UpdateBy,@UpdateDate)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@StockInfoId", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@ShopNumber", SqlDbType.VarChar, 100), new SqlParameter("@Size", SqlDbType.VarChar, 20), new SqlParameter("@Color", SqlDbType.VarChar, 50), new SqlParameter("@Number", SqlDbType.Int, 4), new SqlParameter("@CreateBy", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@CreateDate", SqlDbType.DateTime), new SqlParameter("@UpdateBy", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UpdateDate", SqlDbType.DateTime) }; parameters[0].Value = model.Id; parameters[1].Value = model.StockInfoId; parameters[2].Value = model.ShopNumber; parameters[3].Value = model.Size; parameters[4].Value = model.Color; parameters[5].Value = model.Number; parameters[6].Value = model.CreateBy; parameters[7].Value = model.CreateDate; parameters[8].Value = model.UpdateBy; parameters[9].Value = model.UpdateDate; int rows = _db.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/* * /// <summary> * /// 分页获取数据列表 * /// </summary> * public DataSet GetList(int PageSize,int PageIndex,string strWhere) * { * SqlParameter[] parameters = { * new SqlParameter("@tblName", SqlDbType.VarChar, 255), * new SqlParameter("@fldName", SqlDbType.VarChar, 255), * new SqlParameter("@PageSize", SqlDbType.Int), * new SqlParameter("@PageIndex", SqlDbType.Int), * new SqlParameter("@IsReCount", SqlDbType.Bit), * new SqlParameter("@OrderType", SqlDbType.Bit), * new SqlParameter("@strWhere", SqlDbType.VarChar,1000), * }; * parameters[0].Value = "Shop_StockInfo_Item"; * parameters[1].Value = "Id"; * parameters[2].Value = PageSize; * parameters[3].Value = PageIndex; * parameters[4].Value = 0; * parameters[5].Value = 0; * parameters[6].Value = strWhere; * return _db.RunProcedure("UP_GetRecordByPage",parameters,"ds"); * }*/ #endregion BasicMethod #region ExtensionMethod /// <summary> /// 根据条件得到商品详细信息 /// </summary> /// <param name="top">返回条数</param> /// <param name="strWhere">条件</param> /// <param name="orderby">排序</param> /// <returns>List<StockInfo/></returns> public List <StockInfo_Item> GetStockList(int top, string strWhere, string orderby) { List <StockInfo_Item> stockLsitem = new List <StockInfo_Item>(); DataSet dsStockLs = GetList(top, strWhere, orderby); if (dsStockLs != null && dsStockLs.Tables[0] != null && dsStockLs.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsStockLs.Tables[0].Rows) { StockInfo_Item stockModel = null; stockModel = DataRowToModel(dr); if (stockModel != null) { stockLsitem.Add(stockModel); } } } return(stockLsitem); }
/// <summary> /// 得到一个对象实体 /// </summary> public StockInfo_Item GetModel(Guid Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,StockInfoId,ShopNumber,Size,Color,Number,CreateBy,CreateDate,UpdateBy,UpdateDate from Shop_StockInfo_Item "); strSql.Append(" where Id=@Id "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.UniqueIdentifier, 16) }; parameters[0].Value = Id; StockInfo_Item model = new StockInfo_Item(); DataSet ds = _db.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(StockInfo_Item model) { return(StockInfo_ItemDAL.instance.Update(model)); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(StockInfo_Item model) { return(StockInfo_ItemDAL.instance.Add(model)); }