public static MvcHtmlString GetDataGridColumns(this HtmlHelper htmlHelper, string xmlName)
{
XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName);
List <XElement> fieldList = targetXml.Element("ColumnList").Elements("column").ToList();
List <Dictionary <string, object> > columsList = new List <Dictionary <string, object> >();
Dictionary <string, string> form = new Dictionary <string, string>();
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<table id='CommonDialogForm' data-bind='datagrid:gridSetting'>");
sb.AppendFormat("<thead><tr>");
foreach (var item in fieldList)
{
string title = ReadXml.getXmlElementAttr(item, "title");
string field = ReadXml.getXmlElementAttr(item, "field");
string hidden = ReadXml.getXmlElementAttr(item, "hidden");
string align = ReadXml.getXmlElementAttr(item, "align");
string sortable = ReadXml.getXmlElementAttr(item, "sortable");
string width = ReadXml.getXmlElementAttr(item, "width");
string formatter = ReadXml.getXmlElementAttr(item, "formatter");
string checkbox = ReadXml.getXmlElementAttr(item, "checkbox");
string gridFormat = "";
string gridEditor = ReadXml.getXmlElementValue(item, "gridEditor");
if (formatter != "")
{
if (formatter == "gridFormat")
{
gridFormat = ReadXml.getXmlElementValue(item, "gridFormat");
formatter = "";
}
else
{
formatter = string.Format("formatter='{0}'", formatter);
}
}
if (hidden != "")
{
hidden = string.Format("hidden='{0}'", hidden);
}
if (sortable != "")
{
sortable = string.Format("sortable='{0}'", sortable);
}
if (checkbox != "")
{
checkbox = string.Format("checkbox='{0}'", checkbox);
}
if (!string.IsNullOrWhiteSpace(gridEditor))
{
gridEditor = string.Format("editor=\"{0}\"", gridEditor);
}
sb.AppendFormat("<th field='{0}' {1} align='{2}' width='{3}' {4} {6} {7} {8} {9}>{5}</th>", field, sortable, align, width, formatter, title, checkbox, gridFormat, hidden, gridEditor);
}
sb.AppendFormat("</tr></thead></table>");
return(MvcHtmlString.Create(sb.ToString()));
}
public static MvcHtmlString GetSearchToolbar(this HtmlHelper htmlHelper, string xmlName)
{
XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName);
List <XElement> fieldList = targetXml.Element("ColumnList").Elements("column").Where(f => f.Attribute("searchType") != null).ToList();
int coulmnIndex = 1;
StringBuilder sb = new StringBuilder();
sb.AppendFormat("<div class='container_16' style='background-color: #E0ECFF; border-bottom: 1px solid #8DB2E3;'>");
foreach (var item in fieldList)
{
string searchType = item.Attribute("searchType").Value;
string title = item.Attribute("title").Value;
string field = item.Attribute("field").Value;
if (searchType == "text")
{
sb.AppendFormat("<div class='grid_2 lbl'>{0}</div>", title);
sb.AppendFormat("<div class='grid_4 val'><input type='text' data-bind='{0}' class='z-txt'/></div>", "value:form." + field);
}
if (searchType == "select")
{
string type = item.Element("searchBinding").Attribute("type").Value;
if (type == "tree")
{
string tree = item.Element("searchBinding").Value;
sb.AppendFormat("<div class='grid_2 lbl'>{0}</div>", title);
sb.AppendFormat("<div class='grid_4 val'><input type='text' data-bind='{0}' {1} class='z-txt easyui-combotree'/></div>", "combotreeValue:form." + field, tree);
}
else if (type == "single" || type == "dictionary" || type == "fix")
{
string selectJsonData = CommonSearchDialog.GetSelectList(type, item.Element("searchBinding"));
sb.AppendFormat("<div class='grid_2 lbl'>{0}</div>", title);
sb.AppendFormat("<div class='grid_4 val'><input type='text' data-bind='{0}' class='z-txt easyui-combobox'/></div>", "comboboxValue:form." + field + ",datasource:" + selectJsonData);
}
}
if (searchType == "daterange")
{
sb.AppendFormat("<div class='grid_2 lbl'>{0}</div>", title);
sb.AppendFormat("<div class='grid_4 val'><input type='text' data-bind='{0}' class='z-txt easyui-daterange'/></div>", "value:form." + field);
}
if (coulmnIndex % 2 == 0 && coulmnIndex != fieldList.Count)
{
sb.AppendFormat("<div class='clear'></div>");
}
coulmnIndex++;
}
sb.AppendFormat("<div class='grid_4 val' style='float:right;'>");
sb.AppendFormat("<a href='#' plain='true' class='easyui-linkbutton' icon='icon-search' title='查询' data-bind='click:searchClick'>查询</a>");
sb.AppendFormat("<a href='#' plain='true' class='easyui-linkbutton' icon='icon-clear' title='清空' data-bind='click:clearClick'>清空</a>");
sb.AppendFormat("</div>");
sb.AppendFormat("<div class='clear'></div></div>");
return(MvcHtmlString.Create(sb.ToString()));
}
public ActionResult GetCommonDialogData()
{
//获取url中的条件，注意requestData是弹出框中的查询条件，当动态添加的查询条件不在弹出框中时，需要先将requestData中的属性删除
var requestData = new NameValueCollection(Request.QueryString);
//获取删选标识字段名
string PrimaryID = requestData["PrimaryID"];
//去掉弹出框中不需要的查询条件
requestData.Remove("xmlName");
//
var xmlName = Request.QueryString["xmlName"].ToString();
//var selectID = Request.QueryString["selectID"].ToString();
XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName);
var settingsXml = targetXml.Element("settings");
var setting = RequestWrapper.Instance().LoadSettingXmlString(settingsXml.ToString());
if (Request.QueryString["PrimaryID"] != null)
{
requestData.Remove("PrimaryID");
}
if (!string.IsNullOrWhiteSpace(PrimaryID))
{
requestData.Remove(PrimaryID);
}
var query = setting.SetRequestData(requestData).ToParamQuery();
if (!string.IsNullOrWhiteSpace(PrimaryID))
{
string NotInList = Request.QueryString[PrimaryID].ToString();
if (!string.IsNullOrEmpty(NotInList))
{
query.AndWhere(PrimaryID, NotInList, Cp.NotIn);
}
}
var service = setting.GetService();
var data = service.GetDynamicListWithPaging(query);
//if (Request.QueryString["selectID"].ToString() != "")
//{
// if (data.Count() > 0)
// {
// //string sql=string.Format(@"")
// data = data.Where(i => !selectID.Contains(i.ID.toString())).ToList();
// }
//}
var json = JsonConvert.SerializeObject(data);
return(Content(json, "application/json"));
}
public ActionResult GetCommonDialogData1()
{
var requestData = new NameValueCollection(Request.QueryString);
requestData.Remove("xmlName");
var selectID = Request.QueryString["selectID"].ToString();
var xmlName = Request.QueryString["xmlName"].ToString();
XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName);
var settingsXml = targetXml.Element("settings");
var setting = RequestWrapper.Instance().LoadSettingXmlString(settingsXml.ToString());
var query = setting.SetRequestData(requestData).ToParamQuery();
var service = setting.GetService();
var data = service.GetDynamicListWithPaging(query);
var json = JsonConvert.SerializeObject(data);
return(Content(json, "application/json"));
}
public dynamic GetCommonDialogData()
{
//获取url中的条件，注意requestData是弹出框中的查询条件，当动态添加的查询条件不在弹出框中时，需要先将requestData中的属性删除
var requestData = new NameValueCollection(HttpContext.Current.Request.QueryString);
//获取删选标识字段名
string PrimaryID = requestData["PrimaryID"];
//去掉弹出框中不需要的查询条件
requestData.Remove("xmlName");
//
var xmlName = HttpContext.Current.Request.QueryString["xmlName"].ToString();
//var selectID = Request.QueryString["selectID"].ToString();
XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName);
var settingsXml = targetXml.Element("settings");
var setting = RequestWrapper.Instance().LoadSettingXmlString(settingsXml.ToString());
if (HttpContext.Current.Request.QueryString["PrimaryID"] != null)
{
requestData.Remove("PrimaryID");
}
if (!string.IsNullOrWhiteSpace(PrimaryID))
{
requestData.Remove(PrimaryID);
}
var query = setting.SetRequestData(requestData).ToParamQuery();
if (!string.IsNullOrWhiteSpace(PrimaryID))
{
string NotInList = HttpContext.Current.Request.QueryString[PrimaryID].ToString();
if (!string.IsNullOrEmpty(NotInList))
{
query.AndWhere(PrimaryID, NotInList, Cp.NotIn);
}
}
var service = setting.GetService();
var data = service.GetDynamicListWithPaging(query);
return(data);
}
public ActionResult CommonDialog2(string xmlName, string parm)
{
XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName);
List <XElement> fieldList = targetXml.Element("ColumnList").Elements("column").ToList();
Dictionary <string, string> form = new Dictionary <string, string>();
foreach (var item in fieldList)
{
var searchType = item.Attribute("searchType");
string field = ReadXml.getXmlElementAttr(item, "field");
if (searchType != null)
{
var currentValue = "";
if (parm != null)
{
string[] p = parm.Split(':');
if (field == p[0])
{
form.Add(field, p[1]);
}
else
{
form.Add(field, currentValue);
}
}
else
{
form.Add(field, currentValue);
}
}
}
var model = new
{
form = form,
xmlName = xmlName
};
ViewBag.xmlName = xmlName;
return(View(model));
}
public ActionResult CommonDialog3(string xmlName)
{
XElement targetXml = CommonSearchDialog.GetSearchXml(xmlName);
List <XElement> fieldList = targetXml.Element("ColumnList").Elements("column").ToList();
Dictionary <string, string> form = new Dictionary <string, string>();
foreach (var item in fieldList)
{
var searchType = item.Attribute("searchType");
string field = ReadXml.getXmlElementAttr(item, "field");
if (searchType != null)
{
form.Add(field, "");
}
}
var model = new
{
form = form,
xmlName = xmlName
};
ViewBag.xmlName = xmlName;
return(View(model));
}
