Пример #1
0
        public DataTable GetDataGridDoc(string ASNNo)
        {
            InventoryFacade facade = null;

            if (facade == null)
            {
                facade = new InventoryFacade(DataProvider);
            }

            object[] objs = facade.QueryInvDoc(FormatHelper.PKCapitalFormat(FormatHelper.CleanString(ASNNo)));
            //设置DataTable的tableName 否则序列化会报错
            DataTable dt = new DataTable("ExampleDataTable");

            if (objs != null)
            {
                dt.Columns.Add("选择", typeof(string));

                dt.Columns.Add("文件名", typeof(string));
                dt.Columns.Add("文件大小", typeof(string));
                dt.Columns.Add("上传者", typeof(string));
                dt.Columns.Add("上传日期", typeof(string));

                for (int i = 0; i < objs.Length; i++)
                {
                    InvDoc doc = objs[i] as InvDoc;
                    dt.Rows.Add("", doc.DocName, doc.DocSize.ToString(), doc.UpUser, FormatHelper.ToDateString(doc.UpfileDate));
                }
            }
            return(dt);
        }
Пример #2
0
        //导入
        protected void cmdEnter_ServerClick(object sender, EventArgs e)
        {
            if (_InventoryFacade == null)
            {
                _InventoryFacade = new InventoryFacade(base.DataProvider);
            }
            string asnNo = FormatHelper.CleanString(this.txtStorageInASNEdit.Text);

            if (string.IsNullOrEmpty(asnNo))
            {
                WebInfoPublish.PublishInfo(this, "入库指令号为空", this.languageComponent1);
                return;
            }

            if (this.FileImport.PostedFile != null)
            {
                try
                {
                    HttpPostedFile postedFile = this.FileImport.PostedFile;

                    DBDateTime dbDateTime = FormatHelper.GetNowDBDateTime(base.DataProvider);
                    InvDoc     invDoc     = _InventoryFacade.CreateNewInvDoc();

                    invDoc.InvDocNo     = asnNo;
                    invDoc.InvDocType   = "DirectSign";
                    invDoc.DocType      = Path.GetExtension(postedFile.FileName);
                    invDoc.DocName      = Path.GetFileNameWithoutExtension(postedFile.FileName);
                    invDoc.DocSize      = postedFile.ContentLength / 1024;
                    invDoc.UpUser       = this.GetUserCode();
                    invDoc.UpfileDate   = dbDateTime.DBDate;
                    invDoc.MaintainUser = this.GetUserCode();
                    invDoc.MaintainDate = dbDateTime.DBDate;
                    invDoc.MaintainTime = dbDateTime.DBTime;
                    invDoc.Dirname      = "InvDoc";
                    string path     = Server.MapPath(this.VirtualHostRoot + "InvDoc/" + "直发入库客户接受凭证/");
                    string fileName = string.Format("{0}_DirectSign_{1}{2}{3}",
                                                    this.txtStorageInASNEdit.Text, dbDateTime.DBDate, dbDateTime.DBTime, invDoc.DocType);

                    invDoc.ServerFileName = fileName;

                    if (!Directory.Exists(path))
                    {
                        Directory.CreateDirectory(path);
                    }
                    invDoc.Dirname = "直发入库客户接受凭证";
                    this.FileImport.PostedFile.SaveAs(path + fileName);
                    _InventoryFacade.AddInvDoc(invDoc);
                    WebInfoPublish.PublishInfo(this, "$Success_UpLoadFile", this.languageComponent1);
                }
                catch (Exception ex)
                {
                    WebInfoPublish.PublishInfo(this, ex.Message, this.languageComponent1);
                }
            }
            else
            {
                WebInfoPublish.PublishInfo(this, "导入文件不能为空", this.languageComponent1);
            }
        }
