//Alt + 1 View Data by No
public void GetViewDataByNo(Window frmParent)
{
PromptForm._frmParent = frmParent;
string tableName = "";
MessageBoxResult result = PromptForm.ShowCombobox("ViewDataByNo", "Table Name", ref tableName);
if (result == MessageBoxResult.Cancel)
{
return;
}
string colName = "";
result = PromptForm.ShowText("ViewDataByNo", "Column Name", ref colName);
if (result == MessageBoxResult.Cancel)
{
return;
}
if (string.IsNullOrEmpty(colName))
{
colName = "*";
}
string strWhere = string.Empty;
if (SQLDBUtil.ColumnIsExistInTable(tableName, "AAStatus"))
{
strWhere = "AAStatus = 'Alive'";
}
string strQuery = SQLDBUtil.GenerateQuery(tableName, strWhere, colName);
//DataTable dtData = SQLDBUtil.GetDataByTable(tableName, strWhere, colName);
//if (dtData == null) return;
//dtData.TableName = tableName;
ShowResultData(frmParent, null, strQuery);
}