public static bool UpdateReleaseItemModel(ReleaseItemModel model)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Tuhu_log")))
{
return(dbHelper.ExecuteNonQuery(@"UPDATE dbo.tbl_ReleaseItem
SET [Name]=@Name
,[Content]=@Content
,[Developer]=@Developer
,[Tester]=@Tester
,[Checker]=@Checker
,[ReleaseTime]=@ReleaseTime
,[Status]=@Status
,[Reason]=@Reason
,[LastUpdatedDateTime]=@LastUpdatedDateTime
WHERE PKID = @PKID;
", CommandType.Text, new SqlParameter[] {
new SqlParameter("@PKID", model.PKID),
new SqlParameter("@Name", model.Name),
new SqlParameter("@Content", model.Content),
new SqlParameter("@Developer", model.Developer),
new SqlParameter("@Tester", model.Tester),
new SqlParameter("@Checker", model.Checker),
new SqlParameter("@ReleaseTime", model.ReleaseTime),
new SqlParameter("@Status", model.Status),
new SqlParameter("@Reason", model.Reason),
new SqlParameter("@LastUpdatedDateTime", DateTime.Now.ToString("yyyy-MM-dd"))
}) > 0 ? true : false);
}
}
public async Task Post(ReleaseItemModel model)
{
var game = new Game
{
Name = model.Name,
ReleaseDate = model.ReleaseDate
};
await _games.InsertOneAsync(game).ConfigureAwait(false);
}
public PartialViewResult ReleaseItemList(ReleaseItemModel model, int pageIndex = 1, int pageSize = 10)
{
var pager = new PagerModel(pageIndex, pageSize);
var data = ItemReleaseManager.SelectList(model, pager);
ViewBag.Select = model;
return(PartialView("ItemReleaseList", new ListModel <ReleaseItemModel>()
{
Pager = pager, Source = data
}));
}
public async Task <ActionResult <ReleaseItemModel> > Post(ReleaseItemModel model)
{
try
{
await _service.Post(model).ConfigureAwait(false);
return(Ok());
}
catch (Exception)
{
return(StatusCode(500));
}
}
public static bool AddReleaseItem(ReleaseItemModel model)
{
using (var sqlHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Tuhu_log")))
{
string sql = @"INSERT INTO [dbo].[tbl_ReleaseItem]
( [Name]
,[Content]
,[Developer]
,[Tester]
,[Checker]
,[ReleaseTime]
,[IsValid]
,[CreateDateTime]
,[Status]
,[Reason]
)
VALUES ( @Name ,
@Content ,
@Developer ,
@Tester ,
@Checker ,
@ReleaseTime ,
@IsValid,
GETDATE(),
@Status,
@Reason
)" ;
var sqlParam = new[]
{
new SqlParameter("@Name", model.Name.Trim(new char[] { '|' })),
new SqlParameter("@Content", model.Content),
new SqlParameter("@Developer", model.Developer),
new SqlParameter("@Tester", model.Tester),
new SqlParameter("@Checker", model.Checker),
new SqlParameter("@ReleaseTime", model.ReleaseTime),
new SqlParameter("@IsValid", 1),
new SqlParameter("@Status", model.Status),
new SqlParameter("@Reason", model.Reason)
};
return(sqlHelper.ExecuteNonQuery(sql, CommandType.Text, sqlParam) > 0 ? true : false);
}
}
public static int GetListCount(SqlDbHelper dbHelper, ReleaseItemModel model, PagerModel pager)
{
var OBJ = dbHelper.ExecuteScalar(@"select count(1) from [dbo].[tbl_ReleaseItem](nolock) where (Name like @Name or @Name is null)
and (Developer like @Developer or @Developer is null)
and (Tester like @Tester or @Tester is null)
and (Checker like @Checker or @Checker is null)
and (datediff(dd,ReleaseTime,@ReleaseTime)=0 or @ReleaseTime is null)
and (Status=@Status or @Status=-1)", CommandType.Text,
new SqlParameter[] {
new SqlParameter("@Name", String.IsNullOrWhiteSpace(model.Name)?null:"%" + model.Name.Replace("|", "%") + "%"),
new SqlParameter("@Developer", String.IsNullOrWhiteSpace(model.Developer)?null:"%" + model.Developer + "%"),
new SqlParameter("@Tester", String.IsNullOrWhiteSpace(model.Tester)?null:"%" + model.Tester + "%"),
new SqlParameter("@Checker", String.IsNullOrWhiteSpace(model.Checker)?null:"%" + model.Checker + "%"),
new SqlParameter("@ReleaseTime", model.ReleaseTime == null?null:model.ReleaseTime),
new SqlParameter("@Status", model.Status)
});
return(Convert.ToInt32(OBJ));
}
public static IEnumerable <ReleaseItemModel> SelectList(ReleaseItemModel model, PagerModel pager)
{
using (var dbHelper = new SqlDbHelper(ConnectionHelper.GetDecryptConn("Tuhu_log")))
{
pager.TotalItem = GetListCount(dbHelper, model, pager);
var list = dbHelper.ExecuteDataTable(@"SELECT [PKID]
,[Name]
,[Content]
,[Developer]
,[Tester]
,[Checker]
,[ReleaseTime]
,[IsValid]
,[Status]
,[Reason]
FROM [dbo].[tbl_ReleaseItem](nolock)
where (Name like @Name or @Name is null)
and (Developer like @Developer or @Developer is null)
and (Tester like @Tester or @Tester is null)
and (Checker like @Checker or @Checker is null)
and (datediff(dd,ReleaseTime,@ReleaseTime)=0 or @ReleaseTime is null)
and (Status=@Status or @Status=-1)
order by PKID desc
OFFSET ( @PageIndex - 1 ) * @PageSize ROWS
FETCH NEXT @PageSize ROWS ONLY;", CommandType.Text,
new SqlParameter[] {
new SqlParameter("@Name", String.IsNullOrWhiteSpace(model.Name)?null:"%" + model.Name.Replace("|", "%") + "%"),
new SqlParameter("@Developer", String.IsNullOrWhiteSpace(model.Developer)?null:"%" + model.Developer + "%"),
new SqlParameter("@Tester", String.IsNullOrWhiteSpace(model.Tester)?null:"%" + model.Tester + "%"),
new SqlParameter("@Checker", String.IsNullOrWhiteSpace(model.Checker)?null:"%" + model.Checker + "%"),
new SqlParameter("@ReleaseTime", model.ReleaseTime == null?null:model.ReleaseTime),
new SqlParameter("@Status", model.Status),
new SqlParameter("@PageIndex", pager.CurrentPage),
new SqlParameter("@PageSize", pager.PageSize),
}).ConvertTo <ReleaseItemModel>();
return(list);
}
}
public static bool UpdateReleaseItem(ReleaseItemModel model) => DalItemRelease.UpdateReleaseItemModel(model);
public static bool AddReleaseItem(ReleaseItemModel model)
{
return(DalItemRelease.AddReleaseItem(model));
}
public static IEnumerable <ReleaseItemModel> SelectList(ReleaseItemModel model, PagerModel pager) => DalItemRelease.SelectList(model, pager);
public ActionResult UpdateReleaseItemModel(ReleaseItemModel model)
{
var result = ItemReleaseManager.UpdateReleaseItem(model);
return(Json(result, JsonRequestBehavior.AllowGet));
}
