string bm1,bm2,bm3,bm4;
string yy="";
string mm = "";
if (CreateTime1.Text != "")
{
yy = CreateTime1.Text.Substring(0, 4);
}
if (CreateTime2.Text != "")
{
mm = CreateTime2.Text.Substring(5, 1);
}
bm1 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm+ "_1]";
bm2 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm + "_2]";
bm3 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm + "_3]";
bm4 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm + "_4]";
GetSingleUserInfo(" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm1 + " where [BankSessionID]='" + BankSessionID.Text + "'UNION " +
" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm2 + " where [BankSessionID]='" + BankSessionID.Text + "'UNION " +
" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm3 + " where [BankSessionID]='" + BankSessionID.Text + "'UNION " +
" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm4 + " where [BankSessionID]='" + BankSessionID.Text + "'"); 提示:<script>alert('对象名 'NewWorldLog.dbo.BankLog_测试__0_1' 无效。')</script>数据库里的表名为 类似 [NewWorldLog].[dbo].[BankLog_测试_2009_06_2]
string yy="";
string mm = "";
if (CreateTime1.Text != "")
{
yy = CreateTime1.Text.Substring(0, 4);
}
if (CreateTime2.Text != "")
{
mm = CreateTime2.Text.Substring(5, 1);
}
bm1 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm+ "_1]";
bm2 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm + "_2]";
bm3 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm + "_3]";
bm4 = "[NewWorldLog].[dbo].[BankLog_测试_" + yy + "_0" + mm + "_4]";
GetSingleUserInfo(" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm1 + " where [BankSessionID]='" + BankSessionID.Text + "'UNION " +
" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm2 + " where [BankSessionID]='" + BankSessionID.Text + "'UNION " +
" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm3 + " where [BankSessionID]='" + BankSessionID.Text + "'UNION " +
" SELECT [ExtID] ,[GameSvr] ,[CreateTime],[Why],[BankSessionID],[OP],[UserIP] FROM " + bm4 + " where [BankSessionID]='" + BankSessionID.Text + "'"); 提示:<script>alert('对象名 'NewWorldLog.dbo.BankLog_测试__0_1' 无效。')</script>数据库里的表名为 类似 [NewWorldLog].[dbo].[BankLog_测试_2009_06_2]
try
{
d = Convert.ToDateTime(CreateTime1.Text + "-" + CreateTime2.Text + "-1"));
}
catch
{
d = DateTime.Now;
}StringBuilder sb = new StringBuilder("");for(int i = 0; i < 4; i++)
{
sb.Append(string.Format(" SELECT [ExtID] .... form {0} where [BankSessionID]='{1}' ",
string.Format("[NewWorldLog].[dbo].[BankLog_测试_{0}_{1}]", d.ToString("yyyy_MM"), i + 1),
BankSessionID.Text));
if( i < 3) sb.Append(" UNION ");
}GetSingleUserInfo(sb.ToString());
'NewWorldLog' 附近有语法错误。
'NewWorldLog' 附近有语法错误。
'NewWorldLog' 附近有语法错误。')</script>真想找个师傅啊 拜师学艺 好多不懂的