public static void Updatestock_SymbolPermLong(stock_SymbolPermLong stock_SymbolPermLong) { try { stock_SymbolPermLongDAO stock_SymbolPermLongDAO = new stock_SymbolPermLongDAO(); stock_SymbolPermLongDAO.Updatestock_SymbolPermLong(stock_SymbolPermLong); } catch (ApplicationException) { throw; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.BusinessUpdatestock_SymbolPermLongException, ex); } }
public virtual stock_SymbolPermLong Createstock_SymbolPermLongFromReader(IDataReader reader) { stock_SymbolPermLong item = new stock_SymbolPermLong(); try { if (!reader.IsDBNull(reader.GetOrdinal("SymbolID"))) item.SymbolID = (int)reader["SymbolID"]; if (!reader.IsDBNull(reader.GetOrdinal("PermDate"))) item.PermDate = (DateTime)reader["PermDate"]; if (!reader.IsDBNull(reader.GetOrdinal("PriceOpen"))) item.PriceOpen = (double)reader["PriceOpen"]; if (!reader.IsDBNull(reader.GetOrdinal("PriceClose"))) item.PriceClose = (double)reader["PriceClose"]; if (!reader.IsDBNull(reader.GetOrdinal("PriceHigh"))) item.PriceHigh = (double)reader["PriceHigh"]; if (!reader.IsDBNull(reader.GetOrdinal("PriceLow"))) item.PriceLow = (double)reader["PriceLow"]; if (!reader.IsDBNull(reader.GetOrdinal("PriceAverage"))) item.PriceAverage = (double)reader["PriceAverage"]; if (!reader.IsDBNull(reader.GetOrdinal("PricePreviousClose"))) item.PricePreviousClose = (double)reader["PricePreviousClose"]; if (!reader.IsDBNull(reader.GetOrdinal("Volume"))) item.Volume = (double)reader["Volume"]; if (!reader.IsDBNull(reader.GetOrdinal("TotalTrade"))) item.TotalTrade = (double)reader["TotalTrade"]; if (!reader.IsDBNull(reader.GetOrdinal("TotalValue"))) item.TotalValue = (double)reader["TotalValue"]; if (!reader.IsDBNull(reader.GetOrdinal("AdjRatio"))) item.AdjRatio = (double)reader["AdjRatio"]; if (!reader.IsDBNull(reader.GetOrdinal("LastUpdated"))) item.LastUpdated = (DateTime)reader["LastUpdated"]; if (!reader.IsDBNull(reader.GetOrdinal("CurrentForeignRoom"))) item.CurrentForeignRoom = (double)reader["CurrentForeignRoom"]; if (!reader.IsDBNull(reader.GetOrdinal("BuyCount"))) item.BuyCount = (double)reader["BuyCount"]; if (!reader.IsDBNull(reader.GetOrdinal("BuyQuantity"))) item.BuyQuantity = (double)reader["BuyQuantity"]; if (!reader.IsDBNull(reader.GetOrdinal("SellCount"))) item.SellCount = (double)reader["SellCount"]; if (!reader.IsDBNull(reader.GetOrdinal("SellQuantity"))) item.SellQuantity = (double)reader["SellQuantity"]; if (!reader.IsDBNull(reader.GetOrdinal("BuyForeignCount"))) item.BuyForeignCount = (double)reader["BuyForeignCount"]; if (!reader.IsDBNull(reader.GetOrdinal("BuyForeignQuantity"))) item.BuyForeignQuantity = (double)reader["BuyForeignQuantity"]; if (!reader.IsDBNull(reader.GetOrdinal("BuyForeignValue"))) item.BuyForeignValue = (double)reader["BuyForeignValue"]; if (!reader.IsDBNull(reader.GetOrdinal("SellForeignCount"))) item.SellForeignCount = (double)reader["SellForeignCount"]; if (!reader.IsDBNull(reader.GetOrdinal("SellForeignQuantity"))) item.SellForeignQuantity = (double)reader["SellForeignQuantity"]; if (!reader.IsDBNull(reader.GetOrdinal("SellForeignValue"))) item.SellForeignValue = (double)reader["SellForeignValue"]; } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessCreatestock_SymbolPermLongFromReaderException, ex); } return item; }
private void saveSymbol() { this.paramater(); this.label1.InnerText = ""; this.label2.InnerText = ""; this.label3.InnerText = ""; this.label4.InnerText = ""; this.label5.InnerText = ""; this.label6.InnerText = ""; this.label7.InnerText = ""; if (this.SelectPermDate.Text == string.Empty) { this.label1.InnerText = Resources.UIResource.ErrorInfo; return; } if (this.InputPriceOpen.Value == string.Empty) { this.label2.InnerText = Resources.UIResource.ErrorInfo; return; } if (this.InputPriceClose.Value == string.Empty) { this.label3.InnerText = Resources.UIResource.ErrorInfo; return; } if (this.InputPriceHight.Value == string.Empty) { this.label4.InnerText = Resources.UIResource.ErrorInfo; return; } if (this.InputPriceLow.Value == string.Empty) { this.label5.InnerText = Resources.UIResource.ErrorInfo; return; } if (this.InputVolume.Value == string.Empty) { this.label6.InnerText = Resources.UIResource.ErrorInfo; return; } if (this.IsNumber(this.InputPriceOpen.Value) == false|| this.IsNumber(this.InputPriceClose.Value) == false|| this.IsNumber(this.InputPriceHight.Value) == false|| this.IsNumber(this.InputPriceLow.Value) == false|| this.IsNumber(this.InputVolume.Value) == false) { this.label7.InnerText = Resources.UIResource.TestInfo; this.label7.Attributes["class"] = "inforError"; return; } stock_SymbolPermLong = stock_SymbolPermLongService.Getstock_SymbolPermLong(symbolId, ApplicationHelper.ConvertStringToDate(permDate)); if (stock_SymbolPermLong == null) { stock_SymbolPermLong = new stock_SymbolPermLong(); stock_SymbolPermLong = this.getValueSymobl(stock_SymbolPermLong); stock_SymbolPermLongService.Createstock_SymbolPermLong(stock_SymbolPermLong); } else { stock_SymbolPermLong = this.getValueSymobl(stock_SymbolPermLong); stock_SymbolPermLongService.Updatestock_SymbolPermLong(stock_SymbolPermLong); } this.label7.InnerText = Resources.UIResource.UpdateSeccess; this.label7.Attributes["class"] = "inforSeccessful"; }
private stock_SymbolPermLong getValueSymobl(stock_SymbolPermLong sk_SymbolPermLong) { sk_SymbolPermLong.SymbolID = Convert.ToInt32(this.DropdownlistSelectSymbol.Value); sk_SymbolPermLong.PermDate = ApplicationHelper.ConvertStringToDate(this.SelectPermDate.Text); sk_SymbolPermLong.PriceOpen= Convert.ToInt64(this.InputPriceOpen.Value); sk_SymbolPermLong.PriceClose = Convert.ToInt64(this.InputPriceClose.Value); sk_SymbolPermLong.PriceHigh = Convert.ToInt64(this.InputPriceHight.Value); sk_SymbolPermLong.PriceLow = Convert.ToInt64(this.InputPriceLow.Value); sk_SymbolPermLong.PriceAverage = this.InputPriceAverage.Value == string.Empty ? 0 : Convert.ToInt64(this.InputPriceAverage.Value); sk_SymbolPermLong.PricePreviousClose = this.InputPricePreviousClose.Value == string.Empty ? 0 : Convert.ToInt64(this.InputPricePreviousClose.Value); sk_SymbolPermLong.Volume = Convert.ToInt64(this.InputVolume.Value); sk_SymbolPermLong.TotalTrade = this.InputTotalTrade.Value == string.Empty ? 0 : Convert.ToInt64(this.InputTotalTrade.Value); sk_SymbolPermLong.TotalValue = this.InputTotalValue.Value == string.Empty ? 0 : Convert.ToInt64(this.InputTotalValue.Value); sk_SymbolPermLong.AdjRatio = this.InputAdjRatio.Value == string.Empty ? 0 : Convert.ToDouble(this.InputAdjRatio.Value); sk_SymbolPermLong.LastUpdated = ApplicationHelper.ConvertStringToDate(this.SelectPermDate.Text); //sk_SymbolPermLong.AdjRatio = this.InputAdjRatio.Value == string.Empty ? 0 : Convert.ToInt64(this.InputAdjRatio.Value); sk_SymbolPermLong.CurrentForeignRoom = this.InputCurrentForeignRoom.Value == string.Empty ? 0 : Convert.ToInt64(this.InputCurrentForeignRoom.Value); sk_SymbolPermLong.BuyCount = this.InputBuyCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyCount.Value); sk_SymbolPermLong.BuyQuantity = this.InputBuyQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyQuantity.Value); sk_SymbolPermLong.SellCount = this.InputSellCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellCount.Value); sk_SymbolPermLong.SellQuantity = this.InputSellQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellQuantity.Value); sk_SymbolPermLong.BuyForeignCount = this.InputBuyForeignCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyForeignCount.Value); sk_SymbolPermLong.BuyForeignQuantity = this.InputBuyForeignQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyForeignQuantity.Value); sk_SymbolPermLong.BuyForeignValue = this.InputBuyForeignValue.Value == string.Empty ? 0 : Convert.ToInt64(this.InputBuyForeignValue.Value); sk_SymbolPermLong.SellForeignCount = this.InputSellForeignCount.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellForeignCount.Value); sk_SymbolPermLong.SellForeignQuantity = this.InputSellForeignQuantity.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellForeignQuantity.Value); sk_SymbolPermLong.SellForeignValue = this.InputSellForeignValue.Value == string.Empty ? 0 : Convert.ToInt64(this.InputSellForeignValue.Value); return sk_SymbolPermLong; }
public virtual void Createstock_SymbolPermLong(stock_SymbolPermLong stock_SymbolPermLong) { try { Database database = DatabaseFactory.CreateDatabase("DestinationConnection"); DbCommand dbCommand = database.GetStoredProcCommand("spstock_SymbolPermLongInsert"); database.AddInParameter(dbCommand, "@SymbolID", DbType.Int32, stock_SymbolPermLong.SymbolID); database.AddInParameter(dbCommand, "@PermDate", DbType.DateTime, stock_SymbolPermLong.PermDate); database.AddInParameter(dbCommand, "@PriceOpen", DbType.Double, stock_SymbolPermLong.PriceOpen); database.AddInParameter(dbCommand, "@PriceClose", DbType.Double, stock_SymbolPermLong.PriceClose); database.AddInParameter(dbCommand, "@PriceHigh", DbType.Double, stock_SymbolPermLong.PriceHigh); database.AddInParameter(dbCommand, "@PriceLow", DbType.Double, stock_SymbolPermLong.PriceLow); database.AddInParameter(dbCommand, "@PriceAverage", DbType.Double, stock_SymbolPermLong.PriceAverage); database.AddInParameter(dbCommand, "@PricePreviousClose", DbType.Double, stock_SymbolPermLong.PricePreviousClose); database.AddInParameter(dbCommand, "@Volume", DbType.Double, stock_SymbolPermLong.Volume); database.AddInParameter(dbCommand, "@TotalTrade", DbType.Double, stock_SymbolPermLong.TotalTrade); database.AddInParameter(dbCommand, "@TotalValue", DbType.Double, stock_SymbolPermLong.TotalValue); database.AddInParameter(dbCommand, "@AdjRatio", DbType.Double, stock_SymbolPermLong.AdjRatio); database.AddInParameter(dbCommand, "@LastUpdated", DbType.DateTime, stock_SymbolPermLong.LastUpdated); database.AddInParameter(dbCommand, "@CurrentForeignRoom", DbType.Double, stock_SymbolPermLong.CurrentForeignRoom); database.AddInParameter(dbCommand, "@BuyCount", DbType.Double, stock_SymbolPermLong.BuyCount); database.AddInParameter(dbCommand, "@BuyQuantity", DbType.Double, stock_SymbolPermLong.BuyQuantity); database.AddInParameter(dbCommand, "@SellCount", DbType.Double, stock_SymbolPermLong.SellCount); database.AddInParameter(dbCommand, "@SellQuantity", DbType.Double, stock_SymbolPermLong.SellQuantity); database.AddInParameter(dbCommand, "@BuyForeignCount", DbType.Double, stock_SymbolPermLong.BuyForeignCount); database.AddInParameter(dbCommand, "@BuyForeignQuantity", DbType.Double, stock_SymbolPermLong.BuyForeignQuantity); database.AddInParameter(dbCommand, "@BuyForeignValue", DbType.Double, stock_SymbolPermLong.BuyForeignValue); database.AddInParameter(dbCommand, "@SellForeignCount", DbType.Double, stock_SymbolPermLong.SellForeignCount); database.AddInParameter(dbCommand, "@SellForeignQuantity", DbType.Double, stock_SymbolPermLong.SellForeignQuantity); database.AddInParameter(dbCommand, "@SellForeignValue", DbType.Double, stock_SymbolPermLong.SellForeignValue); database.ExecuteNonQuery(dbCommand); } catch (Exception ex) { // log this exception log4net.Util.LogLog.Error(ex.Message, ex); // wrap it and rethrow throw new ApplicationException(SR.DataAccessCreatestock_SymbolPermLongException, ex); } }