public void Save() { string q; if (Id == 0) { if (ModuleCode == Guid.Empty) { q = $@" INSERT INTO players_modules(player_id) VALUES(0) SELECT @@IDENTITY AS Result"; Id = DataConnection.GetResultInt(q); } else { Id = ShipModule.ModuleIdByGuid(ModuleCode); if (Id == 0) { return; } } } q = $@"UPDATE players_modules SET player_id = {PlayerId}, module_id = {ModuleTypeId}, experience = {Experience}, module_level = {ModuleLevel}, rig_id = {RigSlotId}, module_code = CAST('{ModuleCode.ToString()}' AS uniqueidentifier) WHERE id = {Id}"; DataConnection.Execute(q); }
public void Create(ModuleCode moduleCode, string businessID, string operate, string opinion, string userid) { BusinessLog log = new BusinessLog(); log.SystemName = SubSystem.苏州市园林绿化企业动态管理系统.ToString(); log.CategoryName = ""; log.PostStatus = ""; log.PriorStatus = ""; log.ModuleName = moduleCode.ToString(); log.KeyString = businessID.ToString(); log.Operation = operate; log.MessageInfo = opinion; log.OperatorID = userid; log.OperatorName = ""; logManager.AppendLog(log); }