public M_Uinfo GetModelFromReader(DbDataReader rdr) { M_Uinfo model = new M_Uinfo(); model.UserId = Convert.ToInt32(rdr["UserID"]); model.TrueName = ConverToStr(rdr["TrueName"]); model.BirthDay = ConverToStr(rdr["BirthDay"]); model.Address = ConverToStr(rdr["Address"]); model.HomePhone = ConverToStr(rdr["HomePhone"]); model.Fax = ConverToStr(rdr["Fax"]); model.ZipCode = ConverToStr(rdr["ZipCode"]); model.Mobile = rdr["Mobile"].ToString(); model.UserSex = ConverToBool(rdr["UserSex"]); model.QQ = ConverToStr(rdr["QQ"]); model.MSN = ConverToStr(rdr["MSN"]); model.ICQ = ConverToStr(rdr["ICQ"]); model.UC = ConverToStr(rdr["UC"]); model.Yahoo = ConverToStr(rdr["Yahoo"]); model.IDCard = ConverToStr(rdr["IDCard"]); model.HomePage = ConverToStr(rdr["HomePage"]); model.UserFace = ConverToStr(rdr["UserFace"]); model.FaceWidth = ConvertToInt(rdr["FaceWidth"]); model.FaceHeight = ConvertToInt(rdr["FaceHeight"]); model.Sign = ConverToStr(rdr["Sign"]); model.Country = ConverToStr(rdr["Country"]); model.Privating = ConvertToInt(rdr["Privacy"]); model.Province = ConverToStr(rdr["Province"]); model.City = ConverToStr(rdr["City"]); model.County = ConverToStr(rdr["County"]); model.CardType = ConverToStr(rdr["cardType"]); model.OfficePhone = ConverToStr(rdr["OfficePhone"]); model.PHS = ConverToStr(rdr["PHS"]); model.HoneyName = ConverToStr(rdr["honeyName"]); model.Shengxiao = ConverToStr(rdr["Shengxiao"]); model.Xingzuo = ConverToStr(rdr["Xingzuo"]); model.WorkProvince = rdr["WorkProvince"].ToString(); model.WorkCounty = rdr["workCity"].ToString(); model.SFStatus = ConvertToInt(rdr["SFStatus"]); model.VIPUser = ConvertToInt(rdr["VIPUser"]); model.Bugle = ConvertToInt(rdr["Bugle"]); model.Position = ConverToStr(rdr["Position"]); model.CompanyName = ConverToStr(rdr["Corp"]); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_Uinfo model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.UserId; sp[1].Value = model.TrueName; sp[2].Value = model.BirthDay; sp[3].Value = model.Address; sp[4].Value = model.HomePhone; sp[5].Value = model.Fax; sp[6].Value = model.ZipCode; sp[7].Value = model.Mobile; sp[8].Value = model.UserSex; sp[9].Value = model.QQ; sp[10].Value = model.MSN; sp[11].Value = model.ICQ; sp[12].Value = model.UC; sp[13].Value = model.Yahoo; sp[14].Value = model.IDCard; sp[15].Value = model.HomePage; sp[16].Value = model.userFace; sp[17].Value = model.FaceWidth; sp[18].Value = model.FaceHeight; sp[19].Value = model.Sign; sp[20].Value = model.Country; sp[21].Value = model.Province; sp[22].Value = model.City; sp[23].Value = model.County; sp[24].Value = model.Privating; sp[25].Value = model.OfficePhone; sp[26].Value = model.PHS; sp[27].Value = model.HoneyName; sp[28].Value = model.CardType; sp[29].Value = model.Shengxiao; sp[30].Value = model.Xingzuo; sp[31].Value = model.WorkProvince; sp[32].Value = model.WorkCounty; sp[33].Value = model.SFStatus; sp[34].Value = model.VIPUser; sp[35].Value = model.Bugle; sp[36].Value = model.Position; sp[37].Value = model.CompanyName; return(sp); }