コード例 #1
0
ファイル: FMaterialMP.aspx.cs プロジェクト: windygu/.net-wms
        protected override DataRow GetGridRow(object obj)
        {
            DataRow row = this.DtSource.NewRow();

            BenQGuru.eMES.Domain.MOModel.Material merterail = obj as BenQGuru.eMES.Domain.MOModel.Material;
            row["MaterialNo"]   = merterail.MCode;
            row["DQMaterialNo"] = merterail.DqmCode;
            row["ENSDesc"]      = merterail.MenshortDesc;
            row["ENLDesc"]      = merterail.MenlongDesc;
            row["CHSDesc"]      = merterail.MchshortDesc;
            row["CHLDesc"]      = merterail.MchlongDesc;

            row["SpecialDesc"]  = merterail.MspecialDesc;
            row["MaterialItem"] = merterail.ModelCode;
            row["MUOM"]         = merterail.Muom;
            row["MaterialType"] = merterail.MaterialType;

            row["ROHS1"]        = merterail.Rohs;
            row["MStatus"]      = merterail.Mstate;
            row["MControlType"] = merterail.MCONTROLTYPE;
            row["MValidity"]    = merterail.Validity;
            row["Msource"]      = merterail.Sourceflag;

            row["MaintainUser"] = merterail.MaintainUser;
            row["MaintainDate"] = FormatHelper.ToDateString(merterail.MaintainDate);
            row["MaintainTime"] = FormatHelper.ToTimeString(merterail.MaintainTime);

            return(row);
        }
コード例 #2
0
ファイル: FMaterialMP.aspx.cs プロジェクト: windygu/.net-wms
        protected override object GetEditObject()
        {
            if (_facade == null)
            {
                _facade = new MOModel.ItemFacade(base.DataProvider);
            }
            BenQGuru.eMES.Domain.MOModel.Material merterial = this._facade.CreateNewMaterial();
            merterial = _facade.GetMaterial(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtMaterialNO.Text, 40))) as BenQGuru.eMES.Domain.MOModel.Material;

            merterial.MCONTROLTYPE = FormatHelper.CleanString(this.drpMaterialType.SelectedValue, 40);
            merterial.Validity     = Int32.Parse(FormatHelper.CleanString(this.txtMaterialValidity.Text, 100));
            merterial.MaintainUser = this.GetUserCode();

            return(merterial);
        }
コード例 #3
0
ファイル: FMaterialMP.aspx.cs プロジェクト: windygu/.net-wms
 protected override void SetEditObject(object obj)
 {
     if (obj == null)
     {
         this.txtMaterialNO.Text            = "";
         this.txtMaterialENDesc.Text        = "";
         this.txtMaterialCHDesc.Text        = "";
         this.txtDQMaterialNO.Text          = "";
         this.drpMaterialType.SelectedIndex = 0;
         this.txtMaterialValidity.Text      = "";
         return;
     }
     BenQGuru.eMES.Domain.MOModel.Material merterial = obj as BenQGuru.eMES.Domain.MOModel.Material;
     this.txtMaterialNO.Text            = merterial.MCode;
     this.txtMaterialENDesc.Text        = merterial.MenshortDesc;
     this.txtMaterialCHDesc.Text        = merterial.MchshortDesc;
     this.txtDQMaterialNO.Text          = merterial.DqmCode;
     this.drpMaterialType.SelectedIndex = this.drpMaterialType.Items.IndexOf(this.drpMaterialType.Items.FindByValue(merterial.MCONTROLTYPE));;
     this.txtMaterialValidity.Text      = merterial.Validity.ToString();
 }
