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; } }
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 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_StockTake_Edit(Navigation xnav, CodeTables.DBTableControl xdbTables) { InitializeComponent(); this.nav = xnav; dbTables = xdbTables; this.Text = lngRPM.s_EditStockTakeItems.s; usrc_EditTable1.Text(lngRPM.s_EditStockTake); }
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; }
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_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 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; }
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); }
public Form_ShopAItem_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string ColumnToOrderBy) { InitializeComponent(); dbTables = xdbTables; tbl = xtbl; this.Text = lngRPM.s_ShopB_Items.s; if (!usrc_EditTable.Init(dbTables, tbl,null,ColumnToOrderBy,false,null,null,false,null)) { bclose = true; } }
public Form_Customer_Person_Edit(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; this.usrc_EditTable.Title = xtbl.lngTableName.s; }
public Form_PersonData_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string xColumnOrderBy, long ID, NavigationButtons.Navigation xnav) { InitializeComponent(); nav = xnav; dbTables = xdbTables; tbl = xtbl; ColumnOrderBy = xColumnOrderBy; ID_v = new long_v(); ID_v.v = ID; this.Text = lngRPM.s_Items.s; }
public SelectID_Table_Assistant_Form(string sql, SQLTable tbl, DBTableControl xDBTables, string[] xsCoumnsToView) { InitializeComponent(); m_sql = sql; m_DBTables = xDBTables; m_tbl = tbl; this.Text = tbl.lngTableName.s + " (" + tbl.TableName + ")"; string csError = ""; ColumnToView = xsCoumnsToView; FillDataTable(ref csError); this.btn_Cancel.Text = lngRPM.s_Cancel.s; }
public DataTable_Form(DBTableControl dbTables, SQLTable tbl, DataTable_Form_ENUM eMode, TableDockingForm pForm) { //m_DB = pDB; m_DBTables = dbTables; m_Mode = eMode; m_tbl = tbl; m_TableDockingForm = pForm; this.Icon = Properties.Resources.table; InitializeComponent(); SetControls(m_tbl); }
public MyDataBase_Tangenta(Form pForm, string XmlRootName, string xmlIniFileFolder) { // TODO: Complete member initialization mt = new TangentaTableClass.SQL_Database_Tables_Definition(); m_DBTables = new DBTableControl(pForm, XmlRootName, xmlIniFileFolder); // Define_Image_SQL_Database_Tables(); // Define_Document_SQL_Database_Tables(); Define_SQL_Database_Tables(); }
public bool Insert(ref long ID, DBTableControl dbTables) { switch (dbTables.m_con.DBType) { case DBConnectionControl40.DBConnection.eDBType.SQLITE: return Insert_SQL(ref ID, dbTables,-1); case DBConnectionControl40.DBConnection.eDBType.MSSQL: return Insert_SQL(ref ID, dbTables,-1); case DBConnectionControl40.DBConnection.eDBType.MYSQL: return Insert_SQL(ref ID, dbTables,-1); } return false; }
public Form_Templates(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy, NavigationButtons.Navigation xnav) { InitializeComponent(); nav = xnav; dbTables = xdbTables; tbl = xtbl; ColumnOrderBy = xColumnOrderBy; this.Text = lngRPM.s_Items.s; rdb_OnlyInOffer.Checked = true; this.rdb_OnlyInOffer.Text = lngRPM.s_OnlyInOffer.s; this.rdb_All.Text = lngRPM.s_AllItems.s; this.rdb_OnlyNotInOffer.Text = lngRPM.s_OnlyNotInOffer.s; }
public Form_ShopC_Item_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl,string xColumnOrderBy, NavigationButtons.Navigation xnav) { InitializeComponent(); nav = xnav; dbTables = xdbTables; tbl = xtbl; usrc_NavigationButtons1.Init(nav); ColumnOrderBy = xColumnOrderBy; lngRPM.s_Items.Text(this, " "+lngRPM.s_Shop_C.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); }
public Price_Undefined_Window(string sTitle,DataTable xdt_price_Item_view,CodeTables.DBTableControl xdbTables) { InitializeComponent(); this.Title = sTitle; this.btn_Edit.Content = lngRPM.s_EditPriceList.s; this.btn_Cancel.Content = lngRPM.s_Cancel.s; dt_price_Item_view = xdt_price_Item_view; dbTables = xdbTables; this.dgvx_PriceUndefinedItem.ItemsSource = dt_price_Item_view.AsDataView(); tbl = new SQLTable(dbTables.GetTable(typeof(Atom_cAddress_Org))); tbl.CreateTableTree(dbTables.items); this.dgvx_PriceUndefinedItem.AutoGeneratedColumns +=dgvx_PriceUndefinedItem_AutoGeneratedColumns; //this.dgvx_PriceUndefinedItem.Columns[0].Header = }
public EditTable_Assistant_Form(usrc_myGroupBox mygrpbox, SQLTable tbl,ID_v id_v, DBTableControl xDBTables,int xpos, int ypos) { my_start_up_id_v = id_v; m_xpos = xpos; m_ypos = ypos; m_DBTables = xDBTables; m_MyGroupBox = mygrpbox; m_tbl = tbl; InitializeComponent(); btn_Cancel.Text = lngRPM.s_Cancel.s; this.Text = tbl.lngTableName.s + " (" + tbl.TableName + ")"; string csError=""; FillDataTable(ref csError); }
public TableDockingForm(Form pParentForm, DBTableControl dbTables, SQLTable tbl,NavigationButtons.Navigation xnav) { nav = xnav; m_pParentForm = pParentForm; InitializeComponent(); m_DBTables = dbTables; m_tbl = tbl; m_pTableDockingFormXml = m_DBTables.m_xml.GetTableDockingFormXml(m_tbl.TableName); if (m_pTableDockingFormXml == null) { m_pTableDockingFormXml = new TableDockingFormXml(m_tbl.TableName); m_DBTables.m_xml.m_xmldata.Add(m_pTableDockingFormXml); } m_pTableDockingFormXml.wrect.SetFormPlacement(this); this.Icon = Properties.Resources.TableDockingForm_icon; this.Text = m_tbl.lngTableName.s; SetViews(); }
public Form_ShopB_Item_Edit(CodeTables.DBTableControl xdbTables, SQLTable xtbl, string ColumnToOrderBy, NavigationButtons.Navigation xnav) { InitializeComponent(); m_bChanged = false; dbTables = xdbTables; nav = xnav; tbl = xtbl; lngRPM.s_Items.Text(this, " "+lngRPM.s_Shop_B.s); List_of_Inserted_Items_ID = new List<long>(); 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); usrc_NavigationButtons1.Init(xnav); string selection = " SimpleItem_$$Name,SimpleItem_$$Abbreviation,SimpleItem_$_siimg_$$Image_Data,SimpleItem_$_sipg1_$$Name,SimpleItem_$_sipg1_$_sipg2_$$Name,SimpleItem_$_sipg1_$_sipg2_$_sipg3_$$Name,SimpleItem_$$ToOffer,ID "; if (!usrc_EditTable.Init(dbTables, tbl, selection, ColumnToOrderBy,false,null,null,false,nav)) { bclose = true; } }
public void CreateInputControls(SQLTable pPrevTable, Column fcol, string sParentKeys, ref List<usrc_InputControl> inpCtrlList, Object pParentWindow, Control pControl, DBTableControl xDBTables, bool bReadOnly, NavigationButtons.Navigation xnav) { int iCol = 0; int iCount = Column.Count(); this.pParentTable = pPrevTable; this.myGroupBox = new usrc_myGroupBox(); this.myGroupBox.SelectionButtonVisible = m_SelectionButtonVisible; this.myGroupBox.Init(this, fcol, sParentKeys, pParentWindow, pControl, xDBTables, bReadOnly,xnav); if (pParentWindow.GetType() == typeof(myPanel)) { this.myGroupBox.Left = 5; this.myGroupBox.Top = 5; Panel pnl = (Panel)pParentWindow; pnl.Controls.Add(myGroupBox); } else if (pParentWindow.GetType() == typeof(usrc_myGroupBox)) { usrc_myGroupBox pParentMyGroupBox = (usrc_myGroupBox)pParentWindow; MyControl mctrl = new MyControl(this.myGroupBox); pParentMyGroupBox.controls.Add(mctrl); } for (iCol = 0; iCol < iCount; iCol++) { Column col = Column[iCol]; if (!col.IsIdentity) { if (col.fKey != null) { string sKey; bool xbReadOnly = bReadOnly; if (col.Style == CodeTables.Column.eStyle.ReadOnlyTable) { xbReadOnly = true; } sKey = sParentKeys + "*" + col.fKey.refInListOfTables.TableName + ">"; col.fKey.fTable.CreateInputControls(this, col, sKey, ref inpCtrlList, this.myGroupBox, pControl, xDBTables, xbReadOnly,xnav); } else { string sImportExportLine; usrc_InputControl inpCtrl; if (col.IsNumber()) { sImportExportLine = sParentKeys + col.Name + ","; inpCtrl = new usrc_InputControl(); inpCtrl.Init(this, col, inpCtrlList, sImportExportLine, true,bReadOnly); if (!bReadOnly) { inpCtrl.ObjectChanged += new usrc_InputControl.delegate_ObjectChanged(inpCtrl_ObjectChanged); } col.InputControl = inpCtrl; } else { sImportExportLine = sParentKeys + col.Name + ","; inpCtrl = new usrc_InputControl(); inpCtrl.Init(this, col, inpCtrlList, sImportExportLine, false,bReadOnly); if (!bReadOnly) { inpCtrl.ObjectChanged += new usrc_InputControl.delegate_ObjectChanged(inpCtrl_ObjectChanged); } col.InputControl = inpCtrl; } MyControl mctrl = new MyControl(inpCtrl); this.myGroupBox.controls.Add(mctrl); } } } if (pPrevTable!=null) { if (pParentWindow is usrc_myGroupBox) { if (!bReadOnly) { this.myGroupBox.Unique_parameter_exist += myGroupBox_Unique_parameter_exist; this.myGroupBox.bUnique_parameter_exist = true; this.myGroupBox.RowReferenceFromTable_Check_NoChangeToOther += myGroupBox_RowReferenceFromTable_Check_NoChangeToOther; this.myGroupBox.usrc_myGroupBox_IndexChanged += new usrc_myGroupBox.delegate_IndexChanged(myGroupBox_usrc_myGroupBox_IndexChanged); this.myGroupBox.usrc_InputControl_ObjectChanged += new usrc_myGroupBox.delegate_ObjectChanged(myGroupBox_usrc_InputControl_ObjectChanged); } } //if (pParentWindow is Panel) //{ // if (!bReadOnly) // { // this.myGroupBox.Unique_parameter_exist += myGroupBox_Unique_parameter_exist; // this.myGroupBox.bUnique_parameter_exist = true; // this.myGroupBox.RowReferenceFromTable_Check_NoChangeToOther += myGroupBox_RowReferenceFromTable_Check_NoChangeToOther; // //this.myGroupBox.usrc_myGroupBox_IndexChanged += new usrc_myGroupBox.delegate_IndexChanged(myGroupBox_usrc_myGroupBox_IndexChanged); // //this.myGroupBox.usrc_InputControl_ObjectChanged += new usrc_myGroupBox.delegate_ObjectChanged(myGroupBox_usrc_InputControl_ObjectChanged); // } //} } }
private bool Insert_MSSQL(ref long ID, DBTableControl dbTables, int iSQLFormatedTabsWithLineBreaks) { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string sql_insert = " insert into " + this.TableName; string sql_insert_columns = ""; string sql_insert_values = ""; string crlf = "\r\n"; if (iSQLFormatedTabsWithLineBreaks >= 0) { sql_insert += crlf + "(" + crlf; } else { sql_insert += "("; } int i = 0; foreach (Column col in Column) { if (!col.IsIdentity) { SQL_Parameter par = null; string Insert_into_value_parameter = null; if (col.get_SQL_Parameter(ref par, ref Insert_into_value_parameter, dbTables, iSQLFormatedTabsWithLineBreaks)) { if (par != null) { if (i == 0) { sql_insert_columns += col.Name; sql_insert_values += Insert_into_value_parameter; i = 1; } else { if (iSQLFormatedTabsWithLineBreaks >= 0) { sql_insert_columns += "," + crlf + col.Name; sql_insert_values += "," + crlf + Insert_into_value_parameter; } else { sql_insert_columns += "," + col.Name; sql_insert_values += "," + Insert_into_value_parameter; } } lpar.Add(par); } } else { return false; } } } if (iSQLFormatedTabsWithLineBreaks >= 0) { sql_insert += sql_insert_columns + crlf + ")" + crlf + "values" + crlf + "(" + crlf + sql_insert_values + crlf + ")"; } else { sql_insert += sql_insert_columns + ")values(" + sql_insert_values + ")"; } object objret = null; string Err = null; if (dbTables.m_con.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref ID, ref objret, ref Err, this.TableName)) { return true; } else { LogFile.Error.Show("Error:SQLTable:Insert_SQLite:Err=" + Err); return false; } }
internal bool Insert_SQL_Get_Select_ID(ref long_v id_v, DBTableControl dbTables, int iSQLFormatedTabsWithLineBreaks) { if (Insert_SQLite_Get_Select_Unique_ID(ref id_v, dbTables, iSQLFormatedTabsWithLineBreaks)) { if (id_v != null) { return true; } else { List<SQL_Parameter> lpar = new List<SQL_Parameter>(); string sql_select = " select id from " + this.TableName + " where "; string sql_compare_values = ""; string sql_InsertColumns = ""; string sql_InsertValues = ""; int i = 0; foreach (Column col in Column) { if (!col.IsIdentity) { string compare_value_parameter = null; SQL_Parameter par = null; if (col.get_SQL_Parameter(ref par, ref compare_value_parameter, dbTables, iSQLFormatedTabsWithLineBreaks)) { if (i == 0) { if (iSQLFormatedTabsWithLineBreaks < 0) { if (compare_value_parameter.Equals("null")) { sql_compare_values += col.Name + " is null "; sql_InsertValues += "null"; } else { sql_compare_values += col.Name + " = " + compare_value_parameter; sql_InsertValues += compare_value_parameter; lpar.Add(par); } } else { if (compare_value_parameter.Equals("null")) { sql_compare_values += "\r\n" + col.Name + " is null "; sql_InsertValues += "\r\nnull"; } else { sql_compare_values += "\r\n" + col.Name + " = " + compare_value_parameter; sql_InsertValues += "\r\n" + compare_value_parameter; lpar.Add(par); } } sql_InsertColumns += col.Name; i = 1; } else { if (iSQLFormatedTabsWithLineBreaks < 0) { if (compare_value_parameter.Equals("null")) { sql_compare_values += " and " + col.Name + " is null "; sql_InsertValues += ",null"; } else { sql_compare_values += " and " + col.Name + " = " + compare_value_parameter; sql_InsertValues += "," + compare_value_parameter; lpar.Add(par); } } else { if (compare_value_parameter.Equals("null")) { sql_compare_values += "\r\n and " + col.Name + " is null "; sql_InsertValues += "\r\n,null"; } else { sql_compare_values += "\r\n and " + col.Name + " = " + compare_value_parameter; sql_InsertValues += "\r\n," + compare_value_parameter; lpar.Add(par); } } sql_InsertColumns += ","+col.Name; } } else { return false; } } } if (sql_compare_values.Length > 0) { sql_select += sql_compare_values; DataTable dt = new DataTable(); string Err = null; if (dbTables.m_con.ReadDataTable(ref dt, sql_select, lpar, ref Err)) { if (dt.Rows.Count > 0) { if (id_v == null) { id_v = new long_v(); } id_v.v = (long)dt.Rows[0]["id"]; return true; } else { string sql_insert = "insert into " + this.TableName + "(" + sql_InsertColumns+")Values("+sql_InsertValues+")"; // row not found long id = -1; object oret = null; if (dbTables.m_con.ExecuteNonQuerySQLReturnID(sql_insert, lpar, ref id, ref oret, ref Err, this.TableName)) { if (id_v == null) { id_v = new long_v(); } id_v.v = id; return true; } else { LogFile.Error.Show("ERROR:Insert_SQLite_Get_Select_ID:sql=" + sql_select + "\r\nErr=" + Err); return false; } } } else { LogFile.Error.Show("ERROR:Insert_SQLite_Get_Select_ID:sql=" + sql_select + "\r\nErr=" + Err); return false; } } return true; } } else { return false; } }
private bool Insert_MYSQL(ref long ID, DBTableControl dbTables) { throw new NotImplementedException(); }
public static bool InsertInDataBase_WithImportText(Globals.delegate_SetControls SetControls, SQLTable m_tbl,DBTableControl dbTables, StringBuilder sDataBaseUsed, bool bRefresh_m_DataTable_Form) { bool bRet = false; List<string> Lines = m_tbl.GetInputControlsData(); if (Lines != null) { if (Lines.Count > 0) { string ErrorMsg = ""; if (SQLcmd_InsertLines(Lines, dbTables, sDataBaseUsed, ref ErrorMsg)) { bRet = true; //System.Data.OleDb.OleDbDataAdapter adp=new System.Data.OleDb.OleDbDataAdapter(); if (bRefresh_m_DataTable_Form) { if (SetControls != null) { SetControls(m_tbl); } } } else { if (!DBConnectionControl40.DynSettings.bPreviewSQLBeforeExecution) { MessageBox.Show(ErrorMsg); } } } } return bRet; }
public static bool SQLcmd_InsertLines(List<string> Line, DBTableControl dbTables, StringBuilder m_strSQLUseDatabase, ref string ErrorMsg) { List<SQL_Parameter> lsqlPar = new List<SQL_Parameter>(); SQLTable sqlTbl = null; SQLTable refsqlTbl = null; int iTableNameStart; int iTableNameEnd; StringBuilder sbSQLInsert = new StringBuilder(m_strSQLUseDatabase.ToString()); string sPrevVar = ""; char[] trimChars = new char[] { ' ', '\t' }; int index; int iCount = Line.Count(); index = 0; while (index < iCount) { string sLine = Line[index]; if (sqlTbl != null) { iTableNameStart = sLine.IndexOf('<'); if (iTableNameStart != -1) { iTableNameStart++; if (sLine[iTableNameStart].Equals('/')) { iTableNameStart++; iTableNameEnd = sLine.IndexOf('>'); string sTblName = sLine.Substring(iTableNameStart, iTableNameEnd - iTableNameStart); if (sqlTbl.TableName.Equals(sTblName)) { string sVarID = Globals.sVar + "_" + sqlTbl.TableName; sPrevVar = Globals.sVar; if (dbTables.m_con.DBType == DBConnection.eDBType.SQLITE) { string PrevVar = sqlTbl.TableName; sVarID = ""; Int64 ID = -1; string csError = null; bool bSomethingDefined = false; if (sqlTbl.SQLcmd_InsertInto_SQLITE(dbTables.m_con, PrevVar, ref sVarID, /*ref lsqlPar,*/ dbTables.items,ref bSomethingDefined, ref ID, ref csError)) { if (ID != -1) { return true; } else { return false; } } else { LogFile.Error.Show("Error:" + csError); } } else { sqlTbl.SQLcmd_Insert_MSSQL(ref sbSQLInsert, sPrevVar, ref sVarID, ref lsqlPar, dbTables.items,0); object oResult = null; if (dbTables.m_con.ExecuteNonQuerySQL(sbSQLInsert.ToString(), lsqlPar,ref oResult, ref ErrorMsg)) { lsqlPar.Clear(); sbSQLInsert.Remove(0, sbSQLInsert.Length); sbSQLInsert.Append(m_strSQLUseDatabase.ToString()); sqlTbl = null; } else { return false; } } } else { MessageBox.Show(lngRPM.s_Illegal_end_table_XML_command_expected.s + ": </" + sqlTbl.TableName + ">\n", lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Error); //Source_Txt.CloseText(); } } else { MessageBox.Show(lngRPM.s_Illegal_end_table_XML_command_expected.s + ": </" + sqlTbl.TableName + ">\n", lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Error); // Source_Txt.CloseText(); } } else { string[] column = sLine.Split(','); int iTokenCount = column.Count(); string s1; string s2 = ""; if (iTokenCount >= 2) { s1 = column[0]; int i; for (i = 1; i < iTokenCount; i++) { s2 += column[i]; } string Value = ""; index = GetValue(index, Line, s2, ref Value); if (sqlTbl.SetColumnValue(s1, Value)) { index++; continue; } else { //Source_Txt.CloseText(); return false; } } else { //Source_Txt.ShowParseError(lngRPM.s_File.s + ":" + FileName + "\n" + lngRPM.s_Comma_is_missing_to_separate_cells_column_name_from_cell_value_in_line.s + ":" + Source_Txt.iLine.ToString(), lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Error); MessageBox.Show(lngRPM.s_File.s + lngRPM.s_Comma_is_missing_to_separate_cells_column_name_from_cell_value_in_line.s, lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Error); //Source_Txt.CloseText(); return false; } } } else { iTableNameStart = sLine.IndexOf('<'); iTableNameEnd = sLine.IndexOf('>'); if ((iTableNameStart != -1) && (iTableNameEnd != -1) && (iTableNameEnd > iTableNameStart)) { string sTableName = sLine.Substring(iTableNameStart + 1, iTableNameEnd - iTableNameStart - 1); sTableName = sTableName.TrimStart(trimChars); sTableName = sTableName.TrimEnd(trimChars); if (Globals.FindTable(out refsqlTbl, sTableName, dbTables.items)) { sqlTbl = new SQLTable(refsqlTbl); sqlTbl.CreateTableTree(dbTables.items); index++; continue; } else { //Source_Txt.ShowParseError(lngRPM.s_TableNameIsExpectedToBeBeforeDataLines.s, lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); MessageBox.Show(lngRPM.s_TableNameIsExpectedToBeBeforeDataLines.s, lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return false; } } else { //Source_Txt.ShowParseError(lngRPM.s_TableNameIsExpectedToBeBeforeDataLines.s, lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); MessageBox.Show(lngRPM.s_TableNameIsExpectedToBeBeforeDataLines.s, lngRPM.s_Error.s, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return false; } } index++; } //Source_Txt.CloseText(); // Structures are filled now create SQL statements return true; }
public CreateView_Form(DBTableControl dbTables, SQLTable tbl, TableDockingForm dtF, NavigationButtons.Navigation xnav) { nav = xnav; this.Visible = false; bFormCreated = false; m_TableDockingForm = dtF; m_DBTables = dbTables; m_tbl = tbl; this.Icon=Properties.Resources.DataView_FormIcon; InitializeComponent(); nmUpDn_Limit.Minimum = 0; nmUpDn_Limit.Maximum = 1000000000; chk_Limit.Checked = Properties.Settings.Default.bLimit; nmUpDn_Limit.Value = Convert.ToDecimal(Properties.Settings.Default.iLimitNumber); chk_Descending.Checked = Properties.Settings.Default.b_order_by_ID_desc; this.flowLayoutPanel1.Tag = 1; this.flowLayoutPanel1.FlowDirection = FlowDirection.LeftToRight; this.flowLayoutPanel2.Tag = 2; this.flowLayoutPanel2.FlowDirection = FlowDirection.TopDown; PictureBox pictureBox_MoveRight = new PictureBox(); pictureBox_MoveRight.Image = Properties.Resources.MoveRightIcon.ToBitmap(); pictureBox_MoveRight.Parent = this; pictureBox_MoveRight.Left = flowLayoutPanel2.Left + flowLayoutPanel2.Width + 3; pictureBox_MoveRight.Top = flowLayoutPanel2.Top + flowLayoutPanel2.Height / 4; pictureBox_MoveRight.Width = pictureBox_MoveRight.Image.Size.Width + 6; pictureBox_MoveRight.Height = pictureBox_MoveRight.Image.Size.Height + 6; pictureBox_MoveRight.Visible = true; //pictureBox_MoveRight.Anchor = AnchorStyles.Top | AnchorStyles.Bottom; PictureBox pictureBox_MoveLeft = new PictureBox(); pictureBox_MoveLeft.Image = Properties.Resources.MoveLeftIcon.ToBitmap(); pictureBox_MoveLeft.Parent = this; pictureBox_MoveLeft.Left = flowLayoutPanel2.Left + flowLayoutPanel2.Width + 3; pictureBox_MoveLeft.Top = flowLayoutPanel2.Top + flowLayoutPanel2.Height/4 + 30; pictureBox_MoveLeft.Width = pictureBox_MoveLeft.Image.Size.Width + 6; pictureBox_MoveLeft.Height = pictureBox_MoveLeft.Image.Size.Height + 6; pictureBox_MoveLeft.Visible = true; //pictureBox_MoveLeft.Anchor = AnchorStyles.Top | AnchorStyles.Bottom; //this.pictureBox2.Image = Properties.Resources.MoveLeftIcon.ToBitmap(); this.flowLayoutPanel1.DragEnter += new DragEventHandler(flowLayoutPanel1_DragEnter); this.flowLayoutPanel1.DragDrop += new DragEventHandler(flowLayoutPanel1_DragDrop); this.flowLayoutPanel2.DragEnter += new DragEventHandler(flowLayoutPanel1_DragEnter); this.flowLayoutPanel2.DragDrop += new DragEventHandler(flowLayoutPanel1_DragDrop); if (!bFormCreated) { int iCtrl = 1; m_pTableDockingFormXml = m_DBTables.m_xml.GetTableDockingFormXml(m_tbl.TableName); if (m_pTableDockingFormXml == null) { m_pTableDockingFormXml = m_DBTables.m_xml.Create_pTableDockingFormXml(m_tbl.TableName); m_DBTables.m_xml.m_xmldata.Add(m_pTableDockingFormXml); } if (m_pTableDockingFormXml.m_CreateViewFormXml == null) { m_pTableDockingFormXml.Create_pCreateViewFormXml(); } m_pTableDockingFormXml.m_CreateViewFormXml.wrect.SetFormPlacement(this); // Create DefineView_InputControls with no binding to xml data ! m_tbl.Create_DefineView_InputControls(null, "", ref m_tbl.DefineView_inpCtrlList, this, this, ref iCtrl); //this.DynamicCreateControls(m_DBTables.m_xml.GetCreateViewFormDefaultView(m_tbl.TableName)); this.DynamicCreateControls(m_pTableDockingFormXml.m_CreateViewFormXml.m_DefaultViewXml); bFormCreated = true; } this.Text = lngRPM.s_DataView_Form.s + m_tbl.lngTableName.s + " (" + m_tbl.TableName + ")"; tsmi_CreateNew.Text = lngRPM.s_CreateNewView.s; tsmi_Select_View.Text = lngRPM.s_SelectView.s; tsmi_DeleteView.Text = lngRPM.s_DeleteView.s; tsmi_Save.Text = lngRPM.s_Save.s; tsmi_Show.Text = lngRPM.s_Show.s; label_PrimaryView.Text = lngRPM.s_PrimaryView.s; chk_Limit.Text = lngRPM.s_Limit.s; chk_Descending.Text = lngRPM.s_Descending.s; grb_ShowLimits.Text = lngRPM.s_View.s; }
/// <summary> /// Create test form /// </summary> /// <param name="identifier">form identifier</param> /// <returns>test form</returns> /// private static Form CreateDockForm(Guid identifier, DBTableControl dbTables, SQLTable x_tbl, TableDockingForm pParentForm, wRect wrect, ViewXml xViewXml,NavigationButtons.Navigation xnav) { if (identifier == new Guid(guid.gDocking_TableGrid_Form.ToByteArray())) { DataTable_Form result = new DataTable_Form(dbTables, x_tbl, DataTable_Form.DataTable_Form_ENUM.EDIT_OR_DELETE, pParentForm); result.Bounds = new Rectangle(wrect.Left, wrect.Top, wrect.Width, wrect.Height); return result; } else if (identifier == new Guid(guid.gDocking_EditTable_Form.ToByteArray())) { EditTable_Form result = new EditTable_Form(dbTables, x_tbl, pParentForm,SetControls,false,xnav); result.Bounds = new Rectangle(wrect.Left, wrect.Top, wrect.Width, wrect.Height); return result; } else if (identifier == new Guid(guid.gDocking_CreateView_Form.ToByteArray())) { CreateView_Form result = new CreateView_Form(dbTables, x_tbl, pParentForm, xnav); result.Bounds = new Rectangle(wrect.Left, wrect.Top, wrect.Width, wrect.Height); return result; } else { for (int i = 0; i < guid.MaxTableViews; i++) { if (identifier == new Guid(guid.gDocking_TableView_Form[i].ToByteArray())) { TableView_Form result = new TableView_Form(i, dbTables, x_tbl, pParentForm, xViewXml); result.Bounds = new Rectangle(wrect.Left, wrect.Top, wrect.Width, wrect.Height); return result; } } } throw new InvalidOperationException(); }