/// <summary> /// 获取列表(根据查询条件获取全部列表) /// </summary> /// <param name="view_OrderList">传入的实体,可以是一个空实体</param> /// <param name="Where">SQL拼接的查询条件字条串,例如: " ID < 100 " </param> /// <returns>返回实体列表</returns> public static List<View_OrderList> GetList(View_OrderList view_OrderList, string Where) { List<View_OrderList> returnList = new List<View_OrderList>(); List<object> tempList = DBClient.GetList(view_OrderList,new View_OrderListMapping(), Constant.CONNSTRING, Where); foreach (object tempobject in tempList) { returnList.Add((View_OrderList)tempobject); } return returnList; }
/// <summary> /// 获取列表(无条件分页获取全部列表) /// </summary> /// <param name="view_OrderList">传入的实体,可以是一个空实体</param> /// <param name="PageSize">每页的记录数,例如:每页显示10条,则传入 10 </param> /// <param name="CurrentCount">当前是第几页</param> /// <param name="TotalCount">输出参数,返回总记录数</param> /// <returns>返回实体列表</returns> public static List<View_OrderList> GetList(View_OrderList view_OrderList, int PageSize, int CurrentCount, out int TotalCount) { List<View_OrderList> returnList = new List<View_OrderList>(); List<object> tempList = DBClient.GetList(view_OrderList,new View_OrderListMapping(), Constant.CONNSTRING, PageSize, CurrentCount, out TotalCount); foreach (object tempobject in tempList) { returnList.Add((View_OrderList)tempobject); } return returnList; }
/// <summary> /// 添加实体 /// </summary> /// <param name="view_OrderList">传入的实体</param> /// <returns>操作数据库时返回的操作行数,如果大于 "0" 则返回 true 否则返回 false</returns> public static bool Add(View_OrderList view_OrderList) { return DBClient.Add(view_OrderList, new View_OrderListMapping(), Constant.CONNSTRING); }
/// <summary> /// 根据编号获取实体 /// </summary> /// <param name="view_OrderList">传入的实体,必须含有编号,根据编号获取</param> /// <returns>返回得到的实体</returns> public static View_OrderList Get(View_OrderList view_OrderList) { return (View_OrderList)DBClient.Get(view_OrderList, new View_OrderListMapping(), Constant.CONNSTRING); }
public static bool PostMessage(View_OrderList view_orderlist) { //商品名称,服务时间,师傅姓名,客户姓名,收费标准,区域 ,备注 //User user = new User(); //user.UserID = view_orderlist.UserID; //user = UserBLL.Get(user); //筛选符合条件的师傅的openid //List<string> openidlist = GetOpenidList(view_orderlist.RepairTypeID, view_orderlist.AddressID); //获取farepairname,grrepairname,areaname,faareaname View_RepairType view_RepairType = new View_RepairType(); view_RepairType.RepairTypeID = view_orderlist.RepairTypeID; view_RepairType = View_RepairTypeBLL.Get(view_RepairType); Address address = new Address(); address.AddressID =view_orderlist.AddressID; address= AddressBLL.Get(address); View_Area view_area = new View_Area(); view_area.AreaID=address.AreaID; view_area= View_AreaBLL.Get(view_area); DataTable datatable = UserBLL.GetOpenidList(); foreach (DataRow openid in datatable.Rows) { string template_id = ConfigurationManager.AppSettings["template_id"]; string link = ConfigurationManager.AppSettings["orderdetaillink"] + "?orderid=" + view_orderlist.OrderID;//订单详情 string errcode = string.Empty; StringBuilder postDataStr = new StringBuilder(); postDataStr.Append("{"); postDataStr.Append("\"touser\":\"" + openid[0].ToString() + "\",\"template_id\":\"" + template_id + "\",\"url\":\"" + link + "\",\"topcolor\":\"#FF0000\",");// //postDataStr.Append("\"touser\":\"" + "oIAqTs8mJhDNLz5PekTH_ad_KZLY" + "\",\"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_RepairType.GrRepairName+"-"+view_RepairType.FaRepairName+"-"+view_orderlist.RepairName + "\",\"color\": \"#173177\"},"); postDataStr.Append("\"keyword2\": {\"value\": \"" + view_orderlist.WorkTime + "\",\"color\": \"#173177\"},"); postDataStr.Append("\"keyword3\": {\"value\":\"" + view_orderlist.CustomName + "\", \"color\": \"#173177\"},"); postDataStr.Append("\"keyword4\": {\"value\": \"" +view_area.FaAreaName+"-"+view_area.AreaName+"-"+ view_orderlist.AddressName + "\",\"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(); } } if (errcode == "0") { Common.Utils.WriteLog(openid[0].ToString()+ "---" + view_orderlist.OrderID); } else { } } Order order = new Order(); order.OrderID = view_orderlist.OrderID; order = Business.OrderBLL.Get(order); order.Status = 2; bool bl = Business.OrderBLL.Save(order); return bl; }
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; }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; //订单ID string orderid = context.Request.Params["orderid"]; View_OrderList order = new View_OrderList(); order.OrderID = int.Parse(orderid); try { order = View_OrderListBLL.Get(order); order.StatusName = StatusHelper.GetOrderStatusText(order.Status); context.Response.Write(DataTabletoJson(order)); } catch (Exception ex) { context.Response.Write(""); } }
/// <summary> /// dataTable转换成Json格式 /// </summary> /// <param name="dt"></param> /// <returns></returns> public static string DataTabletoJson(View_OrderList order) { StringBuilder jsonBuilder = new StringBuilder(); jsonBuilder.Append("{"); jsonBuilder.Append("\""); jsonBuilder.Append("OrderID"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.OrderID); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("OrderNo"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.OrderNo); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("UserID"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.UserID); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("OrderPrice"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.OrderPrice); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("Status"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.Status); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("StatusName"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.StatusName); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("OrderTime"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.OrderTime); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("RepairTypeID"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.RepairTypeID); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("RepairName"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.RepairName); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("Price"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.OrderPrice); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("Note"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.Note); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("BusmanID"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.BusmanID); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("WorkTime"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.WorkTime); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("GetOrderTime"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.GetOrderTime); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("PayTime"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.PayTime); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("RepairName"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.RepairName); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("CustomName"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.CustomName); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("BusmanName"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.BusmanName); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("BusmanPhone"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.BusmanPhone); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("CustomPhone"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.CustomPhone); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("AddressName"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.AddressName); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("PhotoURL"); jsonBuilder.Append("\":\""); jsonBuilder.Append(order.PhotoURL); jsonBuilder.Append("\","); jsonBuilder.Remove(jsonBuilder.Length - 1, 1); jsonBuilder.Append("}"); return jsonBuilder.ToString(); }
/// <summary> /// 获取列表(根据查询条件获取全部列表) /// </summary> /// <param name="view_OrderList">传入的实体,可以是一个空实体</param> /// <param name="Where">SQL拼接的查询条件字条串,例如: " ID < 100 " </param> /// <returns>返回实体列表</returns> public static List<View_OrderList> GetList(View_OrderList view_OrderList, string Where) { return View_OrderListDAL.GetList(view_OrderList, Where); }
/// <summary> /// 获取列表(无条件分页获取全部列表) /// </summary> /// <param name="view_OrderList">传入的实体,可以是一个空实体</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<View_OrderList> GetList(View_OrderList view_OrderList, int PageSize, int CurrentCount, string Where, out int TotalCount) { return View_OrderListDAL.GetList(view_OrderList, PageSize, CurrentCount, Where, out TotalCount); }
/// <summary> /// 获取列表(无条件获取全部列表) /// </summary> /// <param name="view_OrderList">传入的实体,可以是一个空实体</param> /// <returns>返回实体列表</returns> public static List<View_OrderList> GetList(View_OrderList view_OrderList) { return View_OrderListDAL.GetList(view_OrderList); }
/// <summary> /// 根据编号获取实体 /// </summary> /// <param name="view_OrderList">传入的实体,必须含有编号,根据编号获取</param> /// <returns>返回得到的实体</returns> public static View_OrderList Get(View_OrderList view_OrderList) { return View_OrderListDAL.Get(view_OrderList); }
/// <summary> /// 添加实体 /// </summary> /// <param name="view_OrderList">传入的实体</param> /// <returns>操作数据库时返回的操作行数,如果大于 "0" 则返回 true 否则返回 false</returns> public static bool Add(View_OrderList view_OrderList) { return View_OrderListDAL.Add(view_OrderList); }
/// <summary> /// 修改实体 /// </summary> /// <param name="view_OrderList">传入的实体</param> /// <returns>操作数据库时返回的操作行数,如果大于 "0" 则返回 true 否则返回 false</returns> public static bool Save(View_OrderList view_OrderList) { return View_OrderListDAL.Save(view_OrderList); }
/// <summary> /// 移除实体(根据实体编号移除一条记录) /// </summary> /// <param name="view_OrderList">传入的实体,必须含有编号</param> /// <returns>操作数据库时返回的操作行数,如果大于 "0" 则返回 true 否则返回 false</returns> public static bool Remove(View_OrderList view_OrderList) { return View_OrderListDAL.Remove(view_OrderList); }