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());
}
