public ReturnType RemoveLogisticCompanyTemplate(string logisticcompanytemplateCode) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*List<LogisticCompanyTemplate> list = alading.LogisticCompanyTemplate.Where(p => p.LogisticCompanyTemplateID == logisticcompanytemplateID).ToList();*/ List <LogisticCompanyTemplate> list = alading.LogisticCompanyTemplate.Where(p => p.LogisticCompanyCode == logisticcompanytemplateCode).ToList(); if (list.Count == 0) { return(ReturnType.NotExisted); } else { LogisticCompanyTemplate sy = list.First(); alading.DeleteObject(sy); alading.SaveChanges(); return(ReturnType.Success); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
public ReturnType AddLogisticCompanyTemplate(LogisticCompanyTemplate logisticcompanytemplate) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { alading.AddToLogisticCompanyTemplate(logisticcompanytemplate); if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.PropertyExisted); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }
private void initLogisticCompany()//设置物流公司 { lc.Clear(); pictureBox2.Controls.Clear(); LogisticCompanyTemplate modifyTemplate = LogisticCompanyTemplateService.GetLogisticTemplate(templateCode); List <LogisticCompany> logCompany = LogisticCompanyService.GetAllLogisticCompany(); mtCompany.Properties.DataSource = logCompany; mtCompany.Properties.DisplayMember = "name"; mtCompany.Text = modifyTemplate.LogisticCompanyName; mtCompany.Properties.ValueMember = "code"; mtCompany.EditValue = modifyTemplate.LogisticCompanyCode; templateName = modifyTemplate.LogisticCompanyName; mtName.Text = modifyTemplate.LogisticCompanyName.ToString(); mtCover.SelectedIndexChanged -= new EventHandler(mtCover_SelectedIndexChanged); string coverArea = modifyTemplate.CoverAreaList; string[] x = coverArea.Split(','); foreach (string y in x) { int count = 0; foreach (CheckedListBoxItem c in mtCover.Items) { if (count >= 2) { if (y == c.Value.ToString()) { c.CheckState = CheckState.Checked; break; } } count++; } } mtCover.SelectedIndexChanged += new EventHandler(mtCover_SelectedIndexChanged); MemoryStream ms = new MemoryStream(modifyTemplate.PreviewImage); pictureBox2.Image = Image.FromStream(ms); lcti = LogisticCompanyTemplateItemService.GetLogisticTemplateItems(modifyTemplate.LogisticCompanyCode); //模版标签 foreach (LogisticCompanyTemplateItem l in lcti) { LabelControl lctemp = new LabelControl(); lctemp.Text = l.ItemName; lctemp.Location = new Point(l.ItemX, l.ItemY); lctemp.MouseDown += new MouseEventHandler(control_MouseDown); lctemp.MouseMove += new MouseEventHandler(control_MouseMove); pictureBox2.Controls.Add(lctemp); lc.Add(lctemp); } }
private void LoadPrintPreview(Alading.Entity.Trade trade) { if (trade != null && !string.IsNullOrEmpty(trade.TemplateCode)) { LogisticCompanyTemplate template = LogisticCompanyService.GetLogisticCompanyTemplate(t => t.TemplateCode == trade.TemplateCode).FirstOrDefault(); if (template != null) { byte[] decommpressBytes = CompressHelper.Decompress(template.TemplateData); MemoryStream memStream = new MemoryStream(decommpressBytes); XtraReport xtraReport = new XtraReport(); xtraReport.PrintingSystem = expressPreview.PrintingSystem; xtraReport.LoadLayout(memStream); xtraReport.CreateDocument(true); memStream.Close(); SetValue(xtraReport, "收件人", trade.receiver_name); SetValue(xtraReport, "收件人电话", trade.receiver_phone); SetValue(xtraReport, "收件人手机", trade.receiver_mobile); SetValue(xtraReport, "收件人地址", trade.receiver_address); SetValue(xtraReport, "收件人邮编", trade.receiver_zip); SetValue(xtraReport, "寄件人", trade.seller_name); SetValue(xtraReport, "寄件人手机", trade.seller_mobile); SetValue(xtraReport, "寄件人电话", trade.seller_phone); } } //PrintingSystem printingSystem = new PrintingSystem(); ////非常关键,设置打印页面大小 ////自定义的纸张,注意单位是:百分之一英寸 0.01英寸 //PaperSize customPaperSize = new PaperSize("Custom Paper Size", 500, 550); //Margins customMargins = new Margins(0, 0, 0, 0); //PageSettings customPageSettings = new PageSettings(); //customPageSettings.PaperSize = customPaperSize; //customPageSettings.Margins = customMargins; //printingSystem.PageSettings.Assign(customPageSettings); //this.printCtrlExpress.PrintingSystem = printingSystem; //XtraReport xtraReport = new XtraReport(); //xtraReport.LoadLayout(@"d:\XtraReport.repx"); //xtraReport.PrintingSystem = printingSystem; //xtraReport.CreateDocument(true); ////预览配货单 //PrintingSystem printingProductSystem = new PrintingSystem(); //this.printCtrlProduct.PrintingSystem = printingProductSystem; //PreviewReport productReport = new PreviewReport(); //Parameter parameter = productReport.Parameters["TradeCode"]; //parameter.Value = "20100345789531"; //productReport.PrintingSystem = printingProductSystem; //productReport.CreateDocument(true); //printingProductSystem.ExecCommand(DevExpress.XtraPrinting.PrintingSystemCommand.Parameters, new object[] { true }); }
private void barButtonItemEditTemplate_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //触发自定义事件 if (OnEditTemplate != null) { LogisticCompanyTemplate template = gvLogisticComTemplate.GetFocusedRow() as LogisticCompanyTemplate; if (template != null) { EditTemplateEventArgs edit = new EditTemplateEventArgs(template, string.Empty); OnEditTemplate(this.gvLogisticComTemplate, edit); } } }
private void mtSave_Click(object sender, EventArgs e) //保存按钮 { if ((mtName.Text != "") && (mtCompany.Text != "")) //判断名称与物流公司是否为空 { string comTemplateName = mtName.Text; string logCompanyName = mtCompany.Text.ToString(); string logCompanyCode = mtCompany.EditValue.ToString(); string logCompanyTemplateCode = templateCode; byte[] i = SetImageToByteArray();//将图片转化成矩阵 string coverArea = string.Empty; foreach (CheckedListBoxItem c in mtCover.CheckedItems) { if (c.Value.ToString() != "全选" && c.Value.ToString() != "取消全选") { coverArea += c.Value + ","; } } if (coverArea != "") { LogisticCompanyTemplate lct = new LogisticCompanyTemplate(); lct.CoverAreaList = coverArea; lct.LogisticCompanyCode = logCompanyCode; lct.LogisticCompanyName = logCompanyName; lct.LogisticCompanyCode = templateCode; lct.LogisticCompanyName = comTemplateName; lct.PreviewImage = i; lct.TemplateID = Convert.ToInt32(templateID); if (LogisticCompanyTemplateService.UpdateLogisticCompanyTemplate(lct) == ReturnType.Success) { UpdateTemplateItems(templateCode); DevExpress.XtraEditors.XtraMessageBox.Show("模板修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearAfterUpdate(); //应切换到模版列表 } else { XtraMessageBox.Show("模板名称重复,请重新输入模板!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); mtName.Focus(); } } else { XtraMessageBox.Show("未选择覆盖区域!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { XtraMessageBox.Show("有空白项未填写!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void ntSave_Click(object sender, EventArgs e)//保存新建模板 { if ((ntName.Text != "") && (ntCompany.Text != "") && (picPath != "")) { string comTemplateName = ntName.Text; string logCompanyName = ntCompany.Text.ToString(); string logCompanyCode = ntCompany.EditValue.ToString(); string TemplateCode = System.Guid.NewGuid().ToString(); byte[] i = SetImageToByteArray(picPath); string coverArea = string.Empty; foreach (CheckedListBoxItem c in ntCover.CheckedItems) { if (c.Value.ToString() != "全选" && c.Value.ToString() != "取消全选") { coverArea += c.Value + ","; } } if (coverArea != "") { LogisticCompanyTemplate lct = new LogisticCompanyTemplate(); lct.CoverAreaList = coverArea; lct.LogisticCompanyCode = logCompanyCode; lct.LogisticCompanyName = logCompanyName; lct.LogisticCompanyCode = TemplateCode; lct.LogisticCompanyName = comTemplateName; lct.PreviewImage = i; if (LogisticCompanyTemplateService.AddLogisticCompanyTemplate(lct) == ReturnType.Success) { NewTemplateItems(TemplateCode); DevExpress.XtraEditors.XtraMessageBox.Show("模板创建成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearAfterSave(); } else { XtraMessageBox.Show("模板名称重复,请重新输入模板!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); ntName.Focus(); } } else { XtraMessageBox.Show("未选择覆盖区域!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { XtraMessageBox.Show("有空白项未填写!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public ReturnType UpdateLogisticCompanyTemplate(string logisticcompanytemplateCode, LogisticCompanyTemplate logisticcompanytemplate) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*var result = alading.LogisticCompanyTemplate.Where(p => p.LogisticCompanyTemplateID == logisticcompanytemplateID).ToList();*/ var result = alading.LogisticCompanyTemplate.Where(p => p.LogisticCompanyCode == logisticcompanytemplateCode).ToList(); if (result.Count == 0) { return(ReturnType.NotExisted); } LogisticCompanyTemplate ob = result.First(); ob.TemplateCode = logisticcompanytemplate.TemplateCode; ob.TemplateName = logisticcompanytemplate.TemplateName; ob.LogisticCompanyCode = logisticcompanytemplate.LogisticCompanyCode; ob.LogisticCompanyName = logisticcompanytemplate.LogisticCompanyName; ob.CoverAreaList = logisticcompanytemplate.CoverAreaList; ob.TemplateData = logisticcompanytemplate.TemplateData; ob.PaperWidth = logisticcompanytemplate.PaperWidth; ob.PaperHeight = logisticcompanytemplate.PaperHeight; ob.TemplateLeftOffset = logisticcompanytemplate.TemplateLeftOffset; ob.TemplateRightOffset = logisticcompanytemplate.TemplateRightOffset; ob.TemplateTopOffset = logisticcompanytemplate.TemplateTopOffset; ob.TemplateBottomOffset = logisticcompanytemplate.TemplateBottomOffset; ob.Landscape = logisticcompanytemplate.Landscape; ob.DefaultPrinter = logisticcompanytemplate.DefaultPrinter; if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.OthersError); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (System.Exception ex) { return(ReturnType.OthersError); } }
private void PreviewTemplate() { if (gridView1.FocusedRowHandle >= 0) { string logisticCode = gridView1.GetRowCellValue(gridView1.FocusedRowHandle, "LogisticCompanyTemplateCode").ToString(); LogisticCompanyTemplate lct = LogisticCompanyTemplateService.GetLogisticTemplate(logisticCode); List <LogisticCompanyTemplateItem> logTempItem = LogisticCompanyTemplateItemService.GetLogisticTemplateItems(lct.LogisticCompanyCode); MemoryStream ms = new MemoryStream(lct.PreviewImage); pictureBox1.Image = Image.FromStream(ms); pictureBox1.Controls.Clear(); foreach (LogisticCompanyTemplateItem l in logTempItem) { LabelControl lctemp = new LabelControl(); lctemp.Text = l.ItemName; lctemp.Location = new Point(l.ItemX, l.ItemY); pictureBox1.Controls.Add(lctemp); } } }
private void LoadTemplate(int focusedRowHandle) { if (focusedRowHandle < 0) { return; } LogisticCompanyTemplate template = gvLogisticComTemplate.GetRow(gvLogisticComTemplate.FocusedRowHandle) as LogisticCompanyTemplate; if (template != null && template.TemplateData != null) { //1、首先解压缩 byte[] decommpressBytes = CompressHelper.Decompress(template.TemplateData); MemoryStream memStream = new MemoryStream(decommpressBytes); XtraReport xtraReport = new XtraReport(); xtraReport.PrintingSystem = this.printingSystem; xtraReport.LoadLayout(memStream); xtraReport.CreateDocument(true); memStream.Close(); } }
/// <summary> /// 加载界面时触发事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TemplateDesign_Load(object sender, EventArgs e) { if (template == null) { template = new LogisticCompanyTemplate(); } else { //模版编辑 LogisticCompanyEditor.Properties.Value = template.LogisticCompanyName; editorRowName.Properties.Value = template.TemplateName; editorRowPrinter.Properties.Value = template.DefaultPrinter; if (template.Landscape == true) { editorRowLanscape.Properties.Value = "横向"; } else { editorRowLanscape.Properties.Value = "纵向"; } editorRowWidth.Properties.Value = template.PaperWidth; editorRowHeight.Properties.Value = template.PaperHeight; editorRowTop.Properties.Value = template.TemplateTopOffset; editorRowBottom.Properties.Value = template.TemplateBottomOffset; editorRowLeft.Properties.Value = template.TemplateLeftOffset; editorRowRight.Properties.Value = template.TemplateRightOffset; if (template.TemplateData != null) { //1、首先解压缩 byte[] decommpressBytes = CompressHelper.Decompress(template.TemplateData); MemoryStream memStream = new MemoryStream(decommpressBytes); xrDesignPanel.OpenReport(memStream); memStream.Close(); } //新建模版不可用 commandBarItemNew.Enabled = false; } saveHandler = new SaveCommandHandler(xrDesignPanel, template, isModigy); try { ShowLogisticsCompany(); ShowDeliveryState(); if (companyName != string.Empty && companyName != "所有物流公司") { LogisticCompanyEditor.Properties.Value = companyName; } //true为模板编辑 if (isModigy == true) { List <string> areaList = template.CoverAreaList.Split(new Char[] { ',' }, StringSplitOptions.RemoveEmptyEntries).ToList(); for (int index = 0; index < checkedListBoxStateCtrl.Items.Count; index++) { if (areaList.Contains(checkedListBoxStateCtrl.Items[index].Value.ToString())) { checkedListBoxStateCtrl.Items[index].CheckState = System.Windows.Forms.CheckState.Checked; } } } else { //默认全选 barEditAllSelect.EditValue = true; for (int index = 0; index < checkedListBoxStateCtrl.Items.Count; index++) { checkedListBoxStateCtrl.Items[index].CheckState = System.Windows.Forms.CheckState.Checked; } } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, Constants.SYSTEM_PROMPT, MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public TemplateDesign(LogisticCompanyTemplate template) { InitializeComponent(); this.template = template; isModigy = true; }
public SaveCommandHandler(XRDesignPanel panel, LogisticCompanyTemplate template, bool isModigy) { this.panel = panel; this.template = template; this.isModigy = isModigy; }
public EditTemplateEventArgs(LogisticCompanyTemplate template, string companyName) { this.template = template; this.companyName = companyName; }
public static ReturnType AddLogisticCompanyTemplate(LogisticCompanyTemplate logisticcompanytemplate) { return(DataProviderClass.Instance().AddLogisticCompanyTemplate(logisticcompanytemplate)); }
public static ReturnType UpdateLogisticCompanyTemplate(string logisticcompanytemplateCode, LogisticCompanyTemplate logisticcompanytemplate) { return(DataProviderClass.Instance().UpdateLogisticCompanyTemplate(logisticcompanytemplateCode, logisticcompanytemplate)); }
public ReturnType UpdateLogisticCompanyTemplate(LogisticCompanyTemplate logisticcompanytemplate) { try { using (AladingEntities alading = new AladingEntities(AppSettings.GetConnectionString())) { /*LogisticCompanyTemplate result = alading.LogisticCompanyTemplate.Where(p => p.LogisticCompanyTemplateID == logisticcompanytemplate.LogisticCompanyTemplateID).FirstOrDefault();*/ LogisticCompanyTemplate result = alading.LogisticCompanyTemplate.Where(p => p.LogisticCompanyCode == logisticcompanytemplate.LogisticCompanyCode).FirstOrDefault(); if (result == null) { return(ReturnType.NotExisted); } #region Using Attach() Function Update,Default USE; //alading.Attach(result); //alading.ApplyPropertyChanges("LogisticCompanyTemplate", logisticcompanytemplate); //Article oldArticle = mixEntity.Article.FirstOrDefault(cc => cc.ArticleCode == article.ArticleCode); //mixEntity.Attach(oldArticle); //mixEntity.ApplyPropertyChanges("Article", article); //return (mixEntity.SaveChanges() == 1); #endregion #region Using All Items Replace To Update ,Default UnUse result.TemplateCode = logisticcompanytemplate.TemplateCode; result.TemplateName = logisticcompanytemplate.TemplateName; result.LogisticCompanyCode = logisticcompanytemplate.LogisticCompanyCode; result.LogisticCompanyName = logisticcompanytemplate.LogisticCompanyName; result.CoverAreaList = logisticcompanytemplate.CoverAreaList; result.TemplateData = logisticcompanytemplate.TemplateData; result.PaperWidth = logisticcompanytemplate.PaperWidth; result.PaperHeight = logisticcompanytemplate.PaperHeight; result.TemplateLeftOffset = logisticcompanytemplate.TemplateLeftOffset; result.TemplateRightOffset = logisticcompanytemplate.TemplateRightOffset; result.TemplateTopOffset = logisticcompanytemplate.TemplateTopOffset; result.TemplateBottomOffset = logisticcompanytemplate.TemplateBottomOffset; result.Landscape = logisticcompanytemplate.Landscape; result.DefaultPrinter = logisticcompanytemplate.DefaultPrinter; #endregion if (alading.SaveChanges() == 1) { return(ReturnType.Success); } else { return(ReturnType.OthersError); } } } catch (SqlException sex) { return(ReturnType.ConnFailed); } catch (Exception ex) { return(ReturnType.OthersError); } }