using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
//using SQLHelper;

namespace SCM
{
    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 SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();

        //构造函数
        public ClsXt_SystemLog()
        {
            MvarItemKey = "Xt_SystemLog";
            MvarReportTitle = "系统日志";
        }
        //删除
        public bool DeleteByID(long sid)
        {
            try
            {
                oWeb.Url = ClsPub1.WEBSURL;
                oWeb.getRunProc("Delete from h_v_Xt_SystemLogList where hid='" + sid + "'",ref DBUtility.ClsPub.sExeReturnInfo);
                return true;
            }
            catch (Exception e)
            {
                return false;
            }
        }

        #region 固定代码 

        //是否存在重复代码
        public bool HavSameNumber(long sItemID,string  sNumber)
        {
            DataSet DS ;
            try
            {
                oWeb.Url = ClsPub1.WEBSURL;
                DS = oWeb.getDataSetBySQL("Select HItemID from Xt_SystemLog Where HItemID<>'" + sItemID + "' and HNumber='" + sNumber + "'", "Xt_SystemLog",ref DBUtility.ClsPub.sExeReturnInfo);
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        
        #endregion
    }
}