/// <summary>
/// 增加一条数据
/// </summary>
//public int Add(ManagementCenter.Model.QH_ConsignQuantum model)
//{
// return qH_ConsignQuantumDAL.Add(model);
//}
///// <summary>
///// 更新一条数据
///// </summary>
//public void Update(ManagementCenter.Model.QH_ConsignQuantum model)
//{
// qH_ConsignQuantumDAL.Update(model);
//}
///// <summary>
///// 删除一条数据
///// </summary>
//public void Delete(int ConsignQuantumID)
//{
// qH_ConsignQuantumDAL.Delete(ConsignQuantumID);
//}
/// <summary>
/// 添加交易规则和单笔最大委托量
/// </summary>
/// <param name="qHConsignQuantum">交易规则实体</param>
/// <param name="qHSingleRequestQuantityl">单笔最大委托量实体</param>
/// /// <param name="qHSingleRequestQuantity2">单笔最大委托量实体</param>
/// <returns></returns>
public int AddQHConsignQuantumAndSingle(QH_ConsignQuantum qHConsignQuantum,
QH_SingleRequestQuantity qHSingleRequestQuantityl,
QH_SingleRequestQuantity qHSingleRequestQuantity2)
{
QH_ConsignQuantumDAL qHConsignQuantumDAL = new QH_ConsignQuantumDAL();
QH_SingleRequestQuantityDAL qHSingleRequestQuantityDAL = new QH_SingleRequestQuantityDAL();
DbConnection Conn = null;
Database db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
DbTransaction Tran = Conn.BeginTransaction();
int consignQuantumID = AppGlobalVariable.INIT_INT;
try
{
consignQuantumID = qHConsignQuantumDAL.Add(qHConsignQuantum, Tran, db);
if (consignQuantumID != AppGlobalVariable.INIT_INT)
{
if (qHSingleRequestQuantityl != null)
{
qHSingleRequestQuantityl.ConsignQuantumID = consignQuantumID;
qHSingleRequestQuantityDAL.Add(qHSingleRequestQuantityl, Tran, db);
}
if (qHSingleRequestQuantity2 != null)
{
qHSingleRequestQuantity2.ConsignQuantumID = consignQuantumID;
qHSingleRequestQuantityDAL.Add(qHSingleRequestQuantity2, Tran, db);
}
Tran.Commit();
}
return(consignQuantumID);
}
catch (Exception ex)
{
Tran.Rollback();
string errCode = "GL-6020";
string errMsg = "添加交易规则和单笔最大委托量失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(consignQuantumID);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
/// <summary>
/// 根据交易规则委托量标识删除交易规则和单笔最大委托量
/// </summary>
/// <param name="ConsignQuantumID">交易规则委托量ID</param>
/// <param name="tran"></param>
/// <param name="db"></param>
/// <param name="falg">标记是否使用了外部事务</param>
/// <returns></returns>
public bool DeleteQHConsignQuantumAndSingle(int ConsignQuantumID, DbTransaction tran, Database db, bool falg)
{
QH_ConsignQuantumDAL qHConsignQuantumDAL = new QH_ConsignQuantumDAL();
QH_SingleRequestQuantityDAL qHSingleRequestQuantityDAL = new QH_SingleRequestQuantityDAL();
DbConnection Conn = null;
try
{
//创建本地事务
if (db == null && tran == null)
{
db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
tran = Conn.BeginTransaction();
}
qHSingleRequestQuantityDAL.DeleteSingleRQByConsignQuantumID(ConsignQuantumID, tran, db);
qHConsignQuantumDAL.Delete(ConsignQuantumID, tran, db);
if (!falg)
{
tran.Commit();
}
return(true);
}
catch (Exception ex)
{
if (!falg)
{
tran.Rollback();
}
string errCode = "GL-6022";
string errMsg = "根据交易规则委托量标识删除交易规则和单笔最大委托量失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(false);
}
finally
{
if (Conn != null && Conn.State == ConnectionState.Open)
{
if (!falg)
{
Conn.Close();
}
}
}
}
/// <summary>
/// 根据交易规则委托量ID获取单笔委托量
/// </summary>
/// <param name="ConsignQuantumID">交易规则委托量ID</param>
/// <returns></returns>
public ManagementCenter.Model.QH_SingleRequestQuantity GetQHSingleRequestQuantityModelByConsignQuantumID(int ConsignQuantumID)
{
try
{
QH_SingleRequestQuantityDAL qHSingleRequestQuantityDAL = new QH_SingleRequestQuantityDAL();
return(qH_SingleRequestQuantityDAL.GetQHSingleRequestQuantityModelByConsignQuantumID(ConsignQuantumID));
}
catch (Exception ex)
{
string errCode = "GL-6041";
string errMsg = "根据交易规则委托量ID获取单笔委托量失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(null);
}
}
///// <summary>
///// 增加一条数据
///// </summary>
//public int Add(ManagementCenter.Model.QH_SingleRequestQuantity model)
//{
// return qH_SingleRequestQuantityDAL.Add(model);
//}
///// <summary>
///// 更新一条数据
///// </summary>
//public void Update(ManagementCenter.Model.QH_SingleRequestQuantity model)
//{
// qH_SingleRequestQuantityDAL.Update(model);
//}
///// <summary>
///// 删除一条数据
///// </summary>
//public void Delete(int SingleRequestQuantityID)
//{
// qH_SingleRequestQuantityDAL.Delete(SingleRequestQuantityID);
//}
#region 根据单笔委托量标识获取单笔委托量实体
/// <summary>
/// 根据单笔委托量标识获取单笔委托量实体
/// </summary>
/// <param name="SingleRequestQuantityID">单笔委托量标识</param>
/// <returns></returns>
public ManagementCenter.Model.QH_SingleRequestQuantity GetQHSingleRequestQuantityModel(int SingleRequestQuantityID)
{
try
{
QH_SingleRequestQuantityDAL qHSingleRequestQuantityDAL = new QH_SingleRequestQuantityDAL();
return(qH_SingleRequestQuantityDAL.GetModel(SingleRequestQuantityID));
}
catch (Exception ex)
{
string errCode = "GL-6040";
string errMsg = "根据单笔委托量标识获取单笔委托量实体失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(null);
}
}
/// <summary>
/// 更新交易规则和单笔最大委托量
/// </summary>
/// <param name="qHConsignQuantum">交易规则实体</param>
/// <param name="qHSingleRequestQuantity1">单笔最大委托量实体</param>
/// <param name="qHSingleRequestQuantity2">单笔最大委托量实体</param>
/// <returns></returns>
public bool UpdateQHConsignQuantumAndSingle(QH_ConsignQuantum qHConsignQuantum,
QH_SingleRequestQuantity qHSingleRequestQuantity1,
QH_SingleRequestQuantity qHSingleRequestQuantity2)
{
QH_ConsignQuantumDAL qHConsignQuantumDAL = new QH_ConsignQuantumDAL();
QH_SingleRequestQuantityDAL qHSingleRequestQuantityDAL = new QH_SingleRequestQuantityDAL();
DbConnection Conn = null;
Database db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
DbTransaction Tran = Conn.BeginTransaction();
try
{
qHConsignQuantumDAL.Update(qHConsignQuantum);
if (qHSingleRequestQuantity1 != null)
{
qHSingleRequestQuantityDAL.Update(qHSingleRequestQuantity1);
}
if (qHSingleRequestQuantity2 != null)
{
qHSingleRequestQuantityDAL.Update(qHSingleRequestQuantity2);
}
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
string errCode = "GL-6021";
string errMsg = "更新交易规则和单笔最大委托量失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(false);
}
finally
{
if (Conn != null && Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
/// <summary>
///根据品种标识,删除期货品种交易规则(规则相关表全部删除)
/// </summary>
/// <param name="BreedClassID">品种标识</param>
/// <returns></returns>
public bool DeleteFuturesTradeRulesAboutAll(int BreedClassID)
{
QH_FuturesTradeRulesDAL qHFuturesTradeRulesDAL = new QH_FuturesTradeRulesDAL();
QH_AgreementDeliveryMonthDAL qH_AgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
QH_ConsignQuantumDAL qH_ConsignQuantumDAL = new QH_ConsignQuantumDAL();
QH_SingleRequestQuantityDAL qH_SingleRequestQuantityDAL = new QH_SingleRequestQuantityDAL();
QH_LastTradingDayDAL qH_LastTradingDayDAL = new QH_LastTradingDayDAL();
DbConnection Conn = null;
Database db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
DbTransaction Tran = Conn.BeginTransaction();
try
{
int ConsignQuantumID = AppGlobalVariable.INIT_INT;
int LastTradingDayID = AppGlobalVariable.INIT_INT;
QH_FuturesTradeRules qHFuturesTradeRules = new QH_FuturesTradeRules();
qHFuturesTradeRules = qHFuturesTradeRulesDAL.GetModel(BreedClassID);
if (qHFuturesTradeRules != null)
{
if (!string.IsNullOrEmpty(qHFuturesTradeRules.ConsignQuantumID.ToString()))
{
ConsignQuantumID = Convert.ToInt32(qHFuturesTradeRules.ConsignQuantumID);
}
if (!string.IsNullOrEmpty(qHFuturesTradeRules.LastTradingDayID.ToString()))
{
LastTradingDayID = Convert.ToInt32(qHFuturesTradeRules.LastTradingDayID);
}
if (ConsignQuantumID != AppGlobalVariable.INIT_INT)
{
if (!qH_SingleRequestQuantityDAL.DeleteSingleRQByConsignQuantumID(ConsignQuantumID, Tran, db))
{
Tran.Rollback();
return(false);
}
}
List <Model.QH_AgreementDeliveryMonth> qHAgreementDeliveryM =
qH_AgreementDeliveryMonthDAL.GetListArray(string.Format("BreedClassID={0}", BreedClassID), Tran,
db);
foreach (Model.QH_AgreementDeliveryMonth MonthID in qHAgreementDeliveryM)
{
if (!qH_AgreementDeliveryMonthDAL.Delete((Int32)MonthID.MonthID, BreedClassID)) //?处理
{
Tran.Rollback();
return(false);
}
}
if (!qHFuturesTradeRulesDAL.Delete(BreedClassID, Tran, db))
{
Tran.Rollback();
return(false);
}
if (ConsignQuantumID != AppGlobalVariable.INIT_INT)
{
if (!qH_ConsignQuantumDAL.Delete(ConsignQuantumID, Tran, db))
{
Tran.Rollback();
return(false);
}
}
if (LastTradingDayID != AppGlobalVariable.INIT_INT)
{
if (!qH_LastTradingDayDAL.Delete(LastTradingDayID, Tran, db))
{
Tran.Rollback();
return(false);
}
}
}
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
string errCode = "GL-6004";
string errMsg = " 根据品种标识,删除期货品种交易规则(规则相关表全部删除)失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(false);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
