// Add by ZZH on 2008-1-21 添加验证是否可以删除的方法
public DataTable CheckState(String strTenderID)
{
string[] sParams = { "tableName", "tablePK", "tablePKValue", "correlationField", "ifCorrelation", "correlationTable", "correlationTableField", "correlationFieldTable" };
object[] objParamValues = { "ITBDocument", "ITBIDKey", strTenderID, "TenderID", "0", "", "", "" };
SqlDbType[] paramTypes = { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
DataTable dt = BaseDataAccess.ExecuteSPQueryDataTable("sp_ControlState", sParams, objParamValues, paramTypes);
return(dt);
}
public string GetId(string sTableName, string sParentId)
{
string[] sParams = { "tbname", "parentid" };
object[] objParamValues = { sTableName, sParentId };
SqlDbType[] paramTypes = { SqlDbType.NVarChar, SqlDbType.NVarChar };
DataTable dt = BaseDataAccess.ExecuteSPQueryDataTable(
"sp_getTreeId", sParams, objParamValues, paramTypes);
return(dt.Rows[0][0].ToString());
}
