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();
}
}
