/// <summary>
/// 添加现货最小变动价位范围值
/// </summary>
/// <param name="xH_MinChangePriceValue">最小变动价位实体</param>
/// <param name="cM_FieldRange">字段范围实体</param>
/// <returns></returns>
public bool AddXHMinChangePriceValue(XH_MinChangePriceValue xH_MinChangePriceValue, CM_FieldRange cM_FieldRange)
{
CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL();
XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL();
DbConnection Conn = null;
Database db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
DbTransaction Tran = Conn.BeginTransaction();
int fieldRangeID = AppGlobalVariable.INIT_INT;
try
{
fieldRangeID = cMFieldRangeDAL.Add(cM_FieldRange, Tran, db);
if (fieldRangeID != AppGlobalVariable.INIT_INT)
{
xH_MinChangePriceValue.FieldRangeID = fieldRangeID;
xHMinChangePriceValueDAL.Add(xH_MinChangePriceValue, Tran, db);
Tran.Commit();
}
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
string errCode = "GL-5320";
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>
/// 根据品种ID获取交易规则_最小变动价位_范围_值
/// </summary>
/// <param name="BreedClassID">品种ID</param>
/// <returns></returns>
public DataSet GetMinChangePriceFieldRangeByBreedClassID(int BreedClassID)
{
try
{
XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL();
return(xHMinChangePriceValueDAL.GetMinChangePriceFieldRangeByBreedClassID(BreedClassID));
}
catch (Exception ex)
{
string errCode = "GL-5323";
string errMsg = "根据品种ID获取交易规则_最小变动价位_范围_值失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(null);
}
}
/// <summary>
/// 根据品种ID，字段范围ID，删除最小变动价位_范围_值
/// </summary>
/// <param name="BreedClassID">品种ID</param>
/// <param name="FieldRangeID">字段范围ID</param>
/// <returns></returns>
public bool DeleteMinChangePriceValue(int BreedClassID, int FieldRangeID)
{
CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL();
XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL();
DbConnection Conn = null;
Database db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
DbTransaction Tran = Conn.BeginTransaction();
try
{
xHMinChangePriceValueDAL.Delete(BreedClassID, FieldRangeID, Tran, db);
cMFieldRangeDAL.Delete(FieldRangeID, Tran, db);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
string errCode = "GL-5321";
string errMsg = "根据品种ID，字段范围ID，删除最小变动价位_范围_值失败!";
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="xHMinChangePriceValue">交易规则_最小变动价位_范围_值实体</param>
/// <param name="cMFieldRange">字段范围值实体</param>
/// <returns></returns>
public bool UpdateMinChangePriceValue(CM_FieldRange cMFieldRange, XH_MinChangePriceValue xHMinChangePriceValue)
{
CM_FieldRangeDAL cMFieldRangeDAL = new CM_FieldRangeDAL();
XH_MinChangePriceValueDAL xHMinChangePriceValueDAL = new XH_MinChangePriceValueDAL();
DbConnection Conn = null;
Database db = DatabaseFactory.CreateDatabase();
Conn = db.CreateConnection();
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
DbTransaction Tran = Conn.BeginTransaction();
try
{
cMFieldRangeDAL.Update(cMFieldRange, Tran, db);
xHMinChangePriceValueDAL.Update(xHMinChangePriceValue, Tran, db);
Tran.Commit();
return(true);
}
catch (Exception ex)
{
Tran.Rollback();
string errCode = "GL-5322";
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();
}
}
}
