private static void UpdateLastBackupDate()
{
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.UpdateCommand = new SqlCommand();
da.UpdateCommand.Connection = new SqlConnection();
da.UpdateCommand.Connection.ConnectionString = XmlConnections.GetConnection("/Connections/BJVVV");
da.UpdateCommand.CommandText = "update BookAddInf..[BackupPeriodic] set [BACKUPLASTDATE] = getdate() where ID = 1";
da.UpdateCommand.Connection.Open();
da.UpdateCommand.ExecuteNonQuery();
da.UpdateCommand.Connection.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
CurReader = new Reader("", "");
if (!Page.IsPostBack)
{
string f = System.AppDomain.CurrentDomain.BaseDirectory;
Login1.Focus();
}
SqlDataAdapter DA = new SqlDataAdapter();
DA.SelectCommand = new SqlCommand();
DA.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/Turn"));
if (Request["pin"] == null)
{
return;
}
if (Request["baza"] == null)
{
return;
}
if (Request["baza"] == "1")
{
DA.SelectCommand.CommandText = "select avtp.PLAIN avt,zagp.PLAIN zag from BJVVV..DATAEXT A " +
" left join BJVVV..DATAEXT zag on A.IDMAIN = zag.IDMAIN and zag.MNFIELD = 200 and zag.MSFIELD = '$a' " +
" left join BJVVV..DATAEXTPLAIN zagp on zag.ID = zagp.IDDATAEXT " +
" left join BJVVV..DATAEXT avt on A.IDMAIN = avt.IDMAIN and avt.MNFIELD = 700 and avt.MSFIELD = '$a' " +
" left join BJVVV..DATAEXTPLAIN avtp on avt.ID = avtp.IDDATAEXT " +
" where A.IDMAIN = " + Request["PIN"];
}
else if (Request["baza"] == "2")
{
DA.SelectCommand.CommandText = "select avtp.PLAIN avt,zagp.PLAIN zag from REDKOSTJ..DATAEXT A " +
" left join REDKOSTJ..DATAEXT zag on A.IDMAIN = zag.IDMAIN and zag.MNFIELD = 200 and zag.MSFIELD = '$a' " +
" left join REDKOSTJ..DATAEXTPLAIN zagp on zag.ID = zagp.IDDATAEXT " +
" left join REDKOSTJ..DATAEXT avt on A.IDMAIN = avt.IDMAIN and avt.MNFIELD = 700 and avt.MSFIELD = '$a' " +
" left join REDKOSTJ..DATAEXTPLAIN avtp on avt.ID = avtp.IDDATAEXT " +
" where A.IDMAIN = " + Request["PIN"];
}
else
{
return;
}
DataSet res = new DataSet();
int i = DA.Fill(res, "t");
Label1.Text = "Вы собираетесь поставить в очередь на оцифровку издание: <br/> <b>Автор:</b> " + res.Tables["t"].Rows[0]["avt"].ToString() + "; <b>Заглавие:</b> " + res.Tables["t"].Rows[0]["zag"].ToString() +
"<br/><br/> Для выполнения этого действия необходимо авторизоваться <br/>";
}
internal bool IsForAbonement()
{
DA = new SqlDataAdapter();
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
DA.SelectCommand = new SqlCommand();
DA.SelectCommand.Connection = con;
DA.SelectCommand.CommandText = "select * from BJVVV..DATAEXT A where IDMAIN = " + this.ID +
" and exists (select 1 from BJVVV..DATAEXT B where A.IDMAIN = B.IDMAIN and B.MNFIELD = 899 and B.MSFIELD = '$a' and B.SORT = 'ЦДДАбонемент')";
DA.Fill(DS, "Name");
DA.SelectCommand.Connection.Close();
con.Dispose();
DA.Dispose();
return(DS.Tables["Name"].Rows.Count > 0 ? true : false);
}
public void delFromBasketE(string idr)
{
DataSet DS = new DataSet();
SqlDataAdapter sdvig = new SqlDataAdapter();
//SqlConnection con = new SqlConnection("Data Source=192.168.3.63;Initial Catalog=Reservation;Persist Security Info=True;User ID=Sasha;Password=Corpse536");
con = new SqlConnection(XmlConnections.GetConnection("/Connections/Zakaz"));
con.Open();
sdvig.DeleteCommand = new SqlCommand("delete from Reservation_E..Basket where IDMAIN = " + this.ID + " and IDREADER = " + idr, con);
sdvig.DeleteCommand.ExecuteNonQuery();
con.Close();
con.Dispose();
sdvig.Dispose();
}
public void InsertELOPENEDWAR(string sid)
{
da.SelectCommand.Parameters.Clear();
da.SelectCommand.Parameters.Add("idbase", SqlDbType.Int);
da.SelectCommand.Parameters.Add("idbook", SqlDbType.Int);
da.SelectCommand.Parameters.Add("sid", SqlDbType.NVarChar);
da.SelectCommand.Parameters["idbase"].Value = 1;
da.SelectCommand.Parameters["idbook"].Value = this.IDMAIN;
da.SelectCommand.Parameters["sid"].Value = sid;
da.SelectCommand.CommandText = "select top 1 * from Reservation_R..ELOPEN_WITHOUTAUTHRGHT " +
" where IDMAIN = @idbook and BASE = @idbase and SESSION = @sid order by DATEOPENING desc";
ds = new DataSet();
int i = da.Fill(ds, "t");
if (i > 0)
{
return;
}
//DataRow r = ds.Tables["t"].Rows[0];
//if (((DateTime)r["DATEOPENING"]).Date == DateTime.Now.Date)
//return;
da.InsertCommand = new SqlCommand();
da.InsertCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
da.InsertCommand.Connection.Open();
da.InsertCommand.Parameters.Clear();
da.InsertCommand.Parameters.Add("idbase", SqlDbType.Int);
da.InsertCommand.Parameters.Add("idbook", SqlDbType.Int);
da.InsertCommand.Parameters.Add("idr", SqlDbType.Int);
da.InsertCommand.Parameters.Add("dateopn", SqlDbType.DateTime);
da.InsertCommand.Parameters.Add("sid", SqlDbType.NVarChar);
da.InsertCommand.Parameters["idbase"].Value = this.Baza;
da.InsertCommand.Parameters["idbook"].Value = this.IDMAIN;
if (this.IDReader == null)
{
da.InsertCommand.Parameters["idr"].Value = "0";
}
else
{
da.InsertCommand.Parameters["idr"].Value = this.IDReader;
}
da.InsertCommand.Parameters["dateopn"].Value = DateTime.Now;
da.InsertCommand.Parameters["sid"].Value = sid;
da.InsertCommand.CommandText = "insert into Reservation_R..ELOPEN_WITHOUTAUTHRGHT " +
"(IDMAIN,IDREADER,BASE,DATEOPENING,SESSION) values (@idbook,@idr,@idbase,@dateopn,@sid)";
da.InsertCommand.ExecuteNonQuery();
da.InsertCommand.Connection.Close();
}
public bool IsOrderedAsAligatByCurReader(string idr)
{
SqlDataAdapter da;
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
da = new SqlDataAdapter("select * from Reservation_O..Orders where ID_Reader = " + idr + " and ALGIDM =" + this.IdmainOfMainAllig, con);
DataSet ds = new DataSet();
int count = da.Fill(ds);
if (count > 0)
{
return(true);
}
da = new SqlDataAdapter("select * from Reservation_O..Orders where ID_Reader = " + idr + " and ID_Book_EC =" + this.IdmainOfMainAllig, con);
ds = new DataSet();
count = da.Fill(ds);
if (count > 0)
{
return(true);
}
da = new SqlDataAdapter("select * from Reservation_R..ISSUED where IDREADER = " + idr + " and IDMAIN =" + this.IdmainOfMainAllig, con);
ds = new DataSet();
count = da.Fill(ds);
if (count > 0)
{
return(true);
}
da = new SqlDataAdapter("select * from Reservation_R..ISSUED_OF where IDREADER = " + idr + " and IDMAIN_CONST = " + this.IdmainOfMainAllig, con);
ds = new DataSet();
count = da.Fill(ds);
if (count > 0)
{
return(true);
}
da = new SqlDataAdapter("select * from Reservation_R..RecievedBooks where IDREADER = " + idr + " and IDMAIN =" + this.IdmainOfMainAllig + " and RETINBK = 0", con);
ds = new DataSet();
count = da.Fill(ds);
if (count > 0)
{
return(true);
}
da.Dispose();
con.Dispose();
return(false);
}
private void DeleteNodeByIDZ(int IDZ)
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = new SqlConnection();
da.SelectCommand.Connection.ConnectionString = XmlConnections.GetConnection("/Connections/BJVVV");
da.SelectCommand.Parameters.Add("IDZS", SqlDbType.Int);
da.SelectCommand.Parameters["IDZS"].Value = IDZ;
da.SelectCommand.CommandText = "PERIOD.dbo.[PI_DEL_VETVJ]";
da.SelectCommand.Connection.Open();
da.SelectCommand.ExecuteNonQuery();
da.SelectCommand.Connection.Close();
}
private static DateTime GetLastBackUpDate()
{
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = new SqlConnection();
da.SelectCommand.Connection.ConnectionString = XmlConnections.GetConnection("/Connections/BJVVV");
da.SelectCommand.CommandText = "select * from BookAddInf..[BackupPeriodic] where ID = 1";
if (da.Fill(ds, "t") == 0)
{
throw new Exception("Не найдена последняя дата бэкапа в базе!");
}
return((DateTime)ds.Tables["t"].Rows[0]["BACKUPLASTDATE"]);
}
protected void delmark_click(object sender, CommandEventArgs e)
{
SqlDataAdapter DA = new SqlDataAdapter();
DA.UpdateCommand = new SqlCommand();
DA.UpdateCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/Turn"));
DA.UpdateCommand.CommandText = "update Reservation_R..TURNTODIGITIZE set MARK = 0 " +
" where ID = " + e.CommandArgument.ToString();
DA.UpdateCommand.Connection.Open();
DA.UpdateCommand.ExecuteNonQuery();
DA.UpdateCommand.Connection.Close();
LoadData();
//GridView1.DataBind();
//GridView1.DataSource = SqlDataSource1;
//GridView1.DataBind();
}
private bool IsAlreadyInOrderWithAnotherNote(int reader)
{
DataSet DS = new DataSet();
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
SqlDataAdapter Status = new SqlDataAdapter("select * from Reservation_O..Orders where ID_Book_EC = " + this.IDMAIN + " and ID_Reader = " + reader + " and InvNumber = '" + this.inv + "' and INOTE = '" + this.note + "'", con);
Status.Fill(DS, "Name");
Status.Dispose();
con.Dispose();
if (DS.Tables["Name"].Rows.Count > 0)
{
return(true);
}
return(false);
}
private bool IsELOrderedByCurrentReader(int idr, int rtype)
{
DataSet DS = new DataSet();
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
SqlDataAdapter da = new SqlDataAdapter("select * from Reservation_R..ELISSUED where IDMAIN = " + this.IDMAIN + " and R_TYPE = " + rtype.ToString() + " and IDREADER = " + idr.ToString(), con);
int i = da.Fill(DS, "Name");
if (i == 0)
{
return(false);
}
else
{
return(true);
}
}
private bool IsFiveElBooksIssued(int idr, int rtype)
{
DataSet DS = new DataSet();
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
SqlDataAdapter da = new SqlDataAdapter("select * from Reservation_R..ELISSUED where R_TYPE = " + rtype.ToString() + " and IDREADER = " + idr.ToString(), con);
int i = da.Fill(DS, "Name");
if (i >= 5)
{
return(true);
}
else
{
return(false);
}
}
public Reader(string login, string sess)
{
SqlDataAdapter DA = new SqlDataAdapter();
DA.SelectCommand = new SqlCommand();
DA.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
DA.SelectCommand.CommandText = "select * from Readers.dbo.Main where NumberReader = " + login;
//DA.SelectCommand.Connection.Open();
DataSet DS = new DataSet();
int recc = DA.Fill(DS, "Reader");
this.ID = DS.Tables["Reader"].Rows[0]["NumberReader"].ToString();
//this.Login = DS.Tables["Reader"].Rows[0]["login"].ToString();
this.FIO = DS.Tables["Reader"].Rows[0]["FamilyName"].ToString() + " " + DS.Tables["Reader"].Rows[0]["Name"].ToString() + " " + DS.Tables["Reader"].Rows[0]["FatherName"].ToString();
this.Session = sess;
//DA.SelectCommand.Connection.Close();
}
public void BuildAndInsertHyperLink(string PIN, string year)
{
SqlDataAdapter da = new SqlDataAdapter();
da.UpdateCommand = new SqlCommand();
da.UpdateCommand.Connection = new SqlConnection();
da.UpdateCommand.Connection.ConnectionString = XmlConnections.GetConnection("/Connections/BJVVV");
da.UpdateCommand.Parameters.Add("HL", SqlDbType.NVarChar);
da.UpdateCommand.Parameters["HL"].Value = @"http://opac.libfl.ru/elcirp/viewer.aspx?pin=" + PIN + "&year=" + year;
da.UpdateCommand.Parameters.Add("IDZ", SqlDbType.Int);
da.UpdateCommand.Parameters["IDZ"].Value = GetIDZofHYPERLINKbyPINandYEAR(PIN, year);
da.UpdateCommand.CommandText = "update PERIOD..PI set POLE = @HL where IDZ = @IDZ";
da.UpdateCommand.Connection.Open();
da.UpdateCommand.ExecuteNonQuery();
da.UpdateCommand.Connection.Close();
}
private DataRowCollection GetIDZofAllPackagesByHyperLinkIDZ(int IDZ)
{
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = new SqlConnection();
da.SelectCommand.Connection.ConnectionString = XmlConnections.GetConnection("/Connections/BJVVV");
da.SelectCommand.Parameters.Add("IDZ", SqlDbType.Int);
da.SelectCommand.Parameters["IDZ"].Value = IDZ;
da.SelectCommand.CommandText = "select IDZ from PERIOD..[PI] where IDF = 240 and VVERH = (select VVERH from PERIOD..[PI] where IDZ = @IDZ)";
if (da.Fill(ds, "t") == 0)
{
throw new Exception("Не найден состав комплекта.");
}
return(ds.Tables["t"].Rows);
}
private string GetFolderByIDZ(string idz)
{
SqlDataAdapter da;
DataSet ds;
da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
ds = new DataSet();
da.SelectCommand.CommandText = "select top 1 * from BookAddInf..ScanInfo_PER_UPLOAD where IDZ = " + idz + " order by ID desc";
int i = da.Fill(ds, "t");
if (i == 0)
{
throw new Exception("В базе нет записей по изданию.");
}
return(ds.Tables["t"].Rows[0]["TITLE"].ToString() + "\\" + ds.Tables["t"].Rows[0]["YEAR"].ToString());
}
public string GetPINbyIDZ(int idz)
{
SqlDataAdapter da = new SqlDataAdapter();
DataSet ds = new DataSet();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = new SqlConnection();
da.SelectCommand.Connection.ConnectionString = XmlConnections.GetConnection("/Connections/BJVVV");
da.SelectCommand.Parameters.Add("IDZ", SqlDbType.Int);
da.SelectCommand.Parameters["IDZ"].Value = idz;
da.SelectCommand.CommandText = " select POLE from PERIOD..[PI] " +
" where IDZ = @IDZ and IDF = 120 ";
if (da.Fill(ds, "t") == 0)
{
throw new Exception("В базе не найден ПИН!");
}
return(ds.Tables["t"].Rows[0]["POLE"].ToString());
}
public void InsertAgreement()
{
da.InsertCommand = new SqlCommand();
da.InsertCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
da.InsertCommand.Connection.Open();
da.InsertCommand.Parameters.Clear();
da.InsertCommand.Parameters.Add("idbase", SqlDbType.Int);
da.InsertCommand.Parameters.Add("idbook", SqlDbType.Int);
da.InsertCommand.Parameters.Add("idr", SqlDbType.Int);
da.InsertCommand.Parameters.Add("dateagr", SqlDbType.DateTime);
da.InsertCommand.Parameters["idbase"].Value = this.Baza;
da.InsertCommand.Parameters["idbook"].Value = this.IDMAIN;
da.InsertCommand.Parameters["idr"].Value = this.IDReader;
da.InsertCommand.Parameters["dateagr"].Value = DateTime.Now;
da.InsertCommand.CommandText = "insert into Reservation_R..AGREEMENT " +
"(IDMAIN,IDREADER,BASE,DATEAGR) values (@idbook,@idr,@idbase,@dateagr)";
da.InsertCommand.ExecuteNonQuery();
da.InsertCommand.Connection.Close();
}
public void DeleteAgreement()
{
da.DeleteCommand = new SqlCommand();
da.DeleteCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
da.DeleteCommand.Connection.Open();
da.DeleteCommand.Parameters.Clear();
da.DeleteCommand.Parameters.Add("idbase", SqlDbType.Int);
da.DeleteCommand.Parameters.Add("idbook", SqlDbType.Int);
da.DeleteCommand.Parameters.Add("idr", SqlDbType.Int);
da.DeleteCommand.Parameters.Add("dateagr", SqlDbType.DateTime);
da.DeleteCommand.Parameters["idbase"].Value = this.Baza;
da.DeleteCommand.Parameters["idbook"].Value = this.IDMAIN;
da.DeleteCommand.Parameters["idr"].Value = this.IDReader;
da.DeleteCommand.Parameters["dateagr"].Value = DateTime.Now;
da.DeleteCommand.CommandText = "Delete from Reservation_R..AGREEMENT " +
" where IDMAIN =@idbook and IDREADER = @idr and BASE = @idbase";
da.DeleteCommand.ExecuteNonQuery();
da.DeleteCommand.Connection.Close();
}
public bool ISExtremistLiterature()//проверить, является ли данная электронная копия экстремистской
{
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
SqlDataAdapter da = new SqlDataAdapter("select 1 from BJVVV..DATAEXT " +
"where IDMAIN = " + this.IDMAIN + " and MNFIELD = 899 and MSFIELD = '$x' and SORT = 'Э' ", con);
DataSet ds = new DataSet();
int count = da.Fill(ds, "t");
da.Dispose();
con.Dispose();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
private int AddPackageNode(int IDZ)
{
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Connection = new SqlConnection();
da.SelectCommand.Connection.ConnectionString = XmlConnections.GetConnection("/Connections/BJVVV");
da.SelectCommand.Parameters.Add("IDZ", SqlDbType.Int);
da.SelectCommand.Parameters["IDZ"].Direction = ParameterDirection.Input;
da.SelectCommand.Parameters["IDZ"].Value = IDZ;
da.SelectCommand.Parameters.Add("IDZ_OUT", SqlDbType.Int);
da.SelectCommand.Parameters["IDZ_OUT"].Value = IDZ;
da.SelectCommand.Parameters["IDZ_OUT"].Direction = ParameterDirection.Output;
da.SelectCommand.CommandText = "PERIOD.dbo.[PI_ADD_VETVJ_VPRAVO]";
da.SelectCommand.Connection.Open();
da.SelectCommand.ExecuteNonQuery();
da.SelectCommand.Connection.Close();
return((int)da.SelectCommand.Parameters["IDZ_OUT"].Value);
}
//private string GetTitle(int idz)
//{
// SqlDataAdapter da;
// DataSet ds;
// da = new SqlDataAdapter();
// da.SelectCommand = new SqlCommand();
// da.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
// ds = new DataSet();
// da.SelectCommand.CommandText = "select top 1 * from BookAddInf..ScanInfo_PER_UPLOAD where IDZ = " + idz + " order by ID desc";
// int i = da.Fill(ds, "t");
// if (i == 0)
// {
// throw new Exception("В базе нет записей по изданию.");
// }
// return ds.Tables["t"].Rows[0]["TITLE"].ToString();
//}
private string GetTitle()
{
SqlDataAdapter da;
DataSet ds;
da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
ds = new DataSet();
da.SelectCommand.CommandText = " select B.POLE TITLE from PERIOD..PI A " +
" left join PERIOD..PI B on B.VVERH = A.IDZ" +
" where A.POLE = " + Request["pin"] + " and A.IDF=120 and B.IDF = 121 ";
int i = da.Fill(ds, "t");
if (i == 0)
{
throw new Exception("В базе нет записей по изданию.");
}
return(ds.Tables["t"].Rows[0]["TITLE"].ToString());
}
private bool IsAlreadyInOrderAsNOTMAINALLIGAT(int reader)
{
if (this.inv.Contains("Электронная"))
{
return(false);
}
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
DataSet DS = new DataSet();
SqlDataAdapter Status = new SqlDataAdapter("select * from Reservation_O..Orders where ALGIDM = " + this.IDMAIN + " and ID_Reader = " + reader, con);
Status.Fill(DS, "Name");
con.Dispose();
Status.Dispose();
if (DS.Tables["Name"].Rows.Count > 0)
{
return(true);
}
return(false);
}
public Reader(string login, string sess)
{
this.Type = 0;
SqlDataAdapter DA = new SqlDataAdapter();
DA.SelectCommand = new SqlCommand();
DA.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/BJVVV"));
DA.SelectCommand.CommandText = "select * from Readers.dbo.Main where NumberReader = " + login;
DataSet DS = new DataSet();
int recc = DA.Fill(DS, "Reader");
this.ID = DS.Tables["Reader"].Rows[0]["NumberReader"].ToString();
//this.Login = DS.Tables["Reader"].Rows[0]["login"].ToString();
this.FIO = DS.Tables["Reader"].Rows[0]["FamilyName"].ToString() + " " + DS.Tables["Reader"].Rows[0]["Name"].ToString() + " " + DS.Tables["Reader"].Rows[0]["FatherName"].ToString();
this.Session = sess;
DA.SelectCommand.CommandText = "select * from Readers..ReaderRight where IDReader = " + login;
DS = new DataSet();
DA.Fill(DS, "t");
string retval = string.Empty;
foreach (DataRow r in DS.Tables["t"].Rows)
{
if ((int)r["IDReaderRight"] == 3)
{
retval += "Сотрудник ВГБИЛ; ";
}
if ((int)r["IDReaderRight"] == 4)
{
retval += "Индивидуальный абонемент; ";
}
if ((int)r["IDReaderRight"] == 5)
{
retval += "Персональный абонемент; ";
}
if ((int)r["IDReaderRight"] == 6)
{
retval += "Коллективный абонемент; ";
}
this.Abonement = retval.TrimEnd();
}
}
private void FillNote(string iddata)
{
DA = new SqlDataAdapter();
DA.SelectCommand = new SqlCommand();
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
DA.SelectCommand.Connection = con;
DA.SelectCommand.CommandText = "select A.PLAIN note " +
"from BJVVV..DATAEXT B " +
"left join BJVVV..DATAEXTPLAIN A on B.ID = A.IDDATAEXT " +
"where " +
" B.MNFIELD = 899 and B.MSFIELD = '$x' and B.IDDATA = " + iddata;
DS = new DataSet();
int cnt2 = DA.Fill(DS, "note");
if (cnt2 != 0)
{
this.note = DS.Tables["note"].Rows[0]["note"].ToString();
}
DA.Dispose();
con.Dispose();
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlDataAdapter DA = new SqlDataAdapter();
DA.UpdateCommand = new SqlCommand();
DA.UpdateCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/Turn"));
DA.UpdateCommand.Parameters.AddWithValue("delcause", TextBox1.Text);
DA.UpdateCommand.Parameters.AddWithValue("deldate", DateTime.Now);
DA.UpdateCommand.CommandText = "update Reservation_R..TURNTODIGITIZE set DELETED = 1, MARK = 0, DELCAUSE = @delcause, DELDATE = @deldate " +
" where ID = " + hfIDOFSELECTEDROW.Value.ToString();
DA.UpdateCommand.Connection.Open();
DA.UpdateCommand.ExecuteNonQuery();
DA.UpdateCommand.Connection.Close();
//GridView1.DataSource = SqlDataSource1;
//GridView1.DataBind();
LoadData();
//UpdatePanel1.Update();
//GridView1.DataBind();
//LoadData();
//SqlDataSource1.DeleteParameters["id"]. = hfIDOFSELECTEDROW.Value.ToString();
}
public void OrdE(InvOfBook _inv, int dur, DateTime date, int idr) //перенос из таблицы корзина в таблицу читатели
{
DataSet DS = new DataSet();
//SqlConnection con = new SqlConnection("Data Source=192.168.3.63;Initial Catalog=Reservation;Persist Security Info=True;User ID=Sasha;Password=Corpse536");
con = new SqlConnection(XmlConnections.GetConnection("/Connections/Zakaz"));
SqlDataAdapter sdvig = new SqlDataAdapter("select * from Reservation_E..Orders where ID_Book_EC =" + this.ID, con);
sdvig.Fill(DS, "Name");
con.Close();
DataRow r = DS.Tables["Name"].NewRow();
r["ID_Reader"] = idr;
r["ID_Book_EC"] = ID;
r["ID_Book_CC"] = 0; //че сюда загонять?????пока ноль. это номер книги карточного каталога
r["Status"] = 0; //изначально статус нулевой
r["Start_Date"] = date;
r["Change_Date"] = date;
r["InvNumber"] = _inv.inv;
r["Form_Date"] = DateTime.Now;
r["Duration"] = dur;
r["Who"] = 0;//кто сменил статус
r["IDDATA"] = int.Parse(_inv.iddata);
//r["INOTE"] = _inv.note;
if (_inv.IsAllig)
{
r["ALGIDM"] = _inv.IdmainOfMainAllig;
}
DS.Tables["Name"].Rows.Add(r);
SqlCommandBuilder cb = new SqlCommandBuilder(sdvig);
sdvig.InsertCommand = cb.GetInsertCommand();
sdvig.Update(DS.Tables["Name"]);
con.Dispose();
sdvig.Dispose();
}
private void button5_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Продолжить?", "Внимание!", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (dr == DialogResult.No)
{
return;
}
string store_ip = XmlConnections.GetConnection("/Connections/store_ip");
string sTargetConnect = @"\\" + store_ip + @"\BookAddInf\PERIOD\";
string sTarget = @"\\" + store_ip + @"\BookAddInf\PERIOD\";
string sTargetConnectBookAddInf = @"\\" + store_ip + @"\BookAddInf";
DBScanInfo db = new DBScanInfo();
Package = "";
int Number = 1;
int Total = new PdfReader(fPDF.FullName).NumberOfPages;
fp = new fProgress(Total);
this.Enabled = false;
fp.Show();
Application.DoEvents();
//преобразовать и скопиировать все изображения номера
//int Total = new PdfReader(fPDF.FullName).NumberOfPages;
//fp.ResetProgress(Total, Number, Total);
try
{
CopyPDFToTarget(store_ip, sTarget, fPDF.DirectoryName, fPDF, Number, Total, fp, sTargetConnectBookAddInf);
}
catch (Exception ex)
{
MessageBox.Show("Произошла ошибка: " + ex.Message + ". Попробуйте еще раз!", "Внимание!", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
fp.Close();
this.Enabled = true;
return;
}
}
private string PreparedForBK()
{
if (this.inv.Contains("Электронная"))
{
return("");
}
con = new SqlConnection(XmlConnections.GetConnection("/Connections/ZakazO"));
SqlDataAdapter da = new SqlDataAdapter("select * from Reservation_R..RecievedBooks A where A.BAR = '" + this.Bar + "' and A.IDDATA ='" + this.iddata +
"' and A.RETINBK = 0 and A.PFORBK = 1 ", con);
DataSet ds = new DataSet();
int count = da.Fill(ds, "t");
da.Dispose();
con.Dispose();
if (count > 0)
{
return(ds.Tables["t"].Rows[0]["DEPNAME"].ToString());
}
else
{
return("");
}
}
protected void Page_Load(object sender, EventArgs e)
{
SqlDataAdapter DA = new SqlDataAdapter();
DA.SelectCommand = new SqlCommand();
DA.SelectCommand.Connection = new SqlConnection(XmlConnections.GetConnection("/Connections/Turn"));
DA.SelectCommand.CommandText = "with main as ( select row_number() over (order by (A.DELDATE )) num,A.IDMAIN pin,case when A.BAZA = 1 then avtp.PLAIN else ravtp.PLAIN end avt, A.DELDATE dd," +
"case when A.BAZA = 1 then zagp.PLAIN else rzagp.PLAIN end zag,A.CREATED cre,case when A.BAZA = 1 then 'Основной фонд' else 'Фонд редкой книги' end baza, A.ID id,A.DELCAUSE dc " +
" from Reservation_R..TURNTODIGITIZE A " +
" left join BJVVV..DATAEXT zag on A.IDMAIN = zag.IDMAIN and zag.MNFIELD = 200 and zag.MSFIELD = '$a' " +
" left join BJVVV..DATAEXTPLAIN zagp on zag.ID = zagp.IDDATAEXT " +
" left join BJVVV..DATAEXT avt on A.IDMAIN = avt.IDMAIN and avt.MNFIELD = 700 and avt.MSFIELD = '$a' " +
" left join BJVVV..DATAEXTPLAIN avtp on avt.ID = avtp.IDDATAEXT " +
" left join REDKOSTJ..DATAEXT rzag on A.IDMAIN = rzag.IDMAIN and rzag.MNFIELD = 200 and rzag.MSFIELD = '$a' " +
" left join REDKOSTJ..DATAEXTPLAIN rzagp on zag.ID = rzagp.IDDATAEXT " +
" left join REDKOSTJ..DATAEXT ravt on A.IDMAIN = ravt.IDMAIN and ravt.MNFIELD = 700 and ravt.MSFIELD = '$a' " +
" left join REDKOSTJ..DATAEXTPLAIN ravtp on ravt.ID = ravtp.IDDATAEXT " +
" where A.DELETED = 1) " +
" select top 100 * from main where num<=100 order by num desc";
DataSet DS = new DataSet();
int i = DA.Fill(DS, "data");
GridView1.DataSource = DS.Tables["data"];
((BoundField)GridView1.Columns[0]).DataField = "num";
//((BoundField)GridView1.Columns[0]).
((BoundField)GridView1.Columns[1]).DataField = "baza";
((BoundField)GridView1.Columns[2]).DataField = "pin";
((BoundField)GridView1.Columns[3]).DataField = "avt";
((BoundField)GridView1.Columns[4]).DataField = "zag";
((BoundField)GridView1.Columns[5]).DataField = "cre";
((BoundField)GridView1.Columns[5]).DataFormatString = "{0:dd.MM.yyyy HH:mm}";
((BoundField)GridView1.Columns[6]).DataField = "dd";
((BoundField)GridView1.Columns[7]).DataField = "dc";
GridView1.DataBind();
}
