/// <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);
}