public bool UpdateRuleState(string ruleInstanceID, int errorCount, enumRuleState ruleState, string arcgisRule)
{
object[] objArgs = { errorCount, (int)ruleState, ruleInstanceID, arcgisRule };
string strSQL = string.Format("Update LR_ResultEntryRule set ArcGiSRule='{3}', ErrorCount={0} ,RuleExeState={1} where RuleInstID='{2}'", objArgs);
return(Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(this.m_ResultConnection, strSQL));
}
public bool UpdateRuleState(string ruleInstanceID, int errorCount, enumRuleState ruleState, string arcgisRule)
{
object[] objArgs = { errorCount, (int)ruleState, ruleInstanceID, arcgisRule };
string strSQL = string.Format("Update LR_ResultEntryRule set ArcGiSRule='{3}', ErrorCount={0} ,RuleExeState={1} where RuleInstID='{2}'", objArgs);
return Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(this.m_ResultConnection, strSQL);
}
public bool UpdateRuleState(string ruleInstanceID, int errorCount, enumRuleState ruleState)
{
string strSQL = string.Format("Update LR_ResultEntryRule set ErrorCount={0} ,RuleExeState={1} where RuleInstID='{2}'", errorCount, (int)ruleState, ruleInstanceID);
return Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(this.m_ResultConnection,strSQL);
}
//public bool ClearResultRuleList(IDbConnection resultConnection)
//{
// return Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(resultConnection, "delete from LR_ResultEntryRule");
//}
public bool AddVerifiedRule(SchemaRule schemaRule,enumErrorType errType, enumRuleState defaultState)
{
string strObject = null;
StringBuilder strBuilder = new StringBuilder("insert into LR_ResultEntryRule(CheckType,RuleInstID,TempInstID,ErrorCount,RuleExeState,TargetFeatClass1,TargetFeatClass2,GZBM,ErrorType) Values ('");
strObject = schemaRule.ChkTypeName;
if (strObject == null) strObject = "";
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("','");
strObject = schemaRule.arrayRuleParas[0].strInstID;
if (strObject == null) strObject = "";
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("','");
strObject = schemaRule.TempInstID;
if (strObject == null) strObject = "";
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("',");
strBuilder.Append(0); strBuilder.Append(",");
strBuilder.Append((int)defaultState); strBuilder.Append(",'");
strObject = schemaRule.FeaClassName;
if (strObject == null) strObject = "";
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("','");
strBuilder.Append("','");
strObject = schemaRule.arrayRuleParas[0].strGZBM;
if (strObject == null) strObject = "";
strBuilder.Append(strObject.Replace("'", "''"));strBuilder.Append("',");
strBuilder.Append((int)errType);
strBuilder.Append(")");
return Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(this.m_ResultConnection, strBuilder.ToString());
}
public bool UpdateRuleState(string ruleInstanceID, int errorCount, enumRuleState ruleState)
{
string strSQL = string.Format("Update LR_ResultEntryRule set ErrorCount={0} ,RuleExeState={1} where RuleInstID='{2}'", errorCount, (int)ruleState, ruleInstanceID);
return(Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(this.m_ResultConnection, strSQL));
}
//public bool ClearResultRuleList(IDbConnection resultConnection)
//{
// return Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(resultConnection, "delete from LR_ResultEntryRule");
//}
public bool AddVerifiedRule(SchemaRule schemaRule, enumErrorType errType, enumRuleState defaultState)
{
string strObject = null;
StringBuilder strBuilder = new StringBuilder("insert into LR_ResultEntryRule(CheckType,RuleInstID,TempInstID,ErrorCount,RuleExeState,TargetFeatClass1,TargetFeatClass2,GZBM,ErrorType) Values ('");
strObject = schemaRule.ChkTypeName;
if (strObject == null)
{
strObject = "";
}
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("','");
strObject = schemaRule.arrayRuleParas[0].strInstID;
if (strObject == null)
{
strObject = "";
}
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("','");
strObject = schemaRule.TempInstID;
if (strObject == null)
{
strObject = "";
}
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("',");
strBuilder.Append(0); strBuilder.Append(",");
strBuilder.Append((int)defaultState); strBuilder.Append(",'");
strObject = schemaRule.FeaClassName;
if (strObject == null)
{
strObject = "";
}
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("','");
strBuilder.Append("','");
strObject = schemaRule.arrayRuleParas[0].strGZBM;
if (strObject == null)
{
strObject = "";
}
strBuilder.Append(strObject.Replace("'", "''")); strBuilder.Append("',");
strBuilder.Append((int)errType);
strBuilder.Append(")");
return(Hy.Common.Utility.Data.AdoDbHelper.ExecuteSql(this.m_ResultConnection, strBuilder.ToString()));
}
