工作笔记（4）

19.下面代码用于在GridView里删除提示
              <ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
    Text="删除" OnClientClick="return confirm('确定要删除吗？')"></asp:LinkButton>
         </ItemTemplate>
20.下面事件是显示光棒
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    //指定当绑定的为数据列时
    if (e.Row.RowType == DataControlRowType.DataRow)
        {
  e.Row.Attributes.Add("onmouseover","currentcolor=this.style.backgroundColor;this.style.backgroundColor='#6699ff'");
e.Row.Attributes.Add("onmouseout","this.style.backgroundColor=currentcolor");
        }
}
21.下面第一个方法是用于从页面上获取值后赋值给实体
第二个方法用于从数据库里边读出数据后赋值给实体
    /// <summary>
    /// 此方法用于从页面上获取值后给实体赋值
    /// </summary>
    /// <param name="obj"></param>
    /// <param name="prop"></param>
    /// <param name="sd"></param>
    public void PropertySetValueOne(object obj,StringDictionary sd)
    {
        Type type = obj.GetType();

        PropertyInfo[] propertyinfo = type.GetProperties();

        foreach (PropertyInfo props in propertyinfo)
        {
            foreach (string key in sd.Keys)
            {
                if (props.Name.ToLower() == key.ToLower())
                {
                    if (!key.Equals(""))
                    {
                        props.SetValue(obj, Convert.ChangeType(sd[key], props.PropertyType),null);
                    }
                    else
                    {
                        props.SetValue(obj,null,null);
                    }
                }
            }
        }
    }

    /// <summary>
    /// 此方法用于重数据库里边读出数据后赋值给实体
    /// </summary>
    /// <returns></returns>
    public object PropertySetValueTwo(object obj,SqlDataReader dr)
    {
        Type type = obj.GetType();
        PropertyInfo[] propert = type.GetProperties();
        foreach (PropertyInfo proper in propert)
        {
            for (int i = 0; i < dr.FieldCount;i++)
            {
                if (proper.Name.ToLower() == dr.GetName(i).ToLower())
                {
                    if (!(dr[i] is DBNull))
                    {
                        proper.SetValue(obj, Convert.ChangeType(dr[i], proper.PropertyType), null);
                    }
                    else
                    {
                        proper.SetValue(obj,null,null);
                    }
                }
            }
        }
        return obj;
}
22.缓存水印图片
        public void ProcessRequest(HttpContext context)
        {
            string imagePath = context.Request.PhysicalPath;
            Bitmap image = null;
            if (context.Cache["imagePath"] == null)
            {
                context.Response.Cache.SetExpires(DateTime.Now.AddMinutes(2));
                image = new Bitmap(imagePath);
                image = addWaterMark(image);
                context.Cache["imagePath"] = image;
            }
            else
            {               
                image = context.Cache["imagePath"] as Bitmap;
                Graphics gs = Graphics.FromImage(image);
                string strs = "这是缓存后的图片";
                Font fonts = new Font("宋体", 20, FontStyle.Bold);
                Brush brushs = Brushes.Blue;
                gs.DrawString(strs, fonts, brushs,0,0);
            }
            image.Save(context.Response.OutputStream, ImageFormat.Jpeg);

        }
        public Bitmap addWaterMark(Bitmap image)
        {
            Graphics g = Graphics.FromImage(image);
            string str = "www.yanjie.com";
            Font font = new Font("宋体", 18, FontStyle.Bold);
            Brush brush = Brushes.Blue;
            SizeF size = g.MeasureString(str, font);
            g.DrawString(str, font, brush, image.Width - size.Width, image.Height - size.Height);
            return image;
        }
23. 缓存编号
<%@ OutputCache Duration="10" VaryByParam="flowerId" %>

24 substring() 和　like查询前三个字母
select * from Policy where (Promulgator = 'hak8880') and (substring(CityPair,1,3)='syx' or substring(CityPair,1,3)='hak')
select * from Policy where (Promulgator = 'hak8880') and (CityPair like 'syx%' or CityPair like 'hak%')

24.９个字符串截取三个一对后..再把另一张表的也是９个字符截取三个一对.再追加到一张表上
select distinct substring(CityPair,1,3) from New_Policy where len(CityPair)=9 union select distinct substring(CityPair,1,3) from New_Tejia where len(CityPair)=9
select distinct substring(CityPair,4,3) from New_Policy where len(CityPair)=9 union select distinct substring(CityPair,3,3) from New_Tejia where len(CityPair)=9

select distinct substring(CityPair,7,3) from New_Policy where len(CityPair)=9 union select distinct substring(CityPair,6,3) from New_Tejia where len(CityPair)=9