public IList <EntityExtraData> Select(EntityExtraData data)
        {
            IList <EntityExtraData> datos = new List <EntityExtraData>();

            datos = GetHsql(data).List <EntityExtraData>();
            if (!Factory.IsTransactional)
            {
                Factory.Commit();
            }
            return(datos);
        }
        public override IQuery GetHsql(Object data)
        {
            StringBuilder   sql    = new StringBuilder("select a from EntityExtraData a    where  ");
            EntityExtraData imgRel = (EntityExtraData)data;

            if (imgRel != null)
            {
                Parms = new List <Object[]>();


                if (imgRel.Entity != null && imgRel.Entity.ClassEntityID != 0)
                {
                    sql.Append(" a.Entity.ClassEntityID = :id1     and   ");
                    Parms.Add(new Object[] { "id1", imgRel.Entity.ClassEntityID });
                }

                if (imgRel.EntityRowID != 0)
                {
                    sql.Append(" a.EntityRowID = :id2     and   ");
                    Parms.Add(new Object[] { "id2", imgRel.EntityRowID });
                }


                if (imgRel.RowID != 0)
                {
                    sql.Append(" a.RowID = :idr2     and   ");
                    Parms.Add(new Object[] { "id2r", imgRel.RowID });
                }
            }

            sql = new StringBuilder(sql.ToString());
            sql.Append(" 1=1 order by a.RowID asc ");
            IQuery query = Factory.Session.CreateQuery(sql.ToString());

            SetParameters(query);
            return(query);
        }
Esempio n. 3
0
        void View_UpdateAdditionalInfo(object sender, EventArgs e)
        {
            try
            {

                string xmlMsg = "";
                string curName = "";
                //Envia el XM con la informacion guardada adicional
                foreach (UIElement uiE in View.StkAddInfo.Children)
                {
                    try
                    {
                        if (((StackPanel)uiE).Children.Count > 0)


                            foreach (UIElement uiE2 in ((StackPanel)uiE).Children)

                                try
                                {
                                    if (((StackPanel)uiE2).Children.Count > 0)

                                        foreach (UIElement uiE3 in ((StackPanel)uiE2).Children)
                                        {
                                            try
                                            {
                                                curName = uiE3.GetType().GetProperty("Uid").GetValue(uiE3, null).ToString();

                                                if (curName.StartsWith("_"))
                                                {
                                                    //xmlMsg += curName;
                                                    //xmlMsg += uiE3.GetType().GetProperty("Text").GetValue(uiE3, null).ToString();
                                                    xmlMsg += "\t<" + curName + ">" + uiE3.GetType().GetProperty("Text").GetValue(uiE3, null).ToString() + "</" + curName + ">\n";
                                                }
                                            }
                                            catch { }
                                        }
                                }
                                catch { }

                    }
                    catch { }

                }

                xmlMsg = "<Data>\n" + xmlMsg + "</Data>\n";

                EntityExtraData exData = new EntityExtraData
                {
                    Entity = new ClassEntity { ClassEntityID = EntityID.Document },
                    EntityRowID = View.Model.CurOpenDoc.DocID
                };



                try { exData = service.GetEntityExtraData(exData).First(); }
                catch { }

                exData.XmlData = xmlMsg;


                //Guardar la data adicional.
                if (exData.RowID == 0)
                {
                    exData.CreatedBy = App.curUser.UserName;
                    exData.CreationDate = DateTime.Now;
                    service.SaveEntityExtraData(exData);
                }
                else
                {
                    exData.ModifiedBy = App.curUser.UserName;
                    exData.ModDate = DateTime.Now;
                    service.UpdateEntityExtraData(exData);
                }

                Util.ShowMessage("Additional Information Updated.");

            }
            catch
            {
                Util.ShowError("Additional Information could not be updated.");
            }

        }
Esempio n. 4
0
 internal void DeleteEntityExtraData(EntityExtraData EntityExtraData)
 {
     try
     {
         SetService();
         SerClient.DeleteEntityExtraData(EntityExtraData);
     }
     finally
     {
         SerClient.Close();
         if (SerClient.State == CommunicationState.Faulted)
             SerClient.Abort();
     }
 }
Esempio n. 5
0
 internal EntityExtraData SaveEntityExtraData(EntityExtraData EntityExtraData)
 {
     try
     {
         SetService();
         return SerClient.SaveEntityExtraData(EntityExtraData);
     }
     finally
     {
         SerClient.Close();
         if (SerClient.State == CommunicationState.Faulted)
             SerClient.Abort();
     }
 }
 public EntityExtraData SelectById(EntityExtraData data)
 {
     return((EntityExtraData)base.SelectById(data));
 }
 public Boolean Delete(EntityExtraData data)
 {
     return(base.Delete(data));
 }
 public Boolean Update(EntityExtraData data)
 {
     return(base.Update(data));
 }
 public EntityExtraData Save(EntityExtraData data)
 {
     return((EntityExtraData)base.Save(data));
 }