C#中的语句格式问题

gpz_dalian gpz_dalian 墨衍会员 · AI 创作全网分发 墨衍智能分发 通过墨衍一键同步至各平台 可同步平台 CSDN微信公众号微博知乎掘金百家号博客园抖音小红书 你的文章也可以这样分发 墨衍会员 ¥399起/年,写一次发全网 我也要 + 加入社区
如果想将如下语句:
string sqlInsert = @"insert into HTPOrderTransaction values("
+ "'" + storeCode + "'" + ","
+ "'" + terminalID + "'" + ","
+ "'" + sequenceNo + "'" + ","
+ "'" + employeeCode + "'" + ","
+ "'" + scheduleDate + "'" + ","
+ "'" + barCode + "'" + ","
+ "'" + quantity + "'" + ","
+ "'" + entryDate + "'" + ","
+ "'" + createDate + "'" + ","
+ "'" + amendDate + "'" + ")";
改写成如下格式:
string sqlSelect = string.Format(@"select StoreCode,TerminalID,SequenceNo from
HTPOrderTransaction where StoreCode = {0}
and TerminalID = '{1}' and SequenceNo = {2}",storeCode,terminalID,sequenceNo);
请教:应该怎么写呢?

...全文

相关推荐

评论 5
收藏 已收藏
分享
返回顶部
gpz_dalian
C# 111,129 成员 642,540 内容