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