public void Should_Success_Create_Data_BalanceStock() { BalanceStock balanceStock = new BalanceStock { BalanceStockId = "BS1807011000951", StockId = 1801, EPOID = "PM16205859", EPOItemId = 1, RO = "162004M", ArticleNo = "FAB 28.12.16/M", SmallestUnitQty = "9", PeriodeMonth = "9", PeriodeYear = "2018", OpenStock = 950.06, DebitStock = 0, CreditStock = 0, CloseStock = 2.74280000000181, OpenPrice = Convert.ToDecimal(21736103.1398), DebitPrice = 0, CreditPrice = 0, ClosePrice = Convert.ToDecimal(62659.1333), CreateDate = new DateTime(2018, 07, 01) }; Assert.NotNull(balanceStock); }
private void listBalanceInfo_RetrieveVirtualItem(object sender, RetrieveVirtualItemEventArgs e) { try { if (e.ItemIndex >= listBalanceInfo.VirtualListSize || e.ItemIndex >= listBalanceInfo.DataList.Count) { return; } BalanceStock b = listBalanceInfo.DataList[e.ItemIndex]; e.Item = new ListViewItem(new string[] { b.Name, b.Info, b.Code, string.Format("{0:c}", b.ApprAmt), string.Format("{0:p2}", b.ApprAmtRatio), string.Format("{0:c}", b.ApprProfit), string.Format("{0:p2}", b.ApprProfitRate), b.Qty.ToString(), b.ExitPossQty.ToString(), string.Format("{0:n0}", b.CurPrice), string.Format("{0:p2}", b.ChangePriceRate), string.Format("{0:n0}", b.AvgPrice) }) { Tag = b }; } catch { Utils.LogError("error", "listviewBalance_RetrieveVirtualItem"); } }
public List <BalanceStock> SearchData(BalanceStock obj) { try { List <BalanceStock> lst = new List <BalanceStock>(); SqlParameter[] Parameters = { new SqlParameter("@OwnerType", obj.Rpt), new SqlParameter("@Agent", obj.Agt), new SqlParameter("@Airline", obj.Air), new SqlParameter("@Usersno", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) }; DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetBalanceStock", Parameters); if (ds.Tables != null && ds.Tables.Count > 0) { lst = ds.Tables[0].AsEnumerable().Select(e => new BalanceStock { Owner = Convert.ToString(e["Owner"].ToString()), Item = Convert.ToString(e["item"].ToString()), City = Convert.ToString(e["City"].ToString()), Ownertype = Convert.ToString(e["OwnerType"].ToString()), Consumble = Convert.ToString(e["Consumble"].ToString()), Utilized = Convert.ToString(e["Utilized"].ToString()), Balance = Convert.ToString(e["Balance"].ToString()), Dt = Convert.ToString(e["Dt"].ToString()) }).ToList(); } return(lst); } catch (Exception ex)// (Exception ex) { // do something for error DataSet dsError; System.Data.SqlClient.SqlParameter[] ParametersError = { new System.Data.SqlClient.SqlParameter("@ErrorMessage", ex.Message), new System.Data.SqlClient.SqlParameter("@ProcName", "GetBalanceStock"), new System.Data.SqlClient.SqlParameter("@UserSNo", ((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo.ToString()) }; dsError = CargoFlash.SoftwareFactory.Data.SqlHelper.ExecuteDataset(CargoFlash.SoftwareFactory.Data.DMLConnectionString.WebConfigConnectionString, System.Data.CommandType.StoredProcedure, "ProcOfHandleErrors", ParametersError); throw ex; } }
private void listBalanceInfo_DrawSubItem(object sender, DrawListViewSubItemEventArgs e) { using (StringFormat sf = new StringFormat()) { switch (e.Header.TextAlign) { case HorizontalAlignment.Center: sf.Alignment = StringAlignment.Center; break; case HorizontalAlignment.Right: sf.Alignment = StringAlignment.Far; break; case HorizontalAlignment.Left: sf.Alignment = StringAlignment.Near; break; } sf.LineAlignment = StringAlignment.Far; BalanceStock b = listBalanceInfo.DataList[e.ItemIndex]; Brush fontBrush = Brushes.White; switch (e.ColumnIndex) { case 0: case 2: //fontBrush = listBalanceInfo.GetCodeBrush(b.Code); break; case 5: case 6: fontBrush = listBalanceInfo.GetPlusMinusBrush(b.ApprProfit); break; case 10: fontBrush = listBalanceInfo.GetPlusMinusBrush(b.ChangePriceRate); break; } e.Graphics.DrawString(e.SubItem.Text, this.Font, fontBrush, e.Bounds, sf); listBalanceInfo.OnDrawSubItem(sender, e); } }
private void InitControl() { if (_type == BalanceType.PORT) { this.Text = "포트조회"; btnOrder.Text = "포트주문"; listMainInfo.SetColumnHeader(new List <ColumnHeaderInfo>() { new ColumnHeaderInfo() { Title = "포트", Width = 150, Align = HorizontalAlignment.Left }, new ColumnHeaderInfo() { Title = "순자산", Width = 75, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "예수금2", Width = 75, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "평가", Width = 75, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "현금", Width = 75, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "융자", Width = 75, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "손익", Width = 75, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "수익률", Width = 75, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "전일대비", Width = 75, Align = HorizontalAlignment.Right } }); listBalanceInfo.SetColumnHeader(new List <ColumnHeaderInfo>() { new ColumnHeaderInfo() { Title = "종목", Width = 150, Align = HorizontalAlignment.Left }, new ColumnHeaderInfo() { Title = "비율", Width = 70, Align = HorizontalAlignment.Left }, new ColumnHeaderInfo() { Title = "코드", Width = 60, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "평가", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "비중", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "손익", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "수익률", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "잔고", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "청산가능", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "현재가", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "전일대비", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "평단", Width = 70, Align = HorizontalAlignment.Right } }, 4); listBalanceInfo.SetComparers(new Dictionary <int, Comparison <BalanceStock> > { { 0, (a, b) => a.Name.CompareTo(b.Name) }, { 1, (a, b) => Convert.ToInt32(a.Info.Split('/')[0]).CompareTo(Convert.ToInt32(b.Info.Split('/')[0])) }, { 2, (a, b) => a.Code.CompareTo(b.Code) }, { 3, (a, b) => a.ApprAmt.CompareTo(b.ApprAmt) }, { 4, (a, b) => a.ApprAmtRatio.CompareTo(b.ApprAmtRatio) }, { 5, (a, b) => a.ApprProfit.CompareTo(b.ApprProfit) }, { 6, (a, b) => a.ApprProfitRate.CompareTo(b.ApprProfitRate) }, { 7, (a, b) => a.Qty.CompareTo(b.Qty) }, { 8, (a, b) => a.ExitPossQty.CompareTo(b.ExitPossQty) }, { 9, (a, b) => a.CurPrice.CompareTo(b.CurPrice) }, { 10, (a, b) => a.ChangePriceRate.CompareTo(b.ChangePriceRate) }, { 11, (a, b) => a.AvgPrice.CompareTo(b.AvgPrice) } }); BalanceStock bs = new BalanceStock("000250", "삼천당제약"); bs.Info = "100/0/0"; bs.ApprAmt = 3999; bs.ApprAmtRatio = 0.5413; bs.ApprProfit = 521; bs.ApprProfitRate = 0.1493; bs.Qty = 275774; bs.ExitPossQty = 275774; bs.CurPrice = 14500; bs.ChangePriceRate = 0.0136; bs.AvgPrice = 12611; _test_list.Add(bs); bs = new BalanceStock("008260", "NI스틸"); bs.Info = "72/26/1"; bs.ApprAmt = 695; bs.ApprAmtRatio = 0.0945; bs.ApprProfit = -54; bs.ApprProfitRate = -0.0721; bs.Qty = 168374; bs.ExitPossQty = 168374; bs.CurPrice = 4125; bs.ChangePriceRate = -0.0084; bs.AvgPrice = 12611; _test_list.Add(bs); //listBalanceInfo.SetDataList(new List<BalanceStock>()); listBalanceInfo.SetDataList(_test_list); } else if (_type == BalanceType.FUND) { this.Text = "펀드조회"; btnOrder.Text = "펀드주문"; } else if (_type == BalanceType.RISK) { this.Text = "펀드조회"; btnOrder.Visible = false; } else if (_type == BalanceType.ACCOUNT) { this.Text = "계좌조회"; btnOrder.Text = "계좌주문"; listMainInfo.SetColumnHeader(new List <ColumnHeaderInfo>() { new ColumnHeaderInfo() { Title = "증권사", Width = 50, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "구분", Width = 35, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "계좌번호", Width = 80, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "계좌명", Width = 60, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "예수금2", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "순자산", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "평가", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "현금", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "융자", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "손익", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "수익률", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "전일대비", Width = 70, Align = HorizontalAlignment.Right } }); listBalanceInfo.SetColumnHeader(new List <ColumnHeaderInfo>() { new ColumnHeaderInfo() { Title = "", Width = 20, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "신용", Width = 35, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "종목", Width = 150, Align = HorizontalAlignment.Left }, new ColumnHeaderInfo() { Title = "코드", Width = 60, Align = HorizontalAlignment.Center }, new ColumnHeaderInfo() { Title = "평가", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "비중", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "손익", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "수익률", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "잔고", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "청산가능", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "현재가", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "전일대비", Width = 70, Align = HorizontalAlignment.Right }, new ColumnHeaderInfo() { Title = "평단", Width = 70, Align = HorizontalAlignment.Right } }, 4); listBalanceInfo.SetComparers(new Dictionary <int, Comparison <BalanceStock> > { { 0, (a, b) => a.Selected.CompareTo(b.Selected) }, { 1, (a, b) => a.CreditType.CompareTo(b.CreditType) }, { 2, (a, b) => a.Name.CompareTo(b.Name) }, { 3, (a, b) => a.Code.CompareTo(b.Code) }, { 4, (a, b) => a.ApprAmt.CompareTo(b.ApprAmt) }, { 5, (a, b) => a.ApprAmtRatio.CompareTo(b.ApprAmtRatio) }, { 6, (a, b) => a.ApprProfit.CompareTo(b.ApprProfit) }, { 7, (a, b) => a.ApprProfitRate.CompareTo(b.ApprProfitRate) }, { 8, (a, b) => a.Qty.CompareTo(b.Qty) }, { 9, (a, b) => a.ExitPossQty.CompareTo(b.ExitPossQty) }, { 10, (a, b) => a.CurPrice.CompareTo(b.CurPrice) }, { 11, (a, b) => a.ChangePriceRate.CompareTo(b.ChangePriceRate) }, { 12, (a, b) => a.AvgPrice.CompareTo(b.AvgPrice) } }); listBalanceInfo.SetDataList(new List <BalanceStock>()); } }
internal void Sum(decimal quantity, string batch, StockValueKey key) { BalanceStock _bs = GetOrDefault(batch); _bs.Base[key] += quantity; }