public void saveShdz(HttpContext context)
{
try
{
Interfaces.Service.FenceService dbserv = new Interfaces.Service.FenceService();
string json = context.Request.Params["json"];
string cxh = context.Request.Params["cxh"];
yw_wldw_gnkh_shdzEntity model = JsonConvert.DeserializeObject <yw_wldw_gnkh_shdzEntity>(json);
if (string.IsNullOrEmpty(model.shdz))
{
throw new Exception("收货地址不能为空");
}
if (string.IsNullOrEmpty(cxh))
{
dbserv.addShdz(model);
}
else
{
dbserv.updateBaseShdz(model);
}
res.result = true;
}
catch (Exception ex)
{
res.result = true;
res.msg = ex.Message;
}
}
public void updateElectronicFence(HttpContext context)
{
try
{
string json = context.Request.Params["json"];
writeLog(json);
authorityCheck(context);
ElectronicFence param = JsonConvert.DeserializeObject <ElectronicFence>(json);
string[] id = param.uniqueId.Split('_');
yw_wldw_gnkh_shdzEntity m = new yw_wldw_gnkh_shdzEntity();
m.yw_khbm = id[0];
m.cxh = id[1];
if (param.style == "circle")
{
m.type = 0;
m.fw = param.radius;
m.jd = param.lng;
m.wd = param.lat;
}
else
{
m.type = 1;
m.points = param.points;
}
new Interfaces.Service.FenceService().updateShdz(m);
res.result = true;
}
catch (Exception ex)
{
res.msg = ex.Message;
res.result = false;
writeLog("updateElectronicFence出现异常：" + ex.Message);
}
}
public void getCreatFenceUrl(HttpContext context)
{
string createFenceBaseUrl = baseUrl + "/showFenceInfoPage.do";
string logid = context.Request.Params["logid"];
string token = HttpUtility.UrlEncode(DESEncrypt(userid));
yw_wldw_gnkh_shdzEntity m1 = JsonConvert.DeserializeObject <yw_wldw_gnkh_shdzEntity>(context.Request.Params["json"]);
ElectronicFence m = new ElectronicFence();
m.uniqueId = m1.yw_khbm + "_" + m1.cxh;
m.userId = userid;
m.lat = m1.wd;
m.lng = m1.jd;
m.radius = m1.fw;
m.address = m1.shdz;
m.style = m1.type == 1 ? "polygon" : "circle";
if (!string.IsNullOrEmpty(m1.points))
{
m.points = m1.points.Replace("\"", "\'");
}
var json = JsonConvert.SerializeObject(m, setting);
string param = "?userId=" + userid + "&token=" + token + "&tools=1&json=" + HttpUtility.UrlEncode(json);
res.data = createFenceBaseUrl + param;
}
public void updateShdz(yw_wldw_gnkh_shdzEntity model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql = " update yw_wldw_gnkh_shdz set jd=@jd,wd=@wd,fw=@fw,type=@type,points=@points where yw_khbm=@yw_khbm and cxh=@cxh ";
conn.Execute(sql, model);
}
}
/// <summary>
/// 修改基本信息
/// </summary>
/// <param name="model"></param>
public void updateBaseShdz(yw_wldw_gnkh_shdzEntity model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql = " update yw_wldw_gnkh_shdz set shdz=@shdz,dz_sf=@dz_sf,dz_dq=@dz_dq,dz_lm=@dz_lm,sfgx=@sfgx,scmc=@scmc where yw_khbm=@yw_khbm and cxh=@cxh ";
conn.Execute(sql, model);
}
}
public void addShdz(yw_wldw_gnkh_shdzEntity model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
model.cxh = getNewCxh(model.yw_khbm).ToString();
model.lrrq = DateTime.Now;
string sql = " insert into yw_wldw_gnkh_shdz (yw_khbm,cxh,shdz,dz_sf,dz_dq,dz_lm,sfgx,scmc)values(@yw_khbm,@cxh,@shdz,@dz_sf,@dz_dq,@dz_lm,@sfgx,@scmc) ";
conn.Execute(sql, model);
}
}
