Examples/eDataBase.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Text;
using EKETEAM.Data;
using EKETEAM.FrameWork;

namespace eFrameWork.Examples
{
    public partial class _eDataBase : System.Web.UI.Page
    {
        public eAction action;
        protected void Page_Load(object sender, EventArgs e)
        {
            action = new eAction();
            action.Actioning += action_Actioning;
            action.Listen();
        }
        protected void action_Actioning(string Action)
        {
            string sql = "";
            string ID = "";
            switch (Action)
            {
                case "":
                    litBody.Text = "无";
                    break;
                case "add":
                    sql = "insert into Demo_Persons (FullName,Account,PassWord) values ('测试','test','" + eBase.getPassWord("123456") + "')";
                    eBase.DataBase.Execute(sql);
                    litBody.Text = "添加成功,ID=";// + eBase.DataBase.ID;
                    break;
                case "edit":
                    //sql = "update Demo_Persons set FullName=FullName + 'a' where ID=3";//修改指定条件记录
                    sql = "select ID from Demo_Persons where delTag=0 order by ID desc"; //修改最后一条记录
                    ID = eBase.DataBase.getValue(sql);
                    sql = "update Demo_Persons set FullName=FullName + 'a' where ID=" + ID;
                    eBase.DataBase.Execute(sql);
                    litBody.Text = "修改成功,ID=" + ID;
                    break;
                case "del":
                    sql = "select ID from Demo_Persons where delTag=0 order by ID desc";
                    ID = eBase.DataBase.getValue(sql); //要删除记录的ID

                    //sql = "update Demo_Persons set delTag=1 where ID=" + ID;//假删除
                    sql = "delete from Demo_Persons where ID=" + ID;//真删除
                    eBase.DataBase.Execute(sql);
                    litBody.Text = "删除成功,ID=" + ID;
                    break;
                case "list":
                    sql = "select top 5 ID,FullName from Demo_Persons where delTag=0 order by NewID()";//随机取
                    DataTable tb = eBase.DataBase.getDataTable(sql);
                    StringBuilder sb = new StringBuilder();
                    foreach (DataRow dr in tb.Rows)
                    {
                        sb.Append("ID=" + dr["ID"].ToString() + ",FullName=" + dr["FullName"].ToString() + "<BR>\r\n");
                    }