关于hashtable用法举例之二

最新推荐文章于 2024-01-15 13:55:06 发布

fx1650699432

最新推荐文章于 2024-01-15 13:55:06 发布

阅读量343

点赞数

CC 4.0 BY-SA版权

分类专栏： .net

本文链接：https://blog.youkuaiyun.com/fx1650699432/article/details/8293261

.net 专栏收录该内容

16 篇文章

订阅专栏

本文介绍了一个使用Hashtable存储评估信息并将其插入到数据库的过程。通过构造SQL语句，该过程实现了向TF_FLOW_INST_APPRAISE表中添加记录的功能。此外，还详细展示了如何使用OraHelper执行SQL语句及异常处理。

Hashtable addInfo = new Hashtable();
   addInfo["FLOW_INST_NO"] = strFLOW_INST_NO;
   addInfo["APPRAISE_USER_NO"] = "";
   addInfo["APPRAISE_USER_NM"] = "";
   addInfo["APPRAISE_IP"] = strIP;
   addInfo["APPRAISE_RESULT"] = strAPPRAISE_RESULT;
   addInfo["APPRAISE_DETAIL"] = strAPPRAISE_DETAIL;

CtlF019901 ctlF019901 = new CtlF019901(this);
int intReturn = ctlF019901.AddAppraiseInfo(addInfo);

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;