MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/BaseData/SlmBaseLoadInfoBll.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using CoreFS.CA06;

using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using ColumnDefine = Core.StlMes.Client.Sale.Common.TbColumnDefine.TbColumnDefine;

namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.BaseData
{
    public class SlmBaseLoadInfoBll : SaleBusinessMgt.BllBase.BaseBll
    {
        public SlmBaseLoadInfoBll(OpeBase ob)
            : base(ob)
        {
            
        }

        /// <summary>
        /// 查询入口
        /// </summary>
        /// <param name="sqlCondition"></param>
        /// <returns></returns>
        private DataSet GetSlmBaseLoadInfo(string sqlCondition)
        {
            string sqlStr = string.Format(SqlCollection.BaseData._QUERYSLMBASESTATION, sqlCondition, base.DateTimeTocharFormat);
            return base.ExecuteQuery(sqlStr);
        }

        /// <summary>
        /// 查询有效汽运数据
        /// </summary>
        /// <param name="carType"></param>
        /// <returns></returns>
        public DataSet GetValidCarSlmBaseLoadInfo()
        {
            string sqlCondition = string.Format(" and cartype = '{0}' and validflag = '{1}'", "汽运", "1");
            return GetSlmBaseLoadInfo(sqlCondition);
        }

        /// <summary>
        /// 查询无效汽运数据
        /// </summary>
        /// <param name="carType"></param>
        /// <returns></returns>
        public DataSet GetNotValidCarSlmBaseLoadInfo()
        {
            string sqlCondition = string.Format(" and cartype = '{0}' and validflag = '{1}'", "汽运", "0");
            return GetSlmBaseLoadInfo(sqlCondition);
        }

        /// <summary>
        /// 查询有效的所有数据
        /// </summary>
        /// <returns></returns>
        public DataSet GetValidSlmBaseLoadInfoAll()
        {
            string sqlCondition = string.Format(" and validflag = '{0}'", "1");
            return GetSlmBaseLoadInfo(sqlCondition);
        }

        /// <summary>
        /// 查询无效的所有数据
        /// </summary>
        /// <returns></returns>
        public DataSet GetNotValidSlmBaseLoadInfoAll()
        {
            string sqlCondition = string.Format(" and validflag = '{0}'", "0");
            return GetSlmBaseLoadInfo(sqlCondition);
        }

        /// <summary>
        /// 查询所有数据(无效、有效)
        /// </summary>
        /// <returns></returns>
        public DataSet GetSlmBaseLoadInfoAll()
        {
            return GetSlmBaseLoadInfo("");
        }

        /// <summary>
        /// 到站信息维护 新增
        /// </summary>
        /// <param name="hs"></param>
        /// <param name="errMsg"></param>
        public void Insert(Hashtable hs, out string errMsg)
        {
            errMsg = "";
            hs.Add(ColumnDefine.SLM_BASE_STATION.STATION_NO, GetSlmBaseStationCode());
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "insert", new object[] { hs });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }

        /// <summary>
        /// 到站信息维护 删除
        /// </summary>
        /// <param name="stationNo"></param>
        public void Delete(string stationNo,string deleteName,out string errMsg)
        {
            errMsg = "";
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "delete", new object[] { stationNo,deleteName });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }

        /// <summary>
        /// 到站信息维护 修改
        /// </summary>
        /// <param name="hs"></param>
        /// <param name="errMsg"></param>
        public void Update(Hashtable hs, out string errMsg)
        {
            errMsg = "";
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "update", new object[] { hs });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }


        /// <summary>
        /// 获取数据行数
        /// </summary>
        /// <returns></returns>
        private double GetCoutOfSlmBaseStation()
        {
            string sqlStr = "select count(1) from slm_base_station ";
            DataSet ds = base.ExecuteQuery(sqlStr);
            if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                return 0;
            return Util.ConverObject.ConvertToDouble(ds.Tables[0].Rows[0][0]);
        }

        /// <summary>
        /// 自动生成客户编码
        /// </summary>
        /// <returns></returns>
        private string GetSlmBaseStationCode()
        {
            string customberno = "";
            string sqlStr = @"select *
                             from (select lpad(l || '', 6, 0) customberno, a.station_no, rownum rn
                                      from (select level - 1 l from dual connect by level <  {0}) b
                                      left join slm_base_station a on a.station_no =
                                                                       lpad(b.l || '', 6, 0)
                                      where a.station_no is null
                                      order by b.l)
                             where rn = 1";
            sqlStr = string.Format(sqlStr, GetCoutOfSlmBaseStation() + 100);
            DataSet ds = base.ExecuteQuery(sqlStr);
            try
            {
                if (ds.Tables[0].Rows.Count == 0)
                    customberno = "000001";
                else
                    customberno = ds.Tables[0].Rows[0]["CUSTOMBERNO"].ToString();
            }
            catch
            {
            }
            return customberno;
        }

        /// <summary>
        /// 服务器方法名路径
        /// </summary>
        private string _ServerName = "core.stlmes.server.sale.service.basedata.SlmBaseStation";
    }
}