コード例 #1
0
ファイル: CheckList.cs プロジェクト: nearlity/tableTool
        public string CheckUnique(TabFile.Column column)
        {
            if (column.head.type != TypeDef.IntType)
            {
                return("检查命令不支持数据类型为" + column.head.type);
            }

            List <int>        existList   = new List <int>();
            OnForeachDelegate checkAction = (dataIndex, data) =>
            {
                int intData = (int)data;
                int index   = existList.IndexOf(intData);
                if (index == -1)
                {
                    existList.Add(intData);
                }
                else
                {
                    return(column.head.name + "=" + intData);
                }
                return(null);
            };

            return(ForeachColumnData(column, checkAction));
        }
コード例 #2
0
ファイル: CheckList.cs プロジェクト: nearlity/tableTool
        public string CheckIDExistAndCanBeZero(TabFile.Column column, string tabFileName, string columnName)
        {
            if (column.head.type != TypeDef.IntType && column.head.type != TypeDef.ListIntType)
            {
                return("检查命令不支持数据类型为" + column.head.type);
            }

            OnForeachDelegate checkAction = (dataIndex, data) =>
            {
                string strData = data.ToString();
                List <TabFile.Column> checkColumns = TabFileDataChecker.Instance.GetTabFileColumn(tabFileName, columnName);
                if (checkColumns == null || checkColumns.Count == 0)
                {
                    return(tabFileName + "表不存在列" + columnName + ",无法进行检查");
                }

                for (int j = 0; j < checkColumns.Count; j++)
                {
                    TabFile.Column checkColumn = checkColumns[j];
                    int            index       = checkColumn.data.IndexOf(strData);
                    if (index == -1 && (int)data != 0)
                    {
                        return(column.head.name + "=" + strData + "不存在" + tabFileName + "表" + columnName + "列");
                    }
                }
                return(null);
            };

            return(ForeachColumnData(column, checkAction));
        }
コード例 #3
0
ファイル: CheckList.cs プロジェクト: nearlity/tableTool
        private string ForeachColumnData(TabFile.Column column, OnForeachDelegate callback)
        {
            string ret = null;

            switch (column.head.type)
            {
            case TypeDef.IntType:
                for (int i = 0; i < column.data.Count; i++)
                {
                    int tempIntData = 0;
                    int.TryParse(column.data[i], out tempIntData);
                    ret = callback.Invoke(i, tempIntData);
                    if (!string.IsNullOrEmpty(ret))
                    {
                        return(ret);
                    }
                }
                break;

            case TypeDef.StringType:
                for (int i = 0; i < column.data.Count; i++)
                {
                    ret = callback.Invoke(i, column.data[i]);
                    if (!string.IsNullOrEmpty(ret))
                    {
                        return(ret);
                    }
                }
                break;

            case TypeDef.ListIntType:
                for (int i = 0; i < column.data.Count; i++)
                {
                    string columnData = column.data[i];
                    columnData = columnData.TrimStart('"');
                    columnData = columnData.TrimEnd('"');
                    string[] columnDataList = columnData.Split(',');
                    for (int j = 0; j < columnDataList.Length; j++)
                    {
                        int tempIntData = 0;
                        int.TryParse(columnDataList[j], out tempIntData);
                        ret = callback.Invoke(i, tempIntData);
                        if (!string.IsNullOrEmpty(ret))
                        {
                            return(ret);
                        }
                    }
                }
                break;
            }
            return(null);
        }
