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