示例#1
0
        //CreateProductComprison
        public string CreateProductComprison(ProductCropModel productmapinstance)
        {
            string        id           = base.GetGlobalId();
            string        buyerid      = productmapinstance.BuyerID;
            string        productid    = string.IsNullOrEmpty(productmapinstance.ProductID) ? "" : productmapinstance.ProductID;
            string        salerid      = productmapinstance.SalerID;
            string        senderid     = productmapinstance.SenderID;
            string        factoryid    = productmapinstance.FactoryID;
            string        code         = productmapinstance.Code;
            string        modecode     = productmapinstance.ModeCode;
            string        modename     = productmapinstance.ModeName;
            string        name         = productmapinstance.Name;
            int           packagerate  = int.Parse(productmapinstance.PackageRate);
            string        producer     = productmapinstance.Producer;
            string        producercode = productmapinstance.ProducerCode;
            string        remark       = productmapinstance.Remark;
            string        speccode     = productmapinstance.SpecCode;
            string        specname     = productmapinstance.SpecName;
            string        specunit     = productmapinstance.SpecUnit;
            string        specunitcode = productmapinstance.SpecUnitCode;
            int           standrate    = int.Parse(productmapinstance.StandRate);
            string        useunit      = productmapinstance.UseUnit;
            string        useunitcode  = productmapinstance.UseUnitCode;
            string        read         = productmapinstance.Read;
            StringBuilder sqlstr       = new StringBuilder();

            sqlstr.AppendFormat("insert into gpo_PRODUCT_MAP (ID,PRODUCT_ID,map_orgtype,MAP_ORGID,FACTORY_ID,SALER_ID,SENDER_ID,SPEC_UNIT,PACKAGE_RATE,MODE_NAME,REMARK,SPEC_UNIT_ID,STAND_RATE,MODE_ID,FACTORY_NAME,FACTORY_CODE,USE_UNIT,USE_UNIT_ID,MEDICAL_SPEC,MEDICAL_SPEC_ID,PRODUCT_NAME,PRODUCT_CODE,PROCESS_FLAG) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}', '{17}','{18}','{19}','{20}','{21}','{22}')", id, productid, '1', buyerid, factoryid, salerid, senderid, specunit, packagerate, modename, remark, specunitcode, standrate, modecode, producer, producercode, useunit, useunitcode, specname, speccode, name, code, read);
            base.DbFacade.SQLExecuteNonQuery(sqlstr.ToString());
            return(id);
        }
        /// <summary>
        /// 加入药品匹配表
        /// </summary>
        /// <param name="productmapinstance"></param>
        /// <returns></returns>
        public void AddProductMap(ProductCropModel productmapinstance)
        {
            bool flag = ProductCodeCompareDAL.GetInstance().JudgeProductCode(productmapinstance.Code, productmapinstance.SalerID);

            if (!flag)
            {
                ProductCodeCompareDAL.GetInstance().CreateProductComprison(productmapinstance);
            }
            else
            {
                ProductCodeCompareDAL.GetInstance().UpdateComparison(productmapinstance);
            }
        }
        private ProductCropModel setProduct(DataGridViewRow dgvr)
        {
            ProductCropModel model = new ProductCropModel();

            model.Code         = getDgvData(dgvr.Cells["PRODUCT_CODE"]);
            model.Name         = dgvr.Cells["PRODUCT_NAME"].Value.ToString();
            model.ModeName     = getDgvData(dgvr.Cells["MEDICAL_MODE"]);
            model.SpecName     = getDgvData(dgvr.Cells["MEDICAL_SPEC"]);
            model.SpecUnit     = getDgvData(dgvr.Cells["SPEC_UNIT"]);
            model.ProducerCode = getDgvData(dgvr.Cells["FACTORY_CODE"]);
            model.Producer     = getDgvData(dgvr.Cells["FACTORY_NAME"]);
            model.BuyerID      = base.CurrentUserOrgId;

            return(model);
        }
示例#4
0
        /// <summary>
        /// 修改产品编码匹配关系
        /// </summary>
        /// <param name="productmapinstance"></param>
        public void UpdateComparison(ProductCropModel productmapinstance)
        {
            string        id          = productmapinstance.ID;
            string        buyerid     = productmapinstance.BuyerID;
            string        productid   = productmapinstance.ProductID;
            string        salerid     = productmapinstance.SalerID;
            string        senderid    = productmapinstance.SenderID;
            string        factoryid   = productmapinstance.FactoryID;
            string        code        = productmapinstance.Code;
            string        modename    = productmapinstance.ModeName;
            string        name        = productmapinstance.Name;
            int           packagerate = int.Parse(productmapinstance.PackageRate);
            string        producer    = productmapinstance.Producer;
            string        remark      = productmapinstance.Remark;
            string        specname    = productmapinstance.SpecName;
            string        specunit    = productmapinstance.SpecUnit;
            int           standrate   = int.Parse(productmapinstance.StandRate);
            string        useunit     = productmapinstance.UseUnit;
            string        read        = productmapinstance.Read;
            StringBuilder sqlstr      = new StringBuilder("update GPO_PRODUCT_MAP");

            sqlstr.AppendFormat(" set PRODUCT_ID='{0}'", productid);
            sqlstr.AppendFormat(",MAP_ORGID='{0}'", buyerid);
            sqlstr.AppendFormat(",FACTORY_ID='{0}'", factoryid);
            sqlstr.AppendFormat(",SALER_ID='{0}'", salerid);
            sqlstr.AppendFormat(",SENDER_ID='{0}'", senderid);
            sqlstr.AppendFormat(",MODE_NAME='{0}'", modename);
            sqlstr.AppendFormat(",PRODUCT_NAME='{0}'", name);
            sqlstr.AppendFormat(",PACKAGE_RATE='{0}'", packagerate);
            sqlstr.AppendFormat(",FACTORY_NAME='{0}'", producer);
            sqlstr.AppendFormat(",REMARK='{0}'", remark);
            sqlstr.AppendFormat(",MEDICAL_SPEC='{0}'", specname);
            sqlstr.AppendFormat(",SPEC_UNIT='{0}'", specunit);
            sqlstr.AppendFormat(",STAND_RATE='{0}'", standrate);
            sqlstr.AppendFormat(",USE_UNIT='{0}'", useunit);
            sqlstr.AppendFormat(",PROCESS_FLAG='{0}'", read);
            sqlstr.AppendFormat(" where PRODUCT_CODE='{0}' and MAP_ORGID='{1}' and id='{2}'", code, buyerid, id);
            base.DbFacade.SQLExecuteNonQuery(sqlstr.ToString());
        }