示例#1
0
 protected void btnDel_Click(object sender, EventArgs e)
 {
     LabMS.BLL.InstrumentAndConsumables bconsum = new LabMS.BLL.InstrumentAndConsumables();
     try
     {
         bconsum.Delete(long.Parse(lbCID.Text));
         LabMS.Common.JShelper.JSAlertAndRedirect(Page, "AddSuccess", "删除成功!", "consumlist.aspx");
     }
     catch (Exception ex)
     {
         lbErr.Visible = true;
         lbErr.Text = ex.Message.ToString();
     }
 }
示例#2
0
        public void bind(string strCode, string strLocation, string strCondition)
        {
            LabMS.BLL.InstrumentAndConsumables bconsum = new LabMS.BLL.InstrumentAndConsumables();
            if (strCondition.Trim().Equals(""))
            {
                strCondition = "";
            }
            else
            {
                strCondition = " and " + strCondition;
            }
            string strWhere = " Type = '" + strCode + "'and SpaceLocation= '" + strLocation + "' and Quantity>0 " + strCondition + " order by ID desc ";
            if (strLocation.Equals("@ALL@"))
            {
                strWhere = " Type = '" + strCode + "'and  Quantity>0 " + strCondition + " order by ID desc ";
            }

            List<LabMS.Model.InstrumentAndConsumables> listmconsum = bconsum.GetModelList(strWhere);
            GridViewDic.DataSource = listmconsum;
            GridViewDic.DataBind();
        }
示例#3
0
        protected void lbSave_Click(object sender, EventArgs e)
        {
            Model.InstrumentAndConsumables instrument = new LabMS.Model.InstrumentAndConsumables();
            BLL.InstrumentAndConsumables binstrument = new LabMS.BLL.InstrumentAndConsumables();
            instrument.Arrow = ddlArrow.SelectedValue;
            instrument.ClassNumber = ddlCClass.SelectedValue;
            instrument.ClassNumber = tbKindNum.Text.Trim();
            instrument.CountryCode = tbCountry.Text;
            instrument.CreatedDate = DateTime.Today;
            instrument.Documents = tbDocuments.Text.Trim();
            instrument.FactoryCode = tbFactoryCode.Text.Trim();
            instrument.FundsSubject = ddlFundsSubject.SelectedValue;
            instrument.Measurement = ddlModle.SelectedValue;
            instrument.Model = tbModel.Text.Trim();
            instrument.Name = tbInstrumentName.Text.Trim();
            instrument.Numbers = tbInstrumentNum.Text.Trim();
            instrument.OperatorDate = DateTime.Now;
            instrument.Standards = tbStandards.Text;
            instrument.ResponesoblePerson = tbResponesoblePerson.Text.Trim();
            instrument.ContactPhone = tbContactPhone.Text.Trim();
            DateTime tempTime = new DateTime();
            if (DateTime.TryParse(tbProductionDate.Text.Trim(), out tempTime))
            {
                instrument.ProductionDate = tempTime;
            }
            if (DateTime.TryParse(tbPurchaseDate.Text.Trim(), out tempTime))
            {
                instrument.PurchaseDate = tempTime;
            }
            decimal iTemp = 0;
            if (decimal.TryParse(tbAmount.Text.Trim(), out iTemp))
            {
                instrument.Quantity = iTemp;
            }
            instrument.PresentSituation = ddlPresentSituation.SelectedValue;
            instrument.Source = ddlSource.SelectedValue;
            instrument.SpaceLocation = tbLocationCode.Text;
            instrument.StockLocation = tbLocationCode.Text;
            instrument.Type = "lowvalue";
            instrument.Purpose = tbPurpose.Text;
            instrument.UnitPrice = tbUnitPrice.Text.Trim();
            instrument.Status = "正常";
            //上传图片
            try
            {
                if (imageUpload.HasFile)
                {
                    HttpPostedFile upPhoto = imageUpload.PostedFile;
                    int upPhotoLength = upPhoto.ContentLength;
                    string PhotoContentType = upPhoto.ContentType;
                    byte[] PhotoArray = new byte[upPhotoLength];
                    Stream PhotoStream = upPhoto.InputStream;
                    PhotoStream.Read(PhotoArray, 0, upPhotoLength);

                    instrument.Pic = PhotoArray;//相片
                    instrument.PicType = PhotoContentType;//图片类型
                }
            }
            catch
            {
                LabMS.Common.JShelper.JSAlert(Page, "Picwrong", "程序错误:图片保存出错");
            }
            //无供应商
            try
            {
                binstrument.Add(instrument);
                LabMS.Common.JShelper.JSAlertAndRedirect(Page, "AddSuccess", "添加成功!", "addlowvalue.aspx");
            }
            catch (Exception ex)
            {
                lbErr.Visible = true;
                lbErr.Text = ex.Message.ToString();
            }
        }
