Example #1
0
		void ToolStripMenuItem1Click(object sender, EventArgs e)
		{
		 	ValueParam[] arrvp = new ValueParam[2];
			//arrvp[0].type = FBA.TextBoxFBA; 
			arrvp[0].value = "Номер договора"; 	
			//arrvp[1]
			arrvp[1].value = "Серия договора"; 
			var frm = new FormValue("Введите номер и серию договора", arrvp);
			if (frm.ShowDialog() != DialogResult.OK) return ;
	        string valueText1 = frm.GetValue(0);
	        string valueText2 = frm.GetValue(1);
		}
Example #2
0
        ///Добавить метод.
        public bool MethodAddOrEdit(Operation operation, string MethodID)
        {
            string[] actionList = { "UPDATE", "INSERT", "DELETE", "SELECT" };
            string   sql        = "SELECT Brief FROM fbaEntity ";

            //sys.SelectComboBox(DirectionQuery.Remote, SQL, frm.tbText1);
            string[] entitlyList = sys.SQLToArray(DirectionQuery.Remote, sql);

            string entityBrief = dgvMethod.Value("Entity");
            string action      = dgvMethod.Value("Action");
            string methodBrief = dgvMethod.Value("Brief");
            string methodValue = dgvMethod.Value("Value");
            string comment     = dgvMethod.Value("Comment");
            string capForm     = operation.ToString() + "entity method";


            //var frm = new FormValue5(Cap,
            //                        "Entity", "Action", "Brief", "Value", "Comment",
            //                         EntityBrief, Action, MethodBrief, MethodValue, Comment,
            //                         entitlyList, action);
            //if (frm.ShowDialog() != DialogResult.OK) return false;


            var arrvp = new ValueParam[5];

            arrvp[0].captionValue  = "Entity";
            arrvp[0].componentType = ComponentType.ComboBox;
            arrvp[0].values        = entitlyList;
            arrvp[0].value         = entityBrief;

            arrvp[1].captionValue  = "Action";
            arrvp[1].componentType = ComponentType.ComboBox;
            arrvp[1].values        = actionList;
            arrvp[1].value         = action;

            arrvp[2].captionValue = "Brief";
            arrvp[2].value        = methodBrief;

            arrvp[3].captionValue = "Value";
            arrvp[3].value        = methodValue;

            arrvp[4].captionValue = "Comment";
            arrvp[4].value        = comment;

            var frm = new FormValue(capForm, arrvp);

            if (frm.ShowDialog() != DialogResult.OK)
            {
                return(false);
            }
            entityBrief = frm.GetValue(0);
            action      = frm.GetValue(1);
            methodBrief = frm.GetValue(2);
            methodValue = frm.GetValue(3);
            comment     = frm.GetValue(4);

            //EntityBrief = frm.tbText1.Text;
            //Action      = frm.tbText2.Text;
            //MethodBrief = frm.tbText3.Text;
            //MethodValue = frm.tbText4.Text;
            //Comment     = frm.tbText5.Text;
            string EntityID = sys.GetEntityID(entityBrief);

            if (operation == Operation.Add)
            {
                sql = "INSERT INTO fbaMethod (" +
                      "UserCreateID, DateCreate, EntityRef, Action, Brief, Value, Comment) VALUES (" +
                      Var.UserID + ", " + sys.DateTimeCurrent() + "," + EntityID + ",'" + action + "', '" + methodBrief + "', '" + methodValue + "', '" + comment + "')";
                if (!sys.Exec(DirectionQuery.Remote, sql))
                {
                    return(false);
                }
                sys.SM("Метод добавлен!", MessageType.Information);
            }
            if (operation == Operation.Edit)
            {
                sql = "UPDATE fbaMethod SET " +
                      "UserCreateID = " + Var.UserID +
                      ",DateCreate  = " + sys.DateTimeCurrent() +
                      ",EntityRef   = " + EntityID +
                      ",Action      = '" + action + "'" +
                      ",Brief       = '" + methodBrief + "'" +
                      ",Value       = '" + methodValue + "'" +
                      ",Comment     = '" + comment + "'" +
                      " WHERE ID = " + MethodID;
                if (!sys.Exec(DirectionQuery.Remote, sql))
                {
                    return(false);
                }
                sys.SM("Метод изменён!", MessageType.Information);
            }
            MethodRefresh();
            return(true);
        }
