本文整理汇总了C#中CodeTables.SQLTable类的典型用法代码示例。如果您正苦于以下问题:C# SQLTable类的具体用法?C# SQLTable怎么用?C# SQLTable使用的例子?那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SQLTable类属于CodeTables命名空间,在下文中一共展示了SQLTable类的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: usrc_EditTable_after_InsertInDataBase
private void usrc_EditTable_after_InsertInDataBase(SQLTable m_tbl, long ID, bool bRes)
{
if (bRes)
{
}
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:7,代码来源:Form_ShopAItem_Edit.cs
示例2: Form_ShopC_Item_Edit
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);
}
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:29,代码来源:Form_ShopC_Item_Edit.cs
示例3: StartThread
public bool StartThread(SQLTable tbl,Control pControl)
{
VirtualSecretaryThread = new Thread(VirtualSecretaryJob);
VirtualSecretary_ThreadParam scp = new VirtualSecretary_ThreadParam(tbl, pControl);
VirtualSecretaryThread.Start(scp);
return true;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:7,代码来源:VirtualSecretary_Thread.cs
示例4: Form_myOrg_Person_Edit
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;
}
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:34,代码来源:Form_myOrg_Person_Edit.cs
示例5: Form_Tool_SelectItem
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)));
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:7,代码来源:Form_Tool_SelectItem.cs
示例6: Form_StockItem_Edit
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;
}
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:32,代码来源:Form_StockItem_Edit.cs
示例7: Create_DefineView_InputControls
// 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);
}
}
}
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:32,代码来源:SQL_Table.Create_DefineView_InputControls.cs
示例8: Form_myOrg_Office
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;
}
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:30,代码来源:Form_myOrg_Office.cs
示例9: Column
//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);
//}
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:26,代码来源:Column.cs
示例10: usrc_RowReferencedFromTable_List_Dialog
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;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:25,代码来源:usrc_RowReferencedFromTable_List_Dialog.cs
示例11: EditTable_Form
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);
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:8,代码来源:EditTable_Form.cs
示例12: Form_DBSettings_Edit
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);
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:9,代码来源:Form_DBSettings_Edit.cs
示例13: Form_PersonData_Edit
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;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:9,代码来源:Form_PersonData_Edit.cs
示例14: Form_OrganisationAccount_Edit
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;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:9,代码来源:Form_OrganisationAccount_Edit.cs
示例15: Do_Form_Stock_Edit
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;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:10,代码来源:Form_SelectStockEditType.cs
示例16: PersonAccount_EditForm
public PersonAccount_EditForm(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID)
{
InitializeComponent();
dbTables = xdbTables;
tbl = xtbl;
ColumnOrderBy = xColumnOrderBy;
ID_v = new long_v();
ID_v.v = ID;
this.Text = lngRPM.s_Items.s;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:10,代码来源:Form_PersonAccount_Edit+.cs
示例17: Edit_OrganisationAccount
internal bool Edit_OrganisationAccount()
{
SQLTable tbl_OrganisationAccount = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(OrganisationAccount)));
Form_OrganisationAccount_Edit edt_Item_dlg = new Form_OrganisationAccount_Edit(DBSync.DBSync.DB_for_Tangenta.m_DBTables,
tbl_OrganisationAccount,
" OrganisationAccount_$_org_$$Name desc",nav);
edt_Item_dlg.ShowDialog();
Init();
return true;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:10,代码来源:Form_myOrg_Edit.cs
示例18: Edit_OrganisationData
internal bool Edit_OrganisationData()
{
SQLTable tbl_OrganisationData = new SQLTable(DBSync.DBSync.DB_for_Tangenta.m_DBTables.GetTable(typeof(OrganisationData)));
OrganisationData_EditForm edt_Item_dlg = new OrganisationData_EditForm(DBSync.DBSync.DB_for_Tangenta.m_DBTables,
tbl_OrganisationData,
" OrganisationData_$_org_$$Name desc",nav);
edt_Item_dlg.ShowDialog();
Init();
return true;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:10,代码来源:Form_myOrg_Edit.cs
示例19: Form_myOrg_Edit
public Form_myOrg_Edit(CodeTables.DBTableControl xdbTables,SQLTable xtbl,bool bAllowNew, NavigationButtons.Navigation xnav)
{
InitializeComponent();
nav = xnav;
this.usrc_NavigationButtons1.Init(nav);
dbTables = xdbTables;
tbl = xtbl;
usrc_EditRow.AllowUserToAddNew = bAllowNew;
lngRPM.s_Edit_Offices.Text(btn_Office);
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:10,代码来源:Form_myOrg_Edit.cs
示例20: Join_for_SQLView_InDataBase
public Join_for_SQLView_InDataBase(SQLTable xtbl,string xTableName,string xTableName_Abbreviation, string xAliasTableName, string xParam_ID1, string xParam_ID2, Column.nullTYPE xnulltype)
{
tbl = xtbl;
nulltype = xnulltype;
TableName = xTableName;
TableName_Abbreviation = xTableName_Abbreviation;
AliasTableName = xAliasTableName;
Param_ID1 = xParam_ID1;
Param_ID2 = xParam_ID2;
pSubJoin = null;
}
开发者ID:dstrucl,项目名称:Tangenta40,代码行数:11,代码来源:JoinList_for_SQLView_InDataBase.cs
注:本文中的CodeTables.SQLTable类示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论