/// <summary>
/// 更新一条数据
/// </summary>
public void UpdateProductsStorageLog(ProductsStorageLogInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbProductsStorageLogInfo set ");
strSql.Append("StorageID=@StorageID,");
strSql.Append("ProductsID=@ProductsID,");
strSql.Append("OrderID=@OrderID,");
strSql.Append("pQuantity=@pQuantity,");
strSql.Append("pType=@pType,");
strSql.Append("pAppendTime=@pAppendTime,");
strSql.Append("pState=@pState");
strSql.Append(" where ProductsStorageLogID=@ProductsStorageLogID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductsStorageLogID", SqlDbType.Int, 4),
new SqlParameter("@StorageID", SqlDbType.Int, 4),
new SqlParameter("@ProductsID", SqlDbType.Int, 4),
new SqlParameter("@OrderID", SqlDbType.Int, 4),
new SqlParameter("@pQuantity", SqlDbType.Decimal, 9),
new SqlParameter("@pType", SqlDbType.Int, 4),
new SqlParameter("@pAppendTime", SqlDbType.DateTime),
new SqlParameter("@pState", SqlDbType.Int, 4)
};
parameters[0].Value = model.ProductsStorageLogID;
parameters[1].Value = model.StorageID;
parameters[2].Value = model.ProductsID;
parameters[3].Value = model.OrderID;
parameters[4].Value = model.pQuantity;
parameters[5].Value = model.pType;
parameters[6].Value = model.pAppendTime;
parameters[7].Value = model.pState;
DbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString());
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ProductsStorageLogInfo GetProductsStorageLogModel(int ProductsStorageLogID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ProductsStorageLogID,StorageID,ProductsID,OrderID,pQuantity,pType,pAppendTime,pState from tbProductsStorageLogInfo ");
strSql.Append(" where ProductsStorageLogID=@ProductsStorageLogID ");
SqlParameter[] parameters =
{
new SqlParameter("@ProductsStorageLogID", SqlDbType.Int, 4)
};
parameters[0].Value = ProductsStorageLogID;
ProductsStorageLogInfo model = new ProductsStorageLogInfo();
DataSet ds = DbHelper.ExecuteDataset(CommandType.Text, strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ProductsStorageLogID"].ToString() != "")
{
model.ProductsStorageLogID = int.Parse(ds.Tables[0].Rows[0]["ProductsStorageLogID"].ToString());
}
if (ds.Tables[0].Rows[0]["StorageID"].ToString() != "")
{
model.StorageID = int.Parse(ds.Tables[0].Rows[0]["StorageID"].ToString());
}
if (ds.Tables[0].Rows[0]["ProductsID"].ToString() != "")
{
model.ProductsID = int.Parse(ds.Tables[0].Rows[0]["ProductsID"].ToString());
}
if (ds.Tables[0].Rows[0]["OrderID"].ToString() != "")
{
model.OrderID = int.Parse(ds.Tables[0].Rows[0]["OrderID"].ToString());
}
if (ds.Tables[0].Rows[0]["pQuantity"].ToString() != "")
{
model.pQuantity = decimal.Parse(ds.Tables[0].Rows[0]["pQuantity"].ToString());
}
if (ds.Tables[0].Rows[0]["pType"].ToString() != "")
{
model.pType = int.Parse(ds.Tables[0].Rows[0]["pType"].ToString());
}
if (ds.Tables[0].Rows[0]["pAppendTime"].ToString() != "")
{
model.pAppendTime = DateTime.Parse(ds.Tables[0].Rows[0]["pAppendTime"].ToString());
}
if (ds.Tables[0].Rows[0]["pState"].ToString() != "")
{
model.pState = int.Parse(ds.Tables[0].Rows[0]["pState"].ToString());
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int AddProductsStorageLog(ProductsStorageLogInfo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbProductsStorageLogInfo(");
strSql.Append("StorageID,ProductsID,OrderID,pQuantity,pType,pAppendTime,pState)");
strSql.Append(" values (");
strSql.Append("@StorageID,@ProductsID,@OrderID,@pQuantity,@pType,@pAppendTime,@pState)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@StorageID", SqlDbType.Int, 4),
new SqlParameter("@ProductsID", SqlDbType.Int, 4),
new SqlParameter("@OrderID", SqlDbType.Int, 4),
new SqlParameter("@pQuantity", SqlDbType.Decimal, 9),
new SqlParameter("@pType", SqlDbType.Int, 4),
new SqlParameter("@pAppendTime", SqlDbType.DateTime),
new SqlParameter("@pState", SqlDbType.Int, 4)
};
parameters[0].Value = model.StorageID;
parameters[1].Value = model.ProductsID;
parameters[2].Value = model.OrderID;
parameters[3].Value = model.pQuantity;
parameters[4].Value = model.pType;
parameters[5].Value = model.pAppendTime;
parameters[6].Value = model.pState;
object obj = DbHelper.ExecuteScalar(CommandType.Text, strSql.ToString(), parameters);
if (obj == null)
{
return(-1);
}
else
{
return(Convert.ToInt32(obj));
}
}
public static void UpdateProductsStorageLog(ProductsStorageLogInfo model)
{
DatabaseProvider.GetInstance().UpdateProductsStorageLog(model);
}
public static int AddProductsStorageLog(ProductsStorageLogInfo model)
{
return(DatabaseProvider.GetInstance().AddProductsStorageLog(model));
}
