protected void txtTransCode_TextChanged(object sender, EventArgs e)
{
string tlcode = txtTransLocCode.Text.Trim() + txtTransSubLocCode.Text.Trim() + txtTransCode.Text.Trim();
if (!myFunc.isTransLocCodeExist(tlcode))
{
txtTransLocDesc.Text = "";
txtTransLocDesc.Enabled = true;
txtTransLocDesc.Focus();
btnSave.Enabled = true;
btnDelete.Enabled = false;
//btnSaveBottom.Enabled=true;
//btnDeleteBottom.Enabled=false;
GridViewTransLocs.Visible = true;
SqlDataSourceTransLocations.SelectCommand = "select * from PartsTransLocation where PartsLocCode='" + txtLocCode.Text.Trim() + "' and PartsSubLocCode='" + txtSubLocCode.Text.Trim() + "'";
SqlDataSourceTransLocations.Select(DataSourceSelectArguments.Empty);
GridViewTransLocs.Visible = true;
GridViewTransLocs.DataBind();
}
else
{
txtTransLocDesc.Text = myFunc.GetTransLocDesc(tlcode);
txtTransLocDesc.Enabled = true;
btnSave.Enabled = false;
btnDelete.Enabled = true;
//btnSaveBottom.Enabled = false;
//btnDeleteBottom.Enabled = true;
GridViewTransLocs.Visible = true;
SqlDataSourceTransLocations.SelectCommand = "select * from PartsTransLocation where PartsTransLocCode='" + tlcode + "'";
SqlDataSourceTransLocations.SelectCommand = "select * from PartsTransLocation where PartsLocCode='" + txtLocCode.Text.Trim() + "' and PartsSubLocCode='" + txtSubLocCode.Text.Trim() + "'";
SqlDataSourceTransLocations.Select(DataSourceSelectArguments.Empty);
GridViewTransLocs.Visible = true;
GridViewTransLocs.DataBind();
}
}
