本文整理汇总了C#中CacheCommand类的典型用法代码示例。如果您正苦于以下问题：C#CacheCommand类的具体用法？C#CacheCommand怎么用？C#CacheCommand使用的例子？这里精选的类代码示例或许可以为您提供帮助。
示例1:GetLabTestDetails
//GetLabTestDetails获取患者某次化验的所有详细信息ZC2014-12-2
//CSQ2015-06-25
publicstaticDataTableGetLabTestDetails(DataConnectionpclsCache,stringUserId,stringVisitId,stringSortNo)
{
DataTablelist=newDataTable();
list.Columns.Add(newDataColumn("Code",typeof(string)));
list.Columns.Add(newDataColumn("Name",typeof(string)));
list.Columns.Add(newDataColumn("Value",typeof(string)));
list.Columns.Add(newDataColumn("IsAbnormalCode",typeof(int)));
list.Columns.Add(newDataColumn("IsAbnormal",typeof(string)));
list.Columns.Add(newDataColumn("UnitCode",typeof(string)));
list.Columns.Add(newDataColumn("Unit",typeof(string)));
list.Columns.Add(newDataColumn("Creator",typeof(string)));
CacheCommandcmd=null;
CacheDataReadercdr=null;
try
{
if(!pclsCache.Connect())
{
returnnull;
}
cmd=newCacheCommand();
cmd=Ps.LabTestDetails.GetLabTestDetails(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId",CacheDbType.NVarChar).Value=UserId;
cmd.Parameters.Add("VisitId",CacheDbType.NVarChar).Value=VisitId;
cmd.Parameters.Add("SortNo",CacheDbType.NVarChar).Value=SortNo;
//cmd.Parameters.Add("ItemCode",CacheDbType.NVarChar).Value=ItemCode;
cdr=cmd.ExecuteReader();
while(cdr.Read())
{
list.Rows.Add(cdr["Code"].ToString(),cdr["Name"].ToString(),cdr["Value"].ToString(),
Convert.ToInt32(cdr["IsAbnormalCode"].ToString()),cdr["IsAbnormal"].ToString(),
cdr["UnitCode"].ToString(),cdr["Unit"].ToString(),cdr["Creator"].ToString());
}
returnlist;
}
catch(Exceptionex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog,"PsLabTestDetails.GetLabTestDetails","
数据库操作异常！errorinformation:"+ex.Message+Environment.NewLine+ex.StackTrace);
returnnull;
}
finally
{
if((cdr!=null))
{
cdr.Close();
cdr.Dispose(true);
cdr=null;
}
if((cmd!=null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd=null;
}
pclsCache.DisConnect();
}
}
原文链接：
http://www.jxszl.com/biancheng/C/556630.html
