/// <summary>
/// 设置应用程序图标
/// </summary>
/// <param name="frm"></param>
public void SetApplicationIco(Form frm)
{
frm.Icon = CommonFunctions.ApplicationIcon();
}
/// <summary>
///
/// </summary>
private void QueryResult()
{
string SQLString = string.Empty;
SQLString = string.Format(@"SELECT center_id ,
hosp_code ,
( SELECT Value
FROM HIS_InterfaceHN.dbo.JC_TypeCompareTable
WHERE TypeID = 4
AND Name = HIS_InterfaceHN.dbo.Interface_AddMatch.match_type
) AS 'match_type' ,
hosp_code ,
hosp_name
FROM HIS_InterfaceHN.dbo.Interface_AddMatch
WHERE HIS_InterfaceHN.dbo.Interface_AddMatch.ID = {0};
SELECT HIS_InterfaceHN.dbo.JC_Interface_CenterDir.ID ,
HIS_InterfaceHN.dbo.JC_Interface_CenterDir.medi_item_type ,
HIS_InterfaceHN.dbo.JC_Interface_CenterDir.item_code ,
HIS_InterfaceHN.dbo.JC_Interface_CenterDir.item_name ,
HIS_InterfaceHN.dbo.JC_Interface_CenterDir.modelID ,
( SELECT Name
FROM HIS_InterfaceHN.dbo.JC_Model
WHERE Code = HIS_InterfaceHN.dbo.JC_Interface_CenterDir.modelID
) AS 'model' ,
HIS_InterfaceHN.dbo.JC_Interface_CenterDir.price
FROM HIS_InterfaceHN.dbo.Interface_AddMatch
LEFT OUTER JOIN HIS_InterfaceHN.dbo.JC_Interface_CenterDir ON HIS_InterfaceHN.dbo.Interface_AddMatch.hosp_name = HIS_InterfaceHN.dbo.JC_Interface_CenterDir.item_name
WHERE ( HIS_InterfaceHN.dbo.Interface_AddMatch.ID = {0} )
ORDER BY HIS_InterfaceHN.dbo.Interface_AddMatch.price;", this._AddMatchID);
try
{
DataSet ds = Alif.DBUtility.DbHelperSQL.Query(SQLString);
this.lblCenterID.Text = string.Format("中心编码：{0}", ds.Tables[0].Rows[0]["center_id"].ToString().Trim());
this.lblHospitalID.Text = string.Format("医院编码：{0}", ds.Tables[0].Rows[0]["hosp_code"].ToString().Trim());
this.lblMatchType.Text = string.Format("匹配类型：{0}", ds.Tables[0].Rows[0]["match_type"].ToString().Trim());
this.lblHosp_code.Text = string.Format("医院目录编码：{0}", ds.Tables[0].Rows[0]["hosp_code"].ToString().Trim());
this.lblHosp_name.Text = string.Format("医院目录名称：{0}", ds.Tables[0].Rows[0]["hosp_name"].ToString().Trim());
this.c1FlexGridSelectDirCompare.DataSource = ds.Tables[1];
this.c1FlexGridSelectDirCompare.Cols["ID"].Visible = false;
this.c1FlexGridSelectDirCompare.Cols["modelID"].Visible = false;
if (!this.c1FlexGridSelectDirCompare.Cols.Contains("model"))
{
this.c1FlexGridSelectDirCompare.Cols["item_code"].Caption = "中心项目编码";
this.c1FlexGridSelectDirCompare.Cols["item_code"].Width = 110;
this.c1FlexGridSelectDirCompare.Cols["item_name"].Caption = "中心项目名称";
this.c1FlexGridSelectDirCompare.Cols["item_name"].Width = 270;
}
else
{
this.c1FlexGridSelectDirCompare.Cols["item_code"].Caption = "中心药品编码";
this.c1FlexGridSelectDirCompare.Cols["item_code"].Width = 110;
this.c1FlexGridSelectDirCompare.Cols["item_name"].Caption = "中心药品名称";
this.c1FlexGridSelectDirCompare.Cols["item_name"].Width = 160;
this.c1FlexGridSelectDirCompare.Cols["model"].Caption = "剂型";
this.c1FlexGridSelectDirCompare.Cols["model"].Width = 110;
}
this.c1FlexGridSelectDirCompare.Cols["price"].Caption = "价格";
this.c1FlexGridSelectDirCompare.Cols["price"].Width = 80;
this.c1FlexGridSelectDirCompare.Cols["medi_item_type"].Caption = "匹配类型";
this.c1FlexGridSelectDirCompare.Cols["medi_item_type"].Width = 60;
}
catch (Exception ex)
{
CommonFunctions.MsgError("查询医院目录编号对应的信息发生错误，错误原因：" + ex.Message);
}
}
