/// <summary>
/// 通过内存地址写数据
/// </summary>
/// <param name="addressFormat"></param>
/// <param name="startAddress"></param>
/// <param name="readByteCount"></param>
/// <returns></returns>
public ApplicationLayerProtocol WriteMemoryByAddress(byte addressFormat, byte[] startAddress, byte[] readByteCount, bool priority)
{
int index = 0;
ParaInfo[] paras = new ParaInfo[startAddress.Length + readByteCount.Length + 1];
paras[index].ByteLen = 1;
paras[index].Value = addressFormat;
index++;
for (int i = 0; i < startAddress.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = startAddress[i];
index++;
}
for (int i = 0; i < readByteCount.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = readByteCount[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.WriteMemoryByAddress, priority, paras);
return(newFrame);
}
/// <summary>
/// 请求上传数据
/// </summary>
/// <param name="dataFormatIdentifier"></param>
/// <param name="addressAndLengthFormatIdentifier"></param>
/// <param name="startAddress"></param>
/// <param name="size"></param>
/// <returns></returns>
public ApplicationLayerProtocol RequestUpload(byte dataFormatIdentifier, byte addressAndLengthFormatIdentifier, byte[] startAddress, byte[] size, bool priority)
{
ParaInfo[] paras = new ParaInfo[startAddress.Length + size.Length];
paras[0].ByteLen = 1;
paras[0].Value = dataFormatIdentifier;
paras[1].ByteLen = 2;
paras[1].Value = addressAndLengthFormatIdentifier;
int index = 2;
for (int i = 0; i < startAddress.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = startAddress[i];
index++;
}
for (int i = 0; i < size.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = size[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.RequestUpload, priority, paras);
return(newFrame);
}
/// <summary>
/// 输入输出控制
/// </summary>
/// <param name="identfier"></param>
/// <param name="ctrlOptRecord"></param>
/// <param name="content"></param>
/// <returns></returns>
public ApplicationLayerProtocol InputOutputControlByIdentifier(byte[] identfier, ControlOptionRecord ctrlOptRecord, bool priority, params byte[] content)
{
ParaInfo[] paras = new ParaInfo[identfier.Length + content.Length + 1];
int index = 0;
for (int i = 0; i < identfier.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = identfier[i];
index++;
}
paras[index].ByteLen = 1;
paras[index].Value = (byte)ctrlOptRecord;
index++;
for (int i = 0; i < content.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = content[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.InputOutputControlByIdentifier, priority, paras);
return(newFrame);
}
/// <summary>
/// 清楚故障码
/// </summary>
/// <param name="groupOfDTC"></param>
/// <returns></returns>
public ApplicationLayerProtocol ClearDiagnosticInformation(byte[] groupOfDTC, bool priority)
{
ParaInfo[] paras = new ParaInfo[groupOfDTC.Length];
for (int i = 0; i < groupOfDTC.Length; i++)
{
paras[i].ByteLen = 1;
paras[i].Value = groupOfDTC[i];
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.ClearDiagnosticInformation, priority, paras);
return(newFrame);
}
/// <summary>
/// 重载方法 获取指定时间段的数据，由于IH所限，按每两小时进行循环读取将数据全部取出来
/// </summary>
/// <param name="para_code">工艺点编码</param>
/// <param name="Btime">开始时间</param>
/// <param name="Etime">结束时间</param>
/// <returns></returns>
protected List <ParaInfo> getParaRecord(string para_code, DateTime Btime, DateTime Etime)
{
DbOperator opt = new DbOperator();
DataSet data = opt.CreateDataSetOra("select t.value_tag,r.gap_hdelay,r.gap_tdelay,r.ctrl_point,r.is_gap_judge,r.periodic,r.rst_value,r.gap_time,r.head_delay,r.tail_delay,r.batch_head_delay,r.batch_tail_delay from HT_QLT_COLLECTION r left join ht_pub_tech_para t on r.para_code = t.para_code where r.PARA_CODE = '" + para_code + "'");
if (data == null || data.Tables[0].Rows.Count == 0)
{
return(null);
}
DataRow drow = data.Tables[0].Rows[0];
////////////////////工艺点标签//////////////////////////////////////////////
string tagname = drow["value_tag"].ToString();
string interval = drow["periodic"].ToString();
if (DateTime.Compare(Btime, Etime) > 0)
{
return(null);
}
List <ParaInfo> paralist = new List <ParaInfo>();
MSYS.DAL.DbOperator ihopt = new MSYS.DAL.DbOperator(new MSYS.DAL.OledbOperator());
DateTime starttime = Btime;
DateTime stoptime = Etime;
if (Etime - Btime > TimeSpan.FromHours(2))
{
starttime = Btime;
stoptime = Btime.AddHours(2);
}
do
{
string query = "SELECT timestamp ,value FROM ihrawdata where tagname = '" + tagname + "' and timestamp between '" + starttime.ToString("yyyy/MM/dd HH:mm:ss") + "' and '" + stoptime.ToString("yyyy/MM/dd HH:mm:ss") + "' and intervalmilliseconds = " + interval + "s order by timestamp ASC";
data = ihopt.CreateDataSetOra(query);
if (data != null && data.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in data.Tables[0].Rows)
{
ParaInfo info = new ParaInfo();
info.timestamp = row["timestamp"].ToString();
info.value = Convert.ToDouble(row["value"].ToString());
paralist.Add(info);
}
}
starttime = stoptime;
stoptime = starttime.AddHours(2);
if (DateTime.Compare(stoptime, Etime) > 0)
{
stoptime = Etime;
}
}while (Etime - starttime > TimeSpan.FromHours(0));
return(paralist);
}
/// <summary>
/// 通过标识符读取数据
/// </summary>
/// <param name="identifier">标识符数组</param>
/// <returns></returns>
public ApplicationLayerProtocol ReadDataByIdentifier(byte[] identifier, bool priority)
{
ParaInfo[] paras = new ParaInfo[identifier.Length];
for (int i = 0; i < identifier.Length; i++)
{
paras[i].ByteLen = 1;
paras[i].Value = identifier[i];
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.ReadDataByIdentifier, priority, paras);
return(newFrame);
}
/// <summary>
/// 退出传输
/// </summary>
/// <param name="transferRequestParameterRecord"></param>
/// <returns></returns>
public ApplicationLayerProtocol RequestTransferExit(bool priority, params byte[] transferRequestParameterRecord)
{
ParaInfo[] paras = new ParaInfo[transferRequestParameterRecord.Length];
for (int i = 0; i < transferRequestParameterRecord.Length; i++)
{
paras[i].ByteLen = 1;
paras[i].Value = transferRequestParameterRecord[i];
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.RequestTransferExit, priority, paras);
return(newFrame);
}
public void ProcessRequest(HttpContext context)
{
ReturnInfo res = new ReturnInfo();
ParaInfo Info = new ParaInfo();
var jsonString = String.Empty;
context.Request.InputStream.Position = 0;
using (var inputStream = new StreamReader(context.Request.InputStream))
{
jsonString = inputStream.ReadToEnd();
}
if (jsonString != null && jsonString != "")
{
try
{
jsonString = utf8_gb2312(jsonString);
WriteMsg("打印出入人员更新参数：" + jsonString);
Info = JsonConvert.DeserializeAnonymousType(jsonString, Info);
DbHelperSQL.connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XQCRDB"].ToString();
string str = " update XQCR_Personnel_Info set ResidentOrVisitor='" + Info.ResidentOrVisitor.Trim() + "',Status='1',UpdateDate='" +
DateTime.Now + "',UpdateUser='******' where ID='" + Info.ID.Trim() + "'";
int i = DbHelperSQL.ExecuteSql(str);
if (i > 0)
{
res.ret = 0;
res.msg = "更新成功";
}
else
{
res.ret = 1;
res.msg = "更新失败";
}
}
catch (Exception ex)
{
res.ret = 2;
res.msg = "fail:" + ex.Message;
WriteMsg("fail:" + ex.Message + ex.StackTrace);
}
}
string returnStr = JsonConvert.SerializeObject(res);
context.Response.ContentType = "text/plain";
context.Response.Write(returnStr);
}
/// <summary>
/// 读DTC信息
/// </summary>
/// <param name="reportType">子功能码</param>
/// <param name="bts">内容</param>
/// <returns></returns>
public ApplicationLayerProtocol ReadDTCInformation(DTCReportType reportType, bool priority, params byte[] bytes)
{
ParaInfo[] paras = new ParaInfo[bytes.Length - 1];
int index = 0;
for (int n = 1; n < bytes.Length; n++)
{
//int index = 1;
paras[index].ByteLen = 1;
paras[index].Value = bytes[n];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.ReadDTCInformation, priority, paras);
return(newFrame);
}
/// <summary>
/// 定时参数管理
/// </summary>
/// <param name="tpat"></param>
/// <param name="content"></param>
/// <returns></returns>
public ApplicationLayerProtocol AccessTimingParameter(TimingParameterAccessType tpat, bool priority, params byte[] content)
{
ParaInfo[] paras = new ParaInfo[content.Length + 1];
paras[0].ByteLen = 1;
paras[0].Value = (byte)tpat;
int index = 1;
for (int i = 0; i < content.Length; i++)
{
paras[i].ByteLen = 1;
paras[i].Value = content[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.AccessTimingParameter, priority, paras);
return(newFrame);
}
/// <summary>
/// 链路控制
/// </summary>
/// <param name="ctrlType"></param>
/// <param name="content"></param>
/// <returns></returns>
public ApplicationLayerProtocol LinkControl(LinkControlType ctrlType, bool priority, params byte[] content)
{
ParaInfo[] paras = new ParaInfo[content.Length + 1];
paras[0].ByteLen = 1;
paras[0].Value = (byte)ctrlType;
int index = 1;
for (int i = 0; i < content.Length; i++)
{
paras[i].ByteLen = 1;
paras[i].Value = content[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.LinkControl, priority, paras);
return(newFrame);
}
/// <summary>
/// 动态定义标识符
/// </summary>
/// <param name="definitionType"></param>
/// <param name="content"></param>
/// <returns></returns>
public ApplicationLayerProtocol DynamicallyDefineDataIdentifier(DefinitionType definitionType, bool priority, params byte[] content)
{
ParaInfo[] paras = new ParaInfo[content.Length + 1];
paras[0].ByteLen = 1;
paras[0].Value = (byte)definitionType;
for (int i = 0; i < content.Length; i++)
{
int index = 1;
paras[index].ByteLen = 1;
paras[index].Value = content[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.DynamicallyDefineDataIdentifier, priority, paras);
return(newFrame);
}
/// <summary>
/// 传输数据
/// </summary>
/// <param name="blockSequenceCounter"></param>
/// <param name="data"></param>
/// <returns></returns>
public ApplicationLayerProtocol TransferData(byte blockSequenceCounter, bool priority, List <byte> data)
{
ParaInfo[] paras = new ParaInfo[data.Count + 1];
paras[0].ByteLen = 1;
paras[0].Value = blockSequenceCounter;
int index = 1;
for (int i = 0; i < data.Count; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = data[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.TransferData, priority, paras);
return(newFrame);
}
/// <summary>
/// 周期访问
/// </summary>
/// <param name="transmissionMode"></param>
/// <param name="content"></param>
/// <returns></returns>
public ApplicationLayerProtocol ReadDataByPeriodicIdentifier(TransmissionMode transmissionMode, bool priority, params byte[] content)
{
ParaInfo[] paras = new ParaInfo[content.Length + 1];
paras[0].ByteLen = 1;
paras[0].Value = (byte)transmissionMode;
for (int i = 0; i < content.Length; i++)
{
int index = 1;
paras[index].ByteLen = 1;
paras[index].Value = content[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.ReadDataByPeriodicIdentifier, priority, paras);
return(newFrame);
}
protected List <ParaInfo> getParaRecord(string tagname, string interval, DateTime Btime, DateTime Etime)
{
if (DateTime.Compare(Btime, Etime) > 0)
{
return(null);
}
List <ParaInfo> paralist = new List <ParaInfo>();
MSYS.DAL.DbOperator ihopt = new MSYS.DAL.DbOperator(new MSYS.DAL.OledbOperator());
DateTime starttime = Btime;
DateTime stoptime = Etime;
if (Etime - Btime > TimeSpan.FromHours(2))
{
starttime = Btime;
stoptime = Btime.AddHours(2);
}
do
{
string query = "SELECT timestamp ,value FROM ihrawdata where tagname = '" + tagname + "' and timestamp between '" + starttime.ToString("yyyy/MM/dd HH:mm:ss") + "' and '" + stoptime.ToString("yyyy/MM/dd HH:mm:ss") + "' and intervalmilliseconds = " + interval + "s order by timestamp ASC";
System.Diagnostics.Debug.WriteLine(query);
DataSet data = ihopt.CreateDataSetOra(query);
if (data != null && data.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in data.Tables[0].Rows)
{
ParaInfo info = new ParaInfo();
info.timestamp = row["timestamp"].ToString();
info.value = Convert.ToDouble(row["value"].ToString());
paralist.Add(info);
}
}
starttime = stoptime;
stoptime = starttime.AddHours(2);
if (DateTime.Compare(stoptime, Etime) > 0)
{
stoptime = Etime;
}
}while (Etime - starttime > TimeSpan.FromHours(2));
return(paralist);
}
/// <summary>
/// 通过标识符写数据
/// </summary>
/// <param name="arrIdentfier"></param>
/// <param name="arrData"></param>
/// <returns></returns>
public ApplicationLayerProtocol WriteDataByIdentifier(byte[] arrIdentfier, bool priority, params byte[] arrData)
{
ParaInfo[] paras = new ParaInfo[arrIdentfier.Length + arrData.Length];
int index = 0;
for (int i = 0; i < arrIdentfier.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = arrIdentfier[i];
index++;
}
for (int i = 0; i < arrData.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = arrData[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.WriteDataByIdentifier, priority, paras);
return(newFrame);
}
/// <summary>
/// 例程控制
/// </summary>
/// <param name="rouCtrlType"></param>
/// <param name="rouIdentifier"></param>
/// <param name="routineControlOptionRecord"></param>
/// <returns></returns>
public ApplicationLayerProtocol RoutineControl(RoutineControlType rouCtrlType, RoutineIdentifier rouIdentifier, bool priority, params byte[] routineControlOptionRecord)
{
ParaInfo[] paras = new ParaInfo[routineControlOptionRecord.Length + 2];
paras[0].ByteLen = 1;
paras[0].Value = (byte)rouCtrlType;
paras[1].ByteLen = 2;
paras[1].Value = (Int16)rouIdentifier;
int index = 2;
for (int i = 0; i < routineControlOptionRecord.Length; i++)
{
paras[index].ByteLen = 1;
paras[index].Value = routineControlOptionRecord[i];
index++;
}
ApplicationLayerProtocol newFrame = new ApplicationLayerProtocol(ApplicationLayerProtocol.RequestID, ServicesID.RoutineControl, priority, paras);
return(newFrame);
}
public void ProcessRequest(HttpContext context)
{
ReturnInfo res = new ReturnInfo();
ParaInfo Info = new ParaInfo();
var jsonString = String.Empty;
context.Request.InputStream.Position = 0;
using (var inputStream = new StreamReader(context.Request.InputStream))
{
jsonString = inputStream.ReadToEnd();
}
if (jsonString != null && jsonString != "")
{
try
{
jsonString = utf8_gb2312(jsonString);
WriteMsg("打印扫码参数：" + jsonString);
Info = JsonConvert.DeserializeAnonymousType(jsonString, Info);
//数据 推送IOC 城市大脑 预留功能
//进行数据比对 返回核对结果
DbHelperSQL.connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XQCRDB"].ToString();
//查询 本人在该小区登记信息
string sql = " select * from XQCR_Personnel_Info where ResidentOrVisitor='0' and CommunityID=@CommunityID " +
" and SubdistrictID=@SubdistrictID and Name=@Name and CertificateID=@CertificateID ";
SqlParameter[] parameters =
{
new SqlParameter("@CommunityID", SqlDbType.NVarChar, 50),
new SqlParameter("@SubdistrictID", SqlDbType.NVarChar, 50),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@CertificateID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Info.CommunityID.Trim();
parameters[1].Value = Info.SubdistrictID.Trim();
parameters[2].Value = Info.Name.Trim();
parameters[3].Value = Info.CertificateID.Trim();
DataSet dstr = DbHelperSQL.Query(sql, parameters);
if (dstr.Tables[0].Rows.Count > 0)
{
//定义 进入信息 model
XQCR_EnterList enterList = new XQCR_EnterList();
XQCR_EnterList enter = new XQCR_EnterList();
enter.ID = Guid.NewGuid().ToString();
enter.UserID = dstr.Tables[0].Rows[0]["ID"].ToString();
enter.CommunityID = Info.CommunityID.Trim();
enter.SubdistrictID = Info.SubdistrictID.Trim();
enter.Name = Info.Name.Trim();
enter.Certificate = dstr.Tables[0].Rows[0]["Certificate"].ToString();
enter.CertificateID = Info.CertificateID.Trim();
enter.CreateUser = Info.CertificateID.Trim();
enter.CreateDate = DateTime.Now;
enter.UpdateUser = Info.CertificateID.Trim();
enter.UpdateDate = DateTime.Now;
//查询是否在 黑名单
string check = " select * from XQCR_BlackList where Name=@Name and CertificateID=@CertificateID ";
SqlParameter[] paracheck =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@CertificateID", SqlDbType.NVarChar, 50)
};
paracheck[0].Value = Info.Name.Trim();
paracheck[1].Value = Info.CertificateID.Trim();
DataSet ds = DbHelperSQL.Query(check, paracheck);
if (ds.Tables[0].Rows.Count > 0)
{
// 保存进入信息 model
enter.Status = "9";
int n = enterList.Add(enter);
if (n > 0)
{
res.ret = 9;
res.msg = "属于黑名单人员，不得进入";
}
else
{
res.ret = 3;
res.msg = "插入进入信息表出现异常";
}
}
else
{
// 保存进入信息 model
enter.Status = "0";
int n = enterList.Add(enter);
if (n > 0)
{
res.ret = 0;
res.msg = "绿灯通过";
}
else
{
res.ret = 3;
res.msg = "插入进入信息表出现异常";
}
}
}
else
{
//定义 进入信息 model
XQCR_EnterList enterList = new XQCR_EnterList();
XQCR_EnterList enter = new XQCR_EnterList();
enter.ID = Guid.NewGuid().ToString();
enter.UserID = "";
enter.CommunityID = Info.CommunityID.Trim();
enter.SubdistrictID = Info.SubdistrictID.Trim();
enter.Name = Info.Name.Trim();
enter.Certificate = "身份证";
enter.CertificateID = Info.CertificateID.Trim();
enter.CreateUser = Info.CertificateID.Trim();
enter.CreateDate = DateTime.Now;
enter.UpdateUser = Info.CertificateID.Trim();
enter.UpdateDate = DateTime.Now;
enter.Status = "8";
int n = enterList.Add(enter);
if (n > 0)
{
res.ret = 8;
res.msg = "未登记信息，请先登记再进入";
}
else
{
res.ret = 3;
res.msg = "插入进入信息表出现异常";
}
}
}
catch (Exception ex)
{
res.ret = 2;
res.msg = "出现异常";
}
}
string returnStr = JsonConvert.SerializeObject(res);
context.Response.ContentType = "text/plain";
context.Response.Write(returnStr);
}
public void ProcessRequest(HttpContext context)
{
ReturnInfo res = new ReturnInfo();
ParaInfo Info = new ParaInfo();
var jsonString = String.Empty;
context.Request.InputStream.Position = 0;
using (var inputStream = new StreamReader(context.Request.InputStream))
{
jsonString = inputStream.ReadToEnd();
}
if (jsonString != null && jsonString != "")
{
try
{
List <CarRegisterInfo> list = new List <CarRegisterInfo>();
jsonString = utf8_gb2312(jsonString);
WriteMsg("打印车牌号登记信息查询参数：" + jsonString);
Info = JsonConvert.DeserializeAnonymousType(jsonString, Info);
if (!String.IsNullOrEmpty(Info.CommunityID.Trim()) && !String.IsNullOrEmpty(Info.SubdistrictID.Trim()))
{
DbHelperSQL.connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XQCRDB"].ToString();
string sql = "select * from XQCR_CarRegister where CommunityID=@CommunityID and SubdistrictID=@SubdistrictID ";
List <SqlParameter> paras = new List <SqlParameter>();
SqlParameter para1 = new SqlParameter("@CommunityID", Info.CommunityID.Trim());
SqlParameter para2 = new SqlParameter("@SubdistrictID", Info.SubdistrictID.Trim());
paras.Add(para1);
paras.Add(para2);
//车牌号
if (!String.IsNullOrEmpty(Info.CarNumber.Trim()))
{
sql += " and CarNumber=@CarNumber ";
SqlParameter paran = new SqlParameter("@CarNumber", Info.CarNumber.Trim());
paras.Add(paran);
}
//进入时间
if (!String.IsNullOrEmpty(Info.Date.Trim()))
{
sql += " and convert(nvarchar (50),CreateDate,23)=@Date ";
SqlParameter paran = new SqlParameter("@Date", Info.Date.Trim());
paras.Add(paran);
}
sql += " order by CreateDate desc";
DataSet ds = DbHelperSQL.Query(sql, paras.ToArray());
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
CarRegisterInfo info = new CarRegisterInfo();
info.ID = ds.Tables[0].Rows[i]["ID"].ToString();
info.CommunityID = ds.Tables[0].Rows[i]["CommunityID"].ToString();
info.Community = ds.Tables[0].Rows[i]["Community"].ToString();
info.SubdistrictID = ds.Tables[0].Rows[i]["SubdistrictID"].ToString();
info.Subdistrict = ds.Tables[0].Rows[i]["Subdistrict"].ToString();
info.CarNumber = ds.Tables[0].Rows[i]["CarNumber"].ToString();
info.Name = ds.Tables[0].Rows[i]["Name"].ToString();
info.Mobile = ds.Tables[0].Rows[i]["Mobile"].ToString();
info.CreateDate = ds.Tables[0].Rows[i]["CreateDate"].ToString();
list.Add(info);
}
res.ret = 0;
res.list = list;
res.msg = "信息列表";
}
else
{
res.ret = 1;
res.list = null;
res.msg = "参数为空";
}
}
catch (Exception ex)
{
res.ret = 2;
res.list = null;
res.msg = "出现异常";
}
}
string returnStr = JsonConvert.SerializeObject(res);
context.Response.ContentType = "text/plain";
context.Response.Write(returnStr);
}
// 获取出入人员 基本信息
public void ProcessRequest(HttpContext context)
{
//返回值
ReturnInfo res = new ReturnInfo();
ParaInfo ParaInfo = new ParaInfo();
var jsonString = String.Empty;
context.Request.InputStream.Position = 0;
using (var inputStream = new StreamReader(context.Request.InputStream))
{
jsonString = inputStream.ReadToEnd();
}
if (jsonString != null && jsonString != "")
{
try
{
jsonString = utf8_gb2312(jsonString);
WriteMsg("打印参数人员信息ID：" + jsonString);
ParaInfo = JsonConvert.DeserializeAnonymousType(jsonString, ParaInfo);
if (!String.IsNullOrEmpty(ParaInfo.ID.Trim()))
{
DbHelperSQL.connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XQCRDB"].ToString();
string str = " select * from XQCR_Personnel_Info where ID=@ID ";
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.NVarChar, 50)
};
parameters[0].Value = ParaInfo.ID.Trim();
DataSet ds = DbHelperSQL.Query(str, parameters);
if (ds.Tables[0].Rows.Count > 0)
{
UserInfo Info = new UserInfo();
Info.ID = ds.Tables[0].Rows[0]["ID"].ToString();
Info.PersonID = ds.Tables[0].Rows[0]["PersonID"].ToString();
Info.CommunityID = ds.Tables[0].Rows[0]["CommunityID"].ToString();
Info.Community = ds.Tables[0].Rows[0]["Community"].ToString();
Info.SubdistrictID = ds.Tables[0].Rows[0]["SubdistrictID"].ToString();
Info.Subdistrict = ds.Tables[0].Rows[0]["Subdistrict"].ToString();
Info.Name = ds.Tables[0].Rows[0]["Name"].ToString();
Info.Certificate = ds.Tables[0].Rows[0]["Certificate"].ToString();
Info.CertificateID = ds.Tables[0].Rows[0]["CertificateID"].ToString();
Info.Mobile = ds.Tables[0].Rows[0]["Mobile"].ToString();
Info.Address = ds.Tables[0].Rows[0]["Address"].ToString();
Info.ResidentOrVisitor = ds.Tables[0].Rows[0]["ResidentOrVisitor"].ToString();
Info.Memo = ds.Tables[0].Rows[0]["Memo"].ToString();
Info.CreateDate = ds.Tables[0].Rows[0]["CreateDate"].ToString();
res.ret = 0;
res.info = Info;
res.msg = "查看填报信息";
}
else
{
res.ret = 0;
res.info = null;
res.msg = "该居民未填报";
}
}
else
{
res.ret = 1;
res.info = null;
res.msg = "参数信息为空";
}
}
catch (Exception ex)
{
res.ret = 2;
res.info = null;
res.msg = "出现异常";
}
}
string returnStr = JsonConvert.SerializeObject(res);
context.Response.ContentType = "text/plain";
context.Response.Write(returnStr);
}
public void ProcessRequest(HttpContext context)
{
ReturnInfo res = new ReturnInfo();
ParaInfo Info = new ParaInfo();
var jsonString = String.Empty;
context.Request.InputStream.Position = 0;
using (var inputStream = new StreamReader(context.Request.InputStream))
{
jsonString = inputStream.ReadToEnd();
}
if (jsonString != null && jsonString != "")
{
try
{
List <EnterInfo> list = new List <EnterInfo>();
jsonString = utf8_gb2312(jsonString);
WriteMsg("打印进入信息查询参数：" + jsonString);
Info = JsonConvert.DeserializeAnonymousType(jsonString, Info);
if (!String.IsNullOrEmpty(Info.CommunityID.Trim()) && !String.IsNullOrEmpty(Info.SubdistrictID.Trim()))
{
DbHelperSQL.connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XQCRDB"].ToString();
string sql = "select a.*,b.Mobile,c.name as Community,d.name as Subdistrict,b.Address,b.ResidentOrVisitor " +
" from XQCR_EnterList a left join XQCR_Personnel_Info b " +
" on a.UserID = b.ID left join XQCR_CommunityDistrict c " +
" on a.CommunityID = c.code left join XQCR_CommunityDistrict d " +
" on a.SubdistrictID = d.code where 1=1 and a.CommunityID=@CommunityID and a.SubdistrictID=@SubdistrictID ";
List <SqlParameter> paras = new List <SqlParameter>();
SqlParameter para1 = new SqlParameter("@CommunityID", Info.CommunityID.Trim());
SqlParameter para2 = new SqlParameter("@SubdistrictID", Info.SubdistrictID.Trim());
paras.Add(para1);
paras.Add(para2);
//常驻 或 访客
if (!String.IsNullOrEmpty(Info.ResidentOrVisitor.Trim()))
{
sql += " and b.ResidentOrVisitor=@ResidentOrVisitor ";
SqlParameter paran = new SqlParameter("@ResidentOrVisitor", Info.ResidentOrVisitor.Trim());
paras.Add(paran);
}
//反馈结果
if (!String.IsNullOrEmpty(Info.Status.Trim()))
{
sql += " and a.Status=@Status ";
SqlParameter paran = new SqlParameter("@Status", Info.Status.Trim());
paras.Add(paran);
}
//进入时间
if (!String.IsNullOrEmpty(Info.Date.Trim()))
{
sql += " and convert(nvarchar (50),a.CreateDate,23)=@Date ";
SqlParameter paran = new SqlParameter("@Date", Info.Date.Trim());
paras.Add(paran);
}
//关键词 查的是 姓名、身份证、手机号码、详细住址
if (!String.IsNullOrEmpty(Info.keys.Trim()))
{
sql += " and ( a.Name like @keys or a.CertificateID like @keys or b.Mobile like @keys or b.Address like @keys ) ";
SqlParameter paran = new SqlParameter("@keys", "%" + Info.keys.Trim() + "%");
paras.Add(paran);
}
sql += " order by a.CreateDate desc";
DataSet ds = DbHelperSQL.Query(sql, paras.ToArray());
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
EnterInfo info = new EnterInfo();
info.ID = ds.Tables[0].Rows[i]["ID"].ToString();
info.UserID = ds.Tables[0].Rows[i]["UserID"].ToString();
info.CommunityID = ds.Tables[0].Rows[i]["CommunityID"].ToString();
info.Community = ds.Tables[0].Rows[i]["Community"].ToString();
info.SubdistrictID = ds.Tables[0].Rows[i]["SubdistrictID"].ToString();
info.Subdistrict = ds.Tables[0].Rows[i]["Subdistrict"].ToString();
info.Name = ds.Tables[0].Rows[i]["Name"].ToString();
info.Certificate = ds.Tables[0].Rows[i]["Certificate"].ToString();
info.CertificateID = ds.Tables[0].Rows[i]["CertificateID"].ToString();
info.Mobile = ds.Tables[0].Rows[i]["Mobile"].ToString();
info.Address = ds.Tables[0].Rows[i]["Address"].ToString();
info.ResidentOrVisitor = ds.Tables[0].Rows[i]["ResidentOrVisitor"].ToString();
info.Status = ds.Tables[0].Rows[i]["Status"].ToString();
info.Date = ds.Tables[0].Rows[i]["CreateDate"].ToString();
list.Add(info);
}
res.ret = 0;
res.list = list;
res.msg = "信息列表";
}
else
{
res.ret = 1;
res.list = null;
res.msg = "参数为空";
}
}
catch (Exception ex)
{
res.ret = 2;
res.list = null;
res.msg = "出现异常";
}
}
string returnStr = JsonConvert.SerializeObject(res);
context.Response.ContentType = "text/plain";
context.Response.Write(returnStr);
}
public void ProcessRequest(HttpContext context)
{
//返回值
ReturnInfo res = new ReturnInfo();
ParaInfo Info = new ParaInfo();
var jsonString = String.Empty;
context.Request.InputStream.Position = 0;
using (var inputStream = new StreamReader(context.Request.InputStream))
{
jsonString = inputStream.ReadToEnd();
}
if (jsonString != null && jsonString != "")
{
try
{
jsonString = utf8_gb2312(jsonString);
WriteMsg("打印参数社区Code：" + jsonString);
Info = JsonConvert.DeserializeAnonymousType(jsonString, Info);
//判断 参数 是否为空
if (!String.IsNullOrEmpty(Info.Code.Trim()))
{
try
{
DbHelperSQL.connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["XQCRDB"].ToString();
string str = " select * from XQCR_CommunityDistrict where ParentId=@Code ";
SqlParameter[] parameters =
{
new SqlParameter("@Code", SqlDbType.NVarChar, 50)
};
parameters[0].Value = Info.Code.Trim();
DataSet ds = DbHelperSQL.Query(str, parameters);
List <XQInfo> list = new List <XQInfo>();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
XQInfo info = new XQInfo();
info.ID = ds.Tables[0].Rows[i]["ID"].ToString();
info.Name = ds.Tables[0].Rows[i]["Name"].ToString();
info.ParentID = ds.Tables[0].Rows[i]["ParentID"].ToString();
info.Code = ds.Tables[0].Rows[i]["Code"].ToString();
info.remark = ds.Tables[0].Rows[i]["remark"].ToString();
info.sort = ds.Tables[0].Rows[i]["sort"].ToString();
list.Add(info);
}
res.ret = 0;
res.Datas = list;
res.msg = "查询成功";
}
catch (Exception ex)
{
res.ret = 1;
res.Datas = null;
res.msg = "查询失败";
WriteMsg("出错误：" + ex.Message + ex.StackTrace);
}
}
else
{
res.ret = 2;
res.Datas = null;
res.msg = "参数为空";
}
}
catch (Exception ex)
{
res.ret = 3;
res.Datas = null;
res.msg = "出现异常";
}
}
string returnStr = JsonConvert.SerializeObject(res);
context.Response.ContentType = "text/plain";
context.Response.Write(returnStr);
}
