Exemplo n.º 1
0
        public void ReplaceInto(MySqlEntity entity)
        {
            string sql = entity.GetReplaceInsertSQL();

            base.Excute(sql, entity);
        }
Exemplo n.º 2
0
        private void CreateAllLayers(ConditionModel model)
        {
            TreeViewItem item = TvTables.SelectedItem as TreeViewItem;

            if (item != null)
            {
                #region 整个库
                model.Table = MySqlHelper.GetDtFields(Constant.Constant.MySqlConn, Constant.Constant.TableName);

                ObservableCollection <TreeViewNode> source = item.ItemsSource as ObservableCollection <TreeViewNode>;
                foreach (TreeViewNode node in source)
                {
                    model.EntityName = node.Name.Trim();
                    //if (TbEntityName.Text.Length > 0)
                    //{
                    //	model.EntityName = this.TbEntityName.Text;
                    //}
                    //if (TbNameSpace.Text.Length > 0)
                    //{
                    //	model.NameSpace = TbNameSpace.Text;
                    //}
                    //else
                    //{

                    //	model.NameSpace = Constant.Constant.DataBase + ".Web";
                    //}

                    //if (RBtnLay.IsChecked == true)
                    //{
                    //	CreateLayersTabItem(model);
                    //}
                    //else if (RBtnMvc.IsChecked == true)
                    //{
                    //}
                    //else if (RBtnProc.IsChecked == true)
                    //{
                    //	CreateProcTabItem();
                    //}
                    //else if (RBtnProcCaller.IsChecked == true)
                    //{
                    //	CreateProcCallerTabItem();
                    //}
                    //else
                    //{
                    //	CreateUI(model);
                    //}
                }
                #endregion
            }
            else
            {
                #region 单个表
                TreeViewNode node = TvTables.SelectedItem as TreeViewNode;
                model.EntityName = node.Name;
                model.Table      = MySqlHelper.GetDtFields(Constant.Constant.MySqlConn, node.Name);


                #region Entity
                TabItem tabItemEntity = new TabItem()
                {
                    Header = "Entity"
                };
                RichTextBox rtbEntity = new RichTextBox();
                rtbEntity.Height = 450;
                rtbEntity.VerticalScrollBarVisibility = ScrollBarVisibility.Visible;
                rtbEntity.VerticalAlignment           = VerticalAlignment.Stretch;
                rtbEntity.AppendText(MySqlEntity.CreatePublicEntity(model.Table));
                tabItemEntity.Content = rtbEntity;
                TcControls.Items.Add(tabItemEntity);


                #endregion

                #region Add

                TabItem tabItemProc = new TabItem();
                tabItemProc.Header = "存贮过程";
                RichTextBox rtbProc = new RichTextBox();
                rtbProc.Height = 450;
                rtbProc.VerticalScrollBarVisibility = ScrollBarVisibility.Visible;
                rtbProc.VerticalAlignment           = VerticalAlignment.Stretch;

                rtbProc.AppendText(MySqlProc.CreateProc(model.Table));
                tabItemProc.Content = rtbProc;
                TcControls.Items.Add(tabItemProc);

                #endregion


                #endregion

                //CreateOneLayer(node, model);
            }
        }