public bool UpdatePaimaiInfo(Entity.Goods.PaimaiInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update PaimaiInfo set "); strSql.Append(" PaimaiInfoID = @PaimaiInfoID , "); strSql.Append(" Deposit = @Deposit , "); strSql.Append(" Interval = @Interval , "); strSql.Append(" Mode = @Mode , "); strSql.Append(" Reserve = @Reserve , "); strSql.Append(" ValidHour = @ValidHour , "); strSql.Append(" ValidMinute = @ValidMinute "); strSql.Append(" where PaimaiInfoID=@PaimaiInfoID "); SqlParameter[] parameters = { new SqlParameter("@PaimaiInfoID", SqlDbType.Int, 4), new SqlParameter("@Deposit", SqlDbType.Int, 4), new SqlParameter("@Interval", SqlDbType.Int, 4), new SqlParameter("@Mode", SqlDbType.Int, 4), new SqlParameter("@Reserve", SqlDbType.VarChar, 100), new SqlParameter("@ValidHour", SqlDbType.Int, 4), new SqlParameter("@ValidMinute", SqlDbType.Int, 4) }; parameters[7].Value = model.PaimaiInfoId; parameters[8].Value = model.Deposit; parameters[9].Value = model.Interval; parameters[10].Value = model.Mode; parameters[11].Value = model.Reserve; parameters[12].Value = model.ValidHour; parameters[13].Value = model.ValidMinute; int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (Ares > 0) { return(true); } else { return(false); } }
public bool AddPaimaiInfo(Entity.Goods.PaimaiInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into PaimaiInfo("); strSql.Append("PaimaiInfoID,Deposit,Interval,Mode,Reserve,ValidHour,ValidMinute"); strSql.Append(") values ("); strSql.Append("@PaimaiInfoID,@Deposit,@Interval,@Mode,@Reserve,@ValidHour,@ValidMinute"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@PaimaiInfoID", SqlDbType.Int, 4), new SqlParameter("@Deposit", SqlDbType.Int, 4), new SqlParameter("@Interval", SqlDbType.Int, 4), new SqlParameter("@Mode", SqlDbType.Int, 4), new SqlParameter("@Reserve", SqlDbType.VarChar, 100), new SqlParameter("@ValidHour", SqlDbType.Int, 4), new SqlParameter("@ValidMinute", SqlDbType.Int, 4) }; parameters[0].Value = model.PaimaiInfoId; parameters[1].Value = model.Deposit; parameters[2].Value = model.Interval; parameters[3].Value = model.Mode; parameters[4].Value = model.Reserve; parameters[5].Value = model.ValidHour; parameters[6].Value = model.ValidMinute; int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters); if (Ares > 0) { return(true); } else { return(false); } }