public static List <string> check(XLS_Class xls, int start, int stop, int col, string table, string name, bool xls_marker)
{
List <string> rett = new List <string>();
string element;
if (xls_marker)
{
if (name != "Owner")
{
element = "xls" + name;
}
else
{
element = name;
}
}
else
{
element = name;
}
for (int i = start; i < stop; i++)
{
if (
SQL_Class.ReadValueInt32("select count(*) from " + table + " where " + element + " like '%" +
xls.read_val(i, col).ToString() + "%'") <= 0)
{
if (!rett.Contains(xls.read_val(i, col).ToString()))
{
rett.Add(xls.read_val(i, col).ToString());
}
}
}
return(rett);
}
private void dgv_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (e.RowIndex == -1 && e.Button == MouseButtons.Middle)
{
string name = dgv.Columns[e.ColumnIndex].Name;
for (int i = 0; i < tbl.el_list.Count; i++)
{
if (name == tbl.el_list[i].name && tbl.el_list[i].cmbox)
{
Element el = tbl.el_list[i];
GroupChangeForm frm = new GroupChangeForm(el);
frm.ShowDialog();
Application.DoEvents();
if (frm.Acept)
{
int new_index = frm.id;
List <int> ids = new List <int>();
for (int j = 0; j < dgv.RowCount; j++)
{
ids.Add((int)dgv.Rows[j].Cells[0].Value);
}
foreach (var VARIABLE in ids)
{
string req = "update itemtable set " + el.name + " = " + new_index + " where ID=" +
VARIABLE;
SQL_Class.Execute(req);
Logs.add_upload_log(VARIABLE, el.name, el.addtable, SQL_Class.ReadValueInt32("select " + el.name + " from itemtable where ID=" + VARIABLE), new_index);
}
Load_Data_With_Filters();
}
}
}
}
}
public List <string> check(XLS_Class xls, int start, int stop, int col, string table, string name)
{
List <string> rett = new List <string>();
string element;
if (XLS_Rbut.Checked)
{
element = "xls" + name;
}
else
{
element = name;
}
for (int i = start; i < stop; i++)
{
if (
SQL_Class.ReadValueInt32("select count(*) from " + table + " where " + element + " like '%" +
xls.read_val(i, col).ToString() + "%'") <= 0)
{
if (xls.read_val(i, col).ToString() == "СКЛАД")
{
MessageBox.Show(i.ToString());
}
if (!rett.Contains(xls.read_val(i, col).ToString()))
{
rett.Add(xls.read_val(i, col).ToString());
}
}
}
return(rett);
}
private void Acept_but_Click(object sender, EventArgs e)
{
Acept = true;
id =
SQL_Class.ReadValueInt32("select ID from " + el.addtable + " where " + el.name + " ='" +
cmb.SelectedItem.ToString() + "'");
Close();
}
public void Update_One_Item(string name, string table, string fr, string addition)
{
int id = SQL_Class.ReadValueInt32("select ID from " + table + " where " + name + "='" + fr + "'");
string old = SQL_Class.ReadValueString("select xls" + name + " from " + table + " where ID=" + id);
old += "|" + addition + "|";
SQL_Class.Execute("Update " + table + " set xls" + name + "='" + old + "' where ID=" + id);
}
private void Owner_CmBox_SelectedIndexChanged(object sender, EventArgs e)
{
if (Owner_CmBox.DataSource != null)
{
if (SQL_Class.get_data_Source("select Owner from ownertable").Contains(Owner_CmBox.SelectedItem.ToString()))
{
mas = Compare_Pare_Mas.get_base_elements(SQL_Class.ReadValueInt32("select ID from ownertable where Owner='" + Owner_CmBox.SelectedItem.ToString() + "'"));
}
}
}
public string get_one_Typethized_part(ComboBox cmb, CheckBox options, string field, string table)
{
string rett = " ";
if (options.Checked)
{
return(" AND itemtable." + field + "=" +
SQL_Class.ReadValueInt32("select ID from " + table + " where " + field + "='" + cmb.SelectedItem +
"'") + " ");
}
else
{
return("");
}
}
//public void upload(string inter_str, ref string param, string par_name, string table,bool cmb)
//{
// if (inter_str != param)
// {
// if (MessageBox.Show("Сохранить?", "Сохранить?", MessageBoxButtons.YesNo) == DialogResult.Yes)
// {
// param = inter_str;
// if (cmb)
// {
// int id =
// SQL_Class.ReadValueInt32("select ID from " + table + " where " + par_name + "= '" + param +
// "'");
// SQL_Class.Execute("update itemtable set " + par_name + "=" + id + " where ID=" + pr.base_el.ID);
// }
// else
// {
// SQL_Class.Execute("update itemtable set " + par_name + "='" + param + "' where ID=" + pr.base_el.ID);
// }
// reload_base_el();
// }
// }
//}
public void upload(string inter_str, int param, string par_name, string table) // for cmbox
{
int new_param_id =
SQL_Class.ReadValueInt32("select ID from " + table + " where " + par_name + " ='" + inter_str + "'");
if (new_param_id != param)
{
if (MessageBox.Show("Сохранить?", "Сохранить?", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
param = new_param_id;
SQL_Class.Execute("update itemtable set " + par_name + "=" + new_param_id + " where ID=" + pr.base_el.ID);
reload_base_el();
}
}
}
void load_data()
{
string zap = "select ID, ItemID, Log, Date, Who from logs where ItemID=" + ID;
log_dgv.DataSource = FuncClass.get_dataTable(zap);
doc_dgv.RowCount = SQL_Class.ReadValueInt32("select count(*) from Documents where ItemID=" + ID);
SQL_Class cl = new SQL_Class();
cl.ReadValues("select ID, Name from documents where ItemID=" + ID);
int i = 0;
while (cl.SQL_DataReader.Read())
{
doc_dgv.Rows[i].Cells[0].Value = cl.get_int(0);
doc_dgv.Rows[i].Cells[1].Value = cl.get_string(1);
i++;
}
}
public void load_info()
{
int count = SQL_Class.ReadValueInt32("Select Count(*) from " + TableName);
dgv.RowCount = count + 1;
string zap = "Select ID," + FName + " from " + TableName;
SQL_Class cl = new SQL_Class();
cl.ReadValues(zap);
int i = 0;
while (cl.SQL_DataReader.Read())
{
dgv.Rows[i].Cells[0].Value = cl.get_int(0);
dgv.Rows[i].Cells[1].Value = cl.SQL_DataReader.GetValue(1);
i++;
}
cl.Manualy_Close_Connection2();
}
private void Add_But_Click(object sender, EventArgs e)
{
Compare_Element el = new Compare_Element();
el.Serial = ser1.Text;
el.Serial2 = ser21.Text;
el.Text = t1.Text;
el.Text2 = t2.Text;
el.Text3 = t3.Text;
el.Text4 = t4.Text;
el.Text5 = t5.Text;
el.Text6 = t6.Text;
el.Prise = prise1.Text;
el.date = date1.Value;
el.Status2id = SQL_Class.ReadValueInt32("select ID from status2table where Status2 ='" + status21.SelectedItem + "'");
el.Typeid = SQL_Class.ReadValueInt32("select ID from typetable where Type ='" + type1.SelectedItem + "'");
el.Markid = SQL_Class.ReadValueInt32("select ID from marktable where Mark ='" + mark1.SelectedItem + "'");
el.Statusid =
SQL_Class.ReadValueInt32("select ID from statustable where Status ='" + status1.SelectedItem + "'");
el.Placeid = SQL_Class.ReadValueInt32("select ID from placetable where Place ='" + place1.SelectedItem + "'");
el.Place2id =
SQL_Class.ReadValueInt32("select ID from place2table where PLace2 ='" + place21.SelectedItem + "'");
el.OSID = SQL_Class.ReadValueInt32("select ID from ostable where OS ='" + os1.SelectedItem + "'");
el.OwnerID = SQL_Class.ReadValueInt32("select ID from ownertable where Owner ='" + owner1.SelectedItem + "'");
if (FuncClass.add_Element(el))
{
Close();
}
else
{
MessageBox.Show("Элемент не добавлен");
}
}
public void request_mas_of_base_elements()
{
mas = Compare_Pare_Mas.get_base_elements(SQL_Class.ReadValueInt32("select ID from ownertable where Owner='" + Owner_CmBox.SelectedItem.ToString() + "'"), SQL_Class.ReadValueInt32("select ID from ostable where OS='" + OS_CmBox.SelectedItem.ToString() + "'"));
}
public static int get_set(string name)
{
return(SQL_Class.ReadValueInt32("select settingstable.Index from settingstable where settingstable.Setting like '%" + name + "%'"));
}
public DataTable get_Table(List <string> mas_eng, string str)
{
string[] or_like = new string[0];
if (All_Search_chBox.Checked)
{
string[] sv = All_Search_TBox.Text.Split('|');
or_like = new string[sv.Length];
for (int i = 0; i < sv.Length; i++)
{
string cur = "";
for (int j = 1; j < mas_eng.Count; j++)
{
if (!"Data_StartIngest_StartIngest_EndTime_Of_Registration".Contains(mas_eng[j]))
{
if (sv[i][0] == '@')
{
cur += " or " + mas_eng[j] + " like '" + sv[i].Replace("#", "").Replace("!", "") + "' ";
}
else
{
cur += " or " + mas_eng[j] + " like '%" + sv[i].Replace("#", "").Replace("!", "") + "%' ";
}
//cur += " or " + mas_eng[j] + " like "+ sv[i].Replace("#","").Replace("@","") + " ";
}
}
or_like[i] = " and ( false " + cur + " )";
if (sv[i][0] == '#')
{
or_like[i] = or_like[i].Replace(" and (", " and NOT (");
}
}
}
string agregate = str;
string pre_zapros = "";
if (agregate.Contains("PrID"))
{
pre_zapros = "SELECT MDA.ID,PrID,MDA.ID " + agregate.Replace("PrID", "St.Name") + " FROM MetaDataArchive as MDA left join ingestassistantsettingsbase.settings as St on St.ID=PrID where( Deleted=0 ";
}
else
{
pre_zapros = "SELECT MDA.ID,PrID,MDA.ID " + agregate + " FROM MetaDataArchive as MDA where (Deleted=0 ";
}
if (ViPlanner_ChBOX.Checked)
{
pre_zapros += "AND ViPlanner='" + Viplanner_TBox.Text + "' ";
}
if (Reel_ID_ChBox.Checked)
{
pre_zapros += "AND Reel_ID='" + Reel_Id_TBox + "' ";
}
if (Pr_Filter_ChBox.Checked)
{
pre_zapros += "AND PrID=" +
SQL_Class.ReadValueInt32(
"select ID from settings where Name='" + Pr_Filter_CmBox.SelectedItem + "'",
Properties.Settings.Default.Setting_Base_Path) + " ";
}
if (D_Date_ChBox.Checked)
{
DateTime d1;
DateTime d2;
if (D_One_RBut.Checked)
{
d1 = Date_Filter1.Value.Date;
d2 = d1.AddDays(1).Date;
}
else
{
d1 = Date_Filter1.Value.Date;
d2 = Date_Filter2.Value.AddDays(1).Date;
}
pre_zapros += "AND (Time_Of_Registration between '" + d1.ToString("yyyy.MM.dd HH:mm:ss") + "' and '" +
d2.ToString("yyyy.MM.dd HH:mm:ss") + "' )";
}
if (All_Search_chBox.Checked)
{
string zapr = "";
pre_zapros += " ";
for (int i = 0; i < or_like.Length; i++)
{
zapr += pre_zapros + or_like[i] + ") union ";
}
if (or_like.Length != 0)
{
zapr = zapr.Substring(0, zapr.Length - 7);
}
else
{
zapr = pre_zapros + " false)";
}
pre_zapros = zapr;
}
else
{
pre_zapros += ")";
}
if (pre_zapros.Contains("UserID"))
{
pre_zapros = pre_zapros.Replace("UserID", "L.L_FullName");
pre_zapros = pre_zapros.Replace("where",
"left join ingestassistantsettingsbase.login as L on L.L_ID=UserID where");
}
if (pre_zapros.Contains("RegisterID"))
{
pre_zapros = pre_zapros.Replace("RegisterID", "LL.L_FullName");
// if (!pre_zapros.Contains("left join ingestassistantsettingsbase.login as L on L_ID=UserId"))
{ pre_zapros = pre_zapros.Replace("where",
"left join ingestassistantsettingsbase.login as LL on LL.L_ID=RegisterID where"); }
}
pre_zapros = pre_zapros.Replace(" ID", "MDA.ID");
var sqlcon = SQL_Class.Create_class(Ingest_Assistant.Properties.Settings.Default.MetaBase_Way);
int rows_count = 0;
//vk
MySqlDataAdapter mad = new MySqlDataAdapter(pre_zapros, sqlcon.SQL_Connection);
//DataSet set = new DataSet();
DataTable tb = new DataTable();
mad.Fill(tb);
return(tb);
}
public static int get_id(ComboBox box, string name, string table)
{
return(SQL_Class.ReadValueInt32("select ID from " + table + " where " + name + " ='" +
box.SelectedItem.ToString() + "'"));
}
