public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql != null && data.Sql.Equals("Del")) { int count = DaoTool.ExecuteScalar(dao, OptContent.get("XmIsSy"), data).ToInt(); if (count > 0) { throw new Exception("项目信息已经被系统使用,不能删除!"); } if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelXmInfo"), data) < 0) { throw new Exception("删除项目信息失败!"); } msg = "项目信息已删除!"; return("ok"); } else if (data.Sql != null && data.Sql.Equals("CheckNHCode")) { msg = "项目信息已删除!"; return("ok"); } else { Opt op = OptContent.get("SaveXmInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { /* if (DaoTool.ExecuteNonQuery(dao, OptContent.get("UpdateZYCFMXInfo"), data) < 0) * { * throw new Exception("更新住院处方明细失败!"); * } * if (DaoTool.ExecuteNonQuery(dao, OptContent.get("UpdateMZCFMXInfo"), data) < 0) * { * throw new Exception("更新门诊处方明细失败!"); * } */ msg = "保存项目信息成功!"; return("ok"); } else { throw new Exception("保存项目信息失败!"); } } else { data.Param[op.Key] = DaoTool.ExecuteScalar(dao, OptContent.get("XmiInfo_seq"), data).ToInt() + 1; if (DaoTool.Save(dao, op, data) > -1) { msg = "保存项目信息成功!"; return("ok"); } else { throw new Exception("保存项目信息失败!"); } } } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql == null || data.Sql == "") { msg = "没有传入有效的SQL参数,无法进行操作!"; return("ok"); } if (data.Sql.Equals("AddOrSaveEQUseManage")) { if (data.Param["USEID"] == null || data.Param["USEID"].ToString() == "") { data.Param["USEID"] = DaoTool.Seq(dao, "LKEQ.SEQEQUse"); if (DaoTool.Save(dao, OptContent.get("SaveEQCardUseInfo_UseManagEdit"), data) < 0) { msg = "执行失败!"; throw new Exception("新增设备使用记录失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } if (DaoTool.Update(dao, OptContent.get("SaveEQCardUseInfo_UseManagEdit"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备使用记录失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } else { msg = "系统出错,请与管理员联系!"; return("ok"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql.Equals("") || data.Sql == null) { msg = "SQL参数错误,无法继续进行操作!"; return("ok"); } if (data.Sql.Equals("QueRenYueJie")) { //月结的时候就是新增自动折旧【所以 折旧ID肯定为空】 data.Param["DEPREID"] = DaoTool.Seq(dao, "LKEQ.SEQEQDepre"); if (DaoTool.Save(dao, OptContent.get("SaveEQDepreciationInfo_EQDepreciation"), data) > -1) { saveRunDetail(dao, data); msg = "执行成功!"; return("ok"); } else { msg = "执行失败!"; throw new Exception("新增折旧主表信息失败!" + dao.ErrMsg); } } else { msg = "系统出错,请与管理员联系!"; return("ok"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { string A = data.Sql; msg = ""; if ("Add".Equals(A)) { if (dao.ExecuteNonQuery("insert into 特殊预交金表(类型,编码,最低预交金,choscode) values(" + data.Param["type"].ToString() + ",'" + data.Param["code"].ToString() + "'," + data.Param["deposit"].ToString() + ",'" + data.Param["choscode"].ToString() + "')") < 0) { throw new Exception(""); } } else if ("Edit".Equals(A)) { if (dao.ExecuteNonQuery("update 特殊预交金表 set 类型=?,编码=?,最低预交金=? where choscode=? and 类型=? and 编码=?", new object[] { data.Param["type"], data.Param["code"], data.Param["deposit"], data.Param["choscode"], data.Param["type"], data.Param["oldcode"] }) < 0) { throw new Exception("更改错误。"); } } else if ("Del".Equals(A)) { if (dao.ExecuteNonQuery("delete 特殊预交金表 where choscode='" + data.Param["choscode"].ToString() + "' and " + "类型=" + data.Param["type"] + " and 编码='" + data.Param["code"] + "'") < 0) { throw new Exception(""); } } return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql != null && data.Sql.Equals("Delete")) { Opt opt = OptContent.get("DeleteEQKind"); if (DaoTool.ExecuteNonQuery(dao, opt, data) < 0) { throw new Exception("删除设备类别信息失败!" + dao.ErrMsg); } msg = "设备类别已删除"; return("ok"); } if (data.Sql != null && data.Sql.Equals("Save")) { Opt opt = OptContent.get("SaveSetEQDetail"); if (DaoTool.Save(dao, opt, data) > -1) { msg = "设置管理的设备类别成功!"; return("ok"); } else { throw new Exception("设置管理的设备类别失败" + dao.ErrMsg); } } else { throw new Exception("设置管理的设备类别失败" + dao.ErrMsg); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Param.ContainsKey("dicgrpid")) { if (DaoTool.Update(dao, OptContent.get("SaveDictGrounp"), data) > 0) { msg = "更新成功!"; return("ok"); } else { throw new Exception("保存失败!"); } } else { int i = DaoTool.ExecuteScalar(dao, OptContent.get("GetMaxDictGrounpId"), data).ToInt() + 1; data.Param["dicgrpid"] = i; if (DaoTool.Save(dao, OptContent.get("SaveDictGrounp"), data) > 0) { msg = "保存成功!"; return("ok"); } else { throw new Exception("保存失败!"); } } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { string sql = "update SYSCLOBDICT set dictvalue=? where dictname=?"; int i = dao.ExecuteNonQuery(sql, new object[] { data.Param["dictvalue"], "menuinfo" }); if (i < 0) { throw new Exception("更新菜单信息失败!"); } msg = "保存成功!"; return("ok"); }
/// <summary> /// 这里均为套用前面的设备折旧的保存 /// </summary> /// <param name="dao"></param> /// <param name="data"></param> /// <returns></returns> bool saveRunDetail(YiTian.db.Dao dao, YtService.data.OptData data) { List <Dictionary <string, object> > XiList = ObjConvert.GetParamsByStr(data.Param["XmlDataList"].ToString()); Opt opt2 = OptContent.get("SaveEQDepreciationDetailInfo_EQDepreciation"); foreach (Dictionary <string, object> d in XiList) { d["CARDID"] = d["卡片ID"]; d["TOTALZJ"] = d["累计折旧"]; d["MONTHZJ"] = d["本月折旧"]; d["TOTALWORK"] = d["总工作量"]; d["TOTALEDWORK"] = d["累计工作量"]; d["MONTHWORK"] = d["本月工作量"]; d["MEMO"] = d["备注"]; d["CHOSCODE"] = data.Param["CHOSCODE"]; d["USERID"] = data.Param["USERID"]; d["USERNAME"] = data.Param["USERNAME"]; d["RECDATE"] = DateTime.Now; //全部为新增过来的折旧ID(固定一个) d["DEPREID"] = data.Param["DEPREID"]; if (DaoTool.Save(dao, opt2, d) < 0) { throw new Exception("新增折旧明细失败!" + dao.ErrMsg); } //这里对这些新增的卡片折旧进行数据更新[可能存在原本的折旧,工作量为空的情况] //if ((d["TOTALEDWORK"] != null || !d["TOTALEDWORK"].ToString().Equals("")) && (d["TOTALZJ"] != null || d["TOTALZJ"].ToString().Equals(""))) if ((!d["TOTALEDWORK"].ToString().Equals("")) && (!d["TOTALZJ"].ToString().Equals(""))) { // MessageBox.Show("1 全部不为null"); dao.ExecuteNonQuery("UPDATE LKEQ.EQCARDREC SET TOTALZJ=TOTALZJ +" + Convert.ToDouble(d["MONTHZJ"]) + " ,TOTALEDWORK=TOTALEDWORK + " + Convert.ToDouble(d["MONTHWORK"]) + " WHERE CARDID=" + d["CARDID"].ToString() + " AND CHOSCODE=" + d["CHOSCODE"].ToString()); } if ((!d["TOTALEDWORK"].ToString().Equals("")) && (d["TOTALZJ"].ToString().Equals(""))) { // MessageBox.Show("2 折旧为null"); dao.ExecuteNonQuery("UPDATE LKEQ.EQCARDREC SET TOTALZJ=" + Convert.ToDouble(d["MONTHZJ"]) + " ,TOTALEDWORK=TOTALEDWORK + " + Convert.ToDouble(d["MONTHWORK"]) + " WHERE CARDID=" + d["CARDID"].ToString() + " AND CHOSCODE=" + d["CHOSCODE"].ToString()); } if ((d["TOTALEDWORK"].ToString().Equals("")) && (!d["TOTALZJ"].ToString().Equals(""))) { // MessageBox.Show("3 工作量为null"); dao.ExecuteNonQuery("UPDATE LKEQ.EQCARDREC SET TOTALZJ=TOTALZJ +" + Convert.ToDouble(d["MONTHZJ"]) + " ,TOTALEDWORK=" + Convert.ToDouble(d["MONTHWORK"]) + " WHERE CARDID=" + d["CARDID"].ToString() + " AND CHOSCODE=" + d["CHOSCODE"].ToString()); } if ((d["TOTALEDWORK"].ToString().Equals("")) && (d["TOTALZJ"].ToString().Equals(""))) { // MessageBox.Show("4 全部为null"); dao.ExecuteNonQuery("UPDATE LKEQ.EQCARDREC SET TOTALZJ=" + Convert.ToDouble(d["MONTHZJ"]) + " ,TOTALEDWORK= " + Convert.ToDouble(d["MONTHWORK"]) + " WHERE CARDID=" + d["CARDID"].ToString() + " AND CHOSCODE=" + d["CHOSCODE"].ToString()); } } return(true); }
bool savePlanDetail(YiTian.db.Dao dao, YtService.data.OptData data) { List <Dictionary <string, object> > mxli = ObjConvert.GetParamsByStr(data.Param["DanJuMx"].ToString()); Opt opt2 = OptContent.get("SaveEQPlanDetailInfo"); foreach (Dictionary <string, object> d in mxli) { //d["DETAILNO"] = DaoTool.Seq(dao, "LKWZ.SEQWZInDetail"); d["PLANID"] = data.Param["PLANID"]; d["APPLYID"] = d["请购ID"]; d["EQID"] = d["设备ID"]; d["EQNAME"] = d["设备名称"]; d["GG"] = d["规格"]; d["XH"] = d["型号"]; d["XH"] = d["型号"]; d["COUNTRY"] = d["国别"]; d["UNITCODE"] = d["单位编码"]; d["NOWNUM"] = d["当前库存数量"]; d["NUM"] = d["采购数量"]; d["PRICE"] = d["采购单价"]; d["MONEY"] = d["采购金额"]; d["SCS"] = d["生产商"]; d["GYS"] = d["供应商"]; d["MEMO"] = d["备注"]; d["TXM"] = d["条形码"]; d["CHOSCODE"] = data.Param["CHOSCODE"]; d["STOCKFLOWNO"] = d["对应的库存流水表的流水号"]; if (!d["行号"].ToString().Equals("")) { d["ROWNO"] = d["行号"].ToString(); if (DaoTool.Update(dao, opt2, d) < 0) { throw new Exception("保存单据明细失败!"); } } else { object rw = dao.Es(OptContent.get("EQGetROWNO").Sql, new object[] { data.Param["PLANID"] }); //data.Param["ROWNO"] = Convert.ToDecimal(rw) + 1; d["ROWNO"] = Convert.ToDecimal(rw) + 1; if (DaoTool.Save(dao, opt2, d) < 0) { throw new Exception("添加单据明细失败!"); } } } return(true); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { string A = data.Sql; Opt op = OptContent.get("SaveYPGYSInfo"); if ("Del".Equals(A)) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelGhDwInfo"), data) < 0) { throw new Exception("删除供货商信息失败!"); } msg = "供货商信息已删除!"; return("ok"); } else if ("Save".Equals(A)) { if (DaoTool.ExecuteScalar(dao, OptContent.get("HaveGhDwInfo"), data).ToInt() > 0) { throw new Exception("编号为【" + data.Param["编号"].ToString() + "】的单位已经存在!"); } if (DaoTool.Save(dao, op, data) > -1) { msg = "保存成功!"; return("ok"); } else { throw new Exception("保存失败!"); } } else if ("Update".Equals(A)) { if (DaoTool.Update(dao, op, data) > -1) { msg = "保存成功!"; return("ok"); } else { throw new Exception("保存失败!"); } } msg = "ok"; return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql != null && data.Sql.Equals("Del")) { int count = DaoTool.ExecuteScalar(dao, OptContent.get("YaoPingIsSy"), data).ToInt(); if (count > 0) throw new Exception("药品已经被系统使用,不能删除!"); if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelYaoPingInfo"), data) < 0) { throw new Exception("删除药品信息失败!"); } msg = "药品已删除!"; return "ok"; } else { Opt op = OptContent.get("SaveYPDictInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { msg = "保存项目信息成功!"; return "ok"; } else { throw new Exception("保存项目信息失败!"+dao.ErrMsg); } } else { data.Param["药品编码"] = DaoTool.ExecuteScalar(dao, OptContent.get("SaveYPDictInfo_seq"), data).ToInt() + 1; if (DaoTool.Save(dao, op, data) > -1) { msg = "保存药品信息成功"; return "ok"; } else { throw new Exception("保存药品信息失败!" + dao.ErrMsg); } } } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql == null) { msg = "无效的SQL参数,无法继续执行!"; return("ok"); } if (data.Sql.Equals("ModifyOrAddInfo")) { //新增的 if (data.Param["MAINTAINID"] == null || data.Param["MAINTAINID"].ToString() == "") { data.Param["MAINTAINID"] = DaoTool.Seq(dao, "LKEQ.SEQEQMaintain"); if (DaoTool.Save(dao, OptContent.get("SaveEQMaintainInfo_EQKeepFitManag"), data) < 0) { msg = "执行失败!"; throw new Exception("新增设备保养记录失败!" + dao.ErrMsg); } msg = "新增保养记录成功!"; return("ok"); } if (DaoTool.Update(dao, OptContent.get("SaveEQMaintainInfo_EQKeepFitManag"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备保养记录失败!" + dao.ErrMsg); } msg = "修改保养记录成功!"; return("ok"); } else { msg = "系统出错,请与管理员联系!"; 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"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql == null) { msg = "缺省SQL参数,无法继续进行操作!"; return("ok"); } if (data.Sql.Equals("ModifyOrAddZhu")) { //只有当新增主表的时候才需要生成对应的recipecode if (data.Param["RECIPECODE"] == null || data.Param["RECIPECODE"].ToString() == "") { DataTable dt = DaoTool.FindDT(dao, OptContent.get("GetRecipeCodeInEQOutInfo"), data); if (dt.Rows.Count <= 0 || dt == null) { throw new Exception("无法查找到单据前缀" + dao.ErrMsg); } DataRow row = dt.Rows[0]; data.Param["RECIPECODE"] = Recipecode(row["RECIPECODE"].ToString(), Convert.ToInt32(row["RECIPEYEAR"]), Convert.ToInt32(row["RECIPEMONTH"]), Convert.ToInt32(row["RECIPELENGTH"])); data.Param.Add("RECIPECODEHelp", data.Param["RECIPECODE"].ToString() + "%"); data.Param["RECIPECODE"] = data.Param["RECIPECODE"] + DaoTool.ExecuteScalar(dao, OptContent.get("GetrecipeCodeNo"), data).ToInt().ToString("D2"); } if (data.Param["OUTID"] == null || data.Param["OUTID"].ToString() == "") { data.Param["OUTID"] = DaoTool.Seq(dao, "LKEQ.SEQEQOut"); OutIdHelp = data.Param["OUTID"].ToString(); if (DaoTool.Save(dao, OptContent.get("ModifyOutMainInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("新增设备领用的主表信息失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } if (DaoTool.Update(dao, OptContent.get("ModifyOutMainInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备领用的出库主表信息失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("ModifyOrAddXi")) { //如果出库Id为空的话,肯定操作为新增,肯定都是新增的细表行。 首先获取生成的主表OUTID if (data.Param["OUTID"] == null || data.Param["OUTID"].ToString() == "") { data.Param["OUTID"] = OutIdHelp; data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQOutDetail"); if (DaoTool.Save(dao, OptContent.get("ModifyOutXiBiaoInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备领用的出库细表失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } else//操作为修改 { if (data.Param["DETAILNO"] == null || data.Param["DETAILNO"].ToString().Trim() == "") { //为新增的数据 新增完之后返回 data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQOutDetail"); if (DaoTool.Save(dao, OptContent.get("ModifyOutXiBiaoInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备领用的出库细表失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } if (DaoTool.Update(dao, OptContent.get("ModifyOutXiBiaoInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备领用的出库细表失败!" + dao.ErrMsg); } msg = "执行成功!"; //能够retrun ok 说明 要么是前面新增的对了,要么是后面的修改正确,不然都是throw出去 return("ok"); } } if (data.Sql.Equals("SHOutMainInfo")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("UpdateStatusInLingYong"), data) < 0) { msg = "执行失败!"; throw new Exception("更新审核状态失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //===================================审核部分===================================== //入库主表 if (data.Sql.Equals("InsertInMain")) { data.Param["INID"] = DaoTool.Seq(dao, "LKEQ.SEQEQIN"); InIdHelp = data.Param["INID"].ToString(); DataTable dt = DaoTool.FindDT(dao, OptContent.get("GetRecipeCodeInEQOutInfo"), data); if (dt.Rows.Count <= 0 || dt == null) { throw new Exception("无法查找到单据前缀" + dao.ErrMsg); } DataRow row = dt.Rows[0]; data.Param["RECIPECODE"] = Recipecode(row["RECIPECODE"].ToString(), Convert.ToInt32(row["RECIPEYEAR"]), Convert.ToInt32(row["RECIPEMONTH"]), Convert.ToInt32(row["RECIPELENGTH"])); data.Param.Add("RECIPECODEHelp", data.Param["RECIPECODE"].ToString() + "%"); data.Param["RECIPECODE"] = data.Param["RECIPECODE"] + DaoTool.ExecuteScalar(dao, OptContent.get("GetrecipeCodeNo"), data).ToInt().ToString("D2"); RecipeCodeInMain = data.Param["RECIPECODE"].ToString(); SHDHHelp = data.Param["SHDH"]; SUPPLYIDHelp = data.Param["SUPPLYID"]; SUPPLYNAMEHelp = data.Param["SUPPLYNAME"]; if (DaoTool.Save(dao, OptContent.get("SaveEQInMainInfoCX"), data) < 0) { msg = "执行失败!"; throw new Exception("入库主表的信息插入失败!" + dao.ErrMsg); } //更新对应生成的INID至当前的出库主表 dao.ExecuteNonQuery("UPDATE LKEQ.EQOUTMAIN SET INID=" + data.Param["INID"].ToString() + " WHERE CHOSCODE=" + data.Param["CHOSCODE"] + " AND OUTID=" + data.Param["OUTID"].ToString()); msg = "执行成功!"; return("ok"); } //入库细表 if (data.Sql != null && data.Sql.Equals("InsertEQInDetail")) { data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQINDETAIL"); InDetailNoHelp = data.Param["DETAILNO"].ToString(); data.Param["INID"] = InIdHelp; if (DaoTool.Save(dao, OptContent.get("SaveEQInDetail"), data) < 0) { msg = "执行失败!"; throw new Exception("入库细表信息执行失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //库存主表 可能不会执行 【只有在库存主表,不存在该设备的信息】 if (data.Sql != null && data.Sql.Equals("InsertStockMain")) { data.Param["STOCKID"] = DaoTool.Seq(dao, "LKEQ.SEQEQSTOCK"); //在每执行一次对库存总表的插入,都会更新一次stockid,否则,就是针对 一个stockid的插入流水 StockIdHelp = data.Param["STOCKID"].ToString(); if (DaoTool.Save(dao, OptContent.get("SaveEQStock"), data) < 0) { msg = "执行失败!"; throw new Exception("库存主表信息执行失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //库存流水 if (data.Sql != null && data.Sql.Equals("InsertStockDetail")) { data.Param["FLOWNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQSTOCKDETAIL"); data.Param["INID"] = InIdHelp; data.Param["RECIPECODE"] = RecipeCodeInMain; data.Param["SHDH"] = SHDHHelp; data.Param["GHSUPPLYID"] = SUPPLYIDHelp; data.Param["GHSUPPLYNAME"] = SUPPLYNAMEHelp; if (data.Param["STOCKID"] == null || data.Param["STOCKID"].ToString() == "") { data.Param["STOCKID"] = StockIdHelp; } if (DaoTool.Save(dao, OptContent.get("SaveEQStockDetail"), data) < 0) { msg = "执行失败!"; throw new Exception("库存流水信息执行失败!" + dao.ErrMsg); } //更新至入库细表 dao.ExecuteNonQuery("UPDATE LKEQ.EQINDETAIL SET STOCKFLOWNO=" + data.Param["FLOWNO"].ToString() + " WHERE CHOSCODE=" + data.Param["CHOSCODE"] + " AND DETAILNO=" + InDetailNoHelp); msg = "执行成功!"; return("ok"); } //冲销操作================================================================================= if (data.Sql != null && data.Sql.Equals("ChongXiaoRuChu")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("ChongXiaoChuKuStatusChange"), data) < 0) { msg = "执行失败!"; throw new Exception("修改出库主表冲销状态失败!" + dao.ErrMsg); } if (DaoTool.ExecuteNonQuery(dao, OptContent.get("ChongXiaoRuKuStatusChange"), data) < 0) { msg = "执行失败!"; throw new Exception("修改入库主表冲销状态失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //插入出库主表 if (data.Sql != null && data.Sql.Equals("ChongXiaoZhuChuKu")) { data.Param["OUTID"] = DaoTool.Seq(dao, "LKEQ.SEQEQOut"); OutIdCXHelp = data.Param["OUTID"].ToString(); if (DaoTool.Save(dao, OptContent.get("ModifyOutMainInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("插入冲销出库主表失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //出库细表 if (data.Sql != null && data.Sql.Equals("ChongXiaoXiChuKu")) { data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQOutDetail"); data.Param["OUTID"] = OutIdCXHelp; if (DaoTool.Save(dao, OptContent.get("ModifyOutXiBiaoInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("插入冲销出库细表失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //入库主表 if (data.Sql != null && data.Sql.Equals("ChongXiaoZhuRuKu")) { data.Param["INID"] = DaoTool.Seq(dao, "LKEQ.SEQEQIN"); InIdCXHelp = data.Param["INID"].ToString(); if (DaoTool.Save(dao, OptContent.get("SaveEQInMainInfoCX"), data) < 0) { throw new Exception("插入冲销入库主表失败!" + dao.ErrMsg); } dao.ExecuteNonQuery("UPDATE LKEQ.EQOUTMAIN SET INID=" + data.Param["INID"].ToString() + " WHERE CHOSCODE= " + data.Param["CHOSCODE"].ToString() + " AND OUTID=" + OutIdCXHelp); msg = "执行成功!"; return("ok"); } //入库细表 if (data.Sql != null && data.Sql.Equals("ChongXiaoXiRuKu")) { data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQINDETAIL"); data.Param["INID"] = InIdCXHelp; if (DaoTool.Save(dao, OptContent.get("SaveEQInDetail"), data) < 0) { throw new Exception("插入冲销细表失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } else { msg = "系统出错,请与管理人员联系!"; return("ok"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql != null && data.Sql.Equals("Del")) { int ifuse = DaoTool.ExecuteScalar(dao, OptContent.get("EQUnitIsUse2"), data).ToInt(); if (ifuse > 0) { //throw new Exception("物资单位已经被系统使用,不能删除!"); msg = "设备单位已经被系统使用,不能删除!"; return("ok"); } int rw = DaoTool.ExecuteNonQuery(dao, OptContent.get("DelEQUnitInfo"), data); if (rw < 0) { throw new Exception("删除设备单位信息失败!"); } msg = "设备单位已删除!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("Save")) { Opt op = OptContent.get("SaveEQUnitInfo"); if (data.Param.ContainsValue(op.Key)) { int repeat = DaoTool.ExecuteScalar(dao, OptContent.get("ModifyEQUnitIsRepeat"), data).ToInt(); if (repeat > 0) { //throw new Exception("已经存在该物资价格体系信息,不能修改成该名称!" + dao.ErrMsg); msg = "已经存在该设备项目信息,不能修改成该名称!"; return("ok"); } int tr = DaoTool.ExecuteScalar(dao, OptContent.get("DefaultEQUnit"), data).ToInt(); if ((data.Param["DEFVALUE"].ToString() == "1") && tr > 0) { data.Params = new object[] { data.Param["DICGRPID"], data.Param["DICID"] }; dao.ExecuteNonQuery(OptContent.get("SetDefaultEQUnit").Sql, data.Params); } if (DaoTool.Update(dao, op, data) > -1) { msg = "保存设备单位信息成功!"; return("ok"); } else { throw new Exception("保存设备单位信息失败!" + dao.ErrMsg); } } else { int repeat = DaoTool.ExecuteScalar(dao, OptContent.get("AddEQUnitIsRepeat"), data).ToInt(); if (repeat > 0) { //throw new Exception("已经存在该物资价格体系信息!" + dao.ErrMsg); msg = "已经存在该设备项目信息!"; return("ok"); } int dicid_int = DaoTool.ExecuteScalar(dao, OptContent.get("SaveEQUnitInfo_seq"), data).ToInt() + 1; //if (dicid_int >= 0 && dicid_int < 10) //{ // data.Param["DICID"] = "0" + dicid_int.ToString(); //} //else //{ // data.Param["DICID"] = dicid_int.ToString(); //} //int tr = DaoTool.ExecuteScalar(dao, OptContent.get("DefaultWZUnit"), data).ToInt(); data.Param["DICID"] = dicid_int.ToString(); if ((data.Param["DEFVALUE"].ToString() == "1") && DaoTool.ExecuteScalar(dao, OptContent.get("DefaultEQUnit"), data).ToInt() > 0) { data.Params = new object[] { data.Param["DICGRPID"], data.Param["DICID"] }; dao.ExecuteNonQuery(OptContent.get("SetDefaultEQUnit").Sql, data.Params); } if (DaoTool.Save(dao, op, data) > -1) { msg = "添加成功!"; return("ok"); } else { throw new Exception("添加设备单位信息失败!" + dao.ErrMsg); } } } else { throw new Exception("保存设备单位信息失败!" + dao.ErrMsg); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql != null && data.Sql.Equals("EQPurchasePlanDelete"))//删除主表 { data.Param["STATUS"] = 0; if (DaoTool.Update(dao, OptContent.get("SaveEQPlanMainInfo"), data) > -1) { msg = "删除采购计划信息成功!"; return("ok"); } else { throw new Exception("删除采购计划信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("PlanDanUpdate_SH")) { Opt op = OptContent.get("SaveEQPlanMainInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { // saveRunDetail(dao, data); //if (data.Param["STATUS"].ToString() == "2") //{ //} msg = "审核采购计划信息成功!"; return("ok"); } else { throw new Exception("审核采购计划信息失败!" + dao.ErrMsg); } } } if (data.Sql != null && data.Sql.Equals("PlanDanUpdata_Submit")) { Opt op = OptContent.get("SaveEQPlanMainInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { msg = "提交采购计划信息成功!"; return("ok"); } else { throw new Exception("提交采购计划信息失败!" + dao.ErrMsg); } } } if (data.Sql != null && data.Sql.Equals("PlanDanEQdelete")) { //删除采购计划细表记录 if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DeleteEQPlanDetailInfo"), data) < 0) { throw new Exception("删除采购设备信息失败!"); } //更新采购计划主表信息 if (DaoTool.Update(dao, OptContent.get("SaveEQPlanMainInfo"), data) < 0) { throw new Exception("保存采购计划单失败!" + dao.ErrMsg); } msg = "删除采购设备信息成功!"; return("ok"); } //if (data.Sql != null && data.Sql.Equals("UpdateWZPlanDan")) //{ // if (DaoTool.Update(dao, OptContent.get("SaveWZPlanMainInfo"), data) > -1) // { // //savePlanDetail(dao, data); // msg = "保存采购计划信息成功!"; // return "ok"; // } // else // { // throw new Exception("保存采购计划信息失败!" + dao.ErrMsg); // } //} if (data.Sql != null && data.Sql.Equals("PlanDanSave")) { Opt op = OptContent.get("SaveEQPlanMainInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { savePlanDetail(dao, data); msg = "保存设备计划信息成功!"; return("ok"); } else { throw new Exception("保存设备计划信息失败!" + dao.ErrMsg); } } else { data.Param["PLANID"] = DaoTool.Seq(dao, "LKEQ.SEQEQPlan"); if (DaoTool.Save(dao, op, data) > -1) { savePlanDetail(dao, data); msg = "添加设备计划成功!"; return("ok"); } else { throw new Exception("添加设备计划失败!" + dao.ErrMsg); } } } msg = "保存成功!"; return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { //SysValueManag if (data.Sql == null) { throw new Exception("Sql内容为空!"); } else if (data.Sql.Equals("Del")) { int count = DaoTool.ExecuteScalar(dao, OptContent.get("InOutIsSy"), data).ToInt(); if (count > 0) { // throw new Exception("此入出类型已经被系统使用,不能删除!"); msg = "此入出类型已经被系统使用,不能删除!"; return("ok"); } if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelInOutInfo"), data) < 0) { throw new Exception("删除此入出类型失败!"); } msg = "此入出类型已删除!"; return("ok"); } else if (data.Sql.Equals("Add")) { Opt op = OptContent.get("SaveInOutInfo"); data.Param["IOID"] = DaoTool.Seq(dao, "LKWZ.SEQWZIO");; data.Param["RECDATE"] = DateTime.Now; if (data.Param["IFDEFAULT"] != null && data.Param["IFDEFAULT"].ToString() == "1") { dao.ExecuteNonQuery("update LKWZ.DICTWZINOUT set IFDEFAULT=0 where CHOSCODE='" + data.Param["CHOSCODE"].ToString() + "' and IOFALG=" + data.Param["IOFLAG"].ToString() + " and OPFLAG=" + data.Param["OPFLAG"].ToString()); } if (DaoTool.Save(dao, op, data) > -1) { msg = "统计类别添加成功!"; return("ok"); } else { throw new Exception("统计类别添加失败!" + dao.ErrMsg); } } else if (data.Sql.Equals("Update")) { Opt op = OptContent.get("SaveInOutInfo"); data.Param["RECDATE"] = DateTime.Now; if (data.Param["IFDEFAULT"] != null && data.Param["IFDEFAULT"].ToString() == "1") { dao.ExecuteNonQuery("update LKWZ.DICTWZINOUT set IFDEFAULT=0 where CHOSCODE='" + data.Param["CHOSCODE"].ToString() + "'"); } if (DaoTool.Update(dao, op, data) > -1) { msg = "统计类别更新成功!"; return("ok"); } else { throw new Exception("统计类别更新失败!" + dao.ErrMsg); } } else if (data.Sql.Equals("TingYong")) { Opt op = OptContent.get("SetInOutUnUsed"); if (DaoTool.ExecuteNonQuery(dao, op, data) != 1) { throw new Exception("停用失败!" + dao.ErrMsg); } msg = "此入出类型停用成功!"; return("ok"); } else if (data.Sql.Equals("QiYong")) { Opt op = OptContent.get("SetInOutUsed"); if (DaoTool.ExecuteNonQuery(dao, op, data) != 1) { throw new Exception("启用失败!" + dao.ErrMsg); } msg = "此入出类型启用成功!"; return("ok"); } else if (data.Sql.Equals("Copy")) { int count = DaoTool.ExecuteScalar(dao, OptContent.get("CheckInOutIsNull"), data).ToInt(); if (count == 0) { DataTable dt = DaoTool.FindDT(dao, OptContent.get("FindInOutCcode0"), data); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { data.Param["IOID"] = DaoTool.Seq(dao, "LKWZ.SEQWZIO"); data.Param["IONAME"] = r["IONAME"]; data.Param["PYCODE"] = r["PYCODE"]; data.Param["WBCODE"] = r["WBCODE"]; data.Param["IFUSE"] = r["IFUSE"]; data.Param["RECIPECODE"] = r["RECIPECODE"]; data.Param["RECIPELENGTH"] = r["RECIPELENGTH"]; data.Param["RECIPEYEAR"] = r["RECIPEYEAR"]; data.Param["RECIPEMONTH"] = r["RECIPEMONTH"]; data.Param["MEMO"] = r["MEMO"]; data.Param["IOFLAG"] = r["IOFLAG"]; data.Param["USEST"] = r["USEST"]; data.Param["USEND"] = r["USEND"]; data.Param["USERD"] = r["USERD"]; data.Param["OPFLAG"] = r["OPFLAG"]; data.Param["IFDEFAULT"] = r["IFDEFAULT"]; data.Param["RECDATE"] = DateTime.Now; if (DaoTool.Save(dao, OptContent.get("SaveInOutInfo"), data) != 1) { throw new Exception("复制失败,!" + dao.ErrMsg); } } } msg = "复制成功!"; return("ok"); } else { msg = "已存在本医疗结构的出入类型,复制失败!"; return("ok"); } } else if (data.Sql.Equals("Find")) { msg = "查找成功!"; return("ok"); } msg = "成功!"; return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql == null) { msg = "无效的SQL参数,无法继续执行!"; return("ok"); } if (data.Sql.Equals("ModifyOrAddInfo")) { //新增的 if (data.Param["NOID"] == null || data.Param["NOID"].ToString() == "") { data.Param["NOID"] = DaoTool.Seq(dao, "LKEQ.SEQEQXZNo"); Opt op = OptContent.get("SaveEQAccount"); if (DaoTool.Save(dao, op, data) < 0) { msg = "执行失败!"; throw new Exception("新增设备下账记录失败!" + dao.ErrMsg); } msg = "新增检查记录成功!"; return("ok"); } if (DaoTool.Update(dao, OptContent.get("SaveEQAccount"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备下账记录失败!" + dao.ErrMsg); } msg = "修改下账记录成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("JDPass")) { data.Param["JDDATE"] = DateTime.Now; if (DaoTool.Update(dao, OptContent.get("SaveEQAccount"), data) > -1) { msg = "鉴定下账信息成功!"; return("ok"); } else { throw new Exception("鉴定下账信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("JDNo")) { if (DaoTool.Update(dao, OptContent.get("SaveEQAccount"), data) > -1) { msg = "鉴定下账信息成功!"; return("ok"); } else { throw new Exception("鉴定下账信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("SHPass")) { Opt op = OptContent.get("ChangTheStatus_EQAccount"); data.Param["SHDATE"] = DateTime.Now; if (DaoTool.Update(dao, OptContent.get("SaveEQAccount"), data) > -1) { if (DaoTool.ExecuteNonQuery(dao, op, data) > 0) { msg = "审核下账信息成功!"; return("ok"); } else { throw new Exception("修改卡片设备状态失败!" + dao.ErrMsg); } } else { throw new Exception("审核下账信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("SHNo")) { if (DaoTool.Update(dao, OptContent.get("SaveEQAccount"), data) > -1) { msg = "审核下账信息成功!"; return("ok"); } else { throw new Exception("审核下账信息失败!" + dao.ErrMsg); } } else { msg = "系统出错,请与管理员联系!"; return("ok"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { #region 停用,启用,删除 if (data.Sql != null && data.Sql.Equals("TingYong")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("QiTingEQStatus_EQStatusManag"), data) < 0) { throw new Exception("停用设备状态信息失败!" + dao.ErrMsg); } msg = "停用设备状态信息成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("QiYong")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("QiTingEQStatus_EQStatusManag"), data) < 0) { throw new Exception("启用设备状态信息失败!" + dao.ErrMsg); } msg = "启用设备状态信息成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("Del")) { //检查是否被其他表所使用,这里是EQCARDREC if (DaoTool.ExecuteScalar(dao, OptContent.get("IfHaveUseEQStatus"), data).ToInt() > 0) { msg = "该条设备状态信息被其他数据所使用,无法删除"; return("ok"); } //如果能够执行到这儿的话,说明不被其他数据所使用 if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelEQStatusInfo"), data) > 0) { msg = "删除该条设备状态信息成功"; return("ok"); } else { throw new Exception("删除该条设备状态信息失败" + dao.ErrMsg); } } #endregion if (data.Sql != null && data.Sql.Equals("Add")) { //求状态编码[等于0 表示没有数据 且至少成功。] int statuscode_int = DaoTool.ExecuteScalar(dao, OptContent.get("GetStatusCodeMax_EQStatusManag"), data).ToInt() + 1; if (statuscode_int > 0 && statuscode_int < 10) { data.Param["STATUSCODE"] = "0" + statuscode_int.ToString(); } if (statuscode_int >= 100) { msg = "状态编码已满,不能继续添加!"; return("ok"); } if (statuscode_int >= 10 && statuscode_int < 100) { data.Param["STATUSCODE"] = statuscode_int.ToString(); } //判断名称是否重复 if (DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveRepetEQStatusName"), data).ToInt() > 0) { msg = "已经存在该状态名称,请修改后提交!"; return("ok"); } if (DaoTool.Save(dao, OptContent.get("SaveEQStatusInfo"), data) > -1) { msg = "增加设备状态信息成功!"; return("ok"); } else { throw new Exception("增加设备状态信息失败" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("Modify")) { //判断名称是否重复 if (DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveRepetEQStatusName"), data).ToInt() > 0) { msg = "已经存在该状态名称,请修改后提交!"; return("ok"); } if (DaoTool.Update(dao, OptContent.get("SaveEQStatusInfo"), data) > -1) { msg = "修改设备状态信息成功!"; return("ok"); } else { throw new Exception("修改设备状态信息失败" + dao.ErrMsg); } } else { msg = "系统错误,请与管理员取得联系!"; return("ok"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql == null) { throw new Exception("SQL参数为空!"); } if (data.Sql.Equals("ModifyZhuInfo")) { if (DaoTool.Update(dao, OptContent.get("SaveEQCardRecInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("设备卡片记录表更新失败!" + dao.ErrMsg); } //更新对应的设备数目 DaoTool.ExecuteNonQuery(dao, OptContent.get("UpdateCardNumInCardInfo"), data); msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("ModifyCCInfo")) { if (data.Param["IsUpdateCC"].ToString() == "1") { if (DaoTool.Update(dao, OptContent.get("SaveEQCardCCInfo"), data) < 0) { throw new Exception("设备财产记录表更新失败!" + dao.ErrMsg); } } else { if (DaoTool.Save(dao, OptContent.get("SaveEQCardCCInfo"), data) < 0) { throw new Exception("设备财产记录表新增失败!" + dao.ErrMsg); } } msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("ModifySMInfo")) { if (data.Param["IsUpdateSM"].ToString() == "1") { if (DaoTool.Update(dao, OptContent.get("SaveEQCardSMInfo"), data) < 0) { throw new Exception("设备说明记录表更新失败!" + dao.ErrMsg); } } else { if (DaoTool.Save(dao, OptContent.get("SaveEQCardSMInfo"), data) < 0) { throw new Exception("设备说明记录表新增失败!" + dao.ErrMsg); } } msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("ModifyFJInfo")) { if (data.Param["IsUpdateFJ"].ToString() == "1") { if (DaoTool.Update(dao, OptContent.get("SaveEQCardFJInfo"), data) < 0) { throw new Exception("设备附件记录表更新失败!" + dao.ErrMsg); } } else { //若为新增,则 行号需要改变 // data.Param.Remove("IsUpdateFJ"); data.Param["ROWNO"] = DaoTool.ExecuteScalar(dao, OptContent.get("FindRowNoInFJ"), data).ToInt() + 1; if (DaoTool.Save(dao, OptContent.get("SaveEQCardFJInfo"), data) < 0) { throw new Exception("设备附件记录表新增失败!" + dao.ErrMsg); } } msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("ModifyJLInfo")) { if (data.Param["IsUpdateJL"].ToString() == "1") { if (DaoTool.Update(dao, OptContent.get("SaveEQCardJLInfo"), data) < 0) { throw new Exception("设备计量记录表更新失败!" + dao.ErrMsg); } } else { data.Param["ROWNO"] = DaoTool.ExecuteScalar(dao, OptContent.get("FindRowNoInFJ"), data).ToInt() + 1; if (DaoTool.Save(dao, OptContent.get("SaveEQCardJLInfo"), data) < 0) { throw new Exception("设备计量记录表新增失败!" + dao.ErrMsg); } } msg = "执行成功!"; return("ok"); } //前面全部为修改部分 下面开始处理新增部分 if (data.Sql.Equals("AddZhuInfo")) { // if(data.Param["IsFlag"]!=null||data.Param["IsFlag"].ToString()="") data.Param["CARDID"] = DaoTool.Seq(dao, "LKEQ.SEQEQCardUse"); CardId = Convert.ToInt32(data.Param["CARDID"]); string Prefix = dao.Es("SELECT PREFIX FROM LKEQ.DICTEQKIND WHERE CHOSCODE=" + data.Param["CHOSCODE"].ToString() + " AND KINDCODE=(SELECT KINDCODE FROM LKEQ.DICTEQ WHERE EQID=" + data.Param["EQID"].ToString() + " AND CHOSCODE=" + data.Param["CHOSCODE"].ToString() + ")").ToString().ToUpper(); int LengthG = Convert.ToInt32(dao.Es("SELECT DISTINCT SYSVALUE FROM HIS.系统参数 WHERE ID=2206"));//长度 //可以直接这样搜索是前缀一样,比较的是后面的数字 object MaxFirst = dao.Es("SELECT MAX(CARDCODE) FROM LKEQ.EQCARDREC WHERE EQID=" + data.Param["EQID"].ToString() + " AND CHOSCODE=" + data.Param["CHOSCODE"].ToString() + " AND CARDCODE LIKE " + "'%" + Prefix + "%'"); string Max; if (MaxFirst == null) { Max = "1"; } else { Max = MaxFirst.ToString(); if (Max.Contains(Prefix)) { Max = ((Convert.ToInt64(Max.Substring(Max.LastIndexOf(Prefix) + Prefix.Length))) + 1).ToString(); } else { Max = "1"; } } data.Param["CARDCODE"] = Prefix + 0.ToString("D" + (LengthG - Max.Length)) + Max; if (DaoTool.Save(dao, OptContent.get("SaveEQCardRecInfo"), data) < 0) { throw new Exception("设备卡片主表新增失败!" + dao.ErrMsg); } //同样的更新数目到库存流水表 DaoTool.ExecuteNonQuery(dao, OptContent.get("UpdateCardNumInCardInfo"), data); msg = "执行成功!"; return("ok"); // } if (data.Sql.Equals("AddJLInfo")) { data.Param["CARDID"] = CardId; data.Param["ROWNO"] = DaoTool.ExecuteScalar(dao, OptContent.get("FindRowNoInFJ"), data).ToInt() + 1; if (DaoTool.Save(dao, OptContent.get("SaveEQCardJLInfo"), data) < 0) { throw new Exception("设备计量信息新增失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("AddCCInfo")) { data.Param["CARDID"] = CardId; if (DaoTool.Save(dao, OptContent.get("SaveEQCardCCInfo"), data) < 0) { throw new Exception("设备财产信息新增失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("AddFJInfo")) { data.Param["CARDID"] = CardId; data.Param["ROWNO"] = DaoTool.ExecuteScalar(dao, OptContent.get("FindRowNoInFJ"), data).ToInt() + 1; if (DaoTool.Save(dao, OptContent.get("SaveEQCardFJInfo"), data) < 0) { throw new Exception("设备附件信息新增失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } if (data.Sql.Equals("AddSMInfo")) { data.Param["CARDID"] = CardId; if (DaoTool.Save(dao, OptContent.get("SaveEQCardSMInfo"), data) < 0) { throw new Exception("设备说明信息新增失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } else { throw new Exception("系统出错,请与管理员联系!"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { string ccode = data.Param["cHosCode"].ToString(); DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("名称")); dt.Columns.Add(new DataColumn("值")); /*string supcode = "" ; * if (ccode.Trim().Length > 7) * { * supcode = ccode.Substring(0, ccode.Length - 2); * } * else { * supcode = ccode; * } * //获取农合前缀 * DataRow r = dt.NewRow(); * object qz = dao.ExecuteScalar("select nhperfix from SYSDICTHOSPITAL where cHosCode=?", new object[] { supcode }); * if (qz == null) * { * r["名称"] = "NHPREFIX"; * r["值"] = ""; * } * else { * r["名称"] = "NHPREFIX"; * r["值"] = qz.ToString(); * } * dt.Rows.Add(r); * * object NHHOSCODE = dao.ExecuteScalar("select nhhospcode from SYSDICTHOSPITAL where cHosCode=?", new object[] { ccode }); * DataRow rd = dt.NewRow(); * if (NHHOSCODE == null) * { * rd["名称"] = "NHHOSCODE"; * rd["值"] = ""; * } * else * { * rd["名称"] = "NHHOSCODE"; * rd["值"] = NHHOSCODE.ToString(); * } * dt.Rows.Add(rd); * * object areacode = dao.ExecuteScalar("select areacode from SYSDICTHOSPITAL where cHosCode=?", new object[] { ccode }); * DataRow rd1 = dt.NewRow(); * if (areacode == null) * { * rd1["名称"] = "AREACODE"; * rd1["值"] = ""; * } * else * { * rd1["名称"] = "AREACODE"; * rd1["值"] = areacode.ToString(); * } * dt.Rows.Add(rd1); */ msg = "OK"; DataTable hisYBParam = dao.find("select t.* from 医保设置表 t where t.choscode=?", new object[] { ccode }); string sql = OptContent.get("Get_SuperCode").Sql; DataTable sup = dao.find(sql, new object[] { ccode }); string wsjcode = sup.Rows[0][0].ToString(); DataTable hisPa = dao.find("select ID,sysvalue from 系统参数 t where (choscode is null or choscode=? or choscode=?) and not exists" + "(select * from 系统参数 where (choscode=? or choscode=?) and t.id=id and length(nvl(t.choscode,' '))<length(choscode) )", new object[] { ccode, wsjcode, ccode, wsjcode }); //优先取医院设置的系统参数,再到卫生局设置的系统参数,再取全省系统参数 DataRow rdwsj = dt.NewRow(); DataRow usnode = dt.NewRow(); DataRow rdnhperfix = dt.NewRow(); rdwsj["名称"] = "WSJCODE"; usnode["名称"] = "USEZBY"; rdnhperfix["名称"] = "NHPERFIX"; if (sup != null) { rdwsj["值"] = sup.Rows[0][0].ToString(); rdnhperfix["值"] = sup.Rows[0][2].ToString(); if (sup.Rows[0][1] != null && sup.Rows[0][1].ToString().Length > 0) { usnode["值"] = sup.Rows[0][1].ToString(); } else { usnode["值"] = "0"; } } else { rdwsj["值"] = ""; usnode["值"] = "0"; rdnhperfix["值"] = ""; } dt.Rows.Add(rdwsj); dt.Rows.Add(usnode); dt.Rows.Add(rdnhperfix); return(new object[] { dt, hisPa, sup, hisYBParam }); }
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) { if (data.Sql != null && data.Sql.Equals("TingYong")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("QiTingEQInOutInfo_EQInOutManag"), data) > 0) { msg = "停用该条设备入出库记录成功!"; return("ok"); } else { throw new Exception("停用该条设备入出库信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("QiYong")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("QiTingEQInOutInfo_EQInOutManag"), data) > 0) { msg = "启用该条设备入出库记录成功!"; return("ok"); } else { throw new Exception("启用该条设备入出库记录失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("Del")) { if (DaoTool.ExecuteScalar(dao, OptContent.get("IfHaveUseEQInOut"), data).ToInt() > 0) { msg = "该条设备入出库记录已被使用,无法删除!"; return("ok"); } if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelEQInOutInfo_EQInOutManag"), data) > 0) { msg = "删除该条设备入出库记录成功!"; return("ok"); } else { throw new Exception("删除该条设备入出库记录失败!" + dao.ErrMsg); } } //----------------------------------这里的代码有些重复,有时间再进行复用操作【关键是msg 这里怎么办?】------------------------------- if (data.Sql != null && data.Sql.Equals("Modify")) { //惯例: 名称是否重复 // 相同的医疗机构编码、入出标志、操作标志的记录里,只能有一条记录的该值为1 if (DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveRepeatInOutName"), data).ToInt() > 0) { msg = "存在相同的设备入出库名称,请修改后再进行操作"; return("ok"); } //MessageBox.Show("执行到修改2"); if (data.Param["IFDEFAULT"].ToString() == "1" && DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveMoreDefault_EQInOutManag"), data).ToInt() > 0) { msg = "相同的医疗机构编码、入出标志、操作标志的记录里,只能有一条记录的默认值为是!"; return("ok"); } //MessageBox.Show("执行到修改3"); //验证:对于一个医疗机构来说,其操作类别为(1:调拨;2:申领;3:盘点)的出入库类型记录 //其入库和出库的类型记录,分别各有且只能有一条记录; //如医疗机构甲,其调拨的入库方式,只能有一种方式,其调拨的出库方式,也只能有一种方式; if (data.Param["OPFLAG"].ToString() != "0" && DaoTool.ExecuteScalar(dao, OptContent.get("IsSingleInOutOfCHOS"), data).ToInt() > 0) { //针对1,2,3 msg = "操作为调拨,申领,盘点的记录,其出库与入库的记录只能各有一条,请修改后再进行操作"; return("ok"); } //MessageBox.Show("执行到修改4"); if (DaoTool.Update(dao, OptContent.get("SaveEQInOutInfo"), data) < 0) { throw new Exception("修改该条设备入出库记录失败!"); } msg = "修改该条设备入出库记录成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("Add")) { //首先设置好ID: data.Param["IOID"] = DaoTool.Seq(dao, "LKEQ.SEQEQIO"); //验证是否重名 if (DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveRepeatInOutName"), data).ToInt() > 0) { msg = "存在相同的设备入出库名称,请修改后再进行操作"; return("ok"); } if (data.Param["IFDEFAULT"].ToString() == "1" && DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveMoreDefault_EQInOutManag"), data).ToInt() > 0) { msg = "相同的医疗机构编码、入出标志、操作标志的记录里,只能有一条记录的默认值为是!"; return("ok"); } if (data.Param["OPFLAG"].ToString() != "0" && DaoTool.ExecuteScalar(dao, OptContent.get("IsSingleInOutOfCHOS"), data).ToInt() > 0) { //针对1,2,3 msg = "操作为调拨,申领,盘点的记录,其出库与入库的记录只能各有一条,请修改后再进行操作"; return("ok"); } if (DaoTool.Save(dao, OptContent.get("SaveEQInOutInfo"), data) < 0) { throw new Exception("新增设备入出库记录失败!"); } msg = "新增设备入出库记录成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("CopyChoscodeData")) { //验证本机构是否包含数据 int count = DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveAnyDataEQInOut_EQInOutManag"), data).ToInt(); if (count == 0) { DataTable dt = DaoTool.FindDT(dao, OptContent.get("FindEQInOutcode0_EQInOutManag"), data); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow r in dt.Rows) { int statuscode_int = DaoTool.ExecuteScalar(dao, OptContent.get("GetEQInOutIDMax"), data).ToInt() + 1; data.Param["IOID"] = DaoTool.Seq(dao, "LKEQ.SEQEQIO"); data.Param["IONAME"] = r["IONAME"]; data.Param["PYCODE"] = r["PYCODE"]; data.Param["WBCODE"] = r["WBCODE"]; data.Param["IFUSE"] = r["IFUSE"]; data.Param["RECIPECODE"] = r["RECIPECODE"]; data.Param["RECIPELENGTH"] = r["RECIPELENGTH"]; data.Param["RECIPEYEAR"] = r["RECIPEYEAR"]; data.Param["RECIPEMONTH"] = r["RECIPEMONTH"]; data.Param["MEMO"] = r["MEMO"]; data.Param["IOFLAG"] = r["IOFLAG"]; data.Param["OPFLAG"] = r["OPFLAG"]; data.Param["IFDEFAULT"] = r["IFDEFAULT"]; data.Param["RECDATE"] = DateTime.Now; if (DaoTool.Save(dao, OptContent.get("SaveEQInOutInfo"), data) < 0) { throw new Exception("复制失败!" + dao.ErrMsg); } } } msg = "复制成功!"; return("ok"); } else { msg = "已存在本医疗结构的出入类型,复制失败!"; return("ok"); } } else { msg = "系统故障,请与管理员联系!"; return("ok"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { msg = "系统参数更改"; if (data.Sql == null) { throw new Exception("Sql内容为空!"); } else if (data.Sql.Equals("Add")) { //if (dao.ExecuteNonQuery(OptContent.get("InsertSysValue").Sql, data.Params) == 5) String[] s = OptContent.get("EQInsertSysValue").Sql.Split('?'); String sql = ""; for (int i = 0; i < s.Length - 1; i++) { if (data.Params[i].GetType().ToString().ToUpper() == "SYSTEM.INT32") { sql += s[i] + data.Params[i].ToString(); } else { sql += s[i] + "'" + data.Params[i].ToString() + "'"; } } sql += s[s.Length - 1]; s = sql.Split(';'); for (int i = 0; i < s.Length; i++) { if (dao.ExecuteNonQuery(s[i]) != 1) { throw new Exception("修改失败,在系统参数表中插入失败!" + dao.ErrMsg); } } msg = "修改成功!"; return("ok"); } else if (data.Sql.Equals("Update")) { String[] s = OptContent.get("EQUpdateSysValue").Sql.Split('?'); String sql = ""; for (int i = 0; i < s.Length - 1; i++) { if (data.Params[i].GetType().ToString().ToUpper() == "SYSTEM.INT32") { sql += s[i] + data.Params[i].ToString(); } else { sql += s[i] + "'" + data.Params[i].ToString() + "'"; } } sql += s[s.Length - 1]; s = sql.Split(';'); for (int i = 0; i < s.Length; i++) { if (dao.ExecuteNonQuery(s[i]) != 1) { throw new Exception("修改失败,在系统参数表中修改失败!" + dao.ErrMsg); } } msg = "修改成功!"; } else if (data.Sql.Equals("Find")) { //FindSysValue msg = "查找成功!"; return("ok"); } return("ok"); }
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) { 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) { if (data.Sql == null) { throw new Exception("Sql内容为空!"); } else if (data.Sql.Equals("Del")) { int count = DaoTool.ExecuteScalar(dao, OptContent.get("CkIsSy"), data).ToInt(); if (count > 0) { // throw new Exception("此统计类别已经被系统使用,不能删除!"); msg = "此统计类别已经被系统使用,不能删除!"; return("ok"); } if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelCkInfo"), data) < 0) { throw new Exception("删除统计类别信息失败!"); } if (DaoTool.ExecuteScalar(dao, OptContent.get("GetCk_seq"), data).ToInt() == 0) { data.Param["COUNTCODE"] = data.Param["SUPERCODE"]; DaoTool.ExecuteNonQuery(dao, OptContent.get("SetSuperCkEnd"), data); } msg = "此统计类别已删除!"; return("ok"); } else if (data.Sql.Equals("Add")) { Opt op = OptContent.get("SaveCkInfo"); data.Param["COUNTCODE"] = (DaoTool.ExecuteScalar(dao, OptContent.get("GetCk_seq"), data).ToInt() + 1).ToString("00"); if (!data.Param["SUPERCODE"].ToString().Equals("0")) { data.Param["COUNTCODE"] = data.Param["SUPERCODE"].ToString() + data.Param["COUNTCODE"].ToString(); } data.Param["RECDATE"] = DateTime.Now; if (DaoTool.Save(dao, op, data) > -1) { Opt op1 = OptContent.get("SetSuperCkNotEnd"); data.Param["COUNTCODE"] = data.Param["SUPERCODE"]; if (data.Param["COUNTCODE"].ToString() != "0") { if (DaoTool.ExecuteNonQuery(dao, op1, data) != 1) { throw new Exception("更新父节点状态失败!" + dao.ErrMsg); } } msg = "统计类别添加成功!"; return("ok"); } else { throw new Exception("统计类别添加失败!" + dao.ErrMsg); } } else if (data.Sql.Equals("Update")) { Opt op = OptContent.get("SaveCkInfo"); //data.Param["COUNTCODE"] = DaoTool.ExecuteScalar(dao, OptContent.get("GetCk_seq"), data).ToInt() + 1; data.Param["RECDATE"] = DateTime.Now; if (DaoTool.Update(dao, op, data) > -1) { msg = "统计类别更新成功!"; return("ok"); } else { throw new Exception("统计类别更新失败!" + dao.ErrMsg); } } else if (data.Sql.Equals("TingYong")) { Opt op = OptContent.get("SetCkUnUsed"); if (DaoTool.ExecuteNonQuery(dao, op, data) != 1) { throw new Exception("停用失败!" + dao.ErrMsg); } msg = "统计类别停用成功!"; return("ok"); } else if (data.Sql.Equals("QiYong")) { Opt op = OptContent.get("SetCkUsed"); if (DaoTool.ExecuteNonQuery(dao, op, data) != 1) { throw new Exception("启用失败!" + dao.ErrMsg); } msg = "统计类别启用成功!"; return("ok"); } else if (data.Sql.Equals("Find")) { msg = "查找成功!"; return("ok"); } msg = "成功!"; return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { #region 针对删除 //针对删除 if (data.Sql != null && data.Sql.Equals("Del")) { //验证是否在其他表中被使用 if (DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveUseEQWareInfo"), data).ToInt() > 0) { msg = "库房被使用,不能被删除,只能进行停用操作!"; return("ok"); } Opt op = OptContent.get("DelEQInfo"); if (DaoTool.ExecuteNonQuery(dao, op, data) > 0) { msg = "库房删除成功"; return("ok"); } else { throw new Exception("库房删除失败" + dao.ErrMsg); } } #endregion #region 针对停用 //针对停用 if (data.Sql != null && data.Sql.Equals("Disa")) { Opt op = OptContent.get("SaveEQInfo"); if (data.Param.ContainsValue(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { msg = "停用库房信息成功!"; return("ok"); } else { throw new Exception("停用库房信息失败!" + dao.ErrMsg); } } } #endregion #region 针对启用 //针对启用 if (data.Sql != null && data.Sql.Equals("Enab")) { Opt op = OptContent.get("SaveEQInfo"); if (data.Param.ContainsValue(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { msg = "启用库房信息成功"; return("ok"); } else { throw new Exception("启用库房信息失败!" + dao.ErrMsg); } } } #endregion //针对保存 if (data.Sql != null && data.Sql.Equals("Save")) { Opt op = OptContent.get("SaveEQInfo"); //感觉就是一个小陷阱,原来是value 如果为修改 if (data.Param.ContainsValue(op.Key)) { //更新设备库房信息 string kd = "0"; int repeat = DaoTool.ExecuteScalar(dao, OptContent.get("ModifyEQInfoIsRepeat"), data).ToInt(); if (repeat > 0) { msg = "已经存在该库房信息,不能修改成该名称!"; return("ok"); } //判断是否存在该类别编码([DICTEQWAREDETAIL]) kindcode [如果存在则置为1] int tr = DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveEQkindcode"), data).ToInt(); if (tr > 0) { kd = "1"; } if (DaoTool.Update(dao, op, data) > -1) { msg = kd + "," + "保存库房信息成功!"; return("ok"); } else { throw new Exception("保存库房信息失败!" + dao.ErrMsg); } } else { //增加设备库房信息 string wd = null; int repeat = DaoTool.ExecuteScalar(dao, OptContent.get("AddEQInfoIsRepeat"), data).ToInt();//添加时 名字是否重复了 if (repeat > 0) { msg = "已经存在该库房信息!"; return("ok"); } int warecode_int = DaoTool.ExecuteScalar(dao, OptContent.get("SaveEQInfo_seq"), data).ToInt() + 1;//+1是新增一个 if (warecode_int == 100) { msg = "库房已满,不能继续添加!"; return("ok"); } //用于转化库房编码,当库房编码小于10,则前面添加0 wd是将库房编码返回去? if (warecode_int >= 0 && warecode_int < 10) { data.Param["warecode"] = "0" + warecode_int.ToString(); wd = "0" + warecode_int.ToString(); } else { data.Param["warecode"] = warecode_int.ToString(); wd = warecode_int.ToString(); } if (DaoTool.Save(dao, op, data) > -1) { msg = wd + "," + "添加成功";//作为返回 return("ok"); } else { throw new Exception("添加库房信息失败!" + dao.ErrMsg); } } } else { throw new Exception("保存设备信息失败!" + dao.ErrMsg); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { //针对启用 if (data.Sql != null && data.Sql.Equals("QiYong")) { Opt op = OptContent.get("QiTingEQCountKind"); if (DaoTool.ExecuteNonQuery(dao, op, data) > 0) { msg = "启用该统计类别信息成功!"; return("ok"); } else { throw new Exception("启用该统计类别信息失败!"); } } if (data.Sql != null && data.Sql.Equals("TingYong")) { Opt op = OptContent.get("QiTingEQCountKind"); if (DaoTool.ExecuteNonQuery(dao, op, data) > 0) { msg = "停用该统计类别信息成功!"; return("ok"); } else { throw new Exception("停用该统计类别信息失败"); } } if (data.Sql != null && data.Sql.Equals("Del")) { Opt op = OptContent.get("IfHaveUse_EQCountKindManag"); if (DaoTool.ExecuteScalar(dao, op, data).ToInt() > 0) { //被使用 msg = "该设备统计类别已被使用,不能删除,只能停用!"; return("ok"); } if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DelEQCKInfo_EQCountKindManag"), data) < 0) { throw new Exception("删除设备统计类别信息失败"); } //在配置端已经设置好为 当前COUNTCODE作为SUPERCODE的子目录[IsHaveChildCK] if (DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveChildCK"), data).ToInt() == 0) { //检验一次,若节点下没有子节点,则更新其为末节点 SetCKSuperEnd DaoTool.ExecuteNonQuery(dao, OptContent.get("SetSuperEQCKEnd_EQCountKindManag"), data); } msg = "删除设备统计类别信息成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("Add")) { Opt op = OptContent.get("SaveCountKind"); //当上级节点确定,获取下级节点的个数+1为下级节点的一部分 data.Param["COUNTCODE"] = (DaoTool.ExecuteScalar(dao, OptContent.get("GetEQCountCode"), data).ToInt() + 1).ToString("00"); //当上级节点不为0[根节点] 其实在客户端就已经写好了,这里只是校验一下 if (!data.Param["SUPERCODE"].ToString().Equals("0")) { data.Param["COUNTCODE"] = data.Param["SUPERCODE"].ToString() + data.Param["COUNTCODE"].ToString(); } data.Param["RECDATE"] = DateTime.Now; if (DaoTool.ExecuteScalar(dao, OptContent.get("isRepeatCountName"), data).ToInt() == 0) { if (DaoTool.Save(dao, op, data) > -1) { //保存了之后,我们必须将对应的父节点设置为非末节点 Opt op1 = OptContent.get("SetSuperEQCKNotEnd"); data.Param["COUNTCODE"] = data.Param["SUPERCODE"]; if (data.Param["COUNTCODE"].ToString() != "0") { if (DaoTool.ExecuteNonQuery(dao, op1, data) != 1) { throw new Exception("更新父节点状态失败!" + dao.ErrMsg); } } msg = "设备统计类别添加成功!"; return("ok"); } else { throw new Exception("设备统计类别添加失败!" + dao.ErrMsg); } } else { msg = "已经存在该统计类别名称!"; return("ok"); } } if (data.Sql != null && data.Sql.Equals("Modify")) { Opt op = OptContent.get("SaveCountKind"); data.Param["RECDATE"] = DateTime.Now; if (DaoTool.ExecuteScalar(dao, OptContent.get("isRepeatCountName"), data).ToInt() == 0) { //当设置为末节点时,检查其是否包含子节点 if (data.Param["IFEND"].ToString() == "1") { if (DaoTool.ExecuteScalar(dao, OptContent.get("IsHaveChildCK"), data).ToInt() > 0) { msg = "该节点下包含子节点,不能设置其为末节点!"; return("ok"); } else { if (DaoTool.Update(dao, op, data) > -1) { msg = "更新设备统计类别信息成功!"; return("ok"); } else { throw new Exception("更新设备统计类别失败!" + dao.ErrMsg); } } } else { if (DaoTool.Update(dao, op, data) > -1) { msg = "更新设备统计类别信息成功!"; return("ok"); } else { throw new Exception("更新设备统计类别失败!" + dao.ErrMsg); } } } else { msg = "已经存在该统计类别名称!"; return("ok"); } } else { msg = "系统出错,请联系管理员!"; return("ok"); } }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { string ac = data.Sql; msg = ""; if ("setRole".Equals(ac)) { string dataRole = data.Param["roles"].ToString(); string userid = data.Param["userid"].ToString(); if (userid == null || userid.Trim().Length == 0) { throw new Exception("无效用户ID!"); } int i = 0; if (data.Param["have"].ToString().Equals("1")) { i = dao.ExecuteNonQuery("DELETE FROM T_HIS_RELUSERRIGHT WHERE userid=" + userid); } if (i >= 0) { if (dataRole != null && dataRole.Length > 0) { string[] rs = dataRole.Split(','); foreach (string r in rs) { if (dao.ExecuteNonQuery("INSERT INTO T_HIS_RELUSERRIGHT (userid,roleid) VALUES (" + userid + "," + r + ")") == -1) { throw new Exception("保存用户角色信息失败!"); } } } msg = "成功保存用户角色!"; } else { throw new Exception("删除原用户角色信息失败!"); } } else if ("setOpKF".Equals(ac)) { string dataKF = data.Param["kfID"].ToString(); string userid = data.Param["userid"].ToString(); string choscode = data.Param["choscode"].ToString(); if (userid == null || userid.Trim().Length == 0) { throw new Exception("无效用户ID!"); } int i = 0; if (data.Param["have"].ToString().Equals("1")) { i = dao.ExecuteNonQuery("DELETE FROM 可操作库房 WHERE userid=" + userid + " and choscode='" + choscode + "'"); } if (i >= 0) { if (dataKF != null && dataKF.Length > 0) { string[] rs = dataKF.Split(','); foreach (string r in rs) { if (dao.ExecuteNonQuery("INSERT INTO 可操作库房 (userid,kfid,choscode) VALUES (" + userid + "," + r + ",'" + choscode + "')") == -1) { throw new Exception("保存可操作库房信息失败!"); } } } msg = "成功保存可操作库房!"; } else { throw new Exception("删除原可操作库房信息失败!"); } } return("ok"); }