datasql.cs

介绍学习的管理系统说明什么的

                SqlCommand command = new SqlCommand(Sql, connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@UName", UName);
                command.Parameters.Add("@AIDCard", UIDCard);
                command.Parameters.Add("@APassword", UPassword);
                command.Parameters.Add("@UTelephone", UTelephone);
                command.Parameters.Add("@Movephone", Movephone);
                command.Parameters.Add("@City", City);
                command.Parameters.Add("@County", County);
                command.Parameters.Add("@Town", Town);
                command.Parameters.Add("@Village", Village);
                command.Parameters.Add("@Ulevel", Ulevel);
                connection.Open();
                command.ExecuteNonQuery();
                new SqlCommand("delete Users where UserID=" + del, connection).ExecuteNonQuery();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string addWxznjUse(string Sql, string del, string OrganName, string OCard, string Opassword, string Faren, string ATelephone, string Movephone, string Address, string reaperSum, string reaperFree, string planeSum, string planeFree, string ditchSum, string ditchFree, string transplantSum, string transplantFree, string mass, string model, string bound, string member, string tele, string move, string remavk)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand(Sql, connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@OrganName", OrganName);
                command.Parameters.Add("@OCard", OCard);
                command.Parameters.Add("@Opassword", Opassword);
                command.Parameters.Add("@Faren", Faren);
                command.Parameters.Add("@ATelephone", ATelephone);
                command.Parameters.Add("@Movephone", Movephone);
                command.Parameters.Add("@Address", Address);
                command.Parameters.Add("@reaperSum", reaperSum);
                command.Parameters.Add("@reaperFree", reaperFree);
                command.Parameters.Add("@planeSum", planeSum);
                command.Parameters.Add("@planeFree", planeFree);
                command.Parameters.Add("@ditchSum", ditchSum);
                command.Parameters.Add("@ditchFree", ditchFree);
                command.Parameters.Add("@transplantSum", transplantSum);
                command.Parameters.Add("@transplantFree", transplantFree);
                command.Parameters.Add("@mass", mass);
                command.Parameters.Add("@model", model);
                command.Parameters.Add("@bound", bound);
                command.Parameters.Add("@member", member);
                command.Parameters.Add("@tele", tele);
                command.Parameters.Add("@move", move);
                command.Parameters.Add("@remavk", remavk);
                connection.Open();
                command.ExecuteNonQuery();
                new SqlCommand("delete Organization where OrganID=" + del, connection).ExecuteNonQuery();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string addWxznjUser(string Sql, string del, string AName, string AIDCard, string APassword, string ATelephone, string Movephone, string Address, string reaperSum, string reaperFree, string planeSum, string planeFree, string ditchSum, string ditchFree, string transplantSum, string transplantFree, string mass, string model, string bound, string remavk)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand(Sql, connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@AName", AName);
                command.Parameters.Add("@AIDCard", AIDCard);
                command.Parameters.Add("@APassword", APassword);
                command.Parameters.Add("@ATelephone", ATelephone);
                command.Parameters.Add("@Movephone", Movephone);
                command.Parameters.Add("@Address", Address);
                command.Parameters.Add("@reaperSum", reaperSum);
                command.Parameters.Add("@reaperFree", reaperFree);
                command.Parameters.Add("@planeSum", planeSum);
                command.Parameters.Add("@planeFree", planeFree);
                command.Parameters.Add("@ditchSum", ditchSum);
                command.Parameters.Add("@ditchFree", ditchFree);
                command.Parameters.Add("@transplantSum", transplantSum);
                command.Parameters.Add("@transplantFree", transplantFree);
                command.Parameters.Add("@mass", mass);
                command.Parameters.Add("@model", model);
                command.Parameters.Add("@bound", bound);
                command.Parameters.Add("@remavk", remavk);
                connection.Open();
                command.ExecuteNonQuery();
                new SqlCommand("delete AMachine where OrganID=" + del, connection).ExecuteNonQuery();
                connection.Close();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string del_City(string City)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand("del_City", connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@City", City);
                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string del_Town(string Town)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand("del_Town", connection);
                command.CommandType = CommandType.StoredProcedure;
                command.Parameters.Add("@Town", Town);
                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string delUser(string table, string ziduan, string tiaojie)
        {
            try
            {
                string cmdText = "delete  " + table + "  where " + ziduan + "=@nei";
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand(cmdText, connection);
                command.Parameters.Add("@nei", tiaojie);
                connection.Open();
                command.ExecuteNonQuery();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string Exec(string Sql, Label View, Label View2)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand(Sql, connection);
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                if (reader.Read())
                {
                    View.Text = reader["AName"].ToString();
                    View2.Text = reader["ATelephone"].ToString() + ",手机:" + reader["Amovephone"].ToString();
                }
                reader.Close();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string ExecuteNonQuery(string Sql)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand(Sql, connection);
                connection.Open();
                int num = command.ExecuteNonQuery();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string ExecuteNonQuery(string Sql, DataList View)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand selectCommand = new SqlCommand(Sql, connection);
                SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet);
                View.DataSource = dataSet;
                View.DataBind();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string ExecuteNonQuery(string Sql, GridView View)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand selectCommand = new SqlCommand(Sql, connection);
                SqlDataAdapter adapter = new SqlDataAdapter(selectCommand);
                DataSet dataSet = new DataSet();
                adapter.Fill(dataSet);
                View.DataSource = dataSet;
                View.DataBind();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string ExecuteNonQuery(string Sql, Label View)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand(Sql, connection);
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                if (reader.Read())
                {
                    View.Text = reader.GetValue(1).ToString();
                }
                reader.Close();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string ExecuteNonQuery(string Sql, Label View, Label View2)
        {
            try
            {
                SqlConnection connection = new SqlConnection(this.Sqlconnection);
                SqlCommand command = new SqlCommand(Sql, connection);
                connection.Open();
                SqlDataReader reader = command.ExecuteReader();
                if (reader.Read())
                {
                    View.Text = reader["AName"].ToString();
                    View2.Text = reader["AIDCard"].ToString();
                }
                reader.Close();
                connection.Close();
                return "ok";
            }
            catch (Exception exception)
            {
                return exception.Message.ToString();
            }
        }

        public string JiaoXi(string sql, TextBox tele, Label address)
        {