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();
CarRegisterInfo myInfo = new CarRegisterInfo();
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);
myInfo = JsonConvert.DeserializeAnonymousType(jsonString, myInfo);
if (!String.IsNullOrEmpty(myInfo.CommunityID.Trim()) && !String.IsNullOrEmpty(myInfo.SubdistrictID.Trim()) && !String.IsNullOrEmpty(myInfo.CarNumber.Trim()))
{
XQCR_CarRegister register = new XQCR_CarRegister();
XQCR_CarRegister car = new XQCR_CarRegister();
car.ID = Guid.NewGuid().ToString();
car.CommunityID = myInfo.CommunityID.Trim();
car.Community = myInfo.Community.Trim();
car.SubdistrictID = myInfo.SubdistrictID.Trim();
car.Subdistrict = myInfo.Subdistrict.Trim();
car.CarNumber = myInfo.CarNumber.Trim();
car.Name = myInfo.Name.Trim();
car.Mobile = myInfo.Mobile.Trim();
car.CreateUser = myInfo.PropertyUser.Trim();
car.CreateDate = DateTime.Now;
car.UpdateUser = myInfo.PropertyUser.Trim();
car.UpdateDate = DateTime.Now;
//插入 小区出入车牌号登记信息
int i = register.Add(car);
if (i > 0)
{
res.ret = 0;
res.msg = "success";
WriteMsg("填报信息成功，证车牌号： " + myInfo.CarNumber);
}
else
{
res.ret = 1;
res.msg = "fail";
WriteMsg("填报信息失败！");
}
}
else
{
res.ret = 2;
res.msg = "参数不能为空";
WriteMsg("填报信息成功，证车牌号： " + myInfo.CarNumber);
}
}
catch (Exception ex)
{
res.ret = 3;
res.msg = "Exception";
WriteMsg("填报信息失败： " + ex);
}
}
string returnStr = JsonConvert.SerializeObject(res);
context.Response.ContentType = "text/plain";
context.Response.Write(returnStr);
}
