/// <summary> /// 添加/编辑自定义表单 /// </summary> /// <param name="Model"></param> /// <returns></returns> public int EditFormInfo(FormInfoEdit Model) { MySqlConnection conn = DbMySqlConnectionWrite(); int iBack = 0; try { using (conn) { if (string.IsNullOrEmpty(Model.ID)) { string strGUID = Guid.NewGuid().ToString(); iBack = conn.Insert("FormInfo") .Field("PK_Form", DbType.AnsiString, strGUID) .Field("PK_Group", DbType.AnsiString, Model.GroupID) .Field("Name", DbType.AnsiString, Model.Name) .Field("ControlSort", DbType.AnsiString, Model.ControlSort) .Field("ControlJson", DbType.AnsiString, Model.ControlJson) .Field("Remark", DbType.AnsiString, Model.Remark) .Field("T_Deleted", DbType.Int32, 0) .Field("T_Creater", DbType.AnsiString, Model.OperatorID) .Field("T_CreaterName", DbType.AnsiString, Model.OperatorName) .Field("T_CreateTime", DbType.DateTime, Model.OperateTime) .Field("T_Updater", DbType.AnsiString, Model.OperatorID) .Field("T_UpdaterName", DbType.AnsiString, Model.OperatorName) .Field("T_UpdateTime", DbType.DateTime, Model.OperateTime) .Execute(); } else { iBack = conn.Update("FormInfo") .Set("Name", DbType.AnsiString, Model.Name) .Set("ControlSort", DbType.AnsiString, Model.ControlSort) .Set("ControlJson", DbType.AnsiString, Model.ControlJson) .Set("Remark", DbType.AnsiString, Model.Remark) .Set("T_Deleted", DbType.Int32, 0) .Set("T_Updater", DbType.AnsiString, Model.OperatorID) .Set("T_UpdaterName", DbType.AnsiString, Model.OperatorName) .Set("T_UpdateTime", DbType.DateTime, Model.OperateTime) .Where(WhereMySQL.Equal("PK_Form", DbType.AnsiString, Model.ID)) .Execute(); } } return iBack; } catch { return 0; } }
public DataResult EditFormInfo(FormInfoEdit Model) { //BForm bWorkOrder = new BForm(); ///操作员信息获取、测试阶段改信息来自常量的引用中。 ///当后台能获取操作员信息后,需取消using OTG.OA.Framework.Const的引用。 UserInfo mUser = BusinessConst.GetDefault(); Model.GroupID = mUser.GroupID; Model.OperatorID = mUser.ID; Model.OperatorName = mUser.Name; Model.OperateTime = DateTime.Now; int iBack = formService.EditFormInfo(Model); if (iBack == 1) { dataResult.Code = ResponseStatusCode.Success; dataResult.Msg = "操作成功!"; } else { dataResult.Code = ResponseStatusCode.Error; dataResult.Msg = "操作失败!"; } return dataResult; }