private void SetFilter_warehouseEDetail(WarehouseE warehouseE)
{
string filter = string.Empty;
filter += $"[WarehouseID] = '{warehouseE.WarehouseID}'";
this.WarehouseDetail_gridView.ActiveFilterString = filter;
}
private void Warehouse_gridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
WarehouseE warehouseE = Warehouse_gridView.GetFocusedRow().CastTo<WarehouseE>();//.CastTo<VouchersE>();
if (warehouseE == null)
{
return;
}
SetFilter_warehouseEDetail(warehouseE);
}
private string GetInsertWarehouseScript(WarehouseE warehouseE)
{
string date = $"{warehouseE.Date.Year}-{warehouseE.Date.Month}-{warehouseE.Date.Day}";
string columns = "WarehouseID, VouchersID, WarehouseListID, Date, DebitAccountID, CreditAccountID, Type, Description, CreateUser, CompanyID ";
string values = $"'{this.YearCT_textEdit.EditValue.ToString().Trim() + warehouseE.WarehouseID}', '{this.YearCT_textEdit.EditValue.ToString().Trim() + warehouseE.VouchersID}', '{warehouseE.WarehouseListID}', '{date}'," +
$" '{warehouseE.DebitAccountID}', '{warehouseE.CreditAccountID}', '{warehouseE.Type}' ,N'{warehouseE.Description}','{"Admin"}','{CompanyID_textEdit.EditValue}'";
return $@"INSERT INTO WarehousePhatTemp({columns}) VALUES({values})";
}
