/// <summary> /// 更新一条数据 /// </summary> public bool Update(TravelAgency.Model.AuthUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update AuthUser set "); strSql.Append("Account=@Account,"); strSql.Append("UserName=@UserName,"); strSql.Append("Password=@Password,"); strSql.Append("UserMobile=@UserMobile,"); strSql.Append("DepartmentId=@DepartmentId,"); strSql.Append("RID=@RID,"); strSql.Append("RoleName=@RoleName"); strSql.Append(" where WorkId=@WorkId "); SqlParameter[] parameters = { new SqlParameter("@Account", SqlDbType.VarChar, 20), new SqlParameter("@UserName", SqlDbType.VarChar, 100), new SqlParameter("@Password", SqlDbType.VarChar, 100), new SqlParameter("@UserMobile", SqlDbType.VarChar, 50), new SqlParameter("@DepartmentId", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@RID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@RoleName", SqlDbType.VarChar, 50), new SqlParameter("@WorkId", SqlDbType.VarChar, 50) }; parameters[0].Value = model.Account; parameters[1].Value = model.UserName; parameters[2].Value = model.Password; parameters[3].Value = model.UserMobile; parameters[4].Value = model.DepartmentId; parameters[5].Value = model.RID; parameters[6].Value = model.RoleName; parameters[7].Value = model.WorkId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TravelAgency.Model.AuthUser DataRowToModel(DataRow row) { TravelAgency.Model.AuthUser model = new TravelAgency.Model.AuthUser(); if (row != null) { if (row["WorkId"] != null) { model.WorkId = row["WorkId"].ToString(); } if (row["Account"] != null) { model.Account = row["Account"].ToString(); } if (row["UserName"] != null) { model.UserName = row["UserName"].ToString(); } if (row["Password"] != null) { model.Password = row["Password"].ToString(); } if (row["UserMobile"] != null) { model.UserMobile = row["UserMobile"].ToString(); } if (row["DepartmentId"] != null && row["DepartmentId"].ToString() != "") { model.DepartmentId = new Guid(row["DepartmentId"].ToString()); } if (row["RID"] != null && row["RID"].ToString() != "") { model.RID = new Guid(row["RID"].ToString()); } if (row["RoleName"] != null) { model.RoleName = row["RoleName"].ToString(); } } return(model); }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(TravelAgency.Model.AuthUser model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into AuthUser("); strSql.Append("WorkId,Account,UserName,Password,UserMobile,DepartmentId,RID,RoleName)"); strSql.Append(" values ("); strSql.Append("@WorkId,@Account,@UserName,@Password,@UserMobile,@DepartmentId,@RID,@RoleName)"); SqlParameter[] parameters = { new SqlParameter("@WorkId", SqlDbType.VarChar, 50), new SqlParameter("@Account", SqlDbType.VarChar, 20), new SqlParameter("@UserName", SqlDbType.VarChar, 100), new SqlParameter("@Password", SqlDbType.VarChar, 100), new SqlParameter("@UserMobile", SqlDbType.VarChar, 50), new SqlParameter("@DepartmentId", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@RID", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@RoleName", SqlDbType.VarChar, 50) }; parameters[0].Value = model.WorkId; parameters[1].Value = model.Account; parameters[2].Value = model.UserName; parameters[3].Value = model.Password; parameters[4].Value = model.UserMobile; parameters[5].Value = Guid.NewGuid(); parameters[6].Value = Guid.NewGuid(); parameters[7].Value = model.RoleName; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public TravelAgency.Model.AuthUser GetModel(string WorkId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 WorkId,Account,UserName,Password,UserMobile,DepartmentId,RID,RoleName from AuthUser "); strSql.Append(" where WorkId=@WorkId "); SqlParameter[] parameters = { new SqlParameter("@WorkId", SqlDbType.VarChar, 50) }; parameters[0].Value = WorkId; TravelAgency.Model.AuthUser model = new TravelAgency.Model.AuthUser(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }