protected override List <object> GetDataSource()
{
CustomerPaymentSearchCondition cpsc = new CustomerPaymentSearchCondition();
cpsc.PaymentTypes = new List <CustomerPaymentType>();
cpsc.PaymentTypes.Add(CustomerPaymentType.Supplier);
cpsc.States = new List <SheetState>();
cpsc.States.Add(SheetState.Approved);
cpsc.HasRemain = true;
_CustomerPayments = (new CustomerPaymentBLL(AppSettings.Current.ConnStr)).GetItems(cpsc).QueryObjects;
CustomerReceivableSearchCondition crsc = new CustomerReceivableSearchCondition();
crsc.Settled = false;
crsc.ReceivableTypes = new List <CustomerReceivableType>();
crsc.ReceivableTypes.Add(CustomerReceivableType.SupplierReceivable);
crsc.ReceivableTypes.Add(CustomerReceivableType.SupplierOtherReceivable);
_CustomerReceivables = (new CustomerReceivableBLL(AppSettings.Current.ConnStr)).GetItems(crsc).QueryObjects;
CompanyBLL bll = new CompanyBLL(AppSettings.Current.ConnStr);
if (SearchCondition == null)
{
CustomerSearchCondition con = new CustomerSearchCondition();
con.ClassID = CompanyClass.Supplier;
_Customers = bll.GetItems(con).QueryObjects;
}
else
{
_Customers = bll.GetItems(SearchCondition).QueryObjects;
}
List <object> records = FilterData();
return(records);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (dataGridView1.Columns[e.ColumnIndex].Name == "colReceivable")
{
CompanyInfo c = dataGridView1.Rows[e.RowIndex].Tag as CompanyInfo;
View.FrmCustomerReceivableView frm = new View.FrmCustomerReceivableView();
CustomerReceivableSearchCondition con = new CustomerReceivableSearchCondition();
con.CustomerID = c.ID;
con.ReceivableTypes = new List <CustomerReceivableType>();
con.ReceivableTypes.Add(CustomerReceivableType.SupplierOtherReceivable);
con.ReceivableTypes.Add(CustomerReceivableType.SupplierReceivable);
con.Settled = false;
frm.SearchCondition = con;
frm.Text = string.Format("{0} 应付款明细", c.Name);
frm.ShowDialog();
}
if (dataGridView1.Columns[e.ColumnIndex].Name == "colPrepay")
{
CompanyInfo c = dataGridView1.Rows[e.RowIndex].Tag as CompanyInfo;
View.FrmCustomerPaymentView frm = new View.FrmCustomerPaymentView();
CustomerPaymentSearchCondition con = new CustomerPaymentSearchCondition();
con.CustomerID = c.ID;
con.PaymentTypes = new List <CustomerPaymentType>();
con.PaymentTypes.Add(CustomerPaymentType.Supplier);
con.States = new List <SheetState>();
con.States.Add(SheetState.Approved);
con.HasRemain = true;
frm.SearchCondition = con;
frm.Text = string.Format("{0} 付款流水明细", c.Name);
frm.ShowDialog();
}
}
}
/// <summary>
/// 获取某个客户的所有还有余额的付款单
/// </summary>
/// <returns></returns>
public QueryResultList <CustomerPayment> GetAllRemains(string customerID)
{
CustomerPaymentSearchCondition con = new CustomerPaymentSearchCondition();
con.CustomerID = customerID;
con.HasRemain = true;
return(GetItems(con));
}
public override CommandResult Delete(CompanyInfo info)
{
StackOutSheetSearchCondition con = new StackOutSheetSearchCondition();
con.CustomerID = info.ID;
List <StackOutSheet> items = (new StackOutSheetBLL(RepoUri)).GetItems(con).QueryObjects;
if (items != null && items.Count > 0)
{
return(new CommandResult(ResultCode.Fail, string.Format("不能删除客户 {0} 的资料，系统中已经存在此客户的送货单", info.Name)));
}
IUnitWork unitWork = ProviderFactory.Create <IUnitWork>(RepoUri);
CustomerPaymentSearchCondition con1 = new CustomerPaymentSearchCondition()
{
CustomerID = info.ID
};
List <CustomerPayment> cps = ProviderFactory.Create <IProvider <CustomerPayment, string> >(RepoUri).GetItems(con1).QueryObjects;
if (cps != null && cps.Count > 0)
{
foreach (CustomerPayment cp in cps)
{
ProviderFactory.Create <IProvider <CustomerPayment, string> >(RepoUri).Delete(cp, unitWork);
}
}
CustomerOtherReceivableSearchCondition con2 = new CustomerOtherReceivableSearchCondition()
{
CustomerID = info.ID
};
List <CustomerOtherReceivable> cds = ProviderFactory.Create <IProvider <CustomerOtherReceivable, string> >(RepoUri).GetItems(con2).QueryObjects;
if (cds != null && cds.Count > 0)
{
foreach (CustomerOtherReceivable cd in cds)
{
ProviderFactory.Create <IProvider <CustomerOtherReceivable, string> >(RepoUri).Delete(cd, unitWork);
}
}
CustomerReceivableSearchCondition con3 = new CustomerReceivableSearchCondition()
{
CustomerID = info.ID
};
List <CustomerReceivable> crs = ProviderFactory.Create <IProvider <CustomerReceivable, Guid> >(RepoUri).GetItems(con3).QueryObjects;
if (crs != null && crs.Count > 0)
{
foreach (CustomerReceivable cr in crs)
{
ProviderFactory.Create <IProvider <CustomerReceivable, Guid> >(RepoUri).Delete(cr, unitWork);
}
}
ProviderFactory.Create <IProvider <CompanyInfo, string> >(RepoUri).Delete(info, unitWork);
return(unitWork.Commit());
}
protected override List <CustomerPayment> GetingItems(System.Data.Linq.DataContext dc, SearchCondition search)
{
IQueryable <CustomerPayment> ret = dc.GetTable <CustomerPayment>();
if (search is SheetSearchCondition)
{
SheetSearchCondition con = search as SheetSearchCondition;
if (con.SheetDate != null)
{
ret = ret.Where(item => item.SheetDate >= con.SheetDate.Begin && item.SheetDate <= con.SheetDate.End);
}
if (con.LastActiveDate != null)
{
ret = ret.Where(item => item.LastActiveDate >= con.LastActiveDate.Begin && item.LastActiveDate <= con.LastActiveDate.End);
}
if (con.SheetNo != null && con.SheetNo.Count > 0)
{
ret = ret.Where(item => con.SheetNo.Contains(item.ID));
}
if (con.States != null && con.States.Count > 0)
{
ret = ret.Where(item => con.States.Contains(item.State));
}
}
if (search is CustomerPaymentSearchCondition)
{
CustomerPaymentSearchCondition con = search as CustomerPaymentSearchCondition;
if (!string.IsNullOrEmpty(con.CustomerID))
{
ret = ret.Where(item => item.CustomerID == con.CustomerID);
}
if (con.PaymentTypes != null && con.PaymentTypes.Count > 0)
{
ret = ret.Where(item => con.PaymentTypes.Contains(item.ClassID));
}
if (con.HasRemain != null)
{
if (con.HasRemain.Value)
{
ret = ret.Where(item => item.Assigned < item.Amount);
}
else
{
ret = ret.Where(item => item.Assigned >= item.Amount);
}
}
}
List <CustomerPayment> sheets = ret.ToList();
return(sheets);
}
protected override List <object> GetDataSource()
{
if (SearchCondition == null)
{
CustomerPaymentSearchCondition con = new CustomerPaymentSearchCondition();
con.LastActiveDate = new DateTimeRange(DateTime.Today.AddYears(-1), DateTime.Now);
con.PaymentTypes = new List <CustomerPaymentType>();
con.PaymentTypes.Add(CustomerPaymentType.Customer);
_Sheets = (new CustomerPaymentBLL(AppSettings.Current.ConnStr)).GetItems(con).QueryObjects;
}
else
{
_Sheets = (new CustomerPaymentBLL(AppSettings.Current.ConnStr)).GetItems(SearchCondition).QueryObjects;
}
return(FilterData());
}
private void chkShowAll_CheckedChanged(object sender, EventArgs e)
{
if (SearchCondition != null)
{
CustomerPaymentSearchCondition cpsc = SearchCondition as CustomerPaymentSearchCondition;
if (cpsc != null)
{
if (!chkShowAll.Checked)
{
cpsc.HasRemain = false;
}
else
{
cpsc.HasRemain = null;
}
}
ReFreshData();
}
}
