public static bool UpdateVehicleMountedCouponConfig(VehicleMountedCouponConfig model) { const string sql = @"UPDATE Configuration.dbo.SE_VehicleMountedCouponConfig SET Channel=@Channel ,Versions=@Versions ,Region=@Region ,Status=@Status ,Images=@Images ,Coupons=@Coupons ,UpdateTime=GETDATE() ,UpdateName=@UpdateName ,Location=@Location ,Name=@Name ,CouponQuantity=@CouponQuantity ,Type=@Type WHERE Id=@Id"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Channel", model.Channel ?? string.Empty), new SqlParameter("@Coupons", model.Coupons ?? string.Empty), new SqlParameter("@Images", model.Images ?? string.Empty), new SqlParameter("@Region", model.Region ?? string.Empty), new SqlParameter("@Versions", model.Versions ?? string.Empty), new SqlParameter("@Status", model.Status), new SqlParameter("@Id", model.Id), new SqlParameter("@UpdateName", model.UpdateName ?? string.Empty), new SqlParameter("@Location", model.Location), new SqlParameter("@Name", model.Name), new SqlParameter("@CouponQuantity", model.CouponQuantity), new SqlParameter("@Type", model.Type) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public static bool InsertVehicleMountedCouponConfig(VehicleMountedCouponConfig model, ref int id) { const string sql = @" INSERT INTO Configuration.dbo.[SE_VehicleMountedCouponConfig] ( [Channel] ,[Versions] ,[Region] ,[Status] ,[Images] ,[Coupons] ,[CreateTime] ,[UpdateTime] ,[CreateName] ,[UpdateName] ,[ActivityId] ,[Location] ,[Name] ,[CouponQuantity] ,[Type] ) VALUES ( @Channel ,@Versions ,@Region ,@Status ,@Images ,@Coupons ,GETDATE() ,GETDATE() ,@CreateName ,@UpdateName ,NEWID() ,@Location ,@Name ,@CouponQuantity ,@Type )SELECT @@IDENTITY"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Channel", model.Channel ?? string.Empty), new SqlParameter("@Coupons", model.Coupons ?? string.Empty), new SqlParameter("@Images", model.Images ?? string.Empty), new SqlParameter("@Region", model.Region ?? string.Empty), new SqlParameter("@Versions", model.Versions ?? string.Empty), new SqlParameter("@Status", model.Status), new SqlParameter("@CreateName", model.CreateName ?? string.Empty), new SqlParameter("@UpdateName", model.UpdateName ?? string.Empty), new SqlParameter("@Location", model.Location), new SqlParameter("@Name", model.Name), new SqlParameter("@CouponQuantity", model.CouponQuantity), new SqlParameter("@Type", model.Type) }; id = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlParameter)); return(id > 0); }
public bool InsertVehicleMountedCouponConfig(VehicleMountedCouponConfig model, ref int id) { try { return(DALVehicleMountedCouponConfig.InsertVehicleMountedCouponConfig(model, ref id)); } catch (Exception ex) { Logger.Log(Level.Error, ex, "InsertVehicleMountedCouponConfig"); throw ex; } }
public bool UpdateVehicleMountedCouponConfig(VehicleMountedCouponConfig model) { try { return(DALVehicleMountedCouponConfig.UpdateVehicleMountedCouponConfig(model)); } catch (Exception ex) { Logger.Log(Level.Error, ex, "UpdateVehicleMountedCouponConfig"); throw ex; } }
public List <VehicleMountedCouponConfig> GetVehicleMountedCouponConfigList(VehicleMountedCouponConfig model, int pageSize, int pageIndex, out int recordCount) { try { return(DALVehicleMountedCouponConfig.GetVehicleMountedCouponConfig(model, pageSize, pageIndex, out recordCount)); } catch (Exception ex) { Logger.Log(Level.Error, ex, "GetVehicleMountedCouponConfigList"); throw ex; } }
public ActionResult Edit(VehicleMountedCouponConfig model) { if (model.Id != 0) { model.UpdateName = User.Identity.Name; return(Json(VehicleMountedCouponConfigManager.UpdateVehicleMountedCouponConfig(model))); } else { model.CreateName = User.Identity.Name; model.UpdateName = User.Identity.Name; int outId = 0; return(Json(VehicleMountedCouponConfigManager.InsertVehicleMountedCouponConfig(model, ref outId))); } }
public ActionResult List(VehicleMountedCouponConfig model, int pageIndex = 1, int pageSize = 15) { int count = 0; string strSql = string.Empty; var lists = VehicleMountedCouponConfigManager.GetVehicleMountedCouponConfigList(model, pageSize, pageIndex, out count); var list = new OutData <List <VehicleMountedCouponConfig>, int>(lists, count); var pager = new PagerModel(pageIndex, pageSize) { TotalItem = count }; return(View(new ListModel <VehicleMountedCouponConfig>(list.ReturnValue, pager))); }
public ActionResult Edit(int id = 0) { ViewBag.ProvinceList = MeiRongAcitivityConfigManager.GetRegion(0); if (id == 0) { VehicleMountedCouponConfig model = new VehicleMountedCouponConfig(); model.CreateTime = DateTime.Now; model.UpdateTime = DateTime.Now; model.Region = "[{'ProvinceName':'','CityName':''}]"; model.Status = true; return(View(model)); } else { VehicleMountedCouponConfig model = VehicleMountedCouponConfigManager.GetVehicleMountedCouponConfigById(id); model.RegionList = JsonConvert.DeserializeObject <List <RegionModel> >(model.Region); return(View(model)); } }
public static List <VehicleMountedCouponConfig> GetVehicleMountedCouponConfig(VehicleMountedCouponConfig model, int pageSize, int pageIndex, out int recordCount) { string sql = @"SELECT * FROM ( SELECT [Id] ,[Channel] ,[Versions] ,[Region] ,[Status] ,[Images] ,[Coupons] ,[CreateTime] ,[UpdateTime] ,[ActivityId] ,[Location] ,[Name] ,[CouponQuantity] ,[Type] FROM [Configuration].[dbo].[SE_VehicleMountedCouponConfig] WHERE 1=1 ) AS PG ORDER BY PG.[UpdateTime] DESC OFFSET ( @PageIndex - 1 ) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY "; string sqlCount = @"SELECT Count(0) FROM [Configuration].[dbo].[SE_VehicleMountedCouponConfig] AS A WITH (NOLOCK) "; var sqlParameters = new SqlParameter[] { new SqlParameter("@PageSize", pageSize), new SqlParameter("@PageIndex", pageIndex), }; recordCount = (int)SqlHelper.ExecuteScalar(connOnRead, CommandType.Text, sqlCount, sqlParameters); return(SqlHelper.ExecuteDataTable(connOnRead, CommandType.Text, sql, sqlParameters).ConvertTo <VehicleMountedCouponConfig>().ToList()); }