private void GVBaleEditDataBind()
{
UserSaveData.Visible = true;
StringBuilder sql = new StringBuilder("select t.*,jp_project_api.get_name(t.project_id) project_name from gen_part_package t where 1=1");
if (DdlProjectQ.SelectedValue != "0")
{
sql.Append(string.Format(" and project_id ='{0}'", DdlProjectQ.SelectedValue));
}
else
{
sql.Append(string.Format(" and project_id in ({0})", ProjectWhereString()));
}
if (TxtPackageNoQ.Text.Trim() != "")
{
sql.Append(string.Format(" and package_no like '{0}'", TxtPackageNoQ.Text));
}
if (TxtPackageNameQ.Text.Trim() != "")
{
sql.Append(string.Format(" and package_name like '{0}'", TxtPackageNameQ.Text));
}
GVBaleEdit.DataSource = DBHelper.createGridView(sql.ToString());
GVBaleEdit.DataKeyNames = new string[] { "package_no" };
GVBaleEdit.DataBind();
//if (GVBaleEdit.Rows.Count == 0) UserSaveData.Visible = false;
}
private void GVBaleEditDataBind_(string objid_)
{
StringBuilder sql = new StringBuilder("select t.*,jp_project_api.get_name(t.project_id) project_name from gen_part_package t where rowid='" + objid_ + "'");
GVBaleEdit.DataSource = DBHelper.createGridView(sql.ToString());
GVBaleEdit.DataKeyNames = new string[] { "package_no" };
GVBaleEdit.DataBind();
}
