/// <summary>
/// 根据港股商品代码返回交易商品
/// </summary>
/// <param name="hkcommodityCode">港股商品代码</param>
/// <returns>返回港股代码实体</returns>
public Entity.HK_Commodity GetHKCommodityByHKCommodityCode(string hkcommodityCode)
{
try
{
LogHelper.WriteDebug("Debug-8605根据港股商品代码返回交易商品方法名称:GetHKCommodityByHKCommodityCode(string hkcommodityCode)参数是:" + hkcommodityCode + "时间是:" + DateTime.Now);
HK_CommodityBLL hK_CommodityBLL = new HK_CommodityBLL();
List <Entity.HK_Commodity> hK_CommodityList =
hK_CommodityBLL.GetListArray(string.Format("HKCommodityCode='{0}'", hkcommodityCode));
if (hK_CommodityList.Count > 0)
{
Entity.HK_Commodity hK_Commodity = hK_CommodityList[0];
if (hK_Commodity != null)
{
return(hK_Commodity);
}
}
return(null);
}
catch (Exception ex)
{
string errCode = "GL-8605";// "GL-8207";
string errMsg = "根据商品代码返回港股交易商品实体失败";
VTException vte = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(vte.ToString(), vte.InnerException);
return(null);
}
}
/// <summary>
/// 更新港股交易商品
/// </summary>
/// <param name="model">港股交易商品实体</param>
/// <returns></returns>
public bool UpdateHKCommodity(ManagementCenter.Model.HK_Commodity model)
{
try
{
return(hK_CommodityDAL.Update(model));
}
catch (Exception ex)
{
string errCode = "GL-7751";
string errMsg = "更新港股交易商品失败!";
VTException exception = new VTException(errCode, errMsg, ex);
LogHelper.WriteError(exception.ToString(), exception.InnerException);
return(false);
}
}
/// <summary>
/// 根据港股交易商品代码获取实体对象
/// </summary>
/// <param name="HKCommodityCode">港股交易商品代码</param>
/// <returns></returns>
public ManagementCenter.Model.HK_Commodity GetModel(string HKCommodityCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select HKCommodityCode,HKCommodityName,BreedClassID,MarketDate,StockPinYin,turnovervolume,PerHandThighOrShare,IsSellNull,ISSysDefaultCode from HK_Commodity ");
strSql.Append(" where HKCommodityCode=@HKCommodityCode ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "HKCommodityCode", DbType.String, HKCommodityCode);
ManagementCenter.Model.HK_Commodity model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
///添加港股交易商品
/// </summary>
/// <param name="model">港股交易商品实体</param>
/// <returns></returns>
public bool Add(ManagementCenter.Model.HK_Commodity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into HK_Commodity(");
strSql.Append("HKCommodityCode,HKCommodityName,BreedClassID,MarketDate,StockPinYin,turnovervolume,PerHandThighOrShare,IsSellNull,ISSysDefaultCode)");
strSql.Append(" values (");
strSql.Append("@HKCommodityCode,@HKCommodityName,@BreedClassID,@MarketDate,@StockPinYin,@turnovervolume,@PerHandThighOrShare,@IsSellNull,@ISSysDefaultCode)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "HKCommodityCode", DbType.String, model.HKCommodityCode);
db.AddInParameter(dbCommand, "HKCommodityName", DbType.String, model.HKCommodityName);
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
//db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, model.MarketDate);
if (model.MarketDate == AppGlobalVariable.INIT_DATETIME)
{
db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, DBNull.Value);
}
else
{
db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, model.MarketDate);
}
db.AddInParameter(dbCommand, "StockPinYin", DbType.String, model.StockPinYin);
db.AddInParameter(dbCommand, "turnovervolume", DbType.Double, model.turnovervolume);
db.AddInParameter(dbCommand, "PerHandThighOrShare", DbType.Int32, model.PerHandThighOrShare);
db.AddInParameter(dbCommand, "IsSellNull", DbType.Int32, model.IsSellNull);
// db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
if (model.ISSysDefaultCode == AppGlobalVariable.INIT_INT)
{
model.ISSysDefaultCode = (int)Types.IsYesOrNo.No;
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
else
{
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
db.ExecuteNonQuery(dbCommand);
return(true);
}
/// <summary>
/// 港股交易商品的对象实体绑定数据
/// </summary>
public ManagementCenter.Model.HK_Commodity ReaderBind(IDataReader dataReader)
{
ManagementCenter.Model.HK_Commodity model = new ManagementCenter.Model.HK_Commodity();
object ojb;
model.HKCommodityCode = dataReader["HKCommodityCode"].ToString();
model.HKCommodityName = dataReader["HKCommodityName"].ToString();
ojb = dataReader["BreedClassID"];
if (ojb != null && ojb != DBNull.Value)
{
model.BreedClassID = (int)ojb;
}
ojb = dataReader["MarketDate"];
if (ojb != null && ojb != DBNull.Value)
{
model.MarketDate = (DateTime)ojb;
}
model.StockPinYin = dataReader["StockPinYin"].ToString();
ojb = dataReader["turnovervolume"];
if (ojb != null && ojb != DBNull.Value)
{
model.turnovervolume = (double)ojb;
}
ojb = dataReader["PerHandThighOrShare"];
if (ojb != null && ojb != DBNull.Value)
{
model.PerHandThighOrShare = (int)ojb;
}
ojb = dataReader["IsSellNull"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsSellNull = (int)ojb;
}
ojb = dataReader["ISSysDefaultCode"];
if (ojb != null && ojb != DBNull.Value)
{
model.ISSysDefaultCode = (int)ojb;
}
return(model);
}
/// <summary>
/// 更新港股交易商品
/// </summary>
/// <param name="model">港股交易商品实体</param>
public bool Update(ManagementCenter.Model.HK_Commodity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update HK_Commodity set ");
//strSql.Append("HKCommodityName=@HKCommodityName,");
strSql.Append("BreedClassID=@BreedClassID,");
//strSql.Append("MarketDate=@MarketDate,");
//strSql.Append("StockPinYin=@StockPinYin,");
// strSql.Append("turnovervolume=@turnovervolume,");
//strSql.Append("PerHandThighOrShare=@PerHandThighOrShare,");
//strSql.Append("IsSellNull=@IsSellNull,");
strSql.Append("ISSysDefaultCode=@ISSysDefaultCode");
strSql.Append(" where HKCommodityCode=@HKCommodityCode ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "HKCommodityCode", DbType.String, model.HKCommodityCode);
// db.AddInParameter(dbCommand, "HKCommodityName", DbType.String, model.HKCommodityName);
db.AddInParameter(dbCommand, "BreedClassID", DbType.Int32, model.BreedClassID);
//db.AddInParameter(dbCommand, "MarketDate", DbType.DateTime, model.MarketDate);
//db.AddInParameter(dbCommand, "StockPinYin", DbType.String, model.StockPinYin);
//db.AddInParameter(dbCommand, "turnovervolume", DbType.Double, model.turnovervolume);
//db.AddInParameter(dbCommand, "PerHandThighOrShare", DbType.Int32, model.PerHandThighOrShare);
//db.AddInParameter(dbCommand, "IsSellNull", DbType.Int32, model.IsSellNull);
//db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
if (model.ISSysDefaultCode == AppGlobalVariable.INIT_INT)
{
model.ISSysDefaultCode = (int)Types.IsYesOrNo.No;
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
else
{
db.AddInParameter(dbCommand, "ISSysDefaultCode", DbType.Int32, model.ISSysDefaultCode);
}
db.ExecuteNonQuery(dbCommand);
return(true);
}
/// <summary>
/// 更新港股交易商品
/// </summary>
/// <param name="model">港股交易商品实体</param>
/// <returns></returns>
public static bool UpdateHKCommodity(ManagementCenter.Model.HK_Commodity model)
{
HK_CommodityBLL hM_CommodityBLL = new HK_CommodityBLL();
return(hM_CommodityBLL.UpdateHKCommodity(model));
}