Example #3
0
        private void MainMenu_N1_1_Click(object sender, EventArgs e)
        {                                                                      
            if (sender == MainMenu_N1_1) sys.ChangeUserPass();
            if (sender == MainMenu_N1_2) Environment.Exit(0);
            
            if (sender == MainMenu_N2_1) sys.ShowDirectorySimple("Договор", "FormContract", "FormContract", null, null, null, null);
            if (sender == MainMenu_N2_2) sys.ShowDirectorySimple("Face", null, null, null, null, null, null);
            if (sender == MainMenu_N2_3)
            { 
            	 
                //int FormNumberLocal = 0;
                //object[] ParamArray = null; //new object[1];
                //ParamArray[0] = 0;
                //ProjectService.FormShow("FormCallCenter", "FormCallCenter", out FormNumberLocal, ParamArray);
                
                 var arrvp = new ValueParam[5];
				 
                 //Вариант 1 установки DataSet для ComboBox. Запрос MSQL.	
                 arrvp[0].captionValue = "Выберите сущность"; 
				 arrvp[0].componentType = ComponentType.ComboBox;				
				 arrvp[0].value = "Сущности"; 				 							
				 arrvp[0].msql  = "SELECT Brief FROM fbaEntity";
				 				 
				 //Вариант 1 установки DataSet для ComboBox. Запрос MSQL.
				 arrvp[1].captionValue = "Выберите таблицу";
				 arrvp[1].componentType = ComponentType.ComboBox;					 
				 arrvp[1].value = ""; 				 				
				 arrvp[1].sql  = "SELECT Name FROM fbaTable";
				
				 
				 arrvp[2].captionValue = "Выберите атрибут";
				 arrvp[2].value = "Атрибуты";				 
				 arrvp[2].componentType = ComponentType.ComboBox;												
				 
				 arrvp[3].captionValue = "Проверка";
				 arrvp[3].value = "Атрибуты";				 
				 arrvp[3].componentType = ComponentType.CheckBox;					 
				 
				 //Это TextBox
				 arrvp[4].captionValue = "Комментарий"; 
				 arrvp[4].componentType = ComponentType.TextBox;				
				 arrvp[4].value = "";
				 arrvp[4].height = 100;
				 arrvp[4].scrolls = System.Windows.Forms.ScrollBars.Both;
				 arrvp[4].wordwrap = true;				 			
				 				 					
				 var frm = new FormValue("Введите номер и серию договора", arrvp);				 
				 //Все созданые ComboBox и TextBox доступны через массивы comboBoxArray и textBoxArray.
				 frm.comboBoxArray[2].SetDataSourceMSQL("SELECT Name FROM fbaAttribute");
				 				 
				 if (frm.ShowDialog() != DialogResult.OK) return;
		         string valueText1 = frm.GetValue(0);
		         string valueText2 = frm.GetValue(1);
		         string valueText3 = frm.GetValue(2);
		         string valueText4 = frm.GetValue(3);
		         sys.SM("valueText1=" + valueText1 + Var.CR + 
		                "valueText2=" + valueText2 + Var.CR + 
		                "valueText3=" + valueText3 + Var.CR + 
		                "valueText4=" + valueText4 + Var.CR
		               );
                
            }

            //Report XLSX Sample .
            if (sender == MainMenu_N2_4)
            {
                int FormNumberLocal = 0;
                object[] ParamArray = null; //new object[1];
                ProjectService.FormShow("FormReport", "FormReport", out FormNumberLocal, ParamArray);
            }

            //Открыть документы по ссылке.
            if (sender == MainMenu_N2_6)
            {
                string ValueText = "";
                                 
                if (!sys.InputValue("List of values", "Input links:", SizeMode.Large, ValueType.String, ref ValueText)) return;
                string[] ListObjectID = ValueText.Split('\n');
                sys.ShowDirectorySimple("Contract", "FormContract", "FormContract", null, ListObjectID, null, null);
            }
            
            //Открыть справку
            if (sender == MainMenu_N3_1) sys.ShowHelp();
            
            if (sender == MainMenu_N3_2) new FormAbout().Show();
             
            //Открыть документы по ссылке.
            if (sender == MainMenu_N3_3) sys.ShowDocumentation();
                      
        }
