private void UpdateDescField()
{
try
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = "PartNum = '" + partnum_txt.Text + "'";
int pagesize = 1;
bool morePages;
PartList = Part.GetList(WhereClause, pagesize, 0, out morePages);
DataList.EpicClose();
desc_txt.Text = PartList.Tables[0].Rows[0]["PartDescription"].ToString();
Part = null;
PartList.Dispose();
PartList = null;
}
catch { desc_txt.Text = ""; }
}
private void SearchBtn_Click(object sender, EventArgs e)
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = PartNo() + Desc() + OfType() + Activity() + OnHold() + NonStock() + TrackLots() + SortBy();
int pageSize;
if (Properties.Settings.Default.allresults)
{
pageSize = 0;
}
else
{
pageSize = Properties.Settings.Default.linelimit;
}
bool morePages;
PartList = Part.GetList(WhereClause, pageSize, 0, out morePages);
DataList.EpicClose();
SearchResultGrid.AutoGenerateColumns = false;
SearchResultGrid.DataSource = PartList.Tables[0];
if (PartList.Tables[0].Rows.Count < 1)
{
SearchResultGrid.DataSource = "";
}
}
private void UpdateDescField()
{
try
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = "PartNum = '" + partnum_txt.Text + "'";
int pagesize = 1;
bool morePages;
PartList = Part.GetList(WhereClause, pagesize, 0, out morePages);
DataList.EpicClose();
desc_txt.Text = PartList.Tables[0].Rows[0]["PartDescription"].ToString();
Part = null;
PartList.Dispose();
PartList = null;
}
catch { desc_txt.Text = ""; }
}
private void SearchBtn_Click(object sender, EventArgs e)
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = PartNo() + Desc() + OfType() + Activity() + OnHold() + NonStock() + TrackLots() + SortBy();
int pageSize;
if (Properties.Settings.Default.allresults)
pageSize = 0;
else
pageSize = Properties.Settings.Default.linelimit;
bool morePages;
PartList = Part.GetList(WhereClause, pageSize, 0, out morePages);
DataList.EpicClose();
SearchResultGrid.AutoGenerateColumns = false;
SearchResultGrid.DataSource = PartList.Tables[0];
if (PartList.Tables[0].Rows.Count < 1)
SearchResultGrid.DataSource = "";
}
private void UpdateParentRev()
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = "PartNum = '" + parent_txt.Text + "'";
int pagesize = 1;
bool morePages;
PartList = Part.GetList(WhereClause, pagesize, 0, out morePages);
DataList.EpicClose();
parentrev_txt.Text = PartList.Tables[0].Rows[0]["PartRevision"].ToString();
Part = null;
PartList.Dispose();
PartList = null;
}
private string UpdateParentDesc()
{
Part Part = new Part(DataList.EpicConn);
PartListDataSet PartList = new PartListDataSet();
string WhereClause = "PartNum = '" + partnumber_txt.Text + "'";
int pagesize = 1;
bool morePages;
PartList = Part.GetList(WhereClause, pagesize, 0, out morePages);
DataList.EpicClose();
string desc = PartList.Tables[0].Rows[0]["PartDescription"].ToString();
Part = null;
PartList.Dispose();
PartList = null;
return desc;
}
