Libs/MojoCube.Office/Sql.cs

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

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

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

namespace MojoCube.Office
{
    public class Sql
    {
        #region  定义属性
        string _TableName;
        public string TableName
        {
            get { return _TableName; }
            set { _TableName = value; }
        }
        string _OrderByKey;
        public string OrderByKey
        {
            get { return _OrderByKey; }
            set { _OrderByKey = value; }
        }
        string _OrderByType;
        public string OrderByType
        {
            get { return _OrderByType; }
            set { _OrderByType = value; }
        }
        string _Where;
        public string Where
        {
            get { return _Where; }
            set { _Where = value; }
        }
        string _pk_ID;
        public string pk_ID
        {
            get { return _pk_ID; }
            set { _pk_ID = value; }
        }
        string _ParentID;
        public string ParentID
        {
            get { return _ParentID; }
            set { _ParentID = value; }
        }
        #endregion

        #region  sql操作
        //多表查询  
        //如： 
        //StringBuilder sb = new StringBuilder(); sb.Append("update tableName set username='baidu' where pk_ID=1"); sb.Append(" update tableName set username='google' where pk_ID=2");
        //SqlQuery(sb.ToString());
        public static void SqlQuery(string strSql)
        {
            SqlConnection conn = new SqlConnection(Connection.ConnString());
            conn.Open();
            SqlTransaction trans = conn.BeginTransaction();