1. DataSet ds = new DataSet();
if (File.Exists("DefaultPrint.xml"))
{ //存在文件
ds.ReadXml("DefaultPrint.xml");
}
else
{
//不存在文件
//File.Create("DefaultPrint.xml");//创建该文件
System.IO.FileStream stream = File.Create("DefaultPrint.xml ");
stream.Close();
ds.WriteXml("DefaultPrint.xml");//不加 会报错 xml格式不对
ds.ReadXml("DefaultPrint.xml");
}
2
DataSet ds = new DataSet();
//System.IO.Stream stream =System.Reflection.Assembly.GetExecutingAssembly().GetManifestResourceStream("DefaultPrint.xml");
ds.ReadXml("DefaultPrint.xml");
ds.Tables[0].Rows.Clear();
int i;
for ( i =0;(listBox2.Items.Count) - 1 >=i; i++)
{
DataRow dr =ds.Tables["DefaultPrint"].NewRow();
dr["prid"] = i + 1;
dr["tempplate"] =listBox2.Items[i].ToString();
dr["template_type"]= "普通快递";
dr["print_name"] ="";
dr["loglistcompany"]= "";
ds.Tables[0].Rows.Add(dr);
}
for (int j =0; (listBox3.Items.Count)- 1 >= j;j++)
{
DataRow dr =ds.Tables["DefaultPrint"].NewRow();
dr["prid"] = i +j+1;
dr["tempplate"] =listBox3.Items[j].ToString();
dr["template_type"]= "到付快递";
dr["print_name"] ="";
dr["loglistcompany"]= "";
ds.Tables[0].Rows.Add(dr);
}
ds.WriteXml("DefaultPrint.xml");
2.
foreach(DataRow r in ds.Tables[0].Rows)
{
if (r[2].ToString() == "普通快递")
listBox1.Items.Add(r[1].ToString());
else if (r[2].ToString() =="到付快递")
listBox2.Items.Add(r[1].ToString());
}
3.
DataSet ds= new DataSet();
ds.ReadXml("DefaultPrint.xml");
bindingSource1.DataSource =ds.Tables[0];
bindingSource1.EndEdit();//会把更新提交到内存中的对象或对象列表(如DataSet)
4
DataSet ds = new DataSet();
IList<TB_ORDER> tboder =serviceLocator.GetService<IORDERBLL>().RetrieveAll();
ds =ConvertToDataSet<TB_ORDER>(tboder); /// Ilist<T> 转换成 DataSet
/// </summary>
/// <paramname="list"></param>
/// <returns></returns>
publicstatic DataSetConvertToDataSet<T>(IList<T>i_objlist)
{
if(i_objlist == null || i_objlist.Count <= 0)
{
return null;
}
DataSetds = new DataSet();
DataTabledt = new DataTable(typeof(T).Name);
DataColumncolumn;
DataRowrow;
System.Reflection.PropertyInfo[] myPropertyInfo = typeof(T).GetProperties(System.Reflection.BindingFlags.Public | System.Reflection.BindingFlags.Instance);
foreach(T t in i_objlist)
{
if (t == null)
{
continue;
}
row = dt.NewRow();
for (int i = 0, j =myPropertyInfo.Length; i < j; i++)
{
System.Reflection.PropertyInfo pi =myPropertyInfo[i];
string name = pi.Name;
if (dt.Columns[name] == null)
{
column = new DataColumn(name,pi.PropertyType);
dt.Columns.Add(column);
}
row[name] =pi.GetValue(t, null);
}
dt.Rows.Add(row);
}
ds.Tables.Add(dt);
returnds;
}
5
//打印按钮
[DllImport("winspool.drv")]
publicstatic extern bool SetDefaultPrinter(stringName);
privatevoid btn_Print_Click(objectsender, EventArgs e)
{
DataSetds = new DataSet();
IList<TB_REPORT_TEMPLATE> list1 =serviceLocator.GetService<IREPORT_TEMPLATE>().RetrieveAll();
IList<TB_ORDER> tboder =serviceLocator.GetService<IORDERBLL>().RetrieveAll();
ds =ConvertToDataSet<TB_ORDER>(tboder);
DataSetds1=new DataSet();
ds1.ReadXml("DefaultPrint.xml");
if(lbx_CommonDel.Enabled == true)
{
for (int i = 0; i< list1.Count; i++)
{
if (list1[i].TYPE_NAME.ToString() ==lbx_CommonDel.SelectedItem.ToString())
{
foreach (DataRow r inds1.Tables[0].Rows)
{
if (r[1].ToString() ==lbx_CommonDel.SelectedItem.ToString())
{
if (r[3].ToString() !="")
{
string str = list1[i].PATH.ToString();
SetDefaultPrinter(r[3].ToString());
XtraReport xr = newXtraReport();
xr.DataSource = ds;
xr.LoadLayout(str);
xr.Print();
break;
}
else
{
MessageBox.Show("必须先给该模板设置默认打印机");
CommonWorkItem<LockPrintView>workitem = workItem.Items.AddNew<CommonWorkItem<LockPrintView>>();
WindowSmartPartInfosmartPartInfo = new WindowSmartPartInfo();
smartPartInfo.Width = 580;
smartPartInfo.Height = 455;
smartPartInfo.Location = newSystem.Drawing.Point(150, 150);
workitem.Space = workItem.Workspaces["DialogWorkspace"];
workitem.Show(smartPartInfo);
this.Dispose();
break;
}
}
}
}
}
}
else
{
for (int i = 0; i< list1.Count; i++)
{
if (list1[i].TYPE_NAME.ToString() ==lbx_ArrPayDel.SelectedItem.ToString())
{
foreach (DataRow rin ds1.Tables[0].Rows)
{
if (r[1].ToString() ==lbx_ArrPayDel.SelectedItem.ToString())
{
if (r[3].ToString() != "")
{
string str = list1[i].PATH.ToString();
SetDefaultPrinter(r[3].ToString());
XtraReport xr = newXtraReport();
xr.DataSource = ds;
xr.LoadLayout(str);
xr.Print();
break;
}
else
{
MessageBox.Show("必须先给该模板设置默认打印机");
CommonWorkItem<LockPrintView>workitem = workItem.Items.AddNew<CommonWorkItem<LockPrintView>>();
WindowSmartPartInfo smartPartInfo = new WindowSmartPartInfo();
smartPartInfo.Width= 580;
smartPartInfo.Height = 455;
smartPartInfo.Location = newSystem.Drawing.Point(150, 150);
workitem.Space = workItem.Workspaces["DialogWorkspace"];
workitem.Show(smartPartInfo);
this.Dispose();
break;
}
}
}
}
}
}
this.Dispose();
}