/// <summary> /// 增加一条数据 /// </summary> public bool Add(MES.Model.UserModuleAuth model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserModuleAuth("); strSql.Append("uid,moduleID,UserType)"); strSql.Append(" values ("); strSql.Append("@uid,@moduleID,@UserType)"); SqlParameter[] parameters = { new SqlParameter("@uid", SqlDbType.Int, 4), new SqlParameter("@moduleID", SqlDbType.Int, 4), new SqlParameter("@UserType", SqlDbType.Char, 1) }; parameters[0].Value = model.uid; parameters[1].Value = model.moduleID; parameters[2].Value = model.UserType; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MES.Model.UserModuleAuth GetModel(int uid, int moduleid, string UserType) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 uid,moduleID,UserType from UserModuleAuth "); strSql.Append(" where uid=@uid and moduleid = @moduleid and UserType=@UserType "); SqlParameter[] parameters = { new SqlParameter("@uid", SqlDbType.Int, 4), new SqlParameter("@moduleid", SqlDbType.Int, 4), new SqlParameter("@UserType", SqlDbType.Char, 1) }; parameters[0].Value = uid; parameters[1].Value = moduleid; parameters[2].Value = UserType; MES.Model.UserModuleAuth model = new MES.Model.UserModuleAuth(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MES.Model.UserModuleAuth DataRowToModel(DataRow row) { MES.Model.UserModuleAuth model = new MES.Model.UserModuleAuth(); if (row != null) { if (row["uid"] != null && row["uid"].ToString() != "") { model.uid = int.Parse(row["uid"].ToString()); } if (row["moduleID"] != null && row["moduleID"].ToString() != "") { model.moduleID = int.Parse(row["moduleID"].ToString()); } if (row["UserType"] != null) { model.UserType = row["UserType"].ToString(); } } return(model); }