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); }