public static string TokenStr()
{
var jsonStr = GetHTML("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=wx7f141ebca00734c2&secret=67178d423e17a75e4c9444d587160027");
return(StringPlus.GetTwoMiddleFirstStr(jsonStr, "\"access_token\":\"", "\",\"expires_in"));
}
/// <summary>
/// 控件点击 消息确认提示框
/// </summary>
/// <param name="Control"></param>
/// <param name="msg"></param>
public static void ShowConfirm(System.Web.UI.WebControls.WebControl Control, string msg)
{
//Control.Attributes.Add("onclick", "return confirm('" + StringPlus.JSStringFormat(msg,false) + "');");
AddJSAttrib(Control, "onclick", "return confirm('" + StringPlus.JSStringFormat(msg, false) + "');");
}
/// <summary>
/// WebControl（UpdatePanel）中显示一消息
/// </summary>
/// <param name="webControl"></param>
/// <param name="msg"></param>
public static void ShowAjaxMsg(System.Web.UI.WebControls.WebControl webControl, string msg)
{
RegisterAjaxJS(webControl, "alert(\"" + StringPlus.JSStringFormat(msg, false) + "\");", true);
}
/// <summary>
/// 显示消息提示对话框，页面加载开始后
/// </summary>
/// <param name="page"></param>
/// <param name="msg"></param>
public static void ShowMsg(System.Web.UI.Page page, string msg)
{
string script = "<script type='text/javascript' language='javascript'>alert('" + StringPlus.JSStringFormat(msg, false) + "');</script>";
//page.Response.Write();
ResponseWriteJS(page, script);
}
/// <summary>
/// 获取不会重复的编码
/// </summary>
/// <returns></returns>
public static string GetNowDifString()
{
string s = GetString(DateTime.Now);
return(s + "" + StringPlus.GetRandomNext(5));
}
/// <summary>
/// 返回当前系统日期的标准格式 yyyy-MM-dd
/// </summary>
public static string GetShortDate(object obj)
{
return(StringPlus.ConverTValue <DateTime>(obj, DateTime.Now, Convert.ToDateTime).ToString("yyyy-MM-dd"));
}
/// <summary>
/// 回发验证码图片 [随机字体随机颜色]
/// </summary>
/// <param name="context"></param>
/// <param name="width"></param>
/// <param name="height"></param>
/// <param name="chkStr"></param>
public static void ResopnseColorImage(System.Web.HttpContext context, int width, int height, string chkStr)
{
Bitmap newMap = new Bitmap(width, height, System.Drawing.Imaging.PixelFormat.Format32bppPArgb);
Graphics g = Graphics.FromImage(newMap);
g.Clear(Color.LightCyan);
Random random = new Random();
int i;
for (i = 0; i < 120; i++)//25
{
int x = random.Next(newMap.Width);
int y = random.Next(newMap.Height);
g.DrawPie(new Pen(Color.LightGray), x, y, 6, 6, 1, 1);
}
//输出不同字体和颜色的验证码字符
for (i = 0; i < chkStr.Length; i++)
{
int cindex = random.Next(8);
int findex = random.Next(6);
int fs = random.Next(2);
Font fs_font = new System.Drawing.Font(FontConsts[findex], 12,
fs == 0 ? System.Drawing.FontStyle.Bold : FontStyle.Italic | FontStyle.Bold);
int ii = 4;
if ((i + 1) % 2 == 0)
{
ii = 2;
}
string tmpstr = chkStr.Substring(i, 1);
//Brush b = new System.Drawing.SolidBrush(ColorConsts[cindex]);
System.Drawing.Drawing2D.LinearGradientBrush b = new LinearGradientBrush(new RectangleF((i * (StringPlus.GetStrByteLength(tmpstr) > 1 ? 20 : 13)), 0, width / 2, height), ColorConsts[cindex], ColorConsts[ii], 1.5F, true);
g.DrawString(tmpstr, fs_font, b, (i * (StringPlus.GetStrByteLength(tmpstr) > 1 ? 22 : 13)), 0);//
}
//画一个边框
g.DrawRectangle(new Pen(Color.LightGray), 0, 0, newMap.Width - 1, newMap.Height - 1);
//输出到浏览器
//System.IO.MemoryStream ms = new System.IO.MemoryStream();
newMap.Save(context.Response.OutputStream, System.Drawing.Imaging.ImageFormat.Jpeg);//ms
//context.Response.ClearContent();
//context.Response.ContentType = "image/Jpeg";
//context.Response.BinaryWrite(ms.ToArray());
g.Dispose();
newMap.Dispose();
}
/// <summary>
/// 将内存中的DataTable转成Excel
/// </summary>
/// <param name="excelSavePath">Excel保存路径</param>
/// <param name="sourceTable">内存中的DataTable</param>
/// <param name="sheetName">在Excel中保存的Sheet名称</param>
public static void Table2Excel(string excelSavePath, DataTable tb, string tbname)
{
FileString.FileDel2(excelSavePath);
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + excelSavePath + ";" + "Extended Properties=Excel 8.0;";
using (OleDbConnection connex = new OleDbConnection(strConn))
{
connex.Open();
string ct = "CREATE TABLE " + tbname + " ("; //以下生成一个sql命令向excel中插入一个表
foreach (DataColumn clmn in tb.Columns)
{
switch (clmn.DataType.Name) //根据不同数据类型分别处理
{
case "Decimal":
ct += clmn.ColumnName + " Decimal,";
break;
case "Double":
ct += clmn.ColumnName + " Double,";
break;
default:
ct += clmn.ColumnName + " NTEXT,";
break;
}
}
ct = ct.Substring(0, ct.Length - 1) + ")";
OleDbCommand cmd1 = new OleDbCommand(ct, connex);
cmd1.ExecuteNonQuery(); //向excel中插入一个表
foreach (DataRow r in tb.Rows) //下面向excel中一行一行写入数据
{
string fs = "", vs = "";
foreach (DataColumn clmn in tb.Columns)
{
fs += clmn.ColumnName + ",";
if (r[clmn.ColumnName] == DBNull.Value)
{
vs += "null,";
continue;
}
switch (clmn.DataType.Name) //根据不同数据类型分别处理
{
case "Decimal":
vs += ((decimal)r[clmn.ColumnName]).ToString("0.00") + ",";
break;
case "Double":
vs += ((double)r[clmn.ColumnName]).ToString("0.00") + ",";
break;
case "DateTime":
vs += "'" + ((DateTime)r[clmn.ColumnName]).ToShortDateString() + "',";
break;
default:
vs += "'" + StringPlus.DanYinHao(r[clmn.ColumnName].ToString()) + "',";
break;
}
}
string sqlstr = "insert into [" + tbname + "$] (" + fs.Substring(0, fs.Length - 1) + ") values (" + vs.Substring(0, vs.Length - 1) + ")";
OleDbCommand cmd = new OleDbCommand(sqlstr, connex);
cmd.ExecuteNonQuery(); //向excel中插入数据
}
connex.Close();
}
}
