/*
 *若建立存储过程
IF EXISTS(SELECT name FROM sysobjects WHERE name='InsertDataIntoS_action_grade' AND TYPE='p')
	DROP PROCEDURE InsertDataIntoS_action_grade
GO
CREATE PROCEDURE InsertDataIntoS_action_grade
	@actionCount int--1表数据记录总数
	@gradeCount int--2表数据记录总数	
	@actionIndex int--1表起始索引
	@gradeIndex int--2表起始索引
AS*/
--TRUNCATE TABLE S_action_grade 如有必要，清空已有数据
declare @actionCount int--1表数据记录总数
declare @gradeCount int--2表数据记录总数
declare @actionIndex int--1表起始索引
declare @gradeIndex int--2表起始索引
set @actionCount=(select count(*) from s_action_info)
set @gradeCount=(select count(*) from e_grade_info)
set @actionIndex=1
while @actionIndex<=@actionCount
begin
	set @gradeIndex=1
	while @gradeIndex<=@gradeCount
		begin
			insert into s_action_grade(action_id,grade_id,day_process_money,total_process_money,tip_type) values(@actionIndex,@gradeIndex,100000,10000000,'1')
			set @gradeIndex=@gradeIndex+1
		end
	set @actionIndex=@actionIndex+1
end
go

var $=function(id){return document.getElementById(id);};
 
var getMouseP=function (e){//获取鼠标坐标 请传递evnet参数
 
				e = e || window.event;
				var m=(e.pageX || e.pageY)?{ x:e.pageX, y:e.pageY } : { x:e.clientX + document.body.scrollLeft - document.body.clientLeft, y:e.clientY + document.body.scrollTop  - document.body.clientTop };
				   return m;
 
			};
 
move=function(o,t){
				o=$(o);
				t=$(t);
				o.onmousedown=function(ev){
					var mxy=getMouseP(ev);//获取当前鼠标坐标
					var by={x:mxy.x-(t.offsetLeft),y:mxy.y-(t.offsetTop)};
					o.style.cursor="move";
					document.onmousemove=function(ev){
							var mxy=getMouseP(ev);
							t.style.left=mxy.x-by.x+"px";
							t.style.top=mxy.y-by.y+"px";
						};
					document.onmouseup=function(){
							window.getSelection ? window.getSelection().removeAllRanges() : document.selection.empty();
							this.onmousemove=null;
						}
				}
	}
move("jelle_test_div","jelle_test_div");

 /// <summary>
 /// 节点定义
 /// </summary>
 public class Node<t>
 {
     private T data;//数据域
     private Node</t><t> next;//引用域
     /// <summary>
     /// 构造器，数据值为输入数据值
     /// </summary>
     /// <param name="val"></param>
     public Node(T val)
     {
         data = val;
         next = null;
     }
     /// <summary>
     /// 构造器，数据值为系统默认值
     /// </summary>
     public Node()
     {
         data = default(T);
         next = null;
     }
     /// <summary>
     /// 数据域属性
     /// </summary>
     public T Data
     {
         get {return data;}
         set { data = value; }
     }
     /// <summary>
     /// 引用域属性
     /// </summary>
     public Node</t><t> Next
     {
         get { return next; }
         set { next = value; }
     }
 }
</t>

