public void setBookReturned(string s, dbBook book)
{
Conn.SQLDA.SelectCommand.CommandText = "select * from [Reservation_R].[dbo].[ISSUED] where IDMAIN = " + s + " and BAR = '" + book.barcode + "' ";
Conn.SQLDA.SelectCommand.Connection = Conn.ZakazCon;
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(Conn.SQLDA);
DataSet B = new DataSet();
int i = Conn.SQLDA.Fill(B);
if (i == 0)
{
//
}
if (B.Tables[0].Rows[0]["IDROLD"].ToString() != "")
{
DeleteBarFromBJVVV(B.Tables[0].Rows[0]["BAR"].ToString());
}
Conn.SQLDA.UpdateCommand = new SqlCommand();
Conn.SQLDA.UpdateCommand.Connection = Conn.BJVVVConn;
Conn.SQLDA.UpdateCommand.CommandText = "update Reservation_R..ISSUED set IDMAIN = 0, IDROLD = '',DATE_FACT_VOZV = '" + DateTime.Today.ToString("yyyyMMdd") + "' where ID = " + B.Tables[0].Rows[0]["ID"].ToString();
if (Conn.SQLDA.UpdateCommand.Connection.State == ConnectionState.Closed)
{
Conn.SQLDA.UpdateCommand.Connection.Open();
}
int rc = Conn.SQLDA.UpdateCommand.ExecuteNonQuery();
Conn.SQLDA.UpdateCommand.Connection.Close();
//B.Tables[0].Rows[0]["IDMAIN"] = "0";
//B.Tables[0].Rows[0]["DATE_FACT_VOZV"] = DateTime.Now.ToShortDateString();
//B.Tables[0].Rows[0]["IDROLD"] = "";
//Conn.SQLDA.UpdateCommand = cmdBuilder.GetUpdateCommand();
//Conn.SQLDA.Update(B.Tables[0]);
}
public dbBook(dbBook Book)
{
this.author = Book.author;
this.barcode = Book.barcode;
this.id = Book.id;
this.name = Book.name;
this.rname = Book.rname;
this.inv = Book.inv;
this.fctvzv = Book.fctvzv;
this.vzv = Book.vzv;
this.iddata = Book.iddata;
this.name = Book.name;
this.rname = Book.rname;
}
public void setBookForReader(dbBook book, dbReader reader, int days)
{
Conn.SQLDA.SelectCommand.CommandText = "select * from Reservation_R..ADVORDER where INV = '" + book.inv + "'";
DataSet DS = new DataSet();
int c = Conn.SQLDA.Fill(DS, "t");
if (c != 0)
{
MessageBox.Show("���� ��������� ����� �� ���������� � �������� � ������� " + DS.Tables["t"].Rows[0]["IDREADER"].ToString() + "! ������� ���������� ����� ���������!");
return;
}
Conn.SQLDA.InsertCommand = new SqlCommand();
Conn.SQLDA.InsertCommand.Connection = Conn.ZakazCon;
if (Conn.ZakazCon.State != ConnectionState.Open) Conn.ZakazCon.Open();
Conn.SQLDA.InsertCommand.CommandText = "insert into Reservation_R..ISSUED (IDMAIN,BAR,DATE_VOZV,IDREADER,IDEMP,DATE_ISSUE,IDMAIN_CONST, " +
" PENALTY, REMPENALTY, INV, STATUS, IDDATA) values (@IDMAIN,@BAR,@DATE_VOZV,@IDREADER,@IDEMP,@DATE_ISSUE,@IDMAIN_CONST, " +
"@PENALTY, @REMPENALTY, @INV, @STATUS,@IDDATA)";
Conn.SQLDA.InsertCommand.Parameters.Add("IDMAIN", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters.Add("BAR", SqlDbType.NVarChar);
Conn.SQLDA.InsertCommand.Parameters.Add("DATE_VOZV", SqlDbType.DateTime);
Conn.SQLDA.InsertCommand.Parameters.Add("IDREADER", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters.Add("IDEMP", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters.Add("DATE_ISSUE", SqlDbType.DateTime);
Conn.SQLDA.InsertCommand.Parameters.Add("IDMAIN_CONST", SqlDbType.NVarChar);
Conn.SQLDA.InsertCommand.Parameters.Add("PENALTY", SqlDbType.Bit);
Conn.SQLDA.InsertCommand.Parameters.Add("REMPENALTY", SqlDbType.Bit);
Conn.SQLDA.InsertCommand.Parameters.Add("INV", SqlDbType.NVarChar);
Conn.SQLDA.InsertCommand.Parameters.Add("IDDATA", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters.Add("STATUS", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters["IDMAIN"].Value = book.id;
Conn.SQLDA.InsertCommand.Parameters["BAR"].Value = book.barcode;
Conn.SQLDA.InsertCommand.Parameters["DATE_VOZV"].Value = DateTime.Now.AddDays(days).ToShortDateString();
Conn.SQLDA.InsertCommand.Parameters["IDREADER"].Value = reader.id;
Conn.SQLDA.InsertCommand.Parameters["IDEMP"].Value = F1.EmpID;
Conn.SQLDA.InsertCommand.Parameters["DATE_ISSUE"].Value = DateTime.Now.ToShortDateString();
Conn.SQLDA.InsertCommand.Parameters["IDMAIN_CONST"].Value = book.id;
Conn.SQLDA.InsertCommand.Parameters["PENALTY"].Value = false;
Conn.SQLDA.InsertCommand.Parameters["REMPENALTY"].Value = false;
Conn.SQLDA.InsertCommand.Parameters["INV"].Value = book.inv;
Conn.SQLDA.InsertCommand.Parameters["STATUS"].Value = 3;
Conn.SQLDA.InsertCommand.Parameters["IDDATA"].Value = book.iddata;
Conn.SQLDA.InsertCommand.ExecuteNonQuery();
//book = book.Remove(book.Length - 1, 1);
//reader = reader.Remove(0, 1);
//reader = reader.Remove(reader.Length - 1, 1);
/*Conn.SQLDA.SelectCommand.CommandText = "select * from Reservation_R..ISSUED where ID = -1";
Conn.SQLDA.SelectCommand.Connection = Conn.ZakazCon;
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(Conn.SQLDA);
int i = Conn.SQLDA.Fill(Zakaz);
DataRow row = Zakaz.Tables[0].NewRow();
row["IDMAIN"] = book.id;
row["BAR"] = book.barcode;
row["DATE_VOZV"] = DateTime.Now.AddDays(days).ToShortDateString();
row["IDREADER"] = reader.id;
row["IDEMP"] = F1.EmpID;
row["DATE_ISSUE"] = DateTime.Now.ToShortDateString();
row["IDMAIN_CONST"] = book.id;
row["PENALTY"] = false;
row["REMPENALTY"] = false;
row["INV"] = book.inv;
Zakaz.Tables[0].Rows.Add(row);
//Conn.SQLDA.SelectCommand.CommandText = "select * from ZAKAZ where ID = -1";
//Conn.SQLDA.SelectCommand.Connection = Conn.ZakazCon;
//SQLDA.InsertCommand = cmdBuilder.GetInsertCommand();
Conn.SQLDA.Update(Zakaz.Tables[0]);*/
}
internal void InsertActionRETURNED(dbReader reader, dbBook book)
{
Conn.SQLDA.InsertCommand = new SqlCommand();
Conn.SQLDA.InsertCommand.Connection = Conn.ZakazCon;
if (Conn.ZakazCon.State != ConnectionState.Open) Conn.ZakazCon.Open();
Conn.SQLDA.InsertCommand.CommandText = "insert into Reservation_R..ABONEMENTACTIONS (ACTIONTYPE,BAR,IDEMP,IDREADER,DATEACT) " +
" values (@ACTIONTYPE,@BAR,@IDEMP,@IDREADER,@DATEACT)";
Conn.SQLDA.InsertCommand.Parameters.Add("ACTIONTYPE", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters.Add("BAR", SqlDbType.NVarChar);
Conn.SQLDA.InsertCommand.Parameters.Add("IDEMP", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters.Add("IDREADER", SqlDbType.Int);
Conn.SQLDA.InsertCommand.Parameters.Add("DATEACT", SqlDbType.DateTime);
Conn.SQLDA.InsertCommand.Parameters["ACTIONTYPE"].Value = 2;
Conn.SQLDA.InsertCommand.Parameters["BAR"].Value = book.barcode;
Conn.SQLDA.InsertCommand.Parameters["IDEMP"].Value = this.F1.EmpID;
Conn.SQLDA.InsertCommand.Parameters["IDREADER"].Value = book.rid;
Conn.SQLDA.InsertCommand.Parameters["DATEACT"].Value = DateTime.Now;
try
{
Conn.SQLDA.InsertCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message + ". �� ��������� ���������������� �������� - �������. ���������� � ������������.");
}
}
