/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_Product_Photo DataRowToModel(DataRow row)
{
WebApi_Model.T_Product_Photo model = new WebApi_Model.T_Product_Photo();
if (row != null)
{
if (row["ProductPhotoID"] != null && row["ProductPhotoID"].ToString() != "")
{
model.ProductPhotoID = int.Parse(row["ProductPhotoID"].ToString());
}
if (row["ProductID"] != null && row["ProductID"].ToString() != "")
{
model.ProductID = int.Parse(row["ProductID"].ToString());
}
if (row["ImgPath"] != null)
{
model.ImgPath = row["ImgPath"].ToString();
}
if (row["ImgRemark"] != null)
{
model.ImgRemark = row["ImgRemark"].ToString();
}
if (row["ImgType"] != null && row["ImgType"].ToString() != "")
{
model.ImgType = int.Parse(row["ImgType"].ToString());
}
if (row["Sorting"] != null && row["Sorting"].ToString() != "")
{
model.Sorting = int.Parse(row["Sorting"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(WebApi_Model.T_Product_Photo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into T_Product_Photo(");
strSql.Append("ProductID,ImgPath,ImgRemark,ImgType,Sorting)");
strSql.Append(" values (");
strSql.Append("@ProductID,@ImgPath,@ImgRemark,@ImgType,@Sorting)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ProductID", SqlDbType.Int, 4),
new SqlParameter("@ImgPath", SqlDbType.NVarChar, 32),
new SqlParameter("@ImgRemark", SqlDbType.NVarChar, 40),
new SqlParameter("@ImgType", SqlDbType.Int, 4),
new SqlParameter("@Sorting", SqlDbType.Int, 4)
};
parameters[0].Value = model.ProductID;
parameters[1].Value = model.ImgPath;
parameters[2].Value = model.ImgRemark;
parameters[3].Value = model.ImgType;
parameters[4].Value = model.Sorting;
object obj = DBHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(WebApi_Model.T_Product_Photo model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update T_Product_Photo set ");
strSql.Append("ProductID=@ProductID,");
strSql.Append("ImgPath=@ImgPath,");
strSql.Append("ImgRemark=@ImgRemark,");
strSql.Append("ImgType=@ImgType,");
strSql.Append("Sorting=@Sorting");
strSql.Append(" where ProductPhotoID=@ProductPhotoID");
SqlParameter[] parameters =
{
new SqlParameter("@ProductID", SqlDbType.Int, 4),
new SqlParameter("@ImgPath", SqlDbType.NVarChar, 32),
new SqlParameter("@ImgRemark", SqlDbType.NVarChar, 40),
new SqlParameter("@ImgType", SqlDbType.Int, 4),
new SqlParameter("@Sorting", SqlDbType.Int, 4),
new SqlParameter("@ProductPhotoID", SqlDbType.Int, 4)
};
parameters[0].Value = model.ProductID;
parameters[1].Value = model.ImgPath;
parameters[2].Value = model.ImgRemark;
parameters[3].Value = model.ImgType;
parameters[4].Value = model.Sorting;
parameters[5].Value = model.ProductPhotoID;
int rows = DBHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public WebApi_Model.T_Product_Photo GetModel(int ProductPhotoID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ProductPhotoID,ProductID,ImgPath,ImgRemark,ImgType,Sorting from T_Product_Photo ");
strSql.Append(" where ProductPhotoID=@ProductPhotoID");
SqlParameter[] parameters =
{
new SqlParameter("@ProductPhotoID", SqlDbType.Int, 4)
};
parameters[0].Value = ProductPhotoID;
WebApi_Model.T_Product_Photo model = new WebApi_Model.T_Product_Photo();
DataSet ds = DBHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
