DAL/Models/Car.cs

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

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

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Data;
using System.Text;
using DBUtility;
using System.Collections;

namespace DAL.Models
{
    public class Car
    {
        public bool EditModelContent(string TableName, Hashtable ht)
        {
            string s = "update " + TableName + " set ";
            List<SqlParameter> p = new List<SqlParameter>();
            int flag = 0;
            foreach (DictionaryEntry de in ht)
            {
                if (flag == 0)
                {
                    s += de.Key.ToString() + "=@" + de.Key.ToString();
                }
                else
                {
                    s += "," + de.Key.ToString() + "=@" + de.Key.ToString();
                }
                flag++;
                p.Add(new SqlParameter("@" + de.Key.ToString(), de.Value.ToString()));
            }
            s += " where infoid=@infoid";
            SqlParameter[] parameters = p.ToArray();
            List<CommandInfo> list = new List<CommandInfo>();
            CommandInfo info2 = new CommandInfo();
            info2.CommandText = s;
            info2.EffentNextType = EffentNextType.ExcuteEffectRows;
            info2.Parameters = parameters;
            list.Add(info2);
            if (DbHelperSQL.ExecuteSqlTran(list) > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        public bool EditContent(string TableName, Hashtable ht)
        {
            string s = "update " + TableName + " set ";
            List<SqlParameter> p = new List<SqlParameter>();
            int flag = 0;
            foreach (DictionaryEntry de in ht)
            {
                if (de.Key.ToString().ToLower() != "infoid")
                {
                    if (flag == 0)
                    {
                        s += de.Key.ToString() + "=@" + de.Key.ToString();