开发数据访问层DAL | MiniFramework蝇量框架 | Winform框架|C/S开发框架

    /// <summary>
    /// TMS系统物流派单数据访问层
    /// </summary>
    public partial class dalOrder : dalBase
    {
        IDatabase db_gSales = DatabaseProvider.GetDatabase(DBIDs.gSales);

        /// <summary>
        /// 获取司机资料
        /// </summary>
        /// <returns></returns>
        internal DataTable GetDrivers()
        {
            //表：LogisticsTruck
            var sql = $"select drivername as 驾驶员,driverphone as 手机号码,remark as 短号,licenseplatenumber as 车牌号,LoadWeight as 吨位,companyname as 定位设备号,iscompany as 是否能用 from LogisticsTruck where status = '1'  and (trademark = '{Loginer.Current.DataSetName}' or  isnull(trademark,'') = '{Loginer.Current.DataSetName + Loginer.Current.DataSetProperties}') order by drivername ";
            return db_gSales.GetTable(sql, "LogisticsTruck");
        }

        /// <summary>
        /// 获取物流编组
        /// </summary>
        /// <param name="SONO"></param>
        /// <returns></returns>
        internal string GetGroupNo(string SONO)
        {
            var sql = $"SELECT TOP 1 LogisticGroup from LogisticsInfo where sheetno = @sheetno";
            var cmd = db_gSales.CreateCommand(sql);
            cmd.AddParam("@sheetno", SONO);
            return db_gSales.ExecuteScalar(cmd.Command).ToStringEx();
        }
}