public static Champion Mapper(MySqlDataReader r)
{
var c = new Champion();
c.Id = r.GetInt32("Id");
c.Name = r.GetString("Name");
c.Title = r.GetString("Title");
c.Stat = new Stat();
c.Stat.Mana = r.GetDouble("Mana");
c.Stat.ManaPerLv = r.GetDouble("ManaPerLevel");
c.Stat.MagicResist = r.GetDouble("MagicResist");
c.Stat.MagicResistPerLv = r.GetDouble("MagicResistPerLevel");
return c;
}
public static PyObject DBColumnToPyObject(int index, ref MySqlDataReader reader)
{
Type type = reader.GetFieldType(index);
switch (type.Name)
{
case "String":
return new PyString(reader.GetString(index));
case "UInt32":
case "Int32":
case "UInt16":
case "Int16":
case "SByte":
case "Byte":
return new PyInt(reader.GetInt32(index));
case "UInt64":
case "Int64":
return new PyLongLong(reader.GetInt64(index));
case "Byte[]":
return new PyBuffer((byte[])reader.GetValue(index));
case "Double":
return new PyFloat(reader.GetDouble(index));
case "Decimal":
return new PyFloat((double)reader.GetDecimal(index));
case "Boolean":
return new PyBool(reader.GetBoolean(index));
default:
Log.Error("Database", "Unhandled MySQL type " + type.Name);
break;
}
return null;
}
public void ChangeReviewSummary()
{
Transform starPanel = reviewSummaryPanel.GetChild(1);
Transform scorePanel = reviewSummaryPanel.GetChild(2);
//string sql = "SELECT COUNT(*), AVG(CAST(score as FLOAT)) FROM review GROUP BY productID HAVING productID = " + product.id + ";";
string sql = "SELECT COUNT(*), AVG(score) FROM review GROUP BY productID HAVING productID = " + product.id + ";";
MySql.Data.MySqlClient.MySqlDataReader reader = DbConnecter.instance.Reader(sql);
int reviewer = 0;
float score = 0;
if (reader.Read())
{
reviewer = reader.GetInt32(0);
score = (float)reader.GetDouble(1);
}
reader.Close();
DbConnecter.instance.CloseConnection();
for (int i = 0; i < 5; i++)
{
float fillAmount = Mathf.Clamp(score - i, 0, 1);
Image yellowStar = starPanel.GetChild(i).GetChild(0).GetComponent <Image>();
yellowStar.fillAmount = fillAmount;
}
Text scoreText = scorePanel.GetChild(0).GetComponent <Text>();
scoreText.text = score.ToString("0.00") + " (" + reviewer + ")";
}
public void checkApprovalNeeded()
{
conn = new MySql.Data.MySqlClient.MySqlConnection(ConnString);
conn.Open();
double count = 0;
double item_price;
double qty;
double policy_amount;
//try
//{
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM item where reqid='" + tb_reqid.Text + "' ";
reader = cmd.ExecuteReader();
while (reader.Read())
{
item_price = reader.GetDouble("item_price");
qty = reader.GetDouble("quantity");
count = count + (item_price * qty);
}
conn.Close();
conn.Open();
cmdd = conn.CreateCommand();
cmdd.CommandText = "SELECT * FROM policy where policy_name='Requisition Approval'";
reader1 = cmdd.ExecuteReader();
if (reader1.Read())
{
policy_amount = reader1.GetDouble("amount");
if (count < policy_amount)
{
imgbtn_assignedto.Enabled = false;
System.Diagnostics.Debug.WriteLine(count);
System.Diagnostics.Debug.WriteLine("Hellooo");
}
}
conn.Close();
//}
//catch (Exception ex)
//{
// Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Fisrt add the items');</script>");
//}
}
public static ProjekcijaDTO readerToProjekcijaDTO(MySqlDataReader reader,FilmDTO film)
{
ProjekcijaDTO projekcija = new ProjekcijaDTO();
projekcija.Id = reader.GetInt32("idProjekcija");
projekcija.Vrijeme = reader.GetDateTime("vrijemeProjekcija");
projekcija.Cijena = reader.GetDouble("cijenaProjekcija");
projekcija.Film =film;
projekcija.Sala = MySqlSalaDAO.readerToSalaDTO(reader);
return projekcija;
}
public static ProjekcijaDTO readerToProjekcijaDTO(MySqlDataReader reader, SalaDTO sala)
{
ProjekcijaDTO projekcija = new ProjekcijaDTO();
projekcija.Id = reader.GetInt32("idProjekcija");
projekcija.Vrijeme = reader.GetDateTime("vrijemeProjekcija");
projekcija.Cijena = reader.GetDouble("cijenaProjekcija");
projekcija.Film = new MySqlFilmDAO().getById(reader.GetInt32("idFilm"));
projekcija.Sala = sala;
return projekcija;
}
public FinanceiroType execReader(MySqlDataReader dr)
{
FinanceiroType type = new FinanceiroType();
type.IdFinanceiro = Convert.ToInt32(dr["id_financeiro"].ToString());
type.IdAssociacao = Convert.ToInt32(dr["id_associacao"].ToString());
type.Titulo = dr["titulo"].ToString();
type.Valor = dr.GetDouble("valor");
type.Data = dr["data"].ToString();
type.Tipo = dr["tipo"].ToString();
return type;
}
public static StavkaOtpremniceDTO readerToStavkaOtpremniceDTO(MySqlDataReader reader)
{
StavkaOtpremniceDTO stavka = new StavkaOtpremniceDTO();
stavka.Kolicina = reader.GetDouble("Kolicina");
stavka.VeleprodajnaCijena = reader.GetDouble("VeleprodajnaCijena");
stavka.Rabat = reader.GetDouble("Rabat");
stavka.CijenaSaRabatom = reader.GetDouble("CijenaSaRabatom");
stavka.IznosSaRabatom = reader.GetDouble("IznosSaRabatom");
stavka.VeleprodajniIznos = reader.GetDouble("VeleprodajniIznos");
return stavka;
}
protected void update(object sender, GridViewUpdateEventArgs e)
{
int id = Convert.ToInt32(GridView1.DataKeys[e.RowIndex].Value.ToString());
string name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("salIncrease")).Text;
int empid = Convert.ToInt32(((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtempid")).Text);
conn = new MySql.Data.MySqlClient.MySqlConnection(constr);
conn.Open();
data = "select Salary from hr.hire_emp where EmployeeID = '" + empid + "'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(data, conn);
reader = cmd.ExecuteReader();
reader.Read();
double s = Convert.ToDouble(name);
double sal = reader.GetDouble(0);
//double x = Convert.ToDouble(sal);
conn.Close();
conn.Open();
double sum = sal + s;
data = "update hr.hire_emp set salary = '" + sum + "' where EmployeeID = '" + empid + "'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(data, conn);
cmd.ExecuteNonQuery();
conn.Close();
//TextBox1.Text = name;
//conn = new MySql.Data.MySqlClient.MySqlConnection(constr);
//conn.Open();
//data = "update training set training_name = '" + name + "' ,start_date = '" + stdate + "' ,end_date = '" + enddate + "' ,train_time = '" + tr_time + "' where training_id = '" + id + "';";
//cmd = new MySql.Data.MySqlClient.MySqlCommand(data, conn);
//cmd.ExecuteNonQuery();
//conn.Close();
GridView1.EditIndex = -1;// no row in edit mode
GetData();
}
public void WriteReview(int amount)
{
int productID = 1;
for (int i = 0; i < amount; i++)
{
string email = "changyeong" + i;
int score = UnityEngine.Random.Range(1, 6);
int first = UnityEngine.Random.Range(0, 5);
int second = UnityEngine.Random.Range(0, 6);
int third = UnityEngine.Random.Range(0, 3);
int fourth = UnityEngine.Random.Range(0, 6);
int fifth = UnityEngine.Random.Range(0, 5);
string sql = "SELECT productReviews FROM member WHERE email = '" + email + "';";
MySql.Data.MySqlClient.MySqlDataReader reader = DbConnecter.instance.Reader(sql);
reader.Read();
string productReviews = "";
if (reader.IsDBNull(0) == false)
{
productReviews = reader.GetString(0);
}
reader.Close();
productReviews = productReviews + productID + ';';
sql = "INSERT INTO review VALUES(" + "'" + email + "', " + productID + ", " + score + ", " + first + ", " + second + ", " + third + ", " + fourth + ", " + fifth + ");";
DbConnecter.instance.ExecuteSQL(sql, false);
sql = "UPDATE member SET productReviews = '" + productReviews + "' WHERE email = '" + email + "';";
DbConnecter.instance.ExecuteSQL(sql, false);
sql = "SELECT COUNT(*), AVG(CAST(score as FLOAT)) FROM review GROUP BY productID HAVING productID = " + productID + ";";
reader = DbConnecter.instance.Reader(sql);
reader.Read();
int reviewer = reader.GetInt32(0);
float grade = (float)reader.GetDouble(1);
reader.Close();
sql = "UPDATE product SET grade = " + grade + ", reviewer = " + reviewer + " WHERE id = " + productID + ";";
DbConnecter.instance.ExecuteSQL(sql, true);
DbConnecter.instance.CloseConnection();
Debug.Log(i);
}
}
public List<string> Unique_GetListOfIds(string table)
{
List<string> idList = new List<string>();
cmd = new MySqlCommand("SELECT distinct(id) FROM " + Database + "." + table, connection);
reader = cmd.ExecuteReader();
while (reader.Read())
{
idList.Add(reader.GetDouble(0).ToString());
}
reader.Close();
return idList;
}
protected ProductDetail getProductDetailFromDataReader(MySqlDataReader datareader)
{
ProductDetail productDetail = new ProductDetail
{
detailId = datareader.GetInt32("detailID"),
verkoopprijs = datareader.GetDouble("verkoopprijs"),
inkoopprijs = datareader.GetDouble("inkoopprijs"),
maatId = datareader.GetInt32("maatId"),
voorraad = datareader.GetInt32("voorraad"),
};
return productDetail;
}
public static Rune Mapper(MySqlDataReader reader)
{
var r = new Rune();
r.Id = reader.GetInt32("Id");
r.Name = reader.GetString("Name");
r.Ap = reader.GetDouble("Ap");
r.ApPerLevel = reader.GetDouble("ApPerLevel");
r.Mana = reader.GetDouble("Mana");
r.ManaPerLevel = reader.GetDouble("ManaPerLevel");
r.MagicResist = reader.GetDouble("MagicResist");
r.MagicResistPerLevel = reader.GetDouble("MagicResistPerLevel");
r.MagicPenetrationFlat = reader.GetDouble("MagicPenetrationFlat");
return r;
}
protected void btn_Assign_Click(object sender, EventArgs e)
{
conn = new MySql.Data.MySqlClient.MySqlConnection(ConnString);
try
{
//check whether all the fields are not null
bool fieldsReq = RequiredFieldValidate();
if (fieldsReq)
{
String listOfItemsnqty = (tb_items_withqty.Text).Trim();
if (listOfItemsnqty.EndsWith(","))
{
listOfItemsnqty = listOfItemsnqty.Substring(0, listOfItemsnqty.Length - 1);
}
String[] arrayOfItemsnqty = listOfItemsnqty.Split(',');
//Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('"+ arrayOfAssignedManagers[2] + "');</script>");
String Item_name;
String Item_qty;
double count = 0;
for (int i = 0; i < arrayOfItemsnqty.Length; i++)
{
conn.Open();
try
{
Item_name = arrayOfItemsnqty[i].Split('-')[0].Trim();
Item_qty = arrayOfItemsnqty[i].Split('-')[1].Trim();
System.Diagnostics.Debug.WriteLine(Item_name);
System.Diagnostics.Debug.WriteLine(Item_qty);
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM all_items where item_name='" + Item_name + "' ";
reader = cmd.ExecuteReader();
if (reader.Read())
{
hiiden_description.Text = reader.GetString("description");
hidden_itemprice.Text = reader.GetString("item_price");
hidden_uom.Text = reader.GetString("uom");
hidden_supplier.Text = reader.GetString("supplier");
hidden_sup_email.Text = reader.GetString("supplier_email");
}
conn.Close();
//Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('"+ hiiden_designation.Text + "');</script>");
conn.Open();
queryStr = "insert into item (item_name,description,uom,item_price,quantity,supplier,supplier_email,reqid) values ('" + Item_name.Trim() + "','" + hiiden_description.Text + "','" + hidden_uom.Text + "','" + Convert.ToDouble(hidden_itemprice.Text) + "','" + Convert.ToDouble(Item_qty) + "','" + hidden_supplier.Text + "','" + hidden_sup_email.Text + "','" + Convert.ToInt32(tb_reqid.Text) + "')";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
cmd.ExecuteNonQuery();
conn.Close();
Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Succesfully Inserted.! ');</script>");
conn.Close();
count = count + (Convert.ToDouble(hidden_itemprice.Text) * Convert.ToDouble(Item_qty));
}
catch
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('failed');</script>");
}
}
//queryStr = "insert into assigned_employee (name,designation,email,reqid) values ('" + tb_expenseid.Text + "','" + tb_expensedate.Text + "','" + Convert.ToString(list_expensetype.SelectedValue) + "','" + tb_expensedescription.Text + "','" + tb_expenseamount.Text + "')";
//cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
//cmd.ExecuteNonQuery();
//Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Succesfully Inserted.! ');</script>");
tb_itemPrice.Text = count.ToString();
conn = new MySql.Data.MySqlClient.MySqlConnection(ConnString);
conn.Open();
double policy_amount;
try
{
cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM policy where policy_name='Requisition Approval'";
reader = cmd.ExecuteReader();
if (reader.Read())
{
policy_amount = reader.GetDouble("amount");
//if (count > policy_amount)
//{
// //Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('ALERT..!!! \n Item cost exceeds the policy amount. Need supervisor approval for this.!!!');</script>");
// lbl_warning.Visible = true;
// lbl_done.Visible = false;
//}
if (checkPlicyAmount(count, policy_amount))
{
lbl_warning.Visible = true;
lbl_done.Visible = false;
}
else
{
//Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('ALERT..!!! \n Item cost exceeds the policy amount. Need supervisor approval for this.!!!');</script>");
lbl_done.Visible = true;
lbl_warning.Visible = false;
}
}
}
catch { }
conn.Close();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Please add items to create requisition..!!');</script>");
}
}
catch (Exception ex)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Scripts", "<script>alert('Data insertion failed');</script>");
}
}
private void cb_Agregar_SelectedIndexChanged(object sender, EventArgs e)
{
if (rb_Materiales.Checked == true)
{
query = "SELECT Codigo, Descripcion, Unidad, Costo, Rendimiento, Importe FROM listapu.materiales WHERE Codigo = '" + cb_Agregar.Text + "';";
con = new MySqlConnection(constring);
cmd = new MySqlCommand(query, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
string Codigo = reader.GetString("Codigo");
string Descripcion = reader.GetString("Descripcion");
string Unidad = reader.GetString("Unidad");
double Costo = reader.GetDouble("Costo");
double Rendimiento = reader.GetDouble("Rendimiento");
double Importe = reader.GetDouble("Importe");
txtCodigo.Text = Codigo;
txtDesc.Text = Descripcion;
txtUnidad.Text = Unidad;
txtCosto.Text = Costo.ToString("0.##");
lbl_Ocupacion.Visible = false;
lbl_Descripcion.Visible = true;
lbl_Sueldo.Visible = false;
lbl_Costo.Visible = true;
lbl_Salario.Visible = false;
lbl_CostoHr.Visible = false;
}
con.Close();
}
else
if (rB_ManodeObra.Checked == true)
{
query = "SELECT Codigo, Ocupacion, SueldoSemanalVigente, SalarioTotal, Rendimiento, Importe FROM listapu.manodeobra WHERE Codigo = '" + cb_Agregar.Text + "';";
con = new MySqlConnection(constring);
cmd = new MySqlCommand(query, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
string Codigo = reader.GetString("Codigo");
string ocupacion = reader.GetString("Ocupacion");
double Sueldo = reader.GetDouble("SueldoSemanalVigente");
double Salario = reader.GetDouble("SalarioTotal");
double Rendimiento = reader.GetDouble("Rendimiento");
double Importe = reader.GetDouble("Importe");
txtCodigo.Text = Codigo;
txtDesc.Text = ocupacion;
txtUnidad.Text = Sueldo.ToString("0.##");
txtCosto.Text = Salario.ToString("0.##");
}
con.Close();
lbl_Ocupacion.Visible = true;
lbl_Descripcion.Visible = false;
lbl_Sueldo.Visible = true;
lbl_Costo.Visible = false;
lbl_Salario.Visible = true;
lbl_CostoHr.Visible = false;
}
else
if (rB_EqMaq.Checked == true)
{
query = "SELECT Codigo, Descripcion, Unidad, CostoHr, Rendimiento, Importe FROM listapu.equipo WHERE Codigo = '" + cb_Agregar.Text + "';";
con = new MySqlConnection(constring);
cmd = new MySqlCommand(query, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
string Codigo = reader.GetString("Codigo");
string Descripcion = reader.GetString("Descripcion");
string Unidad = reader.GetString("Unidad");
double Costo = reader.GetDouble("CostoHr");
double Rendimiento = reader.GetDouble("Rendimiento");
double Importe = reader.GetDouble("Importe");
txtCodigo.Text = Codigo;
txtDesc.Text = Descripcion;
txtUnidad.Text = Unidad;
txtCosto.Text = Costo.ToString("0.##");
}
con.Close();
lbl_Ocupacion.Visible = false;
lbl_Descripcion.Visible = true;
lbl_Sueldo.Visible = false;
lbl_Costo.Visible = false;
lbl_Salario.Visible = false;
lbl_CostoHr.Visible = true;
}
}
public static double? getDouble(MySqlDataReader dr, string column)
{
int ordinal = dr.GetOrdinal(column);
if (dr.IsDBNull(ordinal))
{
return null;
}
else
{
return dr.GetDouble(ordinal);
}
}
IEnumerator QueryDB(float seconds)
{
double xDiff, yDiff, xNewPos, yNewPos;
// My Nexus 5
//string query = "SELECT x, y from devicelocations where deviceID = '4192fe2d3b7fbf27';";
//string query = "SELECT i, j, virtual from devicelocations where deviceID = '4192fe2d3b7fbf27';";
//***
//string query = "SELECT i, j from devicelocations where deviceID = '4192fe2d3b7fbf27';";
string query = "SELECT i, j from devicelocations";
//Group's Nexus 4
//string query = "SELECT x, y from devicelocations where deviceID = 'c76129348d8acd2e';";
//string query = "SELECT i, j, virtual from devicelocations where deviceID = 'c76129348d8acd2e';";
while (true) {
try {
if (con.State.CompareTo(ConnectionState.Open) != 0) {
con.Open(); //this line causes the windows-1252 encoding error if I18N DLLs are not included, even though it only OPENS the connection & hasn't actually requested any data yet (easy solution - include the I18N DLLs)
}
using (con) {
using (cmd = new MySqlCommand(query, con)) {
read = cmd.ExecuteReader();
while (read.Read()) {
for (int i = 0; i < read.FieldCount; i++) {
//xDiff = Math.Abs(read.GetDouble(0) - anchorAtlasX);
xDiff = Math.Abs((read.GetDouble(0) - anchorAtlasI));
Double xDiffMeters = xDiff / pixelsPerMeter;
//yDiff = Math.Abs(read.GetDouble(1) - anchorAtlasY);
yDiff = Math.Abs((read.GetDouble(1) - anchorAtlasJ));
Double yDiffMeters = yDiff / pixelsPerMeter;
//virt = (read.GetBoolean(2));
//Debug.Log("virt flag: " + virt);
//if (read.GetDouble(0) > anchorAtlasX)
if (read.GetDouble(0) > anchorAtlasI) {
//xNewPos = anchorUnityX + xDiff;
xNewPos = anchorUnityX + xDiffMeters;
}
else {
//xNewPos = anchorUnityX - xDiff;
xNewPos = anchorUnityX - xDiffMeters;
}
//if (read.GetDouble(1) > anchorAtlasY)
if (read.GetDouble(1) > anchorAtlasJ) {
//yNewPos = anchorUnityY - yDiff;
yNewPos = anchorUnityY - yDiffMeters;
}
else {
//yNewPos = anchorUnityY + yDiff;
yNewPos = anchorUnityY + yDiffMeters;
}
// Vector of NewPoint
newPos = new Vector3((float)xNewPos, (float)transform.position.y, (float)yNewPos);
//Debug.Log("New Vector3: " + newPos.x + ", " + newPos.y + ", " + newPos.z);
// Actual transform (movement) code is in update() as that runs every frame whereas this method only runs every x seconds (it's a coroutine with WaitForSeconds at the end)
}
}
}
}
}
catch (Exception e) {
Debug.Log(e.ToString());
}
//Debug.Log("DB query on: " + System.DateTime.Now);
yield return new WaitForSeconds(seconds);
}
}
public void Change(string columnas, string bd, int rB)
{
query = "SELECT " + columnas + " FROM " + bd + " WHERE Codigo = '" + cb_Agregar.Text + "';";
try
{
if (rB == 1)
{
con = new MySqlConnection(constring);
cmd = new MySqlCommand(query, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
string Codigo = reader.GetString("Codigo");
string Descripcion = reader.GetString("Descripcion");
string Unidad = reader.GetString("Unidad");
double Costo = reader.GetDouble("Costo");
double Rendimiento = reader.GetDouble("Rendimiento");
double Importe = reader.GetDouble("Importe");
txtCodigo.Text = Codigo;
txtDesc.Text = Descripcion;
txtUnidad.Text = Unidad;
txtCosto.Text = Costo.ToString("0.##");
}
con.Close();
lbl_Ocupacion.Visible = false;
lbl_Descripcion.Visible = true;
lbl_Sueldo.Visible = false;
lbl_Costo.Visible = true;
lbl_Salario.Visible = false;
lbl_CostoHr.Visible = false;
}
else
if (rB == 2)
{
con = new MySqlConnection(constring);
cmd = new MySqlCommand(query, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
string Codigo = reader.GetString("Codigo");
string ocupacion = reader.GetString("Ocupacion");
double Sueldo = reader.GetDouble("SueldoSemVig");
double Salario = reader.GetDouble("SalarioTotal");
double Rendimiento = reader.GetDouble("Rendimiento");
double Importe = reader.GetDouble("Importe");
txtCodigo.Text = Codigo;
txtDesc.Text = ocupacion;
txtUnidad.Text = Sueldo.ToString("0.##");
txtCosto.Text = Salario.ToString("0.##");
}
con.Close();
lbl_Ocupacion.Visible = true;
lbl_Descripcion.Visible = false;
lbl_Sueldo.Visible = true;
lbl_Costo.Visible = false;
lbl_Salario.Visible = true;
lbl_CostoHr.Visible = false;
}
else
if (rB == 3)
{
con = new MySqlConnection(constring);
cmd = new MySqlCommand(query, con);
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
string Codigo = reader.GetString("Codigo");
string Descripcion = reader.GetString("Descripcion");
string Unidad = reader.GetString("Unidad");
double Costo = reader.GetDouble("CostoHr");
double Rendimiento = reader.GetDouble("Rendimiento");
double Importe = reader.GetDouble("Importe");
txtCodigo.Text = Codigo;
txtDesc.Text = Descripcion;
txtUnidad.Text = Unidad;
txtCosto.Text = Costo.ToString("0.##");
}
con.Close();
lbl_Ocupacion.Visible = false;
lbl_Descripcion.Visible = true;
lbl_Sueldo.Visible = false;
lbl_Costo.Visible = false;
lbl_Salario.Visible = false;
lbl_CostoHr.Visible = true;
}
}
catch
{
MessageBox.Show("Error en la conexión de la Base de Datos", "Ocurrió un error",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
/// <summary>
/// Populate object from database record
/// </summary>
/// <param name="reader">
/// A <see cref="MySqlDataReader"/>
/// </param>
public void SetFromSql(MySqlDataReader reader)
{
for (int i = 0; i < reader.FieldCount; i++) {
switch (reader.GetName(i)) {
case "id": Id = reader.GetInt64(i); break;
case "name": Name = reader.GetString(i); break;
case "fullname": FullName = reader.GetString(i); break;
case "sha1_hash": sha1Hash = reader.GetString(i); break;
case "directory_id": DirectoryId = reader.GetInt64(i); break;
case "mimetype": Mimetype = reader.GetString(i); break;
case "title":
Title = DB.IsNull(reader[i]) ? null : reader.GetString(i);
break;
case "description":
Description = DB.IsNull(reader[i]) ? null : reader.GetString(i);
break;
case "copyright":
Copyright = DB.IsNull(reader[i]) ? null : reader.GetString(i);
break;
case "width": Width = reader.GetInt32(i); break;
case "height": Height = reader.GetInt32(i); break;
case "size": Size = reader.GetInt64(i); break;
case "resolution": Resolution = reader.GetDouble(i); break;
case "exif":
Exif = DB.IsNull(reader[i]) ? null : reader.GetString(i);
break;
case "created": Created = reader.GetDateTime(i); break;
case "modified":
if (!DB.IsNull(reader[i]))
Modified = reader.GetDateTime(i);
break;
case "keywords":
Keywords = DB.IsNull(reader[i]) ? null : reader.GetString(i);
break;
}
}
if (Id > 0) {
using (var db = new DbManager(Manager.DbCon)) {
var sql = "SELECT * FROM `preview` WHERE file_id=@id";
if (db.QueryReader(sql, DB.Param("id", Id))) {
while (db.DataReader.NextResult()) {
db.DataReader.Read();
Previews.Add(PreviewFile.FromSql(db.DataReader));
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 1";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn1.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency FROM competency Limit 2";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn2.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 3";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn3.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 4";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn4.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 5";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn5.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
svr.Text = Session["username"].ToString();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From self_questions WHERE Competency LIKE '"+ cn1.Text +"' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore1 = 0;
while (reader.Read())
{
maxscore1++;
}
max = maxscore1*5;
max1.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From self_questions WHERE Competency LIKE '" + cn2.Text + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore2 = 0;
while (reader.Read())
{
maxscore2++;
}
max = maxscore2 * 5;
max2.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From self_questions WHERE Competency LIKE '" + cn3.Text + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore3 = 0;
while (reader.Read())
{
maxscore3++;
}
max = maxscore3 * 5;
max3.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From self_questions WHERE Competency LIKE '" + cn4.Text + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore4 = 0;
while (reader.Read())
{
maxscore4++;
}
max = maxscore4 * 5;
max4.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From self_questions WHERE Competency LIKE '" + cn5.Text + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore1 = 0;
while (reader.Read())
{
maxscore5++;
}
max = maxscore5 * 5;
max5.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 1c FROM selfevascore WHERE StudentName LIKE 'A'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
sum1c.Text = reader.GetString(reader.GetOrdinal("1c"));
scr1 = reader.GetDouble(reader.GetOrdinal("1c"));
}
if (scr1 <= 0.6 * maxscore1*5)
{
comm1.Text = "You need to improve on " + cn1.Text + ". Don't give up!";
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 2c FROM selfevascore WHERE StudentName LIKE 'A'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
sum2c.Text = reader.GetString(reader.GetOrdinal("2c"));
scr2 = reader.GetDouble(reader.GetOrdinal("2c"));
}
if (scr2 <= 0.6 * maxscore2 * 5)
{
comm2.Text = "You need to improve on " + cn2.Text + ". Try harder!";
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 3c FROM selfevascore WHERE StudentName LIKE 'A'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
sum3c.Text = reader.GetString(reader.GetOrdinal("3c"));
scr3 = reader.GetDouble(reader.GetOrdinal("3c"));
}
if (scr3 <= 0.6 * maxscore3 * 5)
{
comm3.Text = "You need to improve on " + cn3.Text + ".";
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 4c FROM selfevascore WHERE StudentName LIKE 'A'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
sum4c.Text = reader.GetString(reader.GetOrdinal("4c"));
scr4 = reader.GetDouble(reader.GetOrdinal("4c"));
}
if (scr4 <= 0.6 * maxscore4 * 5)
{
comm4.Text = "You need to improve on " + cn4.Text + ". Try harder!";
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 5c FROM selfevascore WHERE StudentName LIKE 'A'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
sum5c.Text = reader.GetString(reader.GetOrdinal("5c"));
scr5 = reader.GetDouble(reader.GetOrdinal("5c"));
}
if (scr5 <= 0.6 * maxscore5 * 5)
{
comm5.Text = "You need to improve on " + cn5.Text + ". Don't give up!";
}
reader.Close();
conn.Close();
}
// 往 dr 填充 r 于 i 索引的值
public static void FillValue( DbRow dr, MySqlDataReader r, int i )
{
switch( dr.parent.columns[ i ].dataType )
{
case DbDataTypes.Boolean:
dr[ i ].Assign( r.GetBoolean( i ) ); break;
case DbDataTypes.Int8:
dr[ i ].Assign( r.GetSByte( i ) ); break;
case DbDataTypes.Int16:
dr[ i ].Assign( r.GetInt16( i ) ); break;
case DbDataTypes.Int32:
dr[ i ].Assign( r.GetInt32( i ) ); break;
case DbDataTypes.Int64:
dr[ i ].Assign( r.GetInt64( i ) ); break;
case DbDataTypes.UInt8:
dr[ i ].Assign( r.GetByte( i ) ); break;
case DbDataTypes.UInt16:
dr[ i ].Assign( r.GetUInt16( i ) ); break;
case DbDataTypes.UInt32:
dr[ i ].Assign( r.GetUInt32( i ) ); break;
case DbDataTypes.UInt64:
dr[ i ].Assign( r.GetUInt64( i ) ); break;
case DbDataTypes.Float:
dr[ i ].Assign( r.GetFloat( i ) ); break;
case DbDataTypes.Double:
dr[ i ].Assign( r.GetDouble( i ) ); break;
case DbDataTypes.DateTime:
dr[ i ].Assign( r.GetDateTime( i ) ); break;
case DbDataTypes.String:
dr[ i ].Assign( r.GetString( i ) ); break;
case DbDataTypes.Bytes:
var len = (int)r.GetBytes( i, 0, null, 0, 0 );
var buf = new byte[ len ];
r.GetBytes( i, 0, buf, 0, len );
dr[ i ].Assign( buf );
break;
default:
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
String connString = System.Configuration.ConfigurationManager.ConnectionStrings["WebAppConnString"].ToString();
svr.Text = Session["username"].ToString();
projectid = Session["project"].ToString();
count = 0;
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 1c FROM webappdemo.peer_ans WHERE StudentName LIKE '" + svr.Text + "'";//!!!!!!! need login start
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
score1 += reader.GetDouble(reader.GetOrdinal("1c"));
count++;
}
score1 = score1 / count;
sum1c.Text = score1.ToString();
count = 0;
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 2c FROM webappdemo.peer_ans WHERE StudentName LIKE '" + svr.Text + "'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
score2 += reader.GetDouble(reader.GetOrdinal("2c"));
count++;
}
score2 = score2 / count;
sum2c.Text = score2.ToString();
count = 0;
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 3c FROM webappdemo.peer_ans WHERE StudentName LIKE '" + svr.Text + "'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
score3 += reader.GetDouble(reader.GetOrdinal("3c"));
count++;
}
score3 = score3 / count;
sum3c.Text = score3.ToString();
count = 0;
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 4c FROM webappdemo.peer_ans WHERE StudentName LIKE '" + svr.Text + "'";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
score4 += reader.GetDouble(reader.GetOrdinal("4c"));
count++;
}
score4 = score4 / count;
sum4c.Text = score4.ToString();
count = 0;
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "SELECT 5c FROM webappdemo.peer_ans WHERE StudentName LIKE '" + svr.Text + "'";//!!!!!! end
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
score5 += reader.GetDouble(reader.GetOrdinal("5c"));
count++;
}
score5 = score5 / count;
sum5c.Text = score5.ToString();
count = 0;
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 1";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn1.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 2";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn2.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 3";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn3.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 4";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn4.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select Competency From competency Limit 5";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
while (reader.Read())
{
cn5.Text = reader.GetString(reader.GetOrdinal("Competency"));
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From peer_questions WHERE Competency LIKE '" + cn1.Text + "'AND ProjectID LIKE '" + projectid + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore1 = 0;
while (reader.Read())
{
maxscore1++;
}
max = maxscore1 * 5;
max1.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From peer_questions WHERE Competency LIKE '" + cn2.Text + "'AND ProjectID LIKE '" + projectid + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore2 = 0;
while (reader.Read())
{
maxscore2++;
}
max = maxscore2 * 5;
max2.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From peer_questions WHERE Competency LIKE '" + cn3.Text + "'AND ProjectID LIKE '" + projectid + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore3 = 0;
while (reader.Read())
{
maxscore3++;
}
max = maxscore3 * 5;
max3.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From peer_questions WHERE Competency LIKE '" + cn4.Text + "'AND ProjectID LIKE '" + projectid + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore4 = 0;
while (reader.Read())
{
maxscore4++;
}
max = maxscore4 * 5;
max4.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = " ";
queryStr = "Select QuestionText From peer_questions WHERE Competency LIKE '" + cn5.Text + "'AND ProjectID LIKE '" + projectid + "' ";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
maxscore1 = 0;
while (reader.Read())
{
maxscore5++;
}
max = maxscore5 * 5;
max5.Text = max.ToString();
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = "";
queryStr = "SELECT Comments FROM peer_ans WHERE StudentName LIKE '" + svr.Text + "' LIMIT 1";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
c1 = "";
while (reader.Read())
{
c1 = reader.GetString(reader.GetOrdinal("Comments"));
Session["uname11"] = c1;
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = "";
queryStr = "SELECT Comments FROM peer_ans WHERE StudentName LIKE '" + svr.Text + "' LIMIT 2";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
c2 = "";
while (reader.Read())
{
c2 = reader.GetString(reader.GetOrdinal("Comments"));
Session["uname12"] = c2;
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = "";
queryStr = "SELECT Comments FROM peer_ans WHERE StudentName LIKE '" + svr.Text + "' LIMIT 3";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
c3 = "";
while (reader.Read())
{
c3 = reader.GetString(reader.GetOrdinal("Comments"));
Session["uname13"] = c3;
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = "";
queryStr = "SELECT Comments FROM peer_ans WHERE StudentName LIKE '" + svr.Text + "' LIMIT 4";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
c4 = "";
while (reader.Read())
{
c4 = reader.GetString(reader.GetOrdinal("Comments"));
Session["uname14"] = c4;
}
reader.Close();
conn.Close();
conn = new MySql.Data.MySqlClient.MySqlConnection(connString);
conn.Open();
queryStr = "";
queryStr = "SELECT Comments FROM peer_ans WHERE StudentName LIKE '" + svr.Text + "' LIMIT 5";
cmd = new MySql.Data.MySqlClient.MySqlCommand(queryStr, conn);
reader = cmd.ExecuteReader();
c5 = "";
while (reader.Read())
{
c5 = reader.GetString(reader.GetOrdinal("Comments"));
Session["uname15"] = c5;
}
reader.Close();
conn.Close();
if (c1 != null)
{
c1 = (String)Session["uname11"];
c1label.Text = c1;
}
else
{
c1label.Text = "N.A.";
}
if (c5 != c1)
{
c2 = (String)Session["uname12"];
c2label.Text = c2;
}
else
{
c2label.Text = "N.A.";
}
if (c3 != c2)
{
c3 = (String)Session["uname13"];
c3label.Text = c3;
}
else
{
c3label.Text = "N.A.";
}
if (c4 != c3)
{
c4 = (String)Session["uname14"];
c4label.Text = c4;
}
else
{
c4label.Text = "N.A.";
}
if (c5 != c4)
{
c5 = (String)Session["uname15"];
c5label.Text = c5;
}
else
{
c5label.Text = "N.A.";
}
}
// 取 dr 中某字段的数据并返回
public static object GetValue( DbColumn col, MySqlDataReader r, int idx )
{
switch( col.dataType )
{
case DbDataTypes.Boolean:
return r.GetBoolean( idx );
case DbDataTypes.Int8:
return r.GetSByte( idx );
case DbDataTypes.Int16:
return r.GetInt16( idx );
case DbDataTypes.Int32:
return r.GetInt32( idx );
case DbDataTypes.Int64:
return r.GetInt64( idx );
case DbDataTypes.UInt8:
return r.GetByte( idx );
case DbDataTypes.UInt16:
return r.GetUInt16( idx );
case DbDataTypes.UInt32:
return r.GetUInt32( idx );
case DbDataTypes.UInt64:
return r.GetUInt64( idx );
case DbDataTypes.Float:
return r.GetFloat( idx );
case DbDataTypes.Double:
return r.GetDouble( idx );
case DbDataTypes.DateTime:
return r.GetDateTime( idx );
case DbDataTypes.String:
return r.GetString( idx );
case DbDataTypes.Bytes:
var len = (int)r.GetBytes( idx, 0, null, 0, 0 );
var buf = new byte[ len ];
r.GetBytes( idx, 0, buf, 0, len );
return buf;
default:
throw new Exception( "unsupported DbType" );
}
}
private void LoadLine(MySqlDataReader rdr)
{
string temp = "";
if(!rdr.IsDBNull(0)) { line_no = rdr.GetInt32(0); ORDER_ARRAY[rowCount, CONST_LINE_NO] = line_no.ToString(); }
if (!rdr.IsDBNull(1)) { part_id = rdr.GetString(1); ORDER_ARRAY[rowCount, CONST_PARTID] = part_id; }
if (!rdr.IsDBNull(2)) { desc = rdr.GetString(2); ORDER_ARRAY[rowCount, CONST_DESC] = desc; }
if (!rdr.IsDBNull(3)) { ordered_qty = rdr.GetInt32(3); ORDER_ARRAY[rowCount, CONST_ORDERED] = ordered_qty.ToString(); }
if (!rdr.IsDBNull(4)) { unit_price = rdr.GetFloat(4); ORDER_ARRAY[rowCount, CONST_PRICE] = unit_price.ToString(); }
if (!rdr.IsDBNull(5)) { mod = rdr.GetChar(5); ORDER_ARRAY[rowCount, CONST_MOD] = mod.ToString(); }
if (!rdr.IsDBNull(6)) { gst = Math.Round(rdr.GetDouble(6), 2); ORDER_ARRAY[rowCount, CONST_GST] = gst.ToString(); }
if (!rdr.IsDBNull(7)) { pst = Math.Round(rdr.GetDouble(7), 2); ORDER_ARRAY[rowCount, CONST_PST] = pst.ToString(); }
if (!rdr.IsDBNull(8)) { notes = rdr.GetString(8); ORDER_ARRAY[rowCount, CONST_NOTES] = notes; }
bool cust = false;
if (mod == 'C')
cust = true;
DataGridViewCheckBoxColumn checkColumn = new DataGridViewCheckBoxColumn();
checkColumn.Name = "X";
checkColumn.HeaderText = "X";
checkColumn.Width = 50;
checkColumn.ReadOnly = false;
checkColumn.FillWeight = 10; //if the datagridview is resized (on form resize) the checkbox won't take up too much; value is relative to the other columns' fill values
dgOrderForm.Rows.Add(line_no.ToString(), cust, part_id, "", desc, ordered_qty.ToString(), unit_price.ToString(), gst.ToString(), pst.ToString(), notes);
MAX_LINE = Convert.ToInt32(line_no);
}
public void Tube_Control(TreeViewItem item)
{
try
{
if (item.Tag.ToString() == "tube0" || item.Tag.ToString() == "tube1")
{
Mouse.OverrideCursor = Cursors.Wait;
_mySqlCommand.CommandText = @"
SELECT
defectsdata.IndexData,
defectsdata.NumberPart,
defectsdata.NumberTube,
defectsdata.NumberSegments,
defectsdata.DataSensors,
DATE_FORMAT(defectsdata.DatePr, '%Y-%m-%d'),
defectsdata.TimePr,
worksmens.NameSmen,
o1.Surname,
o2.Surname
FROM
defectsdata
INNER JOIN indexes ON indexes.IndexData = defectsdata.IndexData
INNER JOIN worksmens ON worksmens.Id_WorkSmen = indexes.Id_WorkSmen
INNER JOIN operators o1 ON o1.Id_Operator = indexes.Id_Operator1
INNER JOIN operators o2 ON o2.Id_Operator = indexes.Id_Operator2
WHERE
defectsdata.IndexData = @A
LIMIT 1
";
_mySqlCommand.Parameters.Clear();
_mySqlCommand.Parameters.AddWithValue("A", item.Uid);
_mySqlCommand.Connection = _connection.MySqlConnection;
_mySqlDataReader = _mySqlCommand.ExecuteReader();
while (_mySqlDataReader.Read())
{
ArchiveWindow.label1.Content = "Номер плавки\t" + _mySqlDataReader.GetString(1);
ArchiveWindow.label2.Content = "Номер трубы\t" + _mySqlDataReader.GetString(2);
ArchiveWindow.label3.Content = "Дата проведения Н.К.\t" + _mySqlDataReader.GetString(5);
ArchiveWindow.label4.Content = "Время проведения Н.К.\t" + _mySqlDataReader.GetString(6);
ArchiveWindow.label5.Content = "Длина трубы (метры)\t\t " +
Math.Round((_mySqlDataReader.GetDouble(3)/6), 2);
ArchiveWindow.label7.Content = "Рабочая смена\t" + _mySqlDataReader.GetString(7);
ArchiveWindow.label8.Content = "Специалист ОКПП\t" + _mySqlDataReader.GetString(9);
ArchiveWindow.label9.Content = "Специалист АСК ТЭСЦ-2\t" + _mySqlDataReader.GetString(8);
for (var i = 0; i < _countDeffectsLine; i++)
{
var line = (Line) ArchiveWindow.canvas1.FindName("errorLine" + i);
ArchiveWindow.canvas1.Children.Remove(line);
try
{
ArchiveWindow.canvas1.UnregisterName("errorLine" + i);
}
// ReSharper disable EmptyGeneralCatchClause
catch
// ReSharper restore EmptyGeneralCatchClause
{
}
}
_countDeffectsLine = 0;
/*_mySqlDataReaderValue4 = _mySqlDataReader.GetValue(4);
_da.Completed += _da_Completed;
_da.From = ArchiveWindow.rectangle1.Width;
_da.To = _mySqlDataReader.GetDouble(3)*4;
_da.Duration = TimeSpan.FromMilliseconds(500);
ArchiveWindow.rectangle1.BeginAnimation(FrameworkElement.WidthProperty, _da);*/
ArchiveWindow.rectangle1.Width = _mySqlDataReader.GetDouble(3)*4;
var j = 0;
foreach (var deffect in (byte[]) _mySqlDataReader.GetValue(4))
{
if (deffect != 0)
{
var redBrush = new SolidColorBrush
{
Color = Colors.Red
};
var errorLine = new Line();
Canvas.SetLeft(errorLine, 40 + (j*4));
errorLine.Opacity = 1;
errorLine.X1 = 0;
errorLine.X2 = 0;
errorLine.Y1 = 151;
errorLine.Y2 = 151 + 70;
errorLine.StrokeThickness = 4;
errorLine.Stroke = redBrush;
errorLine.Fill = redBrush;
ArchiveWindow.canvas1.RegisterName("errorLine" + _countDeffectsLine, errorLine);
ArchiveWindow.canvas1.Children.Add(errorLine);
/*_da1.From = 0;
_da1.To = 1;
_da1.Duration = TimeSpan.FromMilliseconds(2000);
errorLine.BeginAnimation(UIElement.OpacityProperty, _da1);*/
_countDeffectsLine++;
}
j++;
}
ArchiveWindow.label6.Content = "Кол-во дефектных сегментов\t " + _countDeffectsLine;
}
_mySqlDataReader.Close();
Mouse.OverrideCursor = Cursors.Arrow;
}
}
// ReSharper disable EmptyGeneralCatchClause
catch
// ReSharper restore EmptyGeneralCatchClause
{
}
}
private StavkaKalkulacijeDTO readerToStavkaKalkulacijeDTO(MySqlDataReader reader)
{
StavkaKalkulacijeDTO stavka = new StavkaKalkulacijeDTO();
stavka.Kolicina = reader.GetDouble("Kolicina");
stavka.NabavnaCijena = reader.GetDouble("NabavnaCijena");
stavka.Rabat = reader.GetDouble("Rabat");
stavka.NetoNabavnaCijena = reader.GetDouble("NetoNabavnaCijena");
stavka.VeleprodajnaCijena = reader.GetDouble("VeleprodajnaCijena");
stavka.RazlikaUCijeni = reader.GetDouble("RazlikaUCijeni");
stavka.NabavnaVrijednost = reader.GetDouble("NabavnaVrijednost");
stavka.VeleprodajnaVrijednost = reader.GetDouble("VeleprodajnaVrijednost");
return stavka;
}