// GET: Form
public ActionResult AURender(string tableName = "", string formTitle = "", string targetArea = "")
{
FormInfo formInfo = new FormInfo(formTitle, "/" + targetArea + "/" + tableName.Replace("tbl", "") + "/AddUpdate");
object[] parms = new object[] { "@tableName", tableName.Trim() };
DataTable table = new SqlFieldAddUpdateAutoDao().GetDataTable(parms, "cofTableRenderAuto_GetAllColumn");
if (table != null && table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
if (row["FieldType"] != null)
{
if (row["FieldType"].ToString() != "")
{
int fieldType = Convert.ToInt32(row["FieldType"]);
FormControl control = new FormControl(fieldType, row["COLUMN_NAME"].ToString(), row["COLUMN_NAME"].ToString(), "", row["DisplayName"].ToString(), row["PlaceHolder"].ToString(), row["Note"].ToString());
if (row["DataSource"] != null)
{
control.DataSource = row["DataSource"].ToString();
}
formInfo.Controls.Add(control);
}
}
}
}
return(View(formInfo));
}
public ActionResult GetAllColumnInTable(string tableName = "")
{
object[] parms = new object[] { "@tableName", tableName.Trim() };
DataTable table = new SqlFieldAddUpdateAutoDao().GetDataTable(parms, "cofTableRenderAuto_GetAllColumn");
ViewBag.DenyFields = Mapper.SplitString(StaticConst.AddUpdateDenyFields);
ViewBag.TableName = tableName;
return(View(table));
}
