完善修复基础资料列表增删改查功能（物料，仓库，职员，部门，组织，计量单位）

yusijie

2022-11-16 a825c44ff42da28c26c26a17b65dba6c1c896262

 DBUtility/ÒµÎñµ¥¾Ý/ClsXt_BaseBill.cs

@@ -201,12 +201,12 @@
                throw (e);
            }
        }
        //删除子表
        //保养计划删除子表1
        public void DeleteBillSub(Int64 lngBillKey)
        {
            oCn.RunProc("Delete From " + MvarItemKeySub + "  where HInterID=" + lngBillKey.ToString());
        }
        //删除子表
        //保养计划删除子表2
        public void DeleteBillSub2(Int64 lngBillKey)
        {
            if (MvarItemKeySub2 != "")
@@ -463,9 +463,10 @@
        //单据号是否重复
        public virtual bool IsExistBillNo(ref string sReturn, string sBillNo, ClsPub.Enum_BillStatus oBillStatus, Int64 lngBillKey)
        {
            string sSql = "";
            try
            {
                string sSql = "";
           
                if (oBillStatus == ClsPub.Enum_BillStatus.BillStatus_AddNew)
                {
                    sSql = "Select HInterID from " + MvarItemKey + "  where hbilltype='" + BillType + "'and HBillNO ='" + sBillNo + "'";
@@ -486,8 +487,8 @@
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
                sReturn = e.Message+"sql:"+ sSql;
                return false;
            }
        }
        #endregion