private Dictionary <Entities.ServerInfo, DbDataSet.额度分配DataTable> ChangeToDict(DataTable dtImport, out string errMsg)
{
errMsg = string.Empty;
var dictServerDT = new Dictionary <Entities.ServerInfo, DbDataSet.额度分配DataTable>();
StringBuilder sb = new StringBuilder();
try
{
List <int> lstErrorRow = new List <int>();
int i = 0;
foreach (DataRow row in dtImport.Rows)
{
i++;
买模式 买模式1 = (买模式)Enum.Parse(typeof(买模式), row[6].ToString(), false);
卖模式 卖模式1 = (卖模式)Enum.Parse(typeof(卖模式), row[7].ToString(), false);
var serverInfo = row[10].ToString();
var server = ServiceConnectHelper.Instance.ServerInfoList.FirstOrDefault(_ => _.Remark == serverInfo || _.Ip == serverInfo);
if (server != null)
{
if (dictServerDT.ContainsKey(server))
{
dictServerDT[server].Add额度分配Row(row[0].ToString(), row[1].ToString(), row[2].ToString(), byte.Parse(row[3].ToString()), row[4].ToString(), row[5].ToString(), (int)买模式1, (int)卖模式1, decimal.Parse(row[8].ToString()), decimal.Parse(row[9].ToString()));
}
else
{
var dt = new DbDataSet.额度分配DataTable();
dt.Add额度分配Row(row[0].ToString(), row[1].ToString(), row[2].ToString(), byte.Parse(row[3].ToString()), row[4].ToString(), row[5].ToString(), (int)买模式1, (int)卖模式1, decimal.Parse(row[8].ToString()), decimal.Parse(row[9].ToString()));
dictServerDT.Add(server, dt);
}
}
else
{
lstErrorRow.Add(i);
}
}
if (lstErrorRow.Count > 0)
{
sb.Append("第").Append(string.Join(",", lstErrorRow)).Append("行未找到匹配的服务器信息，无法导入！");
errMsg = sb.ToString();
}
else
{
return(dictServerDT);
}
}
catch (Exception ex)
{
errMsg = ex.Message;
}
return(null);
}
private DbDataSet.额度分配DataTable ChangeTableToLimitDt(DataTable dtImport, out string erMsg)
{
erMsg = string.Empty;
DbDataSet.额度分配DataTable dtLimit = new DbDataSet.额度分配DataTable();
try
{
foreach (DataRow row in dtImport.Rows)
{
买模式 买模式1 = (买模式)Enum.Parse(typeof(买模式), row[6].ToString(), false);
卖模式 卖模式1 = (卖模式)Enum.Parse(typeof(卖模式), row[7].ToString(), false);
dtLimit.Add额度分配Row(row[0].ToString(), row[1].ToString(), row[2].ToString(), byte.Parse(row[3].ToString()), row[4].ToString(), row[5].ToString(), (int)买模式1, (int)卖模式1, decimal.Parse(row[8].ToString()), decimal.Parse(row[9].ToString()));
}
return(dtLimit);
}
catch (Exception ex)
{
erMsg = ex.Message;
}
return(null);
}
