public override IQuery GetHsql(Object data)
{
StringBuilder sql = new StringBuilder("select a from C_CasNumber a where ");
C_CasNumber C_CasNumber = (C_CasNumber)data;
if (C_CasNumber != null)
{
Parms = new List <Object[]>();
if (C_CasNumber.CasNumberID != 0)
{
sql.Append(" a.CasNumberID = :id and ");
Parms.Add(new Object[] { "id", C_CasNumber.CasNumberID });
}
if (!String.IsNullOrEmpty(C_CasNumber.Name))
{
sql.Append(" (a.Name like :nom OR a.Code like :nomz) and ");
Parms.Add(new Object[] { "nom", "%" + C_CasNumber.Name + "%" });
Parms.Add(new Object[] { "nomz", C_CasNumber.Name + "%" });
}
if (!String.IsNullOrEmpty(C_CasNumber.Code))
{
sql.Append(" a.Code = :nom1 and ");
Parms.Add(new Object[] { "nom1", C_CasNumber.Code });
}
}
sql = new StringBuilder(sql.ToString());
sql.Append(" 1=1 order by a.CasNumberID asc ");
IQuery query = Factory.Session.CreateQuery(sql.ToString());
SetParameters(query);
return(query);
}
public void LoadData(C_CasNumber casnumber, bool reset)
{
this.CasNumber = casnumber;
RecordList = null;
if (reset)
{
//Regulator = null;
//lvRules.SelectedIndex = -1;
}
if (Regulator == null)
{
lvRules.Items.Refresh();
return;
}
//Y la lista de Rules
RecordList = service.GetC_CasNumberRule(new C_CasNumberRule {
CasNumber = this.CasNumber,
Rule = new MMaster {
MetaType = new MType {
Code = Regulator.Code
}
}
});
lvRules.Items.Refresh();
}
public IList <C_CasNumber> Select(C_CasNumber data)
{
IList <C_CasNumber> datos = new List <C_CasNumber>();
try
{
datos = GetHsql(data).SetMaxResults(WmsSetupValues.NumRegs).List <C_CasNumber>();
if (!Factory.IsTransactional)
{
Factory.Commit();
}
}
catch (Exception e)
{
NHibernateHelper.WriteEventLog(WriteLog.GetTechMessage(e));
}
return(datos);
}
private void cboData_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
C_CasNumber data = ((ComboBox)sender).SelectedItem as C_CasNumber;
if (data == null)
{
return;
}
txtData.Text = data.Code;
this.C_CasNumber = data;
this.C_CasNumberDesc = C_CasNumber.Name;
cboData.Visibility = Visibility.Collapsed;
//imgLoad.Focus();
EventHandler temp = OnLoadRecord;
if (temp != null)
{
temp(sender, e);
}
}
internal void DeleteC_CasNumber(C_CasNumber c_CasNumber)
{
try
{
SetService();
SerClient.DeleteC_CasNumber(c_CasNumber);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
internal C_CasNumber SaveC_CasNumber(C_CasNumber c_CasNumber)
{
try
{
SetService();
return SerClient.SaveC_CasNumber(c_CasNumber);
}
finally
{
SerClient.Close();
if (SerClient.State == CommunicationState.Faulted)
SerClient.Abort();
}
}
public void LoadData(C_CasNumber casnumber, bool reset)
{
this.CasNumber = casnumber;
RecordList = null;
if (reset)
{
//Regulator = null;
//lvRules.SelectedIndex = -1;
}
if (Regulator == null)
{
lvRules.Items.Refresh();
return;
}
//Y la lista de Rules
RecordList = service.GetC_CasNumberRule(new C_CasNumberRule {
CasNumber = this.CasNumber,
Rule = new MMaster { MetaType = new MType { Code = Regulator.Code } }
});
lvRules.Items.Refresh();
}
public C_CasNumber SelectById(C_CasNumber data)
{
return((C_CasNumber)base.SelectById(data));
}
public Boolean Delete(C_CasNumber data)
{
return(base.Delete(data));
}
public Boolean Update(C_CasNumber data)
{
return(base.Update(data));
}
public C_CasNumber Save(C_CasNumber data)
{
return((C_CasNumber)base.Save(data));
}
