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

namespace DAL
{
    public class ClsCg_CarTrajectoryBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsCg_CarTrajectoryBillMain omodel = new Model.ClsCg_CarTrajectoryBillMain();
        public List<Model.ClsCg_CarTrajectoryBillSub> DetailColl = new List<Model.ClsCg_CarTrajectoryBillSub>();

        public ClsCg_CarTrajectoryBill()
        {
            base.MvarItemKeySub = "Cg_CarTrajectoryBillSub";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey = "Cg_CarTrajectoryBillMain";
            base.MvarReportTitle = "车辆轨迹单据";
            base.BillType = "1119";
            base.HBillSubType = "1119";
        }

        #region 固定代码

        ~ClsCg_CarTrajectoryBill()
        {
            DetailColl = null;
        }

        #endregion

        #region 自定义方法

        // 修改单据
      
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                oCn.BeginTran();

                // 保存前控制 - 与新增保持一致
                string HBillNote = "";
                DataSet ds = oCn.RunProcReturn("EXEC h_p_Cg_CarTrajectoryBill_BeforeSaveCtrl " +
                    omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',2 ",
                    "h_p_Cg_CarTrajectoryBill_BeforeSaveCtrl");

                if (ds == null)
                {
                    sReturn = "保存前判断失败！";
                    return false;
                }

