public void UpdateWlgzCmdOutPort(yw_hddz_wlgz_cmdEntity model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
StringBuilder sql = new StringBuilder();
sql.Append("update yw_hddz_wlgz_cmd set ");
sql.Append(" cdzwlsj_bd =@cdzwlsj ");
sql.Append(" where rwbh=@rwbh and wlxh=@wlxh");
conn.Execute(sql.ToString(), model);
}
}
public void UpdateInOrOutFence(HttpContext context)
{
try
{
string json = context.Request.Params["json"];
writeLog(json, "fence");
authorityCheck(context);
TaskRequest param = JsonConvert.DeserializeObject <TaskRequest>(json);
yw_hddz_wlgzEntity wlgz = new Interfaces.Service.FenceService().getWlgzByDzwlbh(param.taskNo);
Interfaces.Service.FenceService fserv = new Interfaces.Service.FenceService();
bool isUpdate = true;//是否需要更新
try
{
if (wlgz == null)
{
throw new Exception("没找到编号为" + param.taskNo + "的任务");
}
List <yw_hddz_wlgz_cmdEntity> list = new Interfaces.Service.FenceService().getWlgzcmdByRwbh(wlgz.rwbh);
foreach (var m in list)
{
if (m.wlxh == param.no)
{
if (param.listenStatus == "0")
{
if (m.jrdzwlsj != null)
{
throw new Exception(m.rwbh + "已经有进入电子围栏时间");
}
else if (m.wlxh == 1 && m.rwlx != "1" && m.rwmc != "港区")
{
throw new Exception("非港区的第一个任务不反写进时间");
}
}
if (param.listenStatus == "1")
{
if (m.rwmc == "港区")// 出港区时间 单独出来
{
m.cdzwlsj = Convert.ToDateTime(param.crttime);
fserv.UpdateWlgzCmdOutPort(m);
throw new Exception(m.rwbh + "出港区时间需要单独处理");
}
else if (m.cdzwlsj != null)
{
throw new Exception(m.rwbh + "已经有出电子围栏时间");
}
}
//出港区时间先不更新 2018年8月14日20:27:59
//if (param.listenStatus == "1" && m.rwmc == "港区")
//{
// throw new Exception("出港区时间先不更新");
//}
}
else if (m.wlxh > param.no)
{
if (m.jrdzwlsj != null || m.cdzwlsj != null)
{
throw new Exception("后续节点已经有围栏出入时间，不能再写入时间");
}
}
}
}
catch (Exception ex)
{
isUpdate = false;
writeLog("UpdateInOrOutFence出现异常：" + ex.Message);
}
if (isUpdate)
{
yw_hddz_wlgz_cmdEntity cmd = new yw_hddz_wlgz_cmdEntity();
cmd.rwbh = wlgz.rwbh;
cmd.wlxh = param.no;
cmd.ywbh = wlgz.ywbh;
cmd.hddz_cxh = int.Parse(wlgz.hddz_cxh);
if (param.listenStatus == "0")
{
cmd.jrdzwlsj = Convert.ToDateTime(param.crttime);
cmd.jdzwlsj_lrsj = DateTime.Now;
}
else
{
cmd.cdzwlsj = Convert.ToDateTime(param.crttime);
cmd.cdzwlsj_lrsj = DateTime.Now;
}
fserv.UpdateWlgzCmd(cmd);
res.result = true;
}
else// 不需要更新时 把result设为true
{
res.result = true;
}
}
catch (Exception ex)
{
res.result = false;
res.msg = ex.Message;
writeLog("UpdateInOrOutFence出现异常：" + ex.Message);
}
}
public void UpdateWlgzCmd(yw_hddz_wlgz_cmdEntity model)
{
using (conn = ConnectionFactory.CreateConnection())
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
StringBuilder sql = new StringBuilder();
sql.Append("update yw_hddz_wlgz_cmd set ");
string strWhere = "";
if (model.jrdzwlsj != null)
{
sql.Append("jrdzwlsj =@jrdzwlsj,jdzwlsj_lrsj=@jdzwlsj_lrsj,jdzwlsj_czry='北斗' ");
strWhere = " and jrdzwlsj is null";
}
else if (model.cdzwlsj != null)
{
sql.Append("cdzwlsj =@cdzwlsj,cdzwlsj_lrsj=@cdzwlsj_lrsj,cdzwlsj_czry='北斗' ");
strWhere = " and cdzwlsj is null";
}
else
{
throw new Exception("进出电子围栏时间必须有一个不能为空");
}
sql.Append(" where rwbh=@rwbh and wlxh=@wlxh");
sql.Append(strWhere);
conn.Execute(sql.ToString(), model);
conn.Execute("p_hywlgz", new { ywbh = model.ywbh, cxh = model.hddz_cxh }, null, null, CommandType.StoredProcedure);
s_log_errEntity log = new s_log_errEntity();
log.eid = "dzwl_" + Guid.NewGuid().ToString();
log.cjsj = DateTime.Now;
log.cscs = 0;
log.funname = "DataToFreshPort";
log.mainid = model.ywbh;
log.parameters = model.hddz_cxh.ToString();
log.changecols = "gq_sj,gq_cp,gq_sjlxfs,gq_rwbh,gq_c_rwbh,hgcyd_sj,hgcyd_cp,hgcyd_sjlxfs,hgcyd_rwbh,hgcyd_c_rwbh,jyd_sj,jyd_cp,jyd_sjlxfs,jyd_rwbh,jyd_c_rwbh,"
+ "sc_sj,sc_cp,sc_sjlxfs,sc_rwbh,sc_c_rwbh,zjfscwld_sj,zjfscwld_cp,zjfscwld_sjlxfs,zjfscwld_rwbh,zjfscwld_c_rwbh,jschfscwld_sj,jschfscwld_cp,"
+ "jschfscwld_sjlxfs,jschfscwld_rwbh,jschfscwld_c_rwbh,fscwld3_sj,fscwld3_cp,fscwld3_sjlxfs,fscwld3_rwbh,fscwld3_c_rwbh,fscwld4_sj,fscwld4_cp,"
+ "fscwld4_sjlxfs,fscwld4_rwbh,fscwld4_c_rwbh,dc_sj,dc_cp,dc_sjlxfs,dc_rwbh,cgqsj,rscsj,djydsj,tgjysj,cscsj,hdcsj,fscwl_ddsj,fscwl_lksj,fscwl2_ddsj,"
+ "fscwl2_lksj,fscwl3_ddsj,fscwl3_lksj,fscwl4_ddsj,fscwl4_lksj";
log.sfcg = 0;
log.tablename = "yw_hddz_jzxxx";
s_log_errEntity log1 = new s_log_errEntity();
log1.eid = "dzwl_" + Guid.NewGuid().ToString();
log1.cjsj = DateTime.Now;
log1.cscs = 0;
log1.funname = "DataToFreshPort";
log1.mainid = model.ywbh;
log1.parameters = model.hddz_cxh.ToString();
log1.changecols = "";
log1.sfcg = 0;
log1.tablename = "yw_hddz_wlgz";
List <s_log_errEntity> list = new List <s_log_errEntity>();
list.Add(log);
list.Add(log1);
string logsql = SqlFactory.GetInsertSql(log);
conn.Execute(logsql, list);
}
}