コード例 #4
0
ファイル: FMaterialMP.aspx.cs プロジェクト: windygu/.net-wms
        private void GetAllItem()
        {
            try
            {
                string fileName = string.Empty;

                #region  new

                #region File
                if (_facade == null)
                {
                    _facade = new MOModel.ItemFacade(base.DataProvider);
                }
                if (inventoryFacade == null)
                {
                    inventoryFacade = new BenQGuru.eMES.Material.InventoryFacade(base.DataProvider);
                }
                string upfileName = "";
                BenQGuru.eMES.Domain.Warehouse.InvDoc doc = new BenQGuru.eMES.Domain.Warehouse.InvDoc();
                if (this.DownLoadPathBom.PostedFile != null)
                {
                    string         stno       = "MaterialImport";// FormatHelper.PKCapitalFormat(FormatHelper.CleanString(this.txtASNSTNOQuery.Text));
                    HttpPostedFile postedFile = this.DownLoadPathBom.PostedFile;
                    string         path       = Server.MapPath(this.VirtualHostRoot + "InvDoc/" + "物料维护/");
                    DBDateTime     dbDateTime = FormatHelper.GetNowDBDateTime(base.DataProvider);
                    //string CARINVNO = row.Items.FindItemByKey("CARINVNO").Text;
                    doc.InvDocNo   = stno;
                    doc.InvDocType = "MaterialImport";//FMaterialMP
                    string[] part = postedFile.FileName.Split(new char[] { '/', '\\' });

                    doc.DocType        = Path.GetExtension(postedFile.FileName);
                    doc.DocName        = Path.GetFileNameWithoutExtension(postedFile.FileName);
                    doc.DocSize        = postedFile.ContentLength / 1024;
                    doc.UpUser         = GetUserCode();
                    doc.UpfileDate     = FormatHelper.TODateInt(DateTime.Now);
                    doc.Dirname        = "物料维护";
                    doc.MaintainUser   = this.GetUserCode();
                    doc.MaintainDate   = dbDateTime.DBDate;
                    doc.MaintainTime   = dbDateTime.DBTime;
                    doc.ServerFileName = doc.DocName + "_" + stno + DateTime.Now.ToString("yyyyMMddhhmmss") + doc.DocType;
                    if (!Directory.Exists(path))
                    {
                        Directory.CreateDirectory(path);
                    }
                    fileName = doc.ServerFileName;

                    upfileName = path + fileName;
                    this.DownLoadPathBom.PostedFile.SaveAs(upfileName);
                }
                else
                {
                    this.DataProvider.RollbackTransaction();
                    WebInfoPublish.PublishInfo(this, "导入文件不能为空", this.languageComponent1);
                    return;
                }

                #endregion

                this.UploadedFileName = upfileName;
                #endregion

                DBDateTime dbTime = FormatHelper.GetNowDBDateTime(this.DataProvider);
                if (this.ViewState["UploadedFileName"] == null)
                {
                    WebInfoPublish.Publish(this, "$Error_UploadFileIsEmpty", this.languageComponent1);
                    //BenQGuru.eMES.Common.ExceptionManager.Raise(this.GetType().BaseType, "$Error_UploadFileIsEmpty");
                }
                fileName = this.ViewState["UploadedFileName"].ToString();
                //读取EXCEL格式文件
                System.Data.DataTable dt = GetExcelData(fileName);

                if ((dt != null) && (dt.Rows.Count > 0))
                {
                    for (int t = 0; t < dt.Rows.Count; t++)
                    {
                        string dqmcode  = dt.Rows[t][0].ToString().Trim(); //物料号
                        string validity = dt.Rows[t][1].ToString().Trim(); //有效期
                        if (validity.Length > 10)
                        {
                            this.DataProvider.RollbackTransaction();
                            WebInfoPublish.Publish(this, "$Error_VALID_DAY_NOT_MORE_THREE", this.languageComponent1);
                            return;
                        }
                        if (!IsInt(validity))
                        {
                            this.DataProvider.RollbackTransaction();
                            WebInfoPublish.Publish(this, "鼎桥物料号" + dqmcode + "有效期必须是数值型", this.languageComponent1);
                            return;
                        }
                        BenQGuru.eMES.Domain.MOModel.Material material =
                            _facade.GetMaterialByDQMCode(dqmcode) as BenQGuru.eMES.Domain.MOModel.Material;
                        if (material != null)
                        {
                            material.Validity     = Convert.ToInt32(FormatHelper.CleanString(validity, 100));
                            material.MaintainDate = dbTime.DBDate;
                            material.MaintainTime = dbTime.DBTime;
                            material.MaintainUser = this.GetUserCode();
                            this._facade.UpdateMaterial(material);
                        }
                        else
                        {
                            this.DataProvider.RollbackTransaction();
                            WebInfoPublish.Publish(this, dqmcode + "EXCEL表中鼎桥物料号不存在", this.languageComponent1);
                            return;
                        }
                    }

                    this.DataProvider.CommitTransaction();
                    WebInfoPublish.Publish(this, "导入成功!", this.languageComponent1);
                }
                else
                {
                    this.DataProvider.RollbackTransaction();
                    WebInfoPublish.Publish(this, "导入内容不能为空", this.languageComponent1);//add by sam
                }
            }
            catch (Exception ex)
            {
                this.DataProvider.RollbackTransaction();
                WebInfoPublish.PublishInfo(this, ex.Message, this.languageComponent1);
            }
        }