/// <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);
}
}
