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