/// <summary> /// 增加一条数据 /// </summary> public int Add(Hch.iDisk.Model.User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [User]("); strSql.Append("ULoginName,URealName,UEmail,UPassWord)"); strSql.Append(" values ("); strSql.Append("@ULoginName,@URealName,@UEmail,@UPassWord)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@ULoginName", SqlDbType.VarChar, 20), new SqlParameter("@URealName", SqlDbType.VarChar, 20), new SqlParameter("@UEmail", SqlDbType.VarChar, 50), new SqlParameter("@UPassWord", SqlDbType.VarChar, 128) }; parameters[0].Value = model.ULoginName; parameters[1].Value = model.URealName; parameters[2].Value = model.UEmail; parameters[3].Value = model.UPassWord; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Hch.iDisk.Model.User model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [User] set "); strSql.Append("ULoginName=@ULoginName,"); strSql.Append("URealName=@URealName,"); strSql.Append("UEmail=@UEmail,"); strSql.Append("UPassWord=@UPassWord"); strSql.Append(" where UId=@UId"); SqlParameter[] parameters = { new SqlParameter("@ULoginName", SqlDbType.VarChar, 20), new SqlParameter("@URealName", SqlDbType.VarChar, 20), new SqlParameter("@UEmail", SqlDbType.VarChar, 50), new SqlParameter("@UPassWord", SqlDbType.VarChar, 128), new SqlParameter("@UId", SqlDbType.Int, 4) }; parameters[0].Value = model.ULoginName; parameters[1].Value = model.URealName; parameters[2].Value = model.UEmail; parameters[3].Value = model.UPassWord; parameters[4].Value = model.UId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Hch.iDisk.Model.User GetModel(int UId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 UId,ULoginName,URealName,UEmail,UPassWord from [User] "); strSql.Append(" where UId=@UId"); SqlParameter[] parameters = { new SqlParameter("@UId", SqlDbType.Int, 4) }; parameters[0].Value = UId; Hch.iDisk.Model.User model = new Hch.iDisk.Model.User(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UId"].ToString() != "") { model.UId = int.Parse(ds.Tables[0].Rows[0]["UId"].ToString()); } if (ds.Tables[0].Rows[0]["ULoginName"] != null) { model.ULoginName = ds.Tables[0].Rows[0]["ULoginName"].ToString(); } if (ds.Tables[0].Rows[0]["URealName"] != null) { model.URealName = ds.Tables[0].Rows[0]["URealName"].ToString(); } if (ds.Tables[0].Rows[0]["UEmail"] != null) { model.UEmail = ds.Tables[0].Rows[0]["UEmail"].ToString(); } if (ds.Tables[0].Rows[0]["UPassWord"] != null) { model.UPassWord = ds.Tables[0].Rows[0]["UPassWord"].ToString(); } return(model); } else { return(null); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Hch.iDisk.Model.User GetModel(int UId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 UId,ULoginName,URealName,UEmail,UPassWord from [User] "); strSql.Append(" where UId=@UId"); SqlParameter[] parameters = { new SqlParameter("@UId", SqlDbType.Int,4) }; parameters[0].Value = UId; Hch.iDisk.Model.User model=new Hch.iDisk.Model.User(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["UId"].ToString()!="") { model.UId=int.Parse(ds.Tables[0].Rows[0]["UId"].ToString()); } if(ds.Tables[0].Rows[0]["ULoginName"]!=null) { model.ULoginName=ds.Tables[0].Rows[0]["ULoginName"].ToString(); } if(ds.Tables[0].Rows[0]["URealName"]!=null) { model.URealName=ds.Tables[0].Rows[0]["URealName"].ToString(); } if(ds.Tables[0].Rows[0]["UEmail"]!=null) { model.UEmail=ds.Tables[0].Rows[0]["UEmail"].ToString(); } if(ds.Tables[0].Rows[0]["UPassWord"]!=null) { model.UPassWord=ds.Tables[0].Rows[0]["UPassWord"].ToString(); } return model; } else { return null; } }