2011年5月14日
摘要: using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using System.Diagnostics;using System.IO;namespace AppleInPicture{ public partial class frmMain : Form { public frmMain() { InitializeComponen 阅读全文
posted @ 2011-05-14 17:47 轻盈 阅读(185) 评论(0) 推荐(0) 编辑
摘要: 1、定义表:Table_To_Purge [Table_Name,Day_Latency,Date_Field_Name]用于存储需要删除的表的信息,表名、删除时间、字段名2、设置一个job定期执行存储过程:EXECUTE [TISC].[dbo].[PURGE_TABLES]3、编写存储过程:CREATE PROCEDURE DBO.PURGE_TABLES ASDECLARE@tablename AS varchar(64),@daylatency AS int,@datefieldname AS varchar(64),@sqldelete AS varchar(512),@eldest 阅读全文
posted @ 2011-05-14 11:45 轻盈 阅读(307) 评论(0) 推荐(0) 编辑
摘要: asp.net 服务器获取真实IP/// <summary> /// 穿过代理服务器获取真实IP /// </summary> /// <returns></returns> public string AcceptTrueIP() { string user_IP = null; if (HttpContext.Current.Request.ServerVariables["HTTP_VIA"] != null) { user_IP = HttpContext.Current.Request.ServerVariables 阅读全文
posted @ 2011-05-14 11:21 轻盈 阅读(233) 评论(0) 推荐(0) 编辑