/// <summary>
/// 華南賬戶（虛擬帳號） add by zhuoqin0830w 2015/05/13
/// </summary>
/// <param name="orderPayment"></param>
/// <returns></returns>
public string AddPaymentHncb(OrderPaymentHncb orderPayment)
{
StringBuilder strSql = new StringBuilder();
int time = Convert.ToInt32(CommonFunction.GetPHPTime(Convert.ToString(DateTime.Now)));
try
{
//根據條件 獲取 serial 中 serial_value 的 值
StringBuilder strSerialValue = new StringBuilder();
strSerialValue.Append(@"SELECT serial_value FROM serial WHERE serial_id = CONCAT('1',DATE_FORMAT(NOW(),'%y'),QUARTER(NOW()));");
string serialValue = _dbAccess.getDataTable(strSerialValue.ToString()).Rows[0][0].ToString();
// 判斷 獲取的 serial_value 是否 為 空 如果 為空 則 等於 '000001'， 如果 不為空 則 serial_value + 1
StringBuilder strP_hncb_id_1 = new StringBuilder();
strP_hncb_id_1.AppendFormat(@"SELECT IF({0} = '','000001',{0} + 1);", serialValue);
string p_hncb_id_1 = _dbAccess.getDataTable(strP_hncb_id_1.ToString()).Rows[0][0].ToString();
// 根據 p_hncb_id_1 的 值 得到 華南賬戶（虛擬帳號）
StringBuilder strP_hncb_id = new StringBuilder();
strP_hncb_id.AppendFormat(@"SELECT CONCAT('98943',DATE_FORMAT(NOW(),'%y'),QUARTER(NOW()),RIGHT(CONCAT('000000',{0}),6));", p_hncb_id_1);
string p_hncb_id = _dbAccess.getDataTable(strP_hncb_id.ToString()).Rows[0][0].ToString();
//根據得到的虛擬帳號 進行新增 p_hncb_id
strSql.Append("INSERT INTO order_payment_hncb(order_id,bank,entday,txtday,paid,type,hncb_sn,outputbank,e_date,vat_number,error,createdate,updatedate,hncb_id) VALUES({0},");
strSql.AppendFormat(" '0', 0, 0, 0, 1, 0, 0, 0, 0, '00', {0}, {0}, '{1}');", time, p_hncb_id);
// 根據獲取的 p_hncb_id_1 進行 修改
strSql.AppendFormat("UPDATE serial SET serial_value = {0} WHERE serial_id = CONCAT('1',DATE_FORMAT(NOW(),'%y'),QUARTER(NOW()));", p_hncb_id_1);
return strSql.ToString();
}
catch (Exception ex)
{
throw new Exception("OrderPaymentHncbDao-->AddPaymentHncb-->" + strSql.ToString() + ex.Message, ex);
}
}
/// <summary>
/// 華南賬戶（虛擬帳號） add by zhuoqin0830w 2015/05/13
/// </summary>
/// <param name="orderPayment"></param>
/// <returns></returns>
public string AddPaymentHncb(OrderPaymentHncb orderPayment)
{
try
{
return _orderPaymentHncbDao.AddPaymentHncb(orderPayment);
}
catch (Exception ex)
{
throw new Exception("OrderPaymentHncbDao-->AddPaymentHncb-->" + ex.Message, ex);
}
}