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