C# SQL语句拼凑方式

 1 public int UpdPOInfo(string poNum, MdlPOInfo mpoi)
 2         {
 3             StringBuilder sbSql = new StringBuilder();
 4             SqlParameter[] sqlParms;
 5             sbSql.Append("UPDATE Bn_POInfo SET ");
 6             sbSql.Append("PONum=@in_PONum,POETD=@in_POETD,POETA=@in_POETA,POPort=@in_POPort,");
 7             sbSql.Append("POCustomer=@in_POCustomer,POCustPO=@in_POCustPO,POContact=@in_POContact,");
 8             sbSql.Append("POPhone=@in_POPhone,POFax=@in_POFax,PODate=@in_PODate,POStatus=@in_POStatus ");
 9             sbSql.Append("WHERE DeleteFlag=0 AND PONum=@in_PONValue");
10             sqlParms = new SqlParameter[]{
11                 new SqlParameter("@in_PONum", SqlDbType.VarChar, 40) {Value = mpoi.PONum},
12                 new SqlParameter("@in_POETD", SqlDbType.DateTime, 8) {Value = mpoi.POETD},
13                 new SqlParameter("@in_POETA", SqlDbType.DateTime, 8) {Value = mpoi.POETA},
14                 new SqlParameter("@in_POPort", SqlDbType.NVarChar, 80) {Value = mpoi.POPort},
15                 new SqlParameter("@in_POCustomer", SqlDbType.NVarChar, 80) {Value = mpoi.POCustomer},
16                 new SqlParameter("@in_POCustPO", SqlDbType.VarChar, 40) {Value = mpoi.POCustPO},
17                 new SqlParameter("@in_POContact", SqlDbType.NVarChar, 40) {Value = mpoi.POContact},
18                 new SqlParameter("@in_POPhone", SqlDbType.VarChar, 40) {Value = mpoi.POPhone},
19                 new SqlParameter("@in_POFax", SqlDbType.VarChar, 40) {Value = mpoi.POFax},
20                 new SqlParameter("@in_PODate", SqlDbType.DateTime, 8) {Value = mpoi.PODate},
21                 new SqlParameter("@in_POStatus", SqlDbType.NVarChar, 10) {Value = mpoi.POStatus},
22                 new SqlParameter("@in_PONValue",SqlDbType.VarChar,40) {Value = poNum}
23             };
24             return myDbHelper.ExecuteNonQuery(CommandType.Text, sbSql.ToString(), sqlParms);
25         }
26 
27 
28  /// <summary>
29         /// 执行 Transact-SQL 增删改语句并返回受影响的行数。
30         /// </summary>
31         public int ExecuteNonQuery(CommandType cmdType, string cmdText, params DbParameter[] dbParms)
32         {
33             return _iDbHelper.ExecuteNonQuery(_connectionString, cmdType, cmdText, dbParms);
34         }
posted on 2013-11-01 14:58 清风暮雨阅读(714) 评论(0) 收藏举报