C#

Lmm Cams wrote:

The post method then finds the file

SELECT id, department
FROM table
GROUP BY id, department, planned_end_date, end_date
HAVING COUNT(*) > 1

IWorkbook workbook = spreadsheetControl.Document;
Worksheet worksheet = workbook.Worksheets["DataSet1"];
CellRange range = worksheet.GetDataRange();
int LastRow = range.BottomRowIndex;
var detected_rows = new List<string>();
var mydic1 = new Dictionary<string, string>();
var keys1 = new List<string>();
var keys2 = new List<string>();
var keys3 = new List<string>();
var my_table4 = new DataTable();

for (int i = 1; i < LastRow + 1; i++)
{
    if (worksheet.Cells[i, 10].DisplayText == "خاتمه یافته")
    {
        keys1.Add(string.Join(",", worksheet.Cells[i, 4].DisplayText, worksheet.Cells[i, 14].DisplayText, worksheet.Cells[i, 19].DisplayText));
        keys2.Add(string.Join(",", worksheet.Cells[i, 26].DisplayText));
        keys3.Add(string.Join(",", worksheet.Cells[i, 28].DisplayText));
    }
}

for (int i = 0; i < keys1.Count; i++)
{
    if (keys2[i] == keys3[i])
    {
        detected_rows.Add(keys1[i]);
    }
}

for (int i = 0; i < keys1.Count; i++)
{
    if (!mydic1.ContainsKey(keys1[i]))
    {
        mydic1.Add(keys1[i], keys2[i]);
    }
}
for (int i = 0; i < detected_rows.Count; i++)
{
    mydic1.Remove(detected_rows[i]);
}

List<string> my_keys = new List<string>(mydic1.Keys);

my_table4.Columns.Add("شماره دستورکار");
my_table4.Columns.Add("مرکز هزینه");
my_table4.Columns.Add("سال");

for (int i = 0; i < my_keys.Count; i++)
{
    string text = my_keys[i];
    string[] my_list = text.Split(',');
    my_table4.Rows.Add(my_list[0], my_list[1], my_list[2]);
}

spreadsheetControl.Invoke((MethodInvoker)delegate { CreateSheet("Error Detection"); });
spreadsheetControl.Invoke((MethodInvoker)delegate { ClearSheet("Error Detection"); });
spreadsheetControl.Invoke((MethodInvoker)delegate { Filldata("Error Detection", my_table4, 0, 0, true); });

if (number & 0x01)
{
    // it is odd
}

if ((number & 0x01) == 1)
   {
   ...

public static bool IsOdd(this int value)
{
    return (value % 2 == 1);
}