Ejemplo n.º 1
0
        /// <summary>
        /// 获取库存信息
        /// </summary>
        /// <param name="p_drData">数据</param>
        /// <returns></returns>
        private clsDS_StorageDetail_VO m_objStorageDetail(DataRow p_drData)
        {
            if (p_drData == null)
            {
                return(null);
            }
            clsDS_StorageDetail_VO objDetail = new clsDS_StorageDetail_VO();

            objDetail.m_dblOPCHARGEFLG_INT = Convert.ToDouble(p_drData["opchargeflg_int"]);
            objDetail.m_dblIPCHARGEFLG_INT = Convert.ToDouble(p_drData["ipchargeflg_int"]);
            objDetail.m_dblPACKQTY_DEC     = Convert.ToDouble(p_drData["packqty_dec"]);

            objDetail.m_dblOPAVAILABLEGROSS_NUM = Convert.ToDouble(p_drData["opcheckresult_int"]) + Math.Round(Convert.ToDouble(p_drData["ipcheckresult_int"]) / objDetail.m_dblPACKQTY_DEC, 2, MidpointRounding.AwayFromZero);
            objDetail.m_dblIPAVAILABLEGROSS_NUM = Convert.ToDouble(p_drData["opcheckresult_int"]) * objDetail.m_dblPACKQTY_DEC + Convert.ToDouble(p_drData["ipcheckresult_int"]);
            objDetail.m_dblOPREALGROSS_INT      = objDetail.m_dblOPAVAILABLEGROSS_NUM;
            objDetail.m_dblIPREALGROSS_INT      = objDetail.m_dblIPAVAILABLEGROSS_NUM;
            objDetail.m_dblOPWHOLESALEPRICE_INT = Convert.ToDouble(p_drData["opcallprice_int"]);
            objDetail.m_dblIPWHOLESALEPRICE_INT = Convert.ToDouble(p_drData["ipcallprice_int"]);
            objDetail.m_dblOPRETAILPRICE_INT    = Convert.ToDouble(p_drData["opretailprice_int"]);
            objDetail.m_dblIPRETAILPRICE_INT    = Convert.ToDouble(p_drData["ipretailprice_int"]);

            objDetail.m_strLOTNO_VCHR     = p_drData["LOTNO_VCHR"].ToString();
            objDetail.m_strINSTOREID_VCHR = p_drData["indrugstoreid_vchr"].ToString();
            objDetail.m_strMEDICINEID_CHR = p_drData["MEDICINEID_CHR"].ToString();

            objDetail.m_dtmVALIDPERIOD_DAT    = Convert.ToDateTime(p_drData["VALIDPERIOD_DAT"]);
            objDetail.m_strDRUGSTOREID_CHR    = m_objViewer.m_strStoreDeptID;
            objDetail.m_strOPUNIT_CHR         = p_drData["opunit_chr"].ToString();
            objDetail.m_strIPUNIT_CHR         = p_drData["ipunit_chr"].ToString();
            objDetail.m_dblOldOPREALGROSS_INT = Convert.ToDouble(p_drData["oprealgross_int"]);
            objDetail.m_dblOldIPREALGROSS_INT = Convert.ToDouble(p_drData["iprealgross_int"]);
            return(objDetail);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// 获取库存明细VO
        /// </summary>
        /// <param name="p_drCommit">数据行</param>
        /// <returns></returns>
        private clsDS_StorageDetail_VO[] m_mthGetStorageDetailVO(DataRow[] p_drCommit)
        {
            if (p_drCommit == null || p_drCommit.Length == 0)
            {
                return(null);
            }

            clsDS_StorageDetail_VO[] objSDVO = null;
            try
            {
                objSDVO = new clsDS_StorageDetail_VO[p_drCommit.Length];
                for (int iRow = 0; iRow < p_drCommit.Length; iRow++)
                {
                    objSDVO[iRow] = new clsDS_StorageDetail_VO();
                    objSDVO[iRow].m_strDRUGSTOREID_CHR   = m_objViewer.m_strDeptID;
                    objSDVO[iRow].m_strMEDICINEID_CHR    = p_drCommit[iRow]["MEDICINEID_CHR"].ToString();
                    objSDVO[iRow].m_strMEDICINENAME_VCHR = p_drCommit[iRow]["MEDICINENAME_VCHR"].ToString();
                    objSDVO[iRow].m_strMEDSPEC_VCHR      = p_drCommit[iRow]["MEDSPEC_VCHR"].ToString();
                    objSDVO[iRow].m_strLOTNO_VCHR        = p_drCommit[iRow]["LOTNO_VCHR"].ToString();
                    objSDVO[iRow].m_dtmVALIDPERIOD_DAT   = Convert.ToDateTime(p_drCommit[iRow]["VALIDPERIOD_DAT"]);
                    objSDVO[iRow].m_strIPUNIT_CHR        = p_drCommit[iRow]["IPUNIT_CHR"].ToString();
                    objSDVO[iRow].m_strOPUNIT_CHR        = p_drCommit[iRow]["OPUNIT_CHR"].ToString();
                    objSDVO[iRow].m_dblIPREALGROSS_INT   = Math.Round(Convert.ToDouble(p_drCommit[iRow]["IPAMOUNT"]), 2, MidpointRounding.AwayFromZero);
                    objSDVO[iRow].m_dblOPREALGROSS_INT   = Math.Round(Convert.ToDouble(p_drCommit[iRow]["OPAMOUNT"]), 2, MidpointRounding.AwayFromZero);
                    objSDVO[iRow].m_dblPACKQTY_DEC       = Convert.ToDouble(p_drCommit[iRow]["PACKQTY_DEC"]);
                    objSDVO[iRow].m_dblIPRETAILPRICE_INT = Math.Round(Convert.ToDouble(p_drCommit[iRow]["IPRETAILPRICE_INT"]), 4, MidpointRounding.AwayFromZero);
                    objSDVO[iRow].m_dblOPRETAILPRICE_INT = Math.Round(Convert.ToDouble(p_drCommit[iRow]["OPRETAILPRICE_INT"]), 4, MidpointRounding.AwayFromZero);
                    try
                    {
                        objSDVO[iRow].m_dblIPWHOLESALEPRICE_INT = Math.Round(Convert.ToDouble(p_drCommit[iRow]["IPWHOLESALEPRICE_INT"]), 4, MidpointRounding.AwayFromZero);
                    }
                    catch
                    {
                    }
                    try
                    {
                        objSDVO[iRow].m_dblOPWHOLESALEPRICE_INT = Math.Round(Convert.ToDouble(p_drCommit[iRow]["OPWHOLESALEPRICE_INT"]), 4, MidpointRounding.AwayFromZero);
                    }
                    catch
                    {
                    }
                    objSDVO[iRow].STATUS = 1;
                    objSDVO[iRow].m_strPRODUCTORID_CHR    = p_drCommit[iRow]["productorid_chr"].ToString();
                    objSDVO[iRow].m_strMEDICINETYPEID_CHR = p_drCommit[iRow]["medicinetypeid_chr"].ToString();
                    objSDVO[iRow].m_strDSINSTOREID_VCHR   = p_drCommit[iRow]["INITIALID_CHR"].ToString();
                }
            }
            catch (Exception Ex)
            {
                return(null);
            }
            return(objSDVO);
        }
Ejemplo n.º 3
0
        /// <summary>
        ///  获取药库出库单明细内容
        /// </summary>
        /// <param name="p_drDetail"></param>
        /// <param name="p_lngMainSEQ"></param>
        /// <returns></returns>
        private clsDS_StorageDetail_VO[] m_mthGetDS_StorageDetail(clsDS_Instorage_VO m_objMainVo)
        {
            clsDS_StorageDetail_VO[] objDetailArr = null;
            //20080724 数量为0 的不用更新库存。
            int intRow = 0;

            for (int i1 = 0; i1 < this.m_objViewer.m_dgvOutStorageDetail.Rows.Count; i1++)
            {
                if (Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[i1].Cells["m_dgvtxtOutAmount"].Value) != 0)
                {
                    intRow++;
                }
            }
            if (intRow > 0)
            {
                objDetailArr = new clsDS_StorageDetail_VO[intRow];
                intRow       = 0;
                for (int iRow = 0; iRow < this.m_objViewer.m_dgvOutStorageDetail.Rows.Count; iRow++)
                {
                    if (Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtOutAmount"].Value) == 0)
                    {
                        continue;
                    }
                    objDetailArr[intRow] = new clsDS_StorageDetail_VO();
                    objDetailArr[intRow].m_strDRUGSTOREID_CHR      = this.m_objViewer.m_dgvOutStorageMain.SelectedRows[0].Cells["m_txtAskDeptid"].Value.ToString();
                    objDetailArr[intRow].m_dtmINSTORAGEDATE_DAT    = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtinstoragedate_dat"].Value == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtinstoragedate_dat"].Value.ToString());
                    objDetailArr[intRow].m_strINSTOREID_VCHR       = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtinstorageid_vchr"].Value.ToString();
                    objDetailArr[intRow].m_strMEDICINEID_CHR       = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["medicineid_chr"].Value.ToString();
                    objDetailArr[intRow].m_strMEDICINENAME_VCHR    = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtMedicineName"].Value.ToString();
                    objDetailArr[intRow].m_strMEDSPEC_VCHR         = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtMedicineSpec"].Value.ToString();
                    objDetailArr[intRow].m_strOPUNIT_CHR           = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtOutUint"].Value.ToString();
                    objDetailArr[intRow].m_dblOPREALGROSS_INT      = Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtOutAmount"].Value.ToString());
                    objDetailArr[intRow].m_strIPUNIT_CHR           = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtipunit_chr"].Value.ToString();
                    objDetailArr[intRow].m_dblIPREALGROSS_INT      = Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txIPAmount"].Value.ToString());
                    objDetailArr[intRow].m_dblPACKQTY_DEC          = Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtPackqty_dec"].Value.ToString());
                    objDetailArr[intRow].m_dtmVALIDPERIOD_DAT      = Convert.ToDateTime(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtEffectDate"].Value.ToString());
                    objDetailArr[intRow].m_strLOTNO_VCHR           = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtProduceNumber"].Value.ToString();
                    objDetailArr[intRow].m_dblOPWHOLESALEPRICE_INT = Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtBuyPrice"].Value.ToString());
                    objDetailArr[intRow].m_dblIPWHOLESALEPRICE_INT = Math.Round(Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtBuyPrice"].Value.ToString()) / Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtPackqty_dec"].Value.ToString()), 4);
                    objDetailArr[intRow].m_dblOPRETAILPRICE_INT    = Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtSalePrice"].Value.ToString());
                    objDetailArr[intRow].m_dblIPRETAILPRICE_INT    = Math.Round(Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_dgvtxtSalePrice"].Value) / Convert.ToDouble(this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtPackqty_dec"].Value.ToString()), 4);
                    objDetailArr[intRow].m_dtmDSINSTORAGEDATE_DAT  = m_objMainVo.m_datMAKEORDER_DAT;
                    objDetailArr[intRow].m_intType               = Convert.ToInt16(m_objMainVo.m_intFORMTYPE_INT);
                    objDetailArr[intRow].m_strDSINSTOREID_VCHR   = m_objMainVo.m_strINDRUGSTOREID_VCHR;
                    objDetailArr[intRow].m_strMEDICINETYPEID_CHR = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["m_txtMedicineTypeid"].Value.ToString();
                    objDetailArr[intRow].m_strPRODUCTORID_CHR    = this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["productorid_chr"].Value != DBNull.Value ? this.m_objViewer.m_dgvOutStorageDetail.Rows[iRow].Cells["productorid_chr"].Value.ToString() : string.Empty;
                    objDetailArr[intRow].STATUS = 1;
                    intRow++;
                }
            }
            return(objDetailArr);
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 获取库存信息
        /// </summary>
        /// <param name="p_drData">数据</param>
        /// <returns></returns>
        private clsDS_StorageDetail_VO[] m_objStorageDetailArr(DataRow[] p_drData)
        {
            if (p_drData == null || p_drData.Length == 0)
            {
                return(null);
            }

            List <clsDS_StorageDetail_VO> lstDetail = new List <clsDS_StorageDetail_VO>();

            for (int iRow = 0; iRow < p_drData.Length; iRow++)
            {
                clsDS_StorageDetail_VO objDetail = m_objStorageDetail(p_drData[iRow]);
                if (objDetail != null)
                {
                    lstDetail.Add(objDetail);
                }
            }

            return(lstDetail.ToArray());
        }