/// <summary>
/// 单链表实现
/// </summary>
public class SinglyLinkedList<t>:IListDS</t><t>
{
    private Node</t><t> head;
    /// <summary>
    /// 单链表的头节点
    /// </summary>
    public Node</t><t> Head
    {
        get { return head; }
        set { head = value; }
    }
    /// <summary>
    /// 构造器，构造具有空指针的头节点
    /// </summary>
    public SinglyLinkedList()
    {
        head = null;
    }
    /// <summary>
    /// 求单链表长度
    /// </summary>
    /// <returns></returns>
    public int GetLength()
    {
        Node</t><t> currNode = head;
        int length = 0;
        while (currNode != null)
        {
            ++length;
            currNode = currNode.Next;
        }
        return length;
    }
    /// <summary>
    /// 清空单链表
    /// </summary>
    public void Clear()
    {
        head = null;
    }
    /// <summary>
    /// 判断单链表是否为空
    /// </summary>
    /// <returns></returns>
    public bool IsEmpty()
    {
        return (head == null) ? true : false;
    }
    /// <summary>
    /// 在单链表末尾添加新元素
    /// </summary>
    /// <param name="item"></param>
    public void Append(T item)
    {
        Node</t><t> newNode = new Node</t><t>(item);
        Node</t><t> currNode = null;
        if (head == null)
        {
            head = newNode;
            return;
        }
        currNode = head;
        while (currNode.Next != null)
        {
            currNode = currNode.Next;
        }
        currNode.Next = newNode;
    }
    /// <summary>
    /// 在指定位置插入元素
    /// </summary>
    /// <param name="item"></param>
    /// <param name="pos"></param>
    /// <returns></returns>
    public bool Insert(T item, int pos)
    {
        if (IsEmpty() || pos < 0)
        {
            Console.WriteLine("The list is empty");
            return false;
        }
        Node<T> newNode = new Node</t><t>(item);
        if (pos == 0)
        {
            newNode.Next = head;
            head = newNode;
            return true;
        }
        Node</t><t> currNode = head.Next;
        Node</t><t> preNode = head;
        int index = 1;
        while (currNode.Next != null && index < pos)
        {
            preNode = currNode;
            currNode = currNode.Next;
            ++index;
        }
 
        if (index == pos)
        {
            newNode.Next = currNode;
            preNode.Next = newNode;
            return true;
        }
        else
        {
            Console.WriteLine("The position is error");
            return false;
        }
    }
    /// <summary>
    /// 删除指定索引位置的元素
    /// 
    /// <param name="pos"></param>
    /// <returns></returns>
    public T Delete(int pos)
    {
        if (IsEmpty() || pos < 0)
        {
            Console.WriteLine("The Link is empty");
            return default(T);
        }
 
        T data = default(T);
        if (pos == 0)
        {
            data = head.Data;
            head = head.Next;
            return data;
        }
        Node<T> preNode = this.head;
        Node</t><t> currNode = this.head.Next;
        int index = 1;
        while (currNode.Next != null && index < pos)
        {
            ++index;
            preNode = currNode;
            currNode = currNode.Next;
        }
 
        if (index == pos)
        {
            preNode.Next = currNode.Next;
            return currNode.Data;
        }
        else
        {
            Console.WriteLine("The position is out of range");
            return default(T);
        }
    }
    /// <summary>
    /// 根据索引查找
    /// 
    /// <param name="pos"></param>
    /// <returns></returns>
    public T GetElem(int pos)
    {
        if (IsEmpty())
        {
            Console.WriteLine("The list is empty");
            return default(T);
        }
        Node</t><t> currNode = head;
        int index = 0;
        while (currNode.Next != null && index < pos)
        {
            ++index;
            currNode = currNode.Next;
        }
        if (index == pos)
            return currNode.Data;
        else
        {
            Console.WriteLine("The position is out of range");
            return default(T);
        }
    }
    /// <summary>
    /// 根据值查找
    /// 
    /// <param name="value"></param>
    /// <returns></returns>
    public int Locate(T value)
    {
        if (IsEmpty())
        {
            Console.WriteLine("The list is empty");
            return -1;
        }
        Node</t><t> currNode = new Node</t><t>();
        currNode = head;
        int pos = -1;
        while (currNode != null && currNode.Data.Equals(value))
        {
            currNode = currNode.Next;
            ++pos;
        }
        if (currNode == null)
            return -1;
 
        return pos;
    }
}
</t>