Example #4
0
        /// <summary>
        /// Контекстное меню.
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void AddClick(object sender, EventArgs e)
        {
            Operation operation = Operation.NotAssigned;

            if (sender == cmModel_N1)
            {
                operation = Operation.Add;
            }
            if (sender == cmModel_N2)
            {
                operation = Operation.Edit;
            }
            if (sender == cmModel_N3)
            {
                operation = Operation.Del;
            }
            if (sender == cmModel_N4)
            {
                operation = Operation.Refresh;
            }
            //Обновить таблицы парсера.
            if (sender == cmModel_N5)
            {
                sys.CreateParserLocalTables();
                return;
            }

            if (operation == Operation.NotAssigned)
            {
                return;
            }

            //Компонент на котором повешено контекстное меню.
            string componentStrip = sys.GetControlNameByMenuStripItem(sender);
            string objID;
            string entityID    = CompEntityTreeFBA1.EntityID;
            string entityBrief = sys.GetEntityBrief(entityID);

            if (operation == Operation.Refresh)
            {
                if (componentStrip == "dgvAttr")
                {
                    LoadAttrList(CompEntityTreeFBA1.EntityID);
                }
                if (componentStrip == "dgvTable")
                {
                    LoadTableList(CompEntityTreeFBA1.EntityID);
                }
                if (componentStrip == "dgvMethod")
                {
                    LoadMethodList(CompEntityTreeFBA1.EntityID);
                }
                return;
            }

            //Атрибут.
            if (componentStrip == "dgvAttr")
            {
                objID = dgvAttr.Value("ID");
                string AttrBrief = dgvAttr.Value("Brief");
                string AttrName  = dgvAttr.Value("Name");
                if (sender == cmModel_N4)
                {
                    LoadAttrList(entityID);
                }
                var f1 = new FormAttr(operation, entityID, objID, AttrBrief, AttrName);
                f1.Icon = this.Icon;
                if (f1.ShowDialog() == DialogResult.OK)
                {
                    LoadAttrList(entityID);
                }
            }

            //Таблица.
            if (componentStrip == "dgvTable")
            {
                objID = dgvTable.Value("ID");
                string objName = dgvTable.Value("Name");
                if (sender == cmModel_N4)
                {
                    LoadTableList(entityID);
                }
                var f1 = new FormTable(operation, objID, objName, entityID);
                f1.Icon = this.Icon;
                if (f1.ShowDialog() == DialogResult.OK)
                {
                    LoadTableList(entityID);
                }
            }

            //Метод.
            if (componentStrip == "dgvMethod")
            {
                string methodID    = dgvMethod.Value("ID");
                string action      = dgvMethod.Value("Action");
                string methodBrief = dgvMethod.Value("Brief");
                string methodValue = dgvMethod.Value("Value");
                string comment     = dgvMethod.Value("Comment");
                string sql         = "";
                if (operation == Operation.Del)
                {
                    if (methodID == "")
                    {
                        return;
                    }
                    sql = "DELETE FROM fbaMethod WHERE ID = " + methodID;
                    if (!sys.Exec(DirectionQuery.Remote, sql))
                    {
                        return;
                    }
                    LoadMethodList(entityID);
                    sys.SM("Метод удален!", MessageType.Information);
                    return;
                }

                string capForm = "";
                if (operation == Operation.Add)
                {
                    capForm = "Add Entity Method";
                }
                if (operation == Operation.Edit)
                {
                    capForm = "Edit Entity Method";
                }
                if (operation == Operation.Del)
                {
                    capForm = "Delete Entity Method";
                }

                string[] actionArr = { "INSERT", "DELETE", "UPDATE" };

                /*var frm = new FormValue5(cap,
                 *                       "Entity", "Action", "Brief", "Value", "Comment",
                 *                       entityBrief, action, methodBrief, methodValue, comment,
                 *                       null, actionArr);
                 * frm.tbText1.ReadOnly = true;
                 * frm.tbText2.ReadOnly = true;
                 * if (frm.ShowDialog() != DialogResult.OK) return;
                 *
                 * entityBrief = frm.tbText1.Text;
                 * action      = frm.tbText2.Text;
                 * methodBrief = frm.tbText3.Text;
                 * methodValue = frm.tbText4.Text;
                 * comment     = frm.tbText5.Text;
                 */

                var arrvp = new ValueParam[5];
                arrvp[0].captionValue  = "Entity";
                arrvp[0].componentType = ComponentType.ComboBox;
                arrvp[0].values        = null;
                arrvp[0].value         = entityBrief;
                arrvp[0].readOnly      = true;

                arrvp[1].captionValue  = "Action";
                arrvp[1].componentType = ComponentType.ComboBox;
                arrvp[1].values        = actionArr;
                arrvp[1].value         = action;
                arrvp[1].readOnly      = true;

                arrvp[2].captionValue = "Brief";
                arrvp[2].value        = methodBrief;

                arrvp[3].captionValue = "Value";
                arrvp[3].value        = methodValue;

                arrvp[4].captionValue = "Comment";
                arrvp[4].value        = comment;

                var frm = new FormValue(capForm, arrvp);
                if (frm.ShowDialog() != DialogResult.OK)
                {
                    return;
                }
                entityBrief = frm.GetValue(0);
                action      = frm.GetValue(1);
                methodBrief = frm.GetValue(2);
                methodValue = frm.GetValue(3);
                comment     = frm.GetValue(4);


                if (operation == Operation.Add)
                {
                    sql = "INSERT INTO fbaMethod (" +
                          "UserCreateID, DateCreate, EntityRef, Action, Brief, Value, Comment) VALUES (" +
                          Var.UserID + ", " + sys.DateTimeCurrent() + "," + entityID + ",'" + action + "', '" + methodBrief + "', '" + methodValue + "', '" + comment + "')";
                    if (!sys.Exec(DirectionQuery.Remote, sql))
                    {
                        return;
                    }
                    sys.SM("Метод добавлен!", MessageType.Information);
                }
                if (operation == Operation.Edit)
                {
                    sql = "UPDATE fbaMethod SET " +
                          "UserChangeID = " + Var.UserID +
                          ",DateChange  = " + sys.DateTimeCurrent() +
                          ",EntityRef   = " + entityID +
                          ",Action      = '" + action + "'" +
                          ",Brief       = '" + methodBrief + "'" +
                          ",Value       = '" + methodValue + "'" +
                          ",Comment     = '" + comment + "'" +
                          " WHERE ID = " + methodID;
                    if (!sys.Exec(DirectionQuery.Remote, sql))
                    {
                        return;
                    }
                    sys.SM("Метод изменён!", MessageType.Information);
                }
                LoadMethodList(entityID);
            }
        }