public M_Pub GetModelFromReader(DbDataReader rdr) { M_Pub model = new M_Pub(); model.Pubid = Convert.ToInt32(rdr["Pubid"]); model.PubName = ConverToStr(rdr["PubName"]); model.PubClass = ConvertToInt(rdr["PubClass"]); model.PubTableName = ConverToStr(rdr["PubTableName"]); model.PubType = ConvertToInt(rdr["PubType"]); model.PubOneOrMore = ConvertToInt(rdr["PubOneOrMore"]); model.PubIPOneOrMore = ConvertToInt(rdr["PubIPOneOrMore"]); model.PubTemplate = ConverToStr(rdr["PubTemplate"]); model.PubLoadstr = ConverToStr(rdr["PubLoadstr"]); model.PubModelID = ConvertToInt(rdr["PubModelID"]); model.PubNodeID = ConverToStr(rdr["PubNodeID"]); model.PubTemplateID = rdr["PubTemplateID"].ToString(); model.Pubinfo = ConverToStr(rdr["Pubinfo"]); model.PubIsTrue = ConvertToInt(rdr["PubIsTrue"]); model.PubCode = ConvertToInt(rdr["PubCode"]); model.PubLogin = ConvertToInt(rdr["PubLogin"]); model.PubAddnum = ConvertToInt(rdr["PubAddnum"]); model.PubBindPub = ConvertToInt(rdr["PubBindPub"]); model.PubShowType = ConvertToInt(rdr["PubShowType"]); model.PubInputTM = ConverToStr(rdr["PubInputTM"]); model.PubInputLoadStr = ConverToStr(rdr["PubInputLoadStr"]); model.PubCreateTime = ConvertToDate(rdr["PubCreateTime"]); model.PubLoginUrl = ConverToStr(rdr["PubLoginUrl"]); model.PubOpenComment = ConvertToInt(rdr["PubOpenComment"]); model.PubEndTime = ConvertToDate(rdr["PubEndTime"]); model.PubIsDel = ConvertToInt(rdr["PubIsDel"]); model.PubTimeSlot = ConvertToInt(rdr["PubTimeSlot"]); model.Pubkeep = ConvertToInt(rdr["Pubkeep"]); model.Puberrmsg = ConverToStr(rdr["Puberrmsg"]); model.PubGourl = ConverToStr(rdr["PubGourl"]); model.PubSiteID = ConvertToInt(rdr["PubSiteID"]); model.Public = ConvertToInt(rdr["Public"]); model.PubPermissions = ConverToStr(rdr["PubPermissions"]); model.Interval = ConvertToInt(rdr["Interval"]); model.PubFlag = ConvertToInt(rdr["PubFlag"]); model.VerifyMode = ConverToStr(rdr["VerifyMode"]); rdr.Close(); return(model); }
public override SqlParameter[] GetParameters() { M_Pub model = this; SqlParameter[] sp = GetSP(); sp[0].Value = model.Pubid; sp[1].Value = model.PubName; sp[2].Value = model.PubClass; sp[3].Value = model.PubTableName; sp[4].Value = model.PubType; sp[5].Value = model.PubOneOrMore; sp[6].Value = model.PubIPOneOrMore; sp[7].Value = model.PubTemplate; sp[8].Value = model.PubLoadstr; sp[9].Value = model.PubModelID; sp[10].Value = model.PubNodeID; sp[11].Value = model.PubTemplateID; sp[12].Value = model.Pubinfo; sp[13].Value = model.PubIsTrue; sp[14].Value = model.PubCode; sp[15].Value = model.PubLogin; sp[16].Value = model.PubAddnum; sp[17].Value = model.PubBindPub; sp[18].Value = model.PubShowType; sp[19].Value = model.PubInputTM; sp[20].Value = model.PubInputLoadStr; sp[21].Value = model.PubCreateTime; sp[22].Value = model.PubLoginUrl; sp[23].Value = model.PubOpenComment; sp[24].Value = model.PubEndTime; sp[25].Value = model.PubIsDel; sp[26].Value = model.PubTimeSlot; sp[27].Value = model.Pubkeep; sp[28].Value = model.Puberrmsg; sp[29].Value = model.PubGourl; sp[30].Value = model.PubSiteID; sp[31].Value = model.Public; sp[32].Value = model.PubPermissions; sp[33].Value = model.Interval; sp[34].Value = model.PubFlag; sp[35].Value = model.VerifyMode; return(sp); }