using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DBUtility
|
{
|
public class ClsGy_Base_Ctl
|
{
|
public string MvarItemKey;
|
public string MvarReportTitle;
|
public Pub_Class.ClsSqlHelper oCn = new Pub_Class.ClsSqlHelper();
|
//新增
|
public virtual bool AddNew()
|
{
|
return true;
|
}
|
|
//修改
|
public virtual bool ModifyByID(Int64 sItemID)
|
{
|
return true;
|
}
|
|
#region 固定代码
|
//是否存在子项目
|
public bool HavChildCodes(Int64 sItemID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select HItemID from " + MvarItemKey + " Where HParentID='" + sItemID + "'", MvarItemKey , ref Pub_Class.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
//根据代码判断信息
|
public virtual bool HavParentCode(string sCode, Int64 sItemID)
|
{
|
return true;
|
}
|
//重复代码
|
public bool HavSameNumber(Int64 sItemID, string sNumber)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select HItemID from " + MvarItemKey + " Where HItemID<>" + sItemID + " and HNumber='" + sNumber + "'", MvarItemKey, ref Pub_Class.ClsPub.sExeReturnInfo);
|
if (DS.Tables[0].Rows.Count == 0)
|
return false;
|
else
|
{
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//审核
|
public bool AuditByID(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
string HCheckEmp = ClsPub.CurUserName;
|
oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '" + HCheckEmp + "',HCheckDate=getdate() where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//反审核
|
public bool DeAuditByID(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '', HCheckDate=null where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//禁用
|
public bool StopByID(Int64 sItemID)
|
{
|
try
|
{
|
oCn.RunProc("Update " + MvarItemKey + " set HStopflag=1 where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//反禁用
|
public bool UnStopByID(Int64 sItemID)
|
{
|
try
|
{
|
oCn.RunProc("Update " + MvarItemKey + " set HStopflag=0 where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
//关闭
|
public bool CloseByID(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
string HCloseEmp = ClsPub.CurUserName;
|
oCn.RunProc("Update " + MvarItemKey + " set HCloseEmp = '" + HCloseEmp + "',HCloseDate=getdate() where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//反关闭
|
public bool DeCloseByID(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
oCn.RunProc("Update " + MvarItemKey + " set HCloseEmp = '', HCloseDate=null where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//审核2 HCheckTime
|
public bool AuditByID2(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
string HCheckEmp = ClsPub.CurUserName;
|
oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '" + HCheckEmp + "',HCheckTime=getdate() where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//反审核2 HCheckTime
|
public bool DeAuditByID2(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
oCn.RunProc("Update " + MvarItemKey + " set HCheckEmp = '', HCheckTime=null where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//关闭2 HCloseTime
|
public bool CloseByID2(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
string HCloseEmp = ClsPub.CurUserName;
|
oCn.RunProc("Update " + MvarItemKey + " set HCloseEmp = '" + HCloseEmp + "',HCloseTime=getdate() where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//反关闭2 HCloseTime
|
public bool DeCloseByID2(Int64 sItemID, ref string sReturn)
|
{
|
try
|
{
|
oCn.RunProc("Update " + MvarItemKey + " set HCloseEmp = '', HCloseTime=null where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
sReturn = "";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//删除
|
public bool DeleteByID(Int64 sItemID)
|
{
|
try
|
{
|
oCn.RunProc("Delete from " + MvarItemKey + " where HItemID='" + sItemID + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
|
|
//删除
|
public bool DeleteByNumber(string sNumber)
|
{
|
try
|
{
|
oCn.RunProc("Delete from " + MvarItemKey + " where HNumber='" + sNumber + "'", ref Pub_Class.ClsPub.sExeReturnInfo);
|
return true;
|
}
|
catch (Exception e)
|
{
|
throw (e);
|
}
|
}
|
#endregion
|
}
|
}
|
