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
|
}
|
}
|
