Ejemplo n.º 1
0
        public void Delete(int QuotationFileID)
        {
            QuotationFile _file = _context.QuotationFiles.Find(QuotationFileID);

            _file.Enabled = false;
            _context.SaveChanges();
        }
 public QuotationFileViewModel(QuotationFile File, string Supplier)
 {
     QuotationFileID = File.QuotationFileID;
     SupplierName    = Supplier;
     UploadDate      = File.CreateDate.ToString("yyyy-MM-dd");
     FileLink        = "/Purchase/GetQuotationFile?QuotationFileID=" + File.QuotationFileID;
 }
Ejemplo n.º 3
0
        /// <summary>
        /// 客先担当選択.Model
        /// </summary>
        /// <param name="dataFile">ファイル情報</param>
        public SelectedStaff(DataFileInfo dataFile)
        {
            switch (dataFile.Kind)
            {
            case DataKind.Quotation:

                var file = new QuotationFile(dataFile);

                MakeClientStaffs(file.ClientName, file.ClientStaffs);
                _File = file;

                break;
            }
        }
Ejemplo n.º 4
0
        protected void btnDownloadTemplate_Click(object sender, EventArgs e)
        {
            try
            {
                QuotationFile quotationFile = new QuotationFile();
                quotationFile.CustomerCode = txtCustomerCode.Text;
                quotationFile.ForecastDate = DateTime.ParseExact(txtPeriod.Text.Insert(3, "01/"), formats, CultureInfo.InvariantCulture, DateTimeStyles.None);
                quotationFile.SysCreator   = HttpContext.Current.User.Identity.Name;
                quotationFile.Export();

                this.ltlMessage.Text         = string.Empty;
                ReportViewer1.ProcessingMode = ProcessingMode.Remote;
                IReportServerCredentials irsc = new ReportServerNetworkCredentials();
                ReportViewer1.ServerReport.ReportServerCredentials = irsc;
                ReportViewer1.ServerReport.ReportServerUrl         = new Uri((string)ViewState["ReportServerUrl"]);
                ReportViewer1.ServerReport.ReportPath = "/Forecast/ForecastTemplate";

                ReportParameter[] myParam =
                {
                    new ReportParameter("CustomerCode", quotationFile.CustomerCode)
                    ,                                   new ReportParameter("ForecastDate",string.Format("{0:MM/dd/yyyy}", quotationFile.ForecastDate))
                    ,                                   new ReportParameter("SysCreator", quotationFile.SysCreator)
                };

                ReportViewer1.ServerReport.SetParameters(myParam);
                ReportViewer1.ServerReport.Refresh();

                string    mimeType;
                string    encoding;
                string    extension;
                string[]  streams;
                Warning[] warnings;
                byte[]    bytes = ReportViewer1.ServerReport.Render("Excel", string.Empty, out mimeType, out encoding, out extension, out streams, out warnings);

                Response.Clear();
                Response.ContentType = "application/excel";
                Response.AddHeader("Content-disposition", string.Format("filename={0:yyyyMM}_{1}_Forecast.xls", quotationFile.ForecastDate, quotationFile.CustomerCode));
                Response.AddHeader("Content-Length", bytes.Length.ToString());
                Response.OutputStream.Write(bytes, 0, bytes.Length);
                Response.OutputStream.Flush();
                Response.OutputStream.Close();
                Response.Flush();
                Response.Close();
            }
            catch (Exception ex)
            {
                ltlMessage.Text = ex.Message.ToString().ToErrorMessageFormat();
            }
        }
Ejemplo n.º 5
0
        /// <summary>
        /// 終了処理
        /// </summary>
        public override void Dispose()
        {
            base.Dispose();

            if (PrintSummaries != null)
            {
                foreach (var summary in PrintSummaries)
                {
                    summary.Dispose();
                }

                PrintSummaries.Clear();
                PrintSummaries = null;
            }

            File.Dispose();
            File = null;
        }
Ejemplo n.º 6
0
 public int Save(QuotationFile File)
 {
     if (File.QuotationFileID == 0)
     {
         _context.QuotationFiles.Add(File);
     }
     else
     {
         QuotationFile _dbEntry = _context.QuotationFiles.Find(File.QuotationFileID);
         if (_dbEntry != null)
         {
             _dbEntry.QuotationRequestID = File.QuotationRequestID;
             _dbEntry.SupplierID         = File.SupplierID;
             _dbEntry.CreateDate         = DateTime.Now;
             _dbEntry.Enabled            = File.Enabled;
             _dbEntry.FileName           = File.FileName;
         }
     }
     _context.SaveChanges();
     return(File.QuotationFileID);
 }
