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"); } }
bool saveRunDetail(YiTian.db.Dao dao, YtService.data.OptData data) { List <Dictionary <string, object> > mxli = ObjConvert.GetParamsByStr(data.Param["DanJuMx"].ToString()); Opt opt2 = OptContent.get("SaveEQOutDetailInfo"); foreach (Dictionary <string, object> d in mxli) { //d["DETAILNO"] = DaoTool.Seq(dao, "LKWZ.SEQWZInDetail"); d["OUTID"] = data.Param["OUTID"]; d["EQID"] = d["设备ID"]; d["UNITCODE"] = d["单位编码"]; d["GG"] = d["规格"]; d["XH"] = d["型号"]; d["CD"] = d["产地"]; d["NUM"] = d["数量"]; d["PRICE"] = d["单价"]; d["MONEY"] = d["金额"]; d["OTHERMONEY"] = d["运杂费"]; d["TOTALPRICE"] = d["成本单价"]; d["TOTALMONEY"] = d["成本金额"]; d["SUPPLYID"] = d["生产厂家ID"]; d["SUPPLYNAME"] = d["生产厂家"]; d["STOCKFLOWNO"] = d["库存流水号"]; d["PRODUCTDATE"] = Convert.ToDateTime(d["生产日期"]); d["VALIDDATE"] = Convert.ToDateTime(d["有效期"]); d["MEMO"] = d["备注"]; d["TXM"] = d["条形码"]; d["CHOSCODE"] = data.Param["CHOSCODE"]; if (!d["流水号"].ToString().Equals("")) { d["DETAILNO"] = d["流水号"].ToString(); if (DaoTool.Update(dao, opt2, d) < 0) { throw new Exception("保存单据明细失败!"); } } else { d["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQOutDetail"); 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) { if (data.Sql == null) { msg = "无效的SQL参数,不能继续执行操作!"; return("ok"); } if (data.Sql.Equals("ModifyOrAddInfo")) { if (data.Param["DEPREID"] == null || data.Param["DEPREID"].ToString() == "") { //新增 data.Param["DEPREID"] = DaoTool.Seq(dao, "LKEQ.SEQEQDepre"); if (DaoTool.Save(dao, OptContent.get("SaveEQDepreciationInfo_EQDepreciation"), data) > -1) { saveRunDetail(dao, data);//2代表新增 msg = "执行成功!"; return("ok"); } else { msg = "执行失败!"; throw new Exception("新增折旧主表信息失败!" + dao.ErrMsg); } } else { //修改 if (DaoTool.Update(dao, OptContent.get("SaveEQDepreciationInfo_EQDepreciation"), data) > -1) { saveRunDetail(dao, data); } else { 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 == 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) { 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) { //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) { msg = "厂商信息"; Dictionary <string, object> pa = new Dictionary <string, object>(); string ac = data.Sql; ObjItem Obj, Obj1, Obj2, Obj4; if ("SaveChangShangInfo".Equals(ac)) { pa["IFFACTORY"] = Convert.ToDecimal(data.Param["IFFACTORY"]); pa["IFSUPPLY"] = Convert.ToDecimal(data.Param["IFSUPPLY"]); pa["IFUSE"] = Convert.ToDecimal(data.Param["IFUSE"]); pa["USERID"] = Convert.ToDecimal(data.Param["USERID"]); pa["SUPPLYNAME"] = data.Param["SUPPLYNAME"].ToString(); pa["USERNAME"] = data.Param["USERNAME"].ToString(); pa["RECDATE"] = DateTime.Now; pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); if (data.Param["PYCODE"] != null) { pa["PYCODE"] = data.Param["PYCODE"].ToString(); } else { pa["PYCODE"] = null; } if (data.Param["WBCODE"] != null) { pa["WBCODE"] = data.Param["WBCODE"].ToString(); } else { pa["WBCODE"] = null; } if (data.Param["UNITPROPERTY"] != null) { pa["UNITPROPERTY"] = data.Param["UNITPROPERTY"].ToString(); } else { pa["UNITPROPERTY"] = null; } if (data.Param["QYDM"] != null) { pa["QYDM"] = data.Param["QYDM"].ToString(); } else { pa["QYDM"] = null; } if (data.Param["FRDB"] != null) { pa["FRDB"] = data.Param["FRDB"].ToString(); } else { pa["FRDB"] = null; } if (data.Param["UNITBANK"] != null) { pa["UNITBANK"] = data.Param["UNITBANK"].ToString(); } else { pa["UNITBANK"] = null; } if (data.Param["BANKACCOUNT"] != null) { pa["BANKACCOUNT"] = data.Param["BANKACCOUNT"].ToString(); } else { pa["BANKACCOUNT"] = null; } if (data.Param["ADDRESS"] != null) { pa["ADDRESS"] = data.Param["ADDRESS"].ToString(); } else { pa["ADDRESS"] = null; } if (data.Param["RELMAN"] != null) { pa["RELMAN"] = data.Param["RELMAN"].ToString(); } else { pa["RELMAN"] = null; } if (data.Param["RELPHONE"] != null) { pa["RELPHONE"] = data.Param["RELPHONE"].ToString(); } else { pa["RELPHONE"] = null; } if (data.Param["POST"] != null) { pa["POST"] = data.Param["POST"].ToString(); } else { pa["POST"] = null; } if (data.Param["FAX"] != null) { pa["FAX"] = data.Param["FAX"].ToString(); } else { pa["FAX"] = null; } if (data.Param["JYXKZ"] != null) { pa["JYXKZ"] = data.Param["JYXKZ"].ToString(); } else { pa["JYXKZ"] = null; } if (data.Param["YYZZ"] != null) { pa["YYZZ"] = data.Param["YYZZ"].ToString(); } else { pa["YYZZ"] = null; } if (data.Param["MEMO"] != null) { pa["MEMO"] = data.Param["MEMO"].ToString(); } else { pa["MEMO"] = null; } if (data.Param["TAXCODE"] != null) { pa["TAXCODE"] = data.Param["TAXCODE"].ToString(); } else { pa["TAXCODE"] = null; } if (data.Param["SUPPLYID"] == null)//新增 { pa["SUPPLYID"] = DaoTool.Seq(dao, "LKEQ.SEQEQSUPPLY"); Opt saveInfo = OptContent.get("EQSaveChangShangInfo"); Opt name = OptContent.get("EQSaveChangShangInfo_Name"); Obj = DaoTool.ExecuteScalar(dao, name, pa); if (!Obj.IsNull) { msg = "名称重复!"; return("ok"); } if (DaoTool.Save(dao, saveInfo, pa) < 0) { throw new Exception("添加厂商信息失败!"); } msg = "添加成功!"; return("ok"); } else //修改 { pa["SUPPLYID"] = Convert.ToDecimal(data.Param["SUPPLYID"]); Opt updataInfo = OptContent.get("EQUpdataChangShangInfo"); Opt updataname = OptContent.get("EQUpdataChangShangInfo_Name"); Obj = DaoTool.ExecuteScalar(dao, updataname, pa); if (!Obj.IsNull) { msg = "名称重复!"; return("ok"); } if (DaoTool.ExecuteNonQuery(dao, updataInfo, pa) < 0) { throw new Exception("修改厂商信息失败!"); } msg = "修改成功!"; return("ok"); } } if ("EQDelChangShangInfo".Equals(ac)) { Opt Del = OptContent.get("EQDelChangShangInfo"); pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["IFUSE"] = Convert.ToDecimal(data.Param["IFUSE"]); pa["SUPPLYID"] = data.Param["SUPPLYID"].ToString(); Opt values1 = OptContent.get("EQDelChangShangInfo_Use1"); Opt values2 = OptContent.get("EQDelChangShangInfo_Use2"); //Opt values3 = OptContent.get("EQDelChangShangInfo_Use3"); Opt values4 = OptContent.get("EQDelChangShangInfo_Use4"); Obj1 = DaoTool.ExecuteScalar(dao, values1, pa); Obj2 = DaoTool.ExecuteScalar(dao, values2, pa); //Obj3 = DaoTool.ExecuteScalar(dao, values3, pa);|| !Obj3.IsNull Obj4 = DaoTool.ExecuteScalar(dao, values4, pa); if (!Obj1.IsNull || !Obj2.IsNull || !Obj4.IsNull) { msg = "不能删除已使用的厂商,只能停用!"; return("ok"); } // //DaoTool. //if (Obj.ToString()=="1") //{ // msg = "已使用过,不能删除只能停用!"; // return "ok"; //} //string values1 = LData.Es("DelChangShangInfo_Use1", "LKWZ", new object[] { dr["厂商ID"], His.his.Choscode }); //string values2 = LData.Es("DelChangShangInfo_Use2", null, new object[] { dr["厂商ID"], His.his.Choscode }); //string values3 = LData.Es("DelChangShangInfo_Use3", null, new object[] { dr["厂商ID"], His.his.Choscode }); //string values4 = LData.Es("DelChangShangInfo_Use4", null, new object[] { dr["厂商ID"], His.his.Choscode }); if (DaoTool.ExecuteNonQuery(dao, Del, pa) < 0) { throw new Exception("删除厂商信息失败!"); } msg = "删除成功!"; return("ok"); } if ("StopWZSupplyInfo".Equals(ac)) { Opt stop = OptContent.get("EQStartOrStopChangShangInfo"); pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["SUPPLYID"] = data.Param["SUPPLYID"].ToString(); pa["IFUSE"] = 0; if (DaoTool.ExecuteNonQuery(dao, stop, pa) < 0) { throw new Exception("停用厂商信息失败!"); } msg = "停用成功!"; return("ok"); } if ("StartWZSupplyInfo".Equals(ac)) { Opt start = OptContent.get("EQStartOrStopChangShangInfo"); pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["SUPPLYID"] = data.Param["SUPPLYID"].ToString(); pa["IFUSE"] = 1; if (DaoTool.ExecuteNonQuery(dao, start, pa) < 0) { throw new Exception("启用厂商信息失败!"); } msg = "启用成功!"; return("ok"); } return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { msg = "设备信息"; Dictionary <string, object> pa = new Dictionary <string, object>(); string ac = data.Sql; ObjItem Obj, Obj1, Obj2, Obj3, Obj4, Obj5, Obj6, Obj8; if ("SaveDictEQInfo".Equals(ac)) { pa["EQNAME"] = data.Param["EQNAME"].ToString(); pa["KINDCODE"] = data.Param["KINDCODE"].ToString(); pa["COUNTCODE"] = data.Param["COUNTCODE"].ToString(); pa["UNITCODE"] = data.Param["UNITCODE"].ToString(); pa["IFJL"] = Convert.ToDecimal(data.Param["IFJL"]); pa["IFUSE"] = Convert.ToDecimal(data.Param["IFUSE"]); pa["ZJTYPE"] = Convert.ToDecimal(data.Param["ZJTYPE"]); pa["ZJRATE"] = Math.Round(Convert.ToDecimal(data.Param["ZJRATE"]), 2); pa["USERID"] = Convert.ToDecimal(data.Param["USERID"]); pa["RECDATE"] = DateTime.Now; pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); if (data.Param["WORKUNITCODE"] != null) { pa["WORKUNITCODE"] = data.Param["WORKUNITCODE"].ToString(); } else { pa["WORKUNITCODE"] = null; } if (data.Param["USERNAME"] != null) { pa["USERNAME"] = data.Param["USERNAME"].ToString(); } else { pa["USERNAME"] = null; } if (data.Param["PYCODE"] != null) { pa["PYCODE"] = data.Param["PYCODE"].ToString(); } else { pa["PYCODE"] = null; } if (data.Param["WBCODE"] != null) { pa["WBCODE"] = data.Param["WBCODE"].ToString(); } else { pa["WBCODE"] = null; } if (data.Param["SHORTNAME"] != null) { pa["SHORTNAME"] = data.Param["SHORTNAME"].ToString(); } else { pa["SHORTNAME"] = null; } if (data.Param["SHORTCODE"] != null) { pa["SHORTCODE"] = data.Param["SHORTCODE"].ToString(); } else { pa["SHORTCODE"] = null; } if (data.Param["ALIASNAME"] != null) { pa["ALIASNAME"] = data.Param["ALIASNAME"].ToString(); } else { pa["ALIASNAME"] = null; } if (data.Param["ALIASCODE"] != null) { pa["ALIASCODE"] = data.Param["ALIASCODE"].ToString(); } else { pa["ALIASCODE"] = null; } if (data.Param["GG"] != null) { pa["GG"] = data.Param["GG"].ToString(); } else { pa["GG"] = null; } if (data.Param["XH"] != null) { pa["XH"] = data.Param["XH"].ToString(); } else { pa["XH"] = null; } if (data.Param["PRODUCTPLACE"] != null) { pa["PRODUCTPLACE"] = data.Param["PRODUCTPLACE"].ToString(); } else { pa["PRODUCTPLACE"] = null; } if (data.Param["TXM"] != null) { pa["TXM"] = data.Param["TXM"].ToString(); } else { pa["TXM"] = null; } if (data.Param["MEMO"] != null) { pa["MEMO"] = data.Param["MEMO"].ToString(); } else { pa["MEMO"] = null; } if (data.Param["EQID"] == null) { pa["EQID"] = DaoTool.Seq(dao, "LKEQ.SEQEQ"); Opt saveInfo = OptContent.get("SaveDictEQInfo"); Opt name = OptContent.get("SaveDictEQInfo_Name"); Obj = DaoTool.ExecuteScalar(dao, name, pa); if (!Obj.IsNull) { msg = "名称重复!"; return("ok"); } if (DaoTool.Save(dao, saveInfo, pa) < 0) { throw new Exception("添加设备信息失败!"); } msg = "添加成功!"; return("ok"); } else { pa["EQID"] = Convert.ToDecimal(data.Param["EQID"]); Opt updataInfo = OptContent.get("UpdataDictEQInfoInfo"); Opt updataname = OptContent.get("UpdataDictEQInfoInfo_Name"); Obj = DaoTool.ExecuteScalar(dao, updataname, pa); if (!Obj.IsNull) { msg = "名称重复!"; return("ok"); } if (DaoTool.ExecuteNonQuery(dao, updataInfo, pa) < 0) { throw new Exception("修改设备信息失败!"); } msg = "修改成功!"; return("ok"); } } if ("DelEQDictInfo".Equals(ac)) { pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["EQID"] = Convert.ToDecimal(data.Param["EQID"]); Opt Del = OptContent.get("DelEQDictInfo"); Opt values1 = OptContent.get("DelEQDictInfo_Use1"); Opt values2 = OptContent.get("DelEQDictInfo_Use2"); Opt values3 = OptContent.get("DelEQDictInfo_Use3"); Opt values4 = OptContent.get("DelEQDictInfo_Use4"); Opt values5 = OptContent.get("DelEQDictInfo_Use5"); Opt values6 = OptContent.get("DelEQDictInfo_Use6"); //Opt values7 = OptContent.get("DelWZDictInfo_Use7");//有可能这里还有涉及到其他表的可能。 || !Obj7.IsNull Opt values8 = OptContent.get("DelEQDictInfo_Use8"); Obj1 = DaoTool.ExecuteScalar(dao, values1, pa); Obj2 = DaoTool.ExecuteScalar(dao, values2, pa); Obj3 = DaoTool.ExecuteScalar(dao, values3, pa); Obj4 = DaoTool.ExecuteScalar(dao, values4, pa); Obj5 = DaoTool.ExecuteScalar(dao, values5, pa); Obj6 = DaoTool.ExecuteScalar(dao, values6, pa); //Obj7 = DaoTool.ExecuteScalar(dao, values7, pa); Obj8 = DaoTool.ExecuteScalar(dao, values8, pa); if (!Obj1.IsNull || !Obj2.IsNull || !Obj3.IsNull || !Obj4.IsNull || !Obj5.IsNull || !Obj6.IsNull || !Obj8.IsNull) { msg = "不能删除已使用的设备,只能停用!"; return("ok"); } if (DaoTool.ExecuteNonQuery(dao, Del, pa) < 0) { throw new Exception("删除设备信息失败!"); } msg = "删除成功!"; return("ok"); } if ("StopEQDictInfo".Equals(ac)) { Opt stop = OptContent.get("StartOrStopEQDictInfo"); pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["EQID"] = data.Param["EQID"].ToString(); pa["IFUSE"] = 0; if (DaoTool.ExecuteNonQuery(dao, stop, pa) < 0) { throw new Exception("停用设备信息失败!"); } msg = "停用成功!"; return("ok"); } if ("StartEQDictInfo".Equals(ac)) { Opt start = OptContent.get("StartOrStopEQDictInfo"); pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["EQID"] = data.Param["EQID"].ToString(); pa["IFUSE"] = 1; if (DaoTool.ExecuteNonQuery(dao, start, pa) < 0) { throw new Exception("启用设备信息失败!"); } msg = "启用成功!"; return("ok"); } return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { if (data.Sql != null && data.Sql.Equals("UpdateEQStock")) { if (DaoTool.Update(dao, OptContent.get("SaveEQStockInfo"), data) > -1) { msg = "保存库存信息成功!"; return("ok"); } else { throw new Exception("保存库存信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("SaveEQStock")) { data.Param["STOCKID"] = DaoTool.Seq(dao, "LKEQ.SEQEQStock");; if (DaoTool.Save(dao, OptContent.get("SaveEQStockInfo"), data) < 0) { // msg = flowno+'+'+DETAILNO; throw new Exception("添加物资库存总表信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("RuKuDanEQdelete")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("DeleteEQInDetailInfo"), data) < 0) { throw new Exception("删除入库物资信息失败!"); } if (DaoTool.Update(dao, OptContent.get("SaveEQInMainInfo"), data) < 0) { throw new Exception("保存入库信息失败!" + dao.ErrMsg); } msg = "删除入库物资信息成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("RuKuDanDelete")) { data.Param["STATUS"] = 0; if (DaoTool.Update(dao, OptContent.get("SaveEQInMainInfo"), data) > -1) { msg = "删除入库信息成功!"; return("ok"); } else { throw new Exception("删除入库信息失败!" + dao.ErrMsg); } } if (data.Sql != null && data.Sql.Equals("RuKuDanUpdate")) { Opt op = OptContent.get("SaveEQInMainInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { // saveRunDetail(dao, data); if (data.Param["STATUS"].ToString() == "2") { msg = "审核信息成功!"; } else if (data.Param["STATUS"].ToString() == "1") { msg = "提交审核入库信息成功!"; } else if (data.Param["STATUS"].ToString() == "6") { msg = "审核入库信息成功!"; } else { msg = "入库成功!"; } return("ok"); } else { throw new Exception("保存入库信息失败!" + dao.ErrMsg); } } } if (data.Sql != null && data.Sql.Equals("CXData")) { Opt op = OptContent.get("SaveEQInMainInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { msg = "冲销成功!"; } else { throw new Exception("保存入库信息失败!" + dao.ErrMsg); } } Dictionary <string, object> dic1 = new Dictionary <string, object>(); dic1["INID"] = data.Param["INID"].ToString(); dic1["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); Opt op1 = OptContent.get("EQInMainInfo_CX"); Dictionary <string, object> dic = DaoTool.Get(dao, op1, dic1); dic["INID"] = DaoTool.Seq(dao, "LKEQ.SEQEQIn"); dic["STATUS"] = 7; dic["TOTALMONEY"] = "-" + dic["TOTALMONEY"].ToString(); dic["INVOICEMONEY"] = "-" + dic["INVOICEMONEY"].ToString(); dic["OTHERMONEY"] = "-" + dic["OTHERMONEY"].ToString(); Opt op2 = OptContent.get("SaveEQInMainInfo"); if (DaoTool.Save(dao, OptContent.get("SaveEQInMainInfo"), dic) > -1)//生成入库主表 { Opt op3 = OptContent.get("EQInDetailInfo_CX"); List <Dictionary <string, object> > lst = DaoTool.Find(dao, op3, data); if (lst != null) { foreach (Dictionary <string, object> dc in lst) { dc["NUM"] = "-" + dc["NUM"].ToString(); dc["MONEY"] = "-" + dc["MONEY"].ToString(); dc["OTHERMONEY"] = "-" + dc["OTHERMONEY"].ToString(); dc["TOTALPRICE"] = "-" + dc["TOTALPRICE"].ToString(); dc["TOTALMONEY"] = "-" + dc["TOTALMONEY"].ToString(); dc["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQInDetail"); dc["INID"] = dic["INID"]; Opt opt4 = OptContent.get("SaveEQInDetailInfo"); if (DaoTool.Save(dao, opt4, dc) < 0) //生成入库细表 { throw new Exception("保存单据明细失败!"); } Dictionary <string, object> dic2 = new Dictionary <string, object>(); Opt op5 = OptContent.get("EQIn_SearchEQStockNum"); Dictionary <string, object> dic3 = new Dictionary <string, object>(); dic3 = DaoTool.Get(dao, op5, dc); dic2["NUM"] = Convert.ToInt32(dic3["NUM"].ToString()) + Convert.ToInt32(dc["NUM"].ToString()); dic2["STOCKID"] = dic3["STOCKID"].ToString(); if (DaoTool.Update(dao, OptContent.get("SaveEQStockInfo"), dic2) > -1)//修改库存总表 { Dictionary <string, object> dic4 = new Dictionary <string, object>(); dic4["FLOWNO"] = dc["STOCKFLOWNO"]; dic4["NUM"] = dc["NUM"]; Opt op6 = OptContent.get("SaveEQStockDetailInfo"); if (DaoTool.Update(dao, op6, dic4) > -1)//修改库存细表 { } else { throw new Exception("保存设备库存流水信息失败!" + dao.ErrMsg); } } else { throw new Exception("保存库存信息失败!" + dao.ErrMsg); } } } } else { throw new Exception("保存入库单据失败!"); } msg = "冲销成功!"; return(msg); } if (data.Sql != null && data.Sql.Equals("SaveEQStockDetail")) { Opt op = OptContent.get("SaveEQStockDetailInfo"); 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["FLOWNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQStockDetail"); string flowno = data.Param["FLOWNO"].ToString(); string DETAILNO = data.Param["DETAILNO"].ToString(); if (DaoTool.Save(dao, op, data) < 0) { // msg = flowno+'+'+DETAILNO; throw new Exception("保存物资库存流水信息失败!" + dao.ErrMsg); } //更新入库细表中的对应库存流水号 //YtService.data.OptData d = new YtService.data.OptData(); //d.Param["STOCKFLOWNO"] = data.Param["FLOWNO"]; //d.Param["DETAILNO"] = data.Param["DETAILNO"]; //if (DaoTool.Update(dao, OptContent.get("SaveWZInDetailInfo"), d) < 0) //{ // throw new Exception("更新入库细表信息失败!" + dao.ErrMsg); //} return(msg = flowno + '+' + DETAILNO); } } if (data.Sql != null && data.Sql.Equals("UpdateEQInDetailInfo")) { if (DaoTool.Update(dao, OptContent.get("SaveEQInDetailInfo"), data) < 0) { throw new Exception("更新入库细表信息失败!" + dao.ErrMsg); } msg = "保存成功!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("RuKuDanSave")) { Opt op = OptContent.get("SaveEQInMainInfo"); if (data.Param.ContainsKey(op.Key)) { if (DaoTool.Update(dao, op, data) > -1) { saveRunDetail(dao, data); msg = "保存入库信息成功!"; return("ok"); } else { throw new Exception("保存入库信息失败!" + dao.ErrMsg); } } else { DataTable dt = dao.Fd(OptContent.get("EQSearchDicEQInOut").Sql, new object[] { data.Param["IOID"].ToString() }); data.Param["OPFLAG"] = dt.Rows[0]["OPFLAG"].ToString(); data.Param["INID"] = DaoTool.Seq(dao, "LKEQ.SEQEQIn"); string recipe = dt.Rows[0]["RECIPECODE"].ToString(); if (Convert.ToDecimal(dt.Rows[0]["RECIPEYEAR"]) == 1) { recipe += DateTime.Now.Year.ToString(); } if (Convert.ToDecimal(dt.Rows[0]["RECIPEMONTH"]) == 1) { if (DateTime.Now.Month < 10) { recipe = recipe + "0" + DateTime.Now.Month.ToString(); } else { recipe += DateTime.Now.Month.ToString(); } } decimal recipeno = Convert.ToDecimal(dao.ExecuteScalar(OptContent.get("EQGetRecipeNo").Sql, new object[] { recipe + '%' })) + 1; if (recipeno > 0 && recipeno < 10) { recipe = recipe + "0" + recipeno.ToString(); } else { recipe = recipe + recipeno.ToString(); } data.Param["RECIPECODE"] = recipe; data.Param["INDATE"] = DateTime.Now; data.Param["STATUS"] = 1; if (DaoTool.Save(dao, OptContent.get("SaveEQInMainInfo"), data) > -1) { saveRunDetail(dao, data); } else { throw new Exception("保存入库单据失败!"); } } } msg = "保存成功!"; return("ok"); }
public object Run(YiTian.db.Dao dao, YtService.data.OptData data, out string msg) { msg = "请购信息"; Dictionary <string, object> pa = new Dictionary <string, object>(); string ac = data.Sql; //ObjItem Obj,Obj1,Obj2,Obj3,Obj4; if ("SaveEQAskBuyInfo".Equals(ac)) { pa["DEPTID"] = Convert.ToDecimal(data.Param["DEPTID"]); pa["EQID"] = Convert.ToDecimal(data.Param["EQID"]); pa["EQNAME"] = data.Param["EQNAME"].ToString(); pa["COUNTRY"] = data.Param["COUNTRY"].ToString(); pa["UNITCODE"] = data.Param["UNITCODE"].ToString(); pa["APPLYNUM"] = Convert.ToDecimal(data.Param["APPLYNUM"]); if (data.Param["YJPRICE"] != null && data.Param["YJPRICE"].ToString().Trim().Length > 0) { pa["YJPRICE"] = Math.Round(Convert.ToDecimal(data.Param["YJPRICE"]), 2); } else { pa["YJPRICE"] = null; } pa["YJMONEY"] = Math.Round(Convert.ToDecimal(data.Param["YJMONEY"]), 2); pa["PLANDATE"] = Convert.ToDateTime(data.Param["PLANDATE"]); pa["STATUS"] = Convert.ToDecimal(data.Param["STATUS"]); pa["USERID"] = Convert.ToDecimal(data.Param["USERID"]); pa["RECDATE"] = DateTime.Now; pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); if (data.Param["GG"] != null) { pa["GG"] = data.Param["GG"].ToString(); } else { pa["GG"] = null; } if (data.Param["XH"] != null) { pa["XH"] = data.Param["XH"].ToString(); } else { pa["XH"] = null; } if (data.Param["REASON"] != null) { pa["REASON"] = data.Param["REASON"].ToString(); } else { pa["REASON"] = null; } if (data.Param["XYFX"] != null) { pa["XYFX"] = data.Param["XYFX"].ToString(); } else { pa["XYFX"] = null; } if (data.Param["PTTJ"] != null) { pa["PTTJ"] = data.Param["PTTJ"].ToString(); } else { pa["PTTJ"] = null; } if (data.Param["MEMO"] != null) { pa["MEMO"] = data.Param["MEMO"].ToString(); } else { pa["MEMO"] = null; } if (data.Param["USERNAME"] != null) { pa["USERNAME"] = data.Param["USERNAME"].ToString(); } else { pa["USERNAME"] = null; } if (data.Param["APPLYID"] == null) { pa["APPLYID"] = DaoTool.Seq(dao, "LKEQ.SEQEQApply"); Opt saveInfo = OptContent.get("SaveEQAskBuyInfo"); if (DaoTool.Save(dao, saveInfo, pa) < 0) { throw new Exception("添加请购信息失败!"); } msg = "添加成功!"; return("ok"); } else { pa["APPLYID"] = Convert.ToDecimal(data.Param["APPLYID"]); Opt updataInfo = OptContent.get("UpdataEQAskBuyInfo"); if (DaoTool.ExecuteNonQuery(dao, updataInfo, pa) < 0) { throw new Exception("修改请购信息失败!"); } msg = "修改成功!"; return("ok"); } } if ("DelEQAskBuyInfo".Equals(ac)) { pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["APPLYID"] = Convert.ToDecimal(data.Param["APPLYID"]); pa["STATUS"] = 0; Opt Del = OptContent.get("DelEQAskBuyInfo"); if (DaoTool.ExecuteNonQuery(dao, Del, pa) < 0) { throw new Exception("删除请购信息失败!"); } msg = "删除成功!"; return("ok"); } if ("Submit_EQAskBuyInfo".Equals(ac)) { pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["APPLYID"] = Convert.ToDecimal(data.Param["APPLYID"]); pa["STATUS"] = 1; Opt Del = OptContent.get("Submit_EQAskBuyInfo"); if (DaoTool.ExecuteNonQuery(dao, Del, pa) < 0) { throw new Exception("提交请购信息失败!"); } msg = "提交成功!"; return("ok"); } if ("EQAskBuyInfo_SHCG".Equals(ac)) { Opt stop = OptContent.get("EQAskBuyInfo_SHCG"); pa["APPLYID"] = Convert.ToDecimal(data.Param["APPLYID"]); pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["SHNUM"] = Convert.ToDecimal(data.Param["SHNUM"]); pa["RECDATE"] = DateTime.Now; pa["SHDATE"] = Convert.ToDateTime(data.Param["SHDATE"]); pa["SHUSERID"] = Convert.ToDecimal(data.Param["SHUSERID"]); pa["STATUS"] = 6; if (data.Param["SHUSERNAME"] != null) { pa["SHUSERNAME"] = data.Param["SHUSERNAME"].ToString(); } else { pa["SHUSERNAME"] = null; } if (DaoTool.ExecuteNonQuery(dao, stop, pa) < 0) { throw new Exception("审核操作失败!"); } msg = "审核操作成功!"; return("ok"); } if ("EQAskBuyInfo_SHSB".Equals(ac)) { Opt start = OptContent.get("EQAskBuyInfo_SHSB"); pa["CHOSCODE"] = data.Param["CHOSCODE"].ToString(); pa["APPLYID"] = Convert.ToDecimal(data.Param["APPLYID"]); pa["STATUS"] = 2; if (DaoTool.ExecuteNonQuery(dao, start, pa) < 0) { throw new Exception("审核操作失败!"); } msg = "审核操作成功!"; return("ok"); } 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) { 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) { #region 前期的一些绑定 if (data.Sql == null) { msg = "缺省SQL参数,无法再服务端进行操作!"; return("ok"); } if (data.Sql != null && data.Sql.Equals("BindWareName")) { msg = "绑定成功"; return(DaoTool.FindDT(dao, OptContent.get("FindWareNameInEQDiaoBo"), data)); } if (data.Sql != null && data.Sql.Equals("BindOutName")) { msg = "绑定成功"; return(DaoTool.FindDT(dao, OptContent.get("FindOutNameInEQDiaoBo"), data)); } if (data.Sql != null && data.Sql.Equals("BindUnitCode")) { msg = "绑定成功"; return(DaoTool.FindDT(dao, OptContent.get("FindUnitNameInEQDiaoBo"), data)); } if (data.Sql != null && data.Sql.Equals("BindEQIDInfo")) { msg = "绑定成功"; return(DaoTool.FindDT(dao, OptContent.get("FindEQIdNameInEQDiaoBo"), data)); } //包含 提交审核与软删除 if (data.Sql != null && data.Sql == "SubmitShenHeOrDel") { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("submitShenHeInfo"), data) < 0) { throw new Exception("更改设备调拨的审核状态信息失败!"); } msg = "执行成功!"; return("ok"); } #endregion //对主表的操作 if (data.Sql != null && data.Sql.Equals("ModifyZhuOrAdd")) { //1、对OUTMAIN进行更新操作 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); } SaveDiaoBoXiInfo(dao, data); msg = "执行成功!"; return("ok"); } if (DaoTool.Update(dao, OptContent.get("ModifyOutMainInfo"), data) < 0) { msg = "执行失败!"; throw new Exception("修改设备调拨的主表信息失败!" + dao.ErrMsg); } SaveDiaoBoXiInfo(dao, data); msg = "执行成功!"; return("ok"); } // ModifyOrAddXi if (data.Sql.Equals("ModifyOrAddXi")) { //如果出库ID为空的话 肯定是新增操作 if (data.Param["OUTID"].ToString().Trim() == "" || data.Param["OUTID"] == null) { data.Param["OUTID"] = OutIdHelp; data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQOutDetail"); if (DaoTool.Save(dao, OptContent.get("ModifyOutXiBiaoInfo"), data) < 0) { 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 != null && data.Sql.Equals("ShenHeOutEQInfo")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("ShenHeEQOutAndDetailInfo"), data) > 0) { msg = "执行成功!"; return("ok"); } else { msg = "执行失败!"; throw new Exception("审核过程中,数据库操作失败!" + dao.ErrMsg); } } if (data.Sql.Equals("SendOutId")) { OutId = data.Param["OUTID"].ToString(); msg = "执行成功!"; return("ok"); } //===================================审核部分=============================== //入库主表 if (data.Sql != null && 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(); if (DaoTool.Save(dao, OptContent.get("SaveEQInMainInfoCX"), data) < 0) { throw new Exception("入库主表信息执行失败" + dao.ErrMsg); } //记得更新对应出库主表的INID dao.ExecuteNonQuery("UPDATE LKEQ.EQOUTMAIN SET INID=" + data.Param["INID"].ToString() + " WHERE CHOSCODE=" + data.Param["CHOSCODE"] + " AND OUTID=" + OutId); msg = "执行成功!"; return("ok"); } //库存主表 可能不会执行 【只有在库存主表,不存在该设备的信息】 if (data.Sql != null && data.Sql.Equals("InsertStockMain")) { data.Param["STOCKID"] = DaoTool.Seq(dao, "LKEQ.SEQEQSTOCK"); //在每执行一次对库存总表的插入,都会更新一次stockid,否则,就是针对一个stockid的插入流水了 StockId = data.Param["STOCKID"].ToString(); if (DaoTool.Save(dao, OptContent.get("SaveEQStock"), data) < 0) { throw new Exception("库存主表信息执行失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //库存流水 if (data.Sql != null && data.Sql.Equals("InsertStockDetail")) { data.Param["FLOWNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQSTOCKDETAIL"); StockFlowNo = data.Param["FLOWNO"].ToString(); data.Param["RECIPECODE"] = RecipeCodeInMain; if (data.Param["STOCKID"] == null || data.Param["STOCKID"].ToString() == "") { data.Param["STOCKID"] = StockId;//在客户端已经经过了判断,要么存在,要么不存在就是库存总表进行了新的插入,直接获取 } if (DaoTool.Save(dao, OptContent.get("SaveEQStockDetail"), data) < 0) { throw new Exception("库存流水信息执行失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //入库细表 if (data.Sql != null && data.Sql.Equals("InsertEQInDetail")) { data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQINDETAIL"); data.Param["STOCKFLOWNO"] = StockFlowNo.ToString(); data.Param["INID"] = InIdHelp; if (DaoTool.Save(dao, OptContent.get("SaveEQInDetail"), data) < 0) { throw new Exception("入库细表信息执行失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //=================================关于冲销的操作========================== //原始数据的状态更改 if (data.Sql != null && data.Sql.Equals("ChongXiaoRuChu")) { if (DaoTool.ExecuteNonQuery(dao, OptContent.get("ChongXiaoChuKuStatusChange"), data) < 0) { throw new Exception("修改出库主表冲销状态失败!" + dao.ErrMsg); } data.Param.Add("INID", dao.Es("SELECT INID FROM LKEQ.EQOUTMAIN WHERE OUTID=" + data.Param["OUTID"].ToString()).ToString()); if (DaoTool.ExecuteNonQuery(dao, OptContent.get("ChongXiaoRuKuStatusChange"), data) < 0) { throw new Exception("修改入库主表冲销状态失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //插入出库主表 if (data.Sql != null && data.Sql.Equals("ChongXiaoZhuChuKu")) { data.Param["OUTID"] = DaoTool.Seq(dao, "LKEQ.SEQEQOut"); OutIdCX = data.Param["OUTID"].ToString(); if (DaoTool.Save(dao, OptContent.get("ModifyOutMainInfo"), data) < 0) { 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"] = OutIdCX; if (DaoTool.Save(dao, OptContent.get("ModifyOutXiBiaoInfo"), data) < 0) { throw new Exception("插入冲销出库细表失败!" + dao.ErrMsg); } msg = "执行成功!"; return("ok"); } //入库主表 if (data.Sql != null && data.Sql.Equals("ChongXiaoZhuRuKu")) { data.Param["INID"] = DaoTool.Seq(dao, "LKEQ.SEQEQIN"); InIdCX = 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=" + OutIdCX); msg = "执行成功!"; return("ok"); } //入库细表 if (data.Sql != null && data.Sql.Equals("ChongXiaoXiRuKu")) { data.Param["DETAILNO"] = DaoTool.Seq(dao, "LKEQ.SEQEQINDETAIL"); data.Param["INID"] = InIdCX; 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) { 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) { 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"); }