//public clsAPIResponse drp_old(clsCmd cmd)
//{
// var _adapter = _appService.getAdapter();
// string sDisplayField = this.displayFields[0];
// string sIDField = this.primaryKeyFields[0];
// string q = string.Format("select {0},{1} from {2}", sDisplayField, sIDField, this.name);
// DataTable t = _adapter.getData(q);
// return clsAPIResponse.ok(t);
//}
public clsAPIResponse validation_delete(clsCmd cmd)
{
NTier.adapter.clsDataAdapterBase _adapter = _appService.getAdapter();
if (this.Relations == null)
{
return(clsAPIResponse.ok());
}
foreach (clsTableRelation relation in this.Relations)
{
var cmd2 = new clsCmd();
StringBuilder sbSQL = new StringBuilder();
sbSQL.AppendFormat("select count(*) from {0}", relation.table);
for (int iField = 0; iField < this.primaryKeyFields.Count; iField++)
{
cmd2.setValue(relation.cols[iField], cmd.getStringValue(this.primaryKeyFields[iField]));
}
cmd2.SQL = NTier.sqlbuilder.sqlUtility.joinWhereCondition(sbSQL.ToString(), cmd2);
long iCount = Convert.ToInt64(_adapter.execScalar(cmd2));
if (iCount > 0)
{
return(clsAPIResponse.get("This record can't be deleted, this record has reference in table [" + relation.table_title + "]"));
}
}
return(clsAPIResponse.ok());
}
public clsGetDataView(NTier.adapter.clsDataAdapterBase adapter)
{
_adapter = adapter;
}
