public bool DeleteHolidayDtl(HolidayDtlModel HolidayDtl) { DbTransaction objTrans = DbAccess.CreateDbTransaction(); try { string sql = "DELETE FROM tbHolidayDtl WHERE YearId=@YearId AND Company=@Company AND Holiday=@Holiday "; DbAccess.ExecuteNonQuery(sql, objTrans, new DbParameter[] { DataAccess.CreateParameter("YearId", DbType.String, HolidayDtl.YearId.ToString()), DataAccess.CreateParameter("Company", DbType.String, HolidayDtl.Company.ToString()), DataAccess.CreateParameter("Holiday", DbType.String, HolidayDtl.id.ToString()), //使用ID 來取代 }); objTrans.Commit(); return(true); } catch { objTrans.Rollback(); return(false); } finally { if (objTrans != null) { objTrans.Dispose(); } } }
public bool EditHolidayDtl(HolidayDtlModel HolidayDtl) { DbTransaction objTrans = DbAccess.CreateDbTransaction(); try { DbAccess.ExecuteNonQuery("UPDATE tbHolidayDtl SET Ctype=@Ctype,Display=@Display,Memo=@Memo WHERE YearId=@YearId AND Company=@Company AND Holiday=@Holiday ", objTrans, new DbParameter[] { DataAccess.CreateParameter("Ctype", DbType.String, HolidayDtl.Ctype.ToString()), DataAccess.CreateParameter("Display", DbType.String, HolidayDtl.Display.ToString()), DataAccess.CreateParameter("Memo", DbType.String, HolidayDtl.Memo.ToString()), DataAccess.CreateParameter("YearId", DbType.String, HolidayDtl.YearId.ToString()), DataAccess.CreateParameter("Company", DbType.String, HolidayDtl.Company.ToString()), DataAccess.CreateParameter("Holiday", DbType.String, HolidayDtl.id.ToString()), //使用ID 來取代 }); objTrans.Commit(); return(true); } catch { objTrans.Rollback(); return(false); } finally { if (objTrans != null) { objTrans.Dispose(); } } }
public HolidayDtlModel GetThisDate(string Company, string SDATE) { HolidayDtlModel Holiday = new HolidayDtlModel(); DataTable dt = DbAccess.ExecuteDataTable("SELECT * FROM gvHolidayDtl WHERE Company=@Company AND Holiday=@SDATE", new DbParameter[] { DataAccess.CreateParameter("Company", DbType.String, Company.ToString().Trim()), DataAccess.CreateParameter("SDATE", DbType.String, SDATE.ToString().Trim()) } ); if (dt.Rows.Count != 0) { Holiday.title = dt.Rows[0]["CtypeName"].ToString(); if (dt.Rows[0]["Memo"].ToString().Trim() != "") { Holiday.title += " (" + dt.Rows[0]["Memo"].ToString() + ")"; } } else { Holiday.title = "上班日"; } return(Holiday); }
public JsonResult InsertHolidayDtl(string HolidayJson) { HolidayDtlModel HolidayDtl = null; try { HolidayDtl = JsonConvert.DeserializeObject <HolidayDtlModel>(HolidayJson); HolidayDtl.Holiday = HolidayDtl.Holiday.Replace("-", ""); if (ModelFactory.InsertHolidayDtl(HolidayDtl)) { return(Json("1"));//代表已經處裡完 } else { return(Json("失敗!"));//失敗 } } catch (Exception ex) { return(Json(ex.Message)); } catch { return(Json("系統發生錯誤")); } }
public bool InsertHolidayDtl(HolidayDtlModel HolidayDtl) { DbTransaction objTrans = DbAccess.CreateDbTransaction(); try { DbAccess.ExecuteNonQuery("INSERT INTO tbHolidayDtl (YearId,Company,Ctype,Holiday,Display,Memo) VALUES (@YearId,@Company,@Ctype,@Holiday,@Display,@Memo) ", objTrans, new DbParameter[] { DataAccess.CreateParameter("YearId", DbType.String, HolidayDtl.YearId.ToString()), DataAccess.CreateParameter("Company", DbType.String, HolidayDtl.Company.ToString()), DataAccess.CreateParameter("Ctype", DbType.String, HolidayDtl.Ctype.ToString()), DataAccess.CreateParameter("Holiday", DbType.String, HolidayDtl.Holiday.ToString()), DataAccess.CreateParameter("Display", DbType.String, HolidayDtl.Display.ToString()), DataAccess.CreateParameter("Memo", DbType.String, HolidayDtl.Memo.ToString()), }); objTrans.Commit(); return(true); } catch { objTrans.Rollback(); return(false); } finally { if (objTrans != null) { objTrans.Dispose(); } } }