public void Print(LdtCustomerInfo cust, DateTime? from, DateTime? to) { if (cust == null) return; if(!doc.PrinterSettings.IsValid) throw new ApplicationException("��Ч�Ĵ�ӡ����" + doc.PrinterSettings.PrinterName); if (cust.LdtBills == null || cust.LdtBills.Count == 0) return; this.from = from; this.to = to; printList = new List<LdtCustomerInfo>(); printList.Add(cust); doc.Print(); }
public IList<LdtCustomerInfo> GetLdtCustomer(bool nameNotNull,bool addressNotNull) { string sql = "select DH, CUST, ADDR, CODE_ID from [MAILDDBILL_�����嵥�����û�] "; sql += "where iif(isnull(DH),'',DH)<>'' "; if (nameNotNull) sql += "and iif(isnull(CUST),'',CUST)<>'' "; if (addressNotNull) sql += "and iif(isnull(ADDR),'',ADDR)<>'' "; DataTable table = Select(sql); IList<LdtCustomerInfo> list = new List<LdtCustomerInfo>(); foreach (DataRow row in table.Rows) { LdtCustomerInfo cust = new LdtCustomerInfo(); cust.PhoneNo = row["DH"].ToString().Trim(); cust.Name = row["CUST"].ToString().Trim(); cust.Address = row["ADDR"].ToString().Trim(); cust.Postcode = row["CODE_ID"].ToString().Trim(); list.Add(cust); } dicBillCache = null; return list; }