/// <summary> /// 把列转变为SqlParameter其中最后有@OrderId转出参数,可以用于存储过程 /// </summary> /// <param name="columns"></param> /// <returns></returns> public static SqlParameter[] GetParameterByColumns(Column[] columns) { var par = new SqlParameter[columns.Length + 1]; par[par.Length - 1] = MakeOutputParam("@OrderId", SqlDbType.Int, 4); for (int i = 0; i < columns.Length; i++) { Column parm = columns[i]; par[i] = MakeInputParam(parm.ParameterName, parm.DbType, parm.Size, parm.Value); } return par; }
/// <summary> /// 构造函数 /// </summary> /// <param name="tableName">表名称</param> /// <param name="columns">列名称 , 若为查询。则将该参数值为 null</param> /// <param name="whereColumns">条件</param> /// <param name="tableNameIsSubQuery">表名是否为一个子查询</param> public SqlCreator(string tableName, Column[] columns, Column[] whereColumns, bool tableNameIsSubQuery) { TableNameIsSubQuery = tableNameIsSubQuery; if (TableNameIsSubQuery) { TableName = tableName; } else { TableName = "[" + tableName + "]"; } Columns = columns; WhereColumns = whereColumns; }
/// <summary> /// 构造函数 /// </summary> /// <param name="tableName">表名称</param> /// <param name="columns">列名称</param> /// <param name="where">条件</param> public SqlCreator(string tableName, Column[] columns, Column where) { TableName = "[" + tableName + "]"; Columns = columns; WhereColumns = new Column[1]; WhereColumns[0] = where; }
/// <summary> /// 构造函数 /// </summary> /// <param name="tableName">表名称</param> /// <param name="columns">列名称 , 若为查询。则将该参数值为 null</param> /// <param name="whereColumns">条件</param> public SqlCreator(string tableName, Column[] columns, Column[] whereColumns) { TableName = "[" + tableName + "]"; Columns = columns; WhereColumns = whereColumns; }