/// <summary> /// 增加一条数据 /// </summary> public bool Add(DNSABC.Model.View_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into View_user("); strSql.Append("Id,UserId,AccountBalance,AvilableBalance,ConsumedAmount,GradeID,State,RealName,Qq,Mobil,Tel,Address,Postcode,Website,IDcardNum,AccountType,SiteID,bh,RoleID,UgroupID,name,PASSWORD,email,age,login_time,sex,pic,quanxian,username,GUID,IP)"); strSql.Append(" values ("); strSql.Append("@Id,@UserId,@AccountBalance,@AvilableBalance,@ConsumedAmount,@GradeID,@State,@RealName,@Qq,@Mobil,@Tel,@Address,@Postcode,@Website,@IDcardNum,@AccountType,@SiteID,@bh,@RoleID,@UgroupID,@name,@PASSWORD,@email,@age,@login_time,@sex,@pic,@quanxian,@username,@GUID,@IP)"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@AccountBalance", SqlDbType.Int, 4), new SqlParameter("@AvilableBalance", SqlDbType.Int, 4), new SqlParameter("@ConsumedAmount", SqlDbType.Int, 4), new SqlParameter("@GradeID", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@RealName", SqlDbType.VarChar, 50), new SqlParameter("@Qq", SqlDbType.Int, 4), new SqlParameter("@Mobil", SqlDbType.VarChar, 20), new SqlParameter("@Tel", SqlDbType.VarChar, 20), new SqlParameter("@Address", SqlDbType.VarChar, 200), new SqlParameter("@Postcode", SqlDbType.VarChar, 20), new SqlParameter("@Website", SqlDbType.VarChar, 200), new SqlParameter("@IDcardNum", SqlDbType.VarChar, 20), new SqlParameter("@AccountType", SqlDbType.Int, 4), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@bh", SqlDbType.Int, 4), new SqlParameter("@RoleID", SqlDbType.VarChar, 50), new SqlParameter("@UgroupID", SqlDbType.VarChar, 50), new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@PASSWORD", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@age", SqlDbType.Int, 4), new SqlParameter("@login_time", SqlDbType.DateTime), new SqlParameter("@sex", SqlDbType.VarChar, 10), new SqlParameter("@pic", SqlDbType.VarChar, 100), new SqlParameter("@quanxian", SqlDbType.VarChar, 50), new SqlParameter("@username", SqlDbType.VarChar, 50), new SqlParameter("@GUID", SqlDbType.VarChar, 50), new SqlParameter("@IP", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.UserId; parameters[2].Value = model.AccountBalance; parameters[3].Value = model.AvilableBalance; parameters[4].Value = model.ConsumedAmount; parameters[5].Value = model.GradeID; parameters[6].Value = model.State; parameters[7].Value = model.RealName; parameters[8].Value = model.Qq; parameters[9].Value = model.Mobil; parameters[10].Value = model.Tel; parameters[11].Value = model.Address; parameters[12].Value = model.Postcode; parameters[13].Value = model.Website; parameters[14].Value = model.IDcardNum; parameters[15].Value = model.AccountType; parameters[16].Value = model.SiteID; parameters[17].Value = model.bh; parameters[18].Value = model.RoleID; parameters[19].Value = model.UgroupID; parameters[20].Value = model.name; parameters[21].Value = model.PASSWORD; parameters[22].Value = model.email; parameters[23].Value = model.age; parameters[24].Value = model.login_time; parameters[25].Value = model.sex; parameters[26].Value = model.pic; parameters[27].Value = model.quanxian; parameters[28].Value = model.username; parameters[29].Value = model.GUID; parameters[30].Value = model.IP; int rows = ROYcms.DB.DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public DNSABC.Model.View_user GetModel() { //该表无主键信息,请自定义主键/条件字段 StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserId,AccountBalance,AvilableBalance,ConsumedAmount,GradeID,State,RealName,Qq,Mobil,Tel,Address,Postcode,Website,IDcardNum,AccountType,SiteID,bh,RoleID,UgroupID,name,PASSWORD,email,age,login_time,sex,pic,quanxian,username,GUID,IP from View_user "); strSql.Append(" where "); SqlParameter[] parameters = { }; DNSABC.Model.View_user model = new DNSABC.Model.View_user(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["Id"] != null && ds.Tables[0].Rows[0]["Id"].ToString() != "") { model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString()); } if (ds.Tables[0].Rows[0]["UserId"] != null && ds.Tables[0].Rows[0]["UserId"].ToString() != "") { model.UserId = int.Parse(ds.Tables[0].Rows[0]["UserId"].ToString()); } if (ds.Tables[0].Rows[0]["AccountBalance"] != null && ds.Tables[0].Rows[0]["AccountBalance"].ToString() != "") { model.AccountBalance = int.Parse(ds.Tables[0].Rows[0]["AccountBalance"].ToString()); } if (ds.Tables[0].Rows[0]["AvilableBalance"] != null && ds.Tables[0].Rows[0]["AvilableBalance"].ToString() != "") { model.AvilableBalance = int.Parse(ds.Tables[0].Rows[0]["AvilableBalance"].ToString()); } if (ds.Tables[0].Rows[0]["ConsumedAmount"] != null && ds.Tables[0].Rows[0]["ConsumedAmount"].ToString() != "") { model.ConsumedAmount = int.Parse(ds.Tables[0].Rows[0]["ConsumedAmount"].ToString()); } if (ds.Tables[0].Rows[0]["GradeID"] != null && ds.Tables[0].Rows[0]["GradeID"].ToString() != "") { model.GradeID = int.Parse(ds.Tables[0].Rows[0]["GradeID"].ToString()); } if (ds.Tables[0].Rows[0]["State"] != null && ds.Tables[0].Rows[0]["State"].ToString() != "") { model.State = int.Parse(ds.Tables[0].Rows[0]["State"].ToString()); } if (ds.Tables[0].Rows[0]["RealName"] != null && ds.Tables[0].Rows[0]["RealName"].ToString() != "") { model.RealName = ds.Tables[0].Rows[0]["RealName"].ToString(); } if (ds.Tables[0].Rows[0]["Qq"] != null && ds.Tables[0].Rows[0]["Qq"].ToString() != "") { model.Qq = int.Parse(ds.Tables[0].Rows[0]["Qq"].ToString()); } if (ds.Tables[0].Rows[0]["Mobil"] != null && ds.Tables[0].Rows[0]["Mobil"].ToString() != "") { model.Mobil = ds.Tables[0].Rows[0]["Mobil"].ToString(); } if (ds.Tables[0].Rows[0]["Tel"] != null && ds.Tables[0].Rows[0]["Tel"].ToString() != "") { model.Tel = ds.Tables[0].Rows[0]["Tel"].ToString(); } if (ds.Tables[0].Rows[0]["Address"] != null && ds.Tables[0].Rows[0]["Address"].ToString() != "") { model.Address = ds.Tables[0].Rows[0]["Address"].ToString(); } if (ds.Tables[0].Rows[0]["Postcode"] != null && ds.Tables[0].Rows[0]["Postcode"].ToString() != "") { model.Postcode = ds.Tables[0].Rows[0]["Postcode"].ToString(); } if (ds.Tables[0].Rows[0]["Website"] != null && ds.Tables[0].Rows[0]["Website"].ToString() != "") { model.Website = ds.Tables[0].Rows[0]["Website"].ToString(); } if (ds.Tables[0].Rows[0]["IDcardNum"] != null && ds.Tables[0].Rows[0]["IDcardNum"].ToString() != "") { model.IDcardNum = ds.Tables[0].Rows[0]["IDcardNum"].ToString(); } if (ds.Tables[0].Rows[0]["AccountType"] != null && ds.Tables[0].Rows[0]["AccountType"].ToString() != "") { model.AccountType = int.Parse(ds.Tables[0].Rows[0]["AccountType"].ToString()); } if (ds.Tables[0].Rows[0]["SiteID"] != null && ds.Tables[0].Rows[0]["SiteID"].ToString() != "") { model.SiteID = int.Parse(ds.Tables[0].Rows[0]["SiteID"].ToString()); } if (ds.Tables[0].Rows[0]["bh"] != null && ds.Tables[0].Rows[0]["bh"].ToString() != "") { model.bh = int.Parse(ds.Tables[0].Rows[0]["bh"].ToString()); } if (ds.Tables[0].Rows[0]["RoleID"] != null && ds.Tables[0].Rows[0]["RoleID"].ToString() != "") { model.RoleID = ds.Tables[0].Rows[0]["RoleID"].ToString(); } if (ds.Tables[0].Rows[0]["UgroupID"] != null && ds.Tables[0].Rows[0]["UgroupID"].ToString() != "") { model.UgroupID = ds.Tables[0].Rows[0]["UgroupID"].ToString(); } if (ds.Tables[0].Rows[0]["name"] != null && ds.Tables[0].Rows[0]["name"].ToString() != "") { model.name = ds.Tables[0].Rows[0]["name"].ToString(); } if (ds.Tables[0].Rows[0]["PASSWORD"] != null && ds.Tables[0].Rows[0]["PASSWORD"].ToString() != "") { model.PASSWORD = ds.Tables[0].Rows[0]["PASSWORD"].ToString(); } if (ds.Tables[0].Rows[0]["email"] != null && ds.Tables[0].Rows[0]["email"].ToString() != "") { model.email = ds.Tables[0].Rows[0]["email"].ToString(); } if (ds.Tables[0].Rows[0]["age"] != null && ds.Tables[0].Rows[0]["age"].ToString() != "") { model.age = int.Parse(ds.Tables[0].Rows[0]["age"].ToString()); } if (ds.Tables[0].Rows[0]["login_time"] != null && ds.Tables[0].Rows[0]["login_time"].ToString() != "") { model.login_time = DateTime.Parse(ds.Tables[0].Rows[0]["login_time"].ToString()); } if (ds.Tables[0].Rows[0]["sex"] != null && ds.Tables[0].Rows[0]["sex"].ToString() != "") { model.sex = ds.Tables[0].Rows[0]["sex"].ToString(); } if (ds.Tables[0].Rows[0]["pic"] != null && ds.Tables[0].Rows[0]["pic"].ToString() != "") { model.pic = ds.Tables[0].Rows[0]["pic"].ToString(); } if (ds.Tables[0].Rows[0]["quanxian"] != null && ds.Tables[0].Rows[0]["quanxian"].ToString() != "") { model.quanxian = ds.Tables[0].Rows[0]["quanxian"].ToString(); } if (ds.Tables[0].Rows[0]["username"] != null && ds.Tables[0].Rows[0]["username"].ToString() != "") { model.username = ds.Tables[0].Rows[0]["username"].ToString(); } if (ds.Tables[0].Rows[0]["GUID"] != null && ds.Tables[0].Rows[0]["GUID"].ToString() != "") { model.GUID = ds.Tables[0].Rows[0]["GUID"].ToString(); } if (ds.Tables[0].Rows[0]["IP"] != null && ds.Tables[0].Rows[0]["IP"].ToString() != "") { model.IP = ds.Tables[0].Rows[0]["IP"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(DNSABC.Model.View_user model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update View_user set "); strSql.Append("Id=@Id,"); strSql.Append("UserId=@UserId,"); strSql.Append("AccountBalance=@AccountBalance,"); strSql.Append("AvilableBalance=@AvilableBalance,"); strSql.Append("ConsumedAmount=@ConsumedAmount,"); strSql.Append("GradeID=@GradeID,"); strSql.Append("State=@State,"); strSql.Append("RealName=@RealName,"); strSql.Append("Qq=@Qq,"); strSql.Append("Mobil=@Mobil,"); strSql.Append("Tel=@Tel,"); strSql.Append("Address=@Address,"); strSql.Append("Postcode=@Postcode,"); strSql.Append("Website=@Website,"); strSql.Append("IDcardNum=@IDcardNum,"); strSql.Append("AccountType=@AccountType,"); strSql.Append("SiteID=@SiteID,"); strSql.Append("bh=@bh,"); strSql.Append("RoleID=@RoleID,"); strSql.Append("UgroupID=@UgroupID,"); strSql.Append("name=@name,"); strSql.Append("PASSWORD=@PASSWORD,"); strSql.Append("email=@email,"); strSql.Append("age=@age,"); strSql.Append("login_time=@login_time,"); strSql.Append("sex=@sex,"); strSql.Append("pic=@pic,"); strSql.Append("quanxian=@quanxian,"); strSql.Append("username=@username,"); strSql.Append("GUID=@GUID,"); strSql.Append("IP=@IP"); strSql.Append(" where "); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4), new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@AccountBalance", SqlDbType.Int, 4), new SqlParameter("@AvilableBalance", SqlDbType.Int, 4), new SqlParameter("@ConsumedAmount", SqlDbType.Int, 4), new SqlParameter("@GradeID", SqlDbType.Int, 4), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@RealName", SqlDbType.VarChar, 50), new SqlParameter("@Qq", SqlDbType.Int, 4), new SqlParameter("@Mobil", SqlDbType.VarChar, 20), new SqlParameter("@Tel", SqlDbType.VarChar, 20), new SqlParameter("@Address", SqlDbType.VarChar, 200), new SqlParameter("@Postcode", SqlDbType.VarChar, 20), new SqlParameter("@Website", SqlDbType.VarChar, 200), new SqlParameter("@IDcardNum", SqlDbType.VarChar, 20), new SqlParameter("@AccountType", SqlDbType.Int, 4), new SqlParameter("@SiteID", SqlDbType.Int, 4), new SqlParameter("@bh", SqlDbType.Int, 4), new SqlParameter("@RoleID", SqlDbType.VarChar, 50), new SqlParameter("@UgroupID", SqlDbType.VarChar, 50), new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@PASSWORD", SqlDbType.VarChar, 50), new SqlParameter("@email", SqlDbType.VarChar, 50), new SqlParameter("@age", SqlDbType.Int, 4), new SqlParameter("@login_time", SqlDbType.DateTime), new SqlParameter("@sex", SqlDbType.VarChar, 10), new SqlParameter("@pic", SqlDbType.VarChar, 100), new SqlParameter("@quanxian", SqlDbType.VarChar, 50), new SqlParameter("@username", SqlDbType.VarChar, 50), new SqlParameter("@GUID", SqlDbType.VarChar, 50), new SqlParameter("@IP", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Id; parameters[1].Value = model.UserId; parameters[2].Value = model.AccountBalance; parameters[3].Value = model.AvilableBalance; parameters[4].Value = model.ConsumedAmount; parameters[5].Value = model.GradeID; parameters[6].Value = model.State; parameters[7].Value = model.RealName; parameters[8].Value = model.Qq; parameters[9].Value = model.Mobil; parameters[10].Value = model.Tel; parameters[11].Value = model.Address; parameters[12].Value = model.Postcode; parameters[13].Value = model.Website; parameters[14].Value = model.IDcardNum; parameters[15].Value = model.AccountType; parameters[16].Value = model.SiteID; parameters[17].Value = model.bh; parameters[18].Value = model.RoleID; parameters[19].Value = model.UgroupID; parameters[20].Value = model.name; parameters[21].Value = model.PASSWORD; parameters[22].Value = model.email; parameters[23].Value = model.age; parameters[24].Value = model.login_time; parameters[25].Value = model.sex; parameters[26].Value = model.pic; parameters[27].Value = model.quanxian; parameters[28].Value = model.username; parameters[29].Value = model.GUID; parameters[30].Value = model.IP; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }