private void CreateLendPanel(GridRowHeaderDoubleClickEventArgs e, SQLiteConnection conn)
{
GridPanel panel = ArchiveGrid.PrimaryGrid;
GridRow row = (GridRow)panel.Rows[e.GridRow.RowIndex];
SQLiteCommand cmd = new SQLiteCommand();
cmd.Connection = conn;
try
{
int archId = int.Parse(row.Cells[1].Value.ToString());
string strsql = string.Format("select * from LendArchive where ArchId ={0} order by LendDate desc", archId);
cmd.CommandText = strsql;
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
GridPanel subPanel = new GridPanel();
SetLendPanelColumn(subPanel);
while (reader.Read())
{
GridRow gr = new GridRow();
gr.Cells.Add(new GridCell(reader.GetInt16(0)));
gr.Cells.Add(new GridCell(reader.GetString(1)));
if (!reader.IsDBNull(2))
{
gr.Cells.Add(new GridCell(Convert.ToDateTime(reader.GetString(2))));
}
gr.Cells.Add(new GridCell(reader.GetInt16(3)));
gr.Cells.Add(new GridCell(reader.IsDBNull(4) ? "" : reader.GetString(4)));
gr.Cells.Add(new GridCell(reader.IsDBNull(5) ? "" : reader.GetString(5)));
gr.Cells.Add(new GridCell(reader.IsDBNull(9) ? "" : reader.GetString(9)));
gr.Cells.Add(new GridCell(reader.IsDBNull(7) ? "" : reader.GetString(7)));
if (!reader.IsDBNull(8))
{
gr.Cells.Add(new GridCell(Convert.ToDateTime(reader.GetString(8))));
}
gr.Cells.Add(new GridCell(reader.IsDBNull(6) ? "" : reader.GetString(6)));
gr.Cells.Add(new GridCell(reader.IsDBNull(10) ? "" : reader.GetString(10)));
gr.Cells.Add(new GridCell(reader.IsDBNull(11) ? "" : reader.GetString(11)));
subPanel.Rows.Add(gr);
}
e.GridRow.Rows.Add(subPanel);
e.GridRow.Expanded = true;
}
}
catch (System.Data.SQLite.SQLiteException E)
{
throw new Exception(E.Message);
}
}
private void ProjectGrid_RowHeaderDoubleClick(object sender, GridRowHeaderDoubleClickEventArgs e)
{
GridPanel panel = ProjectGrid.PrimaryGrid;
GridRow row = (GridRow)panel.Rows[e.GridRow.RowIndex];
row.Rows.Clear();
int id = (int)row.Cells["gcId"].Value;
using (SQLiteConnection conn = new SQLiteConnection(DataSourceManager.DataSource))
{
conn.Open();
SQLiteCommand cmd = new SQLiteCommand();
cmd.Connection = conn;
try
{
string Id = row.Cells[0].Value.ToString();
string strsql = string.Format("select * from ArchiveInfo where ProjectId={0} order by ArchDate desc", id);
cmd.CommandText = strsql;
SQLiteDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
GridPanel subPanel = new GridPanel();
SetArchivePanelColumn(subPanel);
while (reader.Read())
{
ArchiveInfo ai = new ArchiveInfo();
ai.Id = reader.GetInt16(0);
ai.ArchiveName = reader.GetString(1);
ai.ArchType = reader.GetString(2);
if (!reader.IsDBNull(3))
{
ai.ArchDate = Convert.ToDateTime(reader.GetString(3));
}
ai.DispatchNum = reader.IsDBNull(4) ? "" : reader.GetString(4);
ai.Copies = reader.GetInt16(5);
ai.Remaining = reader.GetInt16(6);
ai.StorageLocation = reader.IsDBNull(7) ? "" : reader.GetString(7);
ai.Handler = reader.IsDBNull(8) ? "" : reader.GetString(8);
GridRow gr = new GridRow();
gr.Cells.Add(new GridCell(ai.ArchiveName));
gr.Cells.Add(new GridCell(ai.Id));
gr.Cells.Add(new GridCell(ai.ArchType));
if (ai.ArchDate != null)
{
gr.Cells.Add(new GridCell(ai.ArchDate.ToString()));//"yyyy-MM-dd"
}
gr.Cells.Add(new GridCell(ai.DispatchNum));
gr.Cells.Add(new GridCell(ai.Copies));
gr.Cells.Add(new GridCell(ai.Remaining));
gr.Cells.Add(new GridCell(ai.StorageLocation));
gr.Cells.Add(new GridCell(ai.Handler));
subPanel.Rows.Add(gr);
}
e.GridRow.Rows.Add(subPanel);
}
}
catch (System.Data.SQLite.SQLiteException E)
{
throw new Exception(E.Message);
}
}
}
