source/HF.Core/HF.Sale.Data/SaleBranchData.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using HF.DataAccess.SqlDataContract;
using HF.DataAccess.DBAgent;
using HF.Business.Common;
using HF.Framework;
namespace HF.Sale.Data
{
    public class SaleBranchData:BaseData
    {
        public SaleBranchData()
        {
            TableName = "Sale_Branch";
            KeyField = "BranchId";
            Prefix = "brh";
            string[] fields ={ "BranchId", "Caption", "FullCaption", "FatherId"};
            FieldList = fields.Concat(BaseFieldArray).ToArray();//合并基础列
            DataBaseName = SaleModuleHelper.CfgDataBaseName;
        }
        public override string GetNewEnCodeByFatherId(string organizeId, string fatherId)
        {
            SqlDataItem item = new SqlDataItem();
            item.CommandText = "Sale_GetBranchMaxCode";
            item.CommandType = CommandType.StoredProcedure.ToString();
            item.DatabaseName = DataBaseName;
            item.AppendParameter("@organizeId", organizeId);
            item.AppendParameter("@branchId", fatherId);
            ClientDBAgent agent = new ClientDBAgent();
            string r = agent.ExecuteScalar(item);
            return r;
        }
        public static SaleStoreData GetInstance()
        {
            return new SaleStoreData();
        }
        public override DataTable GetChildListTableTop(string organizeId, string fatherId, string enableFlag, string deleteFlag, int n, string sort)
        {
            if (fatherId.IsEmpty()) fatherId = SaleConst.Sale_BranchFirstFatherId;
            if (sort.IsEmpty()) sort = "OrderNum";
            string tmpStr = "select * from Sale_Branch where    ";
            SqlDataItem sqlItem = new SqlDataItem();
            string whereStr =  " FatherId=@FatherId and OrganizeId=@OrganizeId ";
            if (!deleteFlag.IsEmpty())
            {
                whereStr = whereStr + " and DeleteFlag=@delflag ";
                sqlItem.AppendParameter("@delflag", deleteFlag);
            }
            if (!enableFlag.IsEmpty())
            {
                whereStr = whereStr + " and enableFlag=@enableFlag ";
                sqlItem.AppendParameter("@enableFlag", enableFlag);
            }
            sqlItem.CommandText = tmpStr + whereStr+ " order by "+ sort;
            sqlItem.DatabaseName = DataBaseName;
            sqlItem.AppendParameter("@FatherId", fatherId);
            sqlItem.AppendParameter("@OrganizeId", organizeId);
            ClientDBAgent agent = new ClientDBAgent();