问题记录
会长期更新，记录一些自己遇到见到的问题。
1.JS解析JSON格式时间。
1 //转换json格式时间的方法 如Date(1340239979000)转换为正常 2 function ConvertJSONDateToJSDateObject(JSONDateString) { 3 var date = new Date(parseInt(JSONDateString.replace("/Date(", "").replace(")/", ""), 10)); 4 var year = date.getFullYear(); 5 var month = date.getMonth + 1 < 10 ? "0" + (date.getMonth() + 1) : date.getMonth() + 1; 6 var currentDate = date.getDate() < 10 ? "0" + date.getDate() : date.getDate(); 7 var hour = date.getHours(); 8 var minute = date.getMinutes(); 9 var second = date.getSeconds(); 10 var datastr = year + "-" + month + "-" + currentDate + " " + hour + ":" + minute + ":" + second; 11 return datastr; 12 }
2.设为首页加入收藏
function addfavor(url, title) { var ua = navigator.userAgent.toLowerCase(); if (ua.indexOf("msie 8") > -1) { external.AddToFavoritesBar(url, title, '收藏名称'); //IE8 } else { try { window.external.addFavorite(url, title); } catch (e) { try { window.sidebar.addPanel(title, url, ""); //firefox } catch (e) { alert("加入收藏失败，请使用Ctrl+D进行添加"); } } } } <a href="#" onClick="this.style.behavior='url(#default#homepage)'; this.setHomePage(document.location.href);event.returnValue=false;">设为首页</a></span> | <span><a href="javascript:void(0);" onclick="javascript:addfavor(window.location,'收藏名称');">加入收藏</a></span>
3.文本框限制输入，适合金钱框
1.文本框只能输入数字代码(小数点也不能输入) <input onkeyup="this.value=this.value.replace(/\D/g,'')" onafterpaste="this.value=this.value.replace(/\D/g,'')"> 2.只能输入数字,能输小数点. <input onkeyup="if(isNaN(value))execCommand('undo')" onafterpaste="if(isNaN(value))execCommand('undo')"> <input name=txt1 onchange="if(/\D/.test(this.value)){alert('只能输入数字');this.value='';}"> 4.只能输入字母和汉字 <input onkeyup="value=value.replace(/[\d]/g,'') "onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[\d]/g,''))" maxlength=10 name="Numbers"> 5.只能输入英文字母和数字,不能输入中文 <input onkeyup="value=value.replace(/[^\w\.\/]/ig,'')"> 6.只能输入数字和英文<font color="Red">chun</font> <input onKeyUp="value=value.replace(/[^\d|chun]/g,'')"> 7.小数点后只能有最多两位(数字,中文都可输入),不能输入字母和运算符号: <input onKeyPress="if((event.keyCode<48 || event.keyCode>57) && event.keyCode!=46 || /\.\d\d$/.test(value))event.returnValue=false"> 8.小数点后只能有最多两位(数字,字母,中文都可输入),可以输入运算符号: <input onkeyup="this.value=this.value.replace(/^(\-)*(\d+)\.(\d\d).*$/,'$1$2.$3')"> 9.只能输入中文： <input name="realname" type="text" maxlength="20" class="input_style" value="<%=realname%>" onkeyup="value=value.replace(/[^\u4E00-\u9FA5]/g,'')" onbeforepaste="clipboardData.setData('text',clipboardData.getData('text').replace(/[^\u4E00-\u9FA5]/g,''))" />
4.window.open(); js,打开一个新窗口函数，参数设定
window.open('index.aspx', "newwindow2", "top=100, left=100,toolbar=yes, menubar=yes, scrollbars=yes, resizable=yes, location=yes, status=yes"); // <SCRIPT LANGUAGE="javascript"> js脚本开始； // window.open 弹出新窗口的命令； // 'page.html' 弹出窗口的文件名； // 'newwindow' 弹出窗口的名字（不是文件名），非必须，可用空''代替； // height=100 窗口高度； // width=400 窗口宽度； // top=0 窗口距离屏幕上方的象素值； // left=0 窗口距离屏幕左侧的象素值； // toolbar=no 是否显示工具栏，yes为显示； // menubar，scrollbars 表示菜单栏和滚动栏。 // Resizable=no 是否允许改变窗口大小，yes为允许； // location=no 是否显示地址栏，yes为允许； // status=no 是否显示状态栏内的信息（通常是文件已经打开），yes为允许； // </SCRIPT> js脚本结束
5.阻止事件冒泡
function stopBubble(e) { //如果传入了对象，那么就是非IE浏览器，才用W3C标准方法 if (e || e.stopPropagation) { e.stopPropagation(); } else { //才用IE的停止事件冒泡的方法 window.event.CancelBubble = true; } }
6.js设置间隔一段时间触发事件
setInterval("test()", 10000)
7.IE提示console未定义
if (!window.console || !console.firebug){ var names = ["log", "debug", "info", "warn", "error", "assert", "dir", "dirxml", "group", "groupEnd", "time", "timeEnd", "count", "trace", "profile", "profileEnd"]; window.console = {}; for (var i = 0; i < names.length; ++i) window.console[names[i]] = function() {} }
/// <summary> /// 计算时间差 与当前时间计算 /// CreateTime:2015-12-17 /// </summary> /// <param name="datetime">开始时间</param> /// <returns>工龄（月）</returns> private int Fun(DateTime datetime) { DateTime dt = DateTime.Now; DateTime dt2 = datetime; if (DateTime.Compare(dt, dt2) < 0) { dt2 = dt; dt = datetime; } int year = dt.Year - dt2.Year; int month = dt.Month - dt2.Month; month = year * 12 + month; if (dt.Day - dt2.Day < -15) { month--; } else if (dt.Day - dt2.Day > 14) { month++; } return month; }
8.随机出10条数据 sql
select top 10 * from table_name order by newid()
9.选择从10到15的记录 sql
select top 5 * from (select top 15 * from table order by id asc) table_别名 order by id desc
10.关于数据库的博客 http://www.cnblogs.com/yubinfeng/archive/2010/11/02/1867386.html#!comments
11. 控制页面滚动条出不出现 style="overflow-x: hidden;overflow-y:auto;"
12.图片处理
public class ImageClass { public ImageClass() { } #region 缩略图 /// <summary> /// 生成缩略图 /// </summary> /// <param name="originalImagePath">源图路径（物理路径）</param> /// <param name="thumbnailPath">缩略图路径（物理路径）</param> /// <param name="width">缩略图宽度</param> /// <param name="height">缩略图高度</param> /// <param name="mode">生成缩略图的方式</param> public static void MakeThumbnail(string originalImagePath, string thumbnailPath, int width, int height, string mode) { System.Drawing.Image originalImage = System.Drawing.Image.FromFile(originalImagePath); int towidth = width; int toheight = height; int x = 0; int y = 0; int ow = originalImage.Width; int oh = originalImage.Height; switch (mode) { case "HW": //指定高宽缩放（可能变形） break; case "W": //指定宽，高按比例 toheight = originalImage.Height * width / originalImage.Width; break; case "H": //指定高，宽按比例 towidth = originalImage.Width * height / originalImage.Height; break; case "Cut": //指定高宽裁减（不变形） if ((double)originalImage.Width / (double)originalImage.Height > (double)towidth / (double)toheight) { oh = originalImage.Height; ow = originalImage.Height * towidth / toheight; y = 0; x = (originalImage.Width - ow) / 2; } else { ow = originalImage.Width; oh = originalImage.Width * height / towidth; x = 0; y = (originalImage.Height - oh) / 2; } break; default: break; } //新建一个bmp图片 System.Drawing.Image bitmap = new System.Drawing.Bitmap(towidth, toheight); //新建一个画板 System.Drawing.Graphics g = System.Drawing.Graphics.FromImage(bitmap); //设置高质量插值法 g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.High; //设置高质量,低速度呈现平滑程度 g.SmoothingMode = System.Drawing.Drawing2D.SmoothingMode.HighQuality; //清空画布并以透明背景色填充 g.Clear(System.Drawing.Color.Transparent); //在指定位置并且按指定大小绘制原图片的指定部分 g.DrawImage(originalImage, new System.Drawing.Rectangle(0, 0, towidth, toheight), new System.Drawing.Rectangle(x, y, ow, oh), System.Drawing.GraphicsUnit.Pixel); try { //以jpg格式保存缩略图 bitmap.Save(thumbnailPath, System.Drawing.Imaging.ImageFormat.Jpeg); } catch (System.Exception e) { throw e; } finally { originalImage.Dispose(); bitmap.Dispose(); g.Dispose(); } } #endregion #region 图片水印 /// <summary> /// 图片水印处理方法 /// </summary> /// <param name="path">需要加载水印的图片路径（绝对路径）</param> /// <param name="waterpath">水印图片（绝对路径）</param> /// <param name="location">水印位置（传送正确的代码）</param> public static string ImageWatermark(string path, string waterpath, string location) { string kz_name = Path.GetExtension(path); if (kz_name == ".jpg" || kz_name == ".bmp" || kz_name == ".jpeg") { DateTime time = DateTime.Now; string filename = "" + time.Year.ToString() + time.Month.ToString() + time.Day.ToString() + time.Hour.ToString() + time.Minute.ToString() + time.Second.ToString() + time.Millisecond.ToString(); Image img = Bitmap.FromFile(path); Image waterimg = Image.FromFile(waterpath); Graphics g = Graphics.FromImage(img); ArrayList loca = GetLocation(location, img, waterimg); g.DrawImage(waterimg, new Rectangle(int.Parse(loca[0].ToString()), int.Parse(loca[1].ToString()), waterimg.Width, waterimg.Height)); waterimg.Dispose(); g.Dispose(); string newpath = Path.GetDirectoryName(path) + filename + kz_name; img.Save(newpath); img.Dispose(); File.Copy(newpath, path, true); if (File.Exists(newpath)) { File.Delete(newpath); } } return path; } /// <summary> /// 图片水印位置处理方法 /// </summary> /// <param name="location">水印位置</param> /// <param name="img">需要添加水印的图片</param> /// <param name="waterimg">水印图片</param> private static ArrayList GetLocation(string location, Image img, Image waterimg) { ArrayList loca = new ArrayList(); int x = 0; int y = 0; if (location == "LT") { x = 10; y = 10; } else if (location == "T") { x = img.Width / 2 - waterimg.Width / 2; y = img.Height - waterimg.Height; } else if (location == "RT") { x = img.Width - waterimg.Width; y = 10; } else if (location == "LC") { x = 10; y = img.Height / 2 - waterimg.Height / 2; } else if (location == "C") { x = img.Width / 2 - waterimg.Width / 2; y = img.Height / 2 - waterimg.Height / 2; } else if (location == "RC") { x = img.Width - waterimg.Width; y = img.Height / 2 - waterimg.Height / 2; } else if (location == "LB") { x = 10; y = img.Height - waterimg.Height; } else if (location == "B") { x = img.Width / 2 - waterimg.Width / 2; y = img.Height - waterimg.Height; } else { x = img.Width - waterimg.Width; y = img.Height - waterimg.Height; } loca.Add(x); loca.Add(y); return loca; } #endregion #region 文字水印 /// <summary> /// 文字水印处理方法 /// </summary> /// <param name="path">图片路径（绝对路径）</param> /// <param name="size">字体大小</param> /// <param name="letter">水印文字</param> /// <param name="color">颜色</param> /// <param name="location">水印位置</param> public static string LetterWatermark(string path, int size, string letter, Color color, string location) { #region string kz_name = Path.GetExtension(path); if (kz_name == ".jpg" || kz_name == ".bmp" || kz_name == ".jpeg") { DateTime time = DateTime.Now; string filename = "" + time.Year.ToString() + time.Month.ToString() + time.Day.ToString() + time.Hour.ToString() + time.Minute.ToString() + time.Second.ToString() + time.Millisecond.ToString(); Image img = Bitmap.FromFile(path); Graphics gs = Graphics.FromImage(img); ArrayList loca = GetLocation(location, img, size, letter.Length); Font font = new Font("宋体", size); Brush br = new SolidBrush(color); gs.DrawString(letter, font, br, float.Parse(loca[0].ToString()), float.Parse(loca[1].ToString())); gs.Dispose(); string newpath = Path.GetDirectoryName(path) + filename + kz_name; img.Save(newpath); img.Dispose(); File.Copy(newpath, path, true); if (File.Exists(newpath)) { File.Delete(newpath); } } return path; #endregion } /// <summary> /// 文字水印位置的方法 /// </summary> /// <param name="location">位置代码</param> /// <param name="img">图片对象</param> /// <param name="width">宽(当水印类型为文字时,传过来的就是字体的大小)</param> /// <param name="height">高(当水印类型为文字时,传过来的就是字符的长度)</param> private static ArrayList GetLocation(string location, Image img, int width, int height) { #region ArrayList loca = new ArrayList(); //定义数组存储位置 float x = 10; float y = 10; if (location == "LT") { loca.Add(x); loca.Add(y); } else if (location == "T") { x = img.Width / 2 - (width * height) / 2; loca.Add(x); loca.Add(y); } else if (location == "RT") { x = img.Width - width * height; } else if (location == "LC") { y = img.Height / 2; } else if (location == "C") { x = img.Width / 2 - (width * height) / 2; y = img.Height / 2; } else if (location == "RC") { x = img.Width - height; y = img.Height / 2; } else if (location == "LB") { y = img.Height - width - 5; } else if (location == "B") { x = img.Width / 2 - (width * height) / 2; y = img.Height - width - 5; } else { x = img.Width - width * height; y = img.Height - width - 5; } loca.Add(x); loca.Add(y); return loca; #endregion } #endregion #region 调整光暗 /// <summary> /// 调整光暗 /// </summary> /// <param name="mybm">原始图片</param> /// <param name="width">原始图片的长度</param> /// <param name="height">原始图片的高度</param> /// <param name="val">增加或减少的光暗值</param> public Bitmap LDPic(Bitmap mybm, int width, int height, int val) { Bitmap bm = new Bitmap(width, height);//初始化一个记录经过处理后的图片对象 int x, y, resultR, resultG, resultB;//x、y是循环次数，后面三个是记录红绿蓝三个值的 Color pixel; for (x = 0; x < width; x++) { for (y = 0; y < height; y++) { pixel = mybm.GetPixel(x, y);//获取当前像素的值 resultR = pixel.R + val;//检查红色值会不会超出[0, 255] resultG = pixel.G + val;//检查绿色值会不会超出[0, 255] resultB = pixel.B + val;//检查蓝色值会不会超出[0, 255] bm.SetPixel(x, y, Color.FromArgb(resultR, resultG, resultB));//绘图 } } return bm; } #endregion #region 反色处理 /// <summary> /// 反色处理 /// </summary> /// <param name="mybm">原始图片</param> /// <param name="width">原始图片的长度</param> /// <param name="height">原始图片的高度</param> public Bitmap RePic(Bitmap mybm, int width, int height) { Bitmap bm = new Bitmap(width, height);//初始化一个记录处理后的图片的对象 int x, y, resultR, resultG, resultB; Color pixel; for (x = 0; x < width; x++) { for (y = 0; y < height; y++) { pixel = mybm.GetPixel(x, y);//获取当前坐标的像素值 resultR = 255 - pixel.R;//反红 resultG = 255 - pixel.G;//反绿 resultB = 255 - pixel.B;//反蓝 bm.SetPixel(x, y, Color.FromArgb(resultR, resultG, resultB));//绘图 } } return bm; } #endregion #region 浮雕处理 /// <summary> /// 浮雕处理 /// </summary> /// <param name="oldBitmap">原始图片</param> /// <param name="Width">原始图片的长度</param> /// <param name="Height">原始图片的高度</param> public Bitmap FD(Bitmap oldBitmap, int Width, int Height) { Bitmap newBitmap = new Bitmap(Width, Height); Color color1, color2; for (int x = 0; x < Width - 1; x++) { for (int y = 0; y < Height - 1; y++) { int r = 0, g = 0, b = 0; color1 = oldBitmap.GetPixel(x, y); color2 = oldBitmap.GetPixel(x + 1, y + 1); r = Math.Abs(color1.R - color2.R + 128); g = Math.Abs(color1.G - color2.G + 128); b = Math.Abs(color1.B - color2.B + 128); if (r > 255) r = 255; if (r < 0) r = 0; if (g > 255) g = 255; if (g < 0) g = 0; if (b > 255) b = 255; if (b < 0) b = 0; newBitmap.SetPixel(x, y, Color.FromArgb(r, g, b)); } } return newBitmap; } #endregion #region 拉伸图片 /// <summary> /// 拉伸图片 /// </summary> /// <param name="bmp">原始图片</param> /// <param name="newW">新的宽度</param> /// <param name="newH">新的高度</param> public static Bitmap ResizeImage(Bitmap bmp, int newW, int newH) { try { Bitmap bap = new Bitmap(newW, newH); Graphics g = Graphics.FromImage(bap); g.InterpolationMode = System.Drawing.Drawing2D.InterpolationMode.HighQualityBicubic; g.DrawImage(bap, new Rectangle(0, 0, newW, newH), new Rectangle(0, 0, bap.Width, bap.Height), GraphicsUnit.Pixel); g.Dispose(); return bap; } catch { return null; } } #endregion #region 滤色处理 /// <summary> /// 滤色处理 /// </summary> /// <param name="mybm">原始图片</param> /// <param name="width">原始图片的长度</param> /// <param name="height">原始图片的高度</param> public Bitmap FilPic(Bitmap mybm, int width, int height) { Bitmap bm = new Bitmap(width, height);//初始化一个记录滤色效果的图片对象 int x, y; Color pixel; for (x = 0; x < width; x++) { for (y = 0; y < height; y++) { pixel = mybm.GetPixel(x, y);//获取当前坐标的像素值 bm.SetPixel(x, y, Color.FromArgb(0, pixel.G, pixel.B));//绘图 } } return bm; } #endregion #region 左右翻转 /// <summary> /// 左右翻转 /// </summary> /// <param name="mybm">原始图片</param> /// <param name="width">原始图片的长度</param> /// <param name="height">原始图片的高度</param> public Bitmap RevPicLR(Bitmap mybm, int width, int height) { Bitmap bm = new Bitmap(width, height); int x, y, z; //x,y是循环次数,z是用来记录像素点的x坐标的变化的 Color pixel; for (y = height - 1; y >= 0; y--) { for (x = width - 1, z = 0; x >= 0; x--) { pixel = mybm.GetPixel(x, y);//获取当前像素的值 bm.SetPixel(z++, y, Color.FromArgb(pixel.R, pixel.G, pixel.B));//绘图 } } return bm; } #endregion #region 上下翻转 /// <summary> /// 上下翻转 /// </summary> /// <param name="mybm">原始图片</param> /// <param name="width">原始图片的长度</param> /// <param name="height">原始图片的高度</param> public Bitmap RevPicUD(Bitmap mybm, int width, int height) { Bitmap bm = new Bitmap(width, height); int x, y, z; Color pixel; for (x = 0; x < width; x++) { for (y = height - 1, z = 0; y >= 0; y--) { pixel = mybm.GetPixel(x, y);//获取当前像素的值 bm.SetPixel(x, z++, Color.FromArgb(pixel.R, pixel.G, pixel.B));//绘图 } } return bm; } #endregion #region 压缩图片 /// <summary> /// 压缩到指定尺寸 /// </summary> /// <param name="oldfile">原文件</param> /// <param name="newfile">新文件</param> public bool Compress(string oldfile, string newfile) { try { System.Drawing.Image img = System.Drawing.Image.FromFile(oldfile); System.Drawing.Imaging.ImageFormat thisFormat = img.RawFormat; Size newSize = new Size(100, 125); Bitmap outBmp = new Bitmap(newSize.Width, newSize.Height); Graphics g = Graphics.FromImage(outBmp); g.CompositingQuality = CompositingQuality.HighQuality; g.SmoothingMode = SmoothingMode.HighQuality; g.InterpolationMode = InterpolationMode.HighQualityBicubic; g.DrawImage(img, new Rectangle(0, 0, newSize.Width, newSize.Height), 0, 0, img.Width, img.Height, GraphicsUnit.Pixel); g.Dispose(); EncoderParameters encoderParams = new EncoderParameters(); long[] quality = new long[1]; quality[0] = 100; EncoderParameter encoderParam = new EncoderParameter(System.Drawing.Imaging.Encoder.Quality, quality); encoderParams.Param[0] = encoderParam; ImageCodecInfo[] arrayICI = ImageCodecInfo.GetImageEncoders(); ImageCodecInfo jpegICI = null; for (int x = 0; x < arrayICI.Length; x++) if (arrayICI[x].FormatDescription.Equals("JPEG")) { jpegICI = arrayICI[x]; //设置JPEG编码 break; } img.Dispose(); if (jpegICI != null) outBmp.Save(newfile, System.Drawing.Imaging.ImageFormat.Jpeg); outBmp.Dispose(); return true; } catch { return false; } } #endregion #region 图片灰度化 public Color Gray(Color c) { int rgb = Convert.ToInt32((double)(((0.3 * c.R) + (0.59 * c.G)) + (0.11 * c.B))); return Color.FromArgb(rgb, rgb, rgb); } #endregion #region 转换为黑白图片 /// <summary> /// 转换为黑白图片 /// </summary> /// <param name="mybt">要进行处理的图片</param> /// <param name="width">图片的长度</param> /// <param name="height">图片的高度</param> public Bitmap BWPic(Bitmap mybm, int width, int height) { Bitmap bm = new Bitmap(width, height); int x, y, result; //x,y是循环次数，result是记录处理后的像素值 Color pixel; for (x = 0; x < width; x++) { for (y = 0; y < height; y++) { pixel = mybm.GetPixel(x, y);//获取当前坐标的像素值 result = (pixel.R + pixel.G + pixel.B) / 3;//取红绿蓝三色的平均值 bm.SetPixel(x, y, Color.FromArgb(result, result, result)); } } return bm; } #endregion #region 获取图片中的各帧 /// <summary> /// 获取图片中的各帧 /// </summary> /// <param name="pPath">图片路径</param> /// <param name="pSavePath">保存路径</param> public void GetFrames(string pPath, string pSavedPath) { Image gif = Image.FromFile(pPath); FrameDimension fd = new FrameDimension(gif.FrameDimensionsList[0]); int count = gif.GetFrameCount(fd); //获取帧数(gif图片可能包含多帧，其它格式图片一般仅一帧) for (int i = 0; i < count; i++) //以Jpeg格式保存各帧 { gif.SelectActiveFrame(fd, i); gif.Save(pSavedPath + "\\frame_" + i + ".jpg", ImageFormat.Jpeg); } } #endregion }
13.生成缩略图
string filePath = context.Request.MapPath("/ImageUp/aa.jpg");//接收的图片路径
string thumbfileName="thumb"+Guid.NewGuid().ToString()+".jpg";//缩略图的名字
Common.ImageClass.MakeThumbnail(filePath,context.Request.MapPath (thumbfileName), 50, 50, "W");//生成缩略图
14.正则验证。判断是否是负整数
var regu = "^\-[1-9][0-9]*$";
var re = new RegExp(regu);
re.test(数字) 返回一个布尔值
15. 计算时间差，返回月份
