public M_Order_Settle GetModelFromReader(DbDataReader rdr) { M_Order_Settle model = new M_Order_Settle(); model.ID = ConvertToInt(rdr["ID"]); model.OrderID = ConvertToInt(rdr["OrderID"]); model.PaymentNo = ConverToStr(rdr["PaymentNo"]); model.Old = ConverToStr(rdr["Old"]); model.After = ConverToStr(rdr["After"]); model.AmountPre = ConverToDouble(rdr["AmountPre"]); model.AmountSettle = ConverToDouble(rdr["AmountSettle"]); model.UserID = ConvertToInt(rdr["UserID"]); model.AdminID = ConvertToInt(rdr["AdminID"]); model.Remind = ConverToStr(rdr["Remind"]); model.ZStatus = ConvertToInt(rdr["ZStatus"]); model.CDate = ConvertToDate(rdr["CDate"]); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_Order_Settle model = this; if (model.CDate <= DateTime.MinValue) { model.CDate = DateTime.Now; } SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.OrderID; sp[2].Value = model.PaymentNo; sp[3].Value = model.Old; sp[4].Value = model.After; sp[5].Value = model.AmountPre; sp[6].Value = model.AmountSettle; sp[7].Value = model.UserID; sp[8].Value = model.AdminID; sp[9].Value = model.Remind; sp[10].Value = model.ZStatus; sp[11].Value = model.CDate; return(sp); }