public override SqlParameter[] GetParameters() { M_UserRecei model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.ID; sp[1].Value = model.ReceivName; sp[2].Value = model.Street; sp[3].Value = model.Zipcode; sp[4].Value = model.phone; sp[5].Value = model.MobileNum; sp[6].Value = model.isDefault; sp[7].Value = model.UserID; sp[8].Value = model.Provinces; sp[9].Value = model.Email; //sp[10].Value = model.CityCode; return(sp); }
public M_UserRecei GetModelFromReader(DbDataReader rdr) { M_UserRecei model = new M_UserRecei(); model.ID = Convert.ToInt32(rdr["ID"].ToString()); model.ReceivName = ConverToStr(rdr["ReceivName"]); model.Street = ConverToStr(rdr["Street"]); model.Zipcode = ConverToStr(rdr["Zipcode"]); model.phone = ConverToStr(rdr["phone"]); model.MobileNum = ConverToStr(rdr["MobileNum"]); model.isDefault = ConvertToInt(rdr["isDefault"]); model.UserID = Convert.ToInt32(rdr["UserID"]); model.Provinces = ConverToStr(rdr["Provinces"]); model.Email = ConverToStr(rdr["Email"]); //model.CityCode = rdr["CityCode"] == DBNull.Value ? "" : rdr["CityCode"].ToString(); rdr.Close(); return(model); }