public ActionResult GetIndexData()
{
string strTableName = Request.Form["tablename"];
if (!string.IsNullOrEmpty(strTableName))
{
SysSetFormService service = new SysSetFormService();
List <SysSetForm> list = service.GetAll().Where(m => m.TableName == strTableName).ToList();
if (list != null && list.Count > 0)
{
SysSetForm model = list[0];
//获取数据
string strColumns = GetColumnNames(model.Columns);
string strDatas = service.SelectData(strTableName, strColumns);
return(Json(new { result = "success", functionname = model.FuntionName, querycriteria = model.QueryCriteria, columns = model.Columns, datas = strDatas }));
}
else
{
return(Json(new { result = "fail", msg = "没有相应的表单设置！" }));
}
}
else
{
return(Json(new { result = "fail", msg = "参数传递错误！" }));
}
}
public ActionResult GetCreateData()
{
string strTableName = Request.Form["tablename"];
if (!string.IsNullOrEmpty(strTableName))
{
SysSetFormService service = new SysSetFormService();
List <SysSetForm> list = service.GetAll().Where(m => m.TableName == strTableName).ToList();
if (list != null && list.Count > 0)
{
SysSetForm model = list[0];
return(Json(new { result = "success", functionname = model.FuntionName, columns = model.Columns }));
}
else
{
return(Json(new { result = "fail", msg = "没有相应的表单设置！" }));
}
}
else
{
return(Json(new { result = "fail", msg = "参数传递错误！" }));
}
}
public ActionResult Publish(Guid id)
{
SysSetFormService service = new SysSetFormService();
var model = service.Get(id);
model.Status = Cupcake.Core.Domain.PublishStatus.Published;
int intRv = service.Modify(model);
if (intRv > 0)
{
MenuService mservice = new MenuService();
Cupcake.Core.Domain.Menu menu = new Cupcake.Core.Domain.Menu();
menu.Name = model.FuntionName;
menu.Sort = 9;
menu.Href = "/ShowForm?t=" + model.TableName;
menu.ParentId = mservice.GetRootId();//new Guid("210D56FF-8EB0-E611-A9D4-00247EDEF854");
menu.CreateDate = DateTime.Now;
menu.UpdateDate = DateTime.Now;
menu.IsDelete = false;
mservice.Add(menu);
}
return(Json(new { result = "success", msg = "发布成功！" }));
}
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 = "没有输入列信息！" }));
}
}
public ActionResult Delete(Guid id)
{
SysSetFormService service = new SysSetFormService();
var model = service.Get(id);
service.Remove(model);
return(Json(new AjaxResult()
{
Result = Cupcake.Core.Domain.Result.Success, Message = ""
}));
}
//
// GET: /SetForm/
public ActionResult Index(SysSetFormCondition condition)
{
SysSetFormService service = new SysSetFormService();
Paging paging = new Paging(condition);
var list = service.GetListByCondition(condition, ref paging);
SysSetFormListModel model = new SysSetFormListModel(list);
model.Paging = paging;
ViewBag.condtion = condition;
return(View(model));
}
//
// GET: /ShowForm/
public ActionResult Index()
{
string tablename = Request.QueryString["t"];
if (!string.IsNullOrEmpty(tablename))
{
SysSetFormService service = new SysSetFormService();
SysSetForm model = service.GetAll().Where(m => m.TableName == tablename).ToList().FirstOrDefault();
if (model != null)
{
ViewBag.funtionname = model.FuntionName;
}
}
ViewBag.tablename = tablename;
return(View());
}
public ActionResult CreateCommit()
{
string strTableName = Request.Form["tablename"];
string strData = Request.Form["data"];
string[] arr = strData.Split(',');
SysSetFormService service = new SysSetFormService();
ReturnValue rv = service.InsertData(strTableName, arr);
if (rv.IsSuccess)
{
return(Json(new { result = "success", msg = "新增成功！" }));
}
else
{
return(Json(new { result = "fail", msg = rv.Message }));
}
}
public ActionResult NoPublish(Guid id)
{
SysSetFormService service = new SysSetFormService();
var model = service.Get(id);
model.Status = Cupcake.Core.Domain.PublishStatus.NotPublished;
int intRv = service.Modify(model);
if (intRv > 0)
{
MenuService mservice = new MenuService();
Cupcake.Core.Domain.Menu menu = mservice.GetAll().Where(m => (m.Href != null && m.Href.Contains(model.TableName))).ToList().FirstOrDefault();
mservice.Remove(menu);
}
return(Json(new { result = "success", msg = "撤回发布成功！" }));
}
public ActionResult Delete()
{
string strTableName = Request.QueryString["tablename"];
string strId = Request.QueryString["id"];
SysSetFormService service = new SysSetFormService();
ReturnValue rv = service.Delete(strTableName, strId);
if (rv.IsSuccess)
{
return(Json(new AjaxResult()
{
Result = Result.Success
}));
}
else
{
return(Json(new AjaxResult()
{
Result = Result.Error, Message = rv.Message
}));
}
}
