/// <summary>
/// Process
/// throws Exception
/// </summary>
/// <returns>info</returns>
override protected string DoIt()
{
//IDbTransaction trx = ExecuteQuery.GerServerTransaction();
MTab tab = new MTab(GetCtx(), p_AD_Tab_ID, Get_Trx());
//MTab tab = new MTab(GetCtx(), p_AD_Tab_ID, trx.ToString());
if (p_AD_Tab_ID == 0 || tab == null || tab.Get_ID() == 0)
{
throw new Exception("@NotFound@: @AD_Tab_ID@ " + p_AD_Tab_ID);
}
//log.info(tab.toString());
int count = 0;
string sql = "SELECT * FROM AD_Column c "
+ "WHERE NOT EXISTS (SELECT * FROM AD_Field f "
+ "WHERE c.AD_Column_ID=f.AD_Column_ID"
+ " AND c.AD_Table_ID=@AD_Table_Id" // #1
+ " AND f.AD_Tab_ID=@AD_Tab_Id)" // #2
+ " AND AD_Table_ID=@AD_Table_Id1" // #3
+ " AND NOT (Name LIKE 'Created%' OR Name LIKE 'Updated%')"
+ " AND IsActive='Y' "
+ "ORDER BY Name desc";
try
{
SqlParameter[] param = new SqlParameter[3];
param[0] = new SqlParameter("@AD_Table_Id", tab.GetAD_Table_ID());
param[1] = new SqlParameter("@AD_Tab_Id", tab.GetAD_Tab_ID());
param[2] = new SqlParameter("@AD_Table_Id1", tab.GetAD_Table_ID());
DataSet ds = DataBase.DB.ExecuteDataset(sql, param, Get_Trx());
//DataSet ds1 = ExecuteQuery.ExecuteDataset(sql);
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
//MColumn column = new MColumn (getCtx(),dr, Get_Trx());
//MColumn column = new MColumn(GetCtx(), dr, null);
MColumn column = new MColumn(GetCtx(), dr, Get_Trx());
//
MField field = new MField(tab);
field.SetColumn(column);
if (column.IsKey())
{
field.SetIsDisplayed(false);
}
if (column.GetColumnName().ToString() == "AD_Client_ID")
{
field.SetSeqNo(10);
}
if (column.GetColumnName().ToString() == "AD_Org_ID")
{
field.SetIsSameLine(true);
field.SetSeqNo(20);
}
//Export_ID Check [Hide Export Field]
if (column.GetColumnName().ToString() == "Export_ID")
{
field.SetIsDisplayed(false);
}
if (field.Save())
{
AddLog(0, DateTime.MinValue, Decimal.Parse(count.ToString()), column.GetName());
//AddLog(0, DateTime.MinValue, null, );
count++;
}
}
ds = null;
}
catch (Exception e)
{
log.Log(Level.SEVERE, sql, e);
}
return("@Created@ #" + count);
}