/// <summary> /// 人员管理 /// </summary> /// <returns></returns> public ActionResult SystemUserEdit(SystemUser model) { AjaxReturnData result = new AjaxReturnData(); int EditCount = 0; if (model.ObjectId == "" || model.ObjectId == null) { //新增 model.ObjectId = Guid.NewGuid().ToString(); EditCount = _systemUser.Insert <SystemUser>(model); } else { Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("ObjectId", model.ObjectId); //修改 EditCount = _systemUser.UpdateTable <SystemUser>(model, param); } if (EditCount > 0) { result.States = true; result.Message = "成功."; } else { result.States = false; result.Message = "失败."; } return(AjaxJson(result)); }
/// <summary> /// 编辑数据字典 /// </summary> /// <returns></returns> public ActionResult EditDataDictionary(S_DataDictionary model) { AjaxReturnData result = new AjaxReturnData(); int EditCount = 0; if (model.TaskID == "" || model.TaskID == null) { //新增 model.TaskID = Guid.NewGuid().ToString(); EditCount = _dataDictionaryService.Insert <S_DataDictionary>(model, ConfigurationManager.AppSettings["SqlConnectionKey_OADB"]); } else { Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("TaskID", model.TaskID); //修改 EditCount = _dataDictionaryService.UpdateTable <S_DataDictionary>(model, param, ConfigurationManager.AppSettings["SqlConnectionKey_OADB"]); } if (EditCount > 0) { result.States = true; result.Message = "成功."; } else { result.States = false; result.Message = "失败."; } return(AjaxJson(result)); }
/// <summary> /// 添加权限 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult EditAuthority(Authority model) { AjaxReturnData result = new AjaxReturnData(); int EditCount = 0; if (string.IsNullOrEmpty(model.ObjectId)) { //新增 model.ObjectId = Guid.NewGuid().ToString(); EditCount = _authority.Insert <Authority>(model); } else { Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("ObjectId", model.ObjectId); //修改 EditCount = _authority.UpdateTable <Authority>(model, param); } if (EditCount < 0) { result.States = false; } return(AjaxJson(result)); }
/// <summary> /// 编辑流程模板配置 /// </summary> /// <param name="Action"></param> /// <param name="ObjectID"></param> /// <param name="ProcessParentId"></param> /// <param name="ProcessName"></param> /// <param name="ProcessCode"></param> /// <returns></returns> public ActionResult EditWorkflowTemplate(int Action, string ObjectID, string ProcessParentId, string ProcessName, string ProcessCode) { AjaxReturnData result = new AjaxReturnData(); int EditCount = 0; if (Convert.ToInt32(EditType.增加) == Action) { //新增 OT_WorkflowTemplate model = new OT_WorkflowTemplate(); model.ObjectID = ObjectID; model.ParentObjectID = ProcessParentId; model.WorkflowCode = ProcessCode; model.ProcessName = ProcessName; model.Content = WorkflowHelper.CreateDefaultContent(ProcessCode); EditCount = _workflowTemplateService.Insert <OT_WorkflowTemplate>(model); } else if (Convert.ToInt32(EditType.修改) == Action) { } if (EditCount > 0) { result.States = true; result.Message = "成功."; } else { result.States = false; result.Message = "失败."; } return(AjaxJson(result)); }
/// <summary> /// 删除流程 /// </summary> /// <param name="WorkFlowCode"></param> /// <returns></returns> public ActionResult DeleteProcess(string WorkflowCode) { AjaxReturnData result = new AjaxReturnData(); List <string> sqlList = new List <string>(); sqlList.Add(string.Format("delete from OT_BizObjectSchema where SchemaCode='{0}'", WorkflowCode)); //删除保存的数据模型 sqlList.Add(string.Format("delete from OT_BizObjectSchemaDraft where SchemaCode='{0}'", WorkflowCode)); //删除发布的数据模型 sqlList.Add(string.Format("delete from OT_WorkflowTemplate where WorkflowCode='{0}'", WorkflowCode)); //删除流程模板 sqlList.Add(string.Format("delete from OT_WorkflowTemplateDraft where WorkflowCode='{0}'", WorkflowCode)); //删除流程模板 sqlList.Add(string.Format(@"if exists (select 1 from sysobjects where id = object_id('I_{0}') and type = 'U') drop table I_{0}", WorkflowCode)); //删除数据表 int successCount = DapperHelper.CreateInstance().TransAction(sqlList); if (successCount > 0) { result.Message = "删除成功."; } else { result.States = false; result.ErrorMessage = "删除失败."; } return(AjaxJson(result)); }
public ActionResult Login(string Account, string Password) { AjaxReturnData result = new AjaxReturnData(); //登录 result.States = false; //登录 List <SystemUser> list = DapperHelper.CreateInstance().SimpleQuery <SystemUser>(@"select * from SystemUser where Account='" + Account + "'"); if (list.Count > 0) { if (list[0].Password == Password) { result.States = true; CookieHelper.SetCookie("systemUserName", list[0].UserName, DateTime.Now.AddDays(1)); CookieHelper.SetCookie("systemUserAccount", list[0].Account, DateTime.Now.AddDays(1)); CookieHelper.SetCookie("systemUserObjectId", list[0].ObjectId, DateTime.Now.AddDays(1)); result.Data = list[0]; } } if (!result.States) { result.Message = "账号密码不正确."; } //else //{ // Response.Redirect(HttpUtility.UrlDecode(Request.Params["ReturnUrl"])); //} return(AjaxJson(result)); }
/// <summary> /// 人员选择 /// </summary> /// <returns></returns> public ActionResult SelectSystemUser() { AjaxReturnData result = new AjaxReturnData(); List <SystemUser> list = _systemUser.SelectData <SystemUser>("select * from SystemUser"); result.Data = list; return(AjaxJson(result)); }
/// <summary> /// 获取角色配置的人员 /// </summary> /// <param name="ObjectId">角色ObjectId</param> /// <returns></returns> public ActionResult GetRoleUsers(string objectId) { AjaxReturnData result = new AjaxReturnData(); List <RoleRelationship> list = _roleRelationship.SelectData <RoleRelationship>("select * from RoleRelationship where RoleObjectId='" + objectId + "'"); result.Data = list; return(AjaxJson(result)); }
/// <summary> /// 增加主表数据字段 /// </summary> /// <param name="FieldJArray">主表字段数组</param> /// <param name="Model">主表数据模型</param> /// <param name="AddTarget">新增目标字段</param> /// <param name="Service">数据保存服务</param> /// <returns></returns> public static AjaxReturnData AddMainTableField(string AddTarget, JArray FieldJArray, OT_BizObjectSchema Model, IOT_BizObjectSchemaService Service) { AjaxReturnData result = new AjaxReturnData(); result.States = true; bool hasField = false; JArray newField = JArray.Parse(AddTarget); foreach (JObject item in FieldJArray) { if (item["FieldCode"] + string.Empty == newField[0]["FieldCode"] + string.Empty) { hasField = true; } } if (hasField) { result.States = false; result.ErrorMessage = "已存在相同编码"; } else { FieldJArray.Add(newField[0]); Model.Content = FieldJArray.ToString(); int updateCount = Service.UpdateTable <OT_BizObjectSchema>(Model); if (updateCount > 0) { result.Message = "更新成功."; } else { result.States = false; result.ErrorMessage = "更新失败."; } } return(result); }
/// <summary> /// 编辑菜单页面保存事件 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult SubmitMenuEdit(Sys_Menu model) { AjaxReturnData result = new AjaxReturnData(); if (model.pk_Menu == 0) { //新增 string maxPk_MenuSql = "select max(pk_Menu)+1 as pk_Menu from Sys_Menu"; int pk_Menu = DapperHelper.CreateInstance().ExecuteScalar(maxPk_MenuSql); model.pk_Menu = pk_Menu; int insertCount = _sys_MenuService.Insert <Sys_Menu>(model); if (insertCount > 0) { result.States = true; result.Message = "新增数据成功."; } else { result.States = false; result.Message = "新增数据失败."; } } else { //修改 Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("pk_Menu", model.pk_Menu); int updateCount = _sys_MenuService.UpdateTable <Sys_Menu>(model, param); if (updateCount > 0) { result.States = true; result.Message = "修改数据成功."; } else { result.States = false; result.Message = "修改数据失败."; } } CacheHelper.Remove("webRootMenuList"); return(AjaxJson(result)); }
/// <summary> /// 获取角色 /// </summary> /// <param name="ObjectId">角色ObjectId</param> /// <returns></returns> public ActionResult GetRoleLists(string roleName = "", int pageIndex = 1) { AjaxReturnData result = new AjaxReturnData(); int pageSize = 15; int totalCount = 0; List <SystemRole> list = new List <SystemRole>(); if (string.IsNullOrEmpty(roleName)) { list.AddRange(_systemRole.SimplePageQuery <SystemRole>(pageSize, pageIndex, "RoleName", out totalCount, "select * from SystemRole")); } else { list.AddRange(_systemRole.SimplePageQuery <SystemRole>(pageSize, pageIndex, "RoleName", out totalCount, "select * from SystemRole where RoleName like '%" + roleName + "%'")); } result.Data = new { TotalPage = Math.Ceiling(Convert.ToDecimal(totalCount / pageSize)) + totalCount % pageSize != 0 ? 1 : 0, List = list }; return(AjaxJson(result)); }
/// <summary> /// 修改权限角色 /// </summary> /// <param name="objectId"></param> /// <param name="roleNames"></param> /// <param name="roleObjectIds"></param> /// <returns></returns> public ActionResult EditAuthRole(string objectId, string roleNames, string roleObjectIds) { AjaxReturnData result = new AjaxReturnData(); Authority model = new Authority(); model = _authority.SelectData <Authority>("select * from Authority where ObjectId='" + objectId + "'")[0]; model.RoleNames = roleNames; model.RoleObjectIds = roleObjectIds; int count = _authority.UpdateTable <Authority>(model); if (count <= 0) { result.States = false; } return(AjaxJson(result)); }
/// <summary> /// 编辑菜单页面保存事件 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult DeleteMenu(string pk_Menu) { AjaxReturnData result = new AjaxReturnData(); Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("pk_Menu", pk_Menu); int deleteCount = _sys_MenuService.DeleteSigerData <Sys_Menu>(param); if (deleteCount > 0) { result.States = true; result.Message = "删除数据成功."; } else { result.States = false; result.Message = "删除数据失败."; } CacheHelper.Remove("webRootMenuList"); return(AjaxJson(result)); }
/// <summary> /// 一对多查询 /// </summary> /// <returns></returns> public ActionResult OneToManyQuery() { IDbConnection connection = new SqlConnection("Data Source=.;Initial Catalog=DataMip;Integrated Security=True;MultipleActiveResultSets=True"); var sql = @"select c.CustomerID, c.CustomerName,c.Mobile,c.Address,c.Email,p.ProductID,p.ProductName,p.ProductDesc from Customers c left join OrderGoods o on c.CustomerID=o.CustomerID left join Product p on p.ProductID=o.ProductID"; var lookUp = new Dictionary <int, Customers>(); List <Customers> customerList = new List <Customers>(); List <Product> productList = new List <Product>(); List <Customers> resultList = new List <Customers>(); customerList = connection.Query <Customers, Product, Customers>(sql, (customer, product) => { Customers c; if (!lookUp.TryGetValue(customer.CustomerID, out c)) { lookUp.Add(customer.CustomerID, c = customer); } Product p; p = product; //productList.Add(p); c.Products.Add(p); return(customer); }, splitOn: "ProductID").ToList(); var result = connection.Query(sql); resultList.AddRange(lookUp.Values); //resultList = DapperHelper.OneToManyQuery<Customers, Product>(sql, "ProductID", "CustomerID"); ViewData["Result"] = resultList; AjaxReturnData returnData = new AjaxReturnData(); returnData.States = true; returnData.Data = resultList; return(AjaxJson(returnData)); //return View(); }
/// <summary> /// 删除权限 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult AuthorityDelete(Authority model) { AjaxReturnData result = new AjaxReturnData(); int EditCount = 0; Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("ObjectId", model.ObjectId); EditCount = _authority.DeleteSigerData <Authority>(param); if (EditCount > 0) { result.States = true; result.Message = "成功."; } else { result.States = false; result.Message = "失败."; } return(AjaxJson(result)); }
/// <summary> /// 编辑数据字典 /// </summary> /// <returns></returns> public ActionResult DeleteDictionary(string taskID) { AjaxReturnData result = new AjaxReturnData(); int EditCount = 0; Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("TaskID", taskID); EditCount = _dataDictionaryService.DeleteSigerData <S_DataDictionary>(param, ConfigurationManager.AppSettings["SqlConnectionKey_OADB"]); if (EditCount > 0) { result.States = true; result.Message = "成功."; } else { result.States = false; result.Message = "失败."; } return(AjaxJson(result)); }
/// <summary> /// 角色管理 /// </summary> /// <returns></returns> public ActionResult SystemRoleDelete(string objectId) { AjaxReturnData result = new AjaxReturnData(); int EditCount = 0; Dictionary <string, object> param = new Dictionary <string, object>(); param.Add("ObjectId", objectId); EditCount = _systemRole.DeleteSigerData <SystemRole>(param); if (EditCount > 0) { result.States = true; result.Message = "成功."; } else { result.States = false; result.Message = "失败."; } return(AjaxJson(result)); }
/// <summary> /// 保存数据模型字段 /// </summary> /// <param name="FiledListString"></param> /// <returns></returns> public ActionResult SaveObjectSchema(string FieldListString, string WorkFlowCode) { AjaxReturnData result = new AjaxReturnData(); #region 保存数据模型字段 List <OT_BizObjectSchema> list = _bizObjectSchemaService.SelectData <OT_BizObjectSchema>("select * from OT_BizObjectSchema where SchemaCode='" + WorkFlowCode + "'"); if (list.Count > 0) { OT_BizObjectSchema model = list[0]; JArray Fields = JArray.Parse(model.Content); JArray newField = JArray.Parse(FieldListString); bool hasField = false; if (!Convert.ToBoolean(newField[0]["IsSonTable"] + string.Empty)) { //非子表数据 foreach (JObject item in Fields) { if (item["FieldCode"] + string.Empty == newField[0]["FieldCode"] + string.Empty) { hasField = true; } } if (hasField) { result.States = false; result.ErrorMessage = "已存在相同编码"; } else { Fields.Add(newField[0]); model.Content = Fields.ToString(); int updateCount = _bizObjectSchemaService.UpdateTable <OT_BizObjectSchema>(model); if (updateCount > 0) { result.Message = "更新成功."; } else { result.States = false; result.ErrorMessage = "更新失败."; } } } else { //子表数据 foreach (JObject item in Fields) { if (item["ObjectId"] + string.Empty == newField[0]["ParentProperty"] + string.Empty) { foreach (JObject children in JArray.Parse(item["children"] + string.Empty)) { if (children["FieldCode"] + string.Empty == newField[0]["FieldCode"] + string.Empty) { hasField = true; } } if (hasField) { result.States = false; result.ErrorMessage = "已存在相同编码"; } else { JArray children = JArray.Parse(item["children"] + string.Empty); children.Add(newField[0]); item["children"] = children; model.Content = Fields.ToString(); int updateCount = _bizObjectSchemaService.UpdateTable <OT_BizObjectSchema>(model); if (updateCount > 0) { result.Message = "更新成功."; } else { result.States = false; result.ErrorMessage = "更新失败."; } } break; } } } } else { OT_BizObjectSchema model = new OT_BizObjectSchema(); model.ObjectID = Guid.NewGuid().ToString(); model.SchemaCode = WorkFlowCode; model.Content = FieldListString; model.DisplayName = "数据模型"; model.CreatedTime = DateTime.Now; model.ModifiedTime = DateTime.Now; int insertCount = _bizObjectSchemaService.Insert <OT_BizObjectSchema>(model); if (insertCount > 0) { result.Message = "保存成功."; } else { result.States = false; result.ErrorMessage = "保存数据失败."; } } #endregion return(AjaxJson(result)); }
/// <summary> /// 删除表数据字段 /// </summary> /// <param name="ObjectId">被删除字段ObjectId</param> /// <param name="FieldJArray">主表字段数组</param> /// <param name="Model">主表数据模型</param> /// <param name="Service">数据保存服务</param> /// <returns></returns> public static AjaxReturnData DeleteTableField(string MainTableCode, string ObjectId, bool IsSonTable, string ParentProperty, JArray FieldJArray, OT_BizObjectSchema Model, IOT_BizObjectSchemaService Service) { string dbConnectionKey = string.Format("Data Source = {0}; Initial Catalog = {1}; User Id = {2}; Password = {3} ", ConfigurationManager.AppSettings["DataSource"], string.IsNullOrEmpty(Model.DbName) ? "ProcDB" : Model.DbName, ConfigurationManager.AppSettings["UserId"], ConfigurationManager.AppSettings["Password"]); AjaxReturnData result = new AjaxReturnData(); result.States = true; if (IsSonTable) { foreach (var item in FieldJArray) { if (item["ObjectId"] + string.Empty == ParentProperty + string.Empty) { foreach (JObject childItem in (JArray)item["children"]) { if (childItem["ObjectId"] + string.Empty == ObjectId + string.Empty) { if ((bool)childItem["IsPublished"] == true) { if (((JArray)item["children"]).Count == 1) { #region 除数据表 string deleteTableFieldSql = "drop table C_" + item["FieldCode"]; DapperHelper.CreateInstance(dbConnectionKey).ExecuteNoneQuery(deleteTableFieldSql); #endregion FieldJArray.Remove(item); } else { #region 除数据表字段 int hasField = DapperHelper.CreateInstance(dbConnectionKey).ExecuteScalar("select COUNT(*) from syscolumns where id=object_id('C_" + MainTableCode + "') and name='" + item["FieldCode"].ToString() + "' "); if (hasField > 0) { string deleteTableFieldSql = "alter table C_" + item["FieldCode"] + " drop column [" + childItem["FieldCode"].ToString() + "]"; DapperHelper.CreateInstance(dbConnectionKey).ExecuteNoneQuery(deleteTableFieldSql); } #endregion } } ((JArray)item["children"]).Remove(childItem); break; } } break; } } } else { foreach (JObject item in FieldJArray) { if (item["ObjectId"] + string.Empty == ObjectId + string.Empty) { if ((bool)item["IsPublished"] == true) { if (item["LogicType"] + string.Empty == "BizObjectArray") { //子表 #region 除数据表 string deleteTableFieldSql = "drop table C_" + item["FieldCode"]; DapperHelper.CreateInstance(dbConnectionKey).ExecuteNoneQuery(deleteTableFieldSql); #endregion } else { #region 除数据表字段 int hasField = DapperHelper.CreateInstance(dbConnectionKey).ExecuteScalar("select COUNT(*) from syscolumns where id=object_id('I_" + MainTableCode + "') and name='" + item["FieldCode"].ToString() + "' "); if (hasField > 0) { string deleteTableFieldSql = "alter table I_" + MainTableCode + " drop column [" + item["FieldCode"].ToString() + "]"; DapperHelper.CreateInstance(dbConnectionKey).ExecuteNoneQuery(deleteTableFieldSql); } #endregion } } FieldJArray.Remove(item); break; } } } Model.Content = FieldJArray.ToString(); int updateCount = Service.UpdateTable <OT_BizObjectSchema>(Model); if (updateCount > 0) { result.Message = "更新成功."; } else { result.States = false; result.ErrorMessage = "更新失败."; } return(result); }
/// <summary> /// 添加角色人员 /// </summary> /// <param name="array"></param> /// <returns></returns> public ActionResult AddRoleUsers(List <RoleRelationship> array, string roleObjectId) { AjaxReturnData result = new AjaxReturnData(); List <RoleRelationship> list = _roleRelationship.SelectData <RoleRelationship>("select * from RoleRelationship where RoleObjectId='" + roleObjectId + "'"); int deleteCount = 0; int insertCount = 0; if (array != null) { if (list.Count > 0) { foreach (var item in list) { if (array.Find(c => c.UserObjectId == item.UserObjectId) != null) { array.Remove(array.Find(c => c.UserObjectId == item.UserObjectId)); } else { //删除 Dictionary <string, Object> param = new Dictionary <string, Object>(); param.Add("ObjectId", item.ObjectId); deleteCount = _roleRelationship.DeleteSigerData <RoleRelationship>(param); } } } foreach (var item in array) { item.ObjectId = Guid.NewGuid() + String.Empty; } insertCount = _roleRelationship.InsertBatch <RoleRelationship>(array); } else { { foreach (var item in list) { //删除 Dictionary <string, Object> param = new Dictionary <string, Object>(); param.Add("ObjectId", item.ObjectId); deleteCount = _roleRelationship.DeleteSigerData <RoleRelationship>(param); } } } if (insertCount > 0 || deleteCount > 0) { result.States = true; result.Message = "成功."; } else { result.States = false; result.Message = "失败."; } return(AjaxJson(result)); }
/// <summary> /// 添加子表数据字段 /// </summary> /// <param name="FieldJArray">主表字段数组</param> /// <param name="Model">主表数据模型</param> /// <param name="AddTarget">新增目标字段</param> /// <param name="Service">数据保存服务</param> /// <returns></returns> public static AjaxReturnData AddSonTableField(string AddTarget, JArray FieldJArray, OT_BizObjectSchema Model, IOT_BizObjectSchemaService Service) { AjaxReturnData result = new AjaxReturnData(); result.States = true; bool hasField = false; JArray newField = JArray.Parse(AddTarget); foreach (JObject item in FieldJArray) { if (item["ObjectId"] + string.Empty == newField[0]["ParentProperty"] + string.Empty) { item["IsPublished"] = false; if (!string.IsNullOrEmpty(item["children"] + string.Empty)) { foreach (JObject children in JArray.Parse(item["children"] + string.Empty)) { if (children["FieldCode"] + string.Empty == newField[0]["FieldCode"] + string.Empty) { hasField = true; } } if (hasField) { result.States = false; result.ErrorMessage = "已存在相同编码"; } else { JArray children = JArray.Parse(item["children"] + string.Empty); children.Add(newField[0]); item["children"] = children; Model.Content = FieldJArray.ToString(); int updateCount = Service.UpdateTable <OT_BizObjectSchema>(Model); if (updateCount > 0) { result.Message = "更新成功."; } else { result.States = false; result.ErrorMessage = "更新失败."; } } } else { //添加第一个子表数据 JArray children = new JArray(); children.Add(newField[0]); item["children"] = children; Model.Content = FieldJArray.ToString(); int updateCount = Service.UpdateTable <OT_BizObjectSchema>(Model); if (updateCount > 0) { result.Message = "更新成功."; } else { result.States = false; result.ErrorMessage = "更新失败."; } } break; } } return(result); }
/// <summary> /// 发布数据模型 /// </summary> /// <param name="FieldListString"></param> /// <param name="WorkFlowCode"></param> /// <returns></returns> public ActionResult PublishObjectSchema(string FieldListString, string WorkFlowCode) { AjaxReturnData result = new AjaxReturnData(); JArray ObjectSchemaList = JArray.Parse(FieldListString); //已保存的数据模型 OT_BizObjectSchema model = new OT_BizObjectSchema(); model = _bizObjectSchemaService.SelectData <OT_BizObjectSchema>("select * from OT_BizObjectSchema where SchemaCode='" + WorkFlowCode + "'")[0]; string hasTableSql = "select count(*) from sysobjects where id = object_id('Work6-OA.dbo.I_" + WorkFlowCode + "')"; int hasTableCount = DapperHelper.CreateInstance().ExecuteScalar(hasTableSql); if (hasTableCount > 0) { //已经发布过的数据模型 } else { StringBuilder FieldSql = new StringBuilder(); //未发布 foreach (JObject item in ObjectSchemaList) { if (item["LogicType"] + string.Empty != "BizObjectArray") { //非子表 FieldSql.Append(item["FieldCode"] + string.Empty); switch (item["LogicType"] + string.Empty) { case "ShortString": case "SingleParticipant": FieldSql.Append(" varchar(255),"); break; case "DateTime": FieldSql.Append(" datetime,"); break; default: break; } } //改变发布状态 item["IsPublished"] = true; } string CreateTableSql = string.Format(@"CREATE TABLE I_{1} (ObjectId char(36) , Name nvarchar(255) , CreatedBy varchar(255), CreatedByParentId varchar(255), ModifiedBy varchar(255), CreatedTime datetime, ModifiedTime datetime, RunningInstanceId varchar(255), {0} PRIMARY KEY (ObjectId) )", FieldSql.ToString(), WorkFlowCode); #region 发布数据模型字段 OT_BizObjectSchemaDraft publishModel = new OT_BizObjectSchemaDraft(); model.Content = ObjectSchemaList.ToString(); model.ModifiedTime = DateTime.Now; publishModel.ObjectID = Guid.NewGuid().ToString(); publishModel.SchemaCode = WorkFlowCode; publishModel.Content = ObjectSchemaList.ToString(); publishModel.DisplayName = "数据模型"; publishModel.CreatedTime = DateTime.Now; publishModel.ModifiedTime = DateTime.Now; //事务处理 using (IDbConnection dbConnection = new SqlConnection(BaseApplication.DefaultSqlConnectionKey)) { dbConnection.Open(); IDbTransaction transaction = dbConnection.BeginTransaction(); try { DapperHelper.CreateInstance().ExecuteNoneQuery(CreateTableSql); //创建数据表 int insertCount = _bizObjectSchemaDraftService.Insert <OT_BizObjectSchemaDraft>(publishModel); int updateCount = _bizObjectSchemaService.UpdateTable <OT_BizObjectSchema>(model); if (insertCount > 0 && updateCount > 0) { result.Message = "发布成功"; } transaction.Commit(); } catch (Exception exception) { result.ErrorMessage = exception.ToString(); transaction.Rollback(); } } #endregion } return(AjaxJson(result)); }