/// <summary>
/// 更新交割月份(包括添加,删除)
/// </summary>
/// <param name="addMonthID">需要添加的月份ID</param>
/// <param name="deleteMonthID">需要删除的月份ID</param>
/// <param name="BreedClassID">品种ID</param>
/// <returns></returns>
public bool UpdateQHAgreementDeliveryMonth(List <int> addMonthID, List <int> deleteMonthID, int BreedClassID)
{
QH_AgreementDeliveryMonthDAL qHAgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
QH_AgreementDeliveryMonth QH_AgreementDeliveryMonth = new QH_AgreementDeliveryMonth();
QH_AgreementDeliveryMonth.BreedClassID = BreedClassID;
DbConnection Conn = null;
Database db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
DbTransaction Tran = Conn.BeginTransaction();
try
{
foreach (int addM in addMonthID)
{
QH_AgreementDeliveryMonth.MonthID = addM;
int a = qHAgreementDeliveryMonthDAL.Add(QH_AgreementDeliveryMonth, Tran, db);
}
foreach (int deleM in deleteMonthID)
{
QH_AgreementDeliveryMonth.MonthID = deleM;
qHAgreementDeliveryMonthDAL.Delete(deleM, BreedClassID, Tran, db);
}
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
string errCode = "GL-6060";
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();
}
}
}
/// <summary>
/// 通过交割月份标识和品种标识查询某个品种的某个交割月份是否存在
/// </summary>
/// <param name="BreedClassID">品种标识</param>
/// <param name="monthid">交割月份标识</param>
/// <returns>某个品种的某个交割月份是否存在</returns>
public QH_AgreementDeliveryMonth GetQHAgreementDeliveryBreedClassID(int BreedClassID, int monthid)
{
try
{
QH_AgreementDeliveryMonthDAL qHAgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
return(qHAgreementDeliveryMonthDAL.GetQHAgreementDeliveryBreedClassID(BreedClassID, monthid));
}
catch (Exception ex)
{
string errCode = "GL-6062";
string errMsg = "根据品种标识返回合约交割月份失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(null);
}
}
/// <summary>
/// 根据品种标识返回合约交割月份
/// </summary>
/// <param name="breedClassID">品种标识</param>
/// <returns></returns>
public List <ManagementCenter.Model.QH_AgreementDeliveryMonth> GetQHAgreementDeliveryMonth(int breedClassID)
{
try
{
QH_AgreementDeliveryMonthDAL qHAgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
return(qHAgreementDeliveryMonthDAL.GetListArray(string.Format("BreedClassID={0}", breedClassID)));
}
catch (Exception ex)
{
string errCode = "GL-6062";
string errMsg = "根据品种标识返回合约交割月份失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(null);
}
}
/// <summary>
/// 判断月份是否为交割月
/// </summary>
/// <param name="month"></param>
/// <param name="breedclass"></param>
/// <returns></returns>
public bool IsTradingMonth(int month, int breedclass)
{
QH_AgreementDeliveryMonthDAL AgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
List <QH_AgreementDeliveryMonth> L = AgreementDeliveryMonthDAL.GetListArray(string.Format("BreedClassID={0}", breedclass));
bool falg = false;
foreach (QH_AgreementDeliveryMonth AgreementDeliveryMonth in L)
{
if ((int)AgreementDeliveryMonth.MonthID == month || (int)AgreementDeliveryMonth.MonthID == 13)
{
falg = true;
break;
}
}
return(falg);
}
/// <summary>
/// 添加期货品种时初始化一个周期的和约代码
/// </summary>
/// <param name="BreedClassID"></param>
public void QHCommdityCodeInit(int BreedClassID)
{
CommodityCodeUpdate CCP = new CommodityCodeUpdate();
//根据品种ID，找到品种的前缀代码
string QH_PrefixCode = CCP.GetQH_PrefixCodeByID(BreedClassID);
//根据品种ID，找到品种的名称
string QH_breedclassName = CCP.GetBreedClassNameByID(BreedClassID);
#region 创建代码规则管理器 add by 董鹏 2010-03-10
//根据品种获取交易所
CM_BreedClassBLL bc = new CM_BreedClassBLL();
CM_BourseTypeBLL bt = new CM_BourseTypeBLL();
var bourseType = bt.GetModel(bc.GetModel(BreedClassID).BourseTypeID.Value);
//创建代码规则管理
CodeRulesManager codeRule;
if (bourseType.CodeRulesType.HasValue)
{
LogHelper.WriteDebug("===开始自动生成代码，代码规则类型：" + bourseType.CodeRulesType.ToString());
codeRule = new CodeRulesManager((Types.CodeRulesType)bourseType.CodeRulesType.Value);
}
else
{
LogHelper.WriteDebug("===开始自动生成代码，没有获取到交易所对应的代码规则，交易所：" + bourseType.BourseTypeName);
codeRule = new CodeRulesManager(null);
}
#endregion
CM_CommodityDAL CommodityDAL = new CM_CommodityDAL();
CM_Commodity CM_Commodity = new CM_Commodity();
CM_Commodity.BreedClassID = BreedClassID;
CM_Commodity.GoerScale = decimal.MaxValue;
CM_Commodity.LabelCommodityCode = null;
CM_Commodity.StockPinYin = null;
CM_Commodity.MarketDate = DateTime.Now.AddYears(-1); //暂时将日期定为一年前 DateTime.MaxValue;
CM_Commodity.turnovervolume = null;
CM_Commodity.IsExpired = (int)Types.IsYesOrNo.No; //初始化期货代码时，默认没有过期
CM_Commodity.ISSysDefaultCode = (int)Types.IsYesOrNo.Yes; //新增期货代码时，默认代码没有过期
QH_AgreementDeliveryMonthDAL AgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
List <QH_AgreementDeliveryMonth> L = AgreementDeliveryMonthDAL.GetListArray(string.Format("BreedClassID={0}", BreedClassID));
foreach (QH_AgreementDeliveryMonth AgreementDeliveryMonth in L)
{
if ((int)AgreementDeliveryMonth.MonthID > System.DateTime.Now.Month && (int)AgreementDeliveryMonth.MonthID <= 12)
{
//string Code = QH_PrefixCode + CommodityCodeUpdate.GetTwoLenYear(System.DateTime.Now) +
// CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID);
//使用代码规则管理器生成代码
string Code = codeRule.GetCode(QH_PrefixCode, DateTime.Now.Year.ToString(), CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID));
CM_Commodity.CommodityCode = Code;
CM_Commodity.CommodityName = Code;// QH_breedclassName + Code.Substring(Code.Length - 4);
CommodityDAL.Add(CM_Commodity);
}
if ((int)AgreementDeliveryMonth.MonthID < System.DateTime.Now.Month)
{
//string Code = QH_PrefixCode + CommodityCodeUpdate.GetTwoLenYear(System.DateTime.Now.AddYears(1)) +
// CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID);
//使用代码规则管理器生成代码
string Code = codeRule.GetCode(QH_PrefixCode, DateTime.Now.AddYears(1).Year.ToString(), CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID));
CM_Commodity.CommodityCode = Code;
CM_Commodity.CommodityName = Code;// QH_breedclassName + Code.Substring(Code.Length - 4);
CommodityDAL.Add(CM_Commodity);
}
if ((int)AgreementDeliveryMonth.MonthID == System.DateTime.Now.Month)
{
int lasttradingday = CCP.GetLastTradingDay(CCP.GetLastTradingDayEntity(BreedClassID), BreedClassID);
string Code = string.Empty;
if (System.DateTime.Now.Day < lasttradingday)
{
// Code = QH_PrefixCode + CommodityCodeUpdate.GetTwoLenYear(System.DateTime.Now) +
//CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID);
//使用代码规则管理器生成代码
Code = codeRule.GetCode(QH_PrefixCode, DateTime.Now.Year.ToString(), CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID));
}
else
{
// Code = QH_PrefixCode + CommodityCodeUpdate.GetTwoLenYear(System.DateTime.Now.AddYears(1)) +
//CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID);
//使用代码规则管理器生成代码
Code = codeRule.GetCode(QH_PrefixCode, DateTime.Now.AddYears(1).Year.ToString(), CommodityCodeUpdate.GetTwoLenMonth((int)AgreementDeliveryMonth.MonthID));
}
CM_Commodity.CommodityCode = Code;
CM_Commodity.CommodityName = Code;// QH_breedclassName + Code.Substring(Code.Length - 4);
CommodityDAL.Add(CM_Commodity);
}
if ((int)AgreementDeliveryMonth.MonthID == 13)
{
SpecialQHCodeInit(BreedClassID, QH_PrefixCode, QH_breedclassName);
}
}
}
/// <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();
}
}
}
/// <summary>
/// 检测期货代码是否到期
/// </summary>
public void CheckCodeIsExpired()
{
try
{
QH_AgreementDeliveryMonthDAL AgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
//一般品种，交割月为1~12月份
QH_FuturesTradeRulesDAL FuturesTradeRulesDAL = new QH_FuturesTradeRulesDAL();
//获取交易规则
List <QH_FuturesTradeRules> L = FuturesTradeRulesDAL.GetListArray(string.Empty);
if (L != null)
{
foreach (QH_FuturesTradeRules FuturesTradeRules in L)
{
#region old
//List<QH_AgreementDeliveryMonth> listQHAgreDeMonth = AgreementDeliveryMonthDAL.GetListArray(string.Format("BreedClassID={0}", FuturesTradeRules.BreedClassID));
//foreach (QH_AgreementDeliveryMonth AgreementDeliveryMonth in listQHAgreDeMonth)
//{
// if ((int)AgreementDeliveryMonth.MonthID != 13)
// {
// Production(FuturesTradeRules.BreedClassID);
// }
//}
#endregion
//交割月份要么等于13，要么不等于，因此不需循环，造成重复执行多遍
//update by 董鹏 2010-03-31
//获取交易规则中的交割月份
List <QH_AgreementDeliveryMonth> listQHAgreDeMonth = AgreementDeliveryMonthDAL.GetListArray(string.Format("BreedClassID={0} and MonthID!={1}", FuturesTradeRules.BreedClassID, 13));
if (listQHAgreDeMonth.Count != 0)
{
Production(FuturesTradeRules.BreedClassID);
}
}
}
else
{
LogHelper.WriteDebug("期货交易规则数据为空");
}
#region old
////特殊处理，本月下月随后的两个季度月份
////QH_AgreementDeliveryMonthDAL AgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
//List<QH_AgreementDeliveryMonth> L_m = AgreementDeliveryMonthDAL.GetListArray(string.Empty);
//if (L_m != null)
//{
// foreach (QH_AgreementDeliveryMonth AgreementDeliveryMonth in L_m)
// {
// if ((int)AgreementDeliveryMonth.MonthID == 13)
// {
// QH_LastTradingDay LastTradingDayEntity =
// GetLastTradingDayEntity((int)AgreementDeliveryMonth.BreedClassID);
// if (System.DateTime.Now.Day ==
// GetLastTradingDay(LastTradingDayEntity, (int)AgreementDeliveryMonth.BreedClassID))
// {
// SpecialQHCodeUpdate((int)AgreementDeliveryMonth.BreedClassID);
// }
// }
// }
//}
//else
//{
// LogHelper.WriteDebug("期货合约交割月份数据为空");
//}
#endregion
//update by 董鹏 2010-03-31
//特殊处理，本月下月随后的两个季度月份
//QH_AgreementDeliveryMonthDAL AgreementDeliveryMonthDAL = new QH_AgreementDeliveryMonthDAL();
List <QH_AgreementDeliveryMonth> L_m = AgreementDeliveryMonthDAL.GetListArray(string.Format("MonthID={0}", 13));
if (L_m != null)
{
foreach (QH_AgreementDeliveryMonth AgreementDeliveryMonth in L_m)
{
QH_LastTradingDay LastTradingDayEntity = GetLastTradingDayEntity((int)AgreementDeliveryMonth.BreedClassID);
if (System.DateTime.Now.Day == GetLastTradingDay(LastTradingDayEntity, (int)AgreementDeliveryMonth.BreedClassID))
{
SpecialQHCodeUpdate((int)AgreementDeliveryMonth.BreedClassID);
}
}
}
else
{
LogHelper.WriteDebug("期货合约交割月份数据为空");
}
}
catch (Exception ex)
{
string errCode = "GL-7000";
string errMsg = "更新期货和约代码失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
}
}
