Пример #1
0
        /// <summary>
        /// ** 功能描述:	获得相同机种、经销商、发货日期的出货单信息
        /// ** 作 者:		Jane Shu
        /// ** 日 期:		2005-07-29
        /// ** 修 改:
        /// ** 日 期:
        /// Laws Lu,2005/09/20,修改	排除删除状态的出货单
        /// Karron Qiu,2005/09/20 ,修改,只查询初始状态的出货单
        /// </summary>
        /// <param name="materialStockOut">包含出货单号、机种、经销商、发货日期</param>
        /// <returns></returns>
        public object GetMaterialStockOut(MaterialStockOut materialStockOut)
        {
            object[] objs = this.DataProvider.CustomQuery(typeof(MaterialStockOut),
                                                          new SQLParamCondition(string.Format("select {0} from TBLMSTOCKOUT where TKTNO=$TKTNO and MODELCODE=$MODELCODE and upper(DEALER)=$DEALER and OUTDATE=$OUTDATE AND STATUS = '" + StockStatus.Initial + "' order by seq desc",
                                                                                              DomainObjectUtility.GetDomainObjectFieldsString(typeof(MaterialStockOut))),
                                                                                new SQLParameter[] { new SQLParameter("TKTNO", typeof(string), materialStockOut.TicketNO),
                                                                                                     new SQLParameter("MODELCODE", typeof(string), materialStockOut.ModelCode),
                                                                                                     new SQLParameter("DEALER", typeof(string), materialStockOut.Dealer.ToUpper()),
                                                                                                     new SQLParameter("OUTDATE", typeof(int), materialStockOut.OutDate) }));

            if (objs != null)
            {
                return(objs[0]);
            }

            return(null);
        }
Пример #2
0
        /// <summary>
        /// ** 功能描述:	判断是否有相同机种、经销商、发货日期的出货单存在
        ///					如果存在返回流水号
        ///					如果不存在,则产生新的流水号,将出货单信息新增入表中,并返回生成的流水号
        ///
        ///					返回结果
        /// ** 作 者:		Jane Shu
        /// ** 日 期:		2005-07-29
        /// ** 修 改:       Karron Qiu
        /// ** 日 期:		2005-9-19
        /// </summary>
        /// <param name="materialStockOut"></param>
        /// <returns></returns>
        public MaterialStockOut AddMaterialStockOut(MaterialStockOut materialStockOut)
        {
            MaterialStockOut stockOut = (MaterialStockOut)this.GetMaterialStockOut(materialStockOut);

            //Laws Lu,2005/09/10 修改
            //			if ( stockOut != null )
            //			{
            //				throw new Exception(string.Format("$Error_CS_Stock_Info_Exist $StockOutTicket={0},$ModelCode={1},$Dealer={2},$OutDate={3}",
            //													materialStockOut.TicketNO,
            //													materialStockOut.ModelCode,
            //													materialStockOut.Dealer,
            //													FormatHelper.ToDateString(materialStockOut.OutDate))	);
            //			}
            //
            //			materialStockOut.Sequence = this.GetUniqueSequenceByTicketNo( materialStockOut.TicketNO );
            //			materialStockOut.Status = StockStatus.Initial;
            //			materialStockOut.MaintainDate = FormatHelper.TODateInt(DateTime.Now);
            //			materialStockOut.MaintainTime = FormatHelper.TOTimeInt(DateTime.Now);

            if (stockOut == null)
            {
                //karron qiu ,2005/9/16 ,增加OID主键
                materialStockOut.OID = Guid.NewGuid().ToString();

                materialStockOut.Sequence = this.GetUniqueSequenceByTicketNo(materialStockOut.TicketNO);
                materialStockOut.Status   = StockStatus.Initial;
                //2006/11/17,Laws Lu add get DateTime from db Server
                DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(DataProvider);

                DateTime dtNow = FormatHelper.ToDateTime(dbDateTime.DBDate, dbDateTime.DBTime);

                materialStockOut.MaintainDate = FormatHelper.TODateInt(dtNow);
                materialStockOut.MaintainTime = FormatHelper.TOTimeInt(dtNow);

                this.DataProvider.Insert(materialStockOut);

                stockOut = materialStockOut;
            }

            return(stockOut);
        }
Пример #3
0
 /// <summary>
 /// 获得明细数量  added by karron qiu ,2005-9-19
 /// </summary>
 /// <param name="materialStockOut"></param>
 /// <returns></returns>
 public int GetMaterialStockOutDetailCount(MaterialStockOut materialStockOut)
 {
     return(this.DataProvider.GetCount(new SQLCondition("select count(*) from TBLMSTOCKOUTDETAIL where TKTNO='" + materialStockOut.TicketNO + "' and SEQ=" + materialStockOut.Sequence)));
 }
Пример #4
0
 //Laws Lu,2005/09/05,	更新出库单
 public void UpdateMaterialStockOut(MaterialStockOut materialStockOut)
 {
     this._helper.UpdateDomainObject(materialStockOut);
 }