updatestatement.cs

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

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

namespace rsgl.baseClass1
{
    public class updateStatement
    {
        private string tableName;
        private whereStatement wherestatement;
        public updateStatement()
        {
            wherestatement = new whereStatement();
        }
        public updateStatement(string tableName)
        {
            this.tableName = tableName;
            wherestatement = new whereStatement();
        }
        public string updateSql(string[] columnNames, string[] columnValues,string [] dataTypes)
        {
            StringBuilder updatesql = new StringBuilder("update ");
            updatesql.Append(tableName + " set ");
            for (int i = 0; i < columnNames.Length; i++)
            {
                if (dataTypes[i] == "char" || dataTypes[i] == "varChar" || dataTypes[i] == "dateTime")
                {
                    updatesql.Append(columnNames[i] + "='" + columnValues[i] + "',");
                }
                else
                {
                    updatesql.Append(columnNames[i] + "=" + columnValues[i] + ",");
                }
            }
            updatesql.Remove(updatesql.Length - 1, 1);
            return updatesql.ToString();
        }
        public string updateSql(string columnName, string columnValue,string type,tableInfo[] tableinfos1, string[] searchTypes, string[] status, bool isMulti)
        {
            StringBuilder updatesql = new StringBuilder("update ");
            updatesql.Append(tableName + " set ");
            updatesql.Append(columnName + "=" + columnName + type+ columnValue);
            updatesql.Append(" " + wherestatement.whereSql(tableinfos1, searchTypes, status, isMulti));
            return updatesql.ToString();

        }
        public string updateSql(tableInfo[] tableinfos,tableInfo[] tableinfos1, string[] searchTypes, string[] status, bool isMulti)
        {
            StringBuilder updatesql = new StringBuilder("update ");
            updatesql.Append(tableName + " set ");
            for (int i = 0; i < tableinfos.Length; i++)
            {
                if (tableinfos[i].ColumnType == "char" || tableinfos[i].ColumnType == "varChar" || tableinfos[i].ColumnType == "dateTime")
                {
                    updatesql.Append(tableinfos[i].ColumnName + "='" +tableinfos[i].ColumnValue + "',");
                }
                else
                {
                    updatesql.Append(tableinfos[i].ColumnName + "=" + tableinfos[i].ColumnValue + ",");
                }
            }
            updatesql.Remove(updatesql.Length - 1, 1);
            updatesql.Append(" " + wherestatement.whereSql(tableinfos1, searchTypes, status,isMulti));
            return updatesql.ToString();
            
        }

    }
}