public int IntMax(Dictionary <Characteristics, int> characteristics) { int intMax; if (Int32.TryParse(Max, out intMax)) { return(intMax); } else { if (Max.Contains("Bonus")) { intMax = Convert.ToInt32(Math.Floor(characteristics[CharacteristicValueConverter.Convert[Max.Remove(Max.IndexOf(" Bonus"))]] / 10.0)); } } return(intMax); }
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("系统出错,请与管理员联系!"); } }