protected void cbSearch_Callback(object source, DevExpress.Web.ASPxCallback.CallbackEventArgs e)
{
IList <ChequeBatch> chequeBatchs = ChequeBatch.FindAvailable(iSabayaContext, BankAccountTextBoxControl21.BankAccount);
IList <ChequeBatchItem> chequeBL = new List <ChequeBatchItem>();
foreach (ChequeBatch cb in chequeBatchs)
{
foreach (ChequeBatchItem cbi in cb.ChequeBatchMembers)
{
if (cbi.Cheque == null)
{
chequeBL.Add(cbi);
break;
}
}
}
Session["ctrls_ChequeBatchItemControl_ChequeBatchItems"] = chequeBL;
gridChequeBatchItems.DataSource = chequeBL;
gridChequeBatchItems.DataBind();
}
public void BindBatchItem()
{
if (Session["SessionBankAccount"] != null)
{
BankAccount ba = (BankAccount)Session["SessionBankAccount"];
List <long> cheque = new List <long>();
IList <Cheque> ch = new List <Cheque>();
ICriteria critCheque = iSabayaContext.PersistencySession.CreateCriteria(typeof(Cheque));
critCheque.Add(Expression.Eq("BankAccount", ba));
ch = critCheque.List <Cheque>();
for (int i = 0; i < ch.Count; i++)
{
if (ch[i].BatchItem != null)
{
cheque.Add(ch[i].BatchItem.ChequeBatchItemID);
}
}
Session["ctrls_ChequeBatchItemControl_ChequeBatchItems"] = null;
IList <ChequeBatch> chequeB = ChequeBatch.FindAvailable(iSabayaContext, ba);
IList <ChequeBatchItem> chequeList = new List <ChequeBatchItem>();
for (int i = 0; i < chequeB.Count; i++)
{
ICriteria crit = iSabayaContext.PersistencySession.CreateCriteria(typeof(ChequeBatchItem));
crit.Add(Expression.Eq("ChequeBatch", chequeB[i]));
crit.Add(Expression.IsNull("Cheque"));//เช็คว่าเช็คใช้หรือยัง ถ้าใช้แล้วเช็ค ChequeBatchItem จะมีChequeID
if (cheque != null)
{
crit.Add(Expression.Not(Expression.In("ChequeBatchItemID", cheque)));
}
foreach (ChequeBatchItem item in crit.List <ChequeBatchItem>())
{
chequeList.Add(item);
}
}
Session["ctrls_ChequeBatchItemControl_ChequeBatchItems"] = chequeList;
}
}
public VOChequeBatch(ChequeBatch instance)
{
this.instance = instance;
}
