/// <summary>
        /// 为导出订单解锁(错误订单解锁、正常回盘解锁)
        /// </summary>
        /// <param name="serid"></param>
        public void SetBusinessUnLock(string lockkey)
        {
            string sql = string.Format("update Business set FrozenNo='' where FrozenNo='{0}'", lockkey);

            SqlHelperCommon sqlHelper = new SqlHelperCommon("PostLoanDB");

            sqlHelper.ExecuteNonQuery(CommandType.Text, sql, 100000, null);
        }
        /// <summary>
        /// 为导出订单加锁
        /// </summary>
        /// <param name="serid"></param>
        private string SetBusinessLock(int serid, int lendingid)
        {
            string lockkey = Crypto.GetFrozenNo((byte)EnumPayKind.Payment_Bank);
            string sql     = "SQL\\BankExport\\PayBankBusinessLock.sql".ToFileContent(true, lockkey, serid, lendingid);

            SqlHelperCommon sqlHelper = new SqlHelperCommon("PostLoanDB");

            sqlHelper.ExecuteNonQuery(CommandType.Text, sql, 100000, null);
            return(lockkey);
        }
        /// <summary>
        /// Author:王正吉
        /// Description:注销所有正在提前清贷中的订单
        /// </summary>
        private string AnnulCLoanByBusinessesByBoHai(string companyKey, string lendingSide)
        {
            SqlHelperCommon sqlHelper = new SqlHelperCommon("PostLoanDB");

            var    querySql   = "SQL\\AdvCLoanCancel\\SELECT_BUSINESS_ADVCLOANING.sql".ToFileContent(true, companyKey, lendingSide);
            var    reader     = sqlHelper.ExecuteReader(CommandType.Text, querySql, null);
            string strContent = string.Empty;

            while (reader.Read())
            {
                strContent += string.Format("{0}\t{1}\t{2}\r\n", reader.GetInt32(0), reader.GetString(1),
                                            reader.GetString(2));
            }

            reader.Close();
            var sql = "SQL\\AdvCLoanCancel\\UPDATE_BUSINESS_FORADVCLOAN.sql".ToFileContent(true, companyKey, lendingSide);

            sqlHelper.ExecuteNonQuery(CommandType.Text, sql, null);
            return(strContent);
        }