public LogMsgData[] IsValid(DataSheetInfo sInfo, int index)
{
List <LogMsgData> result = new List <LogMsgData>();
DataFieldInfo dfi = sInfo.GetFieldInfo(index);
int len = 0;
if (!int.TryParse(dfi.validationValue, out len))
{
return(null);
}
int count = sInfo.GetContentCount();
for (int i = 0; i < count; i++)
{
object data = sInfo.GetContentValue(i, index);
if (data != null && (dfi.type == DataFieldType.Int || dfi.type == DataFieldType.Float || dfi.type == DataFieldType.Double || dfi.type == DataFieldType.Long))
{
}
}
if (result.Count > 0)
{
return(result.ToArray());
}
else
{
return(null);
}
}
public LogMsgData[] IsValid(DataSheetInfo sInfo, int index)
{
List <LogMsgData> result = new List <LogMsgData>();
DataFieldInfo dfi = sInfo.GetFieldInfo(index);
int count = sInfo.GetContentCount();
Dictionary <string, bool> cacheData = new Dictionary <string, bool>();
for (int i = 0; i < count; i++)
{
object data = sInfo.GetContentValue(i, index);
if (data == null)
{
result.Add(new ErrorLogData1(LogConst.E_DataValidation_Null, "" + index));
}
}
if (result.Count > 0)
{
return(result.ToArray());
}
else
{
return(null);
}
}
public LogMsgData[] IsValid(DataSheetInfo sInfo, int index)
{
List <LogMsgData> result = new List <LogMsgData>();
DataFieldInfo dfi = sInfo.GetFieldInfo(index);
int len = 0;
if (!int.TryParse(dfi.validationValue, out len))
{
return(null);
}
int count = sInfo.GetContentCount();
for (int i = 0; i < count; i++)
{
object data = sInfo.GetContentValue(i, index);
if (data != null && (dfi.type == DataFieldType.String || dfi.type == DataFieldType.Stringt || dfi.type == DataFieldType.Res))
{
string value = (string)data;
if (value.Length > len)
{
result.Add(new ErrorLogData3(LogConst.E_DataValidation_StrLen, "" + index, "" + len, value));
}
}
}
if (result.Count > 0)
{
return(result.ToArray());
}
else
{
return(null);
}
}
public LogMsgData[] IsValid(DataSheetInfo sInfo, int index)
{
List <LogMsgData> result = new List <LogMsgData>();
DataFieldInfo dfi = sInfo.GetFieldInfo(index);
int count = sInfo.GetContentCount();
Dictionary <string, bool> cacheData = new Dictionary <string, bool>();
for (int i = 0; i < count; i++)
{
object data = sInfo.GetContentValue(i, index);
if (data != null)
{
string validaStr = null;
if (dfi.type == DataFieldType.Dic)
{
Dictionary <string, string> dicData = (Dictionary <string, string>)data;
List <string> tempStrs = new List <string>();
foreach (KeyValuePair <string, string> kvp in dicData)
{
string t = kvp.Key + ":" + (kvp.Value == null ? "null" : kvp.Value);
tempStrs.Add(t);
}
tempStrs.Sort();
validaStr = string.Join(",", tempStrs.ToArray());
}
else if (dfi.type == DataFieldType.Array)
{
List <string> arrData = (List <string>)data;
arrData.Sort();
validaStr = string.Join(",", arrData.ToArray());
}
else
{
validaStr = (string)data;
}
if (cacheData.ContainsKey(validaStr))
{
result.Add(new ErrorLogData2(LogConst.E_DataValidation_Repeat, "" + index, validaStr));
}
else
{
cacheData.Add(validaStr, true);
}
}
}
if (result.Count > 0)
{
return(result.ToArray());
}
else
{
return(null);
}
}
private void CreateSummary()
{
summary.count = dataSheet.GetContentCount();
summary.subformCount = (int)Math.Ceiling(((float)summary.count) / exportConfig.subform);
summary.textPath = dataSheet.Name + "Text";
summary.strPath = dataSheet.Name + "Str";
for (int i = 0; i < dataSheet.GetFieldCount(); i++)
{
DataFieldInfo dfInfo = dataSheet.GetFieldInfo(i);
if (dfInfo.type == DataFieldType.Stringt)
{
summary.textFields.Add(dfInfo.name);
}
else if (dfInfo.type == DataFieldType.String || dfInfo.type == DataFieldType.Res)
{
summary.strFields.Add(dfInfo.name);
}
}
int index = 1;
while (true)
{
DataToOptimizeLuaSummary.SubformDataOfSummary subformData = new DataToOptimizeLuaSummary.SubformDataOfSummary();
subformData.path = string.Format("{0}/{0}_{1}", dataSheet.Name, index);
subformData.minID = int.Parse((string)dataSheet.GetContentValue((index - 1) * exportConfig.subform, 0));
int maxIndex = index * exportConfig.subform - 1;
if (maxIndex >= dataSheet.GetContentCount())
{
maxIndex = dataSheet.GetContentCount() - 1;
}
subformData.maxID = int.Parse((string)dataSheet.GetContentValue(maxIndex, 0));
summary.subforms.Add(subformData);
if (maxIndex == dataSheet.GetContentCount() - 1)
{
break;
}
index++;
}
for (int i = 1; i < dataSheet.GetFieldCount(); i++)
{
DataFieldInfo dfInfo = dataSheet.GetFieldInfo(i);
if (dfInfo.type == DataFieldType.Array || dfInfo.type == DataFieldType.Dic)
{
continue;
}
Dictionary <string, int> totalCount = new Dictionary <string, int>();
for (int j = 0; j < dataSheet.GetContentCount(); j++)
{
string data = (string)dataSheet.GetContentValue(j, i, true);
if (!string.IsNullOrEmpty(data))
{
if (dfInfo.type == DataFieldType.Stringt)
{
data = "" + text.AddText(data);
}
else if (dfInfo.type == DataFieldType.String || dfInfo.type == DataFieldType.Res)
{
data = "" + str.AddText(data);
}
if (totalCount.ContainsKey(data))
{
totalCount[data]++;
}
else
{
totalCount.Add(data, 1);
}
}
}
string maxValue = null;
int maxCount = 0;
foreach (KeyValuePair <string, int> kvp in totalCount)
{
if (kvp.Value > maxCount)
{
maxValue = kvp.Key;
maxCount = kvp.Value;
}
}
if (maxValue != null && maxCount > 1)
{
summary.defaultDic.Add(dfInfo, maxValue);
}
}
}
