/// <summary>
/// 获取列表（根据查询条件获取全部列表）
/// </summary>
/// <param name="view_repairType">传入的实体，可以是一个空实体</param>
/// <param name="Where">SQL拼接的查询条件字条串，例如： " ID < 100 " </param>
/// <returns>返回实体列表</returns>
public static List<View_RepairType> GetList(View_RepairType view_repairType, string Where)
{
List<View_RepairType> returnList = new List<View_RepairType>();
List<object> tempList = DBClient.GetList(view_repairType,new View_RepairTypeMapping(), Constant.CONNSTRING, Where);
foreach (object tempobject in tempList)
{
returnList.Add((View_RepairType)tempobject);
}
return returnList;
}
/// <summary>
/// 根据编号获取实体
/// </summary>
/// <param name="view_repairType">传入的实体，必须含有编号，根据编号获取</param>
/// <returns>返回得到的实体</returns>
public static View_RepairType Get(View_RepairType view_repairType)
{
return (View_RepairType)DBClient.Get(view_repairType, new View_RepairTypeMapping(), 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;
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="view_repairType">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Add(View_RepairType view_repairType)
{
return DBClient.Add(view_repairType, new View_RepairTypeMapping(), Constant.CONNSTRING);
}
/// <summary>
/// 修改实体
/// </summary>
/// <param name="view_repairType">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Save(View_RepairType view_repairType)
{
return View_RepairTypeDAL.Save(view_repairType);
}
/// <summary>
/// 移除实体（根据实体编号移除一条记录）
/// </summary>
/// <param name="view_repairType">传入的实体，必须含有编号</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Remove(View_RepairType view_repairType)
{
return View_RepairTypeDAL.Remove(view_repairType);
}
/// <summary>
/// 获取列表（根据查询条件获取全部列表）
/// </summary>
/// <param name="view_repairType">传入的实体，可以是一个空实体</param>
/// <param name="Where">SQL拼接的查询条件字条串，例如： " ID < 100 " </param>
/// <returns>返回实体列表</returns>
public static List<View_RepairType> GetList(View_RepairType view_repairType, string Where)
{
return View_RepairTypeDAL.GetList(view_repairType, Where);
}
/// <summary>
/// 根据编号获取实体
/// </summary>
/// <param name="view_repairType">传入的实体，必须含有编号，根据编号获取</param>
/// <returns>返回得到的实体</returns>
public static View_RepairType Get(View_RepairType view_repairType)
{
return View_RepairTypeDAL.Get(view_repairType);
}
/// <summary>
/// 添加实体
/// </summary>
/// <param name="view_repairType">传入的实体</param>
/// <returns>操作数据库时返回的操作行数，如果大于 "0" 则返回 true 否则返回 false</returns>
public static bool Add(View_RepairType view_repairType)
{
return View_RepairTypeDAL.Add(view_repairType);
}