protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int id = Convert.ToInt32(Request.QueryString["id"]);
DalSic.SysPaciente pac = new DalSic.SysPaciente(id);
DataTable dtd = new DataTable();
if (pac != null)
{
txtDocumento.Text = pac.NumeroDocumento.ToString();
txtApellidoNombres.Text = pac.Apellido.ToString() + " " + pac.Nombre.ToString();;
txtEdad.Text = pac.Edad.ToString();
txtSexo.Text = pac.SysSexo.Nombre.ToString();
txtOS.Text = pac.SysObraSocial.Nombre.ToString();
SubSonic.Select query = new SubSonic.Select();
query.From(DalSic.SysDefuncion.Schema);
query.Where(SysDefuncion.Columns.IdPaciente).IsEqualTo(id).And(SysDefuncion.Columns.Activo).IsEqualTo(true);
dtd = query.ExecuteDataSet().Tables[0];
if (dtd.Rows.Count > 0) //Se encontró registro de defunción asociado
{
cargarRegistro(dtd);
btnAnularDefuncion.Visible = true;
hfupdate.Value = "si";
}
else
{
hfupdate.Value = "no";
}
}
}
}
/// <summary>
/// Loads the grid.
/// </summary>
private void LoadGrid()
{
if (String.IsNullOrEmpty(tableName))
{
throw new ArgumentException("No tableName property set - please be sure to set the name of the table or view you'd like to see", tableName);
}
DecideSortDirection();
//load the data
DataProvider provider = DataService.GetInstance(ProviderName);
SqlQuery q = new Select(provider).From(tableName);
//set the select list
StringBuilder selectList = new StringBuilder("*");
if (!String.IsNullOrEmpty(columnList))
{
selectList = new StringBuilder();
for (int i = 0; i < colList.Count; i++)
{
selectList.Append(colList[i].ToString().Trim());
if (i + 1 < colList.Count)
{
selectList.Append(",");
}
}
}
q.SelectColumnList = selectList.ToString().Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
//sorting
if (!String.IsNullOrEmpty(sortBy))
{
TableSchema.TableColumn col = provider.GetTableSchema(tableName, TableType.Table).GetColumn(sortBy);
if (col != null && col.MaxLength < 2048 && col.DataType != DbType.Binary && col.DataType != DbType.Byte)
{
if (String.IsNullOrEmpty(sortDirection) || sortDirection.Trim() == SqlFragment.ASC.Trim())
{
q.OrderAsc(sortBy);
}
else
{
q.OrderDesc(sortBy);
}
}
}
//paging
if (pageSize > 0)
{
q.Paged(pageIndex, pageSize);
ddlPages.SelectedValue = pageIndex.ToString();
}
//honor logical deletes
q.CheckLogicalDelete();
//where
if (!String.IsNullOrEmpty(whereExpression))
{
q.WhereExpression(whereExpression);
}
SqlQueryBridge.AddLegacyWhereCollection(q, whereCollection);
DataSet ds = q.ExecuteDataSet();
if (ds.Tables.Count > 0)
{
dataSource = ds.Tables[0];
}
else
{
throw new Exception("Bad query - no data returned. Did you set the correct provider?");
}
EnsureTotals(q);
//set the buttons
SetPagingButtonState();
//create a table
BuildRows();
}
