/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MPaper SetModel(DataRow dr)
{
Models.MPaper mod = new Models.MPaper();
mod.PaperID = int.Parse(dr["PaperID"].ToString());
mod.TWYear = int.Parse(dr["TWYear"].ToString());
mod.PaperTitle = dr["PaperTitle"].ToString();
mod.PaperAuthor = dr["PaperAuthor"].ToString();
mod.Company = dr["Company"].ToString();
mod.SummaryC = dr["SummaryC"].ToString();
mod.SummaryE = dr["SummaryE"].ToString();
mod.MemberType = dr["MemberType"].ToString();
mod.MemberID = dr["MemberID"].ToString();
mod.Tel1 = dr["Tel1"].ToString();
mod.Tel2 = dr["Tel2"].ToString();
mod.Ext = dr["Ext"].ToString();
mod.Fax1 = dr["Fax1"].ToString();
mod.Fax2 = dr["Fax2"].ToString();
mod.Email = dr["Email"].ToString();
mod.UploadDate = SQLUtil.GetDateTime(dr["UploadDate"]);
mod.PublishType = dr["PublishType"].ToString();
mod.PaperDomainID = dr["PaperDomainID"].ToString();
mod.Publish = bool.Parse(dr["Publish"].ToString());
mod.FileExtension = dr["FileExtension"].ToString();
mod.Examine = dr["Examine"].ToString();
mod.ExamineDate = SQLUtil.GetDateTime(dr["ExamineDate"]);
mod.PaperNo = dr["PaperNo"].ToString();
return(mod);
}
/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MOrder SetModel(DataRow dr)
{
Models.MOrder mod = new Models.MOrder();
mod.OrderID = int.Parse(dr["OrderID"].ToString());
mod.TWYear = int.Parse(dr["TWYear"].ToString());
mod.MemberGID = dr["MemberGID"].ToString();
mod.MemberPID = dr["MemberPID"].ToString();
mod.MerchantTradeNo = dr["MerchantTradeNo"].ToString();
mod.TradeNo = dr["TradeNo"].ToString();
mod.TradeAmount = int.Parse(dr["TradeAmount"].ToString());
mod.PaymentType = dr["PaymentType"].ToString();
mod.Payment1 = dr["Payment1"].ToString();
mod.Payment2 = dr["Payment2"].ToString();
mod.Payment3 = dr["Payment3"].ToString();
mod.PaymentNo = dr["PaymentNo"].ToString();
mod.WebATMAccBank = dr["WebATMAccBank"].ToString();
mod.TradeDate = DateTime.Parse(dr["TradeDate"].ToString());
mod.DeadlineDate = DateTime.Parse(dr["DeadlineDate"].ToString());
mod.PayDate = SQLUtil.GetDateTime(dr["PayDate"]);
mod.RecDate = SQLUtil.GetDateTime(dr["RecDate"]);
mod.PayFrom = dr["PayFrom"].ToString();
mod.FeeStatus = dr["FeeStatus"].ToString();
mod.Remark = dr["Remark"].ToString();
return(mod);
}
/// <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 List<Models.MMemberP> GetList()
//{
// SqlCommand cmd = new SqlCommand("STP_MemberPGet");
// cmd.CommandType = CommandType.StoredProcedure;
// DataSet ds = SQLUtil.QueryDS(cmd);
// return GetList(ds);
//}
/// <summary>
/// 實體物件取得DataReader資料
/// </summary>
private Models.MMemberP SetModel(SqlDataReader dr)
{
Models.MMemberP mod = new Models.MMemberP();
while (dr.Read())
{
mod.MemberPID = dr["MemberPID"].ToString();
mod.MemberPassword = dr["MemberPassword"].ToString();
mod.NameC = dr["NameC"].ToString();
mod.NameE = dr["NameE"].ToString();
mod.Email = dr["Email"].ToString();
mod.PID = dr["PID"].ToString();
mod.Birthday = SQLUtil.GetDateTime(dr["Birthday"]);
mod.RegisterDate = DateTime.Parse(dr["RegisterDate"].ToString());
mod.Sex = dr["Sex"].ToString();
mod.Native = dr["Native"].ToString();
mod.MemberClass = dr["MemberClass"].ToString();
mod.SchoolConsent = dr["SchoolConsent"].ToString();
mod.StudentIDCard = dr["StudentIDCard"].ToString();
mod.StudentIDCardFileType = dr["StudentIDCardFileType"].ToString();
mod.School = dr["School"].ToString();
mod.CollegeDepartment = dr["CollegeDepartment"].ToString();
mod.Education = dr["Education"].ToString();
mod.Job = dr["Job"].ToString();
mod.JobTitle = dr["JobTitle"].ToString();
mod.Student = bool.Parse(dr["Student"].ToString());
mod.Mobile = dr["Mobile"].ToString();
mod.TEL = dr["TEL"].ToString();
mod.FAX = dr["FAX"].ToString();
mod.ZipCodeH = dr["ZipCodeH"].ToString();
mod.CityH = dr["CityH"].ToString();
mod.AreaH = dr["AreaH"].ToString();
mod.AddressH = dr["AddressH"].ToString();
mod.ZipCode = dr["ZipCode"].ToString();
mod.City = dr["City"].ToString();
mod.Area = dr["Area"].ToString();
mod.Address = dr["Address"].ToString();
mod.Memo = dr["Memo"].ToString();
mod.Status = dr["Status"].ToString();
mod.EDM = bool.Parse(dr["EDM"].ToString());
mod.CreateUser = dr["CreateUser"].ToString();
mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString());
mod.UpdateUser = dr["UpdateUser"].ToString();
mod.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString());
}
return(mod);
}
/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MReceipt SetModel(DataRow dr)
{
Models.MReceipt mod = new Models.MReceipt();
mod.ReceiptID = int.Parse(dr["ReceiptID"].ToString());
mod.TWYear = int.Parse(dr["TWYear"].ToString());
mod.MemberID = dr["MemberID"].ToString();
mod.MemberType = dr["MemberType"].ToString();
mod.ReceiptType = dr["ReceiptType"].ToString();
mod.Fee = int.Parse(dr["Fee"].ToString());
mod.ReceivedFromAppend = dr["ReceivedFromAppend"].ToString();
mod.Remark = dr["Remark"].ToString();
mod.CreateUser = dr["CreateUser"].ToString();
mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString());
mod.CancelUser = SQLUtil.GetString(dr["CancelUser"]);
mod.CancelDate = SQLUtil.GetDateTime(dr["CancelDate"]);
mod.Enable = bool.Parse(dr["Enable"].ToString());
return(mod);
}
