private static WorkBean tryGetWorkBeanValue(string ip) { WorkBean work = new WorkBean(); bool exist = workMap.TryGetValue(ip, out work); return(work); }
public static void insertUserDataToWorkBean(UserBean bean)//读卡器读到卡号 { /*** * 接收到一个用户刷卡信息 * 1、查看卡号是否存在用户表中(可不做要求cjc) * 2、查看关联表中,是否存在读卡器IP * 3、记录 * * 一个IP对应一个读卡器, * 查看workMap中是否有 */ // TODO 从用户表中通过卡号查找用户信息在给到bean WorkBean work = tryGetWorkBeanValue(bean.Ip); if (work != null) { if (!work.Card.Equals(bean.Card))//判断存在卡号是否与当前刷的卡号一致 不一致则移除后新增 { workMap.Remove(bean.Ip); workMap.Add(bean.Ip, insertUserToMap(bean)); } } else { workMap.Add(bean.Ip, insertUserToMap(bean)); } }
private static WorkBean insertWeightToMap(WorkBean workBean, DZCBean bean) { workBean.WeiIp = bean.Ip; workBean.Weight = bean.Weight; workBean.Data = bean.Data; workBean.Unit = bean.Unit; return(workBean); }
private static WorkBean insertUserToMap(UserBean bean) { WorkBean workBean = new WorkBean(); workBean.UserIp = bean.Ip; workBean.UserId = bean.Num; workBean.Name = bean.Name; workBean.Card = bean.Card; return(workBean); }
public ResultBean insertWeightDataToWorkBean(DZCBean bean)//电子秤读到重量 { ResultBean result = new ResultBean(); bool success = false; string msg = ""; ConnBean conn = new ConnBean(); bool connExist = connMap.TryGetValue(bean.Ip, out conn);//通过关联表中找到读卡器IP if (conn != null) { if (conn.Ip3 != null) //读卡器IP { WorkBean work = tryGetWorkBeanValue(conn.Ip3); //通过读卡器IP得到已经保存的刷卡信息 if (work != null) { work = insertWeightToMap(work, bean); saveWork(work);//保存信息 success = true; msg = "数据保存成功"; result.IsLow = (bean.Weight - conn.Weight) < 0.00000001;//低重 result.Value1 = bean.Weight + ""; result.Value2 = conn.Weight + ""; result.Msg2 = "低重,发送报警。报警重量:" + conn.Weight + ",当前重量:" + bean.Weight;//在IsLow为true时才正确 result.Bean = conn; } else { msg = "电子称 " + conn.Ip + " 未有用户刷卡,重量数据不保存"; } } else { msg = "电子称 " + conn.Ip + " 关联的读卡器 " + conn.Ip3 + " 不存在"; } } else { msg = "关联表中不存在电子秤IP:" + bean.Ip + "的报警器及读卡器关联信息"; } result.Success = success; result.Msg = msg; return(result); }
//保存用户称药数据信息 public Boolean saveWork(WorkBean b) { if (b == null) { return(false); } //CJC需要处理部分 LogUtil.instance.Log("-------开始保存数据-------");//"insert into work(weighter_ip) values('127.168.3.78')" string sql = "insert into work(user_id,user_name,user_card,user_ip,weighter_ip,weight,data,unit) values(" + b.UserId + ",'" + b.Name + "','" + b.Card + "','" + b.UserIp + "','" + b.WeiIp + "','" + b.Weight + "','" + b.Data + "','" + b.Unit + "')"; LogUtil.instance.Log(sql);//日志输出 cmd.CommandText = sql; int count = Convert.ToInt32(cmd.ExecuteScalar()); Console.WriteLine("数据库保存结果:" + count); return(true); }