public bool GetData(int Code) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from UnpaidBlackList where Code =" + Code.ToString()); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(int pCode) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from Erp_tabrizbus2.dbo.AUTOnlineReaderConfig where code=" + pCode.ToString()); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetShiftDriverData(int BusNumber, DateTime StartDate, DateTime EndDate) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from AUTPrinterRporte where BusNumber = " + BusNumber.ToString() + " And StartDate = '" + StartDate.ToString() + "' and EndDate = '" + EndDate.ToString() + "'"); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetShiftDriverData(int pCode) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from AUTPrinterRporte where ShiftDriverCode=" + pCode.ToString()); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(int pCode) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from " + JMainFrame.Server01 + @"erp_tabrizbus.dbo.AUTConsoleQueryAuto where code=" + pCode.ToString()); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(int pCode) { JDataBase DB = new JDataBase(); try { DB.setQuery("SELECT * FROM SLADefines WHERE Code = " + pCode.ToString()); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(int pCode) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from AUTBusEventRegister where code=" + pCode.ToString()); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(string pLineNumber) { JDataBase DB = new JDataBase(); try { DB.setQuery("select top 1 * from AUTDailyLineTransactionCount where LineCode=" + pLineNumber + " order by Code desc"); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(int pcode) { JDataBase d = new JDataBase(); try { d.setQuery("select * from AUTBusEventActivity where code=" + pcode.ToString()); d.Query_DataReader(); if (d.DataReader.Read()) { JTable.SetToClassProperty(this, d.DataReader); return(true); } return(false); } finally { d.Dispose(); } }
// GetInfo #region GetInfo /// <summary> /// اطلاعات یک کارتابل /// </summary> /// <param name="pCode">کد object</param> /// <returns>Boolean</returns> public Boolean GetData(int pCode) { JDataBase db = JGlobal.MainFrame.GetDBO(); try { db.setQuery(@"SELECT * FROM " + JTableNamesAutomation.Folders + " WHERE " + Folder.Code + "=" + JDataBase.Quote(pCode.ToString())); db.Query_DataReader(); if (db.DataReader.Read()) { JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
public bool GetData(string pLineNumber) { JDataBase DB = new JDataBase(); try { DB.setQuery("select top 1 * from AutLineServices where LineCode=" + pLineNumber); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetDataByLine(int pLineCode) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from AUTDailyLineTransactionCount where LineCode = " + pLineCode.ToString()); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
/// <summary> /// /// </summary> /// <param name="pCode"></param> /// <returns></returns> public Boolean GetData(int pCode) { JDataBase db = JGlobal.MainFrame.GetDBO(); try { db.setQuery("SELECT * FROM Subsidiaries WHERE [code]=" + JDataBase.Quote(pCode.ToString())); db.Query_DataReader(); if (db.DataReader.Read()) { JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
public bool GetData(string plaque) { JDataBase DB = new JDataBase(); try { DB.setQuery("select * from AUTAutomobile where Plaque=N'" + plaque.ToString() + "'"); DB.Query_DataReader(); if (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public Boolean Find(string pClassName, int pObjectCode, int pDynamicClassCode, JDataBase pDB) { JDataBase db = pDB; try { db.setQuery("SELECT * FROM Objects WHERE ClassName='" + pClassName.ToString() + "' AND DynamicClassCode = '" + pDynamicClassCode.ToString() + "' And ObjectCode = " + pObjectCode.ToString()); db.Query_DataReader(); if (db.DataReader.Read()) { JTable.SetToClassProperty(this, db.DataReader); return(true); } } finally { } return(false); }
public Boolean GetData(string pClassName, int pObjectCode, int pDynamicClassCode) { JDataBase db = new JDataBase(); try { db.setQuery("SELECT * FROM " + JTableNamesAutomation.Objects + " WHERE ClassName=" + JDataBase.Quote(pClassName) + " AND DynamicClassCode = " + pDynamicClassCode.ToString() + " AND ObjectCode = " + pObjectCode.ToString()); if (db.Query_DataReader() && db.DataReader.Read()) { JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
/// <summary> /// لیست کارتابل های کاربری خاص به همراه شرط های آن /// </summary> /// <param name="pCode">کد object</param> /// <returns>Boolean</returns> //public int InsertKartablCondition( tmpJDynamicKartabl) //{ // int code = 0; // JDataBase db = JGlobal.MainFrame.GetDBO(); // try // { // JKartablTable JST = new JKartablTable(); // JST.SetValueProperty(this); // // ----------------- ثبت اطلاعات نامه ------------------- // Code = JST.Insert(db); // if (Code > 0) // { // tmpJDynamicKartabl.Kartabl_code = Code; // JDynamicFolders JDK = new JDynamicFolders(); // tmpJDynamicKartabl.Kartabl_code = Code; // if (JDK.Insert(tmpJDynamicKartabl,db) < 0) // { // db.Rollback(db.TransactionName); // return -1; // } // } // else // return -1; // return -1; // } // finally // { // db.Dispose(); // } //} #endregion GetInfo // Node #region Node /// <summary> /// /// </summary> /// <param name="pParentCode"></param> /// <returns></returns> public JNode[] GetChildsNode(int pParentCode) { JNode[] N = new JNode[0]; JDataBase DB = new JDataBase(); try { DB.setQuery("SELECT * FROM " + ClassLibrary.JTableNamesAutomation.Folders + " WHERE parent_Code = " + pParentCode.ToString()); DB.Query_DataReader(); Array.Resize(ref N, DB.RecordCount); int Count = 0; while (DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); N[Count++] = GetNode(); } return(N); } finally { DB.Dispose(); } }
/// <summary> /// بازیابی محتوای آرشیو /// </summary> /// <param name="pArchiveCode"></param> /// <returns></returns> //private JFile _RetrieveContent(int pArchiveCode) //{ // JDataBase DB = this._Database; // try // { // DB.setQuery("SELECT * FROM " + JTableNameArchive.ContentTable + " WHERE Code = " + pArchiveCode.ToString()); // if (DB.Query_DataSet()) // { // if (DB.DataSet.Tables[0].Rows.Count > 0) // { // System.Data.DataRow row = DB.DataSet.Tables[0].Rows[0]; // JFile file = new JFile(); // file.Content = (byte[])row["Contents"]; // file.Extension = row["FileExtension"].ToString(); // file.FileSource = JFile.JFileSource.FromArchive; // DB.setQuery("UPDATE " + JTableNameArchive.ContentTable + " SET LastAccess = GETDATE() WHERE Code = " + pArchiveCode.ToString()); // DB.Query_Execute(); // return file; // } // return null; // } // return null; // } // catch (Exception ex) // { // JSystem.Except.AddException(ex); // return null; // } //} /// <summary> /// بازیابی اطلاعات مربوط به آرشیو و ست کردن مقادیر کلاس /// </summary> /// <param name="pCode"></param> /// <returns></returns> private bool _GetData(int pCode) { JDataBase DB = this._Database; try { DB.setQuery("SELECT * FROM " + JTableNameArchive.ArchiveTable + " WHERE Code = " + pCode.ToString() + " AND Status = 1"); if (DB.Query_DataReader() && DB.DataReader.Read()) { JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } catch (Exception ex) { JSystem.Except.AddException(ex); return(false); } finally { DB.DataReader.Close(); } }