/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFilterEdit_Click(object sender, EventArgs e)
{
if (listFilters.SelectedObjects.Count == 0)
{
return;
}
Filter filter = (Filter)listFilters.SelectedObjects[0];
using (FormFilter formFilter = new FormFilter(_sql, _filters))
{
formFilter.Filter = filter;
if (formFilter.ShowDialog(this) == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
filter.Definition = formFilter.Filter.Definition;
filter.Condition = formFilter.Filter.Condition;
filter.Value = formFilter.Filter.Value;
LoadFilters();
LoadSearch(1);
SetFilterButtonStatus(true);
}
}
///Все управляющие кноки справочника.
private void tb_N1_Click(object sender, EventArgs e)
{
//Filter.
if ((sender == tb_N1) || (sender == cm_N1))
{
if (!FormFilter.Filter(this, EntityBrief, DGV1.Left, DGV1.Top, ref filter))
{
return;
}
//sys.SM(filter.FullQuery);
Var.con.SelectDT(filter.FullQuerySQL, out dt);
DGV1.DataSource = dt;
}
//Refresh.
if ((sender == tb_N2) || (sender == cm_N2))
{
Var.con.SelectDT(filter.FullQuerySQL, out dt);
DGV1.DataSource = dt;
}
//ShowSQL.
if (sender == cm_N8)
{
sys.SM(filter.FullQuerySQL, MessageType.Information);
}
//ShowMSQL.
if (sender == cm_N9)
{
sys.SM(filter.FullQueryMSQL, MessageType.Information);
}
//Sum of the values
//if (sender == cm_N10) sys.SM("Функционал пока не работает!");
//Details
if (sender == cm_N8)
{
DGV1.GridInformation();
}
//Export to Excel
if (sender == cm_N6)
{
DGV1.ExportToExcel();
}
//Save to CSV
if (sender == cm_N7)
{
DGV1.DataGridViewToCSV("");
}
//Форма поиска.
if ((sender == tb_N6) || (sender == cm_N9))
{
fs = FormSearch.FormSearchShow(this.Name, DGV1, null);
}
}
public void Test()
{
Filter filter = new Filter();
filter.PrimitivesKeys.Add(new KeyMatcher("Item1"));
filter.PrimitivesKeys.Add(new KeyMatcher("Item2"));
FormFilter.EditFilter(filter);
}
private void UserUI_Load(object sender, EventArgs e)
{
formMode = FormMode.View;
formFilter = FormFilter.SupplierName;
GetLastUser();
LoadUsers();
}
public async Task <IEnumerable <FormModel> > GetAsync(FormFilter filter)
{
if (filter == null)
{
throw new TMNotFoundException(string.Format(ErrorMessages.CollectionEmpty, nameof(filter)));
}
var filters = filter.Create();
string[] properties = new string[] { nameof(Form.IdOwnerNavigation), nameof(Form.IdKeyFormTypeNavigation) };
var data = await context.FormRepository.GetAsync(filters, properties);
return(data.Select(f => mappingManager.Create(f)));
}
private void PayablePaymentUI_Load(object sender, EventArgs e)
{
formMode = FormMode.View;
formFilter = FormFilter.SupplierName;
FillCode();
GetLastPayablePayment();
if (lvwPayablePayment.Items.Count == 0)
{
tsbBack.Enabled = false;
tsbNext.Enabled = false;
tsbEdit.Enabled = false;
tsbDelete.Enabled = false;
tsbHistory.Enabled = false;
}
}
private void StockCorrectionUI_Load(object sender, EventArgs e)
{
formMode = FormMode.View;
formFilter = FormFilter.SupplierName;
FillCode();
GetLastStockCorrection();
if (lvwStockCorrection.Items.Count == 0)
{
tsbBack.Enabled = false;
tsbNext.Enabled = false;
tsbEdit.Enabled = false;
tsbDelete.Enabled = false;
tsbHistory.Enabled = false;
}
}
/// <summary>
/// 工具栏-过滤器
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btiFilter_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
TreeNode curNode = trvDatabase.SelectedNode;
List <IDataTable> lstSource = curNode.Tag as List <IDataTable>;
FormFilter frmFilter = FormFilter.GetInstance(curNode);
DialogResult result = frmFilter.ShowDialog();
if (result == DialogResult.OK)
{
List <IDataTable> lstTables = frmFilter.GetFilterResult(lstSource);
LoadTableOrViewNodes(curNode, lstTables);
}
else if (result == DialogResult.Ignore) //--代表清除过滤条件
{
LoadTableOrViewNodes(curNode, lstSource);
}
}
private void SalesmanUI_Load(object sender, EventArgs e)
{
formMode = FormMode.View;
formFilter = FormFilter.SupplierName;
GetLastSalesman();
LoadSalesmen();
if (lvwSalesman.Items.Count == 0)
{
tsbEdit.Enabled = false;
tsbDelete.Enabled = false;
tsbRefresh.Enabled = false;
tsbMenuFilter.Enabled = false;
txtSearch.Enabled = false;
tsbFilter.Enabled = false;
}
}
public ManageFormsViewModel(
IWindowManager windowManager,
IBusyIndicator busyIndicator,
IRequestManager requestManager,
IEventAggregator eventAggregator,
INotificationManager notificationManager)
{
this.eventAggregator = eventAggregator;
this.eventAggregator.Subscribe(this);
this.notificationManager = notificationManager;
this.windowManager = windowManager;
this.requestManager = requestManager;
BusyIndicator = busyIndicator;
ChkBankIsActive = false;
formFilter = new FormFilter();
FormModels = new BindableCollection <FormModel>();
}
private void CustomerListUI_Load(object sender, EventArgs e)
{
formMode = FormMode.View;
formFilter = FormFilter.CustomerName;
GetLastCustomer();
LoadCustomers();
if (lvwCustomer.Items.Count == 0)
{
tsbEdit.Enabled = false;
tsbDelete.Enabled = false;
tsbRefresh.Enabled = false;
tsbMenuFilter.Enabled = false;
txtSearch.Enabled = false;
tsbFilter.Enabled = false;
}
}
/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnFilterAdd_Click(object sender, EventArgs e)
{
using (FormFilter formFilter = new FormFilter(_sql, _filters))
{
using (new HourGlass(this))
using (NPoco.Database db = new NPoco.Database(Db.GetOpenMySqlConnection()))
{
formFilter.LoadClassifications(db);
}
if (formFilter.ShowDialog(this) == System.Windows.Forms.DialogResult.Cancel)
{
return;
}
_filters.Add(formFilter.Filter);
LoadFilters();
LoadSearch(1);
SetFilterButtonStatus(true);
}
}
/// <summary>
/// Конструктор.
/// </summary>
/// <param name="caption">Заголовок формы справочника</param>
/// <param name="dirparams">Параметры открытия справочника. Тип DirectoryParams.</param>
public FormDirectory(string caption, ref DirectoryParams dirparams)
{
InitializeComponent();
this.listParams = dirparams;
if (string.IsNullOrEmpty(caption))
{
if (dirparams.EntityBrief != "")
{
caption = caption + dirparams.EntityBrief;
}
if (!sys.IsEmpty(dirparams.ObjectID))
{
caption = caption.AddRightSpace() + "Object: " + dirparams.ObjectID;
}
}
Text = caption;
int Check = 0;
if (dirparams.showMode == ShowMode.Filter)
{
Check = 1;
}
if (dirparams.showMode == ShowMode.ExecMSQL)
{
Check = 1;
}
if (dirparams.showMode == ShowMode.ExecSQL)
{
Check = 1;
}
if (Check == 0)
{
sys.SM("Неверно указан указан режим отображения справочника!");
return;
}
tb_N1.Visible = dirparams.ButtonFilter; //(dirparams.showMode == ShowMode.Filter) ; //Filter
tb_N2.Visible = dirparams.ButtonRefresh; //AllowUpdate; //Refresh
tb_N3.Visible = dirparams.ButtonAdd; //AllowUpdate; //New
tb_N4.Visible = dirparams.ButtonEdit; //AllowUpdate; //Edit
tb_N5.Visible = dirparams.ButtonDelete; //AllowUpdate; //Delete
tb_N6.Visible = dirparams.ButtonSearch; //AllowUpdate; //Delete
btnCancel.Visible = tb_N4.Visible; //Если доступно изменение, то кнопка Cancel видима.
filter.ListObjectID = dirparams.ListObjectID;
filter.EntityBrief = dirparams.EntityBrief;
filter.ColumnWidth = dirparams.ColumnWidth;
if (dirparams.showMode == ShowMode.Filter)
{
Action(CommandType.Filter);
}
if (dirparams.showMode == ShowMode.ExecMSQL)
{
FormFilter.FilterRead(ref filter, false);
if ((filter.FullQuerySQL == "") || (filter.AttrSelect == ""))
{
Action(CommandType.Filter);
}
}
if (dirparams.showMode == ShowMode.ExecSQL)
{
Action(CommandType.ExecSQL);
}
if (dirparams.showMode == ShowMode.ExecMSQL)
{
Action(CommandType.ExecMSQL);
}
//var clickController = new CellClickEvent();
//grid1.Controller.AddController(clickController);
//grid1.EndEditingRowOnValidate = false;
// grid1.AcceptsInputChar = false;
}
///Вместо button1.PerformClick();
private void Action(CommandType commandType)
{
if (commandType == CommandType.Ok)
{
Close();
}
if (commandType == CommandType.Filter)
{
if (!FormFilter.Filter(
this,
listParams.EntityBrief,
grid1.Left,
grid1.Top,
ref filter,
listParams.OuterWHERE
))
{
FilterSet = false;
return;
}
FilterSet = true;
RefreshGridForm(DirectionQuery.Remote, grid1, filter);
}
if (commandType == CommandType.ExecSQL)
{
FilterSet = false;
filter.FullQuerySQL = listParams.СustomSQLQuery;
RefreshGridForm(DirectionQuery.Remote, grid1, filter);
}
if (commandType == CommandType.ExecMSQL)
{
FilterSet = false;
filter.FullQuerySQL = sys.Parse(listParams.СustomMSQLQuery);
RefreshGridForm(DirectionQuery.Remote, grid1, filter);
}
if (commandType == CommandType.Refresh)
{
RefreshGridForm(DirectionQuery.Remote, grid1, filter);
}
if (commandType == CommandType.Add)
{
EditObject("");
}
if (commandType == CommandType.Edit)
{
this.listParams.ObjectID = grid1.Value(0, true);
if (listParams.DoubleClickReturn)
{
Close();
}
//показываем форму свойств выбранного объекта.
EditObject(this.listParams.ObjectID);
}
if (commandType == CommandType.Del)
{
int countDeleted = 0;
string objectCaption = "";
string[] arrID = grid1.GetSelectedValues(0, true);
if (arrID == null)
{
return;
}
if (arrID.Length == 0)
{
return;
}
string entityName = sys.GetEntityName("", listParams.EntityBrief);
if (entityName != "")
{
objectCaption = entityName;
}
if (arrID.Length == 1)
{
objectCaption = objectCaption + " ИД Объекта " + arrID[0];
}
else
{
objectCaption = objectCaption = objectCaption + " Всего объектов " + arrID.Length.ToString();
}
if (!sys.SM("Вы действительно ходите удалить " + objectCaption, MessageType.Question))
{
return;
}
if (arrID.Length == 1)
{
objectCaption = "'" + entityName + "'. ИД Объекта " + arrID[0];
var Obj = new FBA.ObjectRef();
if (!Obj.DeleteObject(DirectionQuery.Remote, "Contract", arrID[0]))
{
return;
}
countDeleted = 1;
sys.SM(objectCaption + " удален", MessageType.Information);
}
if (arrID.Length > 1)
{
var progress1 = new FormProgress("Удаление", "Удаление объектов" + entityName, arrID.Length);
progress1.Show();
for (int i = 0; i < arrID.Length; i++)
{
objectCaption = "'" + entityName + "'. ИД Объекта " + arrID[i];
var Obj = new FBA.ObjectRef();
if (!Obj.DeleteObject(DirectionQuery.Remote, "Contract", arrID[i]))
{
return;
}
countDeleted++;
progress1.Inc();
}
progress1.Dispose();
if (countDeleted == arrID.Length)
{
objectCaption = "Все объекты " + entityName + " удалены. Всего: " + countDeleted;
sys.SM(objectCaption, MessageType.Information);
}
if (countDeleted < arrID.Length)
{
objectCaption = "Объекты " + entityName + " удалены. Всего: " + countDeleted + " из " + arrID.Length.ToString();
sys.SM(objectCaption, MessageType.Warning);
}
if (countDeleted == 0)
{
objectCaption = "Объекты " + entityName + " удалены не были.";
sys.SM(objectCaption);
}
if (countDeleted > 0)
{
if (sys.SM("Обновить содержимое справочника " + entityName + "?", MessageType.Question))
{
RefreshGridForm(DirectionQuery.Remote, grid1, filter);
}
}
;
}
}
if (commandType == CommandType.ShowSQL)
{
sys.SM(filter.FullQuerySQL, MessageType.Information);
}
if (commandType == CommandType.ShowMSQL)
{
sys.SM(filter.FullQueryMSQL, MessageType.Information);
}
if (commandType == CommandType.Details)
{
grid1.GridInformation();
}
if (commandType == CommandType.ExportToExcel)
{
grid1.SourceGridToExcel();
}
if (commandType == CommandType.ExportToCSV)
{
grid1.SourceGridToCSV();
}
if (commandType == CommandType.Search)
{
dtSearch = FormSearch.FormSearchShow(this.Name, null, grid1);
}
if (commandType == CommandType.Copy)
{
grid1.CopyRegion(false, false);
}
if (commandType == CommandType.CopyAll)
{
grid1.CopyRegion(true, true);
}
if (commandType == CommandType.CopyWithCaptions)
{
grid1.CopyRegion(true, false);
}
//if (Operation == "Copy")
//{
// string Value = sys.GetValueByColumnIndex(DG2, -1, true);
// Value.CopyToClipboard();
//}
if (commandType == CommandType.SelectAll)
{
SourceGridSelectAll(grid1); //DG2.SelectAll());
}
if (commandType == CommandType.SelectRows)
{
SourceGridSelectRows(grid1);
}
if (commandType == CommandType.SelectColumns)
{
SourceGridSelectColumns(grid1);
}
if (commandType == CommandType.SelectionModeCell)
{
SetSelectionMode(SourceGrid.GridSelectionMode.Cell);
}
if (commandType == CommandType.SelectionModeRow)
{
SetSelectionMode(SourceGrid.GridSelectionMode.Row);
}
if (commandType == CommandType.SelectionModeColumn)
{
SetSelectionMode(SourceGrid.GridSelectionMode.Column);
}
if (commandType == CommandType.Cancel)
{
this.listParams.ObjectID = "";
this.Close();
}
//Копирование ссылок на выделенные документы.
if (commandType == CommandType.CopyDocumentLink)
{
var links = new StringBuilder();
string[] arrID = grid1.GetSelectedValues(0, true);
if (arrID.Length == 0)
{
return;
}
for (int i = 0; i < arrID.Length; i++)
{
links.Append("FBALink.Entity:" + listParams.EntityBrief + ",ObjectID:" + arrID[i] + Var.CR);
}
links.ToString().CopyToClipboard();
}
}
