CacheConnection GetConnection(bool firstCall = true)
{
try
{
if (CacheConnect == null)
{
string connStr = ConfigurationManager.ConnectionStrings["CacheDB"].ConnectionString;
CacheConnect = new CacheConnection();
CacheConnect.ConnectionString = connStr;
}
if (CacheConnect.State == System.Data.ConnectionState.Closed)
{
CacheConnect.Open();
}
}
catch (CacheInternalException e)
{
if (firstCall)
{
Thread.Sleep(30);
GetConnection(false);
}
}
return(CacheConnect);
}
public void WorklistDataItem_OpenId_ShouldReturnAnInstanceOfWorklistDataItem()
{
var cacheConnect = new CacheConnection();
cacheConnect.ConnectionString = "Server=Cache3; Namespace = RMH; Password = PASSWORD01; User ID = GAOG;";
cacheConnect.Open();
GGTestProduct product = null;
try
{
product = GGTestProduct.OpenId(cacheConnect, "1");
}
catch (Exception e)
{
Assert.Fail(e.Message);
}
finally
{
if (product != null)
{
Assert.AreEqual("Test Product 1", product.Name, "product name does not matched");
Assert.AreEqual("Test", product.Category.ToString(), "product category does not matched");
product.Close();
}
else
{
Assert.Inconclusive("Test data does not exist");
}
cacheConnect.Close();
}
}
//数据库连接 ZAM 2015-5-22
public bool Connect()
{
bool ret = false;
try
{
DataConnection.count++;
CacheConnectionObject.Open();
/*#region<"CachePool Monitor">
* // CachePool Monitor ZAM 2015-5-22
* int activeCount = CachePoolManager.ActiveConnectionCount;
* int idleCount = CachePoolManager.IdleCount(CacheConnectionObject);
* int inUseCount = CachePoolManager.InUseCount(CacheConnectionObject);
*
* HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Service: " + this.serviceID + " DCount: " + DataConnection.count + " CID: " + ConnectID + " State: " + CacheConnectionObject.State.ToString() + " ID: " + CacheConnectionObject.CacheJobID, "");
* HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Active " + activeCount + " idle: " + idleCount + " inUse:" + inUseCount + " ", "");
*
#endregion*/
ret = true;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "", "数据库连接失败！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
throw ex;
}
return(ret);
}
public static List <QuestionAnswer> GetQuestionAnswer(string OEORI_RowId)
{
List <QuestionAnswer> listQuestionAnswer = new List <QuestionAnswer>();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(QueryString.GetQuesAns(OEORI_RowId), con))
{
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
QuestionAnswer qa = new QuestionAnswer();
string item = reader["QUES_Code"].ToString();
string[] items = item.Split('_');
qa.OrdItemType = items.Length > 1 ? items[1].ToString() : "";
qa.QUES = items.Length > 2 ? items[2].ToString() : "";
qa.QUES_Desc = reader["QUES_Desc"].ToString();
qa.QA_Answer = reader["QA_Answer"].ToString();
listQuestionAnswer.Add(qa);
}
}
}
}
return(listQuestionAnswer);
}
public static Patient GetPatient(string epiRowId)
{
Patient pt = new Patient();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(QueryString.GetPatient(epiRowId), con))
{
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
string hn = reader["PAPMI_No"].ToString();
pt.HN = hn;
pt.Name = string.IsNullOrEmpty(reader["TTL_Desc"].ToString()) ? reader["PAPMI_Name"].ToString() + " " + reader["PAPMI_Name2"].ToString() : reader["TTL_Desc"].ToString() + reader["PAPMI_Name"].ToString() + " " + reader["PAPMI_Name2"].ToString();
pt.Gender = reader["CTSEX_Desc"].ToString();
DateTime dt = Convert.ToDateTime(reader["PAPMI_DOB"].ToString());
pt.DOB = dt.ToString("dd/MM/") + dt.Year.ToString();
pt.EpisodeNo = reader["PAADM_ADMNo"].ToString();
pt.Age = reader["PAPER_AgeYr"].ToString();
pt.Allergys = _ICPOERepository.GetAllergys(hn);
}
}
}
}
return(pt);
}
public static DataTable DTBindProcedure(string procedureName, string conString, Dictionary <string, object> para)
{
dt = new DataTable();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(procedureName, con))
{
cmd.CommandType = CommandType.StoredProcedure;
foreach (KeyValuePair <string, object> kvp in para)
{
cmd.Parameters.Add(kvp.Key, kvp.Value);
}
if (para != null)
{
using (CacheDataReader dr = cmd.ExecuteReader())
{
dt.Load(dr);
return(dt);
}
}
}
}
return(dt);
}
/// <summary>
/// Returns the ADO.NET IDbCommand for this database.
/// </summary>
/// <param name="connectionString">Database connection string</param>
/// <returns></returns>
public override IDbConnection CreateNewDbConnection(string connectionString)
{
var con = new CacheConnection(connectionString);
con.Open();
con.SetQueryRuntimeMode(InterSystems.Data.CacheTypes.QueryRuntimeMode.LOGICAL);
return(con);
}
private CacheConnection BuildConnection(DbContext context)
{
var connection = new CacheConnection();
connection.ConnectionString = context.Database.Connection.ConnectionString;
connection.Open();
return(connection);
}
static void Main(string[] args)
{
CacheConnection CacheConnect = new CacheConnection();
CacheConnect.ConnectionString = "Server=192.168.1.10;Port=5641;User=_SYSTEM;Password=SYS;Namespace=company2;Pooling=false;";
CacheConnect.Open();
//Lock Query List Example
Console.WriteLine("Lock Query List Example");
CacheDataAdapter cadpt = new CacheDataAdapter();
DataSet ds = new DataSet();
CacheCommand cmdCache = new CacheCommand("%SYS.LockQuery_List", CacheConnect);
cmdCache.CommandType = CommandType.StoredProcedure;
cadpt.SelectCommand = cmdCache;
cadpt.Fill(ds, "Locks");
bool locked = false;
int id = 13395;
string table = "Invoice";
foreach (DataRow row in ds.Tables["Locks"].Rows) //loop through locks
{
Console.WriteLine(row["LockString"]);
if (row["LockString"].Equals("^oo" + table + "D(" + id + ")")) //depends on class storage definition data location
{
locked = true;
break;
}
}
if (locked)
{
Console.WriteLine("Record is locked");
}
else
{
Console.WriteLine("Record is unlocked");
}
Console.WriteLine();
//Process Query Example
Console.WriteLine("Process Query Example");
CacheCommand cmdCache2 = new CacheCommand("%SYS.ProcessQuery_CONTROLPANEL", CacheConnect);
cmdCache2.CommandType = CommandType.StoredProcedure;
CacheParameter JNparam = new CacheParameter("JobNumber", CacheDbType.Int);
JNparam.Value = 1;
cmdCache2.Parameters.Add(JNparam);
cadpt.SelectCommand = cmdCache2;
cadpt.Fill(ds, "Processes");
foreach (DataRow row in ds.Tables["Processes"].Rows) //loop through processes
{
Console.WriteLine("Job Number: " + row["Job#"] + ", Namespace: " + row["Nspace"]);
}
}
public static List <QAModel> GetQAModel(string OEORI_RowId)
{
List <QAModel> results = new List <QAModel>();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var cmd = new CacheCommand(QueryString.GetQuesAns(OEORI_RowId), con))
{
using (var reader = cmd.ExecuteReader())
{
string type = string.Empty;
while (reader.Read())
{
QAModel qam = new QAModel();
string[] spilts = reader["QUES_Code"].ToString().Split('_');
if (Regex.IsMatch(reader["QUES_Desc"].ToString(), @"<[^>]*>"))
{
type = spilts.Length > 2 ? spilts[2] : "";
qam.QUES_Code = reader["QUES_Code"].ToString();
qam.QUES_Desc = reader["QUES_Desc"].ToString();
qam.QA_Answer = reader["QA_Answer"].ToString();
qam.QUES_ControlType = reader["QUES_ControlType"].ToString();
qam.QUES_Type = type;
results.Add(qam);
}
else
{
if (!string.IsNullOrEmpty(reader["QA_Answer"].ToString()))
{
qam.QUES_Code = reader["QUES_Code"].ToString();
qam.QUES_Desc = reader["QUES_Desc"].ToString();
qam.QA_Answer = reader["QA_Answer"].ToString();
qam.QUES_ControlType = reader["QUES_ControlType"].ToString();
qam.QUES_Type = type;
results.Add(qam);
}
}
}
}
}
}
return(results);
}
public static DataTable DTBindDataCommand(string cmdString, string conString)
{
DataTable dt = new DataTable();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var adt = new CacheDataAdapter(cmdString, conString))
{
adt.Fill(dt);
}
}
return(dt);
}
public static DataSet DSBindDataCommand(string cmdString, string conString)
{
DataSet ds = new DataSet();
using (var con = new CacheConnection(conString))
{
con.Open();
using (var adt = new CacheDataAdapter(cmdString, con))
{
adt.Fill(ds);
}
}
return(ds);
}
public static string BindDataCommand(string cmdString, string conString)
{
string result = string.Empty;
using(var con = new CacheConnection(conString))
{
con.Open();
using(var cmd = new CacheCommand(cmdString, con))
{
result = cmd.ExecuteScalar().ToString();
}
}
return result;
}
public static string ExecuteScalarBindDataCommand(string cmdString, string connectionString)
{
string result = string.Empty;
using (var con = new CacheConnection(connectionString))
{
using (var cmd = new CacheCommand(cmdString, con))
{
con.Open();
result = Convert.ToString(cmd.ExecuteScalar());
}
}
return(result);
}
static void Main(string[] args)
{
string connString = "Server=192.168.1.10;Port=5641;User=_SYSTEM;Password=SYS;Namespace=company2;Pooling=false;";
const int ErrLogID = 354159;
Console.WriteLine("\nProgram starting.");
try
{
CacheConnection conn = new CacheConnection(connString);
conn.Open();
var locked = Lock(conn, "ErrLog", ErrLogID);
if (locked != null)
{
Console.WriteLine("Lock Successfully");
}
//Doing things
//another program
//Now another program is trying to edit the same row. I want to check if the row is locked.
CacheConnection conn2 = new CacheConnection(connString);
conn2.Open();
var startTime = DateTime.Now;
Console.WriteLine(startTime.ToString());
locked = Lock(conn2, "ErrLog", ErrLogID);
if (locked == null)
{
Console.WriteLine("The row is locked");
}
var endTime = DateTime.Now;
Console.WriteLine(endTime.ToString());
var diff = endTime.Subtract(startTime);
var res = String.Format("{0}:{1}:{2}", diff.Hours, diff.Minutes, diff.Seconds);
Console.WriteLine($"Time Spend on lock checking {res}");
}
catch (Exception ee)
{
Console.WriteLine("ERROR: " + ee.Message);
}
Console.WriteLine("Program exited.");
}
//数据库连接 ZAM 2015-5-22
public bool Connect()
{
bool ret = false;
try
{
DataConnection.count++;
CacheConnectionObject.Open();
ret = true;
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "", "数据库连接失败！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
throw ex;
}
return(ret);
}
public static Tuple <User, string> GetUser(string username, string password)
{
var model = new User();
string message = string.Empty;
var query = TrakCareQuery.GetUser(username);
using (CacheConnection con = new CacheConnection(Constants.Cache))
{
con.Open();
using (CacheCommand cmd = new CacheCommand(query.Item1, con))
{
foreach (KeyValuePair <string, string> pair in query.Item2)
{
var key = pair.Key;
cmd.AddInputParameters(new { key = pair.Value });
}
using (var reader = cmd.ExecuteReader())
{
if (reader.Read())
{
User user = new User()
{
SSUSR_Initials = reader["SSUSR_Initials"].ToString(),
SSUSR_Name = reader["SSUSR_Name"].ToString(),
SSUSR_Password = reader["SSUSR_Password"].ToString()
};
if (Helper.CheckPassword(user, password))
{
model = user;
message = "Login Success.";
}
else
{
message = "Login fail.";
}
}
}
}
}
return(new Tuple <User, string>(model, message));
}
static void Main(string[] args)
{
CacheConnection CacheConnect = new CacheConnection();
CacheConnect.ConnectionString = "Server = 192.168.1.10; "
+ "Port = 5641; " + "Namespace = COMPANY2; "
+ "Password = SYS; " + "User ID = _SYSTEM;";
CacheConnect.Open();
var startTime = DateTime.Now;
CacheConnect.DynamicMode = true;
CacheMethodSignature mtdSignature = CacheConnect.GetMtdSignature();
mtdSignature.Clear();
mtdSignature.Add(375399, false); //id
mtdSignature.Add(0, false); //exclusive lock
mtdSignature.Add(0, false); //immediate timeout
mtdSignature.SetReturnType(CacheConnect, ClientTypeId.tStatus);
CacheObject.RunClassMethod(CacheConnect, "User.Customer", "%LockId", mtdSignature);
CacheStatus status = (CacheStatus)((CacheStatusReturnValue)(mtdSignature.ReturnValue)).Value;
if (status.IsOK)
{
Console.WriteLine("Lock acquired");
Console.ReadLine();
mtdSignature.Clear();
mtdSignature.Add(1, false); //id
mtdSignature.SetReturnType(CacheConnect, ClientTypeId.tStatus);
CacheObject.RunClassMethod(CacheConnect, "Sample.Person", "%UnlockId", mtdSignature);
Console.WriteLine("Unlocked");
}
else
{
Console.WriteLine("Already Locked");
}
var endTime = DateTime.Now;
var diff = endTime.Subtract(startTime);
var res = String.Format("{0} milliseconds", diff.TotalMilliseconds);
Console.WriteLine($"Time Spend on lock checking: {res}");
CacheConnect.Close();
}
public static CacheConnection GetConnection()
{
if (_connection == null)
{
try
{
_connection = new CacheConnection();
_connection.ConnectionString = "Server=localhost; Port=1972; Namespace=USER;" +
"Password=qazwsx001; User ID=_SYSTEM;";
_connection.Open();
}
catch (Exception ex)
{
MessageBox.Show("Connection error: " + ex.Message);
}
}
return(_connection);
}
public void connect(String server, String port, String userid, String password, String nspace)
{
try
{
// Create a connection to Cache
conn = new CacheConnection();
string cacheConnectString = "Server = " + server + "; Log File=cprovider.log;Port=" + port + "; Namespace=" + nspace + "; Password = "******";User ID = " + userid + ";";
// Cache server Connection Information
conn.ConnectionString = cacheConnectString;
//Open a Connection to Cache
conn.Open();
}
catch (Exception err)
{
MessageBox.Show("ERROR: " + err.Message);
}
}
static void Main(string[] args)
{
// Create a connection to Cache
CacheConnection conn = new CacheConnection();
// Cache server Connection Information
// Set Server to your IP address and port to Cache SuperServer port, Log File is optional
conn.ConnectionString = "Server = localhost; Log File=cprovider.log;Port=1972; Namespace=Samples; Password = SYS; User ID = _SYSTEM;";
//Open a Connection to Cache
conn.Open();
CacheMethodSignature ms = new CacheMethodSignature();
ms.SetReturnType(conn, ClientTypeId.tString);
CacheObject.RunClassMethod(conn, "%SYSTEM.Version", "GetVersion", ms);
Console.Write("ReturnValue = " + ms.ReturnValue._Value);
conn.Close();
}
private void TestConnection()
{
try
{
CacheConnection cacheConnection = new CacheConnection();
cacheConnection.ConnectionString = String.Format(
"Server = {0};Port = 1972;Namespace=SAMPLES;Password={1}; User ID={2}",
ConnectionHost,
ConnectionPass,
ConnectionUser);
cacheConnection.Open();
if (cacheConnection.State == System.Data.ConnectionState.Open)
{
// ViewModelNotification = String.Format("Successfully connected to {0}!",ConnectionHost);
}
cacheConnection.Close();
}
catch (Exception ex)
{
//ViewModelNotification = ex.Message;
}
}