Bll/BOrderFun.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Dal;

namespace Bll
{
    public class BOrderFun
    {
        DOrderFun Ido = new DOrderFun();
        public bool SortDownByCondition(string TableName, string OrderName, string IdName, string IdValue, string Andsql, bool Asc, string OrderTable)
        {
            DataTable thisdt = Ido.getThisOrderBySearch(TableName, OrderName, IdName, IdValue);
            if (thisdt.Rows.Count < 1)
            {
                return false;
            }

            DataTable downdt = null;
            if (Asc)
            {
                downdt = Ido.getDownNextIdOrderAscBySearch(TableName, OrderName, IdName, Andsql, thisdt.Rows[0][0].ToString());
            }
            else
            {
                downdt = Ido.getDownNextIdOrderDescBySearch(TableName, OrderName, IdName, Andsql, thisdt.Rows[0][0].ToString());
            }
            if (downdt.Rows.Count < 1)
            {
                return false;
            }

            return Ido.UpdateOder(OrderTable, IdName, OrderName, IdValue, thisdt.Rows[0][0].ToString(), downdt.Rows[0][0].ToString(), downdt.Rows[0][1].ToString());
        }

        public bool SortUpByCondition(string TableName, string OrderName, string IdName, string IdValue, string Andsql, bool Asc, string OrderTable)
        {
            DataTable thisdt = Ido.getThisOrderBySearch(TableName, OrderName, IdName, IdValue);
            if (thisdt.Rows.Count < 1)
            {
                return false;
            }

            DataTable updt = null;
            if (Asc)
            {
                updt = Ido.getUpNextIdOrderAscBySearch(TableName, OrderName, IdName, Andsql, thisdt.Rows[0][0].ToString());
            }
            else
            {
                updt = Ido.getUpNextIdOrderDescBySearch(TableName, OrderName, IdName, Andsql, thisdt.Rows[0][0].ToString());
            }
            if (updt.Rows.Count < 1)
            {
                return false;
            }
            return Ido.UpdateOder(OrderTable, IdName, OrderName, IdValue, thisdt.Rows[0][0].ToString(), updt.Rows[0][0].ToString(), updt.Rows[0][1].ToString());
        }