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