/// <summary>
/// Gets all rows from Excel sheet that is mapped to the used object type.
/// </summary>
/// <returns>Returns a list of type Metrics</returns>
public IEnumerable <T> GetAll()
{
var currentType = typeof(T);
var selectStatement = currentType.GetSelectStatement();
var itemsList = new List <T>();
using (OleDbConnection connection = new OleDbConnection(_connectionString))
{
OleDbCommand command = new OleDbCommand(selectStatement, connection);
connection.Open();
OleDbDataReader reader = command.ExecuteReader();
while (reader != null && reader.Read())
{
var item = new T();
foreach (var property in currentType.GetProperties())
{
var value = reader[property.GetMappingColumn()];
if (value != DBNull.Value)
{
property.SetValue(item, value);
}
}
itemsList.Add(item);
}
reader?.Close();
}
return(itemsList);
}
/// <summary>
/// Run SQL Query over Excel file
/// </summary>
/// <param name="sql">
/// SQL Query to run
/// </param>
/// <param name="dataTable">
/// DataSet with result
/// </param>
/// <returns>
/// True if operation completed successfully
/// </returns>
public void RunSql(string sql, ref DataTable dataTable)
{
OleDbConnection oConn = null;
OleDbCommand oComm = null;
OleDbDataReader oRdr = null;
try
{
String sConnString = BuildConnectionString();
oConn = new OleDbConnection(sConnString);
oConn.Open();
String sCommand = sql;
oComm = new OleDbCommand(sCommand, oConn);
oRdr = oComm.ExecuteReader();
dataTable.Load(oRdr);
}
finally
{
oRdr?.Close();
oRdr = null;
oComm?.Dispose();
oConn.Close();
oConn.Dispose();
}
}
/// <summary>
/// Gets the row from Excel sheet that is mapped to the used object type, having the gived ID.
/// </summary>
/// <returns>Returns a row of type Metrics</returns>
public T GetSingle(object id)
{
var currentType = typeof(T);
var selectStatement = currentType.GetSelectStatementForSingle(id);
using (OleDbConnection connection = new OleDbConnection(_connectionString))
{
OleDbCommand command = new OleDbCommand(selectStatement, connection);
connection.Open();
OleDbDataReader reader = command.ExecuteReader();
if (reader != null && reader.Read())
{
var item = new T();
foreach (var property in currentType.GetProperties())
{
var value = reader[property.GetMappingColumn()];
if (value != DBNull.Value)
{
property.SetValue(item, value);
}
}
return(item);
}
reader?.Close();
}
return(null);
}
public IEnumerable <TrainingRow> GetAllRows()
{
var rows = new List <TrainingRow>();
using (OleDbConnection connection = new OleDbConnection(_connectionString))
{
OleDbCommand command = new OleDbCommand(GetSelectStatement(), connection);
connection.Open();
OleDbDataReader reader = command.ExecuteReader();
while (reader != null && reader.Read())
{
var row = new TrainingRow();
var idColumn = reader[_idColumn];
if (idColumn != DBNull.Value)
{
row.IdColumn = idColumn.ToString();
row.Input = GetArrayOfVariables(reader, _inputVariables);
row.Output = GetArrayOfVariables(reader, _outputVariables);
rows.Add(row);
}
}
reader?.Close();
}
return(rows);
}
/*---------------------------------------------------------------*/
protected List <BaseEntity> Select()
{
List <BaseEntity> list = new List <BaseEntity>();
try
{
Command.Connection = Con;
Con.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
BaseEntity entity = NewEntity();
list.Add(CreateModel(entity));
}
}
catch (Exception e)
{
Console.WriteLine("Error! " + e.Message);
}
finally
{
Reader?.Close();
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
}
return(list);
}
/*================================================================================
* GET PLUSES
*================================================================================*/
public static FullObservableCollection <Pluses> GetPluses()
{
// Creamos la lista y el comando que extrae las líneas.
FullObservableCollection <Pluses> lista = new FullObservableCollection <Pluses>();
using (OleDbConnection conexion = new OleDbConnection(App.Global.CadenaConexion))
{
string comandoSQL = "SELECT * FROM Pluses ORDER BY Año;";
OleDbCommand comando = new OleDbCommand(comandoSQL, conexion);
OleDbDataReader lector = null;
try
{
conexion.Open();
lector = comando.ExecuteReader();
while (lector.Read())
{
Pluses pluses = new Pluses(lector);
lista.Add(pluses);
pluses.Nuevo = false;
pluses.Modificado = false;
}
} catch (Exception ex)
{
Utils.VerError("BdPluses.GetPluses", ex);
} finally
{
lector?.Close();
}
}
return(lista);
}
//================================================================================
// GET GRAFICO
//================================================================================
public static GraficoBase GetGrafico(int numero, DateTime validez)
{
GraficoBase grafico = null;
OleDbDataReader lector = null;
using (OleDbConnection conexion = new OleDbConnection(App.Global.CadenaConexion)) {
try {
conexion.Open();
OleDbCommand comando = new OleDbCommand(comandoGetGrafico, conexion);
comando.Parameters.AddWithValue("@Validez", validez.ToString("yyyy-MM-dd"));
comando.Parameters.AddWithValue("@Numero", numero);
// Ejecutamos el comando y extraemos el gráfico.
lector = comando.ExecuteReader();
if (lector.Read())
{
grafico = new GraficoBase(lector);
}
} catch (Exception ex) {
Utils.VerError("BdPijamas.GetGrafico", ex);
} finally {
lector?.Close();
}
}
return(grafico);
}
/// <summary>
/// Fills contents of passed combo box with values from database.
/// </summary>
/// <param name="comboBox"></param>
/// <param name="dataItems"></param>
/// <param name="query"></param>
/// <param name="member"></param>
/// <param name="value"></param>
private void fillCombo(ComboBox comboBox, List <dataItem> dataItems, string query, string displayValue, string selector)
{
//Fill List with passed query's database results
fillComboBoxList(dataItems, query);
//Set list as combo box item source
comboBox.ItemsSource = dataItems;
//Set property from data item to display
comboBox.DisplayMemberPath = displayValue;
//Selector for record to display
comboBox.SelectedValuePath = selector;
//Procedure to query the database a fill list with result
void fillComboBoxList(List <dataItem> items, string sql)
{
myConn.Open();
//create query
OleDbCommand myCmd = myConn.CreateCommand();
//set passed SQL string to query
myCmd.CommandText = sql;
try
{
//run query
myDR = myCmd.ExecuteReader();
while (myDR.Read())
{
//null validation arrow function
string outOfBounds(int i) => myDR.FieldCount > i ? myDR[i].ToString() : "";
//add new data item to items with values read from the database.
items.Add(new dataItem
{
//add properties
id = outOfBounds(0),
prodName = outOfBounds(1)
});
}
}
catch (Exception e)
{
//display unhelpful obtuse system generation error message
MessageBox.Show(e.ToString());
}
//close connections (prevents exception errors!)
myConn?.Close();
myDR?.Close();
}
}
public void createCatalagoCuentas()
{
string strAccessConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=database\\" + this.databaseFileName;
string strAccessSelect = "SELECT * FROM [CatalogoCuentasSatVendor]";
DataSet myDataSet = new DataSet();
OleDbConnection myAccessConn = null;
try
{
myAccessConn = new OleDbConnection(strAccessConn);
}
catch (Exception ex)
{
Console.WriteLine("Error: Failed to create a database connection. \n{0}", ex.Message);
return;
}
try
{
myAccessConn.Open();
OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn);
OleDbDataReader reader = myAccessCommand.ExecuteReader();
List <SatContabilidad.CatalogoCtas.CatalogoCtas> ctas = new List <SatContabilidad.CatalogoCtas.CatalogoCtas>();
while (reader.Read())
{
SatContabilidad.CatalogoCtas.CatalogoCtas cta = new SatContabilidad.CatalogoCtas.CatalogoCtas();
Type code = typeof(CatalogoCtas.c_CodAgrup);
foreach (CatalogoCtas.c_CodAgrup o in Enum.GetValues(typeof(CatalogoCtas.c_CodAgrup)))
{
if (GetXmlAttrNameFromEnumValue(o).Equals(reader["CodAgrupador"].ToString(), StringComparison.OrdinalIgnoreCase))
{
cta.CodAgrup = o;
}
}
cta.NumCta = reader["NumCta"].ToString();
cta.Desc = reader["Desc"].ToString();
cta.Natur = reader["Natur"].ToString();
cta.Nivel = int.Parse(reader["Nivel"].ToString());
ctas.Add(cta);
}
reader.Close();
myAccessConn.Close();
SatContabilidad.CatalogoCtas.Catalogo catalogo = new SatContabilidad.CatalogoCtas.Catalogo();
catalogo.schemaLocation = "www.sat.gob.mx/esquemas/ContabilidadE/1_1/CatalogoCuentas http://www.sat.gob.mx/esquemas/ContabilidadE/1_1/CatalogoCuentas/CatalogoCuentas_1_1.xsd";
catalogo.Ctas = ctas.ToArray <SatContabilidad.CatalogoCtas.CatalogoCtas>();
Type mes = typeof(CatalogoCtas.CatalogoMes);
catalogo.Mes = (CatalogoCtas.CatalogoMes)Enum.Parse(mes, (int.Parse(this.month) - 1).ToString());
catalogo.Anio = int.Parse(this.year);
catalogo.RFC = this.rfc;
XmlSerializer serializer = new XmlSerializer(typeof(SatContabilidad.CatalogoCtas.Catalogo));
System.IO.TextWriter writer = new System.IO.StreamWriter(this.outputPath + this.rfc + this.year + this.month + "CT.xml");
serializer.Serialize(writer, catalogo);
}
catch (Exception ex)
{
Console.WriteLine("Error: Failed to retrive the required data from the Database.\n{0}", ex.Message);
return;
}
finally
{
myAccessConn.Close();
}
}
/*---------------------------------------------------------------*/
public int SaveChanges()
{
OleDbCommand command = new OleDbCommand();
OleDbTransaction trans = null;
int recordsAffected = 0;
int errorIndex = 0;
try
{
Con.Open();
trans = Con.BeginTransaction();
command.Connection = Con;
command.Transaction = trans;
//inserted
foreach (var item in Inserted)
{
command.Parameters.Clear();
item.CreateSql(item.Entity, command);
recordsAffected += command.ExecuteNonQuery();
command.CommandText = "SELECT @@Identity"; //get last ID on this session
int temp = (int)command.ExecuteScalar();
item.Entity.Id = temp;
errorIndex++;
}
Inserted.Clear();
//updated, deleted
foreach (var item in Updated)
{
command.Parameters.Clear();
item.CreateSql(item.Entity, command);
recordsAffected += command.ExecuteNonQuery();
}
Updated.Clear();
trans.Commit();
}
catch (Exception e)
{
Debug.WriteLine("\n" + e.Message + "\nSQL:" + command.CommandText);
try
{
trans.Rollback();
}
catch (Exception ex2)
{
// This catch block will handle any errors that may have occurred
// on the server that would cause the rollback to fail, such as
// a closed connection.
Console.WriteLine("Rollback Exception Type: {0}", ex2.GetType());
Console.WriteLine(" Message: {0}", ex2.Message);
}
}
finally
{
Reader?.Close();
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
}
return(recordsAffected);
}
public void loadNomenclature()
{
DateTime dt;
ListViewItem ListViewItem_add;
if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL)
{
oleDbConnection = new OleDbConnection();
oleDbConnection.ConnectionString = DataConfig.oledbConnectLineBegin +
DataConfig.localDatabase +
DataConfig.oledbConnectLineEnd +
DataConfig.oledbConnectPass;
oleDbConnection.Open();
oleDbCommand = new OleDbCommand("SELECT * FROM Counteragents WHERE (name = '" + Counteragent + "')", oleDbConnection);
oleDbDataReader = oleDbCommand.ExecuteReader();
if (oleDbDataReader.Read())
{
priceName = oleDbDataReader["excel_table_id"].ToString();
}
else
{
MessageBox.Show("Контрагент " + "\"" + Counteragent + "\"" + " не существует в справочнике контрагентов.", "Сообщение");
}
oleDbDataReader.Close();
if (priceName != "")
{
oleDbCommand = new OleDbCommand("SELECT * FROM " + priceName + " ", oleDbConnection);
oleDbDataReader = oleDbCommand.ExecuteReader();
while (oleDbDataReader.Read())
{
ListViewItem_add = new ListViewItem();
ListViewItem_add.SubItems.Add(oleDbDataReader["name"].ToString());
ListViewItem_add.StateImageIndex = 0;
ListViewItem_add.SubItems.Add(oleDbDataReader["price"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["manufacturer"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["remainder"].ToString());
dt = new DateTime();
DateTime.TryParse(oleDbDataReader["term"].ToString(), out dt);
ListViewItem_add.SubItems.Add(dt.ToString("dd.MM.yyyy"));
ListViewItem_add.SubItems.Add(oleDbDataReader["discount1"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["discount2"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["discount3"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["discount4"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["code"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["series"].ToString());
ListViewItem_add.SubItems.Add(oleDbDataReader["article"].ToString());
ListViewItem_add.SubItems.Add(Counteragent);
ListViewItem_add.SubItems.Add(priceName);
listView1.Items.Add(ListViewItem_add);
}
oleDbDataReader.Close();
}
else
{
MessageBox.Show("Контрагент " + Counteragent + " не содержит прайс-листа.", "Сообщение");
}
oleDbConnection.Close();
}
else if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER)
{
sqlConnection = new SqlConnection(DataConfig.serverConnection);
sqlConnection.Open();
sqlCommand = new SqlCommand("SELECT * FROM Counteragents WHERE (name = '" + Counteragent + "')", sqlConnection);
sqlDataReader = sqlCommand.ExecuteReader();
if (sqlDataReader.Read())
{
priceName = sqlDataReader["excel_table_id"].ToString();
}
else
{
MessageBox.Show("Контрагент " + "\"" + Counteragent + "\"" + " не существует в справочнике контрагентов.", "Сообщение");
}
sqlDataReader.Close();
if (priceName != "")
{
sqlCommand = new SqlCommand("SELECT * FROM " + priceName + " ", sqlConnection);
sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
ListViewItem_add = new ListViewItem();
ListViewItem_add.SubItems.Add(sqlDataReader["name"].ToString());
ListViewItem_add.StateImageIndex = 0;
ListViewItem_add.SubItems.Add(sqlDataReader["price"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["manufacturer"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["remainder"].ToString());
dt = new DateTime();
DateTime.TryParse(sqlDataReader["term"].ToString(), out dt);
ListViewItem_add.SubItems.Add(dt.ToString("dd.MM.yyyy"));
ListViewItem_add.SubItems.Add(sqlDataReader["discount1"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["discount2"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["discount3"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["discount4"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["code"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["series"].ToString());
ListViewItem_add.SubItems.Add(sqlDataReader["article"].ToString());
ListViewItem_add.SubItems.Add(Counteragent);
ListViewItem_add.SubItems.Add(priceName);
listView1.Items.Add(ListViewItem_add);
}
sqlDataReader.Close();
}
else
{
MessageBox.Show("Контрагент " + Counteragent + " не содержит прайс-листа.", "Сообщение");
}
sqlConnection.Close();
}
}
private void Showdata()
{
int varindex = 0;
dataGridView1.Rows.Clear();
dataGridView1.ColumnCount = 8;
dataGridView1.Columns[varindex].Name = "วันที่นำส่ง";
dataGridView1.Columns[varindex].Width = 130;
varindex = varindex + 1;
dataGridView1.Columns[varindex].Name = "ผู้เบิก";
dataGridView1.Columns[varindex].Visible = false;
varindex = varindex + 1;
dataGridView1.Columns[varindex].Name = "ชื่อผู้เบิก";
dataGridView1.Columns[varindex].Width = 170;
varindex = varindex + 1;
dataGridView1.Columns[varindex].Name = "จำนวนเงิน";
dataGridView1.Columns[varindex].Width = 110;
varindex = varindex + 1;
dataGridView1.Columns[varindex].Name = "ระหว่างวันที่";
dataGridView1.Columns[varindex].Width = 120;
varindex = varindex + 1;
dataGridView1.Columns[varindex].Name = "ถึงวันที่";
dataGridView1.Columns[varindex].Width = 120;
varindex = varindex + 1;
dataGridView1.Columns[varindex].Name = "รอบเงินเข้า";
dataGridView1.Columns[varindex].Width = 120;
varindex = varindex + 1;
dataGridView1.Columns[varindex].Name = "SEQ";
dataGridView1.Columns[varindex].Width = 45;
string sql = "";
if (MyGlobal.GlobalAuthority == "Admin")
{
if (txtSearchUserID.Text == "")
{
sql = "Select * from EOD_AllowanceData order by SEQ";
txtUser.Text = "";
txtUserID.Text = "";
}
else if (txtSearchUserID.Text != "")
{
sql = "Select * from EOD_AllowanceData where UserID like '%' + '" + txtSearchUserID.Text + "' + '%' order by SEQ";
}
}
else
{
if (txtSraStartDate.Text == "" && txtSearchEndDate.Text == "")
{
sql = "Select * from EOD_AllowanceData where UserID like '%' + '" + MyGlobal.GlobalUserID + "' + '%' order by SEQ";
}
else if (txtSraStartDate.Text != "" && txtSearchEndDate.Text != "")
{
sql = "Select * from EOD_AllowanceData where UserID like '%' + '" + MyGlobal.GlobalUserID + "' + '%' and StartDate >= '" + txtSraStartDate.Text + "' and EndDate <= '" + txtSearchEndDate.Text + "' order by SEQ";
}
}
OleDbCommand com = new OleDbCommand(sql, conn);
OleDbDataReader dr = com.ExecuteReader();
while (dr.Read())
{
string varUserName = "";
string sql1 = "Select * from UserMaster where UserID = '" + dr["UserID"].ToString() + "' ";
OleDbCommand com1 = new OleDbCommand(sql1, conn);
OleDbDataReader dr1 = com1.ExecuteReader();
while (dr1.Read())
{
varUserName = dr1["UserName"].ToString();
txtUser2.Text = dr1["UserName"].ToString();
}
dr1.Close();
dataGridView1.Rows.Add(dr["DeliveryDate"].ToString(), dr["UserID"].ToString(), varUserName, dr["Amount"].ToString(), dr["StartDate"].ToString(), dr["EndDate"].ToString(), dr["PaymentPeriod"].ToString(), dr["SEQ"].ToString());
}
foreach (DataGridViewColumn column in dataGridView1.Columns)
{
column.SortMode = DataGridViewColumnSortMode.NotSortable;
}
dr.Close();
}
private string LoadViewSource()
{
string text = string.Empty;
OleDbConnection cn = null;
OleDbDataReader reader = null;
try
{
string select = string.Format(@"SELECT CASE WHEN encrypted = 1 THEN NULL ELSE com.text END as Source FROM sysobjects o, syscomments com
WHERE o.id = object_id(N'[{0}].[{1}]')
and com.id=o.id
and com.status=2
order by colid;", this.Schema, this.Name);
cn = new OleDbConnection(dbRoot.ConnectionString);
cn.Open();
cn.ChangeDatabase(this.Database.Name);
OleDbCommand cmd = cn.CreateCommand();
cmd.CommandText = select;
try
{
reader = cmd.ExecuteReader();
while (reader.Read())
{
text += reader[0].ToString();
}
reader.Close();
}
catch
{
if (reader != null)
{
reader.Close();
}
}
if (text == string.Empty)
{
select = string.Format(@"SELECT CASE WHEN encrypted = 1 THEN NULL ELSE com.text END as Source FROM sysobjects o, syscomments com
WHERE o.id = object_id(N'[{0}].[{1}]')
and com.id=o.id
order by colid;", this.Schema, this.Name);
cmd = cn.CreateCommand();
cmd.CommandText = select;
reader = cmd.ExecuteReader();
while (reader.Read())
{
text += reader[0].ToString();
}
reader.Close();
cn.Close();
}
cn.Close();
text = text.TrimStart(' ', '\r', '\n', '\t');
}
catch
{
if (reader != null)
{
reader.Close();
}
if ((cn != null) && (cn.State != ConnectionState.Closed) && (cn.State != ConnectionState.Broken))
{
cn.Close();
}
}
return(text);
}
protected void Page_Load(object sender, EventArgs e)
{
UserManager manager = new UserManager();
//check if the user is a venue owner or a user, and make visible the correct panel
if (manager.GetPhoneNumber(User.Identity.GetUserId()) != null)
{
ownerView.Visible = true;
//query database for events booked at owner's venue
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString;
OleDbConnection c = new OleDbConnection(connectionString);
c.Open();
OleDbCommand cmd = c.CreateCommand();
cmd.CommandType = CommandType.Text;
//create query
cmd.CommandText = "SELECT V.venueName FROM venue V WHERE V.owner = '" + User.Identity.GetUserName() + "' AND V.isClosed = 0";
//execute query
OleDbDataReader reader = cmd.ExecuteReader();
//check if user owns a venue
String venueName = "";
while (reader.Read())
{
venueName = reader.GetString(0);
}
//c.Close();
reader.Close();
if (!venueName.Equals(""))
{
//check if there are events booked at the venue
cmd.CommandText = "SELECT E.eventName, E.eventDate, E.category FROM event E WHERE E.location = '" + venueName + "'";
reader = cmd.ExecuteReader();
int i = 0;
while (reader.Read())
{
//only show events that are upcoming
if (inFuture(reader.GetString(1)))
{
System.Web.UI.HtmlControls.HtmlGenericControl dynDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV");
dynDiv.ID = "dynDivCode" + i.ToString();
dynDiv.Attributes["class"] = "col-lg-4";
switch (reader.GetString(2))
{
case "Music":
dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test3.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>";
break;
case "Academic":
dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test1.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>";
break;
case "Party":
dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/eventhub3.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>";
break;
case "Film":
dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test2.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>";
break;
case "Fine Arts":
dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/test2.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>";
break;
case "Sports":
dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/eventhub5.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>";
break;
case "Other":
dynDiv.InnerHtml = "<div class = thumbnail><img src = \"../Style/eventhub4.jpg\" /><h5>" + reader.GetString(1) + "</h5><h4>" + reader.GetString(0) + "</h4></div>";
break;
}
ownerFiller.Controls.Add(dynDiv);
i++;
}
}
}
reader.Close();
}
else
{
userView.Visible = true;
string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["DBConnect"].ConnectionString;
OleDbConnection c = new OleDbConnection(connectionString);
c.Open();
OleDbCommand cmd = c.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select TOP 3 E.eventName, E.eventDate from event E INNER JOIN attendedEvents AE on E.eventName = AE.event where E.eventDate < '" + DateTime.Now.ToString("MM/dd/yyyy") + "' and AE.attendee = '" + User.Identity.GetUserName() + "'";
OleDbDataReader reader = cmd.ExecuteReader();
int i = 0;
// reader = cmd.ExecuteReader();
while (reader.Read())
{
if (i == 0)
{
attendedEvent1.Text = reader.GetString(0);
attendedEventDate1.Text = reader.GetString(1);
}
if (i == 1)
{
attendedEvent2.Text = reader.GetString(0);
attendedEventDate2.Text = reader.GetString(1);
}
if (i == 2)
{
attendedEvent3.Text = reader.GetString(0);
attendedEventDate3.Text = reader.GetString(1);
}
i++;
}
reader.Close();
c.Close();
cmd.CommandText = "select TOP 3 E.eventName, E.eventDate from event E INNER JOIN attendedEvents AE on E.eventName = AE.event where E.eventDate >= '" + DateTime.Now.ToString("MM/dd/yyyy") + "' and AE.attendee = '" + User.Identity.GetUserName() + "'";
c.Open();
reader = cmd.ExecuteReader();
i = 0;
// reader = cmd.ExecuteReader();
while (reader.Read())
{
if (i == 0)
{
bookedEvent1.Text = reader.GetString(0);
bookedEventDate1.Text = reader.GetString(1);
}
if (i == 1)
{
bookedEvent2.Text = reader.GetString(0);
bookedEventDate2.Text = reader.GetString(1);
}
if (i == 2)
{
bookedEvent3.Text = reader.GetString(0);
bookedEventDate3.Text = reader.GetString(1);
}
i++;
}
reader.Close();
c.Close();
}
}
public void LoadPBImage()
{
String imgPath = "";
ImageLayout iLayout = ImageLayout.None;
int layoutVal = 0;
try
{
DBConnection.Open();
OleDbDataReader reader = DBConnection._Read("select * from BSetting where ID=1");
reader.Read();
if (reader.HasRows)
{
layoutVal = Convert.ToInt16(reader["bValue"]);
imgPath = reader["path"].ToString();
}
reader.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
DBConnection.Close();
}
//----------->
if (layoutVal == 0)
{
iLayout = ImageLayout.None;
}
else if (layoutVal == 1)
{
iLayout = ImageLayout.Center;
}
else if (layoutVal == 2)
{
iLayout = ImageLayout.Stretch;
}
else if (layoutVal == 3)
{
iLayout = ImageLayout.Tile;
}
else if (layoutVal == 4)
{
iLayout = ImageLayout.Zoom;
}
//-------------->
if (!imgPath.Equals(""))
{
if (System.IO.File.Exists(imgPath))
{
this.BackgroundImage = Image.FromFile(imgPath);
this.Refresh();
this.BackgroundImageLayout = iLayout;
}
else
{
this.BackgroundImage = Sales_Management.Properties.Resources.unknown;
this.Refresh();
this.BackgroundImageLayout = ImageLayout.Center;
}
}
else
{
this.BackgroundImage = Sales_Management.Properties.Resources.unknown;
this.Refresh();
this.BackgroundImageLayout = ImageLayout.Center;
}
}
public void Reset()
{
try
{
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + lblpath.Text + "';");
con.Open();
cmd = con.CreateCommand();
cmd.CommandText = "SELECT MAX(VOCHERNO) as VOUCHERNO FROM LedgerPosting WHERE VOUCHERTYPE='" + "QUICK RECEIPT" + "' ";
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
if (rdr.IsDBNull(rdr.GetOrdinal("VOUCHERNO")))
{
txtReceiptNo.Text = Convert.ToString("1");
}
else
{
txtReceiptNo.Text = Convert.ToString(Convert.ToInt64(rdr["VOUCHERNO"]) + 1);
}
}
if ((rdr != null))
{
rdr.Close();
}
con.Close();
con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source='" + lblpath.Text + "';");
con.Open();
String sql = "select ACCOUNTNAME from Account";
cmd = new OleDbCommand(sql, con);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
cmbCustomer.Items.Add(rdr[0]);
}
con.Close();
cmbCustomer.Text = "";
cmbpaymentmode.Text = "Cash";
txtChequeno.Text = "";
txttotalamount.Text = "";
txt_extra1.Text = "";
label1.Hide();
label4.Hide();
dtpChequeDate.Hide();
txtChequeno.Hide();
txttotalamount.Text = "";
btn_save.Enabled = true;
btn_delete.Enabled = false;
cmbCustomer.Focus();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
static void Main(string[] args)
{
// Setup a trace listener to the console
Trace.AutoFlush = true;
// First, determine the filename to use:
string dir = Environment.CurrentDirectory + "\\";
string baseName = "hstlogfile." + DateTime.Now.ToShortDateString().Replace("/", "-");
string ext = ".txt";
// If this file exists, rename appropriately
if (System.IO.File.Exists(dir + baseName + ext))
{
int x = 1;
while (System.IO.File.Exists(dir + baseName + "." + Convert.ToString(x) + ext))
{
x++;
}
baseName = baseName + "." + Convert.ToString(x);
}
System.IO.FileStream traceLog = new System.IO.FileStream(dir + baseName + ext, System.IO.FileMode.OpenOrCreate);
// Creates the new trace listener.
System.Diagnostics.TextWriterTraceListener newListener =
new System.Diagnostics.TextWriterTraceListener(traceLog);
// Add the listener
Trace.Listeners.Add(newListener);
Trace.Listeners.Add(new TextWriterTraceListener(Console.Out));
// If the settings folder does not exist, create it
if (!System.IO.Directory.Exists(Environment.CurrentDirectory + "\\settings"))
{
Trace.WriteLine("Settings folder was not found - it is being created.");
System.IO.Directory.CreateDirectory(Environment.CurrentDirectory + "\\settings");
}
Thread.CurrentThread.Priority = ThreadPriority.Lowest; // We don't want anything to interfere with
// the game servers that are being managed.
//////////////////////////////////////////////////////////////
// Initialization: Part One - Load settings from files
//////////////////////////////////////////////////////////////
// Open the database connection
string dbFile = Environment.CurrentDirectory + "\\settings\\global_settings.mdb";
if (!System.IO.File.Exists(dbFile))
{
Trace.WriteLine("Database file not found - " + dbFile);
Trace.WriteLine("Could not initialize - reinstall HST to repair this problem.");
}
DB.OpenDatabase(dbFile);
// Start all of the server processes
ServerManager.ServerList = new System.Collections.ArrayList();
// Load the server list from the database
OleDbDataReader dr = DB.GetData("select * from servers");
if (dr.HasRows)
{
while (dr.Read())
{
string startupFolder = dr.GetString(dr.GetOrdinal("installed_dir"));
HaloServer h = new HaloServer(startupFolder);
h.name = dr.GetString(dr.GetOrdinal("name"));
h.id = Convert.ToString(dr.GetInt32(dr.GetOrdinal("server_id")));
h._ipAddress = System.Net.IPAddress.Parse(dr.GetString(dr.GetOrdinal("ip_address")));
h._port = dr.GetInt32(dr.GetOrdinal("port"));
h._commandLine = dr.GetString(dr.GetOrdinal("commandline"));
h._parameters = dr.GetString(dr.GetOrdinal("parameters"));
ServerManager.ServerList.Add(h);
h.Start();
}
}
else
{
Trace.WriteLine("No servers found.");
}
dr.Close();
string input;
while (true)
{
input = Console.ReadLine().ToUpper();
if (input == "QUIT")
{
// There are still child threads running - we need to fix that.
foreach (System.Collections.DictionaryEntry de in ServerManager.ServerList)
{
GameServer g = (GameServer)de.Value;
g.Stop();
}
break;
}
if (input.StartsWith("STOP"))
{
GameServer g = (GameServer)ServerManager.ServerList[0];
Trace.WriteLine("Stopping Server: " + g.name);
g.Stop();
}
if (input.StartsWith("START"))
{
GameServer g = (GameServer)ServerManager.ServerList[0];
Trace.WriteLine("Starting Server: " + g.name);
g.Start();
}
/*if (input.StartsWith("WEB"))
* {
* if (hServ.Active)
* {
* Trace.WriteLine("Web server active.");
* Trace.WriteLine("IP: " + hServ.Ip);
* Trace.WriteLine("Port: " + Convert.ToString(hServ.Port));
* Trace.WriteLine(" ");
* }
* else
* {
* Trace.WriteLine("Web Server not currently active.");
* }
* }*/
}
}
public TestLoadXmlFromSvr(ITestOutputHelper output)
{
this.output = output;
// retrieve metadata as xml from target server
string sqlStatementForTablesToImport = @"
select (
select mappingName = N'm_sync_' + tables.[name],
mappingDescription = N'HSTG',
[enabled] = 'true',
[schemaExt] = (
select objectSchema = schema_name(tables.[schema_id]),
objectName = tables.[name]
for xml path('underlyingSource'), root('AzP_EDW'), type
),
[source] = (
select dataStore = (
select connectionKey = 'HSTG_PRD'
for xml path(''), type
),
[language] = 'T-SQL',
code = 'select * from ' + schema_name(tables.[schema_id]) + N'.' + tables.[name] + N' where OMD_INSERT_DATETIME > ? AND OMD_INSERT_DATETIME <= ?;'
for xml path(''), type
),
[target] = (
select dataStore = (
select connectionKey = 'HSTG'
for xml path(''), type
),
objectSchema = schema_name(tables.[schema_id]),
objectName = tables.[name]
for xml path(''), type
),
mappedDataItems = (
select sourceDataItem = (select columnName = columns.[name] for xml path(''), type),
targetColumn = (select columnName = columns.[name] for xml path(''), type)
from sys.columns
where columns.[object_id] = tables.[object_id]
and columns.[name] not like 'OMD\_%' escape '\'
order by columns.column_id
for xml path('MappedDataItem'), type
)
from EDW_150_History_Area.sys.tables
inner join openquery(AUBIWSQLPRD, '
select schema_name(tables.[schema_id]) as [schema_name]
, tables.[name]
from EDW_150_History_Area.sys.tables;
') src
on src.[schema_name] = schema_name(tables.[schema_id])
and src.[name] = tables.[name]
where schema_name(tables.[schema_id]) = N'dbo'
order by schema_name(tables.[schema_id]), tables.[name]
for xml path('MappedDataSet'), root('ArrayOfMappedDataSet')
) as xmlColumn;
";
using (OleDbConnection conn = new OleDbConnection(@"Provider=SQLNCLI11;Server=(local);Integrated Security=SSPI;Initial Catalog=EDW_150_History_Area;"))
{
OleDbCommand cmd = new OleDbCommand(sqlStatementForTablesToImport, conn);
conn.Open();
OleDbDataReader reader = cmd.ExecuteReader();
string xmlString = "";
while (reader.Read())
{
// read xml to string (assuming single row)
xmlString = reader.GetString(0);
}
reader.Close();
// load to object model
List<MappedDataSet> loaded = XmlLoader.LoadFromString(xmlString);
loadedMappings.MappedDataSets.AddRange(loaded);
}
}
private void btnLoadDoc_Click(object sender, EventArgs e)
{
odc字典連線 = new System.Data.OleDb.OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\EN_" + cb目標語言.Text + ".dll");
odc詞頻典連線 = new System.Data.OleDb.OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Application.StartupPath + @"\WordFrequency.dll");
DGVResult.Rows.Clear();
progressBar.Value = 0;
panel1.Visible = true;
this.Enabled = false;
Dict各單字之雙語對照.Clear();
//1.建立文件清單，2.將所載入之文件加到清單中，3.再將清單丟給詞頻物件分析其詞頻
Docs = new List <WordFrequencyCounter.Document>(); //建立文件清單
Docs.Add(new WordFrequencyCounter.Document(tbDoc.Text, false, strArr忽略字)); //將所載入之文件加到清單中
wordFrequency = new WordFrequencyCounter.WordFrequency(Docs); //將清單丟給詞頻物件分析其詞頻
//此後，wordFrequency記錄著文章中的每個單字，以及其在文章中出現之頻率
progressBar.Maximum = wordFrequency.Frequencies.Count; //進度條最大值設為單字數
lbTotalWordNum.Text = progressBar.Maximum.ToString(); //「共多少單字要查」的label
this.Refresh(); //重繪表單以顯示最新資訊
odc詞頻典連線.Open();
odc字典連線.Open();
odCmd查字典 = odc字典連線.CreateCommand(); //用來查單字解釋
odCmd查詞頻典 = odc詞頻典連線.CreateCommand(); //用來查詞頻
//將文章中的每個單字，查出其中文解釋，以及其語料詞頻排行
//str調整中單字原形：一個字串配對一個數字，即單字配對其文件詞頻
//str文中單字變化形.Key：單字；str文中單字變化形.Value：詞頻
string str調整中單字原形 = null; //驗證過程中，用來儲存改來改去的字
string str文中單字變化形 = null; //驗證過程中，用來儲存原本的字(可能為變化形)
foreach (KeyValuePair <string, int> singleWord in wordFrequency.Frequencies)
{
Application.DoEvents();
try
{
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + singleWord.Key + "'";
oddr查字典 = odCmd查字典.ExecuteReader();
#region 判斷單字的變化型態
str調整中單字原形 = str文中單字變化形 = singleWord.Key.ToLower();
if (!oddr查字典.Read())
{
if (str調整中單字原形.EndsWith("s"))
{
if (str調整中單字原形.EndsWith("ies"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y";
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
else if (str調整中單字原形.EndsWith("es"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
if (str調整中單字原形 == str文中單字變化形)//字尾有直接加s，為免與es混淆，不能用else
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 1, 1);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
}
else if (str調整中單字原形.EndsWith("ed"))
{
if (str調整中單字原形.EndsWith("ied"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y";
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
else//驗證+ed
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
if (str調整中單字原形 == str文中單字變化形) //驗證：重覆字尾+ed
{
if (str調整中單字原形[str調整中單字原形.Length - 3] == str調整中單字原形[str調整中單字原形.Length - 4]) //驗證：重覆字尾+ed
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3); //刪除重覆的字尾+ed
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
}
if (str調整中單字原形 == str文中單字變化形)//驗證：字尾有e，直接+d
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 1, 1);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
}
else if (str調整中單字原形.EndsWith("r"))
{
if (str調整中單字原形.EndsWith("ier"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y";
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
else if (str調整中單字原形.EndsWith("er"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
if (str調整中單字原形 == str文中單字變化形)//驗證字尾有e，直接+r
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 1, 1);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
}
}
else if (str調整中單字原形.EndsWith("t"))
{
if (str調整中單字原形.EndsWith("iest"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 4, 4) + "y";
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
else//驗證+est
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
}
else if (str調整中單字原形.EndsWith("ly"))
{
if (str調整中單字原形.EndsWith("ally"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 4, 4);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
else if (str調整中單字原形.EndsWith("ily"))//驗證去y+ily
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y";
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
else//驗證+ly
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
if (str調整中單字原形 == str文中單字變化形)//驗證-e+ly
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 2, 2) + "e";
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
}
else if (str調整中單字原形.EndsWith("ing"))
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3);
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
if (str調整中單字原形 == str文中單字變化形)
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "e";//驗證 -e+ing
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
if (str調整中單字原形 == str文中單字變化形)
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 3, 3) + "y";//驗證 -y+ing
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
if (str調整中單字原形 == str文中單字變化形)
{
if (str調整中單字原形[str調整中單字原形.Length - 4] == str調整中單字原形[str調整中單字原形.Length - 5]) //驗證 重複字尾+ing
{
str調整中單字原形 = str調整中單字原形.Remove(str調整中單字原形.Length - 4, 4); //刪除重複的字尾和ing
odCmd查字典.CommandText = "SELECT [解釋] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
str調整中單字原形 = oddr查字典.Read() ? str調整中單字原形 : str文中單字變化形;
}
}
}
}
else
{
str調整中單字原形 = str文中單字變化形;
}
#endregion 判斷單字變化型態
odCmd查字典.CommandText = "SELECT [解釋],[音標] FROM [DICT] where [單字] = '" + str調整中單字原形 + "'";
oddr查字典.Close();
oddr查字典 = odCmd查字典.ExecuteReader();
//MessageBox.Show(str調整中單字原形);
if (oddr查字典.Read())
{
odCmd查詞頻典.CommandText = "SELECT [識別碼] FROM [15000Frequency] where [word] = '" + str調整中單字原形 + "'";
oddr查詞頻典 = odCmd查詞頻典.ExecuteReader();
//hSBDegree.Value：難度，該數字與每個單字語料詞頻的排名比較，是故越大則越難（越罕見）
//識別碼是詞頻典中之PK，即每個單字語料詞頻的排名
if ((oddr查詞頻典.Read() && Int32.Parse(oddr查詞頻典["識別碼"].ToString()) >= hsb難度.Value) || !oddr查詞頻典.HasRows)
{
//把單字、中文、文章詞頻、語料詞頻排行一一放入詞頻分析表
//若在詞頻典中找不到，則其難度定為999999，使其在詞頻分析表中優先列出
//DGVResult.Rows.Add(singleWord.Key, oddr查字典["解釋"].ToString(), singleWord.Value, oddr查詞頻典.HasRows ? Int32.Parse(oddr查詞頻典["識別碼"].ToString()) : 999999);
DGVResult.Rows.Add(singleWord.Key,
oddr查字典["解釋"].ToString() + "||||" + oddr查字典["音標"],
oddr查詞頻典.HasRows ? Int32.Parse(oddr查詞頻典["識別碼"].ToString()) : 999999,
singleWord.Value);
//目前的系統需求不需計算本文詞頻，所以singleWord.Value皆以0替代
Dict各單字之雙語對照.Add(singleWord.Key, oddr查字典["解釋"].ToString() + "||||" + oddr查字典["音標"]);
}
}
oddr查字典.Close();
oddr查詞頻典.Close();
}
catch (Exception ex)
{
//MessageBox.Show(ex.Message + ex.Source + ex.TargetSite + ex.);
//oddr查字典.Close();
//oddr查詞頻典.Close();
}
progressBar.Value++;
lbDoneWordNum.Text = progressBar.Value.ToString();
this.Refresh();//每查一個詞頻就重繪表單以顯示最新進度
}
odc詞頻典連線.Close();
//詞頻分析表中預設以語料詞頻排行降冪排序，即難字排上面
DGVResult.Sort(DGVResult.Columns["Degree"], ListSortDirection.Descending);
panel1.Visible = false;
this.Enabled = true;
}
private void listViewEx1_MouseDoubleClick(object sender, MouseEventArgs e)
{
RezultateleCautarii rc = new RezultateleCautarii();
string cnp = listViewEx1.SelectedItems[0].SubItems[2].Text;
string index = listViewEx1.SelectedItems[0].SubItems[0].Text;
string[] s1 = { "Leucocite 22", "Rh 10", "Fibrinogen 17", "Timp trombina 15", "Grup sanguin 10", "Proteina S 55", "Proteina C 45" };
//bioch
string[] s2 = { "Ca ionic 7", "Ca seric 9", "Mg seric 7", "Glucoza serica 7", "Trigliceride 9", "CK 9", "Profil lipidic 28", "ADNhepatitaC 390", "ArnhepatitaB 390" };
// markeri enodocrini
string[] s4 = { "AFP 29", "Calcitonina 51", "CA125 35", "CA15-3 35", "Ca72-4 43", "SCC 44", "ACTH 36", "Cortisol 29", "Prolactina 30", "Insulina 29" };
//imun_ser
string[] s3 = { "IgA 18", "IgB 18", "ASLO 13", "ANA 55", "AMA 45", "Anticorpi_antiADN 55" };
OleDbConnection aConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MedLab_DataBase.mdb");
aConnection.Open();
OleDbCommand aCommand = new OleDbCommand("SELECT * FROM Pacienti WHERE Cnp=@cnp", aConnection);
aCommand.Parameters.Add("@cnp", OleDbType.VarChar, 100, "Cnp").Value = cnp;
OleDbDataReader myreader = aCommand.ExecuteReader(CommandBehavior.CloseConnection);
while (myreader.Read())
{
rc.textBox1.Text = myreader.GetString(1);
rc.textBox2.Text = myreader.GetString(0);
rc.textBox3.Text = myreader.GetString(4);
rc.textBox4.Text = myreader.GetString(2);
rc.textBox5.Text = myreader.GetString(3);
rc.textBox6.Text = myreader.GetString(5);
}
myreader.Close();
OleDbConnection aConnection2 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=MedLab_DataBase.mdb");
aConnection2.Open();
OleDbCommand aCommand2 = new OleDbCommand("SELECT * FROM INREGISTRARi WHERE IDCerere=@index", aConnection2);
aCommand2.Parameters.Add("@index", OleDbType.VarChar, 100, "Cnp").Value = index;
OleDbDataReader myreader2 = aCommand2.ExecuteReader(CommandBehavior.CloseConnection);
string Hemat;
string ImSer;
string Bioch;
string Mend;
myreader2.Read();
Hemat = myreader2.GetString(9);
ImSer = myreader2.GetString(10);
Bioch = myreader2.GetString(11);
Mend = myreader2.GetString(12);
rc.textBox7.Text = myreader2.GetString(7);
rc.textBox8.Text = myreader2.GetString(4);
rc.textBox9.Text = myreader2.GetString(5);
rc.textBox10.Text = myreader2.GetString(6);
Object[] obj;
int nr_crt = 0, nr = 0;
int nrH, nrB, nrIS, nrME;
nrH = nrB = nrIS = nrME = 0;
obj = new object[18];
//Console.WriteLine("nume" + myc.Nume + "\nadr" + myc.Adr + "\nhemat" + myc.Hemat + "\nbio" + myc.Bioch + "\ncnp" + myc.Cnp + "\ndanl" + myc.Danl + "\ndn" + myc.Dn + "\nemail" + myc.Email + "\nimser" + myc.ImSer + "\nmedic" + myc.Medic + "\nmend" + myc.Mend + "\nnrtel" + myc.Nrtel + "\nnrsp" + myc.Nrtel_spital + "\nsp" + myc.Spital);
int i;
for (i = 4; i < Hemat.Length; i++)
{
if (Hemat[i] != ';')
{
nr = nr * 10 + int.Parse(Hemat[i].ToString());
}
else
{
nr_crt++;
obj = new Object[3];
obj[0] = nr_crt;
obj[1] = s1[nr].Substring(0, s1[nr].IndexOf(' '));
obj[2] = " ";
rc.dataGridViewX1.Rows.Add(obj);
nr = 0;
}
}
nrH = nr_crt;
nr = 0;
//nr_crt = 0;
for (i = 4; i < Bioch.Length; i++)
{
if (Bioch[i] != ';')
{
nr = nr * 10 + int.Parse(Bioch[i].ToString());
}
else
{
nr_crt++;
obj = new Object[3];
obj[0] = nr_crt;
obj[1] = s2[nr].Substring(0, s2[nr].IndexOf(' '));
obj[2] = " ";
rc.dataGridViewX1.Rows.Add(obj);
nr = 0;
}
}
nrB = nr_crt - nrH;
nr = 0;
// nr_crt = 0;
for (i = 4; i < ImSer.Length; i++)
{
if (ImSer[i] != ';')
{
nr = nr * 10 + int.Parse(ImSer[i].ToString());
}
else
{
nr_crt++;
obj = new Object[3];
obj[0] = nr_crt;
obj[1] = s3[nr].Substring(0, s3[nr].IndexOf(' '));
obj[2] = " ";
rc.dataGridViewX1.Rows.Add(obj);
nr = 0;
}
}
nrIS = nr_crt - (nrB + nrH);
nr = 0;
//nr_crt = 0;
//nr_crt = 0;
for (i = 4; i < Mend.Length; i++)
{
if (Mend[i] != ';')
{
nr = nr * 10 + int.Parse(Mend[i].ToString());
}
else
{
nr_crt++;
obj = new Object[3];
obj[0] = nr_crt;
obj[1] = s4[nr].Substring(0, s4[nr].IndexOf(' '));
obj[2] = " ";
rc.dataGridViewX1.Rows.Add(obj);
nr = 0;
}
}
// nrME = nr_crt - (nrIS + nrH + nrB);
myreader2.Close();
rc.index = Convert.ToInt32(index);
rc.ShowDialog();
rc.Dispose();
rc.Focus();
}
private void button1_Click(object sender, EventArgs e)
{
conn = new OleDbConnection(str);
conn.Open();
//判断是否为空
if (!Py())
{
this.tabts.Text = "用户名/密码不能为空";
this.txtname.Text = "";
this.txtmi.Text = "";
this.txtyzm.Text = "";
FrmLogin_Load(null, null);
return;
}
else
{
this.tabts.Text = "";
}
string sql = "select count(UserName) from [tb_User] where UserName='******' "; //按照账号查询是否有该条
cmd = new OleDbCommand(sql, conn);
string su1 = cmd.ExecuteScalar().ToString();
if (su1 == "0") //没有输出错误并且清空
{
this.tabts.Text = "账号错误";
this.txtname.Text = "";
this.txtmi.Text = "";
this.txtyzm.Text = "";
FrmLogin_Load(null, null);
return;
}
//按照账号和密码去验证输入的账号和密码是否正确
string sql1 = "select count(UserName) from [tb_User] where UserName='******' and UserPwd='" + this.txtmi.Text + "' ";
cmd.CommandText = sql1;
string su2 = cmd.ExecuteScalar().ToString();
if (su2 == "0")//没有输出错误并且清空
{
this.tabts.Text = "密码错误";
this.txtname.Text = "";
this.txtmi.Text = "";
this.txtyzm.Text = "";
FrmLogin_Load(null, null);
return;
}
//如果全部正确 查询 账号和密码赋值到变量为传值准备
string sql2 = "select * from [tb_User] where UserName='******' and UserPwd='" + this.txtmi.Text + "' ";
cmd.CommandText = sql2;
dr = cmd.ExecuteReader();
if (dr.Read())
{
uspss = dr["UserPwd"].ToString();
usmen = dr["UserName"].ToString();
}
dr.Close();
conn.Close();
//验证验证码是否正确
if (this.labyzm.Text != this.txtyzm.Text)
{
this.tabts.Text = "验证码错误";
this.txtname.Text = "";
this.txtmi.Text = "";
this.txtyzm.Text = "";
FrmLogin_Load(null, null);
return;
}
//new 到主窗口
FrmMain f1 = new FrmMain(s);
FrmMain.ry = usmen;
this.Hide();
f1.ShowDialog();
this.Dispose();
}
protected async void Unnamed6_Click(object sender, EventArgs e)
{
int for_danger = 0;
if (Names.Text == "")
{
Response.Write("<script>alert('Все поля должны быть заполнены!');</script>");
return;
}
if (Email.Text == "")
{
Response.Write("<script>alert('Все поля должны быть заполнены!');</script>");
return;
}
if (Login.Text == "")
{
Response.Write("<script>alert('Все поля должны быть заполнены!');</script>");
return;
}
if (Password.Text == "")
{
Response.Write("<script>alert('Все поля должны быть заполнены!');</script>");
return;
}
if (ConfirmPassword.Text == "")
{
Response.Write("<script>alert('Все поля должны быть заполнены!');</script>");
return;
}
if (for_danger == 0)
{
SqlConnection = new OleDbConnection(connectString);
await SqlConnection.OpenAsync();
OleDbDataReader sqlReader = null;
OleDbCommand command = new OleDbCommand("INSERT INTO [Пользователи] ([ФИО],[Адрес электронной почты],[Пароль],Логин,Статус)VALUES(@1,@2,@3,@4,@5)", SqlConnection);
command.Parameters.AddWithValue("@1", Names.Text);
command.Parameters.AddWithValue("@2", Email.Text);
command.Parameters.AddWithValue("@3", Password.Text);
command.Parameters.AddWithValue("@4", Login.Text);
command.Parameters.AddWithValue("@5", "Ученик");
OleDbCommand command1 = new OleDbCommand("SELECT * FROM [Пользователи]", SqlConnection);
sqlReader = command1.ExecuteReader();
while (sqlReader.Read())
{
if (Login.Text == Convert.ToString(sqlReader["Логин"]))
{
Response.Write("<script>alert('Пользователь с таким логином заргестрирован');</script>");
return;
}
}
sqlReader.Close();
await command.ExecuteNonQueryAsync();
string for_id = "1";
command = new OleDbCommand("SELECT * FROM [Пользователи]", SqlConnection);
sqlReader = command.ExecuteReader();
while (sqlReader.Read())
{
if (Login.Text == Convert.ToString(sqlReader["Логин"]))
{
for_id = Convert.ToString(sqlReader["Код"]);
}
}
Response.Redirect("~/Default_page_past.aspx?userID=" + for_id, false);
return;
}
}
private void ReceiveClientMessage(Socket ClientSocket)
{
string USERID = "";
while (true)
{
string ClientMessagePackage = "";
try
{
byte[] MessageBuffer = new byte[ClientSocket.ReceiveBufferSize - 1];
int MessageBufferSize = ClientSocket.Receive(MessageBuffer);
ClientMessagePackage = Encoding.UTF8.GetString(MessageBuffer, 0, MessageBufferSize);
}
catch (ThreadAbortException) { return; }
catch (Exception ex)
{
UnityModule.DebugPrint("接收客户端消息时遇到错误：{0}", ex.Message);
UserSignOut(USERID, ref ClientSocket);
UnityModule.DebugPrint("用户 {0} 异常下线，当前在线总数：{1}", USERID, SocketsDictionary.Count.ToString());
return;
}
string[] ClientMessages = ClientMessagePackage.Split('\n');
foreach (string TempClientMessage in ClientMessages)
{
try
{
if (string.IsNullOrEmpty(TempClientMessage))
{
continue;
}
string ClientMessage = TempClientMessage + '\n';
UnityModule.DebugPrint("收到客户端发送来的数据：{0}", ClientMessage);
string MessagePattern = ProtocolFormatter.GetCMDTypePattern();
Regex MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline);
Match MessageMatchResult = MessageRegex.Match(ClientMessage);
string cmdType = MessageMatchResult.Groups["CMDTYPE"].Value.ToUpper();
switch (cmdType)
{
case "CHATMESSAGE":
{
MessagePattern = ProtocolFormatter.GetProtocolPattern(ProtocolFormatter.CMDType.ChatMessage);
MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline);
MessageMatchResult = MessageRegex.Match(ClientMessage);
string ToID = MessageMatchResult.Groups["TOID"].Value;
string Message = MessageMatchResult.Groups["MESSAGE"].Value;
UnityModule.DebugPrint("消息来自:{0} 发送给:{1} 内容:{2}", USERID, ToID, Encoding.UTF8.GetString(Convert.FromBase64String(Message)));
//判断对方是否连接
if (SocketsDictionary.ContainsKey(ToID))
{
string MessageID = null;
UnityDBController.ExecuteNonQuery("INSERT INTO CHATBASE (FromID,ToID,ChatTime,Message,SentYet) VALUES ('{0}','{1}','{2}','{3}',YES)", USERID, ToID, DateTime.UtcNow, Message);
MessageID = UnityDBController.ExecuteScalar("SELECT MAX(ID) FROM CHATBASE WHERE FROMID='{0}'\n", USERID).ToString();
SocketsDictionary[ToID].Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.ChatMessage, USERID, DateTime.UtcNow.ToString(), MessageID, Message)));
}
else
{
UnityDBController.ExecuteNonQuery("INSERT INTO CHATBASE (FromID,ToID,ChatTime,Message,SentYet) VALUES ('{0}','{1}','{2}','{3}',NO)", USERID, ToID, DateTime.UtcNow, Message);
}
break;
}
case "GETCHATHISTORY":
{
//TODO:获取历史聊天记录
break;
}
case "SIGNIN":
{
//用户登录消息
MessagePattern = ProtocolFormatter.GetProtocolPattern(ProtocolFormatter.CMDType.SignIn);
MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline);
MessageMatchResult = MessageRegex.Match(ClientMessage);
string UserID = MessageMatchResult.Groups["USERID"].Value;
string Password = MessageMatchResult.Groups["PASSWORD"].Value;
object CheckUserID = UnityDBController.ExecuteScalar("SELECT UserID FROM UserBase WHERE UserID='{0}' AND Password='******';", UserID, Password);
if (CheckUserID != null)
{
//用户登陆成功！
UnityModule.DebugPrint("用户登录成功！{0}", CheckUserID as string);
ClientSocket.Send(Encoding.ASCII.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.SignInSuccessfully, CheckUserID as string)));
}
else
{
//用户发生一次错误的密码验证！
UnityModule.DebugPrint("用户登录失败！{0}", UserID);
ClientSocket.Send(Encoding.ASCII.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.SignInUnsuccessfully, UserID as string)));
}
//验证成功后关闭Socket
ClientSocket?.Close();
//验证完成后需要结束接收消息线程
return;
}
case "WHOAMI":
{
MessagePattern = ProtocolFormatter.GetProtocolPattern(ProtocolFormatter.CMDType.WhoAmI);
MessageRegex = new Regex(MessagePattern, RegexOptions.IgnoreCase | RegexOptions.Singleline);
MessageMatchResult = MessageRegex.Match(ClientMessage);
USERID = MessageMatchResult.Groups["USERID"].Value;
if (SocketsDictionary.ContainsKey(USERID))
{
UnityModule.DebugPrint("用户 {0} 已经在 {1} 登录，即将被顶下线...", USERID, SocketsDictionary[USERID].RemoteEndPoint.ToString());
Socket TempSocket = SocketsDictionary[USERID];
TempSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.AnothorSignIn, USERID)));
Thread TempThread = ReceiveThreadDictionary[TempSocket.RemoteEndPoint.ToString()];
ReceiveThreadDictionary.Remove(TempSocket.RemoteEndPoint.ToString());
TempThread.Abort();
SocketsDictionary.Remove(USERID);
TempSocket?.Close();
}
//以USERID为KEY，记录Socket
SocketsDictionary.Add(USERID, ClientSocket);
//好友登录
UserSignIn(USERID, ref ClientSocket);
UnityModule.DebugPrint("用户 {0} 在 {1} 上线，当前在线总数：{2}", USERID, ClientSocket.RemoteEndPoint.ToString(), SocketsDictionary.Count.ToString());
break;
}
case "GETFRIENDSLIST":
{
OleDbDataReader FriendsListReader = UnityDBController.ExecuteReader("SELECT UserID,NickName,Signature,OnLine FROM UserBase WHERE UserID IN(SELECT Guest FROM FriendBase WHERE Host ='{0}')", USERID);
if (FriendsListReader != null && FriendsListReader.HasRows)
{
while (FriendsListReader.Read())
{
string FriendID = null;
string NickName = null;
string Signature = null;
bool OnLine = false;
try
{
FriendID = FriendsListReader["UserID"] as string; //??""很重要，否则封装协议消息时会因为string类型变量为引用而出错
NickName = FriendsListReader["NickName"] as string ?? "(无昵称)";
Signature = FriendsListReader["Signature"] as string ?? "(无签名)";
OnLine = (bool)FriendsListReader["OnLine"];
}
catch (Exception ex)
{
UnityModule.DebugPrint("读取用户{0}的好友{1}信息时遇到错误：{2}", USERID, FriendID, ex.Message);
}
ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.GetFriendsList, FriendID, NickName, Signature, OnLine.ToString().ToUpper())));
}
}
FriendsListReader.Close();
//发送[好友列表发送完成]消息
ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.FriendsListComplete, USERID)));
break;
}
case "GETMESSAGENOTSENDYET":
{
OleDbDataReader MessageNRYReader = UnityDBController.ExecuteReader("SELECT * FROM ChatBase WHERE ToID ='{0}' AND SentYet = NO", USERID);
if (MessageNRYReader != null && MessageNRYReader.HasRows)
{
List <string> MessageIDList = new List <string>();
while (MessageNRYReader.Read())
{
string MessageID = null;
string FromID = null;
string ChatTime = null;
string ChatMessage = null;
try
{
MessageID = MessageNRYReader["ID"].ToString();
FromID = MessageNRYReader["FromID"] as string;
ChatTime = ((DateTime)MessageNRYReader["ChatTime"]).ToString();
ChatMessage = MessageNRYReader["Message"] as string;
MessageIDList.Add(MessageID);
}
catch (Exception ex)
{
UnityModule.DebugPrint("读取消息ID{0}时遇到错误：{2}", MessageID, ex.Message);
}
ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.ChatMessage, FromID, ChatTime, MessageID, ChatMessage)));
}
MessageNRYReader?.Close();
foreach (string messageID in MessageIDList)
{
UnityDBController.ExecuteNonQuery("UPDATE ChatBase SET SentYet = YES WHERE ID = {0}", messageID);
}
}
MessageNRYReader?.Close();
//发送[暂存消息发送完成]消息
ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.MessageNSYComplete, USERID)));
break;
}
case "SIGNOUT":
{
UserSignOut(USERID, ref ClientSocket);
UnityModule.DebugPrint("用户 {0} 正常下线，当前在线总数：{1}", USERID, SocketsDictionary.Count.ToString());
return;
}
default:
{
UnityModule.DebugPrint("遇到未知消息：{0}", ClientMessage);
ClientSocket.Send(Encoding.UTF8.GetBytes(ProtocolFormatter.FormatProtocol(ProtocolFormatter.CMDType.ChatMessage,
UnityModule.ServerNickName, DateTime.UtcNow.ToString(), "0", Convert.ToBase64String(Encoding.UTF8.GetBytes("服务端收到你发来未知的CMDTYPE：" + cmdType + " 消息原文：" + ClientMessage)))));
break;
}
}
}
catch (ThreadAbortException) { return; }
catch (Exception ex)
{
UnityModule.DebugPrint("分析并回应用户消息时发生错误：{0}", ex.Message);
}
}
}
}
protected void addColumnButton_Click(object sender, EventArgs e)
{
if (perm == "admin")
{
try
{
List <string> columnNames = new List <string>();
string tempAdder = String.Empty;
string userID = String.Empty;
assetsConn.Open();
assetsCmd.Connection = assetsConn;
assetsCmd.CommandText = "SELECT * FROM People";
OleDbDataReader dr = assetsCmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
columnNames.Add(dr.GetName(i));
}
dr.Close();
assetsConn.Close();
if (columnNames.Count <= 12)
{
assetsConn.Open();
assetsCmd.Connection = assetsConn;
assetsCmd.CommandText = "ALTER TABLE People ADD " + columnBox.Text + " string";
assetsCmd.ExecuteNonQuery();
assetsConn.Close();
assetsCmd.Parameters.Clear();
}
usersConn.Open();
usersCmd.CommandText = "SELECT ID FROM Users WHERE Login = @login";
usersCmd.Parameters.AddWithValue("@login", HttpContext.Current.User.Identity.Name);
userID = usersCmd.ExecuteScalar().ToString();
usersCmd.Parameters.Clear();
usersConn.Close();
Scripts.OperationLogCreator op = new Scripts.OperationLogCreator();
op.OperationLog("UserID: " + userID + " || Operacja wykonana: dodanie pola opisowego: " + columnBox.Text + " do tabeli People");
ClearTextBoxes();
}
catch (Exception exc)
{
Scripts.ErrorLogCreator err = new Scripts.ErrorLogCreator();
err.ErrorLog(exc.Message);
errorLabel.Text = "Błąd! " + exc.Message;
}
finally
{
assetsConn.Close();
usersConn.Close();
}
}
}
// Display the result set recursively expanding chapterDepth deep
static void DisplayReader(OleDbDataReader myDataReader, ref uint count, uint alignment, int chapterDepth)
{
try
{
// compute alignment
StringBuilder indent = new StringBuilder((int)alignment);
indent.Append(' ', (int)alignment);
while (myDataReader.Read())
{
// add alignment
StringBuilder row = new StringBuilder(indent.ToString());
// for all columns
for (int i = 0; i < myDataReader.FieldCount; i++)
{
// null columns
if (myDataReader.IsDBNull(i))
{
row.Append("NULL;");
}
else
{
//vector columns
object[] myArray = myDataReader.GetValue(i) as object[];
if (myArray != null)
{
DisplayValue(myArray, row);
}
else
{
//check for chapter columns from "group on" queries
if (myDataReader.GetFieldType(i).ToString() != "System.Data.IDataReader")
{
//regular columns are displayed here
row.Append(myDataReader.GetValue(i));
}
else
{
//for a chapter column type just display the colum name
row.Append(myDataReader.GetName(i));
}
}
row.Append(';');
}
}
if (chapterDepth >= 0)
{
Console.WriteLine(row);
count++;
}
// for each chapter column
for (int i = 0; i < myDataReader.FieldCount; i++)
{
if (myDataReader.GetFieldType(i).ToString() == "System.Data.IDataReader")
{
OleDbDataReader Reader = myDataReader.GetValue(i) as OleDbDataReader;
DisplayReader(Reader, ref count, alignment + 8, chapterDepth - 1);
}
}
}
}
finally
{
myDataReader.Close();
myDataReader.Dispose();
}
}
protected void updateButton_Click(object sender, EventArgs e)
{
if (perm == "admin")
{
try
{
List <string> columnNames = new List <string>();
String[] values;
string tempAdder = String.Empty;
string userID = String.Empty;
int counter = 2;
int maxCounter = 0;
assetsConn.Open();
assetsCmd.Connection = assetsConn;
assetsCmd.CommandText = "SELECT * FROM People";
OleDbDataReader dr = assetsCmd.ExecuteReader();
for (int i = 0; i < dr.FieldCount; i++)
{
columnNames.Add(dr.GetName(i));
}
values = DescriptionBox.Text.Split(';');
maxCounter = columnNames.Count;
dr.Close();
assetsConn.Close();
for (int i = 2; i < maxCounter; i++)
{
if (i == maxCounter - 1)
{
tempAdder += columnNames[i] + " = @v" + (i - 1) + " ";
}
else
{
tempAdder += columnNames[i] + " = @v" + (i - 1) + ", ";
}
}
assetsConn.Open();
if (UserNameBox.Text == String.Empty && DescriptionBox.Text != String.Empty)
{
assetsCmd.CommandText = "UPDATE People SET " + tempAdder + "WHERE ID = @id";
}
else
{
assetsCmd.CommandText = "UPDATE People SET " + columnNames[1] + " = @v0, " + tempAdder + "WHERE ID = @id";
}
assetsCmd.Parameters.AddWithValue("@v0", UserNameBox.Text);
for (int i = 1; i < (maxCounter - 1); i++)
{
string v = "@v" + i;
if (counter < maxCounter && values.Length == columnNames.Count - 2)
{
assetsCmd.Parameters.AddWithValue(v, values[counter - 2]);
counter++;
}
else if (counter < maxCounter && values.Length < columnNames.Count - 2)
{
if (counter - 2 < values.Length)
{
assetsCmd.Parameters.AddWithValue(v, values[counter - 2]);
}
else
{
assetsCmd.Parameters.AddWithValue(v, String.Empty);
}
counter++;
}
else if (counter < maxCounter && values.Length > columnNames.Count - 2)
{
if (counter - 2 < columnNames.Count - 2)
{
assetsCmd.Parameters.AddWithValue(v, values[counter - 2]);
}
counter++;
}
}
assetsCmd.Parameters.AddWithValue("@id", IDBox.Text);
assetsCmd.ExecuteNonQuery();
assetsConn.Close();
assetsCmd.Parameters.Clear();
usersConn.Open();
usersCmd.CommandText = "SELECT ID FROM Users WHERE Login = @login";
usersCmd.Parameters.AddWithValue("@login", HttpContext.Current.User.Identity.Name);
userID = usersCmd.ExecuteScalar().ToString();
usersCmd.Parameters.Clear();
usersConn.Close();
Scripts.OperationLogCreator op = new Scripts.OperationLogCreator();
op.OperationLog("UserID: " + userID + " || Operacja wykonana: aktualizacja danych o użytkowniku z ID: " + IDBox.Text + " w tabeli People");
ClearTextBoxes();
}
catch (Exception exc)
{
Scripts.ErrorLogCreator err = new Scripts.ErrorLogCreator();
err.ErrorLog(exc.Message);
errorLabel.Text = "Błąd! " + exc.Message;
}
finally
{
assetsConn.Close();
usersConn.Close();
}
}
}
public void createBalanza()
{
string strAccessConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=database\\" + this.databaseFileName;
string strAccessSelect = "SELECT * FROM [Add Acumulados] INNER JOIN [CatalogoCuentasSatVendor] ON [Add Acumulados].[SUBCTA] = [CatalogoCuentasSatVendor].[NumCta]";
DataSet myDataSet = new DataSet();
OleDbConnection myAccessConn = null;
try
{
myAccessConn = new OleDbConnection(strAccessConn);
}
catch (Exception ex)
{
Console.WriteLine("Error: Failed to create a database connection. \n{0}", ex.Message);
return;
}
try
{
myAccessConn.Open();
OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn);
OleDbDataReader reader = myAccessCommand.ExecuteReader();
List <SatContabilidad.Balanza.BalanzaCtas> balanzaCtas = new List <SatContabilidad.Balanza.BalanzaCtas>();
while (reader.Read())
{
SatContabilidad.Balanza.BalanzaCtas balanzaCta = new Balanza.BalanzaCtas();
balanzaCta.NumCta = reader["SUBCTA"].ToString().Trim();
balanzaCta.SaldoIni = 0;
balanzaCta.Debe = Decimal.Parse(reader["MOVDEB"].ToString());
balanzaCta.Haber = Decimal.Parse(reader["MOVHAB"].ToString());
balanzaCta.SaldoFin = balanzaCta.Haber - balanzaCta.Debe;
balanzaCtas.Add(balanzaCta);
}
reader.Close();
myAccessConn.Close();
SatContabilidad.Balanza.Balanza balanza = new Balanza.Balanza();
balanza.TipoEnvio = "N";
balanza.schemaLocation = "www.sat.gob.mx/esquemas/ContabilidadE/1_1/BalanzaComprobacion http://www.sat.gob.mx/esquemas/ContabilidadE/1_1/BalanzaComprobacion/BalanzaComprobacion_1_1.xsd";
balanza.Anio = int.Parse(this.year);
balanza.Ctas = balanzaCtas.ToArray <Balanza.BalanzaCtas>();
Type mes = typeof(Balanza.BalanzaMes);
balanza.Mes = (Balanza.BalanzaMes)Enum.Parse(mes, (int.Parse(this.month) - 1).ToString());
balanza.RFC = this.rfc;
XmlSerializer serializer = new XmlSerializer(typeof(SatContabilidad.Balanza.Balanza));
System.IO.TextWriter writer = new System.IO.StreamWriter(this.outputPath + this.rfc + this.year + this.month + "BN.xml");
XmlSerializerNamespaces ns = new XmlSerializerNamespaces();
ns.Add("BCE", "www.sat.gob.mx/esquemas/ContabilidadE/1_1/BalanzaComprobacion");
ns.Add("xsi", "http://www.w3.org/2001/XMLSchema-instance");
serializer.Serialize(writer, balanza, ns);
}
catch (Exception ex)
{
Console.WriteLine("Error: Failed to retrive the required data from the Database.\n{0}", ex.Message);
return;
}
finally
{
myAccessConn.Close();
}
}
// my Functions
// for checking whether Control Exist or not
private bool isControlExist()
{
bool ret = false;
string Qry = "select * from Column_Tab where Clm_Name ='" + txtCntlrName.Text + "';";
if (cmbCntrlType.Text == "Column")
{
Qry = "select * from Column_Tab where Clm_Name ='" + txtCntlrName.Text + "';";
}
else if (cmbCntrlType.Text == "Beam")
{
Qry = "select * from Beam_Tab where Bm_Name ='" + txtCntlrName.Text + "';";
}
else if (cmbCntrlType.Text == "Wall")
{
Qry = "select * from Wall_Tab where Wl_Name ='" + txtCntlrName.Text + "';";
}
else if (cmbCntrlType.Text == "Window" || cmbCntrlType.Text == "Door")
{
Qry = "select * from Window_Tab where Win_Name ='" + txtCntlrName.Text + "';";
}
else if (cmbCntrlType.Text == "Base")
{
Qry = "select * from Base_Tab where BS_Name ='" + txtCntlrName.Text + "';";
}
else if (cmbCntrlType.Text == "Roof")
{
Qry = "select * from Roof_Tab where Rf_Name ='" + txtCntlrName.Text + "';";
}
try
{
OleDbConnection con = new OleDbConnection(ConStr);
OleDbCommand cmd = new OleDbCommand(Qry, con);
con.Open();
OleDbDataReader Dr = null;
Dr = cmd.ExecuteReader();
if (Dr.HasRows)
{
while (Dr.Read())
{
EdtCntrl = Dr.GetString(1);
ret = true;
}
}
else
{
MessageBox.Show("there is no such " + cmbCntrlType.Text, "Information", MessageBoxButtons.OK);
}
if (Dr != null)
{
Dr.Close();
}
if (con != null)
{
con.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "ERROR", MessageBoxButtons.OK);
}
return(ret);
}
public void createPolizasPeriodo()
{
string strAccessConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=database\\" + this.databaseFileName;
string strAccessSelect = "SELECT * FROM [Apuntes_Polizas_Import]";
DataSet myDataSet = new DataSet();
OleDbConnection myAccessConn = null;
try
{
myAccessConn = new OleDbConnection(strAccessConn);
}
catch (Exception ex)
{
Console.WriteLine("Error: Failed to create a database connection. \n{0}", ex.Message);
return;
}
try
{
myAccessConn.Open();
OleDbCommand myAccessCommand = new OleDbCommand(strAccessSelect, myAccessConn);
OleDbDataReader reader = myAccessCommand.ExecuteReader();
List <SatContabilidad.Polizas.PolizasPoliza> polizas = new List <SatContabilidad.Polizas.PolizasPoliza>();
while (reader.Read())
{
SatContabilidad.Polizas.PolizasPoliza poliza = new SatContabilidad.Polizas.PolizasPoliza();
List <SatContabilidad.Polizas.PolizasPolizaTransaccion> transacciones = new List <Polizas.PolizasPolizaTransaccion>();
SatContabilidad.Polizas.PolizasPolizaTransaccion transaccion = new Polizas.PolizasPolizaTransaccion();
List <SatContabilidad.Polizas.PolizasPolizaTransaccionOtrMetodoPago> otrosMetodosdePago = new List <Polizas.PolizasPolizaTransaccionOtrMetodoPago>();
Polizas.PolizasPolizaTransaccionOtrMetodoPago otroMetodoPago = new Polizas.PolizasPolizaTransaccionOtrMetodoPago();
switch (reader["MONEDA"].ToString())
{
case "DL":
otroMetodoPago.Moneda = SatContabilidad.Polizas.c_Moneda.USD;
otroMetodoPago.TipCamb = Decimal.Parse(reader["CAMAPU"].ToString());
otroMetodoPago.TipCambSpecified = true;
break;
default:
otroMetodoPago.Moneda = SatContabilidad.Polizas.c_Moneda.MXN;
otroMetodoPago.TipCambSpecified = false;
break;
}
otroMetodoPago.MonedaSpecified = true;
otroMetodoPago.Monto = Decimal.Parse(reader["IMPAPU"].ToString());
otroMetodoPago.RFC = this.rfc;
otrosMetodosdePago.Add(otroMetodoPago);
transaccion.OtrMetodoPago = otrosMetodosdePago.ToArray <SatContabilidad.Polizas.PolizasPolizaTransaccionOtrMetodoPago>();
transacciones.Add(transaccion);
poliza.Transaccion = transacciones.ToArray <SatContabilidad.Polizas.PolizasPolizaTransaccion>();
polizas.Add(poliza);
}
reader.Close();
myAccessConn.Close();
SatContabilidad.Polizas.Polizas polizasLast = new SatContabilidad.Polizas.Polizas();
polizasLast.schemaLocation = "www.sat.gob.mx/esquemas/ContabilidadE/1_1/CatalogoCuentas/CatalogoCuentas_1_1.xsd";
polizasLast.Anio = int.Parse(this.year);
Type mes = typeof(Polizas.PolizasMes);
polizasLast.Mes = (Polizas.PolizasMes)Enum.Parse(mes, (int.Parse(this.month) - 1).ToString());
polizasLast.Poliza = polizas.ToArray <SatContabilidad.Polizas.PolizasPoliza>();
polizasLast.RFC = this.rfc;
XmlSerializer serializer = new XmlSerializer(typeof(SatContabilidad.Polizas.Polizas));
System.IO.TextWriter writer = new System.IO.StreamWriter(this.outputPath + this.rfc + this.year + this.month + "PL.xml");
serializer.Serialize(writer, polizasLast);
}
catch (Exception ex)
{
Console.WriteLine("Error: Failed to retrive the required data from the Database.\n{0}", ex.Message);
return;
}
finally
{
myAccessConn.Close();
}
}
private void ToolStripTextBox1_TextChanged(object sender, EventArgs e)
{
baglanti();
DataGridView1.Rows.Clear();
if (ToolStripTextBox1.Text.Length < 1)
{
ToolStripTextBox1.BackColor = Color.DarkRed;
}
else
{
ToolStripTextBox1.BackColor = Color.LimeGreen;
}
if (StokKoduToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE StokKodu LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (CinsiToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Cinsi LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (BirimiToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Birimi LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (SınıfıToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Sinifi LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (GrubuToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Grubu LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (RafNumarasıToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE RafNo LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (GözNumarasıToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE GozNo LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (AçıklamaToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Aciklama LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
if (FiyatToolStripMenuItem.Checked)
{
DataGridView1.Rows.Clear();
OleDbCommand cmd = new OleDbCommand("SELECT * FROM STOKKARTI WHERE Fiyat LIKE '%" + ToolStripTextBox1.Text + "%'", bag);
OleDbDataReader oku = cmd.ExecuteReader();
while (oku.Read())
{
DataGridView1.Rows.Add(oku[0].ToString(), oku[1].ToString(), oku[2].ToString(), oku[3].ToString(), oku[4].ToString(), oku[5].ToString(), oku[6].ToString(), oku[7].ToString(), oku[8].ToString());
}
oku.Close();
}
}
