工作需要筆記

http://www.codeproject.com/Articles/771455/Diving-in-OOP-Day-Polymorphism-and-Inheritance-Ear

http://www.dotblogs.com.tw/skychang/archive/2012/05/10/72114.aspx

http://hamiltonserena.blogspot.tw/2012/09/c-list_6.html

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        Random rd = new Random();
        //製造50隻熊貓
        List<熊貓> 熊貓家族 = new List<熊貓>();
        for (int i = 1; i < 51; i++)
        {
            int height = rd.Next(170, 200);
            int age = rd.Next(18, 110);            
            if ((age + height) % 2 == 0)
            {
                熊貓家族.Add(new 熊貓() { 姓名 = "熊貓小姐" + i.ToString() + "號", 年紀 = age, 身長 = height, 性別 = "女" });
            }
            else
            {
                熊貓家族.Add(new 熊貓() { 姓名 = "熊貓先生" + i.ToString() + "號", 年紀 = age, 身長 = height, 性別 = "男" });
            }
        }
        //製造100隻龍貓
        rd = new Random();
        List<龍貓> 龍貓家族 = new List<龍貓>();
        for (int i = 1; i < 101; i++)
        {            
            int height = rd.Next(140, 180);
            int age = rd.Next(18, 110);            
            if ((age + height) % 2 == 0)
            {
                龍貓家族.Add(new 龍貓() { 姓名 = "龍貓小姐" + i.ToString() + "號", 年紀 = age, 身長 = height, 性別 = "女" });
            }else
            {
                龍貓家族.Add(new 龍貓() { 姓名 = "龍貓先生" + i.ToString() + "號", 年紀 = age, 身長 = height, 性別 = "男" });
            }
        }
        //製造10狗狗
        rd = new Random();
        List<狗狗> 狗狗家族 = new List<狗狗>();
        for (int i = 1; i < 11; i++)
        {
            int height = rd.Next(120, 160);
            int age = rd.Next(18, 110);            
            if ((age + height) % 2 == 0)
            {
                狗狗家族.Add(new 狗狗() { 姓名 = "哈巴狗小姐" + i.ToString() + "號", 年紀 = age, 身長 = height, 性別 = "女" });
            }
            else
            {
                狗狗家族.Add(new 狗狗() { 姓名 = "哈巴狗先生" + i.ToString() + "號", 年紀 = age, 身長 = height, 性別 = "男" });
            }
        }
        
        龍貓 龍貓媽媽 = new 龍貓();
        龍貓媽媽.年紀 = 28;
        龍貓媽媽.身長 = 80;
        龍貓媽媽.性別 = "女";

        龍貓孩子 龍貓弟弟 = new 龍貓孩子();
        龍貓弟弟.年紀 = 8;
        龍貓弟弟.身長 = 50;
        龍貓弟弟.性別 = "男";
        龍貓弟弟.技能 = "抓老鼠";

        龍貓孩子 龍貓妹妹 = new 龍貓孩子();
        龍貓妹妹.年紀 = 4;
        龍貓妹妹.身長 = 40;
        龍貓妹妹.性別 = "女";
        龍貓妹妹.技能 = "撿毛球";

        int h_140 = 0;
        int h_150 = 0;
        int h_160 = 0;
        int h_170 = 0;
        foreach(貓貓 item in 龍貓家族)
        {            
            if (item.身長 >= 140 && item.身長 < 150)
            {
                h_140++;
            }else if (item.身長 >= 150 && item.身長 < 160)
            {
                h_150++;
            }
            else if (item.身長 >= 160 && item.身長 < 170)
            {
                h_160++;
            }
            else if (item.身長 >= 170 && item.身長 < 180)
            {
                h_170++;
            }            
        }
        Response.Write("身長140~150的龍貓有" + h_140 + "隻
");
        Response.Write("身長150~160的龍貓有" + h_150 + "隻

<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
<link rel="icon" href="/favicon.ico" type="image/x-icon">

http://www.favicon-generator.org/

http://responsive-jp.com/

<ul>

<asp:Repeater ID="Repeater2" runat="server">

DataView dv = new DataView(dt會員);
dv.Sort = "序號 " + "DESC";   //排序
dv.RowFilter = "序號<20";     //查詢條件
dv.RowFilter = "暱稱 like '%會員%'";     //查詢條件
GridView1.DataSource = dv;
GridView1.DataBind();

http://www.dotblogs.com.tw/yc421206/archive/2009/10/18/11095.aspx

private DataTable 產生dataTable()
    {
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add(new System.Data.DataColumn("姓名", typeof(string)));
        dt.Columns.Add(new System.Data.DataColumn("電話", typeof(string)));
        SqlDataReader dr會員 = xdb.查詢_會員();
        while (dr會員.Read())
        {
            dr = dt.NewRow();
            dr[0] = dr會員["姓名"].ToString();
            dr[1] = dr會員["電話"].ToString();
            dt.Rows.Add(dr);
        }        
        return dt;
    }

//之後再加上欄位內容
        for (int i = 0; i < dt會員.Rows.Count; i++)
        {
            dt會員.Rows[i][2] = i;
        }

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Configuration;
using System.Data;
using System.Data.SqlClient;

/// 
/// db 的摘要描述
/// 
public class db
{
    public string DB連線字串 = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        public db()
        {
                //
                // TODO: 在這裡新增建構函式邏輯
                //
        }
    public SqlConnection 資料庫連線(string connString)
    {
        try
        {
            SqlConnection connDB = new SqlConnection(connString);
            connDB.Open();
            return connDB;
        }
        catch (SqlException ex)
        {
            throw (ex);
        }
    }
    int errCode = 0;
    //***************** 查詢_會員 ***************** 
    public DataSet 查詢_會員(int 第n頁,int 筆數)
    {
        SqlConnection conn = this.資料庫連線(DB連線字串);
        if (conn == null) { errCode = 1; }

        SqlDataAdapter da = new SqlDataAdapter("EXECUTE 會員_查詢", conn);
        DataSet ds = new DataSet();        
        try
        {
            da.Fill(ds, 第n頁, 筆數, "會員清單");
        }
        catch (Exception ex)
        {
            errCode = 1;
        }
        if (conn != null) { conn.Close(); conn.Dispose(); conn = null; }    //連線關閉
        return ds;
    }    
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;

private DataTable GetData()
    {
        DataTable dt = new DataTable();
        DataRow dr;
        dt.Columns.Add(new System.Data.DataColumn("Column1", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column2", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column3", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column4", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column5", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column6", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column7", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column8", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column9", typeof(int)));
        dt.Columns.Add(new System.Data.DataColumn("Column10", typeof(String)));
        dt.Columns.Add(new System.Data.DataColumn("Column11", typeof(String)));
        int totalprice = 0;
        List orderlist = (List)Session["orderlist_session"];
        if (orderlist != null)
        {
            int i = 0;
            foreach (orderProdObj element in orderlist)
            {
                dr = dt.NewRow();
                dr[0] = i;
                dr[1] = element.name;
                dr[2] = element.colorName;
                dr[3] = element.size;
                dr[4] = Convert.ToInt16(element.count);
                dr[5] = Convert.ToInt16(element.totalCount);
                dr[6] = Convert.ToInt16(element.buyPrice);
                dr[7] = Convert.ToInt16(element.count) * Convert.ToInt16(element.buyPrice);
                dr[8] = element.no;
                dr[9] = element.prodDLink;
                dr[10] = element.prodImg;
                dt.Rows.Add(dr);
                totalprice = totalprice + (Convert.ToInt16(element.count) * Convert.ToInt16(element.buyPrice));
                i++;
            }
        }
        totalText.Value = totalprice.ToString();
        //Response.Write(totalprice);

        return dt;

    }