private Dictionary <string, int> _QueryEachDayChargeYB(DBManager dbMgr, string fromDate, string toDate, string userid, int zoneid)
{
Dictionary <string, int> result;
if (dbMgr == null || string.IsNullOrEmpty(fromDate) || string.IsNullOrEmpty(toDate) || string.IsNullOrEmpty(userid))
{
result = null;
}
else
{
Dictionary <string, int> eachDayChargeYB = new Dictionary <string, int>();
MySQLConnection conn = null;
try
{
string cmdText = string.Format("SELECT SUM(amount) as total,DATE_FORMAT(inputtime,'%Y-%m-%d') as inputdate FROM t_inputlog WHERE u='{0}' AND inputtime >='{1}' AND inputtime <= '{2}' AND zoneid={3} AND result='success' GROUP BY inputdate UNION ALL SELECT SUM(amount) as total,DATE_FORMAT(inputtime,'%Y-%m-%d') as inputdate FROM t_inputlog2 WHERE u='{0}' AND inputtime >='{1}' AND inputtime <= '{2}' AND zoneid={3} AND result='success' GROUP BY inputdate", new object[]
{
userid,
fromDate,
toDate,
zoneid
});
GameDBManager.SystemServerSQLEvents.AddEvent(string.Format("+SQL: {0}", cmdText), EventLevels.Important);
conn = dbMgr.DBConns.PopDBConnection();
MySQLCommand cmd = new MySQLCommand(cmdText, conn);
try
{
MySQLDataReader reader = cmd.ExecuteReaderEx();
while (reader.Read())
{
string inputDate = reader["inputdate"].ToString();
int inputMoney = Convert.ToInt32(reader["total"].ToString());
if (!eachDayChargeYB.ContainsKey(inputDate))
{
eachDayChargeYB.Add(inputDate, inputMoney);
}
else
{
Dictionary <string, int> dictionary;
string key;
(dictionary = eachDayChargeYB)[key = inputDate] = dictionary[key] + inputMoney;
}
}
}
catch (MySQLException)
{
LogManager.WriteLog(LogTypes.Error, string.Format("读取数据库失败: {0}", cmdText), null, true);
}
cmd.Dispose();
cmd = null;
}
finally
{
if (null != conn)
{
dbMgr.DBConns.PushDBConnection(conn);
}
}
result = eachDayChargeYB;
}
return(result);
}
private void Read(ref List<string[]> result)
{
oraRD = cmd.ExecuteReaderEx();
int n = oraRD.FieldCount;
while (oraRD.Read())
{
string[] oneResult = new string[n];
for (int i = 0; i < n; i++)
{
oneResult[i] = oraRD[i].ToString();
}
result.Add(oneResult);
}
oraRD.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
string strCategory = Request.QueryString["Category"].ToString();
MySQLConnection conn = new MySQLConnection(new MySQLConnectionString("192.168.1.250", "discuz_bbs", "cupid", "qweqwe123").AsString);
//Response.Write("Connecting to database");
try
{
conn.Open();
}
catch (Exception ex)
{
Response.Write(ex.Message);
return;
}
MySQLCommand cmd = new MySQLCommand("set names gb2312", conn);
cmd.ExecuteNonQuery();
if (strCategory == "1")
{
cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `cdb_threads` WHERE fid = 8 ORDER BY dateline DESC LIMIT 0,5", conn);
//cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `pre_forum_thread` WHERE fid = 8 ORDER BY dateline DESC LIMIT 0,7", conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
while (reader.Read())
{
//Response.Write(string.Format("{0}---{1}---{2}---{3}<br>", reader["tid"], reader["author"], reader["subject"].ToString().Replace("??", "--"), reader["views"]));
sb.Append(string.Format("<a target=\"_blank\" title=\"{1}\" href=\"http://192.168.1.250/viewthread.php?tid={0}&extra=page%3D1\">{2}{1}</a>\r\n", reader["tid"], reader["subject"].ToString().Replace("??", "--"), ShowFidName(reader["fid"])));
//sb.Append(string.Format("<a target=\"_blank\" title=\"{1}\" href=\"http://192.168.1.250/forum.php?mod=viewthread&tid={0}&extra=page%3D1\">{2}{1}</a>\r\n", reader["tid"], reader["subject"].ToString().Replace("??", "--"), ShowFidName(reader["fid"])));
}
strContent = sb.ToString();
reader.Close();
cmd.Dispose();
conn.Close();
}
if (strCategory == "11")
{
cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `cdb_threads` WHERE fid = 8 ORDER BY dateline DESC LIMIT 5,5", conn);
//cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `pre_forum_thread` WHERE fid = 8 ORDER BY dateline DESC LIMIT 7,7", conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
while (reader.Read())
{
//Response.Write(string.Format("{0}---{1}---{2}---{3}<br>", reader["tid"], reader["author"], reader["subject"].ToString().Replace("??", "--"), reader["views"]));
sb.Append(string.Format("<a target=\"_blank\" title=\"{1}\" href=\"http://192.168.1.250/viewthread.php?tid={0}&extra=page%3D1\">{2}{1}</a>\r\n", reader["tid"], reader["subject"].ToString().Replace("??", "--"), ShowFidName(reader["fid"])));
}
strContent = sb.ToString();
reader.Close();
cmd.Dispose();
conn.Close();
}
if (strCategory == "2")
{
cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `cdb_threads` WHERE fid not in (8,16,18) ORDER BY dateline DESC LIMIT 0,7", conn);
//cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `pre_forum_thread` WHERE fid not in (8,16,18) ORDER BY dateline DESC LIMIT 0,7", conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
while (reader.Read())
{
//Response.Write(string.Format("{0}---{1}---{2}---{3}<br>", reader["tid"], reader["author"], reader["subject"].ToString().Replace("??", "--"), reader["views"]));
sb.Append(string.Format("<a target=\"_blank\" title=\"{1}\" href=\"http://192.168.1.250/viewthread.php?tid={0}&extra=page%3D1\">{2}{1}</a>\r\n", reader["tid"], reader["subject"].ToString().Replace("??", "--"), ShowFidName(reader["fid"])));
}
strContent = sb.ToString();
reader.Close();
cmd.Dispose();
conn.Close();
}
if (strCategory == "3")
{
cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `cdb_threads` WHERE fid not in (8,16,18) ORDER BY dateline DESC LIMIT 7,7", conn);
//cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `pre_forum_thread` WHERE fid not in (8,16,18) ORDER BY dateline DESC LIMIT 7,7", conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
while (reader.Read())
{
//Response.Write(string.Format("{0}---{1}---{2}---{3}<br>", reader["tid"], reader["author"], reader["subject"].ToString().Replace("??", "--"), reader["views"]));
sb.Append(string.Format("<a target=\"_blank\" title=\"{1}\" href=\"http://192.168.1.250/viewthread.php?tid={0}&extra=page%3D1\">{2}{1}</a>\r\n", reader["tid"], reader["subject"].ToString().Replace("??", "--"), ShowFidName(reader["fid"])));
}
strContent = sb.ToString();
reader.Close();
cmd.Dispose();
conn.Close();
}
//huodong1
if (strCategory == "4")
{
cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `cdb_threads` WHERE fid = 18 ORDER BY dateline DESC LIMIT 0,7", conn);
//cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `pre_forum_thread` WHERE fid = 18 ORDER BY dateline DESC LIMIT 0,7", conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
while (reader.Read())
{
//Response.Write(string.Format("{0}---{1}---{2}---{3}<br>", reader["tid"], reader["author"], reader["subject"].ToString().Replace("??", "--"), reader["views"]));
sb.Append(string.Format("<a target=\"_blank\" title=\"{1}\" href=\"http://192.168.1.250/viewthread.php?tid={0}&extra=page%3D1\">{2}{1}</a>\r\n", reader["tid"], reader["subject"].ToString().Replace("??", "--"), ShowFidName(reader["fid"])));
}
strContent = sb.ToString();
reader.Close();
cmd.Dispose();
conn.Close();
}
//huodong2
if (strCategory == "5")
{
cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `cdb_threads` WHERE fid = 18 ORDER BY dateline DESC LIMIT 7,7", conn);
//cmd = new MySQLCommand("SELECT fid,tid,author,subject,views FROM `pre_forum_thread` WHERE fid = 18 ORDER BY dateline DESC LIMIT 7,7", conn);
MySQLDataReader reader = cmd.ExecuteReaderEx();
while (reader.Read())
{
//Response.Write(string.Format("{0}---{1}---{2}---{3}<br>", reader["tid"], reader["author"], reader["subject"].ToString().Replace("??", "--"), reader["views"]));
sb.Append(string.Format("<a target=\"_blank\" title=\"{1}\" href=\"http://192.168.1.250/viewthread.php?tid={0}&extra=page%3D1\">{2}{1}</a>\r\n", reader["tid"], reader["subject"].ToString().Replace("??", "--"), ShowFidName(reader["fid"])));
}
strContent = sb.ToString();
reader.Close();
cmd.Dispose();
conn.Close();
}
//MySQLCommand commn = new MySQLCommand("set names gb2312", conn);
//commn.ExecuteNonQuery();
//DataTable dt = new MySQLSelectCommand(conn, new string[] { "tid", "author", "subject", "views" }, new string[] { "cdb_threads" }, null, null, null, true, 0, 10, false).Table;
//foreach (DataRow row in dt.Rows)
//{
// Response.Write(string.Format("{0}---{1}---{2}---{3}", row["tid"], row["author"], row["subject"], row["views"]));
//}
//dt.Dispose();
//commn.Dispose();
}
