public M_Shop_ProOrderList GetModelFromReader(DbDataReader rdr) { M_Shop_ProOrderList model = new M_Shop_ProOrderList(); model.ID = Convert.ToInt32(rdr["ID"]); model.OrderListID = ConvertToInt(rdr["OrderListID"]); model.ProID = ConvertToInt(rdr["ProID"]); model.ProName = ConverToStr(rdr["ProName"]); model.ProPrice = ConverToDouble(rdr["ProPrice"]); model.Pronum = ConvertToInt(rdr["Pronum"]); model.Pronum_Rece = ConvertToInt(rdr["Pronum_Rece"]); model.ProArrive = ConverToDouble(rdr["ProArrive"]); model.Remind = ConverToStr(rdr["Remind"]); model.ZStatus = ConverToStr(rdr["ZStatus"]); model.CDate = ConvertToDate(rdr["CDate"]); model.UserID = ConvertToInt(rdr["UserID"]); model.AllMoney = ConverToDouble(rdr["AllMoney"]); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_Shop_ProOrderList model = this; if (model.CDate <= DateTime.MinValue) { model.CDate = DateTime.Now; } SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.OrderListID; sp[2].Value = model.ProID; sp[3].Value = model.ProName; sp[4].Value = model.ProPrice; sp[5].Value = model.Pronum; sp[6].Value = model.Pronum_Rece; sp[7].Value = model.ProArrive; sp[8].Value = model.Remind; sp[9].Value = model.ZStatus; sp[10].Value = model.CDate; sp[11].Value = model.UserID; sp[12].Value = model.AllMoney; return(sp); }