//اگر کد برابر صفر باشد تنها مقادیر مربوط به دیتای کاربر فعلی را می گیرد. public bool GetData(int code = 0, int userCode = -1) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { if (code == 0) { DB.setQuery("select top 1 * from AVLCash where userCode=" + userCode); } else { DB.setQuery("select top 1 * from AVLCash where code=" + code + " AND userCode=" + userCode); } DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public JFactorItem(int pFactorCode) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 * from AccFactorItem where Factorcode=" + pFactorCode); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); } } finally { DB.Dispose(); } }
public bool GetData(string deviceCode, int personcode, string name) { ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO(); try { db.setQuery("SELECT top 1 * FROM [AVLArea] WHERE [deviceCode]=" + deviceCode + " and personCode=" + personcode + " and [Name]=N'" + name + "'"); if (db.Query_DataReader() && db.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
/// <summary> /// If isGeofence was FALSE, it will return all the lines /// If isGeofence was TRUE, it will return all the geofence areas /// </summary> /// <param name="IsGeofence"></param> /// <returns></returns> public bool GetAreas(bool IsGeofence = false) { ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO(); try { db.setQuery("SELECT * FROM [AVLArea] WHERE [IsGeofence] = '" + IsGeofence + "'"); if (db.Query_DataReader() && db.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
public bool GetData(string whereClause) { ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO(); try { db.setQuery("SELECT top 1 * FROM [AVLJoinDevice] WHERE " + whereClause); if (db.Query_DataReader() && db.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
public bool GetData(int currentUserCode) { ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO(); try { db.setQuery("SELECT * FROM [AVLSubUserObjects] WHERE AND [userCode]=" + currentUserCode); if (db.Query_DataReader() && db.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
public static Int64 GetCash(int userCode) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 paid from AVLCash where userCode=" + userCode); DB.Query_DataReader(); if (DB.DataReader.Read()) { Int64 t = Convert.ToInt64(DB.DataReader[0]); return(t); } return(0); } finally { DB.Dispose(); } }
public bool PerformGetData(string query) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery(query); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(string pCode) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 * from avlsite_com_1.dbo.TransactionCars where CarID=" + pCode); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetDataByFactorCode(int FactorCode) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 * from AVLPaid where FactorCode=" + FactorCode); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(string Code) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 * from AVLDeviceModel where Code=" + Code); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(string domain) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 * from AVLResellerDomain where domain='" + domain + "'"); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(string where) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select * from AVLPurchasePlan where " + where); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(string pCode) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { // Need to use a faster query. Prefered using row_number(). DB.setQuery("select top 1 * from AVLGeofenceData where Code=" + pCode); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
/// <summary> /// Returns latest gateaway invoice inserted. /// </summary> /// <returns></returns> public static JAVLPaid GetLatestGateawayInvoice(int userCode) { JAVLPaid paid = new JAVLPaid(); ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 * from AVLPaid where invoiceNumber='g' AND State=0 AND type='G' AND userCode=" + userCode + " AND documentDateTime BETWEEN '" + DateTime.Now.AddMinutes(-15) + "' AND '" + DateTime.Now.ToString() + "'"); DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(paid, DB.DataReader); } return(paid); } finally { DB.Dispose(); } }
public bool GetData(int PCode) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select * from AUTBazRasService where code=" + PCode); if (DB.Query_DataReader()) { if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } } } finally { DB.Dispose(); } return(false); }
public bool GetData(string code, string pCode) { ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO(); try { db.setQuery("SELECT * FROM [AVLArea] WHERE [code] = " + code + " AND [personCode]=" + pCode); if (code == "0") { db.setQuery("SELECT * FROM [AVLArea] WHERE [personCode]=" + pCode); } if (db.Query_DataReader() && db.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }
public static bool Set(string KeyName, object KeyValue) { ClassLibrary.JDataBase db = new ClassLibrary.JDataBase(); try { db.setQuery("Select * from AUTSettings Where KeyName = N'" + KeyName + "'"); if (db.Query_DataReader() && db.DataReader.Read()) { db.setQuery("Update AUTSettings SET KeyValue = N'" + KeyValue + "' Where KeyName=N'" + KeyName + "'"); } else { db.setQuery("Insert into AUTSettings (KeyName, KeyValue) VALUES(N'" + KeyName + "', N'" + KeyValue + "')"); } db.DataReader.Close(); return(db.Query_Execute() >= 0 ? true : false); } finally { db.Dispose(); } }
public bool GetData(int Code, int userCode = -1) { ClassLibrary.JDataBase DB = new ClassLibrary.JDataBase(); try { DB.setQuery("select top 1 * from AccFactor where Code=" + Code + " AND userCode=" + userCode); if (userCode == -1) { DB.setQuery("select top 1 * from AccFactor where Code=" + Code); } DB.Query_DataReader(); if (DB.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, DB.DataReader); return(true); } return(false); } finally { DB.Dispose(); } }
public bool GetData(int Code = 0, string MethodName = "", string TableName = "", int DeviceModelCode = 0) { ClassLibrary.JDataBase db = ClassLibrary.JGlobal.MainFrame.GetDBO(); try { string query = "SELECT * FROM [AVLDataKeeper] WHERE 1=1 "; if (Code != 0) { query += " AND Code=" + Code; } if (!string.IsNullOrEmpty(MethodName)) { query += " AND ExtractorMethod=" + MethodName; } if (!string.IsNullOrEmpty(TableName)) { query += " AND TableName=" + TableName; } if (DeviceModelCode != 0) { query += " AND DeviceModelCode=" + DeviceModelCode; } db.setQuery(query); if (db.Query_DataReader() && db.DataReader.Read()) { ClassLibrary.JTable.SetToClassProperty(this, db.DataReader); return(true); } return(false); } finally { db.Dispose(); } }