开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > SilverLight > 查看源码
UserManage.asmx.cs
资源名称：SFGS_siliverlight.rar　[点击查看]
上传用户：jxqhsy
上传日期：2020-12-31
资源大小：1793k
文件大小：35k
源码类别：

SilverLight

开发平台：

HTML/CSS

UserManage.asmx.cs：源码内容
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.Services;
  6. using System.Data.SqlClient;
  7. using System.Configuration;
  8. using System.Text;
  10. namespace SFGS.Web
  11. {
  12.     /// <summary>
  13.     /// UserManage 的摘要说明
  14.     /// </summary>
  15.     [WebService(Namespace = "http://tempuri.org/")]
  16.     [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
  17.     [System.ComponentModel.ToolboxItem(false)]
  18.     // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
  19.     // [System.Web.Script.Services.ScriptService]
  20.     public class UserManage : System.Web.Services.WebService
  21.     {
  22.         /// <summary>
  23.         /// 创建管理员用户
  24.         /// </summary>
  25.         /// <param name="userName"></param>
  26.         /// <param name="userPwd"></param>
  27.         /// <param name="beizhu"></param>
  28.         /// <returns></returns>
  29.         [WebMethod]
  30.         public bool AddUser(string userName, string userPwd, string beizhu)
  31.         {
  32.             try
  33.             {
  34.                 int count = 0;
  35.                 DAL.DBHelper db = new DAL.DBHelper();
  36.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Admin where UserName='" + userName.ToString().Replace("'", "''") + "'");
  37.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  38.                 while (dr.Read() == true)
  39.                 {
  40.                     count++;
  41.                 }
  42.                 dr.Close();
  43.                 dr.Dispose();
  44.                 cmd.Dispose();
  45.                 if (count > 0) return false;//如果已存用户返回false;
  47.                 cmd = db.GetSqlStringCommond(
  48.                     "INSERT INTO Admin VALUES ('" +
  49.                     userName.ToString().Replace("'", "''") + "','" +
  50.                     userPwd.ToString().Replace("'", "''") + "','" +
  51.                     beizhu.ToString().Replace("'", "''") + "')");
  52.                 db.ExecuteNonQuery(cmd);
  53.                 db.Close();
  54.                 cmd.Dispose();
  55.                 return true;
  56.             }
  57.             catch (Exception ex)
  58.             {
  59.                 return false;
  60.             }
  62.         }
  64.         /// <summary>
  65.         /// 管理员登录
  66.         /// </summary>
  67.         /// <returns></returns>
  68.         [WebMethod]
  69.         public bool LoginAdmin(string userName, string userPwd)
  70.         {
  71.             try
  72.             {
  73.                 int count = 0;
  74.                 DAL.DBHelper db = new DAL.DBHelper();
  75.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Admin where UserName='" + userName.ToString().Replace("'", "''") + "' AND PassWord='" + userPwd.ToString().Replace("'", "''") + "'");
  76.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  77.                 while (dr.Read() == true)
  78.                 {
  79.                     count++;
  80.                 }
  81.                 if (count > 0)
  82.                 {
  83.                     return true;
  84.                 }
  85.                 else
  86.                 {
  87.                     return false;
  88.                 }
  89.                 dr.Close();
  90.                 dr.Dispose();
  91.                 db.Close();
  92.                 cmd.Dispose();
  93.             }
  94.             catch (Exception ex)
  95.             {
  96.                 return false;
  97.             }
  99.         }
  101.         /// <summary>
  102.         /// 更新用户表
  103.         /// </summary>
  104.         /// <param name="userName"></param>
  105.         /// <param name="userPwd"></param>
  106.         /// <returns></returns>
  107.         [WebMethod]
  108.         public bool UpdateUser(string userName, string userPwd)
  109.         {
  110.             try
  111.             {
  112.                 int count = 0;
  113.                 DAL.DBHelper db = new DAL.DBHelper();
  114.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Admin where UserName='" + userName.ToString().Replace("'", "''") + "'");
  115.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  116.                 while (dr.Read() == true)
  117.                 {
  118.                     count++;
  119.                 }
  120.                 dr.Close();
  121.                 dr.Dispose();
  122.                 cmd.Dispose();
  123.                 if (count <= 0) return false;//如果用户不存在则返回false;
  125.                 cmd = db.GetSqlStringCommond("update admin set PassWord='" + userPwd.ToString().Replace("'", "''") + "' where UserName='" + userName.ToString().Replace("'", "''") + "'");
  126.                 int number = db.ExecuteNonQuery(cmd);
  127.                 db.Close();
  128.                 cmd.Dispose();
  129.                 if (number > 0)
  130.                     return true;
  131.                 else
  132.                     return false;
  133.             }
  134.             catch (System.Exception ex)
  135.             {
  136.                 return false;
  137.             }
  138.         }
  140.         /// <summary>
  141.         /// 删除指定用户
  142.         /// </summary>
  143.         /// <param name="userName"></param>
  144.         /// <returns></returns>
  145.         [WebMethod]
  146.         public bool DeleteUser(string userName)
  147.         {
  148.             try
  149.             {
  150.                 int count = 0;
  151.                 DAL.DBHelper db = new DAL.DBHelper();
  152.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Admin where UserName='" + userName.ToString().Replace("'", "''") + "'");
  153.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  154.                 while (dr.Read() == true)
  155.                 {
  156.                     count++;
  157.                 }
  158.                 dr.Close();
  159.                 dr.Dispose();
  160.                 cmd.Dispose();
  161.                 if (count <= 0) return false;//如果用户不存在则返回false;
  163.                 cmd = db.GetSqlStringCommond("delete from Admin where UserName='" + userName.ToString().Replace("'", "''") + "'");
  164.                 int number = db.ExecuteNonQuery(cmd);
  165.                 db.Close();
  166.                 cmd.Dispose();
  167.                 if (number > 0)
  168.                     return true;
  169.                 else
  170.                     return false;
  171.             }
  172.             catch (System.Exception ex)
  173.             {
  174.                 return false;
  175.             }
  176.         }
  178.         /// <summary>
  179.         /// 更新题目表
  180.         /// </summary>
  181.         /// <param name="ID"></param>
  182.         /// <param name="SurveyID"></param>
  183.         /// <param name="text"></param>
  184.         /// <param name="OptionA"></param>
  185.         /// <param name="OptionB"></param>
  186.         /// <param name="OptionC"></param>
  187.         /// <param name="OptionD"></param>
  188.         /// <returns></returns>
  189.         [WebMethod]
  190.         public bool UpdateQuestion(string ID, string SurveyID, string text, string OptionA, string OptionB, string OptionC, string OptionD)
  191.         {
  192.             try
  193.             {
  194.                 int count = 0;
  195.                 DAL.DBHelper db = new DAL.DBHelper();
  196.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Question where ID=" + ID.ToString().Replace("'", "''"));
  197.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  198.                 while (dr.Read() == true)
  199.                 {
  200.                     count++;
  201.                 }
  202.                 dr.Close();
  203.                 dr.Dispose();
  204.                 cmd.Dispose();
  205.                 if (count <= 0) return false;//如果问题不存在返回false;
  207.                 cmd = db.GetSqlStringCommond("update Question set " +
  208.                                              "SurveyID=" + SurveyID.ToString().Replace("'", "''") + "," +
  209.                                              "Text='" + text.ToString().Replace("'", "''") + "'," +
  210.                                              "OptionA='" + OptionA.ToString().Replace("'", "''") + "'," +
  211.                                              "OptionB='" + OptionB.ToString().Replace("'", "''") + "'," +
  212.                                              "OptionC='" + OptionC.ToString().Replace("'", "''") + "'," +
  213.                                              "OptionD='" + OptionD.ToString().Replace("'", "''") + "' " +
  214.                                              "where ID=" + ID.ToString().Replace("'", "''")
  215.                                              );
  216.                 int number = db.ExecuteNonQuery(cmd);
  217.                 db.Close();
  218.                 cmd.Dispose();
  219.                 if (number > 0)
  220.                     return true;
  221.                 else
  222.                     return false;
  224.             }
  225.             catch (System.Exception ex)
  226.             {
  227.                 return false;
  228.             }
  230.         }
  232.         /// <summary>
  233.         /// 添加新问题
  234.         /// </summary>
  235.         /// <param name="SurveyID"></param>
  236.         /// <param name="text"></param>
  237.         /// <param name="OptionA"></param>
  238.         /// <param name="OptionB"></param>
  239.         /// <param name="OptionC"></param>
  240.         /// <param name="OptionD"></param>
  241.         /// <returns></returns>
  242.         [WebMethod]
  243.         public bool AddQuestion(string SurveyID, string text, string OptionA, string OptionB, string OptionC, string OptionD)
  244.         {
  245.             try
  246.             {
  247.                 int count = 0;
  248.                 DAL.DBHelper db = new DAL.DBHelper();
  249.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Survey where ID=" + SurveyID.ToString().Replace("'", "''"));
  250.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  251.                 while (dr.Read() == true)
  252.                 {
  253.                     count++;
  254.                 }
  255.                 dr.Close();
  256.                 dr.Dispose();
  257.                 dr = null;
  258.                 cmd.Dispose();
  259.                 if (count <= 0) return false;//如果调查表中不存在ID为SurveyID的记录则返回false;
  261.                 count = 0;
  262.                 cmd = db.GetSqlStringCommond("select * from Question where SurveyID=" + SurveyID.ToString().Replace("'", "''") + " and Text='" + text.ToString().Replace("'", "''") + "'");
  263.                 dr = db.ExecuteReader(cmd);
  264.                 while (dr.Read() == true)
  265.                 {
  266.                     count++;
  267.                 }
  268.                 dr.Close();
  269.                 dr.Dispose();
  270.                 cmd.Dispose();
  271.                 if (count > 0) return false;//如果问题已存在则返回false;
  273.                 cmd = db.GetSqlStringCommond("insert into Question values(" +
  274.                                               SurveyID.ToString().Replace("'", "''") + ",'" +
  275.                                               text.ToString().Replace("'", "''") + "','" +
  276.                                               OptionA.ToString().Replace("'", "''") + "','" +
  277.                                               OptionB.ToString().Replace("'", "''") + "','" +
  278.                                               OptionC.ToString().Replace("'", "''") + "','" +
  279.                                               OptionD.ToString().Replace("'", "''") + "')");
  280.                 int number = db.ExecuteNonQuery(cmd);
  281.                 db.Close();
  282.                 cmd.Dispose();
  283.                 if (number > 0)
  284.                     return true;
  285.                 else
  286.                     return false;
  287.             }
  288.             catch (System.Exception ex)
  289.             {
  290.                 return false;
  291.             }
  292.         }
  294.         /// <summary>
  295.         /// 删除指定题目
  296.         /// </summary>
  297.         /// <param name="ID"></param>
  298.         /// <returns></returns>
  299.         [WebMethod]
  300.         public bool DeleteQuestion(string ID)
  301.         {
  302.             try
  303.             {
  304.                 int count = 0;
  305.                 DAL.DBHelper db = new DAL.DBHelper();
  306.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Question where ID=" + ID.ToString().Replace("'", "''"));
  307.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  308.                 while (dr.Read() == true)
  309.                 {
  310.                     count++;
  311.                 }
  312.                 dr.Close();
  313.                 dr.Dispose();
  314.                 dr = null;
  315.                 cmd.Dispose();
  316.                 if (count <= 0) return false;//如果调查表中不存在ID为SurveyID的记录则返回false;
  318.                 cmd = db.GetSqlStringCommond("delete from Question where ID=" + ID.ToString().Replace("'", "''"));
  319.                 int number = db.ExecuteNonQuery(cmd);
  320.                 db.Close();
  321.                 cmd.Dispose();
  322.                 if (number > 0)
  323.                     return true;
  324.                 else
  325.                     return false;
  326.             }
  327.             catch (System.Exception ex)
  328.             {
  329.                 return false;
  330.             }
  332.         }
  334.         /// <summary>
  335.         /// 读取指定调查的问题
  336.         /// </summary>
  337.         /// <param name="SurveyID"></param>
  338.         /// <returns></returns>
  339.         [WebMethod]
  340.         public string ReadQuestion(string SurveyID)
  341.         {
  342.             try
  343.             {
  344.                 int count = 0;
  345.                 DAL.DBHelper db = new DAL.DBHelper();
  346.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Question where SurveyID=" + SurveyID.ToString().Replace("'", "''"));
  347.                 System.Data.DataSet ds = db.ExecuteDataSet(cmd);
  348.                 if (ds.Tables[0].Rows.Count <= 0)
  349.                 {
  350.                     return "";
  351.                 }
  353.                 System.Text.StringBuilder sb = new StringBuilder();
  354.                 sb.Append("<?xml version="1.0" encoding="utf-8" ?>");
  355.                 sb.Append("<Questions>");
  356.                 foreach (System.Data.DataRow dr in ds.Tables[0].Rows)
  357.                 {
  358.                     sb.Append("<Question>");
  359.                     sb.Append("<ID>");
  360.                     sb.Append(dr["ID"].ToString());
  361.                     sb.Append("</ID>");
  362.                     sb.Append("<SurveyID>");
  363.                     sb.Append(dr["SurveyID"].ToString());
  364.                     sb.Append("</SurveyID>");
  365.                     sb.Append("<Text>");
  366.                     sb.Append(dr["Text"].ToString());
  367.                     sb.Append("</Text>");
  368.                     sb.Append("<OptionA>");
  369.                     sb.Append(dr["OptionA"].ToString());
  370.                     sb.Append("</OptionA>");
  371.                     sb.Append("<OptionB>");
  372.                     sb.Append(dr["OptionB"].ToString());
  373.                     sb.Append("</OptionB>");
  374.                     sb.Append("<OptionC>");
  375.                     sb.Append(dr["OptionC"].ToString());
  376.                     sb.Append("</OptionC>");
  377.                     sb.Append("<OptionD>");
  378.                     sb.Append(dr["OptionD"].ToString());
  379.                     sb.Append("</OptionD>");
  380.                     sb.Append("</Question>");
  382.                 }
  383.                 sb.Append("</Questions>");
  385.                 ds.Dispose();
  386.                 cmd.Dispose();
  387.                 db.Close();
  389.                 return sb.ToString();
  390.             }
  391.             catch (System.Exception ex)
  392.             {
  393.                 return "";
  394.             }
  395.         }
  397.         /// <summary>
  398.         /// 更新指定ID的调查表
  399.         /// </summary>
  400.         /// <param name="ID"></param>
  401.         /// <param name="Name"></param>
  402.         /// <param name="Description"></param>
  403.         /// <param name="Date"></param>
  404.         /// <param name="IsCurrentSurvey"></param>
  405.         /// <returns></returns>
  406.         [WebMethod]
  407.         public bool UpdateSurvey(string ID, string Name, string Description, string Date, string IsCurrentSurvey)
  408.         {
  409.             try
  410.             {
  411.                 int count = 0;
  412.                 DAL.DBHelper db = new DAL.DBHelper();
  413.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Survey where ID=" + ID.ToString().Replace("'", "''"));
  414.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  415.                 while (dr.Read() == true)
  416.                 {
  417.                     count++;
  418.                 }
  419.                 dr.Close();
  420.                 dr.Dispose();
  421.                 cmd.Dispose();
  422.                 cmd = null;
  423.                 if (count <= 0) return false;
  425.                 cmd = db.GetSqlStringCommond("update Survey set " +
  426.                                                "Name='" + Name.ToString().Replace("'", "''") + "'," +
  427.                                                "Description='" + Description.ToString().Replace("'", "''") + "'," +
  428.                                                "Date='" + Date.ToString().Replace("'", "''") + "'," +
  429.                                                "IsCurrentSurvey='" + IsCurrentSurvey.ToString().Replace("'", "''") + "'" +
  430.                                                " where ID=" + ID.ToString().Replace("'", "''"));
  431.                 int number = db.ExecuteNonQuery(cmd);
  432.                 if (number > 0)
  433.                     return true;
  434.                 else
  435.                     return false;
  436.             }
  437.             catch (System.Exception ex)
  438.             {
  439.                 return false;
  440.             }
  441.         }
  443.         /// <summary>
  444.         /// 添加新的调查
  445.         /// </summary>
  446.         /// <param name="Name"></param>
  447.         /// <param name="Description"></param>
  448.         /// <param name="Date"></param>
  449.         /// <param name="IsCurrentSurvey"></param>
  450.         /// <returns></returns>
  451.         [WebMethod]
  452.         public bool AddSurvey(string Name, string Description, string Date, string IsCurrentSurvey)
  453.         {
  454.             try
  455.             {
  456.                 int count = 0;
  457.                 DAL.DBHelper db = new DAL.DBHelper();
  458.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Survey where Name='" + Name.ToString().Replace("'", "''") + "'");
  459.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  460.                 while (dr.Read() == true)
  461.                 {
  462.                     count++;
  463.                 }
  464.                 dr.Close();
  465.                 dr.Dispose();
  466.                 cmd.Dispose();
  467.                 cmd = null;
  468.                 if (count > 0) return false;//如果该记录已经存在
  470.                 cmd = db.GetSqlStringCommond("insert into Survey values(" +
  471.                                              "'" + Name.ToString().Replace("'", "''") + "'," +
  472.                                              "'" + Description.ToString().Replace("'", "''") + "'," +
  473.                                              "'" + Date.ToString().Replace("'", "''") + "'," +
  474.                                              "'" + IsCurrentSurvey.ToString().Replace("'", "''") + "')" +
  475.                                              "");
  476.                 int number = db.ExecuteNonQuery(cmd);
  477.                 db.Close();
  478.                 cmd.Dispose();
  479.                 if (number > 0)
  480.                     return true;
  481.                 else
  482.                     return false;
  483.             }
  484.             catch (System.Exception ex)
  485.             {
  486.                 return false;
  487.             }
  488.         }
  490.         /// <summary>
  491.         /// 删除指定ID的调查记录，及其关联的题目记录
  492.         /// </summary>
  493.         /// <param name="ID"></param>
  494.         /// <returns></returns>
  495.         [WebMethod]
  496.         public bool DeleteSurvey(string ID)
  497.         {
  498.             try
  499.             {
  500.                 int count = 0;
  501.                 DAL.DBHelper db = new DAL.DBHelper();
  502.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Survey where ID=" + ID.ToString().Replace("'", "''"));
  503.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  504.                 while (dr.Read() == true)
  505.                 {
  506.                     count++;
  507.                 }
  508.                 dr.Close();
  509.                 dr.Dispose();
  510.                 cmd.Dispose();
  511.                 cmd = null;
  512.                 if (count <= 0) return false;
  514.                 cmd = db.GetSqlStringCommond("delete from Survey where ID=" + ID.ToString().Replace("'", "''"));
  515.                 int number1 = db.ExecuteNonQuery(cmd);
  516.                 cmd.Dispose();
  518.                 cmd = db.GetSqlStringCommond("delete from Question where SurveyID=" + ID.ToString().Replace("'", "''"));
  519.                 int number2 = db.ExecuteNonQuery(cmd);
  520.                 db.Close();
  521.                 cmd.Dispose();
  523.                 if (number1 > 0 || number2 > 0)
  524.                 {
  525.                     return true;
  526.                 }
  527.                 else
  528.                 {
  529.                     return false;
  530.                 }
  531.             }
  532.             catch (System.Exception ex)
  533.             {
  534.                 return false;
  535.             }
  536.         }
  538.         /// <summary>
  539.         /// 取指定ID的调查
  540.         /// </summary>
  541.         /// <param name="ID"></param>
  542.         /// <returns></returns>
  543.         [WebMethod]
  544.         public string ReadSurvey(string ID)
  545.         {
  546.             try
  547.             {
  548.                 int count = 0;
  549.                 DAL.DBHelper db = new DAL.DBHelper();
  550.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Survey where ID=" + ID.ToString().Replace("'", "''"));
  551.                 System.Data.DataSet ds = db.ExecuteDataSet(cmd);
  552.                 if (ds.Tables[0].Rows.Count <= 0)
  553.                 {
  554.                     return "";
  555.                 }
  557.                 System.Text.StringBuilder sb = new StringBuilder();
  558.                 sb.Append("<?xml version="1.0" encoding="utf-8" ?>");
  559.                 sb.Append("<Surveys>");
  560.                 foreach (System.Data.DataRow dr in ds.Tables[0].Rows)
  561.                 {
  562.                     sb.Append("<Survey>");
  563.                     sb.Append("<ID>");
  564.                     sb.Append(dr["ID"].ToString());
  565.                     sb.Append("</ID>");
  566.                     sb.Append("<Name>");
  567.                     sb.Append(dr["Name"].ToString());
  568.                     sb.Append("</Name>");
  569.                     sb.Append("<Description>");
  570.                     sb.Append(dr["Description"].ToString());
  571.                     sb.Append("</Description>");
  572.                     sb.Append("<Date>");
  573.                     sb.Append(dr["Date"].ToString());
  574.                     sb.Append("</Date>");
  575.                     sb.Append("<IsCurrentSurvey>");
  576.                     sb.Append(dr["IsCurrentSurvey"].ToString());
  577.                     sb.Append("</IsCurrentSurvey>");
  578.                     sb.Append("</Survey>");
  579.                 }
  580.                 sb.Append("</Surveys>");
  582.                 ds.Dispose();
  583.                 cmd.Dispose();
  584.                 db.Close();
  586.                 return sb.ToString();
  587.             }
  588.             catch (System.Exception ex)
  589.             {
  590.                 return "";
  591.             }
  592.         }
  594.         /// <summary>
  595.         /// 取指定ID的调查
  596.         /// </summary>
  597.         /// <param name="ID"></param>
  598.         /// <returns></returns>
  599.         [WebMethod]
  600.         public string ReadAllSurvey()
  601.         {
  602.             try
  603.             {
  604.                 int count = 0;
  605.                 string response = "";
  606.                 DAL.DBHelper db = new DAL.DBHelper();
  607.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Survey");
  608.                 System.Data.DataSet ds = db.ExecuteDataSet(cmd);
  609.                 if (ds.Tables[0].Rows.Count <= 0)
  610.                 {
  611.                     return "";
  612.                 }
  614.                 System.Text.StringBuilder sb = new StringBuilder();
  615.                 sb.Append("<?xml version="1.0" encoding="utf-8" ?>");
  616.                 sb.Append("<Surveys>");
  617.                 foreach (System.Data.DataRow dr in ds.Tables[0].Rows)
  618.                 {
  619.                     cmd = db.GetSqlStringCommond("select count(*) from Response where QuestionID =(select TOP 1 ID from Question where SurveyID =" + dr["ID"].ToString() + ")");
  620.                     System.Data.DataSet ds1= db.ExecuteDataSet(cmd);
  621.                     if (ds1.Tables[0].Rows.Count<=0)
  622.                     {
  623.                         response = "0";
  624.                     }
  625.                     else
  626.                     {
  627.                         response = ds1.Tables[0].Rows[0][0].ToString();
  628.                     }
  631.                     sb.Append("<Survey>");
  632.                     sb.Append("<ID>");
  633.                     sb.Append(dr["ID"].ToString());
  634.                     sb.Append("</ID>");
  635.                     sb.Append("<Name>");
  636.                     sb.Append(dr["Name"].ToString());
  637.                     sb.Append("</Name>");
  638.                     sb.Append("<Description>");
  639.                     sb.Append(dr["Description"].ToString());
  640.                     sb.Append("</Description>");
  641.                     sb.Append("<Responses>");
  642.                     sb.Append(response);
  643.                     sb.Append("</Responses>");
  644.                     sb.Append("<Date>");
  645.                     sb.Append(dr["Date"].ToString());
  646.                     sb.Append("</Date>");
  647.                     sb.Append("<IsCurrentSurvey>");
  648.                     sb.Append(dr["IsCurrentSurvey"].ToString());
  649.                     sb.Append("</IsCurrentSurvey>");
  650.                     sb.Append("</Survey>");
  651.                 }
  652.                 sb.Append("</Surveys>");
  654.                 ds.Dispose();
  655.                 cmd.Dispose();
  656.                 db.Close();
  658.                 return sb.ToString();
  659.             }
  660.             catch (System.Exception ex)
  661.             {
  662.                 return "";
  663.             }
  664.         }
  666.         [WebMethod]
  667.         public bool UpdateResponse()
  668.         {
  669.             return false;
  670.         }
  672.         /// <summary>
  673.         /// 添加记录
  674.         /// </summary>
  675.         /// <param name="QuestionID"></param>
  676.         /// <param name="Selection"></param>
  677.         /// <returns></returns>
  678.         [WebMethod]
  679.         public bool AddResponse(string QuestionID, string Selection)
  680.         {
  681.             try
  682.             {
  683.                 int count = 0;
  684.                 DAL.DBHelper db = new DAL.DBHelper();
  685.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Question where ID=" + QuestionID.ToString());
  686.                 System.Data.Common.DbDataReader dr = db.ExecuteReader(cmd);
  687.                 while (dr.Read() == true)
  688.                 {
  689.                     count++;
  690.                 }
  691.                 dr.Close();
  692.                 dr.Dispose();
  693.                 cmd.Dispose();
  694.                 cmd = null;
  695.                 if (count <= 0) return false;
  697.                 cmd = db.GetSqlStringCommond("insert into Response values(" +
  698.                                                                           QuestionID.ToString() + ",'" +
  699.                                                                           Selection.ToString().Replace("'", "''") +
  700.                                                                           "')");
  701.                 int number = db.ExecuteNonQuery(cmd);
  702.                 db.Close();
  703.                 cmd.Dispose();
  704.                 if (number > 0) return true;
  705.                 else return false;
  706.             }
  707.             catch (System.Exception ex)
  708.             {
  709.                 return false;
  710.             }
  711.         }
  713.         /// <summary>
  714.         /// 删除指定ID的记录
  715.         /// </summary>
  716.         /// <param name="ID"></param>
  717.         /// <returns></returns>
  718.         [WebMethod]
  719.         public bool DeleteResponse(string ID)
  720.         {
  721.             try
  722.             {
  723.                 DAL.DBHelper db = new DAL.DBHelper();
  724.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("delete from Response where ID=" + ID.ToString());
  725.                 int number = db.ExecuteNonQuery(cmd);
  726.                 db.Close();
  727.                 cmd.Dispose();
  728.                 if (number > 0) return true;
  729.                 else return false;
  730.             }
  731.             catch (System.Exception ex)
  732.             {
  733.                 return false;
  734.             }
  735.         }
  737.         [WebMethod]
  738.         public string PercentResponse(string SurveyID)
  739.         {
  740.             try
  741.             {
  742.                 DAL.DBHelper db = new DAL.DBHelper();
  743.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select * from Question where SurveyID=" + SurveyID.ToString());
  744.                 System.Data.DataSet ds = db.ExecuteDataSet(cmd);
  745.                 if (ds.Tables[0].Rows.Count <= 0)
  746.                 {
  747.                     return "";//如果没有找到，则返回空
  748.                 }
  750.                 System.Text.StringBuilder sb = new StringBuilder();
  751.                 sb.Append("<?xml version="1.0" encoding="utf-8" ?>");
  752.                 sb.Append("<Percents>");
  753.                 foreach (System.Data.DataRow dr in ds.Tables[0].Rows)
  754.                 {
  755.                     int count = 0;
  756.                     int countA = 0;
  757.                     int countB = 0;
  758.                     int countC = 0;
  759.                     int countD = 0;
  760.                     System.Data.DataSet tmpDs;
  762.                     sb.Append("<Percent>");
  763.                     sb.Append("<ID>");
  764.                     sb.Append(dr["ID"].ToString());
  765.                     sb.Append("</ID>");
  767.                     cmd = db.GetSqlStringCommond("select * from Response where QuestionID=" + dr["ID"].ToString());
  768.                     tmpDs = db.ExecuteDataSet(cmd);
  769.                     count = tmpDs.Tables[0].Rows.Count;
  771.                     if (count <= 0)
  772.                     {
  773.                         sb.Append("<A>0</A><B>0</B><C>0</C><D>0</D>");
  774.                     }
  775.                     else
  776.                     {
  777.                         cmd = db.GetSqlStringCommond("select * from Response where QuestionID=" + dr["ID"].ToString() + " and (Selection='a' or Selection='A')");
  778.                         tmpDs = db.ExecuteDataSet(cmd);
  779.                         countA = tmpDs.Tables[0].Rows.Count;
  781.                         cmd = db.GetSqlStringCommond("select * from Response where QuestionID=" + dr["ID"].ToString() + " and (Selection='b' or Selection='B')");
  782.                         tmpDs = db.ExecuteDataSet(cmd);
  783.                         countB = tmpDs.Tables[0].Rows.Count;
  785.                         cmd = db.GetSqlStringCommond("select * from Response where QuestionID=" + dr["ID"].ToString() + " and (Selection='c' or Selection='C')");
  786.                         tmpDs = db.ExecuteDataSet(cmd);
  787.                         countC = tmpDs.Tables[0].Rows.Count;
  789.                         cmd = db.GetSqlStringCommond("select * from Response where QuestionID=" + dr["ID"].ToString() + " and (Selection='d' or Selection='D')");
  790.                         tmpDs = db.ExecuteDataSet(cmd);
  791.                         countD = tmpDs.Tables[0].Rows.Count;
  793.                         sb.Append("<A>");
  794.                         sb.Append(Convert.ToString((float)countA / count * 100));
  795.                         sb.Append("</A>");
  796.                         sb.Append("<B>");
  797.                         sb.Append(Convert.ToString((float)countB / count * 100));
  798.                         sb.Append("</B>");
  799.                         sb.Append("<C>");
  800.                         sb.Append(Convert.ToString((float)countC / count * 100));
  801.                         sb.Append("</C>");
  802.                         sb.Append("<D>");
  803.                         sb.Append(Convert.ToString((float)countD / count * 100));
  804.                         sb.Append("</D>");
  805.                     }
  806.                     sb.Append("</Percent>");
  807.                 }
  808.                 sb.Append("</Percents>");
  810.                 return sb.ToString();
  811.             }
  812.             catch (System.Exception ex)
  813.             {
  814.                 return "";
  815.             }
  816.         }
  818.         /// <summary>
  819.         /// 读当前调查名
  820.         /// </summary>
  821.         /// <returns></returns>
  822.         [WebMethod]
  823.         public string ReadCurrentSurvey()
  824.         {
  825.             try
  826.             {
  827.                 DAL.DBHelper db = new DAL.DBHelper();
  828.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select TOP 1 Name from Survey where IsCurrentSurvey='1'");
  829.                 System.Data.DataSet ds = db.ExecuteDataSet(cmd);
  830.                 if (ds.Tables[0].Rows.Count<=0)
  831.                 {
  832.                     return "";
  833.                 }
  835.                 return ds.Tables[0].Rows[0]["Name"].ToString();
  837.             }
  838.             catch (System.Exception ex)
  839.             {
  840.                 return "";
  841.             }            
  842.         }
  844.         /// <summary>
  845.         /// 根据调查标题设置当前调查
  846.         /// </summary>
  847.         /// <param name="Name"></param>
  848.         /// <returns></returns>
  849.         [WebMethod]
  850.         public bool WriteCurrentSurvey(string Name)
  851.         {
  852.             try
  853.             {
  854.                 DAL.DBHelper db = new DAL.DBHelper();
  855.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("update Survey set IsCurrentSurvey='0'");
  856.                 db.ExecuteNonQuery(cmd);
  858.                 cmd = db.GetSqlStringCommond("update Survey set IsCurrentSurvey='1' where Name='" + Name.ToString().Replace("'", "''") + "'");
  859.                 int number=db.ExecuteNonQuery(cmd);
  860.                 cmd.Dispose();
  861.                 db.Close();
  862.                 if (number>0)
  863.                 {
  864.                     return true;
  865.                 }
  866.                 else
  867.                 {
  868.                     return false;
  869.                 }
  870.             }
  871.             catch (System.Exception ex)
  872.             {
  873.                 return false;
  874.             }
  875.         }
  877.         /// <summary>
  878.         /// 联系我们
  879.         /// </summary>
  880.         /// <param name="userName"></param>
  881.         /// <param name="userPwd"></param>
  882.         /// <param name="beizhu"></param>
  883.         /// <returns></returns>
  884.         [WebMethod]
  885.         public bool ContactUS(string name, string age, string query)
  886.         {
  887.             try
  888.             {
  889.                 int count = 0;
  890.                 DAL.DBHelper db = new DAL.DBHelper();
  891.                 System.Data.Common.DbCommand cmd = null;
  893.                 if (count > 0) return false;//如果已存用户返回false;
  895.                 cmd = db.GetSqlStringCommond(
  896.                     "INSERT INTO ContactUS VALUES ('" +
  897.                     name.ToString().Replace("'", "''") + "','" +
  898.                     age.ToString().Replace("'", "''") + "','" +
  899.                     query.ToString().Replace("'", "''") + "')");
  900.                 int i = db.ExecuteNonQuery(cmd);
  901.                 db.Close();
  902.                 cmd.Dispose();
  903.                 return true;
  904.             }
  905.             catch (Exception ex)
  906.             {
  907.                 return false;
  908.             }
  910.         }
  912.         [WebMethod]
  913.         public string ReadMaxSurvey()
  914.         {
  915.             try
  916.             {
  917.                 int count = 0;
  918.                 DAL.DBHelper db = new DAL.DBHelper();
  919.                 System.Data.Common.DbCommand cmd = db.GetSqlStringCommond("select max(id) as id from Survey");
  920.                 System.Data.DataSet ds = db.ExecuteDataSet(cmd);
  921.                 if (ds.Tables[0].Rows.Count < 1)
  922.                 {
  923.                     return "";
  924.                 }
  925.                 ds.Dispose();
  926.                 cmd.Dispose();
  927.                 db.Close();
  928.                 string id = "";
  929.                 try
  930.                 {
  931.                     id = ds.Tables[0].Rows[0]["id"].ToString();
  932.                 }
  933.                 catch
  934.                 {
  935.                     return "";
  936.                 }
  937.                 return id;
  938.             }
  939.             catch (System.Exception ex)
  940.             {
  941.                 return "false";
  942.             }
  943.         } 
  945.     }
  946. }