📄 report.cs
字号:
using System;
using System.Collections;
using OI.Modules;
namespace OI.Data
{
//设计人:陈仕欣 日期:2003-11-19
//v1.0 修改日期:2003-11-19
/// <summary>
/// 枚举类：reports
/// 集合元素类：report
/// </summary>
/// <example>
/// <code>
/// reports oFileList=new reports()
/// foreach(reports.report in oFileList)
/// {
/// }
/// </code>
/// <code>
/// reports.report oFileList=new
/// </code>
/// </example>
public class reports :OI.Data.DbObject,IEnumerable
{
private string cSearchKey;
//出错信息;
private string cErrorMessage;
private string cReportID="";
private string cUserID="";
private string cTitle="";
private int nCurrentRecordNum=0;
public int CurrentRecordNum
{
get
{
return this.nCurrentRecordNum;
}
set
{
this.nCurrentRecordNum=value;
}
}
/// <summary>
/// 设置过滤条件:报告ID
/// </summary>
public string ReportID
{
get
{
return cReportID;
}
set
{
cReportID=OI.Modules.String.GenSafeChars(value);;
}
}
/// <summary>
/// 设置过滤条件:用户ID
/// </summary>
public string UserID
{
get
{
return cUserID;
}
set
{
cUserID=OI.Modules.String.GenSafeChars(value);;
}
}
/// <summary>
/// 设置过滤条件:标题
/// </summary>
public string Title
{
get
{
return cTitle;
}
set
{
cTitle=OI.Modules.String.GenSafeChars(value);;
}
}
System.Data.DataSet oDataSet;
/// <summary>
/// 出错信息
/// </summary>
public string ErrorMessage
{
get
{
return cErrorMessage;
}
set
{
cErrorMessage=value;
}
}
/// <summary>
/// 组织查询条件
/// </summary>
/// <returns>查询字符串</returns>
private string GenSqlFilter()
{
string cSql="";
if(this.cReportID!="")
{
if(cSql!="")
cSql=cSql+" and ReportID ='"+this.cReportID+"' " ;
else
cSql=cSql+" where ReportID ='"+this.cReportID+"' " ;
}
if(this.cUserID!="")
{
if(cSql!="")
cSql=cSql+" and UserID ='"+this.cUserID+"' " ;
else
cSql=cSql+" where UserID ='"+this.cUserID+"' " ;
}
if(this.cTitle!="")
{
if(cSql!="")
cSql=cSql+" and Title ='"+this.cTitle+"' " ;
else
cSql=cSql+" where Title ='"+this.cTitle+"' " ;
}
if(cSearchKey!=null&&cSearchKey!="")
{
if(cSql!="")
cSql=cSql+" And (Title like '%"+cSearchKey+"%')";
else
cSql=cSql+" Where (Title like '%"+cSearchKey+"%')";
}
return cSql; }
/// <summary>
/// 从项目中获取数据
/// </summary>
/// <returns>成功/失败</returns>
public void GetData()
{
if(oDataSet !=null)
oDataSet.Clear();
string sqlFilter=this.GenSqlFilter();
string calculateCmdString="select count(*) from Document"+sqlFilter;
string sql="SQLQueryBlock"+GenSqlFilter();//在些写入Sql查询语句
try
{
oDataSet=this.RunCommand(calculateCmdString,sql,"tablename");//在此写入表名
}
catch(System.Data.SqlClient.SqlException e)
{
if(this.Connection.State==System.Data.ConnectionState.Open)
this.Connection.Close();
throw new AppException("执行下列语句出错：\n\r"+sql,e);
}
}
/// <summary>
/// 查询关键字
///在以下项目中查询:
///
/// </summary>
public string SearchKey
{
get
{
return cSearchKey;
}
set
{
cSearchKey=OI.Modules.String.GenSafeChars(value);
}
}
/// <summary>
/// 获取查询后的数据XML格式字符串
/// </summary>
/// <returns>成功或失败</returns>
public string GetDataXml()
{
if(this.oDataSet==null)
GetData();
return oDataSet.GetXml() ;
}
/// <summary>
/// 构造函数
/// </summary>
public reports(string newConnectionString):base(newConnectionString)
{
}
public reports()
{
}
/// <summary>
/// 增加
/// </summary>
/// <returns></returns>
public bool Addreport()
{
return true;
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public bool Editreport()
{
return true;
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public bool Deletereport()
{
return true;
}
/// <summary>
/// 获取当前的元素
/// </summary>
/// <returns>返回元素类</returns>
public IEnumerator GetEnumerator()
{
return new report(this);
}
public bool Disponse()
{
if(this.oDataSet!=null)
{
this.oDataSet.Clear();
this.oDataSet.Dispose();
}
return true;
}
//内含的类
/// <summary>
/// 内含的类
/// </summary>
public class report:OI.Data.DbObject,IEnumerator
{
//============================以下代码为类:report的属性变量
int nReportID;
int nUserID;
string cTitle;
string cContent;
bool isSend;
DateTime dReportDate;
string cFilePath;
string cFileDescription;
bool deleteSign;
//以下代码为类:report的属性变量
/// <summary>
/// 属性:报告ID
/// </summary>
public int ReportID
{
get
{
return nReportID;
}
set
{
nReportID=value;
}
}
/// <summary>
/// 属性:用户ID
/// </summary>
public int UserID
{
get
{
return nUserID;
}
set
{
nUserID=value;
}
}
/// <summary>
/// 属性:标题
/// </summary>
public string Title
{
get
{
return cTitle;
}
set
{
cTitle=value;
}
}
/// <summary>
/// 属性:内容
/// </summary>
public string Content
{
get
{
return cContent;
}
set
{
cContent=value;
}
}
/// <summary>
/// 属性:已发送标识
/// </summary>
public bool IsSend
{
get
{
return isSend;
}
set
{
isSend=value;
}
}
/// <summary>
/// 属性:报告日期
/// </summary>
public System.DateTime ReportDate
{
get
{
return dReportDate;
}
set
{
dReportDate=value;
}
}
/// <summary>
/// 属性:附件路径
/// </summary>
public string FilePath
{
get
{
return cFilePath;
}
set
{
cFilePath=value;
}
}
/// <summary>
/// 属性:附件描述
/// </summary>
public string FileDescription
{
get
{
return cFileDescription;
}
set
{
cFileDescription=value;
}
}
/// <summary>
/// 属性:删除标识
/// </summary>
public bool DeleteSign
{
get
{
return deleteSign;
}
set
{
deleteSign=value;
}
}
/// <summary>
/// 获取数据集
/// </summary>
/// <returns>成功或失败</returns>
private void SetData()
{
this.oobjs.GetData();
}
/// <summary>
/// 根据索引字段查询单一的元素，不能与foreach共同使用
/// </summary>
/// <param name="id"></param>
/// <returns>查到/没有查到</returns>
public bool Search(string cId)
{
cId=OI.Modules.String.GenSafeChars(cId);
string sql="SQLBlock";//在此填写你的Sql语句
System.Data.SqlClient.SqlDataReader oDataReader;
try
{
oDataReader=this.RunCommand(sql);
}
catch(System.Data.SqlClient.SqlException e)
{
if(this.Connection.State==System.Data.ConnectionState.Open)
this.Connection.Close();
throw new AppException("执行下列SQL语句出错：\n\r"+sql,e);
}
//设置各属性质
if(oDataReader.Read())
{
//以下代码为类:report的属性变量
if (!oDataReader.IsDBNull(0))
{
nReportID=oDataReader.GetInt32(0);
}
if (!oDataReader.IsDBNull(1))
{
nUserID=oDataReader.GetInt32(1);
}
if (!oDataReader.IsDBNull(2))
{
cTitle=oDataReader.GetString(2);
}
if (!oDataReader.IsDBNull(3))
{
cContent=oDataReader.GetString(3);
}
if (!oDataReader.IsDBNull(4))
{
isSend=oDataReader.GetBoolean(4);
}
if (!oDataReader.IsDBNull(5))
{
dReportDate=oDataReader.GetDateTime(5);
}
if (!oDataReader.IsDBNull(6))
{
cFilePath=oDataReader.GetString(6);
}
if (!oDataReader.IsDBNull(7))
{
cFileDescription=oDataReader.GetString(7);
}
if (!oDataReader.IsDBNull(8))
{
deleteSign=oDataReader.GetBoolean(8);
}
oDataReader.Close();
return true;
}
else
{
oDataReader.Close();
return false;
}
}
private reports oobjs; //构造函数
/// <summary>
/// 从容器类中构造
/// </summary>
/// <param name="toobjs"></param>
public report(reports toobjs)
{
oobjs=toobjs;
}
/// <summary>
/// 单独使用类
/// </summary>
public report(string newConnectionString):base(newConnectionString)
{
}
public report()
{
}
/// <summary>
/// 获取当前的对象
/// </summary>
object IEnumerator.Current
{
get
{
return this;
}
}
/// <summary>
/// 下一个对象
/// </summary>
/// <returns>有或无</returns>
public bool MoveNext()
{
if(oobjs.oDataSet==null)
{
SetData();
if(oobjs.nCurrentRecordNum<0)
oobjs.nCurrentRecordNum=0;
}
if(oobjs.PageSize>0)
{
if(oobjs.nCurrentRecordNum+(oobjs.PageNum-1)*oobjs.PageSize>=oobjs.RecordCount||oobjs.CurrentRecordNum>oobjs.PageSize-1)
{
this.oobjs.CurrentRecordNum=0;
return false;
}
}
else
{
if(oobjs.nCurrentRecordNum>=oobjs.RecordCount)
{
this.oobjs.CurrentRecordNum=0;
return false;
}
}
//以下代码为类:report的属性变量
try
{
nReportID=System.Convert.ToInt32(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][0]);
}
catch(System.Exception ErrorExcept_Property_0)
{
ErrorLog.WriteLog(ErrorExcept_Property_0.Message);
nReportID=0;
}
try
{
nUserID=System.Convert.ToInt32(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][1]);
}
catch(System.Exception ErrorExcept_Property_1)
{
ErrorLog.WriteLog(ErrorExcept_Property_1.Message);
nUserID=0;
}
try
{
cTitle=System.Convert.ToString(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][2]);
}
catch(System.Exception ErrorExcept_Property_2)
{
ErrorLog.WriteLog(ErrorExcept_Property_2.Message);
cTitle="";
}
try
{
cContent=System.Convert.ToString(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][3]);
}
catch(System.Exception ErrorExcept_Property_3)
{
ErrorLog.WriteLog(ErrorExcept_Property_3.Message);
cContent="";
}
try
{
isSend=System.Convert.ToBoolean(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][4]);
}
catch(System.Exception ErrorExcept_Property_4)
{
ErrorLog.WriteLog(ErrorExcept_Property_4.Message);
isSend=false;
}
try
{
dReportDate=System.Convert.ToDateTime(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][5]);
}
catch(System.Exception ErrorExcept_Property_5)
{
ErrorLog.WriteLog(ErrorExcept_Property_5.Message);
dReportDate=System.DateTime.MinValue;
}
try
{
cFilePath=System.Convert.ToString(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][6]);
}
catch(System.Exception ErrorExcept_Property_6)
{
ErrorLog.WriteLog(ErrorExcept_Property_6.Message);
cFilePath="";
}
try
{
cFileDescription=System.Convert.ToString(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][7]);
}
catch(System.Exception ErrorExcept_Property_7)
{
ErrorLog.WriteLog(ErrorExcept_Property_7.Message);
cFileDescription="";
}
try
{
deleteSign=System.Convert.ToBoolean(oobjs.oDataSet.Tables["report"].Rows[oobjs.nCurrentRecordNum][8]);
}
catch(System.Exception ErrorExcept_Property_8)
{
ErrorLog.WriteLog(ErrorExcept_Property_8.Message);
deleteSign=false;
}
oobjs.nCurrentRecordNum++;
return true;
}
/// <summary>
/// 复位
/// </summary>
public void Reset()
{
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -