using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
using SQLHelper;
|
|
namespace BLL
|
{
|
class ClsXt_SystemLog
|
{
|
private string _mvarItemKey;
|
|
public string MvarItemKey
|
{
|
get { return _mvarItemKey; }
|
set { _mvarItemKey = value; }
|
}
|
private string _mvarReportTitle;
|
|
public string MvarReportTitle
|
{
|
get { return _mvarReportTitle; }
|
set { _mvarReportTitle = value; }
|
}
|
ClsCN oCN = new ClsCN();
|
public long id;
|
public DateTime GeginDate;
|
public string userid;
|
public string WorkstationName;
|
public string WorkList;
|
public string SystemName;
|
public string NetuserName;
|
public string State;
|
//构造函数
|
public ClsXt_SystemLog()
|
{
|
MvarItemKey = "Xt_SystemLog";
|
MvarReportTitle = "系统日志";
|
}
|
//删除
|
public bool DeleteByID(long sid)
|
{
|
try
|
{
|
oCN.RunProc("Delete from h_v_Xt_SystemLogList where hid='" + sid + "'");
|
return true;
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
|
#region 固定代码
|
|
//是否存在重复代码
|
public bool HavSameNumber(long sItemID,string sNumber)
|
{
|
DataSet DS ;
|
try
|
{
|
DS = oCN.RunProcReturn("Select HItemID from Xt_SystemLog Where HItemID<>'" + sItemID + "' and HNumber='" + sNumber + "'", "Xt_SystemLog");
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
|
#endregion
|
}
|
}
|
