public ActionResult Edit(ShareActivityProductConfig model) { string js = "<script>alert(\"保存失败 \");location='/ShareActivityProductConfig/Index';</script>"; if (model.Id != 0) { if (ShareActivityProductConfigManager.UpdateShareActivityProductConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } else { if (ShareActivityProductConfigManager.InsertShareActivityProductConfig(model)) { return(RedirectToAction("Index")); } else { return(Content(js)); } } }
public ActionResult List(ShareActivityProductConfig model, int pageIndex = 1, int pageSize = 30) { int count = 0; var lists = ShareActivityProductConfigManager.GetShareActivityProductConfigList(model, pageSize, pageIndex, out count); var list = new OutData <List <ShareActivityProductConfig>, int>(lists, count); var pager = new PagerModel(pageIndex, pageSize) { TotalItem = count }; return(View(new ListModel <ShareActivityProductConfig>(list.ReturnValue, pager))); }
public bool InsertShareActivityProductConfig(ShareActivityProductConfig model) { try { return(DALShareActivityProductConfig.InsertShareActivityProductConfig(model)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new ShareActivityProductConfigException(1, "InsertShareActivityProductConfig", ex); Logger.Log(Level.Error, exception, "InsertShareActivityProductConfig"); throw ex; } }
public List <ShareActivityProductConfig> GetShareActivityProductConfigList(ShareActivityProductConfig model, int pageSize, int pageIndex, out int recordCount) { try { return(DALShareActivityProductConfig.GetShareActivityProductConfigList(model, pageSize, pageIndex, out recordCount)); } catch (TuhuBizException) { throw; } catch (Exception ex) { var exception = new ShareActivityProductConfigException(1, "GetShareActivityProductConfigList", ex); Logger.Log(Level.Error, exception, "GetShareActivityProductConfigList"); throw ex; } }
public static bool UpdateShareActivityProductConfig(ShareActivityProductConfig model) { const string sql = @"UPDATE Configuration..ShareActivityProductConfig SET Status=@Status ,ProductId=@ProductId ,ProductName=@ProductName ,CreateTime=GETDATE() WHERE Id=@Id"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Status", model.Status), new SqlParameter("@ProductId", model.ProductId), new SqlParameter("@ProductName", model.ProductName ?? string.Empty), new SqlParameter("@Id", model.Id) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public static bool InsertShareActivityProductConfig(ShareActivityProductConfig model) { const string sql = @" INSERT INTO Configuration..ShareActivityProductConfig ( [Status] ,[ProductId] ,[ProductName] ,[CreateTime] ) VALUES( @Status ,@ProductId ,@ProductName ,GETDATE() )"; var sqlParameter = new SqlParameter[] { new SqlParameter("@Status", model.Status), new SqlParameter("@ProductId", model.ProductId), new SqlParameter("@ProductName", model.ProductName ?? string.Empty) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlParameter) > 0); }
public static List <ShareActivityProductConfig> GetShareActivityProductConfigList(ShareActivityProductConfig model, int pageSize, int pageIndex, out int recordCount) { string sql = @"SELECT * FROM ( SELECT [Id] , [Status] , [ProductId] , [ProductName] , [CreateTime] FROM [Configuration].[dbo].[ShareActivityProductConfig] WITH ( NOLOCK ) WHERE ( @ProductId = '' OR ( @ProductId <> '' AND ProductId = @ProductId ) ) ) AS PG ORDER BY PG.CreateTime DESC OFFSET ( @PageIndex - 1 ) * @PageSize ROWS FETCH NEXT @PageSize ROWS ONLY "; string sqlCount = @"SELECT COUNT(1) FROM [Configuration].[dbo].[ShareActivityProductConfig] WITH (NOLOCK) WHERE ( @ProductId = '' OR ( @ProductId <> '' AND ProductId = @ProductId ) )"; var sqlParameters = new SqlParameter[] { new SqlParameter("@PageSize", pageSize), new SqlParameter("@PageIndex", pageIndex), new SqlParameter("@ProductId", model.ProductId ?? "") }; recordCount = (int)SqlHelper.ExecuteScalar(connOnRead, CommandType.Text, sqlCount, sqlParameters); return(SqlHelper.ExecuteDataTable(connOnRead, CommandType.Text, sql, sqlParameters).ConvertTo <ShareActivityProductConfig>().ToList()); }