コード例 #4
0
        public List <TabFile.Column> GetTabFileColumn(string name, string key)
        {
            TabFile tabFile = GetTabFile(name);

            if (tabFile == null)
            {
                return(null);
            }

            string columnParent = null;
            string columnName   = null;
            int    index        = key.IndexOf('.');

            if (index == -1)
            {
                columnParent = null;
                columnName   = key;
            }
            else
            {
                columnParent = key.Substring(0, index);
                columnName   = key.Substring(index + 1);
            }

            List <TabFile.Column> ret = new List <TabFile.Column>();

            for (int i = 0; i < tabFile.columns.Count; i++)
            {
                TabFile.Column column = tabFile.columns[i];
                //  if (column.head.parent == columnParent && column.head.name == columnName)
                if (column.head.name == columnName)
                {
                    ret.Add(column);
                }
            }

            if (ret == null || ret.Count == 0)
            {
                System.Console.WriteLine(key + "标识不存在,请检查checklist_" + name);
            }
            return(ret);
        }
コード例 #5
0
ファイル: CheckList.cs プロジェクト: nearlity/tableTool
        public string CheckIDExistAndCanBeZeroWithRelative(TabFile.Column column, string relative, string columnName)
        {
            if (column.head.type != TypeDef.IntType)
            {
                return("检查命令不支持数据类型为" + column.head.type);
            }

            string[]          relativeList = relative.Split('=');
            OnForeachDelegate checkAction  = (dataIndex, data) =>
            {
                if ((int)data == 0)
                {
                    return(null);
                }

                string relativeTabFileName = FindRelativeColumn(dataIndex, relativeList);
                if (relativeTabFileName == null)
                {
                    return("根据数据:" + data + ";无法找到关联列:" + relative);
                }
                List <TabFile.Column> checkColumns = TabFileDataChecker.Instance.GetTabFileColumn(relativeTabFileName, columnName);
                if (checkColumns.Count != 1)
                {
                    return("根据数据:" + data + ";无法找到关联列:" + relative);
                }
                TabFile.Column relativeColumn = checkColumns[0];
                for (int j = 0; j < relativeColumn.data.Count; j++)
                {
                    int tempIntData = 0;
                    int.TryParse(relativeColumn.data[j], out tempIntData);
                    if (tempIntData == (int)data)
                    {
                        return(null);
                    }
                }
                return("无法在关联列:" + relative + "找到数据:" + data);
            };

            return(ForeachColumnData(column, checkAction));
        }
