private void button7_Click(object sender, EventArgs e)//Олег. То что оцифровали с микрофильмов
{
SqlDataAdapter DA;
DataSet DS;
DA = new SqlDataAdapter();
DS = new DataSet();
DA.SelectCommand = new SqlCommand();
DA.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/CirculationACC"));
DA.SelectCommand.CommandText = "select row_number() over (order by A.ID) num,D.POLE tit,B.POLE IDMAIN,A.ID kolvo,A.YEAR,len(A.PACKAGE)-len(replace(A.PACKAGE,';','')) nomera " +
" from BookAddInf..DgtPeriodic A " +
" left join PERIOD..PI B on B.POLE = A.PIN and B.IDF = 120" +
" left join PERIOD..PI C on C.IDZ = B.VNIZ" +
" left join PERIOD..PI D on D.IDZ = C.VPRAVO" +
//" where A.CREATOR in (468)";
" where cast(cast(A.DATEADD as varchar(11)) as datetime) between '20150101' and '20151231' and A.CREATOR in (468)";
DA.Fill(DS, "t");
foreach (DataRow row in DS.Tables["t"].Rows)
{
if (row["IDMAIN"].ToString() == "")
{
continue;
}
string outside_ip = @"\\192.168.4.30\BookAddInf\PERIOD\";
string PIN = PINFormat(row["IDMAIN"].ToString());
outside_ip += PIN.Substring(0, 1) + @"\" + PIN.Substring(1, 3) + @"\" + PIN.Substring(4, 3) + @"\" + row["YEAR"].ToString() + @"\";
DirectoryInfo Target = new DirectoryInfo(outside_ip);
DirectoryInfo[] Numbers = Target.GetDirectories();
int kolvo = 0;
foreach (DirectoryInfo di in Numbers)
{
using (new NetworkConnection(outside_ip, new NetworkCredential("bj\\sasha", "Corpse536")))
{
FileInfo[] fi = di.GetFiles("*.jpg");
kolvo += fi.Length;
}
}
row["kolvo"] = kolvo;
}
dataGridView1.DataSource = DS.Tables["t"];
}
private void button5_Click(object sender, EventArgs e)//Redkostj по тематике
{
SqlDataAdapter DA;
DataSet DS;
DA = new SqlDataAdapter();
DS = new DataSet();
DA.SelectCommand = new SqlCommand();
DA.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/CirculationACC"));
DA.SelectCommand.CommandText = "select row_number() over (order by A.IDBook) num,DD.PLAIN tema, " +
" C.PLAIN tit,B.IDMAIN IDMAIN,C.ID kolvo " +
" from BookAddInf..ScanInfo A " +
" left join REDKOSTJ..DATAEXT B on A.IDBook = B.IDMAIN and B.MNFIELD = 200 and B.MSFIELD = '$a' " +
" left join REDKOSTJ..DATAEXTPLAIN C on C.IDDATAEXT = B.ID " +
" left join REDKOSTJ..DATAEXT D on A.IDBook = D.IDMAIN and D.MNFIELD = 922 and D.MSFIELD = '$e' " +
" left join REDKOSTJ..DATAEXTPLAIN DD on DD.IDDATAEXT = D.ID " +
" where A.IDBase = 2 and cast(cast(A.DateEBook as varchar(11)) as datetime) between '20160101' and '20160630' and C.PLAIN is not null";
DA.Fill(DS, "t");
foreach (DataRow row in DS.Tables["t"].Rows)
{
if (row["IDMAIN"].ToString() == "")
{
continue;
}
string outside_ip = @"\\192.168.4.30\BookAddInf\REDKOSTJ\";
string outside_ip_connect = @"\\192.168.4.30\BookAddInf\";
string PIN = PINFormat(row["IDMAIN"].ToString());
outside_ip += PIN.Substring(0, 1) + @"\" + PIN.Substring(1, 3) + @"\" + PIN.Substring(4, 3) + @"\";
DirectoryInfo Target = new DirectoryInfo(outside_ip);
//using (new NetworkConnection(outside_ip, new NetworkCredential("bj\\CopyPeriodAddInf", "Period_Copy")))
using (new NetworkConnection(outside_ip_connect, new NetworkCredential("bj\\sasha", "Corpse536")))
{
FileInfo[] fi = Target.GetFiles("*.jpg");
row["kolvo"] = fi.Length;
}
}
List <TemaKolvo> list = new List <TemaKolvo>();
bool first = false;
foreach (DataRow row in DS.Tables["t"].Rows)
{
int incr = 0;
int index = -1;
TemaKolvo tmp = new TemaKolvo(row["tema"].ToString(), (int)row["kolvo"], 1);
foreach (TemaKolvo tk in list)
{
if (tk.tema == row["tema"].ToString())
{
incr = tk.kolvo;
incr += (int)row["kolvo"];
index = list.IndexOf(tk);
break;
}
}
if (!first)
{
list.Add(tmp);
first = true;
continue;
}
if (index != -1)
{
list[index].kolvo = incr;
list[index].kolvopins++;
}
else
{
list.Add(tmp);
}
}
var bind = new BindingSource();
bind.DataSource = list;
dataGridView1.DataSource = bind;
}