Ejemplo n.º 7
0
        /// <summary>
        /// 見積書改訂
        /// </summary>
        public void RevisionQuotation()
        {
            if (Quotations.Count.Equals(0))
            {
                Quotations.Add(new DataFileInfo(DataKind.Quotation, 0, DateTime.Now, 1, false));
            }
            else
            {
                Quotations.Add(new DataFileInfo(DataKind.Quotation, Quotations[Quotations.Count - 1].Revision + 1, DateTime.Now, 1, false));
            }

            SelectedQuotation = Quotations[Quotations.Count - 1];

            var file = new QuotationFile(SelectedQuotation)
            {
                JobName    = Name,
                QuoteNo    = new DocumentNoFile().UpdateDocumentNo(DataKind.Quotation),
                ClientName = SelectedClient?.Name
            };

            file.Save();
        }
Ejemplo n.º 8
0
 /// <summary>
 /// 見積書.Model
 /// </summary>
 /// <param name="dataFile">見積情報</param>
 public Quotation(DataFileInfo dataFile)
 {
     DataFile = dataFile;
     File     = new QuotationFile(DataFile);
 }
Ejemplo n.º 9
0
        private void ValidateAndUploadFile()
        {
            try
            {
                ViewState["xls"] = FileUpload1.FileBytes;
                IExcelDataReader excelReader = ExcelReaderFactory.CreateOpenXmlReader(FileUpload1.PostedFile.InputStream);
                excelReader.IsFirstRowAsColumnNames = true;
                DataSet xls = excelReader.AsDataSet();

                ViewState["Valid"] = true;

                DataTable CustomerFile = CreateTable();

                List <string> colNames = new List <string>(columns.Values);
                List <string> colKeys  = new List <string>(columns.Keys);

                Int32 ID = 1;
                CustomerFile = xls.Tables[sheet].AsEnumerable().Select(r =>
                {
                    var row       = CustomerFile.NewRow();
                    row.ItemArray = new object[] {
                        ID++,
                        r[colNames[0]],
                        r[colNames[1]],
                        r[colNames[2]],
                        r[colNames[3]],
                        r[colNames[4]],
                        r[colNames[5]],
                        r[colNames[6]],
                        r[colNames[7]],
                        r[colNames[8]],
                        r[colNames[9]]
                    };
                    return(row);
                }).CopyToDataTable();

                CustomerFile.AsEnumerable().Where(r => r[columns.FirstOrDefault(x => x.Value == "Customer Code").Key] == DBNull.Value
                                                  | r[columns.FirstOrDefault(x => x.Value == "Ichikoh Part No").Key] == DBNull.Value).ToList().ForEach(r => r.Delete());
                CustomerFile.AcceptChanges();

                CustomerFile = CustomerFile.AsEnumerable().Where(
                    r => r[colKeys[0]].ToString() != string.Empty |
                    r[colKeys[1]].ToString() != string.Empty |
                    r[colKeys[2]].ToString() != string.Empty |
                    r[colKeys[3]].ToString() != string.Empty |
                    r[colKeys[4]].ToString() != string.Empty |
                    r[colKeys[5]].ToString() != string.Empty |
                    r[colKeys[6]].ToString() != string.Empty |
                    r[colKeys[7]].ToString() != string.Empty |
                    r[colKeys[8]].ToString() != string.Empty |
                    r[colKeys[9]].ToString() != string.Empty
                    ).CopyToDataTable();
                CustomerFile.TableName = "xml";

                MemoryStream s = new MemoryStream();
                CustomerFile.WriteXml(s, true);
                s.Seek(0, SeekOrigin.Begin);
                StreamReader sr  = new StreamReader(s);
                string       xml = sr.ReadToEnd();
                sr.Close();

                DataTable order = QuotationFile.Validate(xml);

                colNames.Add("ID");
                colNames.Add("Customer CodeX");
                colNames.Add("Ichikoh Part NoX");

                gvSheet.DataKeyNames = colNames.ToArray();

                gvSheet.DataSource = order;
                gvSheet.DataBind();

                gvSheet.Visible = !(bool)ViewState["Valid"];

                if ((bool)ViewState["Valid"])
                {
                    QuotationFile qf = new QuotationFile();

                    qf.Name        = Path.GetFileName(FileUpload1.PostedFile.FileName);
                    qf.ContentType = FileUpload1.PostedFile.ContentType;
                    qf.Data        = (byte[])ViewState["xls"];

                    order.TableName = "xml";
                    s = new MemoryStream();
                    order.WriteXml(s, true);
                    s.Seek(0, SeekOrigin.Begin);
                    sr     = new StreamReader(s);
                    qf.Xml = sr.ReadToEnd();
                    sr.Close();

                    qf.SysCreator = HttpContext.Current.User.Identity.Name;
                    Int32 refID = qf.Import();

                    ltlMessage.Text = "<img src='../App_Themes/Default/images/listing/ico-accept.png' /> Successfuly uploaded file.".ToSuccessMessageFormat();
                }
            }
            catch (Exception ex)
            {
                if (ex.Message.ToString().Contains("does not belong to table"))
                {
                    ltlMessage.Text = "File is invalid. Please choose the customer forecast template or Excel file containing customer forecast orders.".ToErrorMessageFormat();
                }
                else
                {
                    ltlMessage.Text = string.Format("The file you are uploading is invalid. {0}.", ex.Message.ToString()).ToErrorMessageFormat();
                }
            }
        }