GG_DPS/DBClass/CreateCommand.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data;

namespace DBClass
{
    public class CreateCommand
    {

        /// <summary>
        /// 根据控件生成Insert的Commond对象，返回新增语句的主键
        /// </summary>
        /// <param name="FormControl">需要组成SQL语句的控件</param>
        /// <param name="Table">表名</param>
        /// <param name="TableId">更新的ID</param>
        /// <param name="db">需要生成Commond的DBHelper</param>
        /// <returns>更新数据的键值</returns>
        public static void GetInsertCommond(Control FormControl, string Table, string TableId, DBClass.DBHelper db)
        {
            string KeyValue = string.Empty;
            StringBuilder FieldString = new StringBuilder();
            StringBuilder ValueString = new StringBuilder();

            foreach (Control ControlItem in FormControl.Controls)
            {
                if (ControlItem.GetType() == typeof(TextBox) || ControlItem.GetType() == typeof(RichTextBox))
                {
                    if (!string.IsNullOrEmpty(ControlItem.Text))
                    {
                        if (ControlItem.Name == TableId)
                        {
                            KeyValue = ControlItem.Text;
                        }
                        FieldString.AppendFormat("{0},", ControlItem.Name);
                        ValueString.AppendFormat("@{0},", ControlItem.Name);
                        db.AddInParameter(string.Format("@{0}", ControlItem.Name), DbType.String, ControlItem.Text);
                    }
                }
            }
            string SQLString = String.Format("Insert into {0} ({1}) values ({2})",
                                                Table,
                                                FieldString.ToString(0, FieldString.Length - 1),
                                                ValueString.ToString(0, ValueString.Length - 1));
            db.SetSqlStringCommond(SQLString);
        }
        
        /// <summary>
        /// 根据控件返回Update的Commond对象
        /// </summary>
        /// <param name="FormControl">需要组成SQL语句的控件</param>
        /// <param name="Table">表名</param>
        /// <param name="TableId">更新的ID</param>
        /// <param name="db">需要生成Commond的DBHelper</param>
        /// <returns>更新数据的键值</returns>
        public static void GetUpdateCommond(Control FormControl, string Table, string TableId, DBClass.DBHelper db)
        {
            string Where = string.Empty;