private void InitGridView()
{
this.Main_BandedGridView.Columns.Clear();
this.Main_BandedGridView.Bands.Clear();
this.Main_BandedGridView.AddColumn("ItemID", "Mã", 90, false);
this.Main_BandedGridView.AddColumn("ItemName", "Tên", 300, false, fixedWidth: false);
this.Main_BandedGridView.AddColumn("ItemSName", "Tên viết tắt", 100, false, fixedWidth: false);
this.Main_BandedGridView.AddLookupEditColumn("ItemUnitID", "ĐVT", 60, ItemUnits, "ItemUnitID", "ItemUnitName", isAllowEdit: false);
string formatString = SoLe_CheckBox.Checked ? "###,###,###,###,##0.00" : "###,###,###,###,##0";
this.Main_BandedGridView.AddSpinEditColumn("DonGiaBQ", "Giá", 100, false, formatString: formatString);
this.Main_BandedGridView.AddSpinEditColumn("LuongDK", "Lượng", 90, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("TienDK", "Tiền", 110, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("SLNhap", "Lượng", 90, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("TTNhap", "Tiền", 110, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("SLXuat", "Lượng", 90, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("TTXuat", "Tiền", 110, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("LuongCK", "Lượng", 90, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("TienCK", "Tiền", 110, false, formatString: formatString, summaryType: DevExpress.Data.SummaryItemType.Sum);
// add band
Main_BandedGridView.AddBand("Sản phẩm", "ItemID", "ItemName", "ItemSName", "ItemUnitID");
Main_BandedGridView.AddBand("", "DonGiaBQ");
Main_BandedGridView.AddBand("Đầu kỳ", "LuongDK", "TienDK");
Main_BandedGridView.AddBand("Nhập", "SLNhap", "TTNhap");
Main_BandedGridView.AddBand("Xuất", "SLXuat", "TTXuat");
Main_BandedGridView.AddBand("Cuối kỳ", "LuongCK", "TienCK");
}
private void ShowChiTietTaiKhoan()
{
var selected = Main_BandedGridView.GetFocusedRow().CastTo <GetCanDoiSoPhatSinhTaiKhoan>();
if (selected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000026);
return;
}
ChiTietTaiKhoan.ChiTietTaiKhoanInput input = new ChiTietTaiKhoan.ChiTietTaiKhoanInput
{
FromDate = this.FromDate,
ToDate = this.ToDate,
SelectedData = selected
};
ChiTietTaiKhoan chiTietTaiKhoan = new ChiTietTaiKhoan(input);
chiTietTaiKhoan.ShowDialog();
}
private void ShowBCTheKho()
{
var selected = Main_BandedGridView.GetFocusedRow().CastTo <GetTongHopKho>();
if (selected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000026);
return;
}
List <TheKho> reportData = GetTheKho(selected.ItemID);
List <ReportParam> param = new List <ReportParam>
{
new ReportParam("FromDate", FromDate),
new ReportParam("ToDate", ToDate)
};
ReportHelper.ShowPreview(ReportTemplate.RPT009, reportData, param);
}
private void InitGridView()
{
this.Main_BandedGridView.Columns.Clear();
this.Main_BandedGridView.Bands.Clear();
this.Main_BandedGridView.AddColumn("AccountID", "Mã TK", 70, false);
this.Main_BandedGridView.AddColumn("AccountDetailID", "Tkê", 70, false);
this.Main_BandedGridView.AddColumn("CustomerSName", "Mã", 70, false);
this.Main_BandedGridView.AddColumn("CustomerName", "Tên", 200, false);
this.Main_BandedGridView.AddSpinEditColumn("DKNo", "Nợ", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("DKCo", "Có", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("PSNo", "Nợ", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("PSCo", "Có", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("CKNo", "Nợ", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("CKCo", "Có", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
// add band
Main_BandedGridView.AddBand("Tài khoản", "AccountID", "AccountDetailID");
Main_BandedGridView.AddBand("Khách hàng", "CustomerSName", "CustomerName");
Main_BandedGridView.AddBand("Đầu kỳ", "DKNo", "DKCo");
Main_BandedGridView.AddBand("Phát sinh", "PSNo", "PSCo");
Main_BandedGridView.AddBand("Cuối kỳ", "CKNo", "CKCo");
}
private void InitGridView()
{
this.Main_BandedGridView.Columns.Clear();
this.Main_BandedGridView.Bands.Clear();
this.Main_BandedGridView.AddColumn("AccountID", "Mã TK", 70, false);
this.Main_BandedGridView.AddColumn("AccountName", "Tên Tài Khoản", 300, false, fixedWidth: false);
if (TypeSearch_LookUpEdit.ItemIndex > 0)
{
this.Main_BandedGridView.AddColumn("AccountDetailID", "T.kê", 50, false);
}
string columnCaption;
switch (CommonInfo.CompanyInfo.CompanyType)
{
case "DL":
columnCaption = DULICH;
break;
case "XD":
columnCaption = XAYDUNG;
break;
case "SX":
columnCaption = SANXUAT;
break;
default:
columnCaption = SANXUAT;
break;
}
if (TypeSearch_LookUpEdit.ItemIndex.In(3, 4))
{
this.Main_BandedGridView.AddColumn("QLMa", columnCaption, 80, false);
}
if (TypeSearch_LookUpEdit.ItemIndex.In(2, 4))
{
//this.Main_BandedGridView.AddLookupEditColumn("CustomerID", "Mã KH", 90, Customers, "CustomerID", "CustomerSName", isAllowEdit: false);
this.Main_BandedGridView.AddColumn("CustomerSName", "Mã KH", 90, false);
}
this.Main_BandedGridView.AddSpinEditColumn("DKNo", "Nợ", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("DKCo", "Có", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("PSNo", "Nợ", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("PSCo", "Có", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("CKNo", "Nợ", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
this.Main_BandedGridView.AddSpinEditColumn("CKCo", "Có", 110, false, summaryType: DevExpress.Data.SummaryItemType.Sum);
// add band
Main_BandedGridView.AddBand("", "AccountID", "AccountDetailID", "AccountName", "QLMa", "CustomerSName");
Main_BandedGridView.AddBand("Số dư đầu kỳ", "DKNo", "DKCo");
Main_BandedGridView.AddBand("Phát sinh trong kỳ", "PSNo", "PSCo");
Main_BandedGridView.AddBand("Số dư cuối kỳ", "CKNo", "CKCo");
if (TypeSearch_LookUpEdit.ItemIndex == 0)
{
this.Main_BandedGridView.AddColumn("NoteStatusColor", "", 30, false);
Main_BandedGridView.AddBand("", "NoteStatusColor");
}
}