/// <summary>
/// 功能：单链表演示
/// 开发：walkingp
/// 时间：2010-4-29
/// 主页：http://www.51obj.cn/
/// </summary>
class Program
{
    static void Main(string[] args)
    {
        SinglyLinkedList<string> demoList = new SinglyLinkedList</string><string>();
 
        /*添加*/
        demoList.Append("Wang Hongjian");
        demoList.Append("ZhangSan");
        demoList.Append("LiSi");
        for (int i = 0; i < demoList.GetLength(); i++)
        {
            Console.WriteLine("The {0} item is:\t{1}",i, demoList.GetElem(i));
        }
        /*插入*/
        Console.WriteLine("Insert the item:");
        demoList.Insert("Zhangyu", 1);
        for (int i = 0; i < demoList.GetLength(); i++)
        {
            Console.WriteLine("The {0} item is:\t{1}", i, demoList.GetElem(i));
        }
        /*删除*/
        Console.WriteLine("Delelte the item:");
        demoList.Delete(3);
        for (int i = 0; i < demoList.GetLength(); i++)
        {
            Console.WriteLine("The {0} item is:\t{1}", i, demoList.GetElem(i));
        }
        /*根据索引查找*/
        Console.WriteLine("The 2st item is:\t{0}", demoList.GetElem(1));
        /*根据值查找*/
        Console.WriteLine("The position of the item 'Wang Hongjian' is:\t{0}",demoList.Locate("Wang Hongjian"));
        /*清空*/
        demoList.Clear();
        Console.WriteLine("Now the list is empty");
    }

/// <summary>
/// 线性表接口
/// </summary>
/// <typeparam name="T"></typeparam>
public interface IListDS<t>
{
    bool Insert(T item,int pos);//插入元素
    bool IsEmpty();//是否为空
    int GetLength();//得到容量
    void Append(T item);//添加新元素
    void Clear();//清空
    T Delete(int pos);//删除元素
    T GetElem(int pos);//根据索引查找
    int Locate(T value);//根据值查找
}
</t>

/// <summary>
/// 顺序表定义
/// </summary>
/// <typeparam name="T"></typeparam>
class SeqListDef<t>
{
    T[] datas;//存放元素数组
    int pointer;//索引
 
    /// <summary>
    /// 构造器
    /// </summary>
    /// <param name="maxSize"></param>
    public SeqListDef(int maxSize)
    {
        datas=new T[maxSize];
    }
 
    /// <summary>
    /// 增加
    /// </summary>
    /// <param name="item"></param>
    public void AddItem(T item)
    {
        datas[++pointer]=item;
    }
 
    /// <summary>
    /// 显示元素
    /// </summary>
    public void DisplayItems()
    {
        for (int j = 0, l = datas.Length; j < l; j++)
        {
            Console.WriteLine("datas[{0}]", j);
        }
    }
}

/// <summary>
/// 顺序表
/// </summary>
/// <typeparam name="T"></typeparam>
public class SeqList<t>:IListDS</t><t>
{
    #region 变量成员
    private int maxsize;//容量
    private T[] datas;//存放元素的数组
    private int last;//末位置
    #endregion
 
    #region 属性
    /// <summary>
    /// 最后一个元素位置
    /// </summary>
    public int Last
    {
        get
        {
            return last;
        }
    }
 
    /// <summary>
    /// 容量
    /// </summary>
    public int MaxSize
    {
        get
        {
            return maxsize;
        }
        set
        {
            maxsize = value;
        }
    }
    #endregion
 
    /// <summary>
    /// 索引器
    /// </summary>
    /// <param name="index"></param>
    /// <returns></returns>
    public T this[int index]
    {
        get
        {
            return datas[index];
        }
        set
        {
            datas[index] = value;
        }
    }
 
    /// <summary>
    /// 构造器
    /// </summary>
    /// <param name="size"></param>
    public SeqList(int size)
    {
        datas = new T[size];
        maxsize = size;
        last = -1;
    }
 
    #region 方法成员
    /// <summary>
    /// 得到顺序表长度
    /// </summary>
    /// <returns></returns>
    public int GetLength()
    {
        return last + 1;
    }
 
    /// <summary>
    /// 清空顺序表
    /// </summary>
    public void Clear()
    {
        last = -1;
    }
 
    /// <summary>
    /// 判断是否为空
    /// </summary>
    /// <returns></returns>
    public bool IsEmpty()
    {
        if(last==-1)
            return true;
        return false;
    }
 
    /// <summary>
    /// 判断顺序表是否已满
    /// </summary>
    /// <returns></returns>
    public bool IsFull()
    {
        if (last == maxsize - 1)
            return true;
        return false;
    }
 
    /// <summary>
    /// 添加新元素
    /// </summary>
    /// <param name="item"></param>
    public void Append(T item)
    {
        if (IsFull())
        {
            Console.WriteLine("The List's already full yet");
            return;
        }
 
        datas[++last] = item;
    }
 
