public DataSet GetCustomersLike(string contactName) { IDbParameters dbParameters = CreateDbParameters(); dbParameters.Add("ContactName", DbType.String).Value = contactName; return(AdoTemplate.DataSetCreateWithParams(CommandType.Text, selectLike, dbParameters)); }
/// 用户列表 /// </summary> public int GetMasterList(Pager p, Hashtable hs) { string sql = "select * from T_Master"; IDbParameters param = AdoTemplate.CreateDbParameters(); sql = PagerSql(sql, p); DataSet ds = AdoTemplate.DataSetCreateWithParams(CommandType.Text, sql, param); p.DataSource = ds.Tables[0]; p.ItemCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]); return(0); }
/// 角色列表 /// </summary> public int GetGroupList(Pager p, Hashtable hs) { string sql = @"select a.*,b.MasterName from T_Group a left join T_Master b on b.ID=a.CreateBy"; IDbParameters param = AdoTemplate.CreateDbParameters(); sql = PagerSql(sql, p); DataSet ds = AdoTemplate.DataSetCreateWithParams(CommandType.Text, sql, param); p.DataSource = ds.Tables[0]; p.ItemCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]); return(0); }
/// <summary> /// 获取用户权限 /// </summary> /// <param name="hs"></param> /// <returns></returns> public DataTable GetMasterAction(int MasterID) { string sql = @"select * from t_action where Code in ( select ActionCode from T_ActionGroup where GroupID in (select GroupID from T_MasterGroup where MasterID=@MasterID ) )"; IDbParameters param = AdoTemplate.CreateDbParameters(); param.AddWithValue("MasterID", MasterID); DataSet ds = AdoTemplate.DataSetCreateWithParams(CommandType.Text, sql, param); return(ds.Tables[0]); }
/// 资源列表 /// </summary> public DataTable GetActionList(Hashtable hs) { string sql = "select * from T_Action where 1=1 "; IDbParameters param = AdoTemplate.CreateDbParameters(); if (hs.Contains("ParentCode")) { sql += " and ParentCode=@ParentCode"; param.AddWithValue("ParentCode", hs["ParentCode"]); } if (hs.Contains("Disabled")) { sql += " and Disabled=@Disabled "; param.AddWithValue("Disabled", hs["Disabled"]); } DataSet ds = AdoTemplate.DataSetCreateWithParams(CommandType.Text, sql, param); return(ds.Tables[0]); }
/// <summary> /// 执行sql语句 /// </summary> public DataSet ExecteSqlDataSet(string sql, IDbParameters parms, CommandType commandType = CommandType.Text) { return(AdoTemplate.DataSetCreateWithParams(commandType, sql, parms)); }