示例#4
0
        protected void lbSave_Click(object sender, EventArgs e)
        {
            #region 验证
            if (string.IsNullOrEmpty(tbCNub.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(Page, "err", "耗材编号不能为空!");
                return;
            }
            ExtendBLL.InstrumentAndConsumables extendconsum
                = new ExtendBLL.InstrumentAndConsumables();
            bool bLegal =  extendconsum.isNumbersLegal(tbCNub.Text.Trim(), "xiaohaopin");
            if (!bLegal)
            {
                LabMS.Common.JShelper.JSAlert(Page, "err", "耗材编号已存在!");
                return;
            }
            if (string.IsNullOrEmpty(tbCName.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(Page, "err", "耗材名称不能为空!");
                return;
            }
            if (string.IsNullOrEmpty(tbTypeNub.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(Page, "err", "型号不能为空!");
                return;
            }
            if (string.IsNullOrEmpty(tbNub.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(Page, "err", "数量不能为空!");
                return;
            }
            if (string.IsNullOrEmpty(tbPrice.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(Page, "err", "单价不能为空!");
                return;
            }
            if (string.IsNullOrEmpty(tbBuyDate.Text.Trim()))
            {
                LabMS.Common.JShelper.JSAlert(Page, "err", "购置日期不能为空!");
                return;
            }

            #endregion

            lbErr.Visible = false;
            Model.InstrumentAndConsumables consumables = new LabMS.Model.InstrumentAndConsumables();
            BLL.InstrumentAndConsumables bconsumables = new LabMS.BLL.InstrumentAndConsumables();
            consumables.Arrow = ddlArrow.SelectedValue;
            consumables.ClassNumber = ddlCClass.SelectedValue;
            consumables.Name = tbClassNub.Text.Trim();
            consumables.CountryCode = tbCountry.Text;
            consumables.CreatedDate = DateTime.Today;
            consumables.Documents = tbDocuments.Text.Trim();
            consumables.FactoryCode = tbFNub.Text.Trim();
            consumables.FundsSubject = ddlFundsSubject.SelectedValue;
            consumables.Measurement = ddlModle.SelectedValue;
            consumables.Model = tbTypeNub.Text.Trim();
            consumables.Name = tbCName.Text.Trim();
            consumables.Numbers = tbCNub.Text.Trim();
            consumables.OperatorDate = DateTime.Now;
            DateTime tempTime = new DateTime();
            if (DateTime.TryParse(tbProduceDate.Text.Trim(), out tempTime))
            {
                consumables.ProductionDate = tempTime;
            }
            if (DateTime.TryParse(tbBuyDate.Text.Trim(), out tempTime))
            {
                consumables.PurchaseDate = tempTime;
            }
            decimal iTemp = 0;
            if (decimal.TryParse(tbNub.Text.Trim(), out iTemp))
            {
                consumables.Quantity = iTemp;
            }
            consumables.Source = ddlComeFrom.SelectedValue;
            consumables.SpaceLocation = tbLocationCode.Text;
            consumables.StockLocation = tbLocationCode.Text; ;
            consumables.Type = "xiaohaopin";
            consumables.UnitPrice = tbPrice.Text.Trim();
            consumables.Purpose = tbPurpose.Text;
            //上传图片
            try
            {
                if (imageUpload.HasFile)
                {
                    HttpPostedFile upPhoto = imageUpload.PostedFile;
                    int upPhotoLength = upPhoto.ContentLength;
                    string PhotoContentType = upPhoto.ContentType;
                    byte[] PhotoArray = new byte[upPhotoLength];
                    Stream PhotoStream = upPhoto.InputStream;
                    PhotoStream.Read(PhotoArray, 0, upPhotoLength);

                    consumables.Pic = PhotoArray;//相片
                    consumables.PicType = PhotoContentType;//图片类型
                }
            }
            catch
            {
                LabMS.Common.JShelper.JSAlert(Page, "Picwrong", "程序错误:图片保存出错");
            }
            //无供应商
            try
            {
                bconsumables.Add(consumables);
                LabMS.Common.JShelper.JSAlertAndRedirect(Page, "AddSuccess", "添加成功!", "addconsum.aspx");
            }
            catch (Exception ex)
            {
                lbErr.Visible = true;
                lbErr.Text = ex.Message.ToString();
            }
        }
 public bool isNumbersLegal(string strNumbers, string strType)
 {
     LabMS.BLL.InstrumentAndConsumables bconsum = new LabMS.BLL.InstrumentAndConsumables();
     List<LabMS.Model.InstrumentAndConsumables> listmconsum
         = new List<LabMS.Model.InstrumentAndConsumables>();
     listmconsum = bconsum.GetModelList("Numbers='" + strNumbers + "' and Type='" + strType + "'");
     if (listmconsum.Count > 0)
     {
         return false;
     }
     return true;
 }
示例#6
0
        protected void lbModify_Click(object sender, EventArgs e)
        {
            Model.InstrumentAndConsumables valuables = new LabMS.Model.InstrumentAndConsumables();
            BLL.InstrumentAndConsumables bvaluables = new LabMS.BLL.InstrumentAndConsumables();

            valuables = bvaluables.GetModel(long.Parse(LabID.Value));

            valuables.Numbers = tbInstrumentNum.Text.Trim();
            valuables.ClassNumber = tbKindNum.Text.Trim();
            valuables.Name = tbInstrumentName.Text.Trim();
            valuables.Standards = tbStandards.Text.Trim();
            valuables.Model = tbModel.Text.Trim();
            valuables.CountryCode = tbCountryCode.Text.Trim();
            valuables.StockLocation = tbLocationCode.Text;
            valuables.SpaceLocation = tbLocationCode.Text;
            valuables.Quantity = Convert.ToInt32(tbAmount.Text);
            valuables.UnitPrice = tbUnitPrice.Text.Trim();
            valuables.FactoryCode = tbFactoryCode.Text.Trim();
            valuables.Documents = tbDocuments.Text.Trim();
            valuables.Measurement = tbMeasurement.Text.Trim();
            valuables.Source = ddlSource.SelectedValue;

            DateTime tempTime = new DateTime();
            if (DateTime.TryParse(tbProductionDate.Text.Trim(), out tempTime))
            {
                valuables.ProductionDate = tempTime;
            }
            if (DateTime.TryParse(tbPurchaseDate.Text.Trim(), out tempTime))
            {
                valuables.PurchaseDate = tempTime;
            }
            if (DateTime.TryParse(tbOpeningTime.Text.Trim(), out tempTime))
            {
                valuables.OpeningTime = tempTime;
            }

            valuables.CreatedDate = Convert.ToDateTime(tbCreatedDate.Text);
            valuables.Arrow = ddlArrow.SelectedValue;
            valuables.PresentSituation = ddlPresentSituation.SelectedValue;
            valuables.FundsSubject = ddlFundsSubject.SelectedValue;
            valuables.ResponesoblePerson = tbResponesoblePerson.Text.Trim();
            valuables.ContactPhone = tbContactPhone.Text.Trim();
            valuables.Charges = tbCharges.Text.Trim();
            valuables.ZipCode = tbZipCode.Text.Trim();
            valuables.MailingAddress = tbMailingAddress.Text.Trim();
            valuables.Purpose = tbPurpose.Text.Trim();
            valuables.OperatorDate = DateTime.Now;
            valuables.Type = "guizhongyiqi";
            //修改图片
            try
            {
                if (imageUpload.HasFile)
                {
                    HttpPostedFile upPhoto = imageUpload.PostedFile;
                    int upPhotoLength = upPhoto.ContentLength;
                    string PhotoContentType = upPhoto.ContentType;
                    byte[] PhotoArray = new byte[upPhotoLength];
                    Stream PhotoStream = upPhoto.InputStream;
                    PhotoStream.Read(PhotoArray, 0, upPhotoLength);

                    valuables.Pic = PhotoArray;//相片
                    valuables.PicType = PhotoContentType;//图片类型
                }
            }
            catch
            {
                LabMS.Common.JShelper.JSAlert(Page, "Picwrong", "程序错误:图片保存出错");
            }
            try
            {
                bvaluables.Update(valuables);
                LabMS.Common.JShelper.JSAlertAndRedirect(Page, "ModifySuccess", "修改成功!", "valuablesedit.aspx?ID=" + LabID.Value);
            }
            catch (Exception ex)
            {
                Err.Text = ex.Message.ToString();
            }
        }