/// <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)); }