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

namespace BaseSet
{
    public class ClsGy_DataInTmp_Material
    {
        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 HItemID;
        public string HNumber;
        public string HHelpCode;
        public string HName;
        public string HShortNumber;
        public bool HEndFlag;
        public bool HStopflag;
        public string HRemark;
        public long HLevel;
        public long HParentID;
        //原代码 用于 替换子项目
        public string HOldNumber;
        //新增
        public bool AddNew()
        {
             
            return true;
           
        }
       
        //修改
        public bool ModifyByID(long sItemID)
        {
            
            return true; 
        }

        /// <summary>
        /// 根据模板名称，列名，返回字段名
        /// </summary>
        /// <param name="sName"></param>
        /// <param name="sColName"></param>
        /// <returns></returns>
        public string GetInfoByName(string sName, int sColName)
        {
            string sFieldName = "";
            DataSet DS;
            try
            {
                DS = oCN.RunProcReturn("Select * from h_v_Gy_DataInTmp_Material Where HName='" + sName.ToString() + "' and HColName='" + sColName.ToString() + "'", "h_v_Gy_DataInTmp_Material");
                if (DS.Tables[0].Rows.Count == 0)
                    return sFieldName;
                else
                {
                    sFieldName = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HFieldName"]);
                    return sFieldName;
                }
            }
            catch (Exception e)
            {
                return sFieldName;
            }
        }

        #region 固定代码
        //是否存在子项目
        public bool HavChildCodes(long sItemID)
        {
            DataSet DS ;
            try
            {
                DS = oCN.RunProcReturn("Select id from Xt_Xtgnb Where sjgnbm='" + sItemID + "'", "Xt_Xtgnb");
                if (DS.Tables[0].Rows.Count==0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //根据代码判断信息
        public bool HavParentCode(string sCode, long sItemID)
        {
            
            return true; 
        }
        //重复代码
        public bool HavSameNumber(long sItemID, string sNumber)
        {
            DataSet DS ;
            try
            {
                DS = oCN.RunProcReturn("Select id from Xt_Xtgnb Where id<>'" + sItemID + "' and gnbm='" + sNumber + "'", "Xt_Xtgnb");
                if (DS.Tables[0].Rows.Count == 0)
                    return false;
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }
        //删除
        public bool DeleteByID(long sItemID,ref string s)
        {
            try
            {
                oCN.RunProc("Delete from Xt_Xtgnb where id='" + sItemID + "'");
                return true;
            }
            catch (Exception e)
            {
                s = e.Message;
                return false;
            }
        }
        //构造函数
        public ClsGy_DataInTmp_Material() 
        {
            MvarItemKey = "Xt_Xtgnb";
            MvarReportTitle = "系统功能表设置";
        }
        #endregion
    }
}