/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable getData2(string s) { string sql = "select * into temp4 from " + s + ""; DataTable dt = SQLHelper.ExecuteDt(base.User_Admin, sql, null); return(dt); }
/// <summary> /// 选择查询 /// </summary> /// <param name="pWhere"></param> /// <returns></returns> public DataTable selectData(string pWhere, string pData) { string sql = "select a.*,b.* from zuce a join xinxi b on a.shenfenzheng=b.shenfenzheng"; switch (pWhere) { case "shenfenzheng": sql = sql + " where a.shenfenzheng=@data"; break; case "xingming": pData = "%" + pData + "%"; sql = sql + " where b.xingming like @data"; break; default: sql = sql + " where a.shenfenzheng=@data"; break; } SqlParameter[] param = new SqlParameter[] { new SqlParameter("@data", SqlDbType.VarChar, 20) }; param[0].Value = pData; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 查询应用 /// </summary> /// <returns></returns> public DataTable chaxun() { string sql = "select distinct yingyong from gongneng";// where xingming=@xingming DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, null); return(dt); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable getData9(string a) { string sql = "select * from yonghu where daihao= " + a + ""; DataTable dt = SQLHelper.ExecuteDt(base.User_Admin, sql, null); return(dt); }
/// <summary> /// 查询xt_tongji /// </summary> /// <returns></returns> public DataTable getData() { string sql = "select * from xt_tongji"; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, CommandType.Text, sql, null); return(dt); }
public DataTable getGongneng() { string sql = "select * from gongneng "; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, null); return(dt); }
/// <summary> /// 按条件提取数据 /// </summary> /// <param name="pWhere"></param> /// <param name="pData"></param> /// <returns></returns> public DataTable getDataWhere(string pWhere, string pData) { string sql = "select * from caidan "; switch (pWhere) { case "yonghu": sql = sql + " where yonghu=@data "; break; case "xuhao": sql = sql + " where xuhao=@data "; break; default: sql = sql + " where xuhao=@data "; break; } sql = sql + " order by xuhao;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@data", SqlDbType.VarChar) }; param[0].Value = pData; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable getData() { string sql = "select a.*,b.* from zuce a join xinxi b on a.shenfenzheng=b.shenfenzheng"; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, null); return(dt); }
/// <summary> /// 查询表字段 /// </summary> /// <returns></returns> public DataTable getData1() { string sql = "Select name FROM SysColumns Where id=Object_Id('yonghu');"; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, null); return(dt); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable getData() { string sql = "select * from yonghu ;"; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, null); return(dt); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable getData4(string a) { //[自动编号字段] int IDENTITY (1,1) PRIMARY KEY , string sql = " create table [temp5] ( [" + a + "] nVarChar(50) default '默认值' null )"; DataTable dt = SQLHelper.ExecuteDt(base.User_Admin, sql, null); return(dt); }
/// <summary> /// 提取上传数据 /// </summary> /// <returns></returns> public DataTable getData_Import() { string sql = "select * from zm_cjzm where xuhao in (select xh from temp_data) order by xuhao ;"; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, null); return(dt); }
/// <summary> /// 查询应用 /// </summary> /// <returns></returns> public DataTable chaxun(string Table) { string sql = "select * from " + Table + "";// SqlParameter[] param = new SqlParameter[] { new SqlParameter("@xingming", SqlDbType.VarChar) }; param[0].Value = Table; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 用户菜单 /// </summary> /// <param name="pYingyong"></param> /// <returns></returns> public DataTable getDataCaidan(string pYingyong) { string sql = "select *,left(bianhao,2) zu1,right(bianhao,4) zu2 from caidan where yingyong=@yingyong order by bianhao;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar) }; param[0].Value = pYingyong; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, CommandType.Text, sql, param); return(dt); }
/// <summary> /// getalldate /// </summary> /// <param name="p"></param> /// <returns></returns> public DataTable getalldate(string p) { string sql = "select *from zm_cjzm where xuhao like @xuhao"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@xuhao", SqlDbType.VarChar, 20) }; param[0].Value = p; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 查询应用 /// </summary> /// <returns></returns> public DataTable getChaxun(string pZubie) { string sql = "select daihao ,mingcheng from yonghu where zubie=@zubie "; SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@zubie", pZubie); DataTable dt = SQLHelper.ExecuteDt(base.User_Admin, sql, para); return(dt); }
public DataTable getYingyong(string pYingyong) { string sql = "select * from caidan where yingyong=@pYingyong "; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@pYingyong", SqlDbType.VarChar) }; param[0].Value = pYingyong; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
public DataTable chaxun(string p) { string sql = "select *from zm_cjzm";// where xingming=@xingming SqlParameter[] param = new SqlParameter[] { new SqlParameter("@xingming", SqlDbType.VarChar) }; param[0].Value = p; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
public DataTable selectData(string zhanghao, string mima) { string sql = "select *from hx_yonghu where zhanghao=@zhanghao and mima=@mima"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@zhanghao", SqlDbType.VarChar, 20), new SqlParameter("@mima", SqlDbType.VarChar, 20) }; param[0].Value = zhanghao; param[1].Value = mima; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 获取证书 /// </summary> /// <param name="pXuhao"></param> /// <param name="pKaoshenghao"></param> /// <returns></returns> public DataTable getData(string pXuhao, string pShenfenzheng) { string sql = "select * from zm_cjzm where xuhao=@xuhao and shenfenzheng=@shenfenzheng;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@xuhao", SqlDbType.VarChar), new SqlParameter("@shenfenzheng", SqlDbType.VarChar) }; param[0].Value = pXuhao; param[1].Value = pShenfenzheng; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
public DataTable getDate(string xingming, string shenfenzheng) { string sql = "select *from zm_cjzm where xingming=@xingming and shenfenzheng=@shenfenzheng"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@xingming", SqlDbType.VarChar, 20), new SqlParameter("@shenfenzheng", SqlDbType.VarChar, 20) }; param[0].Value = xingming; param[1].Value = shenfenzheng; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable getData(string yonghu) { string sql = "select a.*,b.* from zuce a join xinxi b on a.shenfenzheng=b.shenfenzheng where a.yonghu=@yonghu"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yonghu", SqlDbType.VarChar, 20) }; param[0].Value = yonghu; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 查询账户 /// </summary> /// <param name="yonghu"></param> /// <param name="mima"></param> /// <returns></returns> public DataTable getData(string yonghu) { string sql = "select * from zuce where yonghu= @yonghu"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yonghu", SqlDbType.VarChar, 20) }; param[0].Value = yonghu; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 获取用户功能 /// </summary> /// <param name="pYonghu">用户代号</param> /// <param name="pBianhao">菜单编号</param> /// <returns>DataTable</returns> public DataTable getGongneng_Bianhao(gongneng mGongneng) { string sql = "select * from gongneng where daihao=@daihao and yingyong=@yingyong and bianhao=@bianhao; "; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@daihao", SqlDbType.VarChar, 20), new SqlParameter("@yingyong", SqlDbType.VarChar, 20), new SqlParameter("@bianhao", SqlDbType.VarChar, 6) }; param[0].Value = mGongneng.Daihao; param[1].Value = mGongneng.Yingyong; param[2].Value = mGongneng.Bianhao; DataTable dt = SQLHelper.ExecuteDt(base.User_Admin, sql, param); return(dt); }
/// <summary> /// 获取用户功能菜单 /// </summary> /// <param name="pYonghu">用户代号</param> /// <param name="pCanshu">参数</param> /// <returns>返回DataTable</returns> public DataTable getGongneng_Yonghu(gongneng mGongneng) { string sql = "select *,left(bianhao,2)+'0000' fuxuhao from gongneng a where a.daihao=@daihao and yingyong=@yingyong and a.canshu0=@canshu order by a.xuhao ;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@daihao", SqlDbType.VarChar, 20), new SqlParameter("@yingyong", SqlDbType.VarChar, 20), new SqlParameter("@canshu", SqlDbType.VarChar, 1) }; param[0].Value = mGongneng.Daihao; param[1].Value = mGongneng.Yingyong; param[2].Value = mGongneng.Canshu0; DataTable dt = SQLHelper.ExecuteDt(base.User_Admin, sql, param); return(dt); }
/// <summary> /// 查询用户菜单 /// </summary> /// <param name="daihao"></param> /// <returns></returns> public DataTable getCaidan(string pYingyong, string pYonghu) { string sql = "select a.*,left(a.bianhao,2) zu1,right(a.bianhao,4) zu2,b.jiancheng,b.url,b.image from gongneng a,caidan b " + "where (a.yingyong=b.yingyong and a.bianhao=b.bianhao) and a.yingyong=@yingyong and a.daihao=@daihao and a.canshu0='1' " + " order by left(b.bianhao,2),b.xuhao;"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@yingyong", SqlDbType.VarChar), new SqlParameter("@daihao", SqlDbType.VarChar) }; param[0].Value = pYingyong; param[1].Value = pYonghu; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
public DataTable chaxunxuhao(string xuhao, string xingming) { string sql = "select *from zm_cjzm where xuhao like @xuhao and xingming like @xingming"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@xuhao", SqlDbType.VarChar, 20), new SqlParameter("@xingming", SqlDbType.VarChar, 20) }; param[0].Value = xuhao; param[1].Value = xingming; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }
/// <summary> /// 查询 /// </summary> /// <returns></returns> public DataTable getData5(string a) { string sql = "ALTER TABLE [temp5] ADD "; switch (a) { //case "学校代号": // sql=sql+" ["+a+"] NVARCHAR (50) NULL ;"; // break; //case "学校名称": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "专业序号": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "招生专业名称": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "科类": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "层次": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "学制": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "学费": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "计划数": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; //case "备注": // sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; // break; case "daihao": sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; break; case "mingcheng": sql = sql + " [" + a + "] NVARCHAR (50) NULL ;"; break; } DataTable dt = SQLHelper.ExecuteDt(base.User_Admin, sql, null); return(dt); }
public DataTable getData3(string d, string m, string r, string b) { string sql = "insert into temp4(daihao,mingcheng,renshu,baoming)values(@d,@m,@r,@b)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@d", SqlDbType.VarChar, 50), new SqlParameter("@m", SqlDbType.VarChar, 50), new SqlParameter("@r", SqlDbType.VarChar, 50), new SqlParameter("@b", SqlDbType.VarChar, 50) }; param[0].Value = d; param[1].Value = m; param[2].Value = r; param[3].Value = b; DataTable dt = SQLHelper.ExecuteDt(base.User_Login, sql, param); return(dt); }