/// <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); }