/// <summary>
/// 打印操作
/// </summary>
/// <param name="operation"></param>
public void PrintDialog(string operation)
{
//当修改原数据是要进行保存后才能去打印
if (biSave.Enabled == true)
{
MessageBox.Show("在原数据上进行修改时请先保存后再进行打印！！！");
}
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = _cTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.PrintingSystem.StartPrint += PrintingSystem_StartPrint;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cBarCode", "R*" + _FitemId + "*L*" + txtcLotNo.Text + "*S*" + lblTitleMain.lblcSerialNumber.Text + ";" + dtpcDefine2.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", txtcInvCode.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", utecInvName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", txtcInvStd.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendor", txtcVendor.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cLotNo", txtcLotNo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", uneiQuantity.Value);
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cDefine1", txtcDefine1.Text);
if (dtpdDate.Checked)
{
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendorDate", dtpdDate.Value);
}
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
/// <summary>
/// 打印操作
/// </summary>
/// <param name="operation"></param>
public void PrintDialog(string operation)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = Application.StartupPath + @"\Stencil\ProOemOrder.repx";
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
xtreport.DataSource = uGridChecks.DataSource;
//模板赋值
for (var i = 0; i < uGridCheck.DisplayLayout.Bands[0].Columns.Count; i++)
{
var cKey = uGridCheck.DisplayLayout.Bands[0].Columns[i].Key;
string cValue;
if (uGridCheck.Rows.Count > _iRowNo)
{
cValue = uGridCheck.Rows[_iRowNo].Cells[i].Value.ToString();
}
else
{
cValue = "";
}
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, cKey, cValue);
}
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
private void simpleButton2_Click(object sender, EventArgs e)
{
XtraReport raporFaturaDetay = new XtraReport();
raporFaturaDetay.DataSource = db.FaturaDetay.Where(f => f.FaturaID == fatura_Id).ToList();
raporFaturaDetay.ShowDesigner();
}
public void PrintDialog(string operation)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = _cTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cBarCode", "P*" + _FitemId + "*L*" + txtFBatchNo.Text + "*S*");
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", txtcInvCode.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", utecInvName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", txtcInvStd.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", uneiQuantity.Value);
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cOrderNumber", txtcOrderNumber.Text);
xtreport.DataSource = GetPrintData();
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
void FisYazdir1(bool Disigner, string pkSatislar, string SatisFisTipi, string YaziciAdi)
{
try
{
string fisid = pkSatislar;
System.Data.DataSet ds = new DataSet("Test");
DataTable FisDetay = DB.GetData(@"exec sp_SatisDetay " + fisid + ",1");
FisDetay.TableName = "FisDetay";
ds.Tables.Add(FisDetay);
DataTable Fis = DB.GetData(@"exec sp_Satislar " + fisid);
if (Fis.Rows.Count == 0)
{
MessageBox.Show("Satış Bulunamadı");
return;
}
string fkFirma = Fis.Rows[0]["fkFirma"].ToString();
Fis.TableName = "Fis";
ds.Tables.Add(Fis);
//şirket bilgileri
DataTable Sirket = DB.GetData(@"select top 1 * from Sirketler");
Sirket.TableName = "Sirket";
ds.Tables.Add(Sirket);
//Bakiye bilgileri
DataTable Bakiye = DB.GetData(@"select dbo.fon_MusteriBakiyesi(fkFirma) as Bakiye,ToplamTutar as FisTutar,dbo.fon_MusteriBakiyesi(fkFirma)-ToplamTutar as OncekiBakiye from Satislar
where pkSatislar=" + pkSatislar);
Bakiye.TableName = "Bakiye";
ds.Tables.Add(Bakiye);
//Firma bilgileri
DataTable Musteri = DB.GetData("select * from Firmalar where pkFirma=" + fkFirma);
Musteri.TableName = "Musteri";
ds.Tables.Add(Musteri);
string exedizini = Path.GetDirectoryName(Application.ExecutablePath);
string RaporDosyasi = exedizini + "\\Raporlar\\" + SatisFisTipi + ".repx";
if (!File.Exists(RaporDosyasi))
{
MessageBox.Show("Dosya Bulunamadı");
return;
}
XtraReport rapor = new XtraReport();
rapor.DataSource = ds;
rapor.LoadLayout(RaporDosyasi);
if (Disigner)
{
rapor.ShowDesigner();
}
else
{
rapor.Print(YaziciAdi);//.ShowPreview();
}
}
catch (Exception exp)
{
MessageBox.Show("Hata Oluştu " + exp.Message);
}
}
void FisYazdir(bool Disigner, string pkSatislar, string SatisFisTipi, string YaziciAdi)
{
ArrayList list = new ArrayList();
list.Add(new SqlParameter("@ilkTarih", ilktarih.DateTime.AddMinutes(-1)));
list.Add(new SqlParameter("@sonTarih", ilktarih.DateTime));
try
{
string fisid = pkSatislar;
System.Data.DataSet ds = new DataSet("Test");
DataTable FisDetay = DB.GetData(@"SELECT Personeller.pkpersoneller,Firmalar.pkFirma,StokKarti.Stokadi,
Firmalar.Firmaadi, Firmalar.Tel, Firmalar.Adres, (Firmalar.Alacak-Firmalar.Borc) as Bakiye, Firmalar.OzelKod,
Personeller.adi,Personeller.soyadi,SatisDetay.Adet,SatisDetay.SatisFiyati,(SatisDetay.Adet*SatisDetay.SatisFiyati-SatisDetay.iskontotutar) as Tutar,
Satislar.OdemeSekli
FROM Satislar
INNER JOIN SatisDetay ON Satislar.pkSatislar = SatisDetay.fkSatislar
INNER JOIN StokKarti ON SatisDetay.fkStokKarti = StokKarti.pkStokKarti
INNER JOIN Firmalar ON Satislar.fkFirma = Firmalar.pkFirma
INNER JOIN Personeller ON Personeller.pkpersoneller=Satislar.fkPerTeslimEden
WHERE Satislar.Siparis = 0 and Satislar.fkSatisDurumu=10
and Satislar.TeslimTarihi between @ilkTarih and @sonTarih
and Satislar.fkPerTeslimEden=@fkPerTeslimEden
order by Personeller.pkpersoneller,Firmalar.pkFirma", list);
FisDetay.TableName = "FisDetay";
ds.Tables.Add(FisDetay);
//MÜŞTERİNİN SORUMLU OLDUĞU PERSONEL
DataTable Fis = DB.GetData(@"SELECT TOP 1 * FROM PERSONELLER");
Fis.TableName = "Fis";
ds.Tables.Add(Fis);
string exedizini = Path.GetDirectoryName(Application.ExecutablePath);
string RaporDosyasi = exedizini + "\\Raporlar\\" + SatisFisTipi + ".repx";
if (!File.Exists(RaporDosyasi))
{
MessageBox.Show("Dosya Bulunamadı");
return;
}
//string RaporDosyasi = exedizini + "\\Raporlar\\MusteriSatis.repx";
XtraReport rapor = new XtraReport();
rapor.DataSource = ds;
rapor.LoadLayout(RaporDosyasi);
if (Disigner)
{
rapor.ShowDesigner();
}
else
{
rapor.ShowPreview();//.Print(YaziciAdi);//.ShowPreview();
}
}
catch (Exception exp)
{
MessageBox.Show("Hata Oluştu " + exp.Message);
}
}
/// <summary>
/// 打印操作
/// </summary>
/// <param name="p"></param>
private void PrintDialog(string p)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = Application.StartupPath + @"\Stencil\TrackDeliveryOrder.repx";
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.Name = "TrackDeliveryOrder";
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.RequestParameters = false;
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cCode", txtcCode.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cOrderType", cbxcOrderType.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cCusName", utxtcCusName.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "OrderDate", dtpOrderDate.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "DeliveryDate", dtpDeliveryDate.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cDepName", utecDepName.Text);
//模板赋值
switch (p)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
private void btnOpenDesign_Click(object sender, EventArgs e)
{
if (txtPath.Text.Trim() == "")
{
MessageBox.Show("请选择报表文件!");
return;
}
XtraReport report = new XtraReport();
report.LoadLayout(txtPath.Text);
report.CreateDocument();
report.ShowDesigner();
}
/// <summary>
/// 打印操作
/// </summary>
/// <param name="operation"></param>
/// <param name="cTemplet"></param>
/// <param name="dSource"></param>
public void PrintDialog(string operation, string cTemplet, DataTable dSource)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = string.Format("{0}\\Stencil\\{1}.repx", Application.StartupPath, cTemplet);
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
xtreport.DataSource = dSource;
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
void YazdirTaksitlerExtra(bool dizayn)
{
XtraReport rapor = new XtraReport();
//rapor.FindControl("label15", true).Text = DB.PersonellerBaslik;
try
{
System.Data.DataSet ds = new DataSet("Test");
string sql = @"select *,dbo.fnc_ParayiYaziyaCevir(Odenecek,2) as rakamoku,Odenecek-Odenen as Kalan
from Taksit T with(nolock)
left join Taksitler TL with(nolock) on T.taksit_id=TL.taksit_id
where Kaydet=0";
//if(checkEdit1.Checked)
sql = sql + " and Odenecek<>Odenen";
sql = sql + " and T.fkFirma=" + pkFirma_id;
DataTable dtTaksitler = DB.GetData(sql);
dtTaksitler.TableName = "Taksitler";
ds.Tables.Add(dtTaksitler);
//
DataTable Cari = DB.GetData("select *,dbo.fon_MusteriBakiyesi(pkFirma) as Bakiye from Firmalar with(nolock) where pkFirma=" + pkFirma_id);
Cari.TableName = "Cari";
ds.Tables.Add(Cari);
//şirket
DataTable Sirket = DB.GetData("select top 1 * from Sirketler with(nolock)");
Sirket.TableName = "Sirket";
ds.Tables.Add(Sirket);
rapor.DataSource = ds;
rapor.LoadLayout(DB.exeDizini + "\\Raporlar\\TaksitlerExtra.repx");
rapor.Name = "TaksitlerExtra";
rapor.Report.Name = "TaksitlerExtra";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (dizayn)
{
rapor.ShowDesigner();
}
else
{
rapor.ShowPreview();
}
}
void FisYazdir(bool Disigner)
{
string sql = @"exec sp_TedarikcilereGenelBakis";
try
{
System.Data.DataSet ds = new DataSet("Test");
DataTable dtliste = DB.GetData(sql);
//DataTable dtliste = (DataTable)gridControl1.DataSource;
dtliste.TableName = "dtliste";
ds.Tables.Add(dtliste);
//şirket bilgileri
DataTable Sirket = DB.GetData(@"select * from Sirketler with(nolock)");
Sirket.TableName = "Sirket";
ds.Tables.Add(Sirket);
string exedizini = Path.GetDirectoryName(Application.ExecutablePath);
string RaporDosyasi = exedizini + "\\Raporlar\\TedarikciBorcListesi.repx";
if (!File.Exists(RaporDosyasi))
{
MessageBox.Show("Dosya Bulunamadı");
return;
}
XtraReport rapor = new XtraReport();
rapor.LoadLayout(RaporDosyasi);
rapor.Name = "TedarikciBorcListesi";
rapor.Report.Name = "TedarikciBorcListesi";
rapor.DataSource = ds;
if (Disigner)
{
rapor.ShowDesigner();
}
else
{
rapor.ShowPreview();
}
ds.Dispose();
}
catch (Exception exp)
{
MessageBox.Show("Hata Oluştu " + exp.Message);
}
}
private void SavePDFReport(XtraReport xtraReport, string docName)
{
// To show the report designer. You need to uncomment this to design the report.
bool designMode = false;
if (designMode)
{
xtraReport.ShowDesigner();
//report1.ShowPreview();
}
else
{
//Save the report in a pdf format
xtraReport.ExportToPdf(docName);
//EPS report in Excel format
if (comboBoxChooseReport.Text == "EPS Report")
{
docName = docName.Replace("pdf", "xlsx");
xtraReport.ExportToXlsx(docName);
}
}
}
void FisYazdir(bool Disigner, string pkSatislar, string SatisFisTipi, string YaziciAdi)
{
try
{
string fisid = pkSatislar;
System.Data.DataSet ds = new DataSet("Test");
DataTable FisDetay = DB.GetData(@"exec sp_AlisDetay " + fisid + ",1");
FisDetay.TableName = "FisDetay";
ds.Tables.Add(FisDetay);
DataTable Fis = DB.GetData(@"exec sp_Alislar " + fisid);
Fis.TableName = "Fis";
ds.Tables.Add(Fis);
string exedizini = Path.GetDirectoryName(Application.ExecutablePath);
string RaporDosyasi = exedizini + "\\Raporlar\\" + SatisFisTipi + ".repx";
if (!File.Exists(RaporDosyasi))
{
MessageBox.Show("Dosya Bulunamadı");
return;
}
//string RaporDosyasi = exedizini + "\\Raporlar\\MusteriSatis.repx";
XtraReport rapor = new XtraReport();
rapor.DataSource = ds;
rapor.LoadLayout(RaporDosyasi);
if (Disigner)
{
rapor.ShowDesigner();
}
else
{
rapor.Print(YaziciAdi);//.ShowPreview();
}
}
catch (Exception exp)
{
MessageBox.Show("Hata Oluştu " + exp.Message);
}
}
void Yazdir(bool dizayn)
{
XtraReport rapor = new XtraReport();
//rapor.FindControl("label15", true).Text = DB.PersonellerBaslik;
try
{
System.Data.DataSet ds = new DataSet("Test");
int i = gridView1.FocusedRowHandle;
DataRow dr = gridView1.GetDataRow(i);
string _fkFirma = dr["pkTedarikciler"].ToString();
DataTable Cari = DB.GetData("select *,dbo.fon_TedarikciBakiyesi(pkTedarikciler) as Bakiye from Tedarikciler with(nolock) where pkTedarikciler=" + _fkFirma);
Cari.TableName = "Cari";
ds.Tables.Add(Cari);
//şirket
DataTable Sirket = DB.GetData("select top 1 * from Sirketler with(nolock)");
Sirket.TableName = "Sirket";
ds.Tables.Add(Sirket);
rapor.DataSource = ds;
rapor.LoadLayout(DB.exeDizini + "\\Raporlar\\TedarikciBakiyesi.repx");
rapor.Name = "TedarikciBakiyesi";
rapor.Report.Name = "TedarikciBakiyesi";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
if (dizayn)
{
rapor.ShowDesigner();
}
else
{
rapor.Print();
}
}
void YazdirTaksitler_(bool dizayn)
{
XtraReport rapor = new XtraReport();
try
{
string fkFirma = teMusteri.Tag.ToString();
System.Data.DataSet ds = new DataSet("Test");
DataTable dtTaksitler = DB.GetData("select *,dbo.fnc_ParayiYaziyaCevir(Odenecek,2) as rakamoku from Taksitler with(nolock) where Odenecek<>Odenen and isnull(Kaydet,0)=0 and fkFirma=" + fkFirma);
//DataTable FisDetay = DB.GetData(sql);
dtTaksitler.TableName = "Taksitler";
ds.Tables.Add(dtTaksitler);
//
DataTable Cari = DB.GetData("select *,dbo.fon_MusteriBakiyesi(pkFirma) as Bakiye from Firmalar with(nolock) where pkFirma=" + fkFirma);
Cari.TableName = "Cari";
ds.Tables.Add(Cari);
//şirket
DataTable Sirket = DB.GetData("select top 1 * from Sirketler with(nolock)");
Sirket.TableName = "Sirket";
ds.Tables.Add(Sirket);
rapor.DataSource = ds;
rapor.LoadLayout(DB.exeDizini + "\\Raporlar\\Taksitler.repx");
rapor.Name = "Taksitler";
rapor.Report.Name = "Taksitler";
}
catch (Exception ex)
{
}
if (dizayn)
{
rapor.ShowDesigner();
}
else
{
rapor.ShowPreview();
}
}
public void PrintDialogRm(string operation, Infragistics.Win.UltraWinGrid.UltraGridRow uRow, DataTable dt)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
//var _RmcTempletFileName = Application.StartupPath + @"\Label\班次制令单.repx";
var temPath = _RmcTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
var cFitemID = uRow.Cells["cFitemID"].Value.ToString();
var cLotNo = uRow.Cells["FBatchNo"].Value.ToString();
var cDefine2 = dt.Rows[0]["cDefine2"].ToString();
var cSerialNumber = dt.Rows[0]["cSerialNumber"].ToString();
var cInvCode = dt.Rows[0]["cInvCode"].ToString();
var cInvName = dt.Rows[0]["cInvName"].ToString();
var dDate = dt.Rows[0]["dDate"].ToString();
var cInvStd = dt.Rows[0]["cInvStd"].ToString();
var cFullName = dt.Rows[0]["cFullName"].ToString();
var iQuantity = uRow.Cells["iQuantity"].Value.ToString();
var cMemo = dt.Rows[0]["cMemo"].ToString();
var cDefine1 = dt.Rows[0]["cDefine1"].ToString();
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cBarCode", "R*" + cFitemID + "*L*" + cLotNo + "*S*" + cSerialNumber + ";" + cDefine2);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", cInvCode);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", cInvName);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dDate);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", cInvStd);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendor", cFullName);
DllWorkPrintLabel.SetParametersValue(xtreport, "cLotNo", cLotNo);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", iQuantity);
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", cMemo);
DllWorkPrintLabel.SetParametersValue(xtreport, "cDefine1", cDefine1);
if (dtpdDate.Checked)
{
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendorDate", dtpdDate.Value);
}
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
public void PrintDialog(string operation)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var _cTempletFileName = Application.StartupPath + @"\Label\班次制令单.repx";
var temPath = _cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", txtcInvCode.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", utecInvName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", txtcInvStd.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cOrderNuber", txtcOrderNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "FBatchNo", txtFBatchNo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", uneiQuantity.Value);
DllWorkPrintLabel.SetParametersValue(xtreport, "cDepartment", txtcDept.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "批次", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "库位", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "库存", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "发货数", txtcMemo.Text);
//xtreport.DataSource = dataInventory.BomDetail;
DataSet ds = new DataSet();
using (var con = new SqlConnection(BaseStructure.WmsCon))
{
using (var cmd = new SqlCommand {
CommandType = CommandType.StoredProcedure, Connection = con
})
{
cmd.CommandText = "proc_Bomdetail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BomID", bomID);
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd))
{
dataAdapter.Fill(ds);
}
cmd.Parameters.Clear();
}
}
int count = 0;
if (!int.TryParse(uneiQuantity.Value.ToString(), out count))
{
count = 0;
}
DataTable dt = null;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0].Clone();
dt.Columns.Add("发货数", typeof(int));
//DataTable dt = ds.Tables[0];
var dtE = ds.Tables[0].AsEnumerable();
foreach (DataRow dr in GetBomDetail())
{
var iquantity = Convert.ToDecimal(dr["iQuantity"]) * count;
var drs = dtE.Where(w => w.Field <string>("cInvCode") == dr["cInvCode"].ToString()).OrderBy(o => o.Field <string>("批次")).ToList();
//DataRow[] drs = dtE.Select(" cInvCode = '"+dr["cInvCode"].ToString()+"'").OrderBy("");
foreach (DataRow dr1 in drs)
{
if (iquantity >= 0)
{
var kc = Convert.ToDecimal(dr1["库存"]);
var fhs = kc > iquantity ? iquantity : kc;
//假如库存大于发货数，直接当前库位发货，如果小于发货数，当前库位发完当前数，并到下一个库位发剩余数量
iquantity = kc >= iquantity ? -1 : iquantity - kc;
DataRow drNew = dt.NewRow();
drNew["AutoID"] = dr1["AutoID"];
drNew["BomID"] = dr1["BomID"];
drNew["cInvCode"] = dr1["cInvCode"];
drNew["cInvName"] = dr1["cInvName"];
drNew["iQuantity"] = dr1["iQuantity"];
drNew["cUnitID"] = dr1["cUnitID"];
drNew["cUnitName"] = dr1["cUnitName"];
drNew["cInvStd"] = dr1["cInvStd"];
drNew["cFullName"] = dr1["cFullName"];
drNew["cMemo"] = dr1["cMemo"];
drNew["dAddTime"] = dr1["dAddTime"];
drNew["cFitemID"] = dr1["cFitemID"];
drNew["批次"] = dr1["批次"];
drNew["库位"] = dr1["库位"];
drNew["库存"] = dr1["库存"];
drNew["发货数"] = fhs;
dt.Rows.Add(drNew);
}
}
}
}
xtreport.DataSource = dt;
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
/// <summary>
/// 打印操作
/// </summary>
/// <param name="operation"></param>
public void PrintDialog(string operation)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = Application.StartupPath + @"\Stencil\ProSaleOrder.repx";
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.Name = "ProSaleOrder";
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
var dt = (DataTable)uGridChecks.DataSource;
xtreport.DataSource = dt;
var iSum = dt.Compute("sum(FAMOUNT)", "True");
decimal dSum;
if (decimal.TryParse(iSum.ToString(), out dSum))
{
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cSum", WmsFunction.ExchangeUper(dSum));
}
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "iSum", iSum);
//模板赋值
for (var i = 0; i < uGridCheck.DisplayLayout.Bands[0].Columns.Count; i++)
{
var cKey = uGridCheck.DisplayLayout.Bands[0].Columns[i].Key;
string cValue;
if (uGridCheck.ActiveRow != null)
{
cValue = uGridCheck.ActiveRow.Cells[i].Value.ToString();
}
else
{
cValue = "";
}
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, cKey, cValue);
}
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
/// <summary>
/// 打印操作
/// </summary>
/// <param name="p"></param>
private void PrintDialog(string p)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = Application.StartupPath + @"\Stencil\TrackDeliveryOrder.repx";
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.Name = "TrackDeliveryOrder";
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.RequestParameters = false;
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cCode", txtcCode.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cOrderType", cbxcOrderType.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cCusName", utxtcCusName.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "OrderDate", dtpOrderDate.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "DeliveryDate", dtpDeliveryDate.Text);
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, "cDepName", utecDepName.Text);
//模板赋值
switch (p)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
public void PrintDialog(string operation)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = _cTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cBarCode", "P*" + _FitemId + "*L*" + txtFBatchNo.Text + "*S*" );
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", txtcInvCode.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", utecInvName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", txtcInvStd.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", uneiQuantity.Value);
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cOrderNumber", txtcOrderNumber.Text);
xtreport.DataSource = GetPrintData();
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
public void PrintDialogRm(string operation,Infragistics.Win.UltraWinGrid.UltraGridRow uRow,DataTable dt)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
//var _RmcTempletFileName = Application.StartupPath + @"\Label\班次制令单.repx";
var temPath = _RmcTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
var cFitemID = uRow.Cells["cFitemID"].Value.ToString();
var cLotNo = uRow.Cells["FBatchNo"].Value.ToString();
var cDefine2 = dt.Rows[0]["cDefine2"].ToString();
var cSerialNumber = dt.Rows[0]["cSerialNumber"].ToString();
var cInvCode = dt.Rows[0]["cInvCode"].ToString();
var cInvName = dt.Rows[0]["cInvName"].ToString();
var dDate= dt.Rows[0]["dDate"].ToString();
var cInvStd = dt.Rows[0]["cInvStd"].ToString();
var cFullName = dt.Rows[0]["cFullName"].ToString();
var iQuantity = uRow.Cells["iQuantity"].Value.ToString();
var cMemo = dt.Rows[0]["cMemo"].ToString();
var cDefine1 = dt.Rows[0]["cDefine1"].ToString();
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cBarCode", "R*" + cFitemID + "*L*" + cLotNo + "*S*" + cSerialNumber + ";" + cDefine2);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", cInvCode);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", cInvName);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dDate);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", cInvStd);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendor", cFullName);
DllWorkPrintLabel.SetParametersValue(xtreport, "cLotNo", cLotNo);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", iQuantity);
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", cMemo);
DllWorkPrintLabel.SetParametersValue(xtreport, "cDefine1", cDefine1);
if (dtpdDate.Checked)
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendorDate", dtpdDate.Value);
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
private void btnPrintPreview_Click(object sender, EventArgs e)
{
XtraReport r = new XtraReport();
DataSet ds = new DataSet();
DataTable dtCompany = new DataTable("Company");
dtCompany.Columns.Add("Tên đơn vị");
dtCompany.Columns.Add("Tên giao dịch");
dtCompany.Columns.Add("Mã số thuế");
dtCompany.Columns.Add("Lĩnh vực hoạt động");
dtCompany.Columns.Add("Điện thoại");
dtCompany.Columns.Add("Fax");
dtCompany.Columns.Add("Email");
dtCompany.Columns.Add("Website");
dtCompany.Columns.Add("Địa chỉ đơn vị");
dtCompany.Columns.Add("Giám đốc");
dtCompany.Columns.Add("Kế toán");
dtCompany.Columns.Add("Thủ quỹ");
DataRow row = dtCompany.NewRow();
object tmp;
EasyParam.GetValue("Tên đơn vị", out tmp, ParamCategory.CompanyInfo, "TÊN DOANH NGHIỆP", DataType.String);
row["Tên đơn vị"] = tmp;
EasyParam.GetValue("Tên giao dịch", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Tên giao dịch"] = tmp;
EasyParam.GetValue("Mã số thuế", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Mã số thuế"] = tmp;
EasyParam.GetValue("Lĩnh vực hoạt động", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Lĩnh vực hoạt động"] = tmp;
EasyParam.GetValue("Điện thoại", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Điện thoại"] = tmp;
EasyParam.GetValue("Fax", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Fax"] = tmp;
EasyParam.GetValue("Email", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Email"] = tmp;
EasyParam.GetValue("Website", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Website"] = tmp;
EasyParam.GetValue("Địa chỉ đơn vị", out tmp, ParamCategory.CompanyInfo, "", DataType.String);
row["Địa chỉ đơn vị"] = tmp;
EasyParam.GetValue("Giám đốc", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Giám đốc"] = tmp;
EasyParam.GetValue("Kế toán", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Kế toán"] = tmp;
EasyParam.GetValue("Thủ quỹ", out tmp, ParamCategory.CompanyInfo, string.Empty, DataType.String);
row["Thủ quỹ"] = tmp;
dtCompany.Rows.Add(row);
DataTable dtInvoice = new DataTable("Invoice");
dtInvoice.Columns.Add("InvoiceCode");
dtInvoice.Columns.Add("InvoiceDate", typeof(DateTime));
dtInvoice.Columns.Add("EntityName");
dtInvoice.Columns.Add("EntityAddress");
dtInvoice.Columns.Add("VoucherCode");
dtInvoice.Columns.Add("VoucherDate", typeof(DateTime));
dtInvoice.Columns.Add("InvoiceNote");
dtInvoice.Columns.Add("Total", typeof(decimal));
dtInvoice.Columns.Add("Bằng chữ");
DataRow rowInvoice = dtInvoice.NewRow();
rowInvoice["InvoiceCode"] = _invoice.InvoiceCode;
rowInvoice["InvoiceDate"] = _invoice.InvoiceDate;
rowInvoice["InvoiceNote"] = _invoice.InvoiceNote;
rowInvoice["EntityName"] = _invoice.EntityName;
rowInvoice["EntityAddress"] = _invoice.EntityAddress;
rowInvoice["VoucherCode"] = _invoice.VoucherCode;
rowInvoice["VoucherDate"] = _invoice.VoucherDate;
rowInvoice["Total"] = _invoice.Total;
rowInvoice["Bằng chữ"] = lbTotalString.Text+"\r\nABCD";
dtInvoice.Rows.Add(rowInvoice);
ds.Tables.Add(dtCompany);
ds.Tables.Add(dtInvoice);
if (_invoiceType.InvoiceTypeName == Constant.INVOICE_TYPE_THU)
r.LoadLayout(Application.StartupPath + @"\Reports\phieuthu.repx");
else if (_invoiceType.InvoiceTypeName == Constant.INVOICE_TYPE_CHI)
r.LoadLayout(Application.StartupPath + @"\Reports\phieuchi.repx");
r.DataSource = ds;
//r.ShowPreview();
r.ShowDesigner();
}
public void PrintDialog(string operation)
{
if (string.IsNullOrEmpty(biEditTemplet.Caption))
{
MessageBox.Show(@"请先在 维护中心-模板管理，添加仓位标签项，再打开此界面!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var dt = new DataKis.StockPlacePrintDataTable();
foreach (var uRow in uGridCheck.Rows.GetFilteredInNonGroupByRows())
{
var nRow = dt.NewStockPlacePrintRow();
nRow.FSPID = int.Parse(uRow.Cells["FSPID"].Value.ToString());
nRow.FNumber = uRow.Cells["FNumber"].Value.ToString();
nRow.FName = uRow.Cells["FName"].Value.ToString();
nRow.FFullName = uRow.Cells["FFullName"].Value.ToString();
dt.Rows.Add(nRow);
}
if (dt.Rows.Count < 1)
{
MessageBox.Show(@"请先筛选要打印的数据!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = _cTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
xtreport.DataSource = dt;
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
public void PrintDialog(string operation)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var _cTempletFileName = Application.StartupPath + @"\Label\班次制令单.repx";
var temPath = _cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", txtcInvCode.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", utecInvName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", txtcInvStd.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cOrderNuber", txtcOrderNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "FBatchNo", txtFBatchNo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", uneiQuantity.Value);
DllWorkPrintLabel.SetParametersValue(xtreport, "cDepartment", txtcDept.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "批次", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "库位", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "库存", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "发货数", txtcMemo.Text);
//xtreport.DataSource = dataInventory.BomDetail;
DataSet ds = new DataSet();
using (var con = new SqlConnection(BaseStructure.WmsCon))
{
using (var cmd = new SqlCommand { CommandType = CommandType.StoredProcedure, Connection = con })
{
cmd.CommandText = "proc_Bomdetail";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BomID", bomID);
using (SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd))
{
dataAdapter.Fill(ds);
}
cmd.Parameters.Clear();
}
}
int count = 0;
if(!int.TryParse(uneiQuantity.Value.ToString(), out count))
{
count = 0;
}
DataTable dt = null;
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
dt = ds.Tables[0].Clone();
dt.Columns.Add("发货数", typeof(int));
//DataTable dt = ds.Tables[0];
var dtE = ds.Tables[0].AsEnumerable();
foreach (DataRow dr in GetBomDetail())
{
var iquantity = Convert.ToDecimal(dr["iQuantity"]) * count;
var drs = dtE.Where(w => w.Field<string>("cInvCode") == dr["cInvCode"].ToString()).OrderBy(o => o.Field<string>("批次")).ToList();
//DataRow[] drs = dtE.Select(" cInvCode = '"+dr["cInvCode"].ToString()+"'").OrderBy("");
foreach (DataRow dr1 in drs)
{
if (iquantity >= 0)
{
var kc = Convert.ToDecimal(dr1["库存"]);
var fhs = kc > iquantity ? iquantity : kc;
//假如库存大于发货数，直接当前库位发货，如果小于发货数，当前库位发完当前数，并到下一个库位发剩余数量
iquantity = kc >= iquantity ? -1 : iquantity - kc;
DataRow drNew = dt.NewRow();
drNew["AutoID"] = dr1["AutoID"];
drNew["BomID"] = dr1["BomID"];
drNew["cInvCode"] = dr1["cInvCode"];
drNew["cInvName"] = dr1["cInvName"];
drNew["iQuantity"] = dr1["iQuantity"];
drNew["cUnitID"] = dr1["cUnitID"];
drNew["cUnitName"] = dr1["cUnitName"];
drNew["cInvStd"] = dr1["cInvStd"];
drNew["cFullName"] = dr1["cFullName"];
drNew["cMemo"] = dr1["cMemo"];
drNew["dAddTime"] = dr1["dAddTime"];
drNew["cFitemID"] = dr1["cFitemID"];
drNew["批次"] = dr1["批次"];
drNew["库位"] = dr1["库位"];
drNew["库存"] = dr1["库存"];
drNew["发货数"] = fhs;
dt.Rows.Add(drNew);
}
}
}
}
xtreport.DataSource = dt;
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
public void PrintDialog(string operation)
{
if (string.IsNullOrEmpty(biEditTemplet.Caption))
{
MessageBox.Show(@"请先在 维护中心-模板管理，添加仓位标签项，再打开此界面!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var dt = new DataKis.StockPlacePrintDataTable();
foreach (var uRow in uGridCheck.Rows.GetFilteredInNonGroupByRows())
{
var nRow = dt.NewStockPlacePrintRow();
nRow.FSPID = int.Parse(uRow.Cells["FSPID"].Value.ToString());
nRow.FNumber = uRow.Cells["FNumber"].Value.ToString();
nRow.FName = uRow.Cells["FName"].Value.ToString();
nRow.FFullName = uRow.Cells["FFullName"].Value.ToString();
dt.Rows.Add(nRow);
}
if (dt.Rows.Count < 1)
{
MessageBox.Show(@"请先筛选要打印的数据!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = _cTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
xtreport.DataSource = dt;
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
/// <summary>
/// 打印操作
/// </summary>
/// <param name="operation"></param>
public void PrintDialog(string operation)
{
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = Application.StartupPath + @"\Stencil\DeliveryOrder.repx";
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.Name = "DeliveryOrder";
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
xtreport.DataSource = uGridChecks.DataSource;
//模板赋值
string cKey, cValue;
for (var i = 0; i < uGridCheck.DisplayLayout.Bands[0].Columns.Count; i++)
{
cKey = uGridCheck.DisplayLayout.Bands[0].Columns[i].Key;
cValue = uGridCheck.Rows[_iRowNo].Cells[i].Value.ToString();
DLL.DllWorkPrintLabel.SetParametersValue(xtreport, cKey, cValue);
}
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
/// <summary>
/// 打印操作
/// </summary>
/// <param name="operation"></param>
public void PrintDialog(string operation)
{
//当修改原数据是要进行保存后才能去打印
if (biSave.Enabled == true)
{
MessageBox.Show("在原数据上进行修改时请先保存后再进行打印！！！");
}
var xtreport = new XtraReport();
// _btApp = new BarTender.Application();
//判断当前打印模版路径是否存在
var temPath = _cTempletFileName; //_cTempletFileName; //Application.StartupPath + @"\Label\" + _cTempletFileName;
if (!File.Exists(temPath))
{
MessageBox.Show(@"当前路径下的打印模版文件不存在!", @"异常", MessageBoxButtons.OK, MessageBoxIcon.Warning);
xtreport.ShowDesigner();
return;
}
xtreport.LoadLayout(temPath);
xtreport.PrinterName = _cPrinter;
xtreport.PrintingSystem.StartPrint += PrintingSystem_StartPrint;
xtreport.RequestParameters = false;
xtreport.ShowPrintStatusDialog = false;
xtreport.ShowPrintMarginsWarning = false;
//模板赋值
DllWorkPrintLabel.SetParametersValue(xtreport, "cSerialNumber", lblTitleMain.lblcSerialNumber.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cBarCode", "R*" + _FitemId + "*L*" + txtcLotNo.Text + "*S*" + lblTitleMain.lblcSerialNumber.Text+";"+dtpcDefine2.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvCode", txtcInvCode.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvName", utecInvName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "dDate", dtpdDate.Value.ToShortDateString());
DllWorkPrintLabel.SetParametersValue(xtreport, "cInvStd", txtcInvStd.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cFullName", txtcFullName.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendor", txtcVendor.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cLotNo", txtcLotNo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "iQuantity", uneiQuantity.Value);
DllWorkPrintLabel.SetParametersValue(xtreport, "cMemo", txtcMemo.Text);
DllWorkPrintLabel.SetParametersValue(xtreport, "cDefine1", txtcDefine1.Text);
if (dtpdDate.Checked)
DllWorkPrintLabel.SetParametersValue(xtreport, "cVendorDate", dtpdDate.Value);
//模板赋值
switch (operation)
{
case "print":
xtreport.Print();
break;
case "design":
xtreport.ShowDesigner();
break;
case "preview":
xtreport.ShowPreview();
break;
}
}
