Esempio n. 1
0
        /// <summary>
        /// 获得单据号码
        /// </summary>
        /// <param name="p_FormNoID">单据ID</param>
        /// <param name="p_Num">第几个单据号码0,1,2,</param>
        /// <param name="sqlTrans">事务</param>
        public string RGetFormNoVendor(int p_FormNoID, int p_FNCVID, string p_VendorID, IDBTransAccess sqlTrans)
        {
            try
            {
                string        outstr = "";
                FormNoControl entity = new FormNoControl(sqlTrans);
                entity.ID = p_FormNoID;
                entity.SelectByID();
                if (entity.NoType == 2)//使用具体业务表进行处理
                {
                    FormNCVendorRule nvRule = new FormNCVendorRule();

                    outstr = nvRule.RGetFormNo(entity, p_FNCVID, p_VendorID, sqlTrans);
                    //Data_FormNCVendor
                }
                else
                {
                    outstr = "单号异常,设置类型错误";
                }
                return(outstr);
            }
            catch (BaseException)
            {
                throw;
            }
            catch (Exception E)
            {
                throw new BaseException(E.Message);
            }
        }
Esempio n. 2
0
        /// <summary>
        /// 新增(传入事务处理)
        /// </summary>
        /// <param name="p_BE">要新增的实体</param>
        /// <param name="sqlTrans">事务类</param>
        public void RAdd(BaseEntity p_BE, IDBTransAccess sqlTrans)
        {
            try
            {
                this.CheckCorrect(p_BE);
                FHForm    entity = (FHForm)p_BE;
                string    sql    = "SELECT FormNo FROM Sale_FHForm WHERE FormNo=" + SysString.ToDBString(entity.FormNo);
                DataTable dt     = sqlTrans.Fill(sql);
                if (dt.Rows.Count > 0)
                {
                    throw new BaseException("单号已存在,请重新生成");
                }

                sql = "SELECT SendCode FROM Sale_FHForm WHERE SendCode=" + SysString.ToDBString(entity.SendCode);
                dt  = sqlTrans.Fill(sql);
                if (dt.Rows.Count > 0)
                {
                    throw new BaseException("送货单号已存在,请重新生成");
                }
                FHFormCtl control = new FHFormCtl(sqlTrans);
                entity.ID = (int)EntityIDTable.GetID((long)SysEntity.Sale_FHForm, sqlTrans);
                control.AddNew(entity);

                FormNoControlRule rulest = new FormNoControlRule();
                rulest.RAddSort((int)FormNoControlEnum.发货单号, sqlTrans);

                FormNCVendorRule rulencv = new FormNCVendorRule();
                rulencv.RAddSort((int)FormNoControlEnum.发货单送货单号, (int)EnumFNCV.发货单送货单号, entity.VendorID, sqlTrans);
            }
            catch (BaseException)
            {
                throw;
            }
            catch (Exception E)
            {
                throw new BaseException(E.Message);
            }
        }