public JsonResult UpdateDropDown(UpdateDropDownModel model, FormCollection form) { DataTable @default = Helper.getData(string.Format("select top 1 COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='{0}' and DATA_TYPE='nvarchar'", model.Table), db); if (@default.Rows.Count == 0) { @default = Helper.getData(string.Format("select COLUMN_NAME,DATA_TYPE from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='{0}' and COLUMN_NAME='name'", model.Table), db); } string orderRichBy = ""; if (@default.Rows.Count > 0) { orderRichBy = " order by " + @default.Rows[0][0].ToString(); } DataTable data = Helper.getData(string.Format("SELECT {0} as value, {1} as text {4} from {2} {3} {6} {5}", model.Value, model.Text, model.Table, model.Where , !string.IsNullOrEmpty(model.Groupby) ? " ," + model.Groupby + " as groupby " : "", !string.IsNullOrEmpty(model.Groupby) ? " order by " + model.Groupby : "", string.IsNullOrEmpty(model.Groupby) ? orderRichBy : ""), db); List <DropDownListJson> json = new List <DropDownListJson>(); if (!string.IsNullOrEmpty(model.OptionLabel)) { json.Add(new DropDownListJson() { Value = "0", Text = (model.OptionLabel) }); } foreach (DataRow item in data.Rows) { bool selected = false; if (model.Selected != null) { selected = model.Selected.Contains(item["value"].ToString()); } if (!string.IsNullOrEmpty(model.Groupby)) { json.Add(new DropDownListJson() { Value = item["value"].ToString(), Text = item["text"].ToString(), Group = item["groupby"].ToString(), Selected = selected }); } else { json.Add(new DropDownListJson() { Value = item["value"].ToString(), Text = item["text"].ToString(), Selected = selected }); } } return(Json(json, JsonRequestBehavior.AllowGet)); }
public string UpdateRadioButton(UpdateDropDownModel model, FormCollection form) { DataTable data = Helper.getData(string.Format("SELECT {0} as value, {1} as text from {2} {3}", model.Value, model.Text, model.Table, model.Where), db); int col = 12 / (model.Col > 4 ? 4 : model.Col); StringBuilder html = new StringBuilder(); int index = 1; bool wasClose = true; foreach (DataRow item in data.Rows) { if (index == 1 && wasClose) { html.AppendFormat(" <div class=\"col col-{0}\">", col); wasClose = false; } bool toggle = (!string.IsNullOrEmpty(model.ToggleOff) && !string.IsNullOrEmpty(model.ToggleON)); html.AppendFormat("<label class=\"{0}\">", toggle ? "toggle" : model.Type); bool selected = model.Selected.Contains(item["value"].ToString()); html.AppendFormat("<input type=\"{3}\" {0} name=\"{1}\" value=\"{2}\" >", selected ? "checked=\"checked\"" : "", model.Name, item["value"].ToString(), model.Type); if (!string.IsNullOrEmpty(model.ToggleOff) && !string.IsNullOrEmpty(model.ToggleON)) { html.AppendFormat("<i data-swchoff-text=\"{0}\" data-swchon-text=\"{1}\"></i>", (model.ToggleOff), (model.ToggleON)); } else { html.AppendFormat("<i></i>"); } html.AppendFormat("{0}</label>", item["text"]); if (index % model.Row == 0) { html.AppendFormat("</div>"); wasClose = true; } } return(html.ToString()); }