/// <summary> /// 获取全部参数名称数据 /// </summary> /// <returns></returns> public DataSet Get_Data() { if (dr == null) { dr = new CallDatabase(); } dr.InitiCommand("select [Id],[ConfigName],[Memo],[No],[Status] from [Sys_ParameterName] order by [No] "); return(dr.DataList()); }
/// <summary> /// 根据主键查询数据 /// </summary> /// <param name="id">主键</param> /// <returns>返回数据集</returns> public DataSet Get_Data(int id) { if (dr == null) { dr = new CallDatabase(); } dr.InitiCommand("select Id,ExpendDate,ExpendType,ItemName,Amount,Reason,Remarks from [Expend] where [Id]=@Id "); dr.AddParameters("Id", DbType.Int32, id); return(dr.DataList()); }
/// <summary> /// 查询数据集 /// </summary> /// <returns></returns> public DataSet Get_Data() { if (dr == null) { dr = new CallDatabase(); } dr.InitiCommand("select Id,LoginName,Pwd,UserName,Remarks,IsAdmin from [Sys_User]"); DataSet data = dr.DataList(); dr.Close(); return(data); }
/// <summary> /// 根据主键查询数据 /// </summary> /// <param name="id">主键</param> /// <returns></returns> public DataSet Get_SingleData(int id) { if (dr == null) { dr = new CallDatabase(); } dr.InitiCommand("select * from [Sys_ParameterValue] where [Id]=@Id"); dr.AddParameters("Id", DbType.Int32, id); DataSet data = dr.DataList(); dr.Close(); return(data); }
/// <summary> /// 根据主键来获取数据集 /// </summary> /// <param name="id">主键</param> /// <returns></returns> public DataSet GetData(int id, out DataTable log_Contents_Data) { log_Contents_Data = new DataTable(); ICallDatabase dr = new CallDatabase(); dr.InitiCommand(); dr.CommandText = "select Login_Name,ModuleName,OperationType,Result,ResultsDescribed,Creation_Date from [Log_Operating] where Id=@Id "; dr.AddParameters("Id", DbType.Int32, id); DataSet data = dr.DataList(); dr.CommandText = "select Contents from [Log_Operating_Contents] where L_Id=@Id order by [No]"; log_Contents_Data = dr.DataList().Tables[0]; dr.Close(); dr.Dispose(); return(data); }
/// <summary> /// 根据日期获取数据 /// </summary> /// <param name="date">日期</param> /// <param name="loginName">登录用户</param> /// <returns></returns> public DataSet GetData(DateTime date, string loginName) { ICallDatabase dr = new CallDatabase(); dr.InitiCommand(); dr.CommandText = "select Login_Name,Result,ResultsDescribed,Creation_Date from [Log_Login] where DateDiff(day,Creation_Date,@Creation_Date)=0 And [Login_Name] like @Login_Name order by [Creation_Date] desc"; dr.AddParameters("Creation_Date", DbType.String, 20, date.ToString()); dr.AddParameters("Login_Name", DbType.String, 50, "%" + loginName + "%"); DataSet data = dr.DataList(); dr.Close(); dr.Dispose(); return(data); }
/// <summary> /// 调用分页的存储过程 /// </summary> /// <returns></returns> public DataSet GetData() { dr.InitiCommand(); dr.CommandText = "PROCE_PAGECHANGE"; dr.CommandType = CommandType.StoredProcedure; dr.AddParameters("TableName", DbType.String, 50, TableName); dr.AddParameters("ReFieldsStr", DbType.String, 200, ReFieldsStr); dr.AddParameters("OrderString", DbType.String, 200, OrderString); dr.AddParameters("WhereString", DbType.String, 500, WhereString); dr.AddParameters("OnString", DbType.String, 500, OnString); dr.AddParameters("PageSize", DbType.Int32, PageSize); dr.AddParameters("PageIndex", DbType.Int32, PageIndex); dr.AddParameters("TotalRecord", DbType.Int32, 1); DbParameter Value = dr.AddParametersDirection("PageCount", DbType.Int32); DataSet data = dr.DataList();//.SqlInquiry(StoredProcedures, parameters); PageCount = int.Parse(Value.Value.ToString()); return(data); }