/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MTWYear SetModel(DataRow dr)
{
Models.MTWYear mod = new Models.MTWYear();
mod.TWYear = int.Parse(dr["TWYear"].ToString());
mod.PeriodID = int.Parse(dr["PeriodID"].ToString());
mod.PaperDateBegin = SQLUtil.GetDateTime(dr["PaperDateBegin"]);
mod.PaperDateEnd = SQLUtil.GetDateTime(dr["PaperDateEnd"]);
mod.RegisterDateBegin = SQLUtil.GetDateTime(dr["RegisterDateBegin"]);
mod.RegisterDateEnd = SQLUtil.GetDateTime(dr["RegisterDateEnd"]);
mod.PayDateBegin = SQLUtil.GetDateTime(dr["PayDateBegin"]);
mod.PayDateEnd = SQLUtil.GetDateTime(dr["PayDateEnd"]);
return(mod);
}
/// <summary>
/// 修改資料
/// <summary>
public bool Edit(Models.MTWYear mod)
{
SqlCommand cmd = new SqlCommand("STP_TWYearEdit");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear;
cmd.Parameters.Add("@PeriodID", SqlDbType.Int).Value = mod.PeriodID;
cmd.Parameters.Add("@PaperDateBegin", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PaperDateBegin);
cmd.Parameters.Add("@PaperDateEnd", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PaperDateEnd);
cmd.Parameters.Add("@RegisterDateBegin", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.RegisterDateBegin);
cmd.Parameters.Add("@RegisterDateEnd", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.RegisterDateEnd);
cmd.Parameters.Add("@PayDateBegin", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PayDateBegin);
cmd.Parameters.Add("@PayDateEnd", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.PayDateEnd);
return(SQLUtil.ExecuteSql(cmd) > 0);
}
/// <summary>
/// 取得最新一筆Time資料
/// <summary>
public Models.MTWYear GetTop1()
{
SqlCommand cmd = new SqlCommand("STP_TWYearGetTop1");
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = SQLUtil.QueryDR(cmd);
bool isHasRows = dr.HasRows;
Models.MTWYear mod = SetModel(dr);
dr.Close();
if (isHasRows)
{
return(mod);
}
else
{
return(null);
}
}
/// <summary>
/// 取得單筆資料
/// <summary>
public Models.MTWYear GetModel(int intTWYear)
{
SqlCommand cmd = new SqlCommand("STP_TWYearGetByPK");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = intTWYear;
SqlDataReader dr = SQLUtil.QueryDR(cmd);
bool isHasRows = dr.HasRows;
Models.MTWYear mod = SetModel(dr);
dr.Close();
if (isHasRows)
{
return(mod);
}
else
{
return(null);
}
}
/// <summary>
/// 修改資料
/// </summary>
public bool Edit(Models.MTWYear mod)
{
return(new DAL.DTWYear().Edit(mod));
}
/// <summary>
/// 新增資料
/// </summary>
public int Add(Models.MTWYear mod)
{
return(new DAL.DTWYear().Add(mod));
}
