public void AddRow(DevExpress.XtraGrid.Views.Grid.GridView View)
{
int currentRow;
currentRow = View.FocusedRowHandle;
if (currentRow < 0)
{
currentRow = View.GetDataRowHandleByGroupRowHandle(currentRow);
}
if (View.GroupedColumns.Count == 0)
{
return;
}
string grp = View.GetRowCellValue(currentRow, colGRP).ToString();
GenelDataSet.XGTRow xgtRow = this.genelDataSet.XGT.FindByGRPID(grp, "+");
if (xgtRow.SYS == "M" || xgtRow.SYS == "V") // Grup Modify ise eklenebilir
{
View.AddNewRow();
View.SetRowCellValue(View.FocusedRowHandle, colGRP, grp);
View.SetRowCellValue(View.FocusedRowHandle, colID, "");
View.SetRowCellValue(View.FocusedRowHandle, colSYS, "V"); // User Modify
View.UpdateCurrentRow();
View.MakeRowVisible(View.FocusedRowHandle, true);
View.ShowEditor();
}
}
public void delete(DevExpress.XtraGrid.Views.Grid.GridView view)
{
for (int i = view.RowCount - 1; i >= 0; i--)
{
view.DeleteRow(i);
}
view.UpdateCurrentRow();
}
public void loadbangkehangtheongay(string ngaychungtu, string ngaycuoi, string manhanvien, DevExpress.XtraGrid.Views.Grid.GridView gridView1)
{
while (gridView1.RowCount > 1)
{
gridView1.DeleteRow(0);
}
manhanvien = gen.GetString("select AccountingObjectID from AccountingObject where AccountingObjectCode='" + manhanvien + "'");
DataTable temp = gen.GetTable("select '131','1111',AccountingObjectCode,SUM(TotalAmountOC+TotalAmount-(TotalFreightAmount/(1+Cast(Tax as money)/100))) as tien from INOutward a, AccountingObject b where a.AccountingObjectID=b.AccountingObjectID and RefDate>='" + ngaychungtu + "' and RefDate<='" + ngaycuoi + "' and EmployeeIDSA='" + manhanvien + "' and IsExport=1 group by AccountingObjectCode order by AccountingObjectCode");
for (int i = 0; i < temp.Rows.Count; i++)
{
gridView1.AddNewRow();
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns["Tài khoản có"], temp.Rows[i][0].ToString());
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns["Tài khoản nợ"], temp.Rows[i][1].ToString());
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns["Số tiền"], Double.Parse(temp.Rows[i][3].ToString()));
gridView1.SetRowCellValue(gridView1.FocusedRowHandle, gridView1.Columns["Mã khách"], temp.Rows[i][2].ToString());
gridView1.UpdateCurrentRow();
}
}