コード例 #6
0
        public void StartCheck(string filePath)
        {
            FileInfo fileInfo = new FileInfo(filePath);
            int      index    = fileInfo.Name.IndexOf('_') + 1;

            if (index == -1)
            {
                System.Console.WriteLine("检查配置命名错误,应为checklist_目标表名:" + fileInfo.Name);
                return;
            }
            string curTargetFileName = fileInfo.Name.Substring(index).Replace(".txt", "").ToLower();

            System.Console.WriteLine("检查完成--->" + curTargetFileName);
            FileStream   fs      = new FileStream(filePath, FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
            StreamReader sr      = new StreamReader(fs);
            string       content = sr.ReadToEnd();

            sr.Close();
            fs.Close();

            string[] lines = content.Split('\n');
            for (int i = 0; i < lines.Length; i++)
            {
                string line = lines[i];
                line = line.Trim('\r');
                string[] commandDesc = line.Split('\t');
                if (commandDesc.Length < 3)
                {
                    continue;
                }
                string     methodName = commandDesc[2];
                Type       t          = checkList.GetType();
                MethodInfo methodInfo = t.GetMethod(methodName);
                if (methodInfo == null)
                {
                    System.Console.WriteLine("检查配置命令不存在:" + methodName);
                    return;
                }

                string key = commandDesc[1];
                List <TabFile.Column> columns = GetTabFileColumn(curTargetFileName, key);
                if (columns == null || columns.Count == 0)
                {
                    return;
                }

                string ret = null;
                for (int j = 0; j < columns.Count; j++)
                {
                    TabFile.Column column    = columns[j];
                    List <object>  paramList = new List <object>();
                    paramList.Add(column);
                    for (int k = 3; k < commandDesc.Length; k++)
                    {
                        string param = commandDesc[k];
                        if (string.IsNullOrEmpty(param))
                        {
                            break;
                        }
                        paramList.Add(param);
                    }
                    ret = methodInfo.Invoke(checkList, paramList.ToArray()) as string;
                    if (string.IsNullOrEmpty(ret))
                    {
                        continue;
                    }
                    System.Console.WriteLine(line + "检查不通过!");
                    System.Console.WriteLine(ret);
                    break;
                }
            }
        }
コード例 #7
0
ファイル: Csfile.cs プロジェクト: nearlity/tableTool
        public bool UnpackFromTabFile(string fileName, TabFile tabfile)
        {
            curTabFile    = tabfile;
            this.fileName = fileName.Substring(0, 1).ToUpper() + fileName.Substring(1);
            CSStruct     curStruct     = null;
            CSListStruct curListSturct = null;

            for (int i = 0; i < tabfile.columns.Count; i++)
            {
                TabFile.Column column = tabfile.columns[i];
                if (!column.head.clientExport)
                {
                    continue;
                }

                switch (column.head.type)
                {
                case TypeDef.IntType:
                case TypeDef.BoolType:
                case TypeDef.FloatType:
                case TypeDef.StringType:
                case TypeDef.ListIntType:
                case TypeDef.ListFloatType:
                case TypeDef.ListStringType:
                case TypeDef.LuaTableType:
                    CSVaribles varible = new CSVaribles();
                    varible.type = column.head.type;
                    varible.name = column.head.name;
                    if (curStruct != null)
                    {
                        if (curStruct.NotContains(varible))
                        {
                            curStruct.varibles.Add(varible);
                        }
                    }
                    else
                    {
                        varibles.Add(varible);
                    }
                    break;

                case TypeDef.StructType:
                    if (!string.IsNullOrEmpty(column.head.name))
                    {
                        if (curStruct != null)
                        {
                            System.Console.WriteLine("struct异常,列:" + (i + 1));
                            return(false);
                        }
                        if (curListSturct == null)
                        {
                            curStruct      = new CSStruct();
                            curStruct.name = column.head.name;
                            structs.Add(curStruct);
                        }
                        else
                        {
                            if (curListSturct.csStruct == null)
                            {
                                curStruct              = new CSStruct();
                                curStruct.name         = curListSturct.name;
                                curListSturct.csStruct = curStruct;
                            }
                            curStruct = curListSturct.csStruct;
                            curListSturct.count++;
                        }
                    }
                    else
                    {
                        if (curStruct == null)
                        {
                            System.Console.WriteLine("struct异常,列:" + (i + 1));
                            return(false);
                        }

                        if (curListSturct == null)
                        {
                            varible          = new CSVaribles();
                            varible.type     = column.head.type;
                            varible.csStruct = curStruct;
                            varibles.Add(varible);
                        }
                        curStruct = null;
                    }
                    break;

                case TypeDef.ListType:
                    if (!string.IsNullOrEmpty(column.head.name))
                    {
                        if (curListSturct != null)
                        {
                            System.Console.WriteLine("list异常,列:" + (i + 1));
                            return(false);
                        }
                        curListSturct      = new CSListStruct();
                        curListSturct.name = column.head.name;
                        structLists.Add(curListSturct);
                    }
                    else
                    {
                        if (curListSturct == null)
                        {
                            System.Console.WriteLine("struct异常,列:" + (i + 1));
                            return(false);
                        }

                        varible              = new CSVaribles();
                        varible.type         = column.head.type;
                        varible.csListStruct = curListSturct;
                        varibles.Add(varible);
                        curListSturct = null;
                    }
                    break;

                default:
                    System.Console.WriteLine(i + ":不支持的数据类型:" + column.head.type + "," + column.head.name);
                    break;
                }
            }
            return(true);
        }
コード例 #8
0
ファイル: CheckList.cs プロジェクト: nearlity/tableTool
        public string CheckRange(TabFile.Column column, string min, string max)
        {
            if (column.head.type != TypeDef.IntType && column.head.type != TypeDef.FloatType && column.head.type != TypeDef.DoubleType)
            {
                return("检查命令不支持数据类型为" + column.head.type);
            }

            object objMinRet = null;
            object objMaxRet = null;

            switch (column.head.type)
            {
            case TypeDef.IntType:
                int intMin = 0;
                int.TryParse(min, out intMin);
                objMinRet = intMin;
                int intMax = 0;
                int.TryParse(max, out intMax);
                objMaxRet = intMax;
                break;

            case TypeDef.FloatType:
                float floatMin = 0;
                float.TryParse(min, out floatMin);
                objMinRet = floatMin;
                float floatMax = 0;
                float.TryParse(max, out floatMax);
                objMaxRet = floatMax;
                break;

            case TypeDef.DoubleType:
                double doubleMin = 0;
                double.TryParse(min, out doubleMin);
                objMinRet = doubleMin;
                double doubleMax = 0;
                double.TryParse(max, out doubleMax);
                objMaxRet = doubleMax;
                break;
            }

            OnForeachDelegate checkAction = (dataIndex, data) =>
            {
                switch (column.head.type)
                {
                case TypeDef.IntType:
                    if ((int)data >= (int)objMinRet && (int)data <= (int)objMaxRet)
                    {
                        return(null);
                    }
                    break;

                case TypeDef.FloatType:
                    if ((int)data >= (int)objMinRet && (int)data <= (int)objMaxRet)
                    {
                        return(null);
                    }
                    break;

                case TypeDef.DoubleType:
                    if ((int)data >= (int)objMinRet && (int)data <= (int)objMaxRet)
                    {
                        return(null);
                    }
                    break;
                }
                return(column.head.name + "=" + data);
            };

            return(ForeachColumnData(column, checkAction));
        }
コード例 #9
0
        public bool UnpackFromTabFile(TabFile tabfile, bool forceAll = false)
        {
            List <LuaStruct> structs = new List <LuaStruct>();

            for (int i = 0; i < tabfile.columns[0].data.Count; i++)
            {
                StringBuilder line = new StringBuilder();
                lines.Add(line);
                LuaStruct structTmp = new LuaStruct();
                structs.Add(structTmp);
            }
            bool isInList = false;

            for (int i = 0; i < tabfile.columns.Count; i++)
            {
                TabFile.Column column = tabfile.columns[i];
                for (int j = 0; j < column.data.Count; j++)
                {
                    StringBuilder line      = lines[j];
                    LuaStruct     structTmp = structs[j];
                    string        data      = column.data[j];
                    if (i == 0)
                    {
                        line.Append("[" + data + "] = {");
                    }

                    if (column.head.serverExport || forceAll)
                    {
                        switch (column.head.type)
                        {
                        case TypeDef.IntType:
                            int intData = 0;
                            int.TryParse(data, out intData);
                            if (!isInList)
                            {
                                line.Append(column.head.name + "=" + intData + ",");
                            }
                            else
                            {
                                if (intData != 0)
                                {
                                    structTmp.hasData = true;
                                }
                                structTmp.str.Append(column.head.name + "=" + intData + ",");
                            }
                            break;

                        case TypeDef.BoolType:
                            string str      = data.ToLower();
                            bool   boolData = false;
                            if (!string.IsNullOrEmpty(str) && str != "0" && str != "false")
                            {
                                boolData = true;
                            }
                            string boolStr = boolData.ToString().ToLower();
                            if (!isInList)
                            {
                                line.Append(column.head.name + "=" + boolStr + ",");
                            }
                            else
                            {
                                if (boolData)
                                {
                                    structTmp.hasData = true;
                                }
                                structTmp.str.Append(column.head.name + "=" + boolStr + ",");
                            }
                            break;

                        case TypeDef.FloatType:
                            float floatData = 0;
                            float.TryParse(data, out floatData);
                            string floatStr = string.Format("{0}", floatData);
                            if (!isInList)
                            {
                                line.Append(column.head.name + "=" + floatStr + ",");
                            }
                            else
                            {
                                if (floatData != 0)
                                {
                                    structTmp.hasData = true;
                                }
                                structTmp.str.Append(column.head.name + "=" + floatStr + ",");
                            }
                            break;

                        case TypeDef.StringType:
                            if (!string.IsNullOrEmpty(data))
                            {
                                string strData = data.TrimStart('"');
                                strData = strData.TrimEnd('"');
                                strData = strData.Replace("\\", "\\\\");
                                strData = strData.Replace("\"", "\\\"");
                                if (!isInList)
                                {
                                    line.Append(column.head.name + "=\"" + strData + "\",");
                                }
                                else
                                {
                                    structTmp.hasData = true;
                                    structTmp.str.Append(column.head.name + "=\"" + strData + "\",");
                                }
                            }
                            break;

                        case TypeDef.ListIntType:
                        case TypeDef.ListFloatType:
                            string strData2 = data.TrimStart('"');
                            strData2 = strData2.TrimEnd('"');
                            if (!isInList)
                            {
                                line.Append(column.head.name + "={" + strData2 + "},");
                            }
                            else
                            {
                                if (!string.IsNullOrEmpty(data))
                                {
                                    structTmp.hasData = true;
                                    structTmp.str.Append(column.head.name + "={" + strData2 + "},");
                                }
                            }
                            break;

                        case TypeDef.ListStringType:
                            if (!string.IsNullOrEmpty(data))
                            {
                                string strData = data.TrimStart('"');
                                strData = strData.TrimEnd('"');
                                string[] param         = strData.Split(',');
                                string   strDataResult = "";
                                for (int k = 0; k < param.Length; k++)
                                {
                                    strDataResult += "\"" + param[k] + "\"";
                                    if (k != param.Length - 1)
                                    {
                                        strDataResult += ",";
                                    }
                                }
                                if (!isInList)
                                {
                                    line.Append(column.head.name + "={" + strDataResult + "},");
                                }
                                else
                                {
                                    structTmp.hasData = true;
                                    structTmp.str.Append(column.head.name + "={" + strDataResult + "},");
                                }
                            }
                            break;

                        case TypeDef.StructType:
                            if (!string.IsNullOrEmpty(column.head.name))
                            {
                                structTmp.str     = new StringBuilder();
                                structTmp.hasData = false;
                                if (isInList)
                                {
                                    structTmp.str.Append("{");
                                }
                                else
                                {
                                    line.Append(column.head.name + "={");
                                }
                            }
                            else
                            {
                                if (isInList)
                                {
                                    structTmp.str.Replace(",", "", structTmp.str.Length - 1, 1);
                                    structTmp.str.Append("},");
                                    if (structTmp.hasData)
                                    {
                                        line.Append(structTmp.str.ToString());
                                    }
                                }
                                else
                                {
                                    line.Replace(",", "", line.Length - 1, 1);
                                    line.Append("},");
                                }
                            }
                            break;

                        case TypeDef.ListType:
                            if (!string.IsNullOrEmpty(column.head.name))
                            {
                                line.Append(column.head.name + "={");
                                isInList = true;
                            }
                            else
                            {
                                line.Replace(",", "", line.Length - 1, 1);
                                line.Append("},");
                                isInList = false;
                            }
                            break;

                        case TypeDef.LuaTableType:
                            if (!string.IsNullOrEmpty(data))
                            {
                                string strData = data.TrimStart('"');
                                strData = strData.TrimEnd('"');
                                if (!isInList)
                                {
                                    line.Append(column.head.name + "=" + strData + ",");
                                }
                                else
                                {
                                    structTmp.hasData = true;
                                    structTmp.str.Append(column.head.name + "=" + strData + ",");
                                }
                            }
                            break;
                        }
                    }

                    if (i == tabfile.columns.Count - 1)
                    {
                        line.Replace(",", "", line.Length - 1, 1);
                        line.Append("},");
                    }
                }
            }
            return(true);
        }