/// <summary>
/// 推送带参数信息
/// </summary>
/// <returns></returns>
public ActionResult MassTextingPram()
{
string accessToken = WxHelper.GetWXAccessToken(WxConfig.AppId, WxConfig.Secret);
string msgUrl = "https://api.weixin.qq.com/cgi-bin/message/template/send?access_token=" + accessToken;
string openid = "oQSqlxIdxzhOrxtxKI9z-KYGRAec";
string xmlMsg = ReadXmlHelper.GetXmlValue(Server.MapPath("/Config/WX.xml"), "PushMsg");
string pushMsg = string.Format(xmlMsg, openid);
//string pushMsg = string.Format(xmlMsg, openid, "", "", "");
string result = WxHelper.HttpPostRequest(msgUrl, pushMsg);
return(Content(result));
}
static void Main(string[] args)
{
int pageSize = 10;
int minval = Convert.ToInt32(ConfigurationManager.AppSettings["MinValue"]);
int maxval = Convert.ToInt32(ConfigurationManager.AppSettings["MaxValue"]);
string Creation_Time = ConfigurationManager.AppSettings["Time"];
string fileName = DateTime.Now.ToString("yyyMMddHHmmss") + "log.txt";
string where = " and QS.creation_time<'" + Creation_Time + "'";
#region
for (int i = minval; i < maxval; i++)
{
var sql = ReadXmlHelper.GetXmlValue(Environment.CurrentDirectory + "/../../SQLXml.xml", "GetExcutePage");
sql = string.Format(sql, where, (i - 1) * pageSize + 1, i * pageSize);
//DataTable dt = SqlHelper.ExecuteTable(SqlHelper.GetConnection("GoalConStr"), CommandType.Text, sql);
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.GetConnection("GoalConStr"), CommandType.Text, sql);
//生成语句
//GenerateSqlByRender(reader);
//sql方法
DataBulkCopy(reader);
Console.WriteLine(i);
WriteLog(fileName, ConvertLog(i, where, pageSize));
}
#endregion
//Console.WriteLine(json);
//string aa = Console.ReadLine();
//Console.WriteLine(aa);
//new Plinq().AddList();
//new Plinq().ConcurrentBag();
//new ThreadDemo().ParallelInvokeMethod();
Console.ReadLine();
}