C# SQL类代码示例

 public static void Delete(string[] args, bool exit = false)
 {
     if (args.Length == 2) args = (string.Join(" ", args) + " *").Split(" ");
     if (args[1].Trim().ToLower() == "smtp") WriteLog("delete(d) smtp * 删除SMTP数据");
     if (args[1].Trim().ToLower() == "email") WriteLog("delete(d) email * 删除邮箱数据");
     WriteLog("===============================================================================");
     if (args[1].Trim().ToLower() == "smtp") {
         args = string.Join(" ", args, 2, args.Length - 2).Split(' ');
         int len = 0;
         if (args.Length == 1 && args [0] == "*")
             len = new SQL().Delete(SmtpList._).ToExec();
         else
             foreach (string s in args) {
                 string[] ss = s.Split(',');
                 if (ss.Length != 3) continue;
                 len += SmtpListHelper.DeleteByID(ss[0], ss[1].ToInt(25), ss[2]) ? 1 : 0;
             }
         WriteLog("删除影响行数：{0}", len);
         SmtpListHelper.ClearCacheAll();
     } else if (args[1].Trim().ToLower() == "email") {
         args = string.Join(" ", args, 2, args.Length - 2).Split(' ');
         int len = 0;
         if (args.Length == 1 && args [0] == "*")
             len = new SQL().Delete(EmailList._).ToExec();
         else
             foreach (string s in args) len += EmailListHelper.DeleteByID(s) ? 1 : 0;
         WriteLog("删除影响行数：{0}", len);
         EmailListHelper.ClearCacheAll();
     }
     WriteLog("END");
     Input(exit);
 }

        /// --------------------------------------------------------------------------------
        /// <summary>
        /// Performs loading an object marked with the FieldMappingObjectHook attribute.
        /// Loads an object with fields or properties marked with DatabaseObjects.FieldMapping attributes
        /// with the fields from the database.
        /// </summary>
        /// <param name="objObject">
        /// The generic object that does not implement IDatabaseObject
        /// but contains FieldMapping attributes.
        /// </param>
        /// <remarks>
        /// Typically used from within the overridden LoadFields function when loading a generic object normally
        /// marked with the FieldMappingObjectHook attribute.
        /// </remarks>
        /// --------------------------------------------------------------------------------
        public static void LoadFieldsForObject(object objObject, SQL.SQLFieldValues objFields)
        {
            if (objObject == null)
                throw new ArgumentNullException();

            LoadFieldsForObject(objObject, objObject.GetType(), objFields);
        }

        public Exception Create(NumeroControl numControl)
        {
            //using (SqlConnection conn = sql.GetConnection())
            using (SqlConnection conn = new SQL().GetLocalConnection())
            {
                SqlCommand cmd = new SqlCommand(@"UPDATE NumeroControl SET NumControl = @NumControl WHERE AnoCorriente = @Year;", conn);

                cmd.Parameters.AddWithValue("Year", numControl.Year);

                cmd.Parameters.AddWithValue("NumControl", numControl.NumControl);

                conn.Open();

                using (SqlTransaction transaction = conn.BeginTransaction())
                {
                    cmd.Transaction = transaction;

                    try
                    {
                        cmd.ExecuteNonQuery();

                        transaction.Commit();

                        return null;
                    }

                    catch (Exception ex)
                    {
                        transaction.Rollback();

                        return ex;
                    }
                }
            }
        }

 public static bool ModifyMessage(String UserName,String key,String values)
 {
     String commStr = "update Users set " + key + " = '" + values + "' where UserName = '" + UserName + "'";
     SQL sql = new SQL();
     bool f = sql.ExecuteNonQuery(commStr);
     sql.Dispose();
     return f;
 }

 public static bool ModifyMessage(int TopicId, String key, String values)
 {
     String commStr = "update Topic set " + key + " = '" + values + "' where id = " + TopicId;
     SQL sql = new SQL();
     bool f = sql.ExecuteNonQuery(commStr);
     sql.Dispose();
     return f;
 }

 public static String GetTopicAnswer(int TopicId)
 {
     String commStr = "select * from Answer where TopicId = " + TopicId;
     SQL sql = new SQL();
     String ans = sql.ExecuteXml(commStr);
     sql.Dispose();
     return ans;
 }

        public void Should_Return_Simple_Delete_From_Table()
        {
            var expected = "DELETE FROM table";
            var sql = new SQL();
            sql.Delete().From("table");

            Assert.AreEqual(expected, sql.ToString());
        }

 public static bool Register(String UserName,String Password)
 {
     String commStr = "insert into Users values ('" + UserName + "','" + Password + "','','','',0,'')";
     SQL sql = new SQL();
     bool f = sql.ExecuteNonQuery(commStr);
     sql.Dispose();
     return f;
 }

 public static String GetRecommandTopic(String Part)
 {
     String commStr = "select * from Topic where Recommand = 1 and Part in ('" + Part.Substring(0,Part.Length-1).Replace(",","','") + "')";
     SQL sql = new SQL();
     String ans = sql.ExecuteXml(commStr);
     sql.Dispose();
     return ans;
 }

 public static String GetAllRecommandTopic()
 {
     String commStr = "select * from Topic where Recommand = 1";
     SQL sql = new SQL();
     String ans = sql.ExecuteXml(commStr);
     sql.Dispose();
     return ans;
 }

 public static String GetUserTopic(String Author)
 {
     String commStr = "select * from Topic where Author = '" + Author + "'";
     SQL sql = new SQL();
     String ans = sql.ExecuteXml(commStr);
     sql.Dispose();
     return ans;
 }

 public static bool DeleteFocusPart(String UserName, String Part)
 {
     String commStr = "update Users set FocusPart = '" + GetMessage(UserName, "FocusPart").Replace(Part+",","") + "' where UserName = '" + UserName + "'";
     SQL sql = new SQL();
     bool f = sql.ExecuteNonQuery(commStr);
     sql.Dispose();
     return f;
 }

 public static String GetXml(String UserName)
 {
     String commStr = "select UserName,Email,StudentNumber,Major,AccumulatePoint,FocusPart from Users where UserName = '" + UserName + "'";
     SQL sql = new SQL();
     String ans = sql.ExecuteXml(commStr);
     sql.Dispose();
     return ans;
 }

 public static String GetXml(int id)
 {
     String commStr = "select * from Topic where id = " + id;
     SQL sql = new SQL();
     String ans = sql.ExecuteXml(commStr);
     sql.Dispose();
     return ans;
 }

 public static bool AddPoint(String UserName, int Point)
 {
     String commStr = "update Users set AccumulatePoint = " + (int.Parse(GetMessage(UserName, "AccumulatePoint"))+Point) + " where UserName = '" + UserName + "'";
     SQL sql = new SQL();
     bool f = sql.ExecuteNonQuery(commStr);
     sql.Dispose();
     return f;
 }