insertstatement.cs

来自「教师管理系统,登陆上去后可以在系统中对教师资料等等做管理」· CS 代码 · 共 76 行

using System;
using System.Collections.Generic;
using System.Text;

namespace rsgl.baseClass1
{
     public class insertStatement
    {
        private string tableName;
        
        public insertStatement()
        {
            
        }
        public insertStatement(string tableName)
        {
            
            this.tableName = tableName;
        }

        public string insertSql(string[] columnValues, string[] dataTypes)
        {
            StringBuilder insertsql = new StringBuilder("insert into ");
            insertsql.Append(tableName + " values(");
            for (int i = 0; i < columnValues.Length; i++)
            {
                if (dataTypes[i] == "char" || dataTypes[i] == "varChar" || dataTypes[i] == "dateTime")
                {
                    insertsql.Append("'" + columnValues[i] + "',");
                }
                else
                {
                    insertsql.Append(columnValues[i] + ",");
                }
            }
            insertsql.Remove(insertsql.Length - 1, 1);
            insertsql.Append(")");
            return insertsql.ToString();
        }
        public string insertSql(tableInfo[] tableinfos)
        {
            StringBuilder insertsql = new StringBuilder("insert into ");
            insertsql.Append(tableName + "(");
            for(int i=0;i<tableinfos.Length;i++)
            {
                insertsql.Append(tableinfos[i].ColumnName+",");
            }
            insertsql.Remove(insertsql.Length - 1, 1);
            insertsql.Append(")" + " values(");
            for (int i = 0; i < tableinfos.Length; i++)
            {
                if (tableinfos[i].ColumnType == "char" || tableinfos[i].ColumnType == "varChar" || tableinfos[i].ColumnType == "dateTime")
                {
                    insertsql.Append("'" + tableinfos[i].ColumnValue + "',");
                }
                else
                {
                    insertsql.Append(tableinfos[i].ColumnValue + ",");
                }
            }
            insertsql.Remove(insertsql.Length - 1, 1);
            insertsql.Append(")");
            return insertsql.ToString();

        }

        public string insertSql(string selectsql)
        {
            StringBuilder insertsql = new StringBuilder("insert into ");
            insertsql.Append(tableName);
            insertsql.Append(selectsql);
            return insertsql.ToString();
        }
    }
}