public M_Order_Invoice GetModelFromReader(DbDataReader rdr) { M_Order_Invoice model = new M_Order_Invoice(); model.ID = ConvertToInt(rdr["ID"]); model.OrderID = ConvertToInt(rdr["OrderID"]); model.InvType = ConvertToInt(rdr["InvType"]); model.InvHead = ConverToStr(rdr["InvHead"]); model.InvContent = ConverToStr(rdr["InvContent"]); model.UserCode = ConverToStr(rdr["UserCode"]); model.UserMobile = ConverToStr(rdr["UserMobile"]); model.UserEmail = ConverToStr(rdr["UserEmail"]); model.CDate = ConvertToDate(rdr["CDate"]); model.UserID = ConvertToInt(rdr["UserID"]); model.InvClass = ConverToStr(model.InvClass); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_Order_Invoice model = this; SqlParameter[] sp = GetSP(); if (model.CDate <= DateTime.MinValue) { model.CDate = DateTime.Now; } sp[0].Value = model.ID; sp[1].Value = model.OrderID; sp[2].Value = model.InvType; sp[3].Value = model.InvHead; sp[4].Value = model.InvContent; sp[5].Value = model.UserCode; sp[6].Value = model.UserMobile; sp[7].Value = model.UserEmail; sp[8].Value = model.CDate; sp[9].Value = model.UserID; sp[10].Value = model.InvClass; return(sp); }