public override void ProcessMessage()
{
var fygl = InObject.XIANGMUGL;
var srmlx = InObject.SHURUMLX;
var srm = InObject.SHURUM;
#region sql查询
var listypxx = DBVisitor.ExecuteModels(SqlLoad.GetFormat(SQ.BASE00006, fygl, srmlx, srm));
if (listypxx.Count == 0)
{
throw new Exception(string.Format("无药品信息！"));
}
else
{
OutObject = new ZD_YAOPINXX_OUT();
foreach (var ypxx in listypxx)
{
var yaopinlb = new YAOPINXX();
yaopinlb.XIANGMUGL = ypxx.Get("XIANGMUGL").ToString();
yaopinlb.XIANGMUXH = ypxx.Get("XIANGMUXH").ToString();
yaopinlb.XIANGMUCDDM = ypxx.Get("XIANGMUCDDM").ToString();
yaopinlb.XIANGMUMC = ypxx.Get("XIANGMUMC");
yaopinlb.XIANGMUGLMC = ypxx.Get("XIANGMUGLMC");
yaopinlb.XIANGMUGG = ypxx.Get("XIANGMUGG");
yaopinlb.XIANGMUJX = ypxx.Get("XIANGMUJX").ToString();
yaopinlb.XIANGMUDW = ypxx.Get("XIANGMUDW");
yaopinlb.XIANGMUCDMC = ypxx.Get("XIANGMUCDMC");
yaopinlb.DANJIA = ypxx.Get("DANJIA").ToString();
yaopinlb.YIBAODJ = ypxx.Get("YIBAODJ");
OutObject.YAOPINMX.Add(yaopinlb);
}
}
#endregion
}
public override void ProcessMessage()
{
this.OutObject = new ZD_YAOPINXX_OUT();
string xiangmuGl = InObject.XIANGMUGL;
string shurumaLx = InObject.SHURUMLX;
string shuruMa = InObject.SHURUM;
string MenZhenZYQY = InObject.MENZHENZYQY;
string fenYuanDM = InObject.BASEINFO.FENYUANDM;//分院代码
if (string.IsNullOrEmpty(xiangmuGl))
{
xiangmuGl = "0";
}
if (string.IsNullOrEmpty(MenZhenZYQY))
{
MenZhenZYQY = "0";
}
if (string.IsNullOrEmpty(fenYuanDM) || fenYuanDM == "0")
{
fenYuanDM = "1";
}
StringBuilder sbSql = new StringBuilder("select * from v_yaopinxx_cx where 1=1 ");
if (xiangmuGl != "0")
{
sbSql.Append(" and yaopinlx='" + xiangmuGl + "' ");
}
if (!string.IsNullOrEmpty(shuruMa))
{
sbSql.Append(" and shuruma1 like '" + shuruMa + "%' ");
}
if (MenZhenZYQY == "1")
{
sbSql.Append(" and menzhenqybz = 1 ");
}
if (MenZhenZYQY == "2")
{
sbSql.Append(" and zhuyuanqybz = 1 ");
}
sbSql.Append(" order by XIANGMUGL,XIANGMUMC ");
DataTable dtYaoPinXX = DBVisitor.ExecuteTable(sbSql.ToString());
if (dtYaoPinXX.Rows.Count > 0)
{
for (int i = 0; i < dtYaoPinXX.Rows.Count; i++)
{
YAOPINXX ypxx = new YAOPINXX();
ypxx.XIANGMUGL = dtYaoPinXX.Rows[i]["XIANGMUGL"].ToString(); //项目归类
ypxx.XIANGMUXH = dtYaoPinXX.Rows[i]["XIANGMUXH"].ToString(); //项目序号
ypxx.XIANGMUCDDM = dtYaoPinXX.Rows[i]["XIANGMUCDDM"].ToString(); //项目产地代码
ypxx.XIANGMUMC = dtYaoPinXX.Rows[i]["XIANGMUMC"].ToString(); //项目名称
ypxx.XIANGMUGLMC = dtYaoPinXX.Rows[i]["XIANGMUGLMC"].ToString(); //项目归类吗名称
ypxx.XIANGMUGG = dtYaoPinXX.Rows[i]["XIANGMUGG"].ToString(); //项目规格
ypxx.XIANGMUJX = dtYaoPinXX.Rows[i]["XIANGMUJX"].ToString(); //项目剂型
ypxx.XIANGMUDW = dtYaoPinXX.Rows[i]["XIANGMUDW"].ToString(); //项目单位
ypxx.XIANGMUCDMC = dtYaoPinXX.Rows[i]["XIANGMUCDMC"].ToString(); //项目产地名称
ypxx.DANJIA = Convert.ToDecimal(dtYaoPinXX.Rows[i]["danjia" + fenYuanDM].ToString()).ToString("0.00"); //单价
ypxx.YIBAODJ = dtYaoPinXX.Rows[i]["yibaodj"].ToString(); //医保等级
ypxx.MENZHENQY = dtYaoPinXX.Rows[i]["menzhenqybz"].ToString(); //门诊启用
ypxx.ZHUYUANQY = dtYaoPinXX.Rows[i]["zhuyuanqybz"].ToString(); //住院启用
OutObject.YAOPINMX.Add(ypxx);
}
}
else
{
throw new Exception("未找到相关的药品信息");
}
}
