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 = "没有输入列信息！" }));
}
}
