/// <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));
}
