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