public static bool InsertBaoYangPackageBrandPriorityConfig(BaoYangPackageBrandPriorityConfig model) { const string sql = @"INSERT INTO Configuration..SE_BaoYangPackageBrandPriorityConfig ( [VehicleID] ,[PackageBrands] ,[JiYouGrade] ,[CreateTime] ,[UpdateTime] ) VALUES( @VehicleID ,@PackageBrands ,@JiYouGrade ,GETDATE() ,GETDATE() )"; var sqlParameter = new SqlParameter[] { new SqlParameter("@VehicleID", model.VehicleID ?? string.Empty), new SqlParameter("@PackageBrands", model.PackageBrands ?? string.Empty), new SqlParameter("@JiYouGrade", model.JiYouGrade ?? string.Empty) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public ActionResult Edit(int id = 0, string edit = "", string VehicleID = "") { ViewBag.Edit = edit; ViewBag.VehicleID = VehicleID; if (id == 0) { BaoYangPackageBrandPriorityConfig model = new BaoYangPackageBrandPriorityConfig(); return(View(model)); } else { return(View(BaoYangPackageBrandPriorityConfigManager.GetBaoYangPackageBrandPriorityConfig(id))); } }
public bool InsertBaoYangPackageBrandPriorityConfig(BaoYangPackageBrandPriorityConfig model) { try { return(DALBaoYangPackageBrandPriorityConfig.InsertBaoYangPackageBrandPriorityConfig(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new BaoYangPackageBrandPriorityConfigException(1, "InsertBaoYangPackageBrandPriorityConfig", ex); Logger.Log(Level.Error, exception, "InsertBaoYangPackageBrandPriorityConfig"); throw ex; } }
public static bool UpdateBaoYangPackageBrandPriorityConfig(BaoYangPackageBrandPriorityConfig model) { const string sql = @"UPDATE Configuration..SE_BaoYangPackageBrandPriorityConfig SET VehicleID=@VehicleID ,PackageBrands=@PackageBrands ,JiYouGrade=@JiYouGrade ,[UpdateTime]=GETDATE() WHERE Id=@Id"; var sqlParameter = new SqlParameter[] { new SqlParameter("@VehicleID", model.VehicleID ?? string.Empty), new SqlParameter("@Brand", model.Brand ?? string.Empty), new SqlParameter("@Vehicle", model.Vehicle ?? string.Empty), new SqlParameter("@PackageBrands", model.PackageBrands ?? string.Empty), new SqlParameter("@JiYouGrade", model.JiYouGrade ?? string.Empty), new SqlParameter("@Id", model.Id) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }