private void Query(HttpContext context)
{
try
{
//先查询有没有注册。对于已注册的，查询欠费列表；对于没有注册的，返回{"error":true,"msg":"Unreg"},前台判断后跳转到注册界面
var phone = context.Request["phone"] ?? "";
UserRegDal userRegDal = new UserRegDal();
DataTable dtReg = userRegDal.Query(new UserReg() { PhoneNumber = phone });
if (dtReg != null && dtReg.Rows.Count > 0)//已注册
{
var yhid = "";
foreach (DataRow row in dtReg.Rows)
{
yhid += row["RNumber"].ToString() + ",";
}
yhid = yhid.Remove(yhid.Length - 1, 1);
InfoReleaseDal dal = new InfoReleaseDal();
var dt = dal.Query(new InfoRelease() { FlagRelease = "1", BusinessType = "011_youo_dfzd" });
string file = "";
string createDt = "";
if (dt != null && dt.Rows.Count > 0)
{
file = dt.Rows[0]["MaterialContent"].ToString();
createDt = dt.Rows[0]["CreateDt"].ToString();
context.Response.Write(string.IsNullOrEmpty(yhid) ? "{\"error\":true,\"msg\":\"用户号为空。\"}" : ReadExcel(yhid, file, createDt));
}
else
{
context.Response.Write("{\"error\":true,\"msg\":\"没有数据。\"}");
return;
}
}
else
{
context.Response.Write("{\"error\":true,\"msg\":\"unreg\"}");//未注册
return;
}
}
catch (Exception ex)
{
context.Response.Write("{\"error\":true,\"msg\":\"" + ex.Message + "\"}");//未注册
Log.Error(ex);
}
}
/// <summary>
/// 删除绑定
/// </summary>
/// <param name="context"></param>
public void DelUserReg2(HttpContext context)
{
var wxid = context.Request["wxid"] ?? "";
var qymc = context.Request["qymc"] ?? "";
var lxr = context.Request["lxr"] ?? "";
var phone = context.Request["phone"] ?? "";
try
{
UserRegDal bll = new UserRegDal();
bll.Del2(new UserReg()
{
Wxid = wxid,
bak1 = qymc,
bak2 = lxr,
PhoneNumber = phone
});
context.Response.Write("{\"success\":true,\"msg\":\"删除成功！\"}");
}
catch (Exception e)
{
Log.Debug("方法名:DelUserReg,描述:删除绑定方法出错,错误原因:" + e.Message);
context.Response.Write("{\"success\":false,\"msg\":\"删除失败！\"}");
}
}
