/// <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:shwang
/// Date:20140704
/// Desc:得到渤海冻结数量
/// </summary>
/// <param name="lendingSideID">放贷方ID</param>
/// <param name="serviceSideID">服务方ID</param>
/// <returns>冻结数量</returns>
private int GetBHFrozenCount(int lendingSideID, int serviceSideID)
{
SqlParameter lendingSideIDPara = new SqlParameter("@LendingSideID", lendingSideID);
SqlParameter serviceSideIDPara = new SqlParameter("@ServiceSideID", serviceSideID);
SqlHelperCommon sqlHelper = new SqlHelperCommon("PostLoanDB");
object countObj = sqlHelper.ExecuteScalar(CommandType.StoredProcedure
, "proc_FinanceManage_GetBHFrozenCount",
new SqlParameter[] { lendingSideIDPara, serviceSideIDPara });
if (countObj == null || countObj == DBNull.Value)
{
return(-1);
}
return(Convert.ToInt32(countObj));
}
/// <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);
}
