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);
    }
Exemple #2
0
        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);
        }