public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg)
{
string A = data.Sql;
msg = "";
if ("Del".Equals(A))
{
object p = dao.ExecuteScalar("select count(*) num from 用户表 where fixedflag=0 and cHosCode = '" + data.Param["choscode"] + "'");
if (p != null && int.Parse(p.ToString()) > 0)
{
throw new Exception("当前医疗机构已被使用，不能删除!");
}
object p2 = dao.ExecuteScalar("select count(*) num from sysdicthospital where parenthoscode = '" + data.Param["choscode"] + "'");
if (p2 != null && int.Parse(p2.ToString()) > 0)
{
throw new Exception("当前医疗机构还有子机构，不能删除!");
}
if (dao.ExecuteNonQuery("DELETE FROM sysdicthospital WHERE cHosCode='" + data.Param["choscode"] + "'") < 0)
{
throw new Exception("删除医疗机构失败！");
}
//msg = "删除成功完成！";
}
else if ("SaveNHFare".Equals(A)) //保存农合诊疗及药品字典
{
List <Dictionary <string, object> > mxli = ObjConvert.GetParamsByStr(StringZip.Decompress(data.Param["nhdatamx"].ToString()));
Opt NhZLData = OptContent.get("nh_FareZLDict");
Opt NhYPData = OptContent.get("nh_FareYPDict");
if (mxli == null || mxli.Count == 0)
{
throw new Exception("无农合费用字典明细！");
}
string vchoscode = data.Param["cHosCode"].ToString();
int rank = int.Parse(data.Param["rank"].ToString());
if (dao.ExecuteNonQuery("DELETE FROM 农合药品表 WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("删除农合药品数据出错！");
}
if (dao.ExecuteNonQuery("DELETE FROM 农合项目表 WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("删除农合项目数据出错！");
}
foreach (Dictionary <string, object> pa in mxli)
{
pa["rank"] = rank;
pa["cHosCode"] = vchoscode;
if (pa["农合类别"].ToString().Equals("02") || pa["农合类别"].ToString().Equals("09"))
{
if (DaoTool.Save(dao, NhYPData, pa) < 0)
{
throw new Exception("保存农合费用字典药品明细失败！");
}
}
else
{
if (pa["农合类别"].ToString().Equals("05") || pa["农合类别"].ToString().Equals("10"))
{
if (DaoTool.Save(dao, NhYPData, pa) < 0)
{
throw new Exception("保存农合费用字典药品明细失败！");
}
}
if (DaoTool.Save(dao, NhZLData, pa) < 0)
{
throw new Exception("保存农合费用字典诊疗明细失败！");
}
}
}
}
else if ("SaveICD10".Equals(A)) //保存农合疾病字典
{
List <Dictionary <string, object> > mxli = ObjConvert.GetParamsByStr(StringZip.Decompress(data.Param["icd10"].ToString()));
Opt NhicdData = OptContent.get("nh_saveICDDict");
if (mxli == null || mxli.Count == 0)
{
throw new Exception("无农合疾病字典明细！");
}
dao.ExecuteNonQuery("truncate table 农合疾病表"); //永远返回-1
foreach (Dictionary <string, object> pa in mxli)
{
if (DaoTool.Save(dao, NhicdData, pa) < 0)
{
throw new Exception("保存农合疾病字典失败！");
}
}
dao.ExecuteNonQuery("update 农合疾病表 t set t.orderid=(select ordid from jb where 编码=t.农合编码) where exists(select * from jb where 编码=t.农合编码)");
}
else if ("SaveSS".Equals(A)) //保存农合手术字典
{
List <Dictionary <string, object> > mxli = ObjConvert.GetParamsByStr(StringZip.Decompress(data.Param["SS"].ToString()));
Opt NhicdData = OptContent.get("nh_saveSSDict");
if (mxli == null || mxli.Count == 0)
{
throw new Exception("无农合手术字典明细！");
}
dao.ExecuteNonQuery("truncate table 农合手术表");
foreach (Dictionary <string, object> pa in mxli)
{
if (DaoTool.Save(dao, NhicdData, pa) < 0)
{
throw new Exception("保存农合手术字典失败！");
}
}
}
else if ("CheckNHFare".Equals(A)) //保存并进行核对农合费用项目
{
List <Dictionary <string, object> > mxli = ObjConvert.GetParamsByStr(StringZip.Decompress(data.Param["nhdatamx"].ToString()));
Opt NhZLData = OptContent.get("nh_FareZLDict");
Opt NhYPData = OptContent.get("nh_FareYPDict");
if (mxli == null || mxli.Count == 0)
{
throw new Exception("无农合费用字典明细！");
}
string vchoscode = data.Param["cHosCode"].ToString();
int rank = int.Parse(data.Param["rank"].ToString());
if (dao.ExecuteNonQuery("DELETE FROM 农合药品表BK WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("删除农合药品BK数据出错！");
}
if (dao.ExecuteNonQuery("DELETE FROM 农合项目表BK WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("删除农合项目BK数据出错！");
}
if (dao.ExecuteNonQuery("Insert into 农合药品表BK(农合编码,农合名称,农合类别,保内外,报补比例,单位,rank,updatetime,基药标志,cHosCode) " +
"Select 农合编码,农合名称,农合类别,保内外,报补比例,单位,rank,updatetime,基药标志,cHosCode from 农合药品表 WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("插入农合药品BK数据出错！");
}
if (dao.ExecuteNonQuery("Insert into 农合项目表BK(农合编码,农合名称,农合类别,保内外,报补比例,单位,rank,updatetime,基药标志,cHosCode) " +
"Select 农合编码,农合名称,农合类别,保内外,报补比例,单位,rank,updatetime,基药标志,cHosCode from 农合项目表 WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("插入农合项目BK数据出错！");
}
if (dao.ExecuteNonQuery("DELETE FROM 农合药品表 WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("删除农合药品数据出错！");
}
if (dao.ExecuteNonQuery("DELETE FROM 农合项目表 WHERE cHosCode='" + vchoscode + "' and RANK=" + rank) < 0)
{
throw new Exception("删除农合项目数据出错！");
}
foreach (Dictionary <string, object> pa in mxli)
{
pa["rank"] = rank;
pa["cHosCode"] = vchoscode;
if (pa["农合类别"].ToString().Equals("02") || pa["农合类别"].ToString().Equals("09"))
{
if (DaoTool.Save(dao, NhYPData, pa) < 0)
{
throw new Exception("保存农合费用字典药品明细失败！");
}
}
else
{
if (pa["农合类别"].ToString().Equals("05") || pa["农合类别"].ToString().Equals("10"))
{
if (DaoTool.Save(dao, NhYPData, pa) < 0)
{
throw new Exception("保存农合费用字典药品明细失败！");
}
}
if (DaoTool.Save(dao, NhZLData, pa) < 0)
{
throw new Exception("保存农合费用字典诊疗明细失败！");
}
}
}
}
else if ("getLog".Equals(A)) //生成日志数据
{
dao.ExecuteNonQuery(" begin PCK_HisCommUse.sp_SaveNHChangeFareLog('" + data.Param["cHosCode"].ToString() + "' ," + data.Param["rank"].ToString() + "); end;");
dao.ExecuteNonQuery(" begin PCK_HisCommUse.sp_CheckNHFareDict('" + data.Param["cHosCode"].ToString() + "' ," + data.Param["rank"].ToString() + "); end;");
// throw new Exception("生成农合更新日志失败！");
}
else if ("SavejmFare".Equals(A)) //保存安顺地区城镇医保费用目录
{
List <Dictionary <string, object> > mxli = ObjConvert.GetParamsByStr(StringZip.Decompress(data.Param["datamx"].ToString()));
Opt fareData = OptContent.get("jm_savefareDict");
if (mxli == null || mxli.Count == 0)
{
throw new Exception("无居保目录明细！");
}
if (dao.ExecuteNonQuery("delete 地区居保目录 where choscode='" + data.Param["cHosCode"].ToString() + "'") < 0)
{
throw new Exception("保存费用目录失败del！");
}
string bm;
foreach (Dictionary <string, object> pa in mxli)
{
bm = pa["大类编码"].ToString();
if (bm.Equals("81"))
{
pa["ypflag"] = 1;
}
else if (bm.Equals("11") || bm.Equals("12") || bm.Equals("13"))
{
pa["ypflag"] = 2;
}
else
{
pa["ypflag"] = 0;
}
pa["拼音码"] = pa["拼音码"].ToString().ToLower();
pa["choscode"] = data.Param["cHosCode"].ToString();
if (DaoTool.Save(dao, fareData, pa) < 0)
{
throw new Exception("保存居保目录明细失败！");
}
}
}
else if ("dictcopy".Equals(A)) //机构字典相互复制
{
if (dao.ExecuteNonQuery(" begin PCK_HisCommUse.sp_jgDictCopy('" +
data.Param["fromHosCode"].ToString() + "' ,'" + data.Param["toHosCode"].ToString() + "' ,'" +
data.Param["ypflag"].ToString() + "' ,'" + data.Param["nhcode"].ToString() + "'); end;") < 0)
{
if (dao.ErrMsg != null)
{
throw new Exception(dao.ErrMsg);
}
}
}
else if ("delyw".Equals(A)) //业务数据删除
{
if (dao.ExecuteNonQuery(" begin PCK_HisCommUse.sp_clearData('" + data.Param["choscode"].ToString() + "'," +
data.Param["flag"].ToString() + "); end;") < 0)
{
if (dao.ErrMsg != null)
{
throw new Exception(dao.ErrMsg);
}
}
}
else if ("delypdict".Equals(A)) //药品字典删除
{
object p = dao.ExecuteScalar("select count(*) num from 库存药品 where cHosCode = " + data.Param["choscode"].ToString());
if (p != null && int.Parse(p.ToString()) > 0)
{
throw new Exception("当前医疗还有库存药品业务数据，不能直接删除字典!");
}
if (dao.ExecuteNonQuery("delete 药品字典表 where choscode='" + data.Param["choscode"].ToString() + "'") < 0)
{
throw new Exception("药品字典删除失败！");
}
}
else if ("setFlag".Equals(A)) //设置机构提示信息
{
if (dao.ExecuteNonQuery(" update sysdicthospital set flag=" + data.Param["flag"].ToString() + ",LICENCE='" +
data.Param["info"].ToString() + "' where CHOSCODE='" + data.Param["cHosCode"].ToString() + "'") < 0)
{
if (dao.ErrMsg != null)
{
throw new Exception(dao.ErrMsg);
}
}
}
return("ok");
}
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg)
{
msg = "ok";
string A = data.Sql;
string choscode = data.Param["cHosCode"].ToString();
if ("Find".Equals(A))
{
object[] objs = new object[1];
objs[0] = dao.find("select ID,sysvalue,choscode,sysexplain from 系统参数 t where (choscode is null or choscode=?) and not exists" +
"(select * from 系统参数 where choscode=? and t.id=id and t.choscode is null)",
new object[] { choscode, choscode });
return(objs);
}
else if ("Save".Equals(A))
{
if (data.Param.ContainsKey("密码"))
{
string pwd = data.Param["密码"].ToString();
object p = dao.ExecuteScalar("select passwd from 密码 where id=3");
if (p != null)
{
if (!p.ToString().Equals(pwd))
{
throw new Exception("输入的密码无效请重新输入！");
}
}
else
{
throw new Exception("输入的密码无效请重新输入！");
}
}
string sql = "", edsql = "", insql = "";
int num = int.Parse(data.Param["num"].ToString());
for (int i = 1; i <= num; i++)
{
if (data.Param.ContainsKey("ID" + i.ToString()))
{
if (data.Param.ContainsKey("note" + i.ToString()))
{
insql = "'" + data.Param["note" + i.ToString()].ToString() + "'";
edsql = ",sysexplain=" + insql;
}
else
{
edsql = "";
insql = "''";
}
if (!data.Param.ContainsKey("TYPE" + i.ToString()))
{
if (!choscode.Equals(""))
{
sql = "UPDATE 系统参数 SET sysvalue='" + data.Param["ID" + i.ToString()].ToString() + "'" + edsql + " WHERE ID=" + i.ToString() + " and choscode='" + choscode + "'";
}
else
{
sql = "UPDATE 系统参数 SET sysvalue='" + data.Param["ID" + i.ToString()].ToString() + "' WHERE ID=" + i.ToString() + " and choscode is null ";
}
}
else
{
sql = "insert into 系统参数 values(" + i.ToString() + ",'" + data.Param["TYPE" + i.ToString()].ToString() + "','" +
data.Param["ID" + i.ToString()].ToString() + "'," + insql + ",'" + choscode + "')";
}
if (dao.ExecuteNonQuery(sql, new object[] {}) < 0)
{
throw new Exception("更新系统参数失败！");
}
}
}
}
return("ok");
}
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg)
{
string ac = data.Sql;
msg = "";
if ("EditPwd".Equals(ac))
{
DataTable dt = dao.find("select a.userpassword from 用户表 a where a.userid=? and a.choscode=? "
, new object[] { data.Param["UserId"], data.Param["cHosCode"] }
);
if (dt == null || dt.Rows.Count == 0)
{
throw new Exception("用户无效！");
}
string pd = "";
if (dt.Rows[0][0] != null)
{
pd = dt.Rows[0][0].ToString();
}
if (!data.Param["oldPwd"].ToString().Equals(pd))
{
throw new Exception("原密码错误！");
}
if (data.Param.ContainsKey("sjh"))
{
object obj1 = dao.ExecuteScalar("select count(*) from 用户表 a where a.mobilephone=?"
, new object[] { data.Param["sjh"] }
);
if (int.Parse(obj1.ToString()) > 0)
{
throw new Exception("您输入的手机号已被其他用户绑定，请重新输入！");
}
int i = dao.ExecuteNonQuery("update 用户表 set mobilephone=? where userid=? and choscode=?"
, new object[] { data.Param["sjh"], data.Param["UserId"], data.Param["cHosCode"] }
);
if (i < 0)
{
throw new Exception("帮定手机号失败！");
}
}
int b = dao.ExecuteNonQuery("update 用户表 set userpassword=? where userid=? and choscode=?"
, new object[] { data.Param["Pwd"], data.Param["UserId"], data.Param["cHosCode"] }
);
if (b < 0)
{
throw new Exception("修改用户密码失败！");
}
msg = "修改密码成功！";
}
else if ("RegCardSet".Equals(ac))
{
if (!data.Param.ContainsKey("密码"))
{
throw new Exception("输入的密码无效请重新输入！");
}
string pwd = data.Param["密码"].ToString();
object p = dao.ExecuteScalar("select passwd from 密码 where id=4");
if (p != null)
{
if (!p.ToString().Equals(pwd))
{
throw new Exception("输入的密码无效请重新输入！");
}
}
else
{
throw new Exception("输入的密码无效请重新输入！");
}
DataTable dt = dao.find("select 1 from 就诊卡范围表 where (开始号 between ? and ? or 结束号 between ? and ?) and length(开始号)=?"
, new object[] { data.Param["开始号"], data.Param["结束号"], data.Param["开始号"], data.Param["结束号"], data.Param["长度"] }
);
if (dt != null && dt.Rows.Count > 0)
{
throw new Exception("输入的就诊卡号已被领用过，请重新录入号码");
}
Opt op = OptContent.get("sys_SaveRegCard");
if (DaoTool.Save(dao, op, data) > -1)
{
msg = "保存就诊卡数据成功！";
}
else
{
throw new Exception("就诊卡领用失败");
}
}
else if ("SaveOpLog".Equals(ac))
{
if (dao.ExecuteNonQuery("insert into 特殊操作日志(choscode,chosname,操作功能,操作员,操作机器,辅助说明) values('" +
data.Param["choscode"].ToString() + "','" + data.Param["chosname"].ToString() + "'," +
data.Param["funID"].ToString() + ",'" + data.Param["username"].ToString() + "','" +
data.Param["hostinfo"].ToString() + "','" + data.Param["说明"].ToString() + "')") < 0)
{
throw new Exception("保存操作日志错误." + dao.ErrMsg);
}
else
{
msg = "ok";
}
}
return("ok");
}
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg)
{
string A = data.Sql;
if ("Del".Equals(A))
{
object p = dao.ExecuteScalar("select count(*) num from 票据领用表 where 领用序号 = " +
data.Param["serialno"].ToString() + " and 领用张数>剩余张数");
if (p != null && int.Parse(p.ToString()) > 0)
{
throw new Exception("当前领用的票据已经被使用，不能再删除!");
}
if (dao.ExecuteNonQuery("delete 票据领用表 where 领用序号=" + data.Param["serialno"].ToString()) < 0)
{
throw new Exception("领用票据删除失败！");
}
}
else if ("PDinvoice".Equals(A))
{
object p = dao.ExecuteScalar("select 领用序号 from 票据领用表 where choscode ='" +
data.Param["choscode"].ToString() + "' and 剩余张数>=1 and 票据类型=" +
data.Param["kind"].ToString() + " and length(开始票号)=" + data.Param["fpcode"].ToString().Length +
" and '" + data.Param["fpcode"].ToString() + "' between 开始票号 and 结束票号 and " +
"((使用模式=1) or (使用模式=0 and 领用人员=" + data.Param["userid"].ToString() + "))");
if (p == null || p.ToString().Equals(""))
{
throw new Exception(data.Param["fpcode"].ToString() + "票据号未领用过，不能被使用!");
}
object x = dao.ExecuteScalar("select count(*) cn from 票据使用表 where choscode ='" +
data.Param["choscode"].ToString() + "' and 票据类型=" +
data.Param["kind"].ToString() + " and 票号='" + data.Param["fpcode"].ToString() + "'");
if (x != null && int.Parse(x.ToString()) > 0)
{
throw new Exception(data.Param["fpcode"].ToString() + "票据号已经被使用过，不能重复使用!");
}
msg = "ok";
return(p.ToString());
}
else if ("SaveNewFP".Equals(A))
{
if (data.Param["kind"].ToString().Equals("1")) //门诊
{
if (dao.ExecuteNonQuery("update 门诊处方表 set 发票号=? where choscode=? and 处方号=?"
, new object[] { data.Param["newfp"], data.Param["choscode"], data.Param["code"] }) < 0)
{
throw new Exception("改写门诊处方发票号错误！");
}
}
else if (data.Param["kind"].ToString().Equals("2"))//住院
{
if (dao.ExecuteNonQuery("update 住院登记表 set 发票号=? where choscode=? and 住院号=?"
, new object[] { data.Param["newfp"], data.Param["choscode"], data.Param["code"] }) < 0)
{
throw new Exception("改写住院发票号错误！");
}
}
else //预交款票据
{
if (dao.ExecuteNonQuery("update 押金表 set 发票号=? where choscode=? and 住院号=? and 发票号=?"
, new object[] { data.Param["newfp"], data.Param["choscode"], data.Param["code"],
data.Param["oldfp"].ToString() }) < 0)
{
throw new Exception("改写预交款票号错误！");
}
}
if (dao.ExecuteNonQuery("insert into 票据使用表(领用序号,票据类型,票号,操作员,choscode,code) values(" +
data.Param["sno"].ToString() + "," + data.Param["kind"].ToString() + ",'" +
data.Param["newfp"].ToString() + "'," + data.Param["userid"].ToString() + ",'" +
data.Param["choscode"].ToString() + "','" + data.Param["code"].ToString() + "')") < 0)
{
throw new Exception("补打发票时票据使用表写入错误！");
}
if (dao.ExecuteNonQuery("update 票据使用表 set 票据状态=1 where 领用序号=" +
data.Param["sno"].ToString() + " and choscode='" + data.Param["choscode"].ToString() +
"' and 票号='" + data.Param["oldfp"].ToString() + "'") < 0)
{
throw new Exception("补打发票时更改票据使用表状态错误！");
}
if (dao.ExecuteNonQuery("insert into 作废票据表(票号,票据类型,更换新票号,操作员,choscode) values('" +
data.Param["oldfp"].ToString() + "'," + data.Param["kind"].ToString() + ",'" +
data.Param["newfp"].ToString() + "'," + data.Param["userid"].ToString() + ",'" +
data.Param["choscode"].ToString() + "')") < 0)
{
throw new Exception("作废票据写入错误！");
}
}
msg = "ok";
return("ok");
}