public int ModifyJia_BuyLog(Jia_BuyLog jia_buylog) { string sql = "update Jia_BuyLog set Nick=@Nick,Type=@Type,Price=@Price,BuyDate=@BuyDate,IsOld=@IsOld,AddDate=@AddDate where Guid=@Guid"; SqlParameter[] param = CreateParameter(jia_buylog); return(DBHelper.ExecuteNonQuery(sql, param)); }
public int AddJia_BuyLog(Jia_BuyLog jia_buylog) { string sql = "insert Jia_BuyLog values(@Nick,@Type,@Price,@BuyDate,@IsOld,@AddDate)"; SqlParameter[] param = CreateParameter(jia_buylog); return(DBHelper.ExecuteNonQuery(sql, param)); }
private SqlParameter[] CreateParameter(Jia_BuyLog jia_buylog) { SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Guid", jia_buylog.Guid), new SqlParameter("@Nick", jia_buylog.Nick), new SqlParameter("@Type", jia_buylog.Type), new SqlParameter("@Price", jia_buylog.Price), new SqlParameter("@BuyDate", jia_buylog.BuyDate), new SqlParameter("@IsOld", jia_buylog.IsOld), new SqlParameter("@AddDate", jia_buylog.AddDate) }; return(param); }
private IList <Jia_BuyLog> Jia_BuyLogPropertity(string sql, params SqlParameter[] param) { DataTable dt = DBHelper.ExecuteDataTable(sql, param); IList <Jia_BuyLog> list = new List <Jia_BuyLog>(); foreach (DataRow dr in dt.Rows) { Jia_BuyLog jia_buylog = new Jia_BuyLog(); jia_buylog.Guid = Convert.ToString(dr["Guid"]); jia_buylog.Nick = Convert.ToString(dr["Nick"]); jia_buylog.Type = Convert.ToString(dr["Type"]); jia_buylog.Price = Convert.ToDecimal(dr["Price"]); jia_buylog.BuyDate = Convert.ToInt32(dr["BuyDate"]); jia_buylog.IsOld = Convert.ToInt32(dr["IsOld"]); jia_buylog.AddDate = Convert.ToDateTime(dr["AddDate"]); list.Add(jia_buylog); } return(list); }