protected void Page_Load(object sender, EventArgs e)
{
this.Title = "YPSCS Survey";
if (!this.IsPostBack)
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
dc.CommandText = "SELECT svcode,svname FROM prd_survey WHERE is_enabled='Y' ORDER BY svcode";
dc.Connection.Open();
IDataReader dr = dc.ExecuteReader();
while (dr.Read())
{
Button btn = new Button();
btn.Text = dr["svname"].ToString();
btn.Width = 300;
btn.Height = 60;
btn.Attributes.Add("OnClick", "window.location='/Survey/" + dr["svcode"].ToString() + "/';return false;");
Literal li = new Literal();
li.Text = "<br/>";
this.Panel_Survey.Controls.Add(btn);
this.Panel_Survey.Controls.Add(li);
}
dr.Close();
dr.Dispose();
dc.Connection.Close();
dc.Connection.Dispose();
Session.Clear();
}
}
private void LoadDetail()
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
dc.CommandText = "SELECT seq,title FROM prd_surveydetail WHERE svcode='" + _svcode + "' ORDER BY seq";
dc.Connection.Open();
DataSet ds = dc.Execute();
string seq = ds.Tables[0].Compute("MAX(seq)", "").ToString();
if (!String.IsNullOrEmpty(seq))
{
int max = int.Parse(seq);
this.Input_Seq.Text = (++max).ToString();
}
else
{
this.Input_Seq.Text = "1";
}
this.GV_Detail.DataSource = ds;
this.GV_Detail.DataBind();
ds.Tables.Clear();
ds.Clear();
ds.Dispose();
dc.Connection.Close();
dc.Connection.Dispose();
}
private void QueryData()
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
string wherestr = "";
string sql = @"SELECT svcode,svname,(CASE WHEN is_enabled='Y' THEN '是' ELSE '否' END) AS enabled FROM prd_survey ";
if (!String.IsNullOrEmpty(this.Query_Name.Text))
{
if (!String.IsNullOrEmpty(wherestr))
{
wherestr += " AND";
}
wherestr += " (svname like '%" + this.Query_Name.Text + "%' OR svcode LIKE '%" + this.Query_Name.Text + "%')";
}
if (this.Query_Enabled.SelectedValue != "-NULL-")
{
if (!String.IsNullOrEmpty(wherestr))
{
wherestr += " AND";
}
wherestr += " (is_enabled='" + this.Query_Enabled.SelectedValue + "')";
}
if (!String.IsNullOrEmpty(wherestr))
{
wherestr = " WHERE " + wherestr;
}
sql = sql + wherestr + " ORDER BY svcode";
dc.CommandText = sql;
dc.Connection.Open();
this.GV_Survey.DataSource = dc.Execute().Tables[0];
this.GV_Survey.DataBind();
dc.Connection.Close();
dc.Connection.Dispose();
}
protected void Button_Delete_Click(object sender, EventArgs e)
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
dc.CommandText = "DELETE FROM prd_survey WHERE svcode='" + _svcode + "'";
dc.Connection.Open();
dc.ExecuteNonQuery();
dc.Connection.Close();
dc.Connection.Dispose();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "JSScript", "window.parent.closedialog();", true);
}
protected void GV_Detail_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Delete")
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
dc.CommandText = "DELETE FROM prd_surveydetail WHERE svcode='" + _svcode + "' and seq='" + e.CommandArgument + "'";
dc.Connection.Open();
dc.ExecuteNonQuery();
dc.Connection.Close();
dc.Connection.Dispose();
}
}
private string LoadCategory(string catid)
{
StringBuilder sb = new StringBuilder();
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
string sql = "";
if (String.IsNullOrEmpty(catid))
{
sql = "SELECT CAT_ID,CODE,NAME,SEQ FROM SYS_CATEGORY WHERE PID IS NULL ORDER BY SEQ";
dc.CommandText = sql;
}
else
{
sql = "SELECT CAT_ID,CODE,NAME,SEQ FROM SYS_CATEGORY WHERE PID='" + catid + "' ORDER BY SEQ";
dc.CommandText = sql;
}
dc.Connection.Open();
DataTable dt = dc.Execute().Tables[0];
dc.Connection.Close();
dc.Connection.Dispose();
for (int x = 0; x < dt.Rows.Count; x++)
{
string catstr = LoadCategory(dt.Rows[x]["CAT_ID"].ToString());
string constr = LoadContent(dt.Rows[x]["CAT_ID"].ToString());
if (catstr.Length > 0 || constr.Length > 0)
{
sb.Append(@"<li><a href=""#"" class=""parent""><span>" + dt.Rows[x]["NAME"].ToString() + "</span></a>");
sb.Append("<div><ul>");
if (catstr.Length > 0)
{
sb.Append("" + catstr + "");
}
if (constr.Length > 0)
{
sb.Append(constr);
}
sb.Append("</ul></div>");
sb.Append("</li>");
}
}
return(sb.ToString());
}
protected void Button_Add_Click(object sender, EventArgs e)
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
dc.CommandText = "INSERT INTO prd_surveydetail (svcode,seq,title) VALUES (:svcode,:seq,:item)";
dc.Connection.Open();
dc.Parameter.Clear();
dc.Parameter.Add("svcode", DbType.String).Value = _svcode;
dc.Parameter.Add("seq", DbType.Int32).Value = int.Parse(this.Input_Seq.Text);
dc.Parameter.Add("item", DbType.String).Value = this.Input_Item.Text;
dc.ExecuteNonQuery();
dc.Connection.Close();
dc.Connection.Dispose();
this.Input_Seq.Text = "";
this.Input_Item.Text = "";
}
private void QueryData()
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
string wherestr = "";
string sql = @"SELECT A.svcode,A.svname,B.company,B.department,B.name,B.email,B.modifydate,B.id AS svid FROM prd_survey A INNER JOIN prd_ans B ON B.svcode=A.svcode";
if (!String.IsNullOrEmpty(this.Query_Company.Text))
{
if (!String.IsNullOrEmpty(wherestr))
{
wherestr += " AND";
}
wherestr += " (B.company like '%" + this.Query_Company.Text + "%')";
}
if (!String.IsNullOrEmpty(this.Query_Name.Text))
{
if (!String.IsNullOrEmpty(wherestr))
{
wherestr += " AND";
}
wherestr += " (B.name like '%" + this.Query_Name.Text + "%' OR B.email LIKE '%" + this.Query_Name.Text + "%')";
}
if (this.Query_Code.SelectedValue != "-NULL-")
{
if (!String.IsNullOrEmpty(wherestr))
{
wherestr += " AND";
}
wherestr += " (A.svcode='" + this.Query_Code.SelectedValue + "')";
}
if (!String.IsNullOrEmpty(wherestr))
{
wherestr = " WHERE " + wherestr;
}
sql = sql + wherestr + " ORDER BY B.modifydate";
dc.CommandText = sql;
dc.Connection.Open();
this.GV_Survey.DataSource = dc.Execute().Tables[0];
this.GV_Survey.DataBind();
dc.Connection.Close();
dc.Connection.Dispose();
}
private void LoadData()
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
dc.CommandText = "SELECT svcode,svname,is_enabled FROM prd_survey WHERE svcode='" + _svcode + "'";
dc.Connection.Open();
IDataReader dr = dc.ExecuteReader();
if (dr.Read())
{
this.Input_Code.Text = dr["svcode"].ToString();
this.Input_Name.Text = dr["svname"].ToString();
this.Input_Enabled.Checked = (dr["is_enabled"].ToString() == "Y");
}
dr.Close();
dr.Dispose();
dc.Connection.Close();
dc.Connection.Dispose();
}
private string LoadContent(string catid)
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
StringBuilder sb = new StringBuilder();
string sql = @"SELECT NAME,LINKURL FROM SYS_CONTENT WHERE CAT_ID='" + catid + @"'";
YPSCS.Base.SiteBase se = new YPSCS.Base.SiteBase();
dc.CommandText = sql;
dc.Connection.Open();
DataTable dt = dc.Execute().Tables[0];
dc.Connection.Close();
dc.Connection.Dispose();
for (int y = 0; y < dt.Rows.Count; y++)
{
sb.Append(@"<li><a href=""" + dt.Rows[y]["LINKURL"].ToString() + @""" ><span>" + dt.Rows[y]["NAME"].ToString() + "</span></a></li>");
}
return(sb.ToString());
}
protected void Button_Save_Click(object sender, EventArgs e)
{
CheckInput();
if (this.PopupMessage1.Length == 0)
{
YPSCS.Framework.Data.SQLiteData dc = new YPSCS.Framework.Data.SQLiteData();
if (!String.IsNullOrEmpty(_svcode))
{
dc.CommandText = "UPDATE prd_survey SET svname='" + this.Input_Name.Text + "',is_enabled='" + (this.Input_Enabled.Checked ? "Y" : "N") + "' WHERE svcode='" + _svcode + "'";
}
else
{
dc.CommandText = "INSERT INTO prd_survey (svcode,svname,is_enabled) VALUES ('" + this.Input_Code.Text + "','" + this.Input_Name.Text + "','" + (this.Input_Enabled.Checked ? "Y" : "N") + "')";
}
dc.Connection.Open();
dc.ExecuteNonQuery();
dc.Connection.Close();
dc.Connection.Dispose();
this.Page.ClientScript.RegisterStartupScript(this.GetType(), "JSScript", "window.parent.closedialog();", true);
}
}