Пример #3
0
        public bool UploadFile(byte[] bytes, string asn, string type, string userName)
        {
            if (bytes.Length > 0)
            {
                MemoryStream ms   = new MemoryStream(bytes);
                string       root = HttpContext.Current.Server.MapPath("~/");

                string path  = root + @"InvDoc\初检签收\";
                string stamp = DateTime.Now.ToString("yyyyMMddmmhhss");


                string fileName = "ASN" + asn + "_" + type + "_" + stamp;
                string fullPath = path + fileName;
                try
                {
                    Image img = Image.FromStream(ms);
                    img.Save(fullPath + ".jpg");
                }
                catch (ArgumentException ex)
                {
                    return(false);
                }

                InvDoc doc = new InvDoc();
                doc.Dirname        = "初检签收";
                doc.InvDocNo       = asn;
                doc.InvDocType     = type;
                doc.DocName        = fileName;
                doc.DocType        = "jpg";
                doc.DocSize        = (bytes.Length / 1024);
                doc.UpUser         = userName;
                doc.UpfileDate     = FormatHelper.TODateInt(DateTime.Now);
                doc.ServerFileName = fileName + ".jpg";
                doc.MaintainUser   = userName;
                doc.MaintainTime   = FormatHelper.TOTimeInt(DateTime.Now);
                doc.MaintainDate   = FormatHelper.TODateInt(DateTime.Now);
                InventoryFacade _inventoryFacade = new InventoryFacade();
                _inventoryFacade.AddInvDoc(doc);


                return(true);
            }
            return(false);
        }
Пример #4
0
        protected override void Grid_ClickCell(GridRecord row, string commandName)
        {
            try
            {
                if (commandName == "Docname")
                {
                    if (_documentFacade == null)
                    {
                        _documentFacade = new DocumentFacade(this.DataProvider);
                    }
                    if (inventoryFacade == null)
                    {
                        inventoryFacade = new BenQGuru.eMES.Material.InventoryFacade(base.DataProvider);
                    }

                    //bool right = _documentFacade.GetDocDirRight(int.Parse(row.Items.FindItemByKey("Dirserial").Value.ToString()), this.GetUserCode(), "QUERY");
                    InvDoc doc = inventoryFacade.GetInvDoc(int.Parse(row.Items.FindItemByKey("Docserial").Value.ToString())) as InvDoc;

                    if (doc != null)
                    {
                        //if (doc.Checkedstatus == "Y" && doc.Validstatus == "Y")
                        //{

                        if (_facade == null)
                        {
                            _facade = new SystemSettingFacade(this.DataProvider);
                        }
                        //object parameter = _facade.GetParameter("DOCDIRPATH", "DOCDIRPATHGROUP");
                        //if (parameter != null)
                        //{
                        //服务器目录路径
                        //string filePath = ((Domain.BaseSetting.Parameter)parameter).ParameterAlias;
                        string filePath = System.AppDomain.CurrentDomain.BaseDirectory + "InvDoc/" + doc.Dirname;
                        //+ "FileUpload";
                        if (filePath.LastIndexOf('\\') == filePath.Length - 1)
                        {
                            filePath = filePath.Substring(0, filePath.Length - 1);
                        }

                        #region//下载文件
                        FileInfo currentFile = new FileInfo(filePath + "/" + row.Items.FindItemByKey("ServerFullName").Value.ToString());
                        if (currentFile.Exists)
                        {
                            this.DownloadFileFull(this.VirtualHostRoot + "InvDoc/" + doc.Dirname + "/" +
                                                  row.Items.FindItemByKey("ServerFullName").Value);
                        }
                        else
                        {
                            Log.Error(filePath + "/" + row.Items.FindItemByKey("ServerFullName").Value.ToString() + "  不存在!");
                            WebInfoPublish.PublishInfo(this, row.Items.FindItemByKey("ServerFullName").Value.ToString() + "不存在", this.languageComponent1);
                        }
                        #endregion
                        //}
                        //else
                        //{
                        //    WebInfoPublish.PublishInfo(this, "$Error_DocDirPath_NotExist", this.languageComponent1);
                        //}

                        //    }
                        //    else
                        //    {
                        //        WebInfoPublish.PublishInfo(this, "$Error_FileIsNotCheckedOrValid", this.languageComponent1);
                        //    }
                    }
                    else
                    {
                        WebInfoPublish.PublishInfo(this, "$Error_HaveNoRightToDownload", this.languageComponent1);
                    }
                }
            }
            catch (Exception ex)
            {
                Log.Error(ex.StackTrace);
                WebInfoPublish.PublishInfo(this, "$Error_QueryFile_Exception", this.languageComponent1);
            }
        }