public static List <CardDataSourceUsage> GetUsage()
{
if (PrescripttionDbHelper != null)
{
return(PrescripttionDbHelper.GetUsage());
}
else
{
//DataTable dt = EMRCommon.GetOutChannel;
string strsql = @"SELECT ID,ChannelName,CName,EName,PYCode,WBCode,InputCode,EnumRange
FROM emrdb..BASE_Channel
WHERE HospitalID = 33 AND DeleteFlag=0 AND OutUsed='Y'
ORDER BY OrderNum" ;
DataTable dt = MidDbHelper.ExecuteDataTable(MidDbHelper.EmrHandle, strsql);
List <CardDataSourceUsage> list_Usage = new List <CardDataSourceUsage>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceUsage mUsage = new CardDataSourceUsage();
mUsage.UsageId = ConvertDataExtend.ToInt32(dt.Rows[i]["ID"], 0);
mUsage.UsageName = dt.Rows[i]["ChannelName"].ToString();
mUsage.Pym = dt.Rows[i]["PYCode"].ToString();
mUsage.Wbm = dt.Rows[i]["WBCode"].ToString();
//mUsage.Szm = dt.Rows[i]["ID"].ToString();
list_Usage.Add(mUsage);
}
return(list_Usage);
}
}
/// <summary>
/// 获取用法信息
/// </summary>
/// <returns>用法列表实体模型</returns>
public List <CardDataSourceUsage> GetUsage()
{
if (ltUsage == null || ltUsage.Count == 0)
{
ServiceResponseData retData = InvokeWcfService("OPProject.Service", "PresManageController", "GetChannelData");
List <Basic_Channel> list = retData.GetData <List <Basic_Channel> >(0);
ltUsage = list;
}
List <CardDataSourceUsage> lists = new List <CardDataSourceUsage>();
foreach (Basic_Channel model in ltUsage)
{
CardDataSourceUsage myUsage = new CardDataSourceUsage();
myUsage.UsageName = model.ChannelName;
myUsage.UsageId = model.ID;
myUsage.Pym = model.PYCode;
myUsage.Wbm = model.WBCode;
lists.Add(myUsage);
}
return(lists);
}
public List <CardDataSourceUsage> GetUsage()
{
string strsql = @"SELECT ID,ChannelName,CName,EName,PYCode,WBCode,InputCode
FROM Clinic_Channel
WHERE DeleteFlag=0
ORDER BY OrderNum" ;
DataTable dt = oleDb.GetDataTable(strsql);
List <CardDataSourceUsage> list_Usage = new List <CardDataSourceUsage>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CardDataSourceUsage mUsage = new CardDataSourceUsage();
mUsage.UsageId = ConvertDataExtend.ToInt32(dt.Rows[i]["ID"], 0);
mUsage.UsageName = dt.Rows[i]["ChannelName"].ToString();
mUsage.Pym = dt.Rows[i]["PYCode"].ToString();
mUsage.Wbm = dt.Rows[i]["WBCode"].ToString();
//mUsage.Szm = dt.Rows[i]["ID"].ToString();
list_Usage.Add(mUsage);
}
return(list_Usage);
}
/// <summary>
/// 医嘱控件数据集获取
/// </summary>
/// <param name="orderCategory">医嘱类别0长嘱1临嘱</param>
/// <param name="pageNo">页号</param>
/// <param name="pageSize">页大小</param>
/// <param name="filter">过滤条件</param>
/// <returns>DataSet usagedic用法数据源 frequencydic频次数据源 entrustdic嘱托数据源 itemdrug药品项目数据源</returns>
public DataSet OrderDataInit(int orderCategory, int pageNo, int pageSize, string filter)
{
//药品项目选项卡数据源
if (dataset == null || dataset.Tables.Count == 0)
{
dataset = new DataSet();
Action <ClientRequestData> requestAction = ((ClientRequestData request) =>
{
request.AddData(orderCategory);
});
ServiceResponseData retdata = InvokeWcfService("IPProject.Service", "OrderManagerController", "OrderDataInit", requestAction);
alldtItemDrug = retdata.GetData <DataTable>(0);
//用法数据源
List <Basic_Channel> list = retdata.GetData <List <Basic_Channel> >(1);
List <CardDataSourceUsage> lists = new List <CardDataSourceUsage>();
foreach (Basic_Channel entrust in list)
{
CardDataSourceUsage myEnturst = new CardDataSourceUsage();
myEnturst.UsageName = entrust.ChannelName;
myEnturst.UsageId = entrust.ID;
myEnturst.Pym = entrust.PYCode;
myEnturst.Wbm = entrust.WBCode;
lists.Add(myEnturst);
}
DataTable dtUsage = EFWCoreLib.CoreFrame.Common.ConvertExtend.ToDataTable(lists);
dtUsage.TableName = "usagedic";
dataset.Tables.Add(dtUsage);
//频次数据源
List <Basic_Frequency> listF = retdata.GetData <List <Basic_Frequency> >(2);
List <CardDataSourceFrequency> listFs = new List <CardDataSourceFrequency>();
foreach (Basic_Frequency entrust in listF)
{
CardDataSourceFrequency myEnturst = new CardDataSourceFrequency();
myEnturst.Name = entrust.FrequencyName;
myEnturst.FrequencyId = entrust.FrequencyID;
myEnturst.Pym = entrust.PYCode;
myEnturst.Wbm = entrust.WBCode;
myEnturst.ExecNum = 2;
listFs.Add(myEnturst);
}
DataTable dtFrequency = EFWCoreLib.CoreFrame.Common.ConvertExtend.ToDataTable(listFs);
dtFrequency.TableName = "frequencydic";
dataset.Tables.Add(dtFrequency);
//嘱托数据源
List <Basic_Entrust> listE = retdata.GetData <List <Basic_Entrust> >(3);
List <CardDataSourceEntrust> listEs = new List <CardDataSourceEntrust>();
foreach (Basic_Entrust entrust in listE)
{
CardDataSourceEntrust myEnturst = new CardDataSourceEntrust();
myEnturst.Name = entrust.EntrustName;
myEnturst.Id = entrust.EntrustID;
myEnturst.Pym = entrust.PYCode;
myEnturst.Wbm = entrust.WBCode;
listEs.Add(myEnturst);
}
DataTable dtEntrust = EFWCoreLib.CoreFrame.Common.ConvertExtend.ToDataTable(listEs);
dtEntrust.TableName = "entrustdic";
dataset.Tables.Add(dtEntrust);
}
if (orderCategory == 0)
{
//长嘱不能开中草药和材料
DataTable dtCopy = alldtItemDrug.Clone();
dtCopy.Clear();
DataRow[] rows = alldtItemDrug.Select(" statid<>102 and itemClass<>2");
foreach (DataRow dr in rows)
{
dtCopy.Rows.Add(dr.ItemArray);
}
dtCopy.TableName = "itemdrug";
if (dataset.Tables.Contains("itemdrug"))
{
dataset.Tables.Remove("itemdrug");
}
dataset.Tables.Add(dtCopy);
return(dataset);
}
else
{
alldtItemDrug.TableName = "itemdrug";
if (dataset.Tables.Contains("itemdrug"))
{
dataset.Tables.Remove("itemdrug");
}
dataset.Tables.Add(alldtItemDrug);
return(dataset);
}
}
