private void GetAllFile(string PathLike)//回调程序目录
{
string[] StrDir = Directory.GetDirectories(PathLike);
string[] StrFile = Directory.GetFiles(PathLike);
if (StrFile.Length > 0)
{
string StrName, StrPath;
int NameLine, PathLine;
for (int i = 0; i < StrFile.Length; i++)
{
StrName = Path.GetFileName(StrFile[i]);
NameLine = StrName.Length;
PathLine = StrFile[i].Length;
StrPath = StrFile[i].Substring(Qline, PathLine - Qline - NameLine);
dataGridView1.Rows.Insert(0);
dataGridView1.Rows[0].Cells["FileName"].Value = StrName.ToString();
dataGridView1.Rows[0].Cells["GVPath"].Value = StrPath;
dataGridView1.Rows[0].Cells["localPath"].Value = StrFile[i];
}
}
if (StrDir.Length > 0)
{
for (int i = 0; i < StrDir.Length; i++)
{
GetAllFile(StrDir[i]);
}
}
}
private void genTable(Table table, OpRes res, GMUser user, QueryMgr mgr)
{
table.GridLines = GridLines.Both;
TableRow tr = new TableRow();
table.Rows.Add(tr);
TableCell td = null;
ResultGameRecharge qresult = (ResultGameRecharge)mgr.getQueryResult(QueryType.queryTypeGameRecharge);
if (qresult.m_fields.Count == 0)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = OpResMgr.getInstance().getResultString(res);
return;
}
int i = 0, j = 0;
s_head = new string[2 + qresult.m_fields.Count];
m_content = new string[2 + qresult.m_fields.Count];
s_head[0] = "日期";
foreach (var r in qresult.m_fields)
{
s_head[++i] = r;
}
s_head[++i] = "总计";
// 表头
for (i = 0; i < s_head.Length; i++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = StrName.getGameName(s_head[i]);
}
Dictionary <string, long> data = new Dictionary <string, long>();
long totalR = 0;
for (i = 0; i < qresult.m_result.Count; i++)
{
tr = new TableRow();
if ((i & 1) == 0)
{
tr.CssClass = "alt";
}
table.Rows.Add(tr);
m_content[0] = qresult.m_result[i].m_time.ToLongDateString();
j = 1;
foreach (var game in qresult.m_fields)
{
long val = qresult.m_result[i].getValue(game);
m_content[j] = val.ToString();
j++;
if (data.ContainsKey(game))
{
data[game] += val;
}
else
{
data.Add(game, val);
}
}
m_content[j] = qresult.m_result[i].m_totalRecharge.ToString();
totalR += qresult.m_result[i].m_totalRecharge;
for (j = 0; j < s_head.Length; j++)
{
td = new TableCell();
tr.Cells.Add(td);
td.Text = m_content[j];
}
}
addStatFoot(table, data, totalR);
}
public override OpRes exportData(StreamWriter sheet, ExportParam param, int dbServerId)
{
int skip = 0;
List <Dictionary <string, object> > dataList = null;
string head = string.Join(",", s_head);
sheet.WriteLine(head);
int t = 0;
long nlong = 0;
string str = "";
while (true)
{
string sql = cmdStr(skip, 1000);
dataList = m_sqlDb.queryList(sql, CMySqlDbName.DB_XIANXIA);
if (dataList == null || dataList.Count == 0)
{
break;
}
skip += dataList.Count;
try
{
for (int i = 0; i < dataList.Count; i++)
{
Dictionary <string, object> data = dataList[i];
nlong = Convert.ToInt64(data["opId"]);
sheet.Write(nlong);
sheet.Write(",");
str = Convert.ToDateTime(data["opTime"]).ToString();
sheet.Write(str);
sheet.Write(",");
str = Convert.ToString(data["opSrc"]);
sheet.Write(str);
sheet.Write(",");
if (!(data["opRemainMoney"] is DBNull))
{
nlong = Convert.ToInt64(data["opRemainMoney"]);
sheet.Write(Tool.showMoneyValue(nlong, m_moneyBase));
}
sheet.Write(",");
if (!(data["aliasName"] is DBNull))
{
str = Convert.ToString(data["aliasName"]);
sheet.Write(str);
}
sheet.Write(",");
t = Convert.ToInt32(data["opType"]);
sheet.Write(StrName.s_scoreOpName[t]);
sheet.Write(",");
nlong = Convert.ToInt64(data["opScore"]);
sheet.Write(Tool.showMoneyValue(nlong, m_moneyBase));
sheet.Write(",");
str = Convert.ToString(data["opDst"]);
sheet.Write(str);
sheet.Write(",");
if (!(data["opDstRemainMoney"] is DBNull))
{
nlong = Convert.ToInt64(data["opDstRemainMoney"]);
sheet.Write(Tool.showMoneyValue(nlong, m_moneyBase));
}
sheet.Write(",");
if (!(data["orderId"] is DBNull))
{
str = Convert.ToString(data["orderId"]);
sheet.Write(str);
}
sheet.Write(",");
if (!(data["userOrderId"] is DBNull))
{
str = Convert.ToString(data["userOrderId"]);
sheet.Write(str);
}
sheet.Write(",");
if (!(data["logFrom"] is DBNull))
{
t = Convert.ToInt32(data["logFrom"]);
}
else
{
t = OrderGenerator.ORDER_FROM_BG_OP;
}
sheet.Write(StrName.s_logFrom[t]);
sheet.Write(",");
if (!(data["finishTime"] is DBNull))
{
str = Convert.ToDateTime(data["finishTime"]).ToString();
sheet.Write(str);
}
sheet.Write(",");
if (!(data["opResult"] is DBNull))
{
t = Convert.ToInt32(data["opResult"]);
}
else
{
t = PlayerReqOrderState.STATE_FINISH;
}
sheet.Write(StrName.s_realTimeOrderState[t]);
sheet.Write(",");
if (t == PlayerReqOrderState.STATE_FAILED)
{
if (!(data["failReason"] is DBNull))
{
t = Convert.ToInt32(data["failReason"]);
sheet.Write(StrName.getRealTimeOrderFailReason(t));
}
}
sheet.Write(",");
sheet.WriteLine();
}
}
catch (System.Exception ex)
{
LogMgr.error(ex.ToString());
}
}
return(OpRes.opres_success);
}
