// 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)); }