private static void GetSql(DateTime dt, string dd102)
{//当前登录人
string userName = SessionAuth.UserName.ToSimplifiedIfTraditional();
//当前服务器时间
DateTime serverDateTime = WinSrv.ServerDateTime;
string sql = string.Format(@"
INSERT INTO TA_LogisticsXD(
DD_102, DD_103, DD_104, DD_105, DD_106, DD_107, DD_108, DD_109, DD_110,
DD_111, DD_112, DD_113, DD_114, DD_115, DD_116, DD_122, DD_125, DD_126, DD_127,
DD_128, DD_129, DD_130, DD_131, DD_132, DD_133, DD_134, DD_135, DD_136, DD_137,
DD_139, DD_140, DD_141, DD_142, DD_143, DD_144, DD_145, DD_146, DD_147, DD_148,
DD_149, DD_152, TranFlag, DD_153, DD_154, DD_155, DD_156, DD_157, DD_158, DD_159,
DD_160, DD_161, DD_162, DD_163, DD_164, DD_165, DD_166, DD_168, DD_169, DD_170,
DD_171, DD_172, DD_173, DD_Flag, DD_174, DD_175, DD_177, DD_178, DD_179, DD_180,
DD_181, DD_182, DD_183, DD_184, DD_138, DD_219,
DD_185, DD_186, DD_151, DD_187, DD_188, DD_189, DD_190, DD_191, DD_192, DD_193,
DD_194, DD_195, CallState, CallCount, LastCall, DD_196, DD_197, DD_198, DD_199,
DD_200, BackComtoWeigh, DD_209, DD_210,ManageCode, PayStation, DD_201, DD_202,
DD_203, DD_207, DD_208, DD_212, DD_213, DD_214, DD_215, DD_216, DD_217, DD_218,DD_222,DD_226)
SELECT DD_102, DD_103, DD_104, DD_105, DD_106, DD_107, DD_108, DD_109, DD_110,
DD_111, DD_112, DD_113, DD_114, DD_115, DD_116, DD_122, DD_125, DD_126, DD_127,
DD_128, DD_129, DD_130, DD_131, DD_132,'" + dt + @"' AS DD_133, DD_134, DD_135, DD_136, DD_137,
DD_139, DD_140, DD_141, DD_142, DD_143, DD_144, DD_145, DD_146, DD_147, DD_148,
DD_149, DD_152, TranFlag, DD_153, DD_154, DD_155, DD_156, DD_157, DD_158, DD_159,
DD_160, DD_161, 1,'" + userName + @"' AS DD_163,'" + serverDateTime + @"'AS DD_164, DD_165, DD_166, DD_168, DD_169, DD_170,
DD_171, DD_172, DD_173, DD_Flag, DD_174, DD_175, DD_177, DD_178, DD_179, DD_180,
DD_181, DD_182, DD_183, DD_184, DD_138, DD_219,
DD_185, DD_186, DD_151, DD_187, DD_188, DD_189, DD_190, DD_191, DD_192, DD_193,
DD_194, DD_195, CallState, CallCount, LastCall, DD_196, DD_197, DD_198, DD_199,
DD_200, BackComtoWeigh, DD_209, DD_210,ManageCode, PayStation, DD_201, DD_202,
DD_221, DD_207, DD_208, DD_212, DD_213, DD_214, DD_215, DD_216, DD_217, DD_218,DD_222,DD_226
FROM TB_CompanyYC WHERE DD_102=@arg0 --DD_102:下单编码
");
WinSrv.ExecuteNonQuery(sql, new object[] { dd102 });
}