/// <summary>
/// 根据品种获取最后交易日实体
/// </summary>
/// <param name="breedclass"></param>
/// <returns></returns>
public QH_LastTradingDay GetLastTradingDayEntity(int breedclass)
{
QH_FuturesTradeRulesDAL FuturesTradeRulesDAL = new QH_FuturesTradeRulesDAL();
QH_LastTradingDayDAL LastTradingDayDAL = new QH_LastTradingDayDAL();
QH_FuturesTradeRules FuturesTradeRules = FuturesTradeRulesDAL.GetModel(breedclass);
QH_LastTradingDay LastTradingDay = LastTradingDayDAL.GetModel((int)FuturesTradeRules.LastTradingDayID);
return(LastTradingDay);
}
/// <summary>
/// 删除最后交易日
/// </summary>
/// <param name="LastTradingDayID">最后交易日ID</param>
/// <returns></returns>
public bool DeleteQHLastTradingDay(int LastTradingDayID)
{
try
{
QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL();
return(qHLastTradingDayDAL.Delete(LastTradingDayID));
}
catch (Exception ex)
{
string errCode = "GL-6052";
string errMsg = "删除最后交易日失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(false);
}
}
/// <summary>
/// 更新最后交易日
/// </summary>
/// <param name="model">最后交易日实体</param>
/// <returns></returns>
public bool UpdateQHLastTradingDay(ManagementCenter.Model.QH_LastTradingDay model)
{
try
{
QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL();
return(qHLastTradingDayDAL.Update(model));
}
catch (Exception ex)
{
string errCode = "GL-6051";
string errMsg = "更新最后交易日失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(false);
}
}
/// <summary>
/// 添加最后交易日
/// </summary>
/// <param name="model">最后交易日实体</param>
/// <returns></returns>
public int AddQHLastTradingDay(ManagementCenter.Model.QH_LastTradingDay model)
{
try
{
QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL();
return(qHLastTradingDayDAL.Add(model));
}
catch (Exception ex)
{
string errCode = "GL-6050";
string errMsg = "添加最后交易日失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(AppGlobalVariable.INIT_INT);
}
}
/// <summary>
/// 根据最后交易日ID，获取最后交易日实体
/// </summary>
/// <param name="LastTradingDayID">最后交易日ID</param>
/// <returns></returns>
public ManagementCenter.Model.QH_LastTradingDay GetQHLastTradingDayModel(int LastTradingDayID)
{
try
{
QH_LastTradingDayDAL qHLastTradingDayDAL = new QH_LastTradingDayDAL();
return(qHLastTradingDayDAL.GetModel(LastTradingDayID));
}
catch (Exception ex)
{
string errCode = "GL-6053";
string errMsg = "根据最后交易日ID，获取最后交易日实体失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(null);
}
}
/// <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();
}
}
}
