private void ClearAll()
{
Session.Remove("Criterion");
txtEducation21Indicator.Text = "";
//ddlEducation21Side.SelectedIndex = 0;
//ddlEducation21Standard.SelectedIndex = 0;
txtDetail.Text = "";
txtSearch.Text = "";
GridViewCriterion.DataSource = null;
GridViewCriterion.DataBind();
}
protected void btDelCriterion_Click(object sender, EventArgs e)
{
if (GridViewCriterion.SelectedItems.Length == 0)
{
return;
}
DataTable dt1 = new DataTable();
dt1 = (DataTable)Session["Criterion"];
DataRow[] dra = dt1.Select("id in (" + string.Join(",", GridViewCriterion.SelectedItems) + ")");
foreach (DataRow dr in dra)
{
dr.Delete();
}
dt1.AcceptChanges();
dvCriterion = dt1.DefaultView;
Session["Criterion"] = dt1;
GridViewCriterion.DataSource = dvCriterion;
GridViewCriterion.DataBind();
if (dvCriterion.Count == 0)
{
btDelCriterion.Visible = false;
}
}
protected void btaddCriterion_Click(object sender, EventArgs e)
{
if (Session["Criterion"] == null)
{
DataTable dt1 = new DataTable();
dt1.Columns.Add("id");
dt1.Columns.Add("Education21CriterionID");
dt1.Columns.Add("Sort");
dt1.Columns.Add("Detail");
dt1.Columns.Add("Score");
DataRow dr;
dr = dt1.NewRow();
dr["id"] = dr.Table.Rows.Count;
dr["Education21CriterionID"] = Guid.NewGuid().ToString();
dr["Sort"] = ddlCriterionSort.SelectedValue;
dr["Detail"] = txtcDetail.Text;
dr["Score"] = txtcScore.Text;
dt1.Rows.Add(dr);
dvCriterion = dt1.DefaultView;
Session["Criterion"] = dt1;
}
else
{
DataTable dt1 = new DataTable();
dt1 = (DataTable)Session["Criterion"];
if (txtid.Text == "")
{
DataView ckdv = ((DataTable)Session["Criterion"]).DefaultView;
if (ckdv.Count != 0)
{
for (int i = 0; i < ckdv.Count; i++)
{
if (ckdv[i]["Sort"].ToString() == ddlCriterionSort.SelectedValue)
{
lblckCritetion.Visible = true;
return;
}
}
}
DataRow dr;
dr = dt1.NewRow();
dr["id"] = dr.Table.Rows.Count;
dr["Education21CriterionID"] = Guid.NewGuid().ToString();
dr["Sort"] = ddlCriterionSort.SelectedValue;
dr["Detail"] = txtcDetail.Text;
dr["Score"] = txtcScore.Text;
dt1.Rows.Add(dr);
}
else
{
DataView ckdv = ((DataTable)Session["Criterion"]).DefaultView;
if (ckdv.Count != 0)
{
for (int i = 0; i < ckdv.Count; i++)
{
if ((ckdv[i]["id"].ToString() != txtid.Text) && (ckdv[i]["Sort"].ToString() == ddlCriterionSort.SelectedValue))
{
lblckCritetion.Visible = true;
return;
}
}
}
Int32 j = Convert.ToInt32(txtid.Text);
dt1.Rows[j]["Education21CriterionID"] = hdfEducation21CriterionID.Value;
dt1.Rows[j]["Sort"] = ddlCriterionSort.SelectedValue;
dt1.Rows[j]["Detail"] = txtcDetail.Text;
dt1.Rows[j]["Score"] = txtcScore.Text;
}
lblckCritetion.Visible = false;
dvCriterion = dt1.DefaultView;
Session["Criterion"] = dt1;
}
dvCriterion.Sort = "Sort";
ClearCriterion();
GridViewCriterion.DataSource = dvCriterion;
GridViewCriterion.CheckListDataField = "id";
GridViewCriterion.DataBind();
if (dvCriterion.Count > 0)
{
btDelCriterion.Visible = true;
GridViewCriterion.Visible = true;
}
}
private void GetData(string id)
{
if (string.IsNullOrEmpty(id))
{
return;
}
string strSql = @"Select SI.*, S.StudyYear, S.EvaluateType, SD.Education21SideID From Education21Side S, Education21Standard SD, Education21Indicator SI
Where SI.Education21IndicatorID = '{0}' And S.Education21SideID = SD.Education21SideID And SD.Education21StandardID = SI.Education21StandardID ";
DataView dv = Conn.Select(string.Format(strSql, id));
if (dv.Count != 0)
{
ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString();
ddlEvaluateType.SelectedValue = dv[0]["EvaluateType"].ToString();
getddlEducation21Side(1, ddlYearB.SelectedValue);
ddlEducation21Side.SelectedValue = dv[0]["Education21SideID"].ToString();
getddlEducation21Standard(1, ddlEducation21Side.SelectedValue);
ddlEducation21Standard.SelectedValue = dv[0]["Education21StandardID"].ToString();
txtEducation21Indicator.Text = dv[0]["Education21IndicatorName"].ToString();
txtDetail.Text = dv[0]["Detail"].ToString();
txtSort.Text = dv[0]["Sort"].ToString();
strSql = " Select RecNum As id, Education21CriterionID, Sort, Detail, Score "
+ " From Education21Criterion "
+ " Where Education21IndicatorID = '{0}' ";
dvCriterion = Conn.Select(string.Format(strSql + " Order By Sort ", id));
if (dvCriterion.Count != 0)
{
btDelCriterion.Visible = true;
if (Session["Criterion"] == null)
{
DataTable dt1 = new DataTable();
dt1.Columns.Add("id");
dt1.Columns.Add("Education21CriterionID");
dt1.Columns.Add("Sort");
dt1.Columns.Add("Detail");
dt1.Columns.Add("Score");
DataRow dr;
for (int i = 0; i < dvCriterion.Count; i++)
{
dr = dt1.NewRow();
dr["id"] = dvCriterion[i]["id"].ToString();
dr["Education21CriterionID"] = dvCriterion[i]["Education21CriterionID"].ToString();
dr["Sort"] = dvCriterion[i]["Sort"].ToString();
dr["Detail"] = dvCriterion[i]["Detail"].ToString();
dr["Score"] = dvCriterion[i]["Score"].ToString();
dt1.Rows.Add(dr);
}
dvCriterion = dt1.DefaultView;
Session["Criterion"] = dt1;
}
GridViewCriterion.Visible = true;
GridViewCriterion.DataSource = dvCriterion;
GridViewCriterion.CheckListDataField = "id";
GridViewCriterion.DataBind();
}
else
{
btDelCriterion.Visible = false;
GridViewCriterion.Visible = false;
}
}
btc.getCreateUpdateUser(lblCreate, lblUpdate, "Education21Indicator", "Education21IndicatorID", id);
}
