public void gettieudegau(string tungay, string denngay, string makhuyenmai)
{
xrLabel5.Text = "BÁO CÁO ĐỐI CHIẾU CHIẾT KHẤU GẤU ĐỎ";
xrLabel1.Text = gen.GetString("select Top 1 CompanyName from Center");
xrLabel2.Text = gen.GetString("select Top 1 Address from Center");
xrLabel6.Text = "MÃ KHUYẾN MÃI - " + makhuyenmai.ToUpper();
xrLabel4.Text = "In lúc: " + String.Format("{0:HH:mm:ss}", DateTime.Now) + " ngày: " + String.Format("{0:dd-MM-yyyy}", DateTime.Now);
DataTable da = new DataTable();
da = gen.GetTable("select Substring(RefNo,7,9) as 'Số phiếu',RefDate as 'Ngày lập',REPLACE(InvoiceNo,'UNI','') as 'Đơn hàng',case when FreeCode='" + makhuyenmai + "' then sotien end as 'Số tiền',case when FreeCode<>'" + makhuyenmai + "' then sotien end as 'Tiền khác', case when FreeCode<>'" + makhuyenmai + "' then FreeCode end 'Chương trình khác',tongtien as 'Tổng tiền',chietkhau as 'Chiết khấu',Case when tongtien-chietkhau<>0 then tongtien-chietkhau end as 'Chênh lệch' from (select a.InvoiceNo,FreeCode,sotien,tongtien from (select a.InvoiceNo,FreeCode,SUM(Amount) as sotien from (select * from INOutwardCheck where Amount<>0) a, (select distinct InvoiceNo from INOutwardCheck where FreeCode='" + makhuyenmai + "') b where a.InvoiceNo=b.InvoiceNo group by a.InvoiceNo,FreeCode) a,(select a.InvoiceNo,SUM(Amount) as tongtien from (select * from INOutwardCheck where Amount<>0) a, (select distinct InvoiceNo from INOutwardCheck where FreeCode='" + makhuyenmai + "') b where a.InvoiceNo=b.InvoiceNo group by a.InvoiceNo) b where a.InvoiceNo=b.InvoiceNo) a,(select RefNo,RefDate,JournalMemo,Round(TotalFreightAmount/1.1,0) as chietkhau from INOutward) b where a.InvoiceNo=b.JournalMemo order by RefNo,RefDate,[Số tiền] DESC");
DataSource = da;
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal2 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
XRSummary summarytotal4 = new XRSummary();
XRSummary summarytotal5 = new XRSummary();
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Đơn hàng");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell10.DataBindings.Add("Text", DataSource, "Đơn hàng");
xrTableCell9.DataBindings.Add("Text", DataSource, "Ngày lập", "{0:dd/MM/yy}");
xrTableCell8.DataBindings.Add("Text", DataSource, "Số phiếu");
xrTableCell15.DataBindings.Add("Text", DataSource, "Chiết khấu", "{0:n0}");
xrTableCell18.DataBindings.Add("Text", DataSource, "Chênh lệch", "{0:n0}");
summarytotal.Running = SummaryRunning.Group;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell11.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
xrTableCell11.Summary = summarytotal;
summarytotal1.Running = SummaryRunning.Group;
summarytotal1.IgnoreNullValues = true;
summarytotal1.FormatString = "{0:n0}";
xrTableCell12.DataBindings.Add("Text", DataSource, "Tiền khác", "{0:n0}");
xrTableCell12.Summary = summarytotal1;
summarytotal4.Running = SummaryRunning.Report;
summarytotal4.IgnoreNullValues = true;
summarytotal4.FormatString = "{0:n0}";
xrTableCell20.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
xrTableCell20.Summary = summarytotal4;
summarytotal5.Running = SummaryRunning.Report;
summarytotal5.IgnoreNullValues = true;
summarytotal5.FormatString = "{0:n0}";
xrTableCell21.DataBindings.Add("Text", DataSource, "Tiền khác", "{0:n0}");
xrTableCell21.Summary = summarytotal5;
xrTableCell22.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
xrTableCell24.DataBindings.Add("Text", DataSource, "Tiền khác", "{0:n0}");
xrTableCell26.DataBindings.Add("Text", DataSource, "Chương trình khác");
}
private void GetBands()
{
try
{
FacebookContext context = new FacebookContext();
context.Load <Band>(context.GetBandsQuery(AccessToken),
(loadOp) =>
{
if (!loadOp.HasError)
{
Bands.Clear();
foreach (Band band in loadOp.Entities)
{
Bands.Add(band);
}
}
else
{
MessageBox.Show(loadOp.Error.ToString());
}
},
null);
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void BindDataSum(DataTable da)
{
xrTable4.Visible = false;
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Số phiếu");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell1.DataBindings.Add("Text", DataSource, "Số phiếu");
xrTableCell2.DataBindings.Add("Text", DataSource, "Ngày", "{0:dd-MM-yyyy}");
xrTableCell3.DataBindings.Add("Text", DataSource, "Lý do");
xrTableCell4.DataBindings.Add("Text", DataSource, "Nhân viên");
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
summarytotal.Running = SummaryRunning.Group;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell20.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
xrTableCell20.Summary = summarytotal;
summarytotal1.Running = SummaryRunning.Report;
summarytotal1.IgnoreNullValues = true;
summarytotal1.FormatString = "{0:n0}";
xrTableCell19.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
xrTableCell19.Summary = summarytotal1;
xrTableCell7.DataBindings.Add("Text", DataSource, "Tài khoản nợ");
xrTableCell10.DataBindings.Add("Text", DataSource, "Tài khoản có");
xrTableCell11.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
}
public void AddMarginBands()
{
// Check if the TopMargin band already presents in the report.
if (Bands.GetBandByType(typeof(TopMarginBand)) == null)
{
// Create a new TopMargin band and add it to the report.
TopMarginBand tmBand = new TopMarginBand();
Bands.Add(tmBand);
// Create a label and set its text and width.
XRLabel label = new XRLabel();
label.Text = "TopMargin Band";
label.Width = 200;
// Add the label to the TopMargin band.
tmBand.Controls.Add(label);
}
// Check if the BottomMargin band already presents in the report.
if (Bands.GetBandByType(typeof(BottomMarginBand)) == null)
{
// Create a new BottomMargin band and add it to the report.
BottomMarginBand bmBand = new BottomMarginBand();
Bands.Add(bmBand);
// Create an XRPageInfo object and set its width and PageInfo option.
XRPageInfo datePageInfo = new XRPageInfo();
datePageInfo.Width = 200;
datePageInfo.PageInfo = PageInfo.DateTime;
// Add the page information control to the BottomMargin band.
bmBand.Controls.Add(datePageInfo);
}
}
public void BindDatakm(DataTable da)
{
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField1 = new GroupField("Mã hàng");
GroupHeader1.GroupFields.Add(groupField1);
xrTableCell1.DataBindings.Add("Text", DataSource, "Mã hàng");
xrTableCell3.DataBindings.Add("Text", DataSource, "Tên hàng");
xrTableCell4.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
XRSummary summary = new XRSummary();
summary.Running = SummaryRunning.Group;
summary.IgnoreNullValues = true;
summary.FormatString = "{0:n0}";
xrTableCell4.Summary = summary;
xrTableCell5.DataBindings.Add("Text", DataSource, "Trọng lượng", "{0:n2}");
XRSummary summary1 = new XRSummary();
summary1.Running = SummaryRunning.Group;
summary1.IgnoreNullValues = true;
summary1.FormatString = "{0:n2}";
xrTableCell5.Summary = summary1;
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
XRSummary summarytotal4 = new XRSummary();
XRSummary summarytotal5 = new XRSummary();
XRSummary summarytotal6 = new XRSummary();
XRSummary summarytotal7 = new XRSummary();
XRSummary summarytotal8 = new XRSummary();
summarytotal.Running = SummaryRunning.Report;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell22.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell22.Summary = summarytotal;
summarytotal1.Running = SummaryRunning.Report;
summarytotal1.IgnoreNullValues = true;
summarytotal1.FormatString = "{0:n2}";
xrTableCell23.DataBindings.Add("Text", DataSource, "Trọng lượng", "{0:n2}");
xrTableCell23.Summary = summarytotal1;
xrTableCell16.DataBindings.Add("Text", DataSource, "Ngày lập", "{0:dd-MM-yyyy}");
xrTableCell11.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell12.DataBindings.Add("Text", DataSource, "Trọng lượng", "{0:n2}");
xrTableCell6.DataBindings.Add("Text", DataSource, "Phiếu");
xrTableCell10.DataBindings.Add("Text", DataSource, "Tên khách");
}
public override void Init(bool setToDefaultValues = false)
{
FSystem.LockDsp();
Bands.Clear();
var gainValues = !setToDefaultValues && EqualizerSettings != null ? EqualizerSettings.GainValues : null;
foreach (var value in EqDefaultValues)
{
var band = GetEqualizerBand(IsEnabled, value[0], value[1], value[2]);
if (band == null)
{
continue;
}
((FmodEqualizerBand)band).PropertyChanged += (sender, e) =>
{
if (e.PropertyName == "Gain")
{
SaveEqualizerSettings();
}
};
if (gainValues != null && gainValues.TryGetValue(band.BandCaption, out float savedValue))
{
band.Gain = savedValue;
}
Bands.Add(band);
}
FSystem.UnlockDsp();
}
public void AddBand(int order, AvrViewBand band)
{
band.ViewID = m_ViewID;
band.SavePivotSettings(order, band);
band.SetUnchanged();
band.Owner = this;
Bands.Add(band);
}
public void BindData2(DataTable da)
{
GroupHeader1.Visible = true;
xrTable10.Visible = true;
xrTable11.Visible = true;
xrTableCell18.Text = "Ghi chú";
DataSource = da;
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Nhóm");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell2.DataBindings.Add("Text", DataSource, "Nhóm");
xrTableCell4.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
XRSummary summary = new XRSummary();
summary.Running = SummaryRunning.Group;
summary.IgnoreNullValues = true;
summary.FormatString = "{0:n0}";
xrTableCell4.Summary = summary;
xrTableCell5.DataBindings.Add("Text", DataSource, "Số lượng quy đổi", "{0:n2}");
XRSummary summary1 = new XRSummary();
summary1.Running = SummaryRunning.Group;
summary1.IgnoreNullValues = true;
summary1.FormatString = "{0:n2}";
xrTableCell5.Summary = summary1;
summarytotal.Running = SummaryRunning.Report;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell22.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell22.Summary = summarytotal;
summarytotal1.Running = SummaryRunning.Report;
summarytotal1.IgnoreNullValues = true;
summarytotal1.FormatString = "{0:n2}";
xrTableCell23.DataBindings.Add("Text", DataSource, "Số lượng quy đổi", "{0:n2}");
xrTableCell23.Summary = summarytotal1;
xrTableCell16.DataBindings.Add("Text", DataSource, "Mã hàng");
xrTableCell10.DataBindings.Add("Text", DataSource, "Tên hàng");
xrTableCell11.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell12.DataBindings.Add("Text", DataSource, "Số lượng quy đổi", "{0:n2}");
}
// this constructor creates object from database
public AvrViewBand(DataRow row, DataSet ds, string tableBands, string tableColumns)
{
m_ID = (long)row["idfViewBand"];
m_ViewID = (long)row["idfView"];
UniquePath = (string)row["UniquePath"];
OriginalName = (string)row["strOriginalName"];
var ids = row["idfLayoutSearchField"];
if (!Utils.IsEmpty(ids))
{
LayoutSearchFieldId = (long)ids;
}
ids = row["strDisplayName"];
if (!Utils.IsEmpty(ids))
{
m_DisplayText = (string)ids;
}
m_Visible = (bool)row["blnVisible"];
m_Freeze = (bool)row["blnFreeze"];
ids = row["intOrder"];
if (!Utils.IsEmpty(ids))
{
m_Order = (int)ids;
}
else
{
m_Order = 0;
}
var drChild = ds.Tables[tableBands].Select(string.Format("idfParentViewBand = {0}", row["idfViewBand"]), "intOrder",
DataViewRowState.CurrentRows);
if (drChild.Length > 0)
{
foreach (var r in drChild)
{
Bands.Add(new AvrViewBand(r, ds, tableBands, tableColumns)
{
Owner = this
});
}
}
var drChildCols = ds.Tables[tableColumns].Select(string.Format("idfViewBand = {0}", row["idfViewBand"]), "intOrder",
DataViewRowState.CurrentRows);
if (drChildCols.Length > 0)
{
foreach (var r in drChildCols)
{
AddColumn(r);
}
}
}
public void BindData(DataTable da)
{
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Đơn vị");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell43.DataBindings.Add("Text", DataSource, "Đơn vị");
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
XRSummary summarytotal4 = new XRSummary();
XRSummary summarytotal5 = new XRSummary();
XRSummary summarytotal6 = new XRSummary();
XRSummary summarytotal7 = new XRSummary();
XRSummary summarytotal8 = new XRSummary();
summarytotal.Running = SummaryRunning.Report;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell32.DataBindings.Add("Text", DataSource, "Số quá hạn", "{0:n0}");
xrTableCell32.Summary = summarytotal;
/*summarytotal1.Running = SummaryRunning.Report;
* summarytotal1.IgnoreNullValues = true;
* summarytotal1.FormatString = "{0:n0}";
* xrTableCell23.DataBindings.Add("Text", DataSource, "Có đầu kỳ", "{0:n0}");
* xrTableCell23.Summary = summarytotal1;
*
* summarytotal3.Running = SummaryRunning.Report;
* summarytotal3.IgnoreNullValues = true;
* summarytotal3.FormatString = "{0:n0}";
* xrTableCell24.DataBindings.Add("Text", DataSource, "Nợ phát sinh", "{0:n0}");
* xrTableCell24.Summary = summarytotal3;
*
* summarytotal4.Running = SummaryRunning.Report;
* summarytotal4.IgnoreNullValues = true;
* summarytotal4.FormatString = "{0:n0}";
* xrTableCell25.DataBindings.Add("Text", DataSource, "Có phát sinh", "{0:n0}");
* xrTableCell25.Summary = summarytotal4;*/
xrTableCell15.DataBindings.Add("Text", DataSource, "Phiếu");
xrTableCell16.DataBindings.Add("Text", DataSource, "Hóa đơn");
xrTableCell17.DataBindings.Add("Text", DataSource, "Hạn nợ");
xrTableCell18.DataBindings.Add("Text", DataSource, "Số tiền nợ", "{0:0,0}");
xrTableCell19.DataBindings.Add("Text", DataSource, "Ngày nợ", "{0:dd-MM-yyyy}");
xrTableCell20.DataBindings.Add("Text", DataSource, "Phiếu trả");
xrTableCell21.DataBindings.Add("Text", DataSource, "Số tiền trả", "{0:0,0}");
xrTableCell22.DataBindings.Add("Text", DataSource, "Ngày trả", "{0:dd-MM-yyyy}");
xrTableCell23.DataBindings.Add("Text", DataSource, "Số dư nợ", "{0:0,0}");
xrTableCell31.DataBindings.Add("Text", DataSource, "Số quá hạn", "{0:0,0}");
xrTableCell34.DataBindings.Add("Text", DataSource, "Số ngày", "{0:n0}");
}
public void BindDatahoadon(DataTable da)
{
DataSource = da;
GroupHeader2.Visible = false;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Mã nhóm");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell4.DataBindings.Add("Text", DataSource, "Mã nhóm");
xrTableCell5.DataBindings.Add("Text", DataSource, "Tên nhóm");
xrTableCell27.DataBindings.Add("Text", DataSource, "Ghi chú", "{0:dd/MM/yyyy}");
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal2 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
XRSummary summarytotal4 = new XRSummary();
XRSummary summarytotal5 = new XRSummary();
summarytotal3.Running = SummaryRunning.Group;
summarytotal3.IgnoreNullValues = true;
summarytotal3.FormatString = "{0:n0}";
xrTableCell13.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell13.Summary = summarytotal3;
summarytotal5.Running = SummaryRunning.Group;
summarytotal5.IgnoreNullValues = true;
summarytotal5.FormatString = "{0:n0}";
xrTableCell19.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
xrTableCell19.Summary = summarytotal5;
summarytotal.Running = SummaryRunning.Report;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell7.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell7.Summary = summarytotal;
summarytotal1.Running = SummaryRunning.Report;
summarytotal1.IgnoreNullValues = true;
summarytotal1.FormatString = "{0:n0}";
xrTableCell11.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
xrTableCell11.Summary = summarytotal1;
xrTableCell1.DataBindings.Add("Text", DataSource, "Mã hàng");
xrTableCell2.DataBindings.Add("Text", DataSource, "Tên hàng");
xrTableCell9.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell12.DataBindings.Add("Text", DataSource, "Số lượng quy đổi", "{0:n2}");
xrTableCell3.DataBindings.Add("Text", DataSource, "Số tiền", "{0:n0}");
}
public void LoadDummyData()
{
Bands.Clear();
Bands.Add(new Band {
Id = 1, Name = "Band 1", Genre = "Testing 123", Country = "Romania"
});
Bands.Add(new Band {
Id = 2, Name = "Murica is the best", Genre = "C", Country = "'murica"
});
Bands.Add(new Band {
Id = 3, Name = "Generic band name is so much generic wow", Genre = "Generic genre is generic", Country = "Generic country is generic"
});
}
public new void RecreateHandle()
{
RebarBand[] btns = GetTRebarBands();
Bands.Clear();
bands = null;
bandsCount = 0;
base.RecreateHandle();
for (int i = 0; i < btns.Length; i++)
{
Bands.Add(btns[i]);
}
}
public void BindData(DataTable da)
{
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Mã kho");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell2.DataBindings.Add("Text", DataSource, "Mã kho");
xrTableCell3.DataBindings.Add("Text", DataSource, "Tên kho");
xrTableCell4.DataBindings.Add("Text", DataSource, "Doanh thu", "{0:n0}");
XRSummary summary = new XRSummary();
summary.Running = SummaryRunning.Group;
summary.IgnoreNullValues = true;
summary.FormatString = "{0:n0}";
xrTableCell4.Summary = summary;
xrTableCell7.DataBindings.Add("Text", DataSource, "Thuế", "{0:n0}");
XRSummary summary2 = new XRSummary();
summary2.Running = SummaryRunning.Group;
summary2.IgnoreNullValues = true;
summary2.FormatString = "{0:n0}";
xrTableCell7.Summary = summary2;
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
summarytotal.Running = SummaryRunning.Report;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell22.DataBindings.Add("Text", DataSource, "Doanh thu", "{0:n0}");
xrTableCell22.Summary = summarytotal;
summarytotal3.Running = SummaryRunning.Report;
summarytotal3.IgnoreNullValues = true;
summarytotal3.FormatString = "{0:n0}";
xrTableCell24.DataBindings.Add("Text", DataSource, "Thuế", "{0:n0}");
xrTableCell24.Summary = summarytotal3;
xrTableCell11.DataBindings.Add("Text", DataSource, "Doanh thu", "{0:n0}");
xrTableCell12.DataBindings.Add("Text", DataSource, "Thuế suất");
xrTableCell13.DataBindings.Add("Text", DataSource, "Thuế", "{0:n0}");
}
public void gettieudebk(string ngaychungtu)
{
xrLabel1.Text = gen.GetString("select Top 1 CompanyName from Center");
xrLabel3.Text = gen.GetString("select Top 1 Address from Center");
xrLabel5.Text = "Đến ngày " + string.Format("{0:dd}", DateTime.Parse(ngaychungtu)) + " tháng " + string.Format("{0:MM}", DateTime.Parse(ngaychungtu)) + " năm " + string.Format("{0:yyyy}", DateTime.Parse(ngaychungtu));
xrLabel4.Text = "In lúc: " + String.Format("{0:HH:mm:ss}", DateTime.Now) + " ngày: " + String.Format("{0:dd-MM-yyyy}", DateTime.Now);
DataTable da = gen.GetTable("select SUBSTRING(RefNo,7,9) as 'Số phiếu',RefDate as 'Ngày',AccountingObjectName as 'Tên khách',DebitAmount as 'Thành tiền',case when Note='' then CreditAmount end as 'Nợ',EmployeeIDSAName as 'Nhân viên',case when Note<>'' then N'Chưa giao' else NoteMain end as 'Ghi chú', EmployeeIDSACode as 'Ngành' from OpeningAccountEntry131TTBackup where PostedDate='" + DateTime.Parse(ngaychungtu).ToShortDateString() + "' order by RefDate,SUBSTRING(RefNo,7,9)");
if (da.Rows.Count == 0)
{
da = gen.GetTable("select SUBSTRING(RefNo,7,9) as 'Số phiếu',RefDate as 'Ngày',AccountingObjectName as 'Tên khách',DebitAmount as 'Thành tiền',case when Note='' then CreditAmount end as 'Nợ',EmployeeIDSAName as 'Nhân viên',case when Note<>'' then N'Chưa giao' else NoteMain end as 'Ghi chú', EmployeeIDSACode as 'Ngành' from OpeningAccountEntry131TTBackup where PostedDate=(select MAX(PostedDate) from OpeningAccountEntry131TTBackup where PostedDate<'" + DateTime.Parse(ngaychungtu).ToShortDateString() + "') order by RefDate,SUBSTRING(RefNo,7,9)");
}
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField1 = new GroupField("Ngành");
GroupHeader1.GroupFields.Add(groupField1);
xrTableCell14.DataBindings.Add("Text", DataSource, "Ngành");
xrTableCell18.DataBindings.Add("Text", DataSource, "Nợ", "{0:n0}");
XRSummary summary1 = new XRSummary();
summary1.Running = SummaryRunning.Group;
summary1.IgnoreNullValues = true;
summary1.FormatString = "{0:n0}";
xrTableCell18.Summary = summary1;
XRSummary summarytotal = new XRSummary();
summarytotal.Running = SummaryRunning.Report;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell16.DataBindings.Add("Text", DataSource, "Nợ", "{0:n0}");
xrTableCell16.Summary = summarytotal;
xrTableCell1.DataBindings.Add("Text", DataSource, "Số phiếu");
xrTableCell7.DataBindings.Add("Text", DataSource, "Ngày", "{0:dd/MM/yyyy}");
xrTableCell6.DataBindings.Add("Text", DataSource, "Tên khách");
xrTableCell10.DataBindings.Add("Text", DataSource, "Thành tiền", "{0:n0}");
xrTableCell12.DataBindings.Add("Text", DataSource, "Nợ", "{0:n0}");
xrTableCell13.DataBindings.Add("Text", DataSource, "Nhân viên");
xrTableCell11.DataBindings.Add("Text", DataSource, "Ghi chú");
}
public void CreateNew()
{
if (Bands != null)
{
Bands.Clear();
}
else
{
Bands = new ObservableCollection <EqualizerBand>();
}
for (int i = 0; i < 10; i++)
{
Bands.Add(new EqualizerBand(Bandlabels[i]));
}
Loaded();
}
public void BindData(DataTable da)
{
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Tài khoản tổng hợp");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell2.DataBindings.Add("Text", DataSource, "Tài khoản tổng hợp");
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal2 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
summarytotal.Running = SummaryRunning.Group;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell3.DataBindings.Add("Text", DataSource, "Số tiền nợ", "{0:n0}");
xrTableCell3.Summary = summarytotal;
summarytotal2.Running = SummaryRunning.Group;
summarytotal2.IgnoreNullValues = true;
summarytotal2.FormatString = "{0:n0}";
xrTableCell4.DataBindings.Add("Text", DataSource, "Số tiền có", "{0:n0}");
xrTableCell4.Summary = summarytotal2;
summarytotal1.Running = SummaryRunning.Report;
summarytotal1.IgnoreNullValues = true;
summarytotal1.FormatString = "{0:n0}";
xrTableCell16.DataBindings.Add("Text", DataSource, "Số tiền nợ", "{0:n0}");
xrTableCell16.Summary = summarytotal1;
summarytotal3.Running = SummaryRunning.Report;
summarytotal3.IgnoreNullValues = true;
summarytotal3.FormatString = "{0:n0}";
xrTableCell19.DataBindings.Add("Text", DataSource, "Số tiền có", "{0:n0}");
xrTableCell19.Summary = summarytotal3;
xrTableCell1.DataBindings.Add("Text", DataSource, "Tài khoản");
xrTableCell6.DataBindings.Add("Text", DataSource, "Tên tài khoản");
xrTableCell10.DataBindings.Add("Text", DataSource, "Số tiền nợ", "{0:n0}");
xrTableCell11.DataBindings.Add("Text", DataSource, "Số tiền có", "{0:n0}");
}
/// <summary>
/// Initializes a new instance of the <see cref="GdalRaster{T}"/> class.
/// This can be a raster with multiple bands.
/// </summary>
/// <param name="fileName">The file name.</param>
/// <param name="fromDataset">The dataset.</param>
public GdalRaster(string fileName, Dataset fromDataset)
: base(fromDataset.RasterYSize, fromDataset.RasterXSize)
{
_dataset = fromDataset;
Filename = fileName;
Name = Path.GetFileNameWithoutExtension(fileName);
int numBands = _dataset.RasterCount;
for (int i = 1; i <= numBands; i++)
{
Band band = _dataset.GetRasterBand(i);
if (i == 1)
{
_band = band;
}
Bands.Add(new GdalRaster <T>(fileName, fromDataset, band));
}
ReadHeader();
}
public void PopulateBands(object bands)
{
if (bands != null)
{
string bandsText = bands.ToString();
Bands.Clear();
bandsText.Split('|').ToList().ForEach(band =>
{
if (!string.IsNullOrEmpty(band))
{
Bands.Add(new BandItem()
{
Add = true, BandName = band
});
}
});
}
}
public void gettieude(string tungay, string denngay, string makhuyenmai)
{
xrLabel5.Text = "BÁO CÁO ĐỐI CHIẾU KHUYẾN MÃI UNILEVER";
xrLabel1.Text = gen.GetString("select Top 1 CompanyName from Center");
xrLabel2.Text = gen.GetString("select Top 1 Address from Center");
xrLabel6.Text = "MÃ KHUYẾN MÃI - " + makhuyenmai.ToUpper();
xrLabel7.Text = "Ngày bắt đầu " + String.Format("{0:dd-MM-yyyy}", DateTime.Parse(tungay)) + " Ngày kết thúc " + String.Format("{0:dd-MM-yyyy}", DateTime.Parse(denngay));
xrLabel4.Text = "In lúc: " + String.Format("{0:HH:mm:ss}", DateTime.Now) + " ngày: " + String.Format("{0:dd-MM-yyyy}", DateTime.Now);
DataTable da = gen.GetTable("select Substring(RefNo,7,9) as 'Số phiếu',RefDate as 'Ngày lập',REPLACE(InvoiceNo,'UNI','') as 'Đơn hàng',InventoryItemCode as 'Mã hàng',InventoryItemName as 'Tên hàng',Case when Freecode='" + makhuyenmai + "' then Quantity end as 'Số lượng',Case when Freecode<>'" + makhuyenmai + "' then Quantity end as 'Số lượng khác',Case when Freecode<>'" + makhuyenmai + "' then FreeCode end as 'Chương trình khác',QuantityConvert as 'Ghi nhận',Case when chenhlech<>0 then chenhlech end as 'Chênh lệch' from (select b.RefNo,b.RefDate,a.InvoiceNo,a.Quantity,b.QuantityConvert,FreeCode,COALESCE(Quantity,0)-COALESCE(QuantityConvert,0) as chenhlech,case when b.InventoryItemID Is null then a.InventoryItemID else b.InventoryItemID end mahang from (select a.RefNo,a.RefDate,c.InvoiceNo,QuantityConvert,b.InventoryItemID from INOutward a, INOutwardDetail b, (select distinct InvoiceNo from INOutwardCheck where FreeCode='" + makhuyenmai + "') c where a.ParalellRefNo=c.InvoiceNo and a.RefID=b.RefID and b.Amount=0) b full outer join (select b.InventoryItemID,Quantity,InvoiceNo,FreeCode from (select * from INOutwardCheck a, (select distinct InvoiceNo as hoadon from INOutwardCheck where FreeCode='" + makhuyenmai + "') b where a.InvoiceNo=b.hoadon) a, InventoryItem b where a.InventoryItemCode=b.InventoryItemCode) a on a.InventoryItemID=b.InventoryItemID and a.InvoiceNo=b.InvoiceNo) a, InventoryItem b where a.mahang=b.InventoryItemID order by a.InvoiceNo,[Số lượng] DESC");
DataSource = da;
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal2 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
XRSummary summarytotal4 = new XRSummary();
XRSummary summarytotal5 = new XRSummary();
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Đơn hàng");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell10.DataBindings.Add("Text", DataSource, "Đơn hàng");
xrTableCell9.DataBindings.Add("Text", DataSource, "Ngày lập", "{0:dd/MM/yy}");
xrTableCell8.DataBindings.Add("Text", DataSource, "Số phiếu");
summarytotal4.Running = SummaryRunning.Report;
summarytotal4.IgnoreNullValues = true;
summarytotal4.FormatString = "{0:n0}";
xrTableCell20.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell20.Summary = summarytotal4;
xrTableCell30.DataBindings.Add("Text", DataSource, "Mã hàng");
xrTableCell22.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell24.DataBindings.Add("Text", DataSource, "Số lượng khác", "{0:n0}");
xrTableCell26.DataBindings.Add("Text", DataSource, "Chương trình khác");
xrTableCell27.DataBindings.Add("Text", DataSource, "Ghi nhận", "{0:n0}");
xrTableCell28.DataBindings.Add("Text", DataSource, "Chênh lệch", "{0:n0}");
}
/// <inheritdoc/>
public override void SetDefaults()
{
switch (Config.ReportSettings.DefaultPaperSize)
{
case DefaultPaperSize.A4:
PaperWidth = 210;
PaperHeight = 297;
break;
case DefaultPaperSize.Letter:
PaperWidth = 215.9f;
PaperHeight = 279.4f;
break;
}
float baseHeight = Units.Millimeters * 10;
if (ReportWorkspace.Grid.GridUnits == PageUnits.Inches ||
ReportWorkspace.Grid.GridUnits == PageUnits.HundrethsOfInch)
{
baseHeight = Units.Inches * 0.4f;
}
ReportTitle = new ReportTitleBand();
ReportTitle.CreateUniqueName();
ReportTitle.Height = baseHeight;
PageHeader = new PageHeaderBand();
PageHeader.CreateUniqueName();
PageHeader.Height = baseHeight * 0.75f;
DataBand data = new DataBand();
Bands.Add(data);
data.CreateUniqueName();
data.Height = baseHeight * 2;
PageFooter = new PageFooterBand();
PageFooter.CreateUniqueName();
PageFooter.Height = baseHeight * 0.5f;
}
public void Update(EffectBand effectBand)
{
// lock band to particular effect if needed
if (!effectBand.Info.CanShareBand)
{
UniqueEffectId = effectBand.Info.EffectId;
}
Bands.Add(effectBand);
if (effectBand.Height > Height)
{
Height = effectBand.Height;
}
if (FirstBeat == null || FirstBeat.Index > effectBand.FirstBeat.Index)
{
FirstBeat = effectBand.FirstBeat;
}
if (LastBeat == null || LastBeat.Index < effectBand.LastBeat.Index)
{
LastBeat = effectBand.LastBeat;
}
}
public override void Init(bool setToDefaultValues = false)
{
// Set peaking equalizer effect with no bands
_eq = new PeakEQParameters();
_fxEq = Bass.ChannelSetFX(_handle, EffectType.PeakEQ, 0);
_eq.fQ = 0f;
_eq.fBandwidth = 2.5f;
_eq.lChannel = FXChannelFlags.All;
//init equalizer bands
Bands.Clear();
var gainValues = !setToDefaultValues && EqualizerSettings != null ? EqualizerSettings.GainValues : null;
for (int i = 0; i < EqDefaultValues.Length; i++)
{
_eq.lBand = i;
_eq.fCenter = EqDefaultValues[i][0];
var res = Bass.FXSetParameters(_fxEq, _eq);
var band = new BassEqualizerBand(_fxEq, i, EqDefaultValues[i][0], EqDefaultValues[i][1], IsEnabled);
if (band == null)
{
continue;
}
band.PropertyChanged += (sender, e) =>
{
if (e.PropertyName == "Gain")
{
SaveEqualizerSettings();
}
};
if (gainValues != null && gainValues.TryGetValue(band.BandCaption, out float savedValue))
{
band.Gain = savedValue;
}
Bands.Add(band);
}
}
public void BindData(DataTable da)
{
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Loại");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell23.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n2}");
XRSummary summary = new XRSummary();
summary.Running = SummaryRunning.Group;
summary.IgnoreNullValues = true;
summary.FormatString = "{0:n2}";
xrTableCell23.Summary = summary;
xrTableCell15.DataBindings.Add("Text", DataSource, "STT");
xrTableCell16.DataBindings.Add("Text", DataSource, "Tên hàng");
xrTableCell17.DataBindings.Add("Text", DataSource, "ĐVT");
xrTableCell18.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n2}");
}
private void OnDatasetChanged()
{
GdalProjectionInfo projection = null;
Bands.Clear();
if (Dataset != null)
{
int numBands = Dataset.RasterCount;
for (int i = 1; i <= numBands; i++)
{
Band band = Dataset.GetRasterBand(i);
if (i == 1)
{
_band = band;
}
Bands.Add(new GdalRasterSet <T>(Filename, Dataset, band));
}
projection = new GdalProjectionInfo(Dataset.GetProjection());
}
Projection = projection;
ReadHeader();
}
public void Update(EffectBand effectBand)
{
// lock band to particular effect if needed
if (!effectBand.Info.CanShareBand)
{
Shared.UniqueEffectId = effectBand.Info.EffectId;
}
effectBand.Slot = this;
Bands.Add(effectBand);
if (effectBand.Height > Shared.Height)
{
Shared.Height = effectBand.Height;
}
if (Shared.FirstBeat == null || effectBand.FirstBeat.IsBefore(Shared.FirstBeat))
{
Shared.FirstBeat = effectBand.FirstBeat;
}
if (Shared.LastBeat == null || effectBand.LastBeat.IsAfter(Shared.LastBeat))
{
Shared.LastBeat = effectBand.LastBeat;
}
}
public AvrView(DataSet ds, string tableView, string tableBands, string tableColumns)
{
var row = ds.Tables[tableView].Rows[0];
m_ViewID = (long)row["idflLayout"];
QueryID = (long)row["idflQuery"];
var ids = row["ChartXAxisViewColumn"];
if (!Utils.IsEmpty(ids))
{
m_ChartXAxisViewColumn = (string)ids;
}
ids = row["MapAdminUnitViewColumn"];
if (!Utils.IsEmpty(ids))
{
m_MapAdminUnitViewColumn = (string)ids;
}
ids = row["idfGlobalView"];
if (!Utils.IsEmpty(ids))
{
m_GlobalView = (long?)ids;
}
ids = row["intGisLayerPosition"];
if (!Utils.IsEmpty(ids))
{
m_GisLayerPosition = (int?)ids;
}
var readOnly = row["blnReadOnly"];
IsReadOnly = readOnly is bool && (bool)readOnly;
ids = row["blbChartLocalSettings"];
if (!Utils.IsEmpty(ids))
{
ChartLocalSettingsZip = (byte[])ids;
}
ids = row["blbGisLayerLocalSettings"];
if (!Utils.IsEmpty(ids))
{
GisLayerLocalSettingsZip = (byte[])ids;
}
ids = row["blbGisMapLocalSettings"];
if (!Utils.IsEmpty(ids))
{
GisMapLocalSettingsZip = (byte[])ids;
}
ids = row["blbViewSettings"];
if (!Utils.IsEmpty(ids))
{
ViewSettingsZip = (byte[])ids;
}
if (m_ChartLocalSettingsZip != null)
{
m_ChartLocalSettingsXml = BinaryCompressor.UnzipString(m_ChartLocalSettingsZip);
}
if (m_GisLayerLocalSettingsZip != null)
{
m_GisLayerLocalSettingsXml = BinaryCompressor.UnzipString(m_GisLayerLocalSettingsZip);
}
if (m_GisMapLocalSettingsZip != null)
{
m_GisMapLocalSettingsXml = BinaryCompressor.UnzipString(m_GisMapLocalSettingsZip);
}
if (m_ViewSettingsZip != null)
{
m_ViewSettingsXml = BinaryCompressor.UnzipString(m_ViewSettingsZip);
}
var drTop = ds.Tables[tableBands].Select("idfParentViewBand is null", "intOrder", DataViewRowState.CurrentRows);
foreach (var r in drTop)
{
Bands.Add(new AvrViewBand(r, ds, tableBands, tableColumns)
{
Owner = this
});
}
var drChildCols = ds.Tables[tableColumns].Select("idfViewBand is null", "intOrder", DataViewRowState.CurrentRows);
if (drChildCols.Length > 0)
{
foreach (var r in drChildCols)
{
AddColumn(r);
}
}
}
public void gettieude(string role)
{
DataTable temp = gen.GetTable("select AccountingObjectCode,a.AccountingObjectName,a.AccountingObjectAddress,b.Contactname,RefDate,RefNo,c.StockID,Tel,ShippingNo,FullName,TotalAmountOC,TotalAmount-TotalFreightAmount+TotalAmountOC,Tax,b.AccountingObjectName,CustomField6,a.Contactname,TotalFreightAmount from INOutwardLPG a, AccountingObject b,Stock c,MSC_User d where a.EmployeeID=d.UserID and a.AccountingObjectID=b.AccountingObjectID and a.StockID=c.StockID and a.RefID='" + role + "'");
xrLabel29.Text = xrLabel31.Text = "Ngày " + String.Format("{0:dd}", DateTime.Parse(temp.Rows[0][4].ToString())) + " tháng " + String.Format("{0:MM}", DateTime.Parse(temp.Rows[0][4].ToString())) + " năm " + String.Format("{0:yyyy}", DateTime.Parse(temp.Rows[0][4].ToString()));
xrLabel11.Text = xrLabel21.Text = temp.Rows[0][1].ToString().ToUpper() + "(" + temp.Rows[0][0].ToString() + ")";
xrLabel34.Text = xrLabel13.Text = temp.Rows[0][2].ToString().ToUpper();
xrLabel24.Text = temp.Rows[0][7].ToString().ToUpper();
xrLabel26.Text = temp.Rows[0][3].ToString().ToUpper();
xrLabel7.Text = temp.Rows[0][8].ToString().ToUpper();
xrLabel15.Text = temp.Rows[0][15].ToString().ToUpper();
xrLabel9.Text = xrLabel8.Text = "Số " + temp.Rows[0][5].ToString().ToUpper();
//xrLabel30.Text = xrLabel37.Text = "Số tiền bằng chữ: " + doi.ChuyenSo(Double.Parse(temp.Rows[0][11].ToString()).ToString());
Double chietkhau = 0;
if (Double.Parse(temp.Rows[0][16].ToString()) != 0)
{
chietkhau = Double.Parse(temp.Rows[0][16].ToString());
xrTableCell82.Text = String.Format("{0:n0}", chietkhau);
}
DataTable dt = new DataTable();
dt.Columns.Add("Tên hàng", Type.GetType("System.String"));
dt.Columns.Add("ĐVT", Type.GetType("System.String"));
dt.Columns.Add("Số lượng", Type.GetType("System.Double"));
dt.Columns.Add("Đơn giá", Type.GetType("System.Double"));
dt.Columns.Add("Thành tiền", Type.GetType("System.Double"));
dt.Columns.Add("Công ty", Type.GetType("System.String"));
dt.Columns.Add("Địa chỉ", Type.GetType("System.String"));
dt.Columns.Add("Số phiếu", Type.GetType("System.String"));
dt.Columns.Add("STT", Type.GetType("System.String"));
dt.Columns.Add("Mã hàng", Type.GetType("System.String"));
DataTable congty = gen.GetTable("select distinct Description from INOutwardLPGDetail where RefID='" + role + "'");
for (int i = 0; i < congty.Rows.Count; i++)
{
Double tongtien = 0;
if (congty.Rows[i][0].ToString() == "HAMACO")
{
xrLabel39.Text = gen.GetString("select RefNo from hamaco.dbo.INOutward where INOutwardRefID='" + role + "'");
}
else if (congty.Rows[i][0].ToString() == "Thiên An")
{
xrLabel40.Text = gen.GetString("select RefNo from hamaco_ta.dbo.INOutward where INOutwardRefID='" + role + "'");
}
else if (congty.Rows[i][0].ToString() == "Dịch vụ HAMACO")
{
xrLabel41.Text = gen.GetString("select RefNo from hamaco_tn.dbo.INOutward where INOutwardRefID='" + role + "'");
}
temp = gen.GetTable("bangkedondathanglpg '" + role + "',N'" + congty.Rows[i][0].ToString() + "'");
for (int j = 0; j < 8; j++)
{
DataRow dr = dt.NewRow();
if (j < temp.Rows.Count)
{
dr[0] = temp.Rows[j][0];
dr[1] = temp.Rows[j][1];
dr[2] = temp.Rows[j][2];
dr[3] = temp.Rows[j][3];
dr[4] = temp.Rows[j][4];
tongtien = tongtien + Double.Parse(temp.Rows[j][4].ToString());
dr[5] = temp.Rows[j][5];
dr[6] = temp.Rows[j][6];
dr[7] = temp.Rows[j][7];
dr[8] = j + 1;
dr[9] = temp.Rows[j][8];
}
else
{
dr[5] = temp.Rows[0][5];
dr[6] = temp.Rows[0][6];
dr[7] = temp.Rows[0][7];
}
dt.Rows.Add(dr);
}
xrTableCell108.Text = String.Format("{0:n0}", tongtien - chietkhau);
xrLabel30.Text = xrLabel37.Text = "Số tiền bằng chữ: " + doi.ChuyenSo((tongtien - chietkhau).ToString());
}
temp = gen.GetTable("bangkedondathanglpg '" + role + "','chung'");
for (int i = 0; i < 9; i++)
{
if (i < temp.Rows.Count)
{
xrTable7.Rows[i].Cells[1].Text = temp.Rows[i][0].ToString();
xrTable7.Rows[i].Cells[2].Text = temp.Rows[i][1].ToString();
xrTable7.Rows[i].Cells[3].Text = Double.Parse(temp.Rows[i][2].ToString()).ToString();
}
}
DataSource = dt;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Công ty");
GroupHeader1.GroupFields.Add(groupField);
xrLabel1.DataBindings.Add("Text", DataSource, "Công ty");
xrLabel6.DataBindings.Add("Text", DataSource, "Địa chỉ");
//xrLabel9.DataBindings.Add("Text", DataSource, "Số phiếu");
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal2 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
summarytotal.Running = SummaryRunning.Group;
summarytotal.IgnoreNullValues = true;
summarytotal.FormatString = "{0:n0}";
xrTableCell46.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell46.Summary = summarytotal;
/*
* summarytotal1.Running = SummaryRunning.Group;
* summarytotal1.IgnoreNullValues = true;
* summarytotal1.FormatString = "{0:n0}";
* xrTableCell108.DataBindings.Add("Text", DataSource, "Thành tiền", "{0:n0}");
* xrTableCell108.Summary = summarytotal1;
*/
summarytotal2.Running = SummaryRunning.Report;
summarytotal2.IgnoreNullValues = true;
summarytotal2.FormatString = "{0:n0}";
xrLabel28.DataBindings.Add("Text", DataSource, "Thành tiền", "{0:n0}");
xrLabel28.Summary = summarytotal2;
summarytotal3.Running = SummaryRunning.Report;
summarytotal3.IgnoreNullValues = true;
summarytotal3.FormatString = "{0:n0}";
xrTableCell106.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell106.Summary = summarytotal3;
xrTableCell2.DataBindings.Add("Text", DataSource, "STT");
xrTableCell3.DataBindings.Add("Text", DataSource, "Tên hàng");
xrTableCell4.DataBindings.Add("Text", DataSource, "ĐVT");
xrTableCell5.DataBindings.Add("Text", DataSource, "Số lượng", "{0:n0}");
xrTableCell8.DataBindings.Add("Text", DataSource, "Mã hàng");
}
public void AddStaticData()
{
Artists.Add(new Artist
{
Name = "Kathy Reid-Naiman",
Email = "*****@*****.**",
WebPageUrl = "",
ImageUrl = "",
Article =
@"<p><span><span>Kathy Reid-Naiman</span> </span>is a full time children's performer, and a member of <a href='http://www.mits.on.ca/'>Mariposa in the Schools</a>, an organization dedicated to bringing quality musical experiences to school children in Ontario. She is also a member of the <a href='http://www.cmnonline.org/'>Children's Music Network</a>. Her children's recordings; Tickles & Tunes, More Tickles & Tunes, Say Hello to the Morning, A Smooth Road to London Town, On My Way to Dreamland and Reaching For the Stars! have become very popular with pre-school teachers and families with toddler's & young children. She has been teaching classes for young children 6 months to 6 years old and their caregivers since 1982 in libraries in Ontario. She is currently running classes in <a href='http://www.library.aurora.on.ca/page/children/programs/preschoolers'> Aurora,</a> and <a href='http://www.uxlib.com/modules/kid_teen/kids/kprog.html'>Uxbridge</a>.</p>
<p></p>
<p></p>
<p>Kathy has presented workshops for the American Library Association, the Ontario Library Association, the Southern Ontario Libraries Services, Frontier College, the National Association for the Education of the Young Child, the California Association for the Education of the Young Child and the Children’s Music Network’s national gatherings.</p>
<p></p>
<p>Kathy is very active as a folk-musician. She plays with Arnie Naiman as <a href='http://www.merriweather.ca/artist.aspx?ID=18'>Ragged but Right</a> and she is the fiddler for The Toronto Women's Sword Team.</p>
<p>She has performed at Mariposa, Winnipeg, Northern Lights festivals and The International Sword Gathering in Scarborough, England and has been on staff at <a href='http://www.cdss.org/'>Pinewoods Music and Dance Camp</a> in Massachusetts and Ogontz Camp in New Hampshire and <a href='http://www.mgl.ca/%7Ejhcole/thewoods/thewoods.html'>The Woods</a> music and dance camp in Muskoka. She plays guitar, fiddle, Appalachian dulcimer, autoharp and banjo uke.</p>
<p></p>
<p><a href='http://www.merriweather.ca/artist.aspx?ID=18'>Ragged But Right</a> has released a brand new cd of mostly old time singing duets. The cd is called <a href='http://www.merriweather.ca/albums.aspx?ID=37'>'Down Harmony Road'</a> and is available at Elderly Instruments, County Sales, CD Baby in the U.S.A. and directly from us Merriweather Records and Paypal in Canada.</p>"
});
var arnie = new Artist
{
Name = "Arnie Naiman",
Email = "*****@*****.**",
Article =
@"<div id='ArtistContent'>
<font style='font-size: 10pt;'><font style='font-size: 18pt;'><span style='font-family: Arial;'></span></font>M<font style='font-size: 10pt;'><span style='font-family: Arial;'>y interest in banjo playing began after attending The Mariposa Folk Festival and Fiddler's Green Folk Club in Toronto in the mid 1970's. I was so impressed with hearing Michael Cooney and Ola Belle Reed that I was determined to get a banjo and become a singer of folk songs. I acquired a Stewart MacDonald Eagle banjo put together from a kit, and Pete Seeger's instructional book and was quickly able to handle the frailing style of playing.</span></font></font> <p style='font-family: Arial;'><font style='font-size: 10pt;'>Shortly after, I met Kurt Metzler who let me listen to his collection of recordings which opened up a new world of traditional music to my ears. I listened to music from the 1920's and 30's from the golden age of recorded stringband and early country music. Uncle Dave Macon, Charlie Poole and The North Carolina Ramblers, The Carter Family, The Delmore Brothers were among those included, as well as revivalists The New Lost City Ramblers- who were a major influence on my playing, and who were current exponents of this music they called 'Old Time Music'.</font></p> <p style='font-family: Arial;'><font style='font-size: 10pt;'>The following year banjo in hand, while waiting in line for tickets to The Mariposa Festival, some strangers with fiddles asked me if I'd play a tune with them. I sheepishly said that I was just a beginner and only knew two fiddle tunes, but I got out the banjo and my very first jam session was in the making. The realization that an instant connection could be made with total strangers through music had a profound effect on me. I started compiling a repertoire of fiddle tunes on the banjo in a more complex downpicking clawhammer style.</font></p> <p style='font-family: Arial;'><font style='font-size: 10pt;'>I attended other festivals that specialized in 'Old Time Music' and thus became a part of a vast community of great players and wonderful people. I hung out with Pete and Ellen Vigour from Virginia who were, and still are inspirational to my musical development. The live presence of the music I was hearing was exciting and intoxicating, and gradually became absorbed into my very soul. I started performing with Kurt Metzler at various venues as 'The Potatoe Pancakes' and we landed a job singing songs and playing instrumental music for a consecutive seven year stint in a pub.</font></p><p style='font-family: Arial;'><font style='font-size: 10pt;'><br></font></p> <p style='font-family: Arial;'><font style='font-size: 10pt;'>I met my wife <a href='http://208.106.133.235/artist.aspx?ID=1'>Kathy Reid</a> within the music community and we began performing and playing music for country and square dances, clubs and festivals and music camps. We organized a weekly folk music performance with the goal of including good local performer's participation, and we named our duo </font><a href='http://www.merriweather.ca/artist.aspx?ID=18'>Ragged But Right</a><font style='font-size: 10pt;'>. <br></font></p><p style='font-family: Arial;'>Ragged But Right
has released a new cd of mostly old time singing duets. The cd is
called <a href='http://www.merriweather.ca/albums.aspx?ID=37'>'Down
Harmony Road'</a></p><p style='font-family: Arial;'><font style='font-size: 10pt;'><br></font></p><p style='font-family: Arial;'><font style='font-size: 10pt;'>I met <a href='http://208.106.133.235/artist.aspx?ID=3'>Chris Coole</a> who quickly accumulated a repertoire of fiddle tunes on the banjo and together with Kathy on guitar and myself on fiddle, and later on<a href='http://208.106.133.235/artist.aspx?ID=22'> Erynn Marshall </a>on fiddle as well, performed as 'The Extraordinary Stringband' and played southern style music for dances.</font></p> <p style='font-family: Arial;'><font style='font-size: 10pt;'>It was during our late night practices that Chris and I discovered that we had each composed some interesting banjo tunes of our own. We decided to record some of these along with some traditional music and the CD <a href='http://208.106.133.235/albums.aspx?ID=9'>'5 Strings Attached With No Backing' </a>was born. After encouraging feedback from the recording, we decided to do occasional club performances together. <a href='http://208.106.133.235/albums.aspx?ID=10'>Volume 2</a> was recorded 3 years later. <br></font></p><p style='font-family: Arial;'><br></p><p style='font-family: Arial;'><font style='font-size: 10pt;'><a href='albums.aspx?ID=11'>THE BANJO SPECIAL</a></font><font style='font-size: 10pt;'> featuring various styles of banjo music together with <a href='http://www.merriweather.ca/artist.aspx?ID=3'>Chris Coole</a>, <a href='http://208.106.133.235/artist.aspx?ID=4'>Chris Quinn</a>, and <a href='http://208.106.133.235/artist.aspx?ID=5'>Brian Taheny </a> was the next recording project along with banjo extravaganza concerts. <br></font></p><p style='font-family: Arial;'><font style='font-size: 10pt;'><br></font></p><p style='font-family: Arial;'><font style='font-size: 10pt;'>Rounder records has released <a href='http://www1.gemm.com/item/OLD--TIME--BANJO--FESTIVAL---d-VARIOUS--ARTISTS/OLD--TIME--BANJO--FESTIVAL/GML1414065429/'>'The Old Time Banjo Festival'</a></font> produced by Grammy Award winner Cathy Fink featuring todays finest banjo players including Arnie Naiman and Chris Coole.</p><p style='font-family: Arial;'><br></p><p style='font-family: Arial;'>Arnie performs with Chris Coole, The Banjo Special, Ragged But Right, and also currently plays banjo in the Virginia based old-time String Band, <a href='http://www.merriweather.ca/artist.aspx?ID=30'>Albemarle Ramblers</a>. The band has released a new cd for 2010 called <a href='http://www.merriweather.ca/albums.aspx?ID=48'>'Gentleman from Virginia' </a>on Merriweather Records<br></p><br><br><p style='font-family: Arial;'><br></p><p style='font-family: Arial;'>Arnie is a member of<a href='http://www.local1000.com/'> <span class='top'>THE TRAVELING MUSICIANS UNION</span> Local 1000 AFM</a></p><p style='font-family: Arial;'><br></p><p style='font-family: Arial;'>Visit <a href='http://www.myspace.com/albemarleramblers'>Albemarle Rambler Myspace</a></p><p style='font-family: Arial;'>Visit <a href='http://www.myspace.com/raggedbutright'>Ragged But Right </a><a href='http://www.myspace.com/raggedbutright'>Myspace</a><br></p><p style='font-family: Arial;'><font style='font-size: 10pt;'>Visit My <a href='http://www.banjohangout.org/my/arnie/'>Banjohangout Page</a></font></p><p style='font-family: Arial;'><br></p><p style='font-family: Arial;'><font style='font-size: 10pt;'><a href='http://www.banjohangout.org/my/arnie/'><br></a></font></p><p style='font-family: Arial;'><br></p><p style='font-family: Arial;'><font style='font-size: 10pt;'><a href='http://www.banjohangout.org/my/arnie/'><br></a></font></p><p style='font-family: Arial;'><br></p><p style='font-family: Arial;'><font style='font-size: 10pt;'><br></font></p></div>"
};
Artists.Add(arnie);
var ramblers = new Band
{
Name = "Albemarle Ramblers",
Article =
@"<font style='font-size: 12pt;'><span style='font-weight: bold;'>Dick Harrington </span>- guitar, vocals</font><br>As a boy Dick Harrington sang folk songs with his grandma. In the early ' 60s he sang and played guitar nightly in a coffee house. In the ' 70s having settled in Virginia, he became inspired mainly by Pete and Ellen Vigour, to play old-time music exclusively and take up fiddle. Dick has recorded with Victoria Young, Afton Mountain String Band and <a href='http://www.troublesomecreekstringband.com/'>Troublesome Creek</a><br><br><font style='font-size: 12pt;'><span style='font-weight: bold;'>Pete Vigour </span>- fiddle, vocals and fingerpicking banjo </font><br><a href='http://vigourmusic.com/Welcome.html'>Pete Vigour</a> is lucky enough to play and teach old-time music for a living. He lives in White Hall, Virginia with his wife Ellen, a fine mandolin player and dance caller. Pete and Ellen have played old-time music in <a href='http://unclehenrysfavorites.com/'>Uncle Henry's Favorites</a><span style='text-decoration: underline;'> </span>for 25 years with Jim Childress and Mark Beall, often featuring guest appearances by Arnie and Dick.<br><br><font style='font-size: 12pt;'><span style='font-weight: bold;'>Arnie Naiman</span> - clawhammer and fingerpicking banjo, vocals</font><br><a href='http://www.merriweather.ca/artist.aspx?ID=2'>Arnie Naiman</a> hails from Aurora Ontario, Canada. He has previously released his own recordings of banjo and old-time music and also performs with <a href='http://www.merriweather.ca/albums.aspx?ID=11'>The Banjo Special</a>, <a href='http://www.merriweather.ca/artist.aspx?ID=3'>Chris Coole </a>and <a href='http://www.merriweather.ca/artist.aspx?ID=18'>Ragged But Right</a>. He has played on recordings for other artists such as<a href='http://www.merriweather.ca/artist.aspx?ID=1'> Kathy Reid-Naiman</a>, The <a href='http://www.merriweather.ca/albums.aspx?ID=36'>Old Time Banjo Festival</a> (Rounder), Chris Coole, <a href='http://www.merriweather.ca/artist.aspx?ID=22'>Erynn Marshall</a>, Eve Goldberg, <a href='http://www.merriweather.ca/artist.aspx?ID=6'>Debbie Carroll</a>, Shelley Posen, and The Marigolds<br><br><font style='font-size: 12pt;'>Their New Old-Time String Band Release , <a href='http://www.merriweather.ca/albums.aspx?ID=48'><span style='font-weight: bold;'>'Gentleman From Virginia'</span></a><br>M05AR - <span style='font-weight: bold; font-style: italic;'>Available NOW!</span></font><br><br><br><br> <span style='font-weight: bold; font-style: italic; text-decoration: underline;'></span><font style='font-size: 14pt;'><br></font>See a Video Live Performance - <a rel='nofollow' target='_blank' href='http://www.youtube.com/watch?v=T3G3UIox6_Y'>Walking The Dog </a><br>
See a Video Live Performance - <a rel='nofollow' target='_blank' href='http://www.youtube.com/watch?v=YAUCH30qg3A'>The Glendy Burke</a><br>See a Video Live Performance - <a href='http://www.youtube.com/watch?v=bhH92M8wtVA'><span>Home In That
Rock</span></a><br>See a Video Live Performance - <a href='http://www.youtube.com/watch?v=rr6I8bDP5-4'>On The Dixie Bee Line</a><br style='font-weight: bold;'><br><font style='font-size: 12pt;'><span style='font-weight: bold; font-style: italic;'>Visit the <a href='http://albemarleramblers.com/'>Albemarle Rambler Website!</a></span></font><br><br style='font-weight: bold; font-style: italic;'><span style='font-weight: bold; font-style: italic;'>Visit <a href='http://www.myspace.com/albemarleramblers'>Albemarle Rambler Myspace</a></span><br><br><font style='font-size: 10pt; font-style: italic; font-weight: bold;'>Visit Arnie Naiman's <a href='http://www.banjohangout.org/my/arnie/'>Banjohangout Page</a></font><br><br><br>"
};
Bands.Add(ramblers);
SaveChanges();
arnie.Bands.Add(ramblers);
var mp3 = new Song
{
Name = "Title Track",
Href = "00-title.mp3"
};
var ogg = new Song
{
Name = "Title Track, ogg",
Href = "00-title.ogg"
};
var oldTimeGenre = new Genre {
Name = "Old Time"
};
var cd = new Product {
Name = "CD - Canada", Price = (decimal)22.5
};
var virginia = new Album
{
Name = "Gentleman From Virginia",
Heading = "Gentleman From Virginia by The Albemarle Ramblers",
Article =
@"'Straight Ahead old time southern string band music- the way we like it!
For years we've been friends in music and in life, and now here are some of our favorite tunes and songs.'
This wonderful collection from the Albemarle Ramblers contains a variety of southern old-time ballads, songs, and tunes learned from Uncle Dave Macon, The Carter Family, Stephen Foster, and fiddlers such as Gerry Milnes, Robert Sykes, Tom Isenhour, James H. Chisholm, Mark Campbell and more plus a band arrangement of Arnie Naiman's banjo tune -'Walking The Dog' to top it off.
M05AR
'...The Albemarle Ramblers is a tight old-time stringband with strong arrangements, impeccable playing and singing, and an interesting collection of songs and tunes. Their CD is enjoyable listening and comes highly-recommended” - Steve Goldfield Bluegrass Unlimited June 2010
“ What happens when three good friends, all of them excellent musicians, combine forces and form a band? They weld themselves into a fine band, that’s what! And we have this cd to prove it.' - Pete Peterson The Old Time Herald April-May 2010 issue'",
Gemm = "RDFD344",
Band = ramblers,
Genre = oldTimeGenre
};
virginia.Songs.Add(mp3);
virginia.Songs.Add(ogg);
virginia.Products.Add(cd);
SaveChanges();
}
public void BindData(DataTable da)
{
DataSource = da;
Bands.Add(GroupHeader1);
GroupField groupField = new GroupField("Mã kho");
GroupHeader1.GroupFields.Add(groupField);
xrTableCell39.DataBindings.Add("Text", DataSource, "Tên kho");
xrTableCell45.DataBindings.Add("Text", DataSource, "Công ty", "{0:n0}");
XRSummary summary17 = new XRSummary();
summary17.Running = SummaryRunning.Group;
summary17.IgnoreNullValues = true;
summary17.FormatString = "{0:n0}";
xrTableCell45.Summary = summary17;
xrTableCell46.DataBindings.Add("Text", DataSource, "TL công ty", "{0:n2}");
XRSummary summary18 = new XRSummary();
summary18.Running = SummaryRunning.Group;
summary18.IgnoreNullValues = true;
summary18.FormatString = "{0:n2}";
xrTableCell46.Summary = summary18;
xrTableCell47.DataBindings.Add("Text", DataSource, "Hàng gửi", "{0:n0}");
XRSummary summary19 = new XRSummary();
summary19.Running = SummaryRunning.Group;
summary19.IgnoreNullValues = true;
summary19.FormatString = "{0:n0}";
xrTableCell47.Summary = summary19;
xrTableCell48.DataBindings.Add("Text", DataSource, "TL hàng gửi", "{0:n2}");
XRSummary summary20 = new XRSummary();
summary20.Running = SummaryRunning.Group;
summary20.IgnoreNullValues = true;
summary20.FormatString = "{0:n2}";
xrTableCell48.Summary = summary20;
xrTableCell51.DataBindings.Add("Text", DataSource, "Tồn cuối", "{0:n0}");
XRSummary summary21 = new XRSummary();
summary21.Running = SummaryRunning.Group;
summary21.IgnoreNullValues = true;
summary21.FormatString = "{0:n0}";
xrTableCell51.Summary = summary21;
xrTableCell52.DataBindings.Add("Text", DataSource, "TL tồn cuối", "{0:n2}");
XRSummary summary22 = new XRSummary();
summary22.Running = SummaryRunning.Group;
summary22.IgnoreNullValues = true;
summary22.FormatString = "{0:n2}";
xrTableCell52.Summary = summary22;
XRSummary summarytotal = new XRSummary();
XRSummary summarytotal1 = new XRSummary();
XRSummary summarytotal3 = new XRSummary();
XRSummary summarytotal4 = new XRSummary();
XRSummary summarytotal5 = new XRSummary();
XRSummary summarytotal6 = new XRSummary();
XRSummary summarytotal7 = new XRSummary();
XRSummary summarytotal8 = new XRSummary();
XRSummary summarytotal9 = new XRSummary();
XRSummary summarytotal10 = new XRSummary();
XRSummary summarytotal11 = new XRSummary();
XRSummary summarytotal12 = new XRSummary();
XRSummary summarytotal13 = new XRSummary();
XRSummary summarytotal14 = new XRSummary();
XRSummary summarytotal15 = new XRSummary();
XRSummary summarytotal16 = new XRSummary();
XRSummary summarytotal17 = new XRSummary();
XRSummary summarytotal18 = new XRSummary();
XRSummary summarytotal19 = new XRSummary();
XRSummary summarytotal20 = new XRSummary();
XRSummary summarytotal21 = new XRSummary();
XRSummary summarytotal22 = new XRSummary();
XRSummary summarytotal23 = new XRSummary();
summarytotal18.Running = SummaryRunning.Report;
summarytotal18.IgnoreNullValues = true;
summarytotal18.FormatString = "{0:n0}";
xrTableCell19.DataBindings.Add("Text", DataSource, "Công ty", "{0:n0}");
xrTableCell19.Summary = summarytotal18;
summarytotal19.Running = SummaryRunning.Report;
summarytotal19.IgnoreNullValues = true;
summarytotal19.FormatString = "{0:n2}";
xrTableCell20.DataBindings.Add("Text", DataSource, "TL công ty", "{0:n2}");
xrTableCell20.Summary = summarytotal19;
summarytotal20.Running = SummaryRunning.Report;
summarytotal20.IgnoreNullValues = true;
summarytotal20.FormatString = "{0:n0}";
xrTableCell21.DataBindings.Add("Text", DataSource, "Hàng gửi", "{0:n0}");
xrTableCell21.Summary = summarytotal20;
summarytotal21.Running = SummaryRunning.Report;
summarytotal21.IgnoreNullValues = true;
summarytotal21.FormatString = "{0:n2}";
xrTableCell23.DataBindings.Add("Text", DataSource, "TL hàng gửi", "{0:n2}");
xrTableCell23.Summary = summarytotal21;
summarytotal22.Running = SummaryRunning.Report;
summarytotal22.IgnoreNullValues = true;
summarytotal22.FormatString = "{0:n0}";
xrTableCell30.DataBindings.Add("Text", DataSource, "Tồn cuối", "{0:n0}");
xrTableCell30.Summary = summarytotal22;
summarytotal23.Running = SummaryRunning.Report;
summarytotal23.IgnoreNullValues = true;
summarytotal23.FormatString = "{0:n2}";
xrTableCell31.DataBindings.Add("Text", DataSource, "TL tồn cuối", "{0:n2}");
xrTableCell31.Summary = summarytotal23;
xrTableCell60.DataBindings.Add("Text", DataSource, "Mã hàng");
xrTableCell2.DataBindings.Add("Text", DataSource, "Tên hàng");
xrTableCell24.DataBindings.Add("Text", DataSource, "Công ty", "{0:n0}");
xrTableCell25.DataBindings.Add("Text", DataSource, "TL công ty", "{0:n2}");
xrTableCell26.DataBindings.Add("Text", DataSource, "Hàng gửi", "{0:n0}");
xrTableCell27.DataBindings.Add("Text", DataSource, "TL hàng gửi", "{0:n2}");
xrTableCell28.DataBindings.Add("Text", DataSource, "Tồn cuối", "{0:n0}");
xrTableCell29.DataBindings.Add("Text", DataSource, "TL tồn cuối", "{0:n2}");
}
