/// <summary>
/// 获取列表（根据查询条件获取全部列表）
/// </summary>
/// <param name="order">传入的实体，可以是一个空实体</param>
/// <param name="Where">SQL拼接的查询条件字条串，例如： " ID < 100 " </param>
/// <returns>返回实体列表</returns>
public static List<Order> GetList(Order order, string Where)
{
List<Order> returnList = new List<Order>();
List<object> tempList = DBClient.GetList(order, new OrderMapping(), Constant.CONNSTRING, Where);
foreach (object tempobject in tempList)
{
returnList.Add((Order)tempobject);
}
return returnList;
}
/// <summary>
/// 获取列表（无条件分页获取全部列表）
/// </summary>
/// <param name="order">传入的实体，可以是一个空实体</param>
/// <param name="PageSize">每页的记录数，例如：每页显示10条，则传入 10 </param>
/// <param name="CurrentCount">当前是第几页</param>
/// <param name="TotalCount">输出参数，返回总记录数</param>
/// <returns>返回实体列表</returns>
public static List<Order> GetList(Order order, int PageSize, int CurrentCount, out int TotalCount)
{
List<Order> returnList = new List<Order>();
List<object> tempList = DBClient.GetList(order,new OrderMapping(), Constant.CONNSTRING, PageSize, CurrentCount, out TotalCount);
foreach (object tempobject in tempList)
{
returnList.Add((Order)tempobject);
}
return returnList;
}
/// <summary>
/// 获取列表（无条件分页获取全部列表）
/// </summary>
/// <param name="order">传入的实体，可以是一个空实体</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<Order> GetList(Order order, int PageSize, int CurrentCount, string Where, out int TotalCount)
{
return OrderDAL.GetList(order, PageSize, CurrentCount, Where, out TotalCount);
}
/// <summary>
/// 获取列表（根据查询条件获取全部列表）
/// </summary>
/// <param name="order">传入的实体，可以是一个空实体</param>
/// <param name="Where">SQL拼接的查询条件字条串，例如： " ID < 100 " </param>
/// <returns>返回实体列表</returns>
public static List<Order> GetList(Order order, string Where)
{
return OrderDAL.GetList(order, Where);
}
/// <summary>
/// 获取列表（无条件获取全部列表）
/// </summary>
/// <param name="order">传入的实体，可以是一个空实体</param>
/// <returns>返回实体列表</returns>
public static List<Order> GetList(Order order)
{
return OrderDAL.GetList(order);
}
/// <summary>
/// 根据编号获取实体
/// </summary>
/// <param name="order">传入的实体，必须含有编号，根据编号获取</param>
/// <returns>返回得到的实体</returns>
public static Order Get(Order order)
{
return OrderDAL.Get(order);
}
public static bool Add(Order order,out int maxID)
{
return OrderDAL.Add(order,out maxID);
}
/// <summary>
/// 修改实体
/// </summary>
/// <param name="order">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Save(Order order)
{
return OrderDAL.Save(order);
}
/// <summary>
/// 移除实体（根据实体编号移除一条记录）
/// </summary>
/// <param name="order">传入的实体，必须含有编号</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Remove(Order order)
{
return OrderDAL.Remove(order);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="order">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Add(Order order)
{
return OrderDAL.Add(order);
}
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;
}
/// <summary>
/// 根据编号获取实体
/// </summary>
/// <param name="order">传入的实体，必须含有编号，根据编号获取</param>
/// <returns>返回得到的实体</returns>
public static Order Get(Order order)
{
return (Order)DBClient.Get(order, new OrderMapping(), Constant.CONNSTRING);
}
public static bool Add(Order order,out int maxID)
{
return DBClient.Add(order, new OrderMapping(), Constant.CONNSTRING,out maxID);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="order">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Add(Order order)
{
return DBClient.Add(order, new OrderMapping(), Constant.CONNSTRING);
}
/// <summary>
/// 移除实体（根据实体编号移除一条记录）
/// </summary>
/// <param name="order">传入的实体，必须含有编号</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Remove(Order order)
{
return DBClient.Remove(order, new OrderMapping(), Constant.CONNSTRING);
}
public void ProcessRequest(HttpContext context)
{
int statustype = 0;
string orderjson = "";
context.Response.ContentType = "text/plain";
if (!string.IsNullOrEmpty(context.Request.Params["statustype"]))
{
statustype = int.Parse(context.Request.Params["statustype"]);
}
else
{
context.Response.Write("false");
}
if (!string.IsNullOrEmpty(context.Request.Params["orderjson"]))
{
orderjson = context.Request.Params["orderjson"];
}
Order order = new Order();
order = JsonConvert.DeserializeObject<Order>(orderjson);
Order order_old = Business.Business.OrderBLL.Get(order);//读取数据库中现有订单，修改状态
//1接单2转单3开始服务4更改价格5支付成功
if (statustype == 1)
{
order_old.Status = 3;
order_old.GetOrderTime = System.DateTime.Now;
order_old.BusmanID = order.BusmanID;
}
else if (statustype == 2) {
//转单会将之前订单状态改为删除，重新生成新的订单，并且置空师傅相关字段
order_old.Status = 0;
order_old.SysNote = "该订单已被转单";
Business.Business.OrderBLL.Save(order_old);
order_old.Status = 4;
Order order_change = order_old;
order_change.SysNote = "该订单由"+order_old.OrderID+"转单";
order_change.OrderNo = "bj" + order.UserID + (new Random()).Next(100, 999);
order_change.OrderTime = System.DateTime.Now;
order_change.BusmanID = null;
order_change.Status = 1;
//创建新订单,并且状态为转单
Business.Business.OrderBLL.Add(order_change);
//进入推送消息池
View_OrderList view_orderlist = View_OrderListBLL.GetByOrderNo(order_change.OrderNo);
OrderBLL.PostMessage(view_orderlist);
}
else if (statustype == 3) {
order_old.Status = 5;
}
else if (statustype == 4) {
order_old.OrderPrice = order.OrderPrice;
}
else if (statustype == 5) {
order_old.Status = 6;
order_old.PayTime = System.DateTime.Now;
}
bool b = OrderBLL.Save(order_old);
//师傅接单后推送消息给用户
if (statustype == 1)
{
View_OrderList view_orderlist = View_OrderListBLL.GetByOrderNo(order_old.OrderNo);
OrderBLL.PostMessageCus(view_orderlist);
}
context.Response.Write(b.ToString().ToLower());
}
