C#中的语句格式问题
如果想将如下语句:
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);
请教:应该怎么写呢?
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);
请教:应该怎么写呢?
...全文
相关推荐
基于Vue的营销收费系统设计源码demo
该项目是一个基于Vue框架开发的营销收费系统演示源码,共计79个文件,包括42个Vue组件文件、14个JavaScript脚本文件、8个PNG图像文件、3个JSON配置文件、2个CSS样式文件以及少量其他文件。该系统以Vue和JavaScript为主要编程语言,辅以CSS进行界面美化,旨在为用户提供一个高效、便捷的营销收费解决方案。
LeetCode——561,数组拆分 I
/** * \* Created: liuhuichao * \* Date: 2019/4/23 * \* Time: 5:43 PM * \* Description: 数组拆分 I * 给定长度为 2n 的数组, 你的任务是将这些数分成 n 对, 例如 (a1, b1), (a2, b2), ..., (an, bn) ,使得从1 到 n 的 min(ai, bi) 总和最大。 ...
基于Vue框架的taz-crm-demo营销部流程审批管理系统设计源码
本项目为天安智能电网科技公司定制研发的基于Vue框架的营销部流程审批管理系统demo,源码共计188个文件,其中包含71个Java文件、27个Vue文件、22个JavaScript文件、9个XML配置文件、6个PNG图片文件、5个CSS文件、5个字体文件、4个JPG图片文件、4个JSON文件、4个映射文件。该系统于2024年7月完成,旨在提高营销部流程审批效率。
Demo
演示版
婚庆酒店项目demo
婚庆酒店项目demo