                if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
                    return false;
                }

                // 更新主表
                string updateSql = "UPDATE Cg_CarTrajectoryBillMain SET " +
                    "HBillNo = '" + omodel.HBillNo + "', " +
                    "HDate = '" + omodel.HDate.ToString() + "', " +
                    "HYear = " + omodel.HYear.ToString() + ", " +
                    "HPeriod = " + omodel.HPeriod.ToString() + ", " +
                    "HRemark = '" + omodel.HRemark + "', " +
                    "HUpDater = '" + DBUtility.ClsPub.CurUserName + "', " +
                    "HUpDateDate = GETDATE(), " +
                    // 自定义字段
                    "HContractTransportBillMainID = " + (omodel.HContractTransportBillMainID.HasValue ? omodel.HContractTransportBillMainID.ToString() : "NULL") + ", " +
                    "HContractTransportBillNo = '" + (omodel.HContractTransportBillNo ?? "") + "', " +
                    "HCarNumber = '" + omodel.HCarNumber + "', " +
                    "HGetTime = '" + omodel.HGetTime.ToString() + "', " +
                    "HLongitude = " + (omodel.HLongitude.HasValue ? omodel.HLongitude.ToString() : "NULL") + ", " +
                    "HLatitude = " + (omodel.HLatitude.HasValue ? omodel.HLatitude.ToString() : "NULL") + " " +
                    "WHERE HInterID = " + lngBillKey.ToString();

                // 调试输出
                LogToFile("执行更新SQL: " + updateSql);

                oCn.RunProc(updateSql);

                // 删除关联
                DeleteRelation(ref sReturn, lngBillKey);

                // 删除子表
                DeleteBillSub(omodel.HInterID);

                // 插入子表数据
                foreach (Model.ClsCg_CarTrajectoryBillSub oSub in DetailColl)
                {
                    string insertSubSql = "INSERT INTO Cg_CarTrajectoryBillSub " +
                        "(HInterID, HBillNo_bak, HEntryID, HCloseMan, HEntryCloseDate, HCloseType, HRemark, " +
                        "HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HRelationQty, HRelationMoney) " +
                        "VALUES (" +
                        omodel.HInterID.ToString() + ", '" +
                        omodel.HBillNo + "', " +
                        oSub.HEntryID.ToString() + ", '" +
                        oSub.HCloseMan + "', '" +
                        oSub.HEntryCloseDate.ToString("yyyy-MM-dd") + "', " +
                        Convert.ToInt32(oSub.HCloseType) + ", '" +
                        oSub.HRemark + "', " +
                        oSub.HSourceInterID.ToString() + ", " +
                        oSub.HSourceEntryID.ToString() + ", '" +
                        oSub.HSourceBillNo + "', '" +
                        oSub.HSourceBillType + "', " +
                        oSub.HRelationQty.ToString() + ", " +
                        oSub.HRelationMoney.ToString() + ")";

                    oCn.RunProc(insertSubSql);
                }


                DataSet ds2 = oCn.RunProcReturn("EXEC h_p_Cg_CarTrajectoryBill_AfterSaveCtrl " +
                    omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',2 ",
                    "h_p_Cg_CarTrajectoryBill_AfterSaveCtrl");

                if (ds2 == null)
                {
                    sReturn = "保存后控制判断失败！";
                    oCn.RollBack();
                    return false;
                }

                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
                    oCn.RollBack();
                    return false;
                }

                sReturn = "修改单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                // 记录详细的错误信息
                string errorDetails = $"编辑单据失败！HInterID: {omodel.HInterID}, HBillNo: {omodel.HBillNo}\n" +
                                     $"错误信息: {e.Message}\n" +
                                     $"堆栈跟踪: {e.StackTrace}";

                LogToFile(errorDetails);
                System.Diagnostics.Debug.WriteLine(errorDetails);

                sReturn = "编辑单据失败！" + e.Message;
                oCn.RollBack();
                throw;
            }
        }

        // 添加日志方法
        private void LogToFile(string message)
        {
            string logPath = @"D:\Logs\MES-SQL.log";
            try
            {
                if (!System.IO.Directory.Exists(@"D:\Logs"))
                    System.IO.Directory.CreateDirectory(@"D:\Logs");

                System.IO.File.AppendAllText(logPath, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + " - " + message + Environment.NewLine);
            }
            catch { }
        }
        // 新增单据
        public override bool AddBill(ref string sReturn)
        {
            try
            {
                oCn.BeginTran();

                // 获取新的HInterID
                if (omodel.HInterID == 0)
                {
                    sReturn = "123";
                    return false;
                }

                // 保存前控制
                string HBillNote = "";
                DataSet ds = oCn.RunProcReturn("EXEC h_p_Cg_CarTrajectoryBill_BeforeSaveCtrl " +
                    omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ",
                    "h_p_Cg_CarTrajectoryBill_BeforeSaveCtrl");

                if (ds == null)
                {
                    sReturn = "保存前判断失败！";
                    return false;
                }

                if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
                    return false;
                }

                // 插入主表
                string insertMainSql = "INSERT INTO Cg_CarTrajectoryBillMain " +
                    "(HYear, HPeriod, HBillType, HBillSubType, HInterID, HDate, HBillNo, HBillStatus, " +
                    "HCheckItemNowID, HCheckItemNextID, HCheckFlowID, HRemark, HBacker, HBackDate, HBackRemark, " +
                    "HChecker, HCheckDate, HMaker, HMakeDate, HUpDater, HUpDateDate, HCloseMan, HCloseDate, " +
                    "HCloseType, HDeleteMan, HDeleteDate, HMainSourceBillType, HMainSourceInterID, " +
                    "HMainSourceEntryID, HMainSourceBillNo, HPrintQty, HContractTransportBillMainID, " +
                    "HContractTransportBillNo, HCarNumber, HGetTime, HLongitude, HLatitude) " +
                    "VALUES (" +
                    omodel.HYear.ToString() + ", " +
                    omodel.HPeriod.ToString() + ", '" +
                    this.BillType + "', '" +
                    this.HBillSubType + "', " +
                    omodel.HInterID.ToString() + ", '" +
                    omodel.HDate.ToString() + "', '" +
                    omodel.HBillNo + "', " +
                    omodel.HBillStatus.ToString() + ", " +
                    omodel.HCheckItemNowID.ToString() + ", " +
                    omodel.HCheckItemNextID.ToString() + ", " +
                    omodel.HCheckFlowID.ToString() + ", '" +
                    omodel.HRemark + "', '" +
                    omodel.HBacker + "', " +
                    (omodel.HBackDate.HasValue ? "'" + omodel.HBackDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'" : "NULL") + ", '" +
                    omodel.HBackRemark + "', '" +
                    omodel.HChecker + "', " +
                    (omodel.HCheckDate.HasValue ? "'" + omodel.HCheckDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'" : "NULL") + ", '" +
                    omodel.HMaker + "', '" +
                    omodel.HMakeDate.ToString() + "', '" +
                    omodel.HUpDater + "', " +
                    (omodel.HUpDateDate.HasValue ? "'" + omodel.HUpDateDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'" : "NULL") + ", '" +
                    omodel.HCloseMan + "', " +
                    (omodel.HCloseDate.HasValue ? "'" + omodel.HCloseDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'" : "NULL") + ", " +
                    Convert.ToInt32(omodel.HCloseType) + ", '" +
                    omodel.HDeleteMan + "', " +
                    (omodel.HDeleteDate.HasValue ? "'" + omodel.HDeleteDate.Value.ToString("yyyy-MM-dd HH:mm:ss") + "'" : "NULL") + ", '" +
                    omodel.HMainSourceBillType + "', " +
                    (omodel.HMainSourceInterID.HasValue ? omodel.HMainSourceInterID.ToString() : "NULL") + ", " +
                    (omodel.HMainSourceEntryID.HasValue ? omodel.HMainSourceEntryID.ToString() : "NULL") + ", '" +
                    omodel.HMainSourceBillNo + "', " +
                    omodel.HPrintQty.ToString() + ", " +
                    (omodel.HContractTransportBillMainID.HasValue ? omodel.HContractTransportBillMainID.ToString() : "NULL") + ", '" +
                    omodel.HContractTransportBillNo + "', '" +
                    omodel.HCarNumber + "', '" +
                    omodel.HGetTime.ToString() + "', " +
                    (omodel.HLongitude.HasValue ? omodel.HLongitude.ToString() : "NULL") + ", " +
                    (omodel.HLatitude.HasValue ? omodel.HLatitude.ToString() : "NULL") + ")";


                oCn.RunProc(insertMainSql);

                // 获取自动生成的HInterID
                //DataSet dsMainID = oCn.RunProcReturn("SELECT SCOPE_IDENTITY() AS HInterID", "GetMainID");
                //if (dsMainID != null && dsMainID.Tables[0].Rows.Count > 0)
                //{
                //    omodel.HInterID = Convert.ToInt32(dsMainID.Tables[0].Rows[0]["HInterID"]);
                //}


                // 插入子表数据
                foreach (Model.ClsCg_CarTrajectoryBillSub oSub in DetailColl)
                {
                    string insertSubSql = "INSERT INTO Cg_CarTrajectoryBillSub " +
                        "(HInterID, HBillNo_bak, HEntryID, HCloseMan, HEntryCloseDate, HCloseType, HRemark, " +
                        "HSourceInterID, HSourceEntryID, HSourceBillNo, HSourceBillType, HRelationQty, HRelationMoney) " +
                        "VALUES (" +
                        omodel.HInterID.ToString() + ", '" +
                        omodel.HBillNo + "', " +
                        oSub.HEntryID.ToString() + ", '" +
                        oSub.HCloseMan + "', '" +
                        oSub.HEntryCloseDate.ToString("yyyy-MM-dd") + "', " +
                        Convert.ToInt32(oSub.HCloseType) + ", '" +
                        oSub.HRemark + "', " +
                        oSub.HSourceInterID.ToString() + ", " +
                        oSub.HSourceEntryID.ToString() + ", '" +
                        oSub.HSourceBillNo + "', '" +
                        oSub.HSourceBillType + "', " +
                        oSub.HRelationQty.ToString() + ", " +
                        oSub.HRelationMoney.ToString() + ")";

                    oCn.RunProc(insertSubSql);
                }

                // 保存后控制
                DataSet ds2 = oCn.RunProcReturn("EXEC h_p_Cg_CarTrajectoryBill_AfterSaveCtrl " +
                    omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ",
                    "h_p_Cg_CarTrajectoryBill_AfterSaveCtrl");

                if (ds2 == null)
                {
                    sReturn = "保存后控制判断失败！";
                    oCn.RollBack();
                    return false;
                }

                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
                    oCn.RollBack();
                    return false;
                }

                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }


        // 显示单据
   
        public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                // 查询主表
                DataSet Ds = oCn.RunProcReturn("SELECT * FROM Cg_CarTrajectoryBillMain WHERE HInterID = " + lngBillKey.ToString(),
                    "Cg_CarTrajectoryBillMain");

                if (Ds.Tables[0].Rows.Count == 0)
                {
                    sReturn = "单据未找到！";
                    return false;
                }

                DataRow row = Ds.Tables[0].Rows[0];

                // 基本字段 - 使用安全转换
                omodel.HYear = SafeConvertToInt(row["HYear"]);
                omodel.HPeriod = SafeConvertToInt(row["HPeriod"]);
                omodel.HBillType = SafeConvertToString(row["HBillType"]);
                omodel.HBillSubType = SafeConvertToString(row["HBillSubType"]);
                omodel.HInterID = SafeConvertToInt(row["HInterID"]);
                omodel.HDate = SafeConvertToDateTime(row["HDate"], DateTime.Now);
                omodel.HBillNo = SafeConvertToString(row["HBillNo"]);
                omodel.HBillStatus = SafeConvertToInt(row["HBillStatus"]);
                omodel.HCheckItemNowID = SafeConvertToInt(row["HCheckItemNowID"]);
                omodel.HCheckItemNextID = SafeConvertToInt(row["HCheckItemNextID"]);
                omodel.HCheckFlowID = SafeConvertToInt(row["HCheckFlowID"]);
                omodel.HRemark = SafeConvertToString(row["HRemark"]);

                // 可空日期字段
                omodel.HBackDate = SafeConvertToNullableDateTime(row["HBackDate"]);
                omodel.HBacker = SafeConvertToString(row["HBacker"]);
                omodel.HBackRemark = SafeConvertToString(row["HBackRemark"]);
                omodel.HCheckDate = SafeConvertToNullableDateTime(row["HCheckDate"]);
                omodel.HChecker = SafeConvertToString(row["HChecker"]);
                omodel.HMaker = SafeConvertToString(row["HMaker"]);
                omodel.HMakeDate = SafeConvertToDateTime(row["HMakeDate"], DateTime.Now);
                omodel.HUpDateDate = SafeConvertToNullableDateTime(row["HUpDateDate"]);
                omodel.HUpDater = SafeConvertToString(row["HUpDater"]);
                omodel.HCloseDate = SafeConvertToNullableDateTime(row["HCloseDate"]);
                omodel.HCloseMan = SafeConvertToString(row["HCloseMan"]);
                omodel.HCloseType = SafeConvertToBool(row["HCloseType"]);
                omodel.HDeleteDate = SafeConvertToNullableDateTime(row["HDeleteDate"]);
                omodel.HDeleteMan = SafeConvertToString(row["HDeleteMan"]);

                // 源单信息
                omodel.HMainSourceBillType = SafeConvertToString(row["HMainSourceBillType"]);
                omodel.HMainSourceInterID = row["HMainSourceInterID"] == DBNull.Value ? (int?)null : SafeConvertToInt(row["HMainSourceInterID"]);
                omodel.HMainSourceEntryID = row["HMainSourceEntryID"] == DBNull.Value ? (int?)null : SafeConvertToInt(row["HMainSourceEntryID"]);
                omodel.HMainSourceBillNo = SafeConvertToString(row["HMainSourceBillNo"]);
                omodel.HPrintQty = SafeConvertToInt(row["HPrintQty"]);

                // 自定义字段
                omodel.HContractTransportBillMainID = row["HContractTransportBillMainID"] == DBNull.Value ? (int?)null : SafeConvertToInt(row["HContractTransportBillMainID"]);
                omodel.HContractTransportBillNo = SafeConvertToString(row["HContractTransportBillNo"]);
                omodel.HCarNumber = SafeConvertToString(row["HCarNumber"]);
                omodel.HGetTime = SafeConvertToDateTime(row["HGetTime"], DateTime.Now);

                // 经纬度字段
                omodel.HLongitude = row["HLongitude"] == DBNull.Value ? (decimal?)null : SafeConvertToDecimal(row["HLongitude"]);
                omodel.HLatitude = row["HLatitude"] == DBNull.Value ? (decimal?)null : SafeConvertToDecimal(row["HLatitude"]);

                omodel.HItemMainID = SafeConvertToInt(row["HItemMainID"]);

                // 查询子表
                DataSet DsSub = oCn.RunProcReturn("SELECT * FROM Cg_CarTrajectoryBillSub WHERE HInterID = " +
                    omodel.HInterID.ToString() + " ORDER BY HEntryID", "Cg_CarTrajectoryBillSub");

                DetailColl.Clear();
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsCg_CarTrajectoryBillSub oSub = new Model.ClsCg_CarTrajectoryBillSub();
                    DataRow subRow = DsSub.Tables[0].Rows[i];

                    // 使用安全转换
                    oSub.HInterID = SafeConvertToInt(subRow["HInterID"]);
                    oSub.HBillNo_bak = SafeConvertToString(subRow["HBillNo_bak"]);
                    oSub.HEntryID = SafeConvertToInt(subRow["HEntryID"]);
                    oSub.HCloseMan = SafeConvertToString(subRow["HCloseMan"]);
                    oSub.HEntryCloseDate = SafeConvertToDateTime(subRow["HEntryCloseDate"], DateTime.Now);  // 第404行修复
                    oSub.HCloseType = SafeConvertToBool(subRow["HCloseType"]);
                    oSub.HRemark = SafeConvertToString(subRow["HRemark"]);
                    oSub.HSourceInterID = SafeConvertToInt(subRow["HSourceInterID"]);
                    oSub.HSourceEntryID = SafeConvertToInt(subRow["HSourceEntryID"]);
                    oSub.HSourceBillNo = SafeConvertToString(subRow["HSourceBillNo"]);
                    oSub.HSourceBillType = SafeConvertToString(subRow["HSourceBillType"]);
                    oSub.HRelationQty = SafeConvertToDecimal(subRow["HRelationQty"]);
                    oSub.HRelationMoney = SafeConvertToDecimal(subRow["HRelationMoney"]);
                    oSub.HItemSubID = SafeConvertToInt(subRow["HItemSubID"]);

                    DetailColl.Add(oSub);
                }

                sReturn = "显示单据成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = $"显示单据失败！单据ID: {lngBillKey}，错误: {e.Message}";
                throw;
            }
        }


        // 安全转换辅助方法 - 添加到 ClsCg_CarTrajectoryBill 类中

        #region 安全转换方法

        /// <summary>
        /// 安全转换为整数
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的整数，转换失败返回0</returns>
        private int SafeConvertToInt(object value)
        {
            if (value == null || value == DBNull.Value)
                return 0;

            try
            {
                return Convert.ToInt32(value);
            }
            catch
            {
                // 如果转换失败，尝试字符串解析
                int result;
                if (int.TryParse(value.ToString(), out result))
                    return result;

                return 0; // 默认值
            }
        }

        /// <summary>
        /// 安全转换为可空整数
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的可空整数，转换失败返回null</returns>
        private int? SafeConvertToNullableInt(object value)
        {
            if (value == null || value == DBNull.Value)
                return null;

            try
            {
                return Convert.ToInt32(value);
            }
            catch
            {
                int result;
                if (int.TryParse(value.ToString(), out result))
                    return result;

                return null; // 转换失败返回null
            }
        }

        /// <summary>
        /// 安全转换为字符串
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的字符串，转换失败返回空字符串</returns>
        private string SafeConvertToString(object value)
        {
            if (value == null || value == DBNull.Value)
                return string.Empty;

            try
            {
                return value.ToString().Trim();
            }
            catch
            {
                return string.Empty;
            }
        }

        /// <summary>
        /// 安全转换为可空日期时间
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的可空日期时间，转换失败返回null</returns>
        private DateTime? SafeConvertToNullableDateTime(object value)
        {
            if (value == null || value == DBNull.Value)
                return null;

            try
            {
                return Convert.ToDateTime(value);
            }
            catch
            {
                // 尝试字符串解析
                DateTime result;
                if (DateTime.TryParse(value.ToString(), out result))
                    return result;

                return null; // 所有尝试都失败
            }
        }

        /// <summary>
        /// 安全转换为日期时间
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <param name="defaultValue">默认值</param>
        /// <returns>转换后的日期时间，转换失败返回默认值</returns>
        private DateTime SafeConvertToDateTime(object value, DateTime defaultValue)
        {
            DateTime? result = SafeConvertToNullableDateTime(value);
            return result ?? defaultValue;
        }

        /// <summary>
        /// 安全转换为小数
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的小数，转换失败返回0</returns>
        private decimal SafeConvertToDecimal(object value)
        {
            if (value == null || value == DBNull.Value)
                return 0m;

            try
            {
                return Convert.ToDecimal(value);
            }
            catch
            {
                decimal result;
                if (decimal.TryParse(value.ToString(), out result))
                    return result;

                return 0m; // 默认值
            }
        }

        /// <summary>
        /// 安全转换为可空小数
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的可空小数，转换失败返回null</returns>
        private decimal? SafeConvertToNullableDecimal(object value)
        {
            if (value == null || value == DBNull.Value)
                return null;

            try
            {
                return Convert.ToDecimal(value);
            }
            catch
            {
                decimal result;
                if (decimal.TryParse(value.ToString(), out result))
                    return result;

                return null; // 转换失败返回null
            }
        }

        /// <summary>
        /// 安全转换为布尔值
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的布尔值，转换失败返回false</returns>
        private bool SafeConvertToBool(object value)
        {
            if (value == null || value == DBNull.Value)
                return false;

            try
            {
                // 处理数据库 BIT 类型
                if (value is bool)
                    return (bool)value;

                if (value is int)
                    return ((int)value) != 0;

                if (value is string)
                {
                    string strValue = ((string)value).ToLower().Trim();
                    return strValue == "1" || strValue == "true" || strValue == "t" || strValue == "是";
                }

                // 最后尝试通用转换
                return Convert.ToBoolean(value);
            }
            catch
            {
                return false; // 默认值
            }
        }

        /// <summary>
        /// 安全转换为可空布尔值
        /// </summary>
        /// <param name="value">数据库值</param>
        /// <returns>转换后的可空布尔值，转换失败返回null</returns>
        private bool? SafeConvertToNullableBool(object value)
        {
            if (value == null || value == DBNull.Value)
                return null;

            try
            {
                if (value is bool)
                    return (bool)value;

                if (value is int)
                {
                    int intValue = (int)value;
                    if (intValue == 0) return false;
                    if (intValue == 1) return true;
                    return null; // 无效的布尔值
                }

                if (value is string)
                {
                    string strValue = ((string)value).ToLower().Trim();
                    if (strValue == "0" || strValue == "false" || strValue == "f" || strValue == "否") return false;
                    if (strValue == "1" || strValue == "true" || strValue == "t" || strValue == "是") return true;
                    return null; // 无效的布尔值
                }

                bool result = Convert.ToBoolean(value);
                return result;
            }
            catch
            {
                return null; // 转换失败返回null
            }
        }

        #endregion
        // 获取新的HInterID


        // 判断单据号是否存在
        public override bool IsExistBillNo(ref string sReturn, string sBillNo, DBUtility.ClsPub.Enum_BillStatus eBillStatus, Int64 lngMainID)
        {
            try
            {
                string sql = "SELECT COUNT(*) AS CNT FROM Cg_CarTrajectoryBillMain WHERE HBillNo = '" + sBillNo + "'";
                if (lngMainID > 0)
                {
                    sql += " AND HInterID <> " + lngMainID.ToString();
                }

                DataSet ds = oCn.RunProcReturn(sql, "CheckBillNo");
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    int count = Convert.ToInt32(ds.Tables[0].Rows[0]["CNT"]);
                    return count > 0;
                }
                return false;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                return false;
            }
        }

        #endregion
    }
}