关于 StringBuilder 用法举例

最新推荐文章于 2024-06-25 08:39:40 发布

fx1650699432

最新推荐文章于 2024-06-25 08:39:40 发布

阅读量420

点赞数

分类专栏： .net

本文链接：https://blog.csdn.net/fx1650699432/article/details/8293264

版权

.net 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

首先，需要调用命名空间 using System.Text;

其次，public int AddAppraiseInfo(Hashtable htInsert)
  {
   int intRes=0;
   StringBuilder strBuilder = new StringBuilder();

   strBuilder.Append("insert into TF_FLOW_INST_APPRAISE(APPRAISE_NO,FLOW_INST_NO,APPRAISE_USER_NO,APPRAISE_USER_NM,APPRAISE_IP,APPRAISE_RESULT,APPRAISE_DETAIL,APPRAISE_DATE) ");
   strBuilder.Append(" values(SQ_TF_FLOW_INST_APPRAISE_NO.NEXTVAL,");
   strBuilder.Append("'"+ htInsert["FLOW_INST_NO"] +"', ");
   strBuilder.Append("'"+ htInsert["APPRAISE_USER_NO"] +"', ");
   strBuilder.Append("'"+ htInsert["APPRAISE_USER_NM"] +"', ");
   strBuilder.Append("'"+ htInsert["APPRAISE_IP"] +"', ");
   strBuilder.Append("'"+ htInsert["APPRAISE_RESULT"] +"', ");
   strBuilder.Append("'"+ htInsert["APPRAISE_DETAIL"] +"', ");
   strBuilder.Append("to_date( '" + Utility.GetSysDateLong() + "','yyyy-mm-dd hh24:mi:ss'))");

   using(OraHelper oraHelper = new OraHelper())
   {
    try
    {
     intRes = oraHelper.ExecuteSql(strBuilder.ToString());
    }
    catch(Exception e)
    {
     AppLoger.WriteLog(this, FrameWorkPara.ERROR_LOG, "CtlF019901.AddAppraiseInfo" + e.Message);
     //ShowError(e);
    }
   }
   return intRes;
  }