public static string UpdateByPrimaryKey(DataTable dataTable) { var columns = SqlUpdateHelper.ArrangeColumns(dataTable); var tableName = dataTable.TableName; return($"UPDATE [{tableName.Trim()}] SET {columns.Trim()} WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};"); }
public static string SelectByPrimaryKey(DataTable dataTable) { var columns = SqlSelectHelper.ArrangeColumnsWithComma(dataTable); var tableName = dataTable.TableName; return($"SELECT TOP 1 {columns.Trim()} FROM [{tableName.Trim()}] WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};"); }
public static string CreateSelectByKeyword(DataTable dataTable) { var columns = SqlSelectHelper.ArrangeColumnsWithComma(dataTable); var tableName = dataTable.TableName; var keys = SqlPrimaryKeyStringHelper.ArrangeColumnsWithComma(dataTable); var whereLikeKeyword = SqlSelectHelper.ArrangeColumeLikeKeyword(dataTable); var subQuery = $"(SELECT ROW_NUMBER() OVER (ORDER BY {{orderByColumnName}} {{orderDirection}}) AS RowSequence, {columns.Trim()} FROM [{tableName.Trim()}] WHERE ({whereLikeKeyword})) AS [{tableName.Trim()}]"; return($"SELECT {columns.Trim()} FROM {subQuery} WHERE RowSequence BETWEEN @Start AND @End;"); }
public static string DeleteByPrimaryKey(DataTable dataTable) { var tableName = dataTable.TableName; return($"DELETE [{tableName.Trim()}] WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};"); }
public static string UpdateColumnByPrimaryKey(DataTable dataTable, DataColumn dataColumn) { var tableName = dataTable.TableName; return($"UPDATE [{tableName.Trim()}] SET {dataColumn.ColumnName.Trim()}=@{dataColumn.ColumnName.Trim()} WHERE {SqlPrimaryKeyStringHelper.ArrangeColumnsWithParam(dataTable)};"); }