public ActionResult QuerySet() { string strTableName = Request.Form["tablename"]; string strItems = Request.Form["items"]; if (!string.IsNullOrEmpty(strTableName) && !string.IsNullOrEmpty(strItems)) { SysSetFormService service = new SysSetFormService(); Cupcake.Core.Domain.SysSetForm data = service.GetAll().Where(m => m.TableName == strTableName).ToList().FirstOrDefault(); if (data != null) { data.QueryCriteria = strItems; int rv = service.Modify(data); if (rv > 0) { return(Json(new { result = "success" })); } else { return(Json(new { result = "fail", msg = "设置失败!" })); } } else { return(Json(new { result = "fail", msg = "设置失败!" })); } } else { return(Json(new { result = "fail", msg = "没有选择查询条件!" })); } }
public ActionResult InputSet() { string strTableName = Request.Form["tablename"]; string strFunctionName = Request.Form["functionname"]; string strItems = Request.Form["items"]; if (!string.IsNullOrEmpty(strTableName) && !string.IsNullOrEmpty(strFunctionName) && !string.IsNullOrEmpty(strItems)) { var Serializer = new JavaScriptSerializer(); var collist = Serializer.Deserialize <List <InputSetModel> >(strItems); if (collist != null && collist.Count > 0) { SysSetFormService service = new SysSetFormService(); Cupcake.Core.Domain.SysSetForm data = new Cupcake.Core.Domain.SysSetForm(); data.TableName = strTableName; data.FuntionName = strFunctionName; data.Columns = strItems; data.Status = Cupcake.Core.Domain.PublishStatus.NotPublished; //for (int j = 0; j < collist.Count; j++) //{ // Reloadsoft.Framework.Model.ColumnModel column = new Model.ColumnModel(); // column.ColumnName = collist[j].ColumnName; // column.ColumnType = (Model.ColumnType)collist[j].ColumnType; // column.ColumnLength = collist[j].ColumnLength; // column.PrimaryKey = collist[j].PrimaryKey; // column.IsNull = collist[j].IsNull; // data.ColumnModels.Add(column); //} int rv = service.Add(data); if (rv > 0) { return(Json(new { result = "success" })); } else { return(Json(new { result = "fail", msg = "设置失败!" })); } } else { return(Json(new { result = "fail", msg = "没有输入列信息!" })); } } else { return(Json(new { result = "fail", msg = "没有输入列信息!" })); } }