public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string orderjson = context.Request.Params["orderjson"];
Order order = JsonConvert.DeserializeObject<Order>(orderjson);
//前台将姓名传入订单号，此处单独处理姓名，然后自动生成订单号
if (!string.IsNullOrEmpty(order.OrderNo))
{
User user = new User();
user.UserID = order.UserID;
user = Business.Business.UserBLL.Get(user);
user.Name = order.OrderNo;
Business.Business.UserBLL.Save(user);
}
order.OrderNo = "bj" + order.UserID + (new Random()).Next(100, 999);
order.OrderTime = System.DateTime.Now;
order.Status = 1;
//获取价格
RepairType rt = new RepairType();
rt.RepairTypeID = order.RepairTypeID;
rt = RepairTypeBLL.Get(rt);
order.OrderPrice=rt.Price;
//因时间字段不赋值报错，暂时将所有时间字段赋值
order.GetOrderTime = System.DateTime.Now;
order.PayTime = System.DateTime.Now;
bool b = OrderBLL.Add(order);
context.Response.Write(b.ToString().ToLower());
//进入推送消息池
View_OrderList view_orderlist = View_OrderListBLL.GetByOrderNo(order.OrderNo);
OrderBLL.PostMessage(view_orderlist);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string phone = context.Request.Params["phone"];
string password = context.Request.Params["password"];
string openid = context.Request.Params["openid"];
bool isExists = UserBLL.isExists(phone);//查询手机号是否存在
string result = string.Empty;
if (isExists)
{
User user = new User();
user.Phone = phone;
user.PWD = password;
user.UserType = 1;
user.Openid = openid;
user.RegisterTime = DateTime.Now;
int maxID;
maxID = UserBLL.Add(user, 0);
result=maxID.ToString();
}
else
{
result="-1";
}
context.Response.Write(result);
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string UserID = context.Request.Params["UserID"];
User user = new User();
user.UserID =int.Parse(UserID);
user = UserBLL.Get(user);
context.Response.Write(Common.JsonHelper.EntityToJson((object)user));
}
/// <summary>
/// 获取列表（无条件分页获取全部列表）
/// </summary>
/// <param name="user">传入的实体，可以是一个空实体</param>
/// <param name="PageSize">每页的记录数，例如：每页显示10条，则传入 10 </param>
/// <param name="CurrentCount">当前是第几页</param>
/// <param name="TotalCount">输出参数，返回总记录数</param>
/// <returns>返回实体列表</returns>
public static List<User> GetList(User user, int PageSize, int CurrentCount, out int TotalCount)
{
List<User> returnList = new List<User>();
List<object> tempList = DBClient.GetList(user, new UserMapping(), Constant.CONNSTRING, PageSize, CurrentCount, out TotalCount);
foreach (object tempobject in tempList)
{
returnList.Add((User)tempobject);
}
return returnList;
}
/// <summary>
/// 获取列表（根据查询条件获取全部列表）
/// </summary>
/// <param name="user">传入的实体，可以是一个空实体</param>
/// <param name="Where">SQL拼接的查询条件字条串，例如： " ID < 100 " </param>
/// <returns>返回实体列表</returns>
public static List<User> GetList(User user, string Where)
{
List<User> returnList = new List<User>();
List<object> tempList = DBClient.GetList(user, new UserMapping(), Constant.CONNSTRING, Where);
foreach (object tempobject in tempList)
{
returnList.Add((User)tempobject);
}
return returnList;
}
/// <summary>
/// 获取列表（无条件分页获取全部列表）
/// </summary>
/// <param name="user">传入的实体，可以是一个空实体</param>
/// <param name="PageSize">每页的记录数，例如：每页显示10条，则传入 10 </param>
/// <param name="CurrentCount">当前是第几页</param>
/// <param name="Where">SQL拼接的查询条件字条串，例如： " ID < 100 " </param>
/// <param name="TotalCount">输出参数，返回总记录数</param>
/// <returns>返回实体列表</returns>
public static List<User> GetList(User user, int PageSize, int CurrentCount, string Where, out int TotalCount)
{
return UserDAL.GetList(user, PageSize, CurrentCount, Where, out TotalCount);
}
/// <summary>
/// 获取列表（根据查询条件获取全部列表）
/// </summary>
/// <param name="user">传入的实体，可以是一个空实体</param>
/// <param name="Where">SQL拼接的查询条件字条串，例如： " ID < 100 " </param>
/// <returns>返回实体列表</returns>
public static List<User> GetList(User user, string Where)
{
return UserDAL.GetList(user, Where);
}
/// <summary>
/// 获取列表（无条件获取全部列表）
/// </summary>
/// <param name="user">传入的实体，可以是一个空实体</param>
/// <returns>返回实体列表</returns>
public static List<User> GetList(User user)
{
return UserDAL.GetList(user);
}
/// <summary>
/// 根据编号获取实体
/// </summary>
/// <param name="user">传入的实体，必须含有编号，根据编号获取</param>
/// <returns>返回得到的实体</returns>
public static User Get(User user)
{
return UserDAL.Get(user);
}
public static int Add(User user,int maxID)
{
return UserDAL.Add(user,maxID);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="user">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Add(User user)
{
return UserDAL.Add(user);
}
/// <summary>
/// 修改实体
/// </summary>
/// <param name="user">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Save(User user)
{
return UserDAL.Save(user);
}
/// <summary>
/// 移除实体（根据实体编号移除一条记录）
/// </summary>
/// <param name="user">传入的实体，必须含有编号</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Remove(User user)
{
return UserDAL.Remove(user);
}
public static bool PostMessageCus(View_OrderList view_orderlist)
{
DTO.Business.User user = new User();
user.UserID = view_orderlist.UserID;
user = UserBLL.Get(user);
//订单编号，接单员，时间及价格，备注
string template_id = ConfigurationManager.AppSettings["template_id_cus"];
string link = ConfigurationManager.AppSettings["orderdetaillink_cus"] + "?orderid=" + view_orderlist.OrderID;//订单详情
string errcode = string.Empty;
StringBuilder postDataStr = new StringBuilder();
postDataStr.Append("{");
postDataStr.Append("\"touser\":\"" + user.Openid + "\",\"template_id\":\"" + template_id + "\",\"url\":\"" + link + "\",\"topcolor\":\"#FF0000\",");//
postDataStr.Append("\"data\":");
postDataStr.Append("{");//data{}
postDataStr.Append("\"first\": {\"value\": \"" + "您好，您的订单已被接单..." + "\",\"color\": \"#173177\"},");
postDataStr.Append("\"keyword1\": {\"value\": \"" + view_orderlist.OrderNo + "\",\"color\": \"#173177\"},");
postDataStr.Append("\"keyword2\": {\"value\": \"" + view_orderlist.BusmanName + "\",\"color\": \"#173177\"},");
postDataStr.Append("\"keyword3\": {\"value\":\"" + view_orderlist.WorkTime+" (￥"+ view_orderlist.OrderPrice+ ")\", \"color\": \"#173177\"},");
postDataStr.Append("\"remark\": {\"value\": \"" + view_orderlist.Note + " " + view_orderlist.SysNote + "\",\"color\": \"#173177\"}");
postDataStr.Append("}");//data结尾
postDataStr.Append("}");
string Url = "https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=" + GetAccessToken();
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Url);
request.Method = "POST";
Stream myRequestStream = request.GetRequestStream();
StreamWriter myStreamWriter = new StreamWriter(myRequestStream);
myStreamWriter.Write(postDataStr);
myStreamWriter.Close();
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream myResponseStream = response.GetResponseStream();
StreamReader myStreamReader = new StreamReader(myResponseStream);
string strResult = myStreamReader.ReadToEnd();
myStreamReader.Close();
myResponseStream.Close();
if (!strResult.Contains("errorcode"))
{
strResult = "[" + strResult + "]";
DataTable dt = JsonHelper.JsonToDataTable(strResult);
if (dt != null && dt.Rows.Count > 0)
{
errcode = dt.Rows[0]["errcode"].ToString();
}
}
bool bl = true;
if (errcode == "0") { bl = true; }
else
{
bl = false;
}
return bl;
}
/// <summary>
/// 移除实体（根据实体编号移除一条记录）
/// </summary>
/// <param name="user">传入的实体，必须含有编号</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Remove(User user)
{
return DBClient.Remove(user, new UserMapping(), Constant.CONNSTRING);
}
/// <summary>
/// 根据编号获取实体
/// </summary>
/// <param name="user">传入的实体，必须含有编号，根据编号获取</param>
/// <returns>返回得到的实体</returns>
public static User Get(User user)
{
return (User)DBClient.Get(user, new UserMapping(), Constant.CONNSTRING);
}
public static int Add(User user,int maxID)
{
DBClient.Add(user, new UserMapping(), Constant.CONNSTRING);
User userMax = (User)DBClient.Get(user, new UserMapping(), Constant.CONNSTRING, " UserID=(select max(UserID) from [User])");
return userMax.UserID;
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="user">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Add(User user)
{
return DBClient.Add(user, new UserMapping(), Constant.CONNSTRING);
}
