/// <summary>
/// 新增字段
/// </summary>
/// <returns></returns>
public ActionResult AddFields()
{
try
{
UserEntity uInfo = ViewData["Account"] as UserEntity;
FieldsEntity entityAdd = new FieldsEntity();
entityAdd.TabId = int.Parse(Request["TabId"]);
entityAdd.FieldName = Request["FieldName"].Trim();
entityAdd.FieldViewName = Request["FieldViewName"].Trim();
entityAdd.FieldDataTypeId = int.Parse(Request["FieldDataTypeId"]);
entityAdd.IsActive = bool.Parse(Request["IsActive"]);
entityAdd.IsSearch = bool.Parse(Request["IsSearch"]);
entityAdd.CreateBy = uInfo.AccountName;
entityAdd.CreateTime = DateTime.Now;
entityAdd.UpdateBy = uInfo.AccountName;
entityAdd.UpdateTime = DateTime.Now;
entityAdd.Sort = int.Parse(Request["Sort"]);
bool ExistsFieldName = new FieldsBLL().ExistsFieldName(entityAdd.FieldName, entityAdd.TabId);
bool ExistsFieldViewName = new FieldsBLL().ExistsFieldViewName(entityAdd.FieldViewName, entityAdd.TabId);
if (ExistsFieldName)
{
return(Content("{\"msg\":\"添加失败,字段名已存在！\",\"success\":false}"));
}
else if (ExistsFieldViewName)
{
return(Content("{\"msg\":\"添加失败,字段显示名已存在！\",\"success\":false}"));
}
else
{
int entityId = new FieldsBLL().Add(entityAdd);
if (entityId > 0)
{
//新增数据库表字段 获取表信息
TableEntity tabEntity = new TableBLL().GetModel(entityAdd.TabId);
DataTypeEntity dataTypeEntity = new DataTypeBLL().GetModel(entityAdd.FieldDataTypeId);
string dbTabName = "tb_" + tabEntity.TabName;
if (Comm.AddTabField(dbTabName, entityAdd.FieldName, dataTypeEntity.DataType))
{
return(Content("{\"msg\":\"添加成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"添加失败！\",\"success\":false}"));
}
}
else
{
return(Content("{\"msg\":\"添加失败！\",\"success\":false}"));
}
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"添加失败," + ex.Message + "\",\"success\":false}"));
}
}
/// <summary>
/// 编辑字段
/// </summary>
/// <returns></returns>
public ActionResult EditFields()
{
try
{
UserEntity uInfo = ViewData["Account"] as UserEntity;
int id = Convert.ToInt32(Request["id"]);
string originalName = Request["originalName"];
string originalViewName = Request["originalViewName"];
FieldsEntity entityEdit = new FieldsBLL().GetModel(id);
entityEdit.FieldName = Request["FieldName"].Trim();
entityEdit.FieldViewName = Request["FieldViewName"].Trim();
entityEdit.FieldDataTypeId = int.Parse(Request["FieldDataTypeId"]);
entityEdit.IsActive = bool.Parse(Request["IsActive"]);
entityEdit.IsSearch = bool.Parse(Request["IsSearch"]);
entityEdit.Sort = int.Parse(Request["Sort"]);
entityEdit.UpdateBy = uInfo.AccountName;
entityEdit.UpdateTime = DateTime.Now;
bool ExistsFieldViewName = new FieldsBLL().ExistsFieldViewName(entityEdit.FieldViewName, entityEdit.TabId);
if (entityEdit.FieldViewName != originalViewName && ExistsFieldViewName)
{
return(Content("{\"msg\":\"修改失败,字段显示名已存在！\",\"success\":false}"));
}
else
{
int result = new FieldsBLL().Update(entityEdit);
if (result > 0)
{
//新增数据库表字段 获取表信息
TableEntity tabEntity = new TableBLL().GetModel(entityEdit.TabId);
DataTypeEntity dataTypeEntity = new DataTypeBLL().GetModel(entityEdit.FieldDataTypeId);
string dbTabName = "tb_" + tabEntity.TabName;
if (Comm.UpdateTabField(dbTabName, entityEdit.FieldName, dataTypeEntity.DataType))
{
return(Content("{\"msg\":\"修改成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"修改失败！\",\"success\":false}"));
}
}
else
{
return(Content("{\"msg\":\"修改失败！\",\"success\":false}"));
}
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"修改失败," + ex.Message + "\",\"success\":false}"));
}
}
public ActionResult GetAllDataTypeInfo()
{
string strWhere = "1=1";
string sort = Request["sort"] == null ? "id" : Request["sort"];
string order = Request["order"] == null ? "asc" : Request["order"];
if (!string.IsNullOrEmpty(Request["DataTypeName"]) && !SqlInjection.GetString(Request["DataTypeName"]))
{
strWhere += " and DataTypeName like '%" + Request["DataTypeName"] + "%'";
}
//首先获取前台传递过来的参数
int pageindex = Request["page"] == null ? 1 : Convert.ToInt32(Request["page"]);
int pagesize = Request["rows"] == null ? 10 : Convert.ToInt32(Request["rows"]);
int totalCount = 0; //输出参数
string strJson = new DataTypeBLL().GetPager("tbDataType", "Id,DataType,DataTypeName,Sort,CreateTime,CreateBy,UpdateTime,UpdateBy", sort + " " + order, pagesize, pageindex, strWhere, out totalCount);
return(Content("{\"total\": " + totalCount.ToString() + ",\"rows\":" + strJson + "}"));
}
/// <summary>
/// 编辑
/// </summary>
/// <returns></returns>
public ActionResult EditDataType()
{
try
{
UserEntity uInfo = ViewData["Account"] as UserEntity;
int id = Convert.ToInt32(Request["id"]);
string originalName = Request["originalName"];
DataTypeEntity typeEdit = new DataTypeBLL().GetModel(id);
typeEdit.DataType = Request["DataType"];
typeEdit.DataTypeName = Request["DataTypeName"];
typeEdit.Sort = int.Parse(Request["Sort"] == null ? "0" : Request["Sort"]);
typeEdit.UpdateBy = uInfo.AccountName;
typeEdit.UpdateTime = DateTime.Now;
bool exists = new DataTypeBLL().Exists(typeEdit.DataTypeName);
if (typeEdit.DataTypeName != originalName && exists)
{
return(Content("{\"msg\":\"修改失败,类型名称已存在！\",\"success\":false}"));
}
else
{
int result = new DataTypeBLL().Update(typeEdit);
if (result > 0)
{
return(Content("{\"msg\":\"修改成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"修改失败！\",\"success\":false}"));
}
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"修改失败," + ex.Message + "\",\"success\":false}"));
}
}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public ActionResult AddDataType()
{
try
{
UserEntity uInfo = ViewData["Account"] as UserEntity;
DataTypeEntity typeAdd = new DataTypeEntity();
typeAdd.DataType = Request["DataType"];
typeAdd.DataTypeName = Request["DataTypeName"];
typeAdd.Sort = int.Parse(Request["Sort"] == null ? "0" : Request["Sort"]);
typeAdd.CreateBy = uInfo.AccountName;
typeAdd.CreateTime = DateTime.Now;
typeAdd.UpdateBy = uInfo.AccountName;
typeAdd.UpdateTime = DateTime.Now;
bool exists = new DataTypeBLL().Exists(typeAdd.DataTypeName);
if (exists)
{
return(Content("{\"msg\":\"添加失败,类型名称已存在！\",\"success\":false}"));
}
else
{
int typeId = new DataTypeBLL().Add(typeAdd);
if (typeId > 0)
{
return(Content("{\"msg\":\"添加成功！\",\"success\":true}"));
}
else
{
return(Content("{\"msg\":\"添加失败！\",\"success\":false}"));
}
}
}
catch (Exception ex)
{
return(Content("{\"msg\":\"添加失败," + ex.Message + "\",\"success\":false}"));
}
}
public ActionResult GetAllDataTypeDrop()
{
string roleJson = new DataTypeBLL().GetAllDataTypeInfo("1=1");
return(Content(roleJson));
}
