/// <summary>
/// 校验机构配置
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static ReturnMessage ckeckJG(XtJgbModel model)
{
ReturnMessage Message = new ReturnMessage();
if (model == null)
{
Message.state = "401";
Message.message = "未查到机构";
Message.result = "";
LogApiHelper.AddErrorLog("getToke-预约下单成功,医院失败，未查到机构");
return(Message);
}
//没有过期则直接返回
if (string.IsNullOrEmpty(model.jgjkurl) || string.IsNullOrEmpty(model.account) || string.IsNullOrEmpty(model.pwd))
{
Message.state = "402";
Message.message = "请检查机构接口配置表";
Message.result = "";
LogApiHelper.AddErrorLog("getToke-预约下单成功,医院失败，请检查机构接口配置表");
return(Message);
}
Message.state = "200";
Message.message = "";
Message.result = "";
return(Message);
}
/// <summary>
/// 更新机构
/// </summary>
/// <param name="model"></param>
public int UpdateJg(XtJgbModel model)
{
using (IDbConnection conn = new DapperConnection().DbConnection)
{
string sql = "update xt_jgb set jgmc=@jgmc,jgdz=@jgdz,csbh=@csbh,dj=@dj,bw=@bw,lxr=@lxr,lxdh=@lxdh,zyfs=@zyfs,jgxz=@jgxz,yydj=@yydj,sfqy=@sfqy,yyimage=@yyimage,yylogoimage=@yylogoimage,yyjs=@yyjs where id=@id";
return(conn.Execute(sql, model));
}
}
/// <summary>
/// 获取机构
/// </summary>
/// <returns></returns>
public XtJgbModel GetJg(string yybh)
{
using (IDbConnection conn = new DapperConnection().DbConnection)
{
string sql = @"
select a.*,b.jgjkurl,b.account,b.pwd,b.iskkservice, d.SFBH
from xt_jgb a
join xt_jgjk b on a.yybh=b.yybh
inner join XT_CSLB c on c.CSBH=a.csbh
inner join XT_SFB d on d.SFBH=c.SFID where a.yybh=@yybh";
XtJgbModel model = conn.Query <XtJgbModel>(sql, new { yybh = yybh }).FirstOrDefault();
return(model);
}
}
/// <summary>
/// 个人套餐同步南医三院
/// </summary>
/// <param name="jgModel"></param>
/// <param name="dwbh"></param>
/// <param name="msg"></param>
/// <returns></returns>
public static bool GrTcTb_nysy(XtJgbModel jgModel, int qdbh, ref string msg)
{
try
{
ReturnMessage Message = new ReturnMessage();
//获取南医三院的套餐列表
returnData TCModelList = GetClusInfo();
if (TCModelList != null)
{
//套餐
List <XttcbModel> TClList = new List <XttcbModel>();
//套餐下组合项目关联
List <XttczhxmbModel> TCGLlList = new List <XttczhxmbModel>();
//套餐下组合项目
List <XttczhxmbmxModel> TCZHXMlList = new List <XttczhxmbmxModel>();
foreach (_clusInfos itemTC in TCModelList.clusInfos)
{
XttcbModel TCModel = new XttcbModel();
TCModel.yybh = jgModel.yybh;
TCModel.tcbh = string.IsNullOrEmpty(itemTC.clus_code) ? "" : itemTC.clus_code.Trim();
TCModel.tcmc = string.IsNullOrEmpty(itemTC.clus_name) ? "" : itemTC.clus_name.Trim();
TCModel.dwbh = "0";
TCModel.dwmc = "南医三院个人套餐";
TCModel.tclx = 2;
TCModel.jg = itemTC.price;
TCModel.sfqy = 1;
TCModel.createtime = DateTime.Now;
TCModel.xb = getNysySEX(itemTC.sex);
TCModel.dsfbzid = qdbh;
TClList.Add(TCModel);
string tcbh = TCModel.tcbh;
decimal OrderMaterialsFee = 0;
string zhxmbhList = "";
foreach (_itemInfos itemZHXM in itemTC.itemInfos)//组合项目
{
string zhxmbh = string.IsNullOrEmpty(itemZHXM.comb_code) ? "" : itemZHXM.comb_code.Trim();
zhxmbhList += zhxmbh + ";";
//去重
List <XttczhxmbmxModel> TCZHXMlCheck = TCZHXMlList.Where(p => p.zhxmbh == zhxmbh).ToList();
if (TCZHXMlCheck.Count == 0)
{
XttczhxmbmxModel TCZHXMModel = new XttczhxmbmxModel();
TCZHXMModel.createtime = DateTime.Now;
TCZHXMModel.sffk = 0;
TCZHXMModel.sfqy = 1;
TCZHXMModel.updatetime = DateTime.Now;
TCZHXMModel.xb = getNysySEX(itemTC.sex);
TCZHXMModel.yybh = jgModel.yybh;
TCZHXMModel.zhxmbh = zhxmbh;
TCZHXMModel.zhxmjg = itemZHXM.price;
//TCZHXMModel.zhxmksbh = "";
//TCZHXMModel.zhxmksmc = "";
TCZHXMModel.zhxmmc = itemZHXM.comb_name;
TCZHXMModel.zhxmms = itemZHXM.note;
TCZHXMlList.Add(TCZHXMModel);
}
//去重
List <XttczhxmbModel> TCGLCheck = TCGLlList.Where(p => p.zhxmbh == zhxmbh & p.tcbh == tcbh).ToList();
if (TCGLCheck.Count == 0)
{
XttczhxmbModel TCGLModel = new XttczhxmbModel();
TCGLModel.yybh = jgModel.yybh;
TCGLModel.dwbh = "0";
TCGLModel.zhxmbh = zhxmbh;
TCGLModel.tcbh = tcbh;
TCGLModel.createtime = DateTime.Now;
TCGLlList.Add(TCGLModel);
}
OrderMaterialsFee = 0;
}
if (!string.IsNullOrEmpty(zhxmbhList))//同步耗材信息
{
OrderMaterialsFee = GetOrderMaterialsFee(zhxmbhList, out Message);
if (Message.state != "200")
{
msg = Message.message;
return(false);
}
if (OrderMaterialsFee != 0)
{
XttczhxmbmxModel TCZHXMModel1 = new XttczhxmbmxModel();
TCZHXMModel1.createtime = DateTime.Now;
TCZHXMModel1.sffk = 0;
TCZHXMModel1.sfqy = 1;
TCZHXMModel1.updatetime = DateTime.Now;
TCZHXMModel1.xb = getNysySEX(itemTC.sex);
TCZHXMModel1.yybh = jgModel.yybh;
TCZHXMModel1.zhxmbh = tcbh + "_HC";
TCZHXMModel1.zhxmjg = OrderMaterialsFee.ToString();
TCZHXMModel1.zhxmmc = TCModel.tcmc + "_耗材费";
TCZHXMModel1.zhxmms = "耗材费";
TCZHXMlList.Add(TCZHXMModel1);
}
if (OrderMaterialsFee != 0)
{
XttczhxmbModel TCGLModel1 = new XttczhxmbModel();
TCGLModel1.yybh = jgModel.yybh;
TCGLModel1.dwbh = "0";
TCGLModel1.zhxmbh = tcbh + "_HC";
TCGLModel1.tcbh = tcbh;
TCGLModel1.createtime = DateTime.Now;
TCGLlList.Add(TCGLModel1);
}
}
TCModel.jg = TCModel.jg + OrderMaterialsFee;
}
new XttcbService().InsertOrUpdate(TClList, TCGLlList, TCZHXMlList);
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
msg = ex.Message;
return(false);
}
}
/// <summary>
/// 静态构造函数
/// </summary>
static NfykdxService()
{
model = new XtjgbService().GetJg(nfykdxYYBH);
}
public JsonResult SaveData(XtJgbModel model)
{
new XtjgbService().UpdateJg(model);
return(Json(new { Code = 200, Msg = "更新成功." }));
}
