public int ModifyJia_Img(Jia_Img jia_img)
{
string sql = "update Jia_Img set TplId=@TplId,Tag=@Tag,JiaImg=@JiaImg where Guid=@Guid";
SqlParameter[] param = CreateParameter(jia_img);
return(DBHelper.ExecuteNonQuery(sql, param));
}
public int AddJia_Img(Jia_Img jia_img)
{
string sql = "insert Jia_Img values(@TplId,@Tag,@JiaImg)";
SqlParameter[] param = CreateParameter(jia_img);
return(DBHelper.ExecuteNonQuery(sql, param));
}
private SqlParameter[] CreateParameter(Jia_Img jia_img)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@Guid", jia_img.Guid),
new SqlParameter("@TplId", jia_img.TplId),
new SqlParameter("@Tag", jia_img.Tag),
new SqlParameter("@JiaImg", jia_img.JiaImg)
};
return(param);
}
private IList <Jia_Img> Jia_ImgPropertity(string sql, params SqlParameter[] param)
{
DataTable dt = DBHelper.ExecuteDataTable(sql, param);
IList <Jia_Img> list = new List <Jia_Img>();
foreach (DataRow dr in dt.Rows)
{
Jia_Img jia_img = new Jia_Img();
jia_img.Guid = Convert.ToString(dr["Guid"]);
jia_img.TplId = Convert.ToString(dr["TplId"]);
jia_img.Tag = Convert.ToString(dr["Tag"]);
jia_img.JiaImg = Convert.ToString(dr["JiaImg"]);
list.Add(jia_img);
}
return(list);
}
