C# CodeTables.SQLTable类代码示例

        private void usrc_EditTable_after_InsertInDataBase(SQLTable m_tbl, long ID, bool bRes)
        {
            if (bRes)
            {

            }
        }

 public Form_ShopC_Item_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID, Control xParentControl)
 {
     InitializeComponent();
     dbTables = xdbTables;
     tbl = xtbl;
     ColumnOrderBy = xColumnOrderBy;
     ID_v = new long_v();
     ID_v.v = ID;
     ParentControl = xParentControl;
     if (ParentControl != null)
     {
         if (ParentControl is usrc_StockEditForSelectedStockTake)
         {
             m_usrc_StockEditForSelectedStockTake = (usrc_StockEditForSelectedStockTake)ParentControl;
         }
     }
     this.Text = lngRPM.s_Items.s;
     rdb_OnlyInOffer.Checked = true;
     lngRPM.s_OnlyInOffer.Text(this.rdb_OnlyInOffer);
     lngRPM.s_AllItems.Text(this.rdb_All);
     lngRPM.s_OnlyNotInOffer.Text(this.rdb_OnlyNotInOffer);
     if (nav==null)
     {
         nav = new NavigationButtons.Navigation();
         nav.m_eButtons = NavigationButtons.Navigation.eButtons.OkCancel;
         nav.eExitResult = NavigationButtons.Navigation.eEvent.NOTHING;
         usrc_NavigationButtons1.Init(nav);
     }
 }

 public bool StartThread(SQLTable tbl,Control pControl)
 {
     VirtualSecretaryThread = new Thread(VirtualSecretaryJob);
     VirtualSecretary_ThreadParam scp = new VirtualSecretary_ThreadParam(tbl, pControl);
     VirtualSecretaryThread.Start(scp);
     return true;
 }

 public Form_myOrg_Person_Edit(long xOffice_ID,NavigationButtons.Navigation xnav)
 {
     InitializeComponent();
     nav = xnav;
     usrc_NavigationButtons1.Init(nav);
     m_Office_ID = xOffice_ID;
     tbl_myOrganisation_Person = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(myOrganisation_Person)));
     lngRPM.s_myOrganisation_Person_Data.Text(this);
     this.Icon = Properties.Resources.Person;
     this.usrc_EditTable1.Title = lngRPM.s_Edit_Office_Data.s;
     string selection = @"  myOrganisation_Person_$_per_$_cfn_$$FirstName,
                             myOrganisation_Person_$_per_$_cln_$$LastName,
                             myOrganisation_Person_$_per_$$DateOfBirth,
                             myOrganisation_Person_$_per_$$Tax_ID,
                             myOrganisation_Person_$_per_$$Registration_ID,
                             myOrganisation_Person_$_office_$_mo_$_orgd_$_org_$$Name,
                             myOrganisation_Person_$_office_$$Name,
                             myOrganisation_Person_$_office_$$ShortName,
                             ID
     ";
     long_v Office_ID_v = null;
     if (m_Office_ID >= 0)
     {
         Office_ID_v = new long_v(m_Office_ID);
     }
     if (usrc_EditTable1.Init(DBSync.DBSync.DB_for_Tangenta.m_DBTables, tbl_myOrganisation_Person, selection, ColumnToOrderBy, false, " where  myOrganisation_Person_$_office_$$ID = " + m_Office_ID.ToString() + " ", null, false,nav))
     {
         usrc_EditTable1.FillInitialData();
     }
     else
     {
         bclose = true;
     }
 }

 public Form_Tool_SelectItem(Atom_ItemShopA xAtom_ItemShopA, usrc_Editor xusrc_Editor)
 {
     InitializeComponent();
     m_Atom_ItemShopA = xAtom_ItemShopA;
     m_usrc_Editor = xusrc_Editor;
     t_Atom_ItemShopA = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Atom_ItemShopA)));
 }

 public Form_StockItem_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string where_condition, string ColumnToOrderBy,TangentaDB.Item_Data x_Item_Data, NavigationButtons.Navigation xnav)
 {
     InitializeComponent();
     nav = xnav;
     m_Item_Data = x_Item_Data;
     lngRPM.s_lbl_Item_Stock.Text(lbl_Item_Stock);
     this.lbl_Item.Text = m_Item_Data.Item_UniqueName.v;
     dbTables = xdbTables;
     tbl = xtbl;
     this.Text = lngRPM.s_Stock.s;
     string selection = @"Stock_$_ppi_$_i_$$UniqueName,Stock_$$dQuantity,Stock_$$ExpiryDate, Stock_$_ppi_$_pp_$$PurchasePricePerUnit,Stock_$$ImportTime,Stock_$_ppi_$_i_$$Description,Stock_$_ppi_$_st_$_sup_$_c_$_orgd_$_org_$$Name,Stock_$_ppi_$_i_$$Code,Stock_$_ppi_$_i_$_u_$$Name,Stock_$_ppi_$_i_$_u_$$Symbol,Stock_$_ppi_$_i_$_u_$$DecimalPlaces,Stock_$_ppi_$_i_$_u_$$StorageOption,Stock_$_ppi_$_i_$_exp_$$ExpectedShelfLifeInDays,Stock_$_ppi_$_i_$_exp_$$SaleBeforeExpiryDateInDays,Stock_$_ppi_$_i_$_exp_$$DiscardBeforeExpiryDateInDays,Stock_$_ppi_$_i_$_wrty_$$WarrantyDuration, Stock_$_ppi_$_i_$_wrty_$$WarrantyDurationType,Stock_$_ppi_$_i_$_wrty_$$WarrantyConditions,Stock_$_ppi_$_i_$_iimg_$$Image_Data,ID";
     if (m_usrc_EditTable.Init(dbTables, tbl, selection,ColumnToOrderBy,false,where_condition,null,false,nav))
     {
         if (m_usrc_EditTable.RowsCount==0)
         {
             if (f_PurchasePrice_Item.GetOneFrom_Item_ID(m_Item_Data.Item_ID.v, ref PurchasePrice_Item_ID))
             {
                 m_usrc_EditTable.FillInitialData();
             }
             else
             {
                 bclose = true;
                 return;
             }
         }
         m_usrc_EditTable.CallBackSetInputControlProperties(m_Item_Data.Unit_DecimalPlaces.v);
     }
     else
     {
         bclose = true;
     }
 }

        // function creates DefineView_InputControls but does not bind them with xml data !
        public void Create_DefineView_InputControls(SQLTable pPrevTable, string sParentKeys, ref List<DefineView_InputControl> inpCtrlList, Object pParentWindow, Form pForm,ref int iCtrl)
        {
            int iCol = 0;
            int iCount = Column.Count();
            this.pParentTable = pPrevTable;

            for (iCol = 0; iCol < iCount; iCol++)
            {
                Column col = Column[iCol];
                if (!col.IsIdentity)
                {
                    if (col.fKey != null)
                    {
                        string sKey;

                        sKey = sParentKeys + "*" + col.fKey.refInListOfTables.TableName + ">";
                        col.fKey.fTable.Create_DefineView_InputControls(this, sKey, ref inpCtrlList, this.DefineView_GroupBox, pForm, ref iCtrl);
                    }
                    else
                    {
                        string sImportExportLine;

                        DefineView_InputControl inpCtrl;
                        sImportExportLine = sParentKeys + col.Name;
                        inpCtrl = new DefineView_InputControl(col, inpCtrlList, sImportExportLine, true, ref iCtrl);
                        col.DefineView_InputControl = inpCtrl;
                        inpCtrlList.Add(inpCtrl);
                    }
                }
            }
        }

 public Form_myOrg_Office(NavigationButtons.Navigation xnav)
 {
     InitializeComponent();
     nav = xnav;
     usrc_NavigationButtons1.Init(nav);
     lngRPM.s_Edit_Office_Data.Text(btn_Office_Data_And_FVI_SLO_RealEstateBP);
     if (myOrg.ID_v != null)
     {
         myOrganisation_ID = myOrg.ID_v.v;
         tbl_Office = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Office)));
         this.Text = lngRPM.s_Edit_Offices.s;
         this.usrc_EditTable1.Title = lngRPM.s_Edit_Offices.s;
         long_v myOrganisation_ID_v = new long_v(myOrganisation_ID);
         string selection = "Office_$$Name,Office_$$ShortName,Office_$_mo_$_orgd_$_org_$$Name,Office_$_mo_$_orgd_$_orgt_$$OrganisationTYPE,Office_$_mo_$_orgd_$_org_$$Tax_ID,ID";
         string where_condition = " where Office_$_mo_$$ID = " + myOrganisation_ID.ToString() + " ";
         if (usrc_EditTable1.Init(DBSync.DBSync.DB_for_Tangenta.m_DBTables, tbl_Office, selection, ColumnToOrderBy, false, null, null, false,nav))
         {
             usrc_EditTable1.FillInitialData();
         }
         else
         {
             bclose = true;
         }
     }
     else
     {
         LogFile.Error.Show("ERROR:Tangenta:Form_myOrg_Offices_Edit():myOrg.ID_v is not defined!");
         bclose = true;
     }
 }

        //this constructor is used only for DBm_Image and DBm_Document table trees
        public Column(Column c,SQLTable DBm_owner_Table,List<SQLTable> lTable)
        {
            obj = SetObject(c.obj);
            nulltype = c.nulltype;
            Style = c.Style;
            flags = c.flags;
            IsIdentity = c.IsIdentity;
            ownerTable = c.ownerTable;
            Name = c.Name;
            //            Value = c.Value;

            //SetType = c.SetType;
            if (c.fKey != null)
            {
                fKey = new ForeignKey(c.fKey, DBm_owner_Table, lTable);
            }
            Name_in_language = c.Name_in_language;
            //Name_in_language = new ltext();
            //int iCount = c.Name_in_language.sText.Length;

            //for (int i = 0; i < iCount;i++)
            //{
            //    Name_in_language.sText(i) = c.Name_in_language.sText(i);
            //}
        }

 public usrc_RowReferencedFromTable_List_Dialog(List<usrc_RowReferencedFromTable> x_usrc_RowReferencedFromTable_List,SQLTable x_tbl,long x_id, ltext xInstruction)
 {
     InitializeComponent();
     Instruction = xInstruction;
     m_usrc_RowReferencedFromTable_List = x_usrc_RowReferencedFromTable_List;
     m_tbl = x_tbl;
     id = x_id;
     if (m_usrc_RowReferencedFromTable_List!=null)
     {
         int y = 0;
         foreach (usrc_RowReferencedFromTable x_usrc_RowReferencedFromTable in m_usrc_RowReferencedFromTable_List)
         {
             x_usrc_RowReferencedFromTable.Top = y;
             x_usrc_RowReferencedFromTable.Left = 2;
             x_usrc_RowReferencedFromTable.BorderStyle = BorderStyle.Fixed3D;
             x_usrc_RowReferencedFromTable.Width = pnl_usrc_RowReferencedTable_List.Width - 4;
             x_usrc_RowReferencedFromTable.Anchor = AnchorStyles.Top | AnchorStyles.Left | AnchorStyles.Right;
             x_usrc_RowReferencedFromTable.Visible = true;
             pnl_usrc_RowReferencedTable_List.Controls.Add(x_usrc_RowReferencedFromTable);
             y += x_usrc_RowReferencedFromTable.Height + 2;
         }
     }
     this.btn_Yes.Text = lngRPM.s_Yes.s;
     this.btn_No.Text = lngRPM.s_No.s;
 }

 public EditTable_Form(DBTableControl dbTables, SQLTable tbl, TableDockingForm dtF,Globals.delegate_SetControls xSetControls, bool bReadOnly,NavigationButtons.Navigation xnav)
 {
     m_TableDockingForm = dtF;
     this.Icon = Properties.Resources.SmallEditIcon;
     InitializeComponent();
     this.Text = lngRPM.s_EditTable.s + tbl.lngTableName.s + " (" + tbl.TableName + ")";
     usrc_EditRow.Init(dbTables, tbl, xSetControls, bReadOnly,xnav);
 }

 public Form_DBSettings_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, NavigationButtons.Navigation xnav)
 {
     InitializeComponent();
     nav = xnav;
     dbTables = xdbTables;
     tbl = xtbl;
     ColumnOrderBy = xColumnOrderBy;
     lngRPM.s_DBSettings.Text(this);
 }

 public Form_PersonData_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy,NavigationButtons.Navigation xnav)
 {
     InitializeComponent();
     nav = xnav;
     dbTables = xdbTables;
     tbl = xtbl;
     ColumnOrderBy = xColumnOrderBy;
     this.Text = lngRPM.s_Customers_Person.s;
 }

 public Form_OrganisationAccount_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy, NavigationButtons.Navigation xnav)
 {
     InitializeComponent();
     nav = xnav;
     dbTables = xdbTables;
     tbl = xtbl;
     ColumnOrderBy = xColumnOrderBy;
     this.Text = lngRPM.s_OrganisationAccount.s;
 }

 internal bool Do_Form_Stock_Edit()
 {
     SQLTable tbl_Stock = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Stock)));
     //SQLTable tbl_Item = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(Item)));
     Form_Stock_Edit edt_Stock_dlg = new Form_Stock_Edit(DBSync.DBSync.DB_for_Tangenta.m_DBTables,
                                                       tbl_Stock,
                                                       "Stock_$_ppi_$_i_$$Code asc", nav);
     edt_Stock_dlg.ShowDialog();
     return edt_Stock_dlg.Changed;
 }