示例#1
0
 public void RunProcedure_one(string sProcName, string ddate)
 {
     try
     {
         MyDbHelper       DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs);
         OleDbParameter[] sqlparam = new OleDbParameter[2];
         sqlparam[0] = MyDbHelper.MakeInParam("ddate", OleDbType.Char, 8, ddate);
         sqlparam[1] = MyDbHelper.MakeOutParam("ret", OleDbType.Char, 200, null);
         DbHelper.ExecuteNonQuery(sProcName.Trim(), sqlparam, true);
     }
     catch (Exception ex)
     {
         MyLog.Log("3", "执行单日期" + sProcName + "存储过程流程时发生异常:" + ex.Message);
     }
     finally
     {
         if (DbHelper != null)
         {
             DbHelper.Dispose();//新加的
         }
     }
 }
示例#2
0
 public void RunProcedure(string sProcName, string beginDate, string endDate, string constr)
 {
     try
     {
         MyDbHelper       DbHelper = new MyDbHelper(constr);
         OleDbParameter[] sqlparam = new OleDbParameter[3];
         sqlparam[0] = MyDbHelper.MakeInParam("date1", OleDbType.Char, 8, beginDate);
         sqlparam[1] = MyDbHelper.MakeInParam("date2", OleDbType.Char, 8, endDate);
         sqlparam[2] = MyDbHelper.MakeOutParam("ret", OleDbType.Char, 200, null);
         DbHelper.ExecuteNonQuery(sProcName.Trim(), sqlparam, true);
     }
     catch (Exception ex)
     {
         MyLog.Log("3", "执行双日期" + sProcName + "存储过程流程时发生异常:" + ex.Message);
     }
     finally
     {
         if (DbHelper != null)
         {
             DbHelper.Dispose();//新加的
         }
     }
 }