    /// <summary>
    /// 插入元素
    /// </summary>
    /// <param name="item">元素</param>
    /// <param name="pos">位置</param>
    /// <returns>是否插入成功</returns>
    public bool Insert(T item, int pos)
    {
        if (IsFull())
        {
            Console.WriteLine("The List's already full yet");
            return false;
        }
        if(pos&lt;0 || pos>last+1)
        {
            Console.WriteLine("The position is error");
            return false;
        }
        if (pos == last + 1)
            datas[pos] = item;
        else
        {
            for (int index = last; index >= pos; --index)
            {
                datas[index + 1] = datas[index];
            }
            datas[pos] = item;
        }
        ++last;
        return true;
    }
 
    /// <summary>
    /// 删除元素
    /// </summary>
    /// <param name="pos"></param>
    /// <returns></returns>
    public T Delete(int pos)
    {
        T tmp = default(T);
        if(IsEmpty())
        {
            Console.WriteLine("The List is empty");
            return tmp;
        }
        if(pos&lt;0 || pos>last)
        {
            Console.WriteLine("The position is err");
            return tmp;
        }
        if (pos == last)
            tmp = datas[last];
        else
        {
            tmp = datas[pos];
            for (int index = pos; index < last; ++index)
            {
                datas[index] = datas[index + 1];
            }
        }
        --last;
        return tmp;
    }
 
    /// <summary>
    /// 根据索引查找某一元素
    /// 
    /// <param name="pos">索引</param>
    /// <returns></returns>
    public T GetElem(int pos)
    {
        if (IsEmpty() || (pos < 0) || pos > last)
        {
            Console.WriteLine("List is empty or the position is error");
            return default(T);
        }
        return datas[pos];
    }
 
    /// <summary>
    /// 根据值查找某一元素
    /// </summary>
    /// <param name="value"></param>
    /// <returns></returns>
    public int Locate(T value)
    {
        if (IsEmpty())
        {
            Console.WriteLine("List is empty");
            return -1;
        }
        int index = 0;
        for (index = 0; index < = last; ++index)
        {
            if (value.Equals(datas[index]))
                break;
        }
        if (index > last)
            return -1;
 
        return index;
    }
    #endregion
}</t>

static void Main(string[] args)
{
    SeqList<int> seqList = new SeqList</int><int>(8);
    seqList.Append(21);
    seqList.Append(22);
    seqList.Append(23);
 
    Console.WriteLine("Inital the sequence list");
    for(int i=0;i<seqlist .GetLength();i++)
    {
        Console.WriteLine(seqList[i]);
    }
    Console.WriteLine("Insert method sample:");
    seqList.Insert(20, 0);
    seqList.Insert(24, 4);
    for(int i=0;i<seqList.GetLength();i++)
    {
        Console.WriteLine(seqList[i]);
    }
    Console.WriteLine("Delete method sample:");
    seqList.Delete(0);
    for(int i=0;i<seqList.GetLength();i++)
    {
        Console.WriteLine(seqList[i]);
    }
    Console.WriteLine("The 2st item is:{0}", seqList.GetElem(1));
    Console.WriteLine("The position of value 23 is:{0}", seqList.Locate(23));
    Console.WriteLine("Empty the sequence list");
    seqList.Clear();
    Console.WriteLine("The length of the sequence list is {0}",seqList.GetLength());
}

<frameset rows="78,*,31" cols="*" frameborder="no" border="0" framespacing="0">
  <frame src="top.aspx" name="topFrame" scrolling="No" noresize="noresize" id="topFrame" title="" />
  </frameset><frameset cols="170,*" frameborder="no" border="0" framespacing="0">
    <frame src="left.aspx" name="leftFrame" scrolling="No" noresize="noresize" id="leftFrame" title="" />
    <frame src="main.aspx" name="mainFrame" id="mainFrame" title="" />
  </frameset>
  <frame src="bottom.aspx" name="bottomFrame" scrolling="No" noresize="noresize" id="bottomFrame" />

<style>
<!--
html,body { height:100%; overflow:hidden;}
body{margin:0;padding:0;}
#header{position:absolute;top:0;width:100%;height:100px;background-color:#D6E6B7;}
#left{position:absolute;top:100px;right:auto;left:0;bottom:0;width:200px;overflow:scroll;_height:100%;background-color:#D3EEEE;}
#middle{position:absolute;top:100px;right:auto;left:200px; bottom:0;width:100%;overflow:scroll;_height:100%;background-color:#F0E1D3;}
-->
</style>
 
<body>
	<div id="header"></div>
	<div id="left"></div>
	<div id="middle">
</div>
</body>