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);
}
}
