/// <summary> /// 增加一条数据 /// </summary> public int Add(JMP.MDL.jmp_terminal model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into jmp_terminal("); strSql.Append("t_system,t_hardware,t_sdkver,t_time,t_screen,t_network,t_appid,t_key,t_mark,t_ip,t_province,t_imsi,t_nettype,t_brand"); strSql.Append(") values ("); strSql.Append("@t_system,@t_hardware,@t_sdkver,@t_time,@t_screen,@t_network,@t_appid,@t_key,@t_mark,@t_ip,@t_province,@t_imsi,@t_nettype,@t_brand"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@t_system", SqlDbType.NVarChar, -1), new SqlParameter("@t_hardware", SqlDbType.NVarChar, -1), new SqlParameter("@t_sdkver", SqlDbType.NVarChar, -1), new SqlParameter("@t_time", SqlDbType.DateTime), new SqlParameter("@t_screen", SqlDbType.NVarChar, -1), new SqlParameter("@t_network", SqlDbType.NVarChar, -1), new SqlParameter("@t_appid", SqlDbType.Int, 4), new SqlParameter("@t_key", SqlDbType.NVarChar, -1), new SqlParameter("@t_mark", SqlDbType.NVarChar, -1), new SqlParameter("@t_ip", SqlDbType.NVarChar, -1), new SqlParameter("@t_province", SqlDbType.NVarChar, -1), new SqlParameter("@t_imsi", SqlDbType.NVarChar, -1), new SqlParameter("@t_nettype", SqlDbType.NVarChar, -1), new SqlParameter("@t_brand", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.t_system; parameters[1].Value = model.t_hardware; parameters[2].Value = model.t_sdkver; parameters[3].Value = model.t_time; parameters[4].Value = model.t_screen; parameters[5].Value = model.t_network; parameters[6].Value = model.t_appid; parameters[7].Value = model.t_key; parameters[8].Value = model.t_mark; parameters[9].Value = model.t_ip; parameters[10].Value = model.t_province; parameters[11].Value = model.t_imsi; parameters[12].Value = model.t_nettype; parameters[13].Value = model.t_brand; object obj = DbHelperSQLDEVICE.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 得到一个对象实体 /// </summary> public JMP.MDL.jmp_terminal GetModel(int t_id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select t_id, t_system, t_hardware, t_sdkver, t_time, t_screen, t_network, t_appid, t_key, t_mark, t_ip, t_province, t_imsi, t_nettype, t_brand "); strSql.Append(" from jmp_terminal "); strSql.Append(" where t_id=@t_id"); SqlParameter[] parameters = { new SqlParameter("@t_id", SqlDbType.Int, 4) }; parameters[0].Value = t_id; JMP.MDL.jmp_terminal model = new JMP.MDL.jmp_terminal(); DataSet ds = DbHelperSQLDEVICE.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["t_id"].ToString() != "") { model.t_id = int.Parse(ds.Tables[0].Rows[0]["t_id"].ToString()); } model.t_system = ds.Tables[0].Rows[0]["t_system"].ToString(); model.t_hardware = ds.Tables[0].Rows[0]["t_hardware"].ToString(); model.t_sdkver = ds.Tables[0].Rows[0]["t_sdkver"].ToString(); if (ds.Tables[0].Rows[0]["t_time"].ToString() != "") { model.t_time = DateTime.Parse(ds.Tables[0].Rows[0]["t_time"].ToString()); } model.t_screen = ds.Tables[0].Rows[0]["t_screen"].ToString(); model.t_network = ds.Tables[0].Rows[0]["t_network"].ToString(); if (ds.Tables[0].Rows[0]["t_appid"].ToString() != "") { model.t_appid = int.Parse(ds.Tables[0].Rows[0]["t_appid"].ToString()); } model.t_key = ds.Tables[0].Rows[0]["t_key"].ToString(); model.t_mark = ds.Tables[0].Rows[0]["t_mark"].ToString(); model.t_ip = ds.Tables[0].Rows[0]["t_ip"].ToString(); model.t_province = ds.Tables[0].Rows[0]["t_province"].ToString(); model.t_imsi = ds.Tables[0].Rows[0]["t_imsi"].ToString(); model.t_nettype = ds.Tables[0].Rows[0]["t_nettype"].ToString(); model.t_brand = ds.Tables[0].Rows[0]["t_brand"].ToString(); return(model); } else { return(null); } }
/// <summary> /// 初始化接口 /// </summary> /// <param name="encryption"></param> /// <returns></returns> public string InfoInterface(ModelZd zd, string encryption, string ip) { object json = ""; // ModelZd zd = new ModelZd(); JMP.MDL.jmp_terminal model = new JMP.MDL.jmp_terminal(); //终端属性实体类型 JMP.MDL.jmp_liveteral mo = new JMP.MDL.jmp_liveteral(); //活跃实体类型 JMP.BLL.jmp_terminal zdbll = new JMP.BLL.jmp_terminal(); //终端属性业务逻辑层 JMP.BLL.jmp_liveteral hybll = new JMP.BLL.jmp_liveteral(); //活跃业务逻辑层 // zd = JMP.TOOL.JsonHelper.Deserializes<ModelZd>(encryption); #region 处理初始化数据 if (zd != null) { #region 判断参数 model.t_key = zd.t_key; JMP.BLL.jmp_app appbll = new JMP.BLL.jmp_app(); //应用业务逻辑层 DataTable dt = new DataTable(); if (JMP.TOOL.CacheHelper.IsCache(zd.t_appkey)) //判读是否存在缓存 { dt = JMP.TOOL.CacheHelper.GetCaChe <DataTable>(zd.t_appkey); //获取缓存 model.t_appid = string.IsNullOrEmpty(dt.Rows[0]["a_id"].ToString()) ? 0 : Int32.Parse(dt.Rows[0]["a_id"].ToString()); model.t_appkey = zd.t_appkey; } else { dt = appbll.GetListjK(zd.t_appkey).Tables[0]; if (dt.Rows.Count > 0) { model.t_appkey = zd.t_appkey; model.t_appid = string.IsNullOrEmpty(dt.Rows[0]["a_id"].ToString()) ? 0 : Int32.Parse(dt.Rows[0]["a_id"].ToString()); JMP.TOOL.CacheHelper.CacheObjectLocak <DataTable>(dt, zd.t_appkey, 5);//存入缓存 } else { return((json = "{\"message\":\"应用无效\",\"result\":9995}").ToString()); } } model.t_mark = zd.t_mark; model.t_network = zd.t_network; //model.t_ip = HttpContext.Current.Request.UserHostAddress; model.t_ip = string.IsNullOrEmpty(ip) ? "" : ip; //string IP = IPAddress.GetAddressByIp(model.t_ip.Split(':')[0].ToString()); string ipstr = ConfigurationManager.AppSettings["ipkstr"].ToString();//获取ip库文件地址 model.t_province = JMP.TOOL.IpProvince.IpAddress(model.t_ip, ipstr); //model.t_province = ""; model.t_imsi = zd.t_imsi; if (model.t_imsi == "404") { model.t_nettype = "其他"; } else { if (model.t_imsi.Length >= 5) { string wlxx = model.t_imsi.Substring(0, 5); if (wlxx == "46000" || wlxx == "46002" || wlxx == "46007" || wlxx == "46020") { model.t_nettype = "移动"; } else if (wlxx == "46003" || wlxx == "46005" || wlxx == "46011") { model.t_nettype = "电信"; } else if (wlxx == "46001" || wlxx == "46006" || wlxx == "46010") { model.t_nettype = "联通"; } else { model.t_nettype = "其他"; } } else { model.t_nettype = "其他"; } } model.t_brand = zd.t_brand; model.t_system = zd.t_system; model.t_hardware = zd.t_hardware; model.t_screen = zd.t_screen; model.t_sdkver = zd.t_sdkver; #endregion int cg = 0; if (zd.t_isnew == 1) { #region 活跃用户 mo.l_teral_key = model.t_key; mo.l_time = DateTime.Now; mo.l_appkey = model.t_appkey; mo.l_appid = model.t_appid; cg = hybll.Add(mo); #endregion } else { #region 新增用户 model.t_time = DateTime.Now; cg = zdbll.Add(model); #endregion } if (cg > 0) { json = "{\"message\":\"成功\",\"result\":100}"; } else { json = "{\"message\":\"失败\",\"error\":101}"; AddLocLog.AddLog(1, 4, HttpContext.Current.Request.UserHostAddress, "接口错误信息", "报错信息:终端属性添加失败");//写入报错日志 } } else { json = "{\"message\":\"json解析出错\",\"error\":9999}"; AddLocLog.AddLog(1, 4, HttpContext.Current.Request.UserHostAddress, "接口错误信息", "报错信息:终端属性参数为传入");//写入报错日志 } return(json.ToString()); #endregion }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(JMP.MDL.jmp_terminal model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update jmp_terminal set "); strSql.Append(" t_system = @t_system , "); strSql.Append(" t_hardware = @t_hardware , "); strSql.Append(" t_sdkver = @t_sdkver , "); strSql.Append(" t_time = @t_time , "); strSql.Append(" t_screen = @t_screen , "); strSql.Append(" t_network = @t_network , "); strSql.Append(" t_appid = @t_appid , "); strSql.Append(" t_key = @t_key , "); strSql.Append(" t_mark = @t_mark , "); strSql.Append(" t_ip = @t_ip , "); strSql.Append(" t_province = @t_province , "); strSql.Append(" t_imsi = @t_imsi , "); strSql.Append(" t_nettype = @t_nettype , "); strSql.Append(" t_brand = @t_brand "); strSql.Append(" where t_id=@t_id "); SqlParameter[] parameters = { new SqlParameter("@t_id", SqlDbType.Int, 4), new SqlParameter("@t_system", SqlDbType.NVarChar, -1), new SqlParameter("@t_hardware", SqlDbType.NVarChar, -1), new SqlParameter("@t_sdkver", SqlDbType.NVarChar, -1), new SqlParameter("@t_time", SqlDbType.DateTime), new SqlParameter("@t_screen", SqlDbType.NVarChar, -1), new SqlParameter("@t_network", SqlDbType.NVarChar, -1), new SqlParameter("@t_appid", SqlDbType.Int, 4), new SqlParameter("@t_key", SqlDbType.NVarChar, -1), new SqlParameter("@t_mark", SqlDbType.NVarChar, -1), new SqlParameter("@t_ip", SqlDbType.NVarChar, -1), new SqlParameter("@t_province", SqlDbType.NVarChar, -1), new SqlParameter("@t_imsi", SqlDbType.NVarChar, -1), new SqlParameter("@t_nettype", SqlDbType.NVarChar, -1), new SqlParameter("@t_brand", SqlDbType.NVarChar, -1) }; parameters[0].Value = model.t_id; parameters[1].Value = model.t_system; parameters[2].Value = model.t_hardware; parameters[3].Value = model.t_sdkver; parameters[4].Value = model.t_time; parameters[5].Value = model.t_screen; parameters[6].Value = model.t_network; parameters[7].Value = model.t_appid; parameters[8].Value = model.t_key; parameters[9].Value = model.t_mark; parameters[10].Value = model.t_ip; parameters[11].Value = model.t_province; parameters[12].Value = model.t_imsi; parameters[13].Value = model.t_nettype; parameters[14].Value = model.t_brand; int rows = DbHelperSQLDEVICE.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }