public ListaItemsPersistencia(string nomeTabela, string chavePrimaria)
{
this._tabela = nomeTabela;
this._chavePrimaria = chavePrimaria;
this._mysql = new Mysql();
this._listaItems = new List<OItemPersistencia>();
}
public int count(string query)
{
try
{
query = query.ToLower();
this.comando.CommandText = Regex.Replace(query, @"select(.*)from", "select count(*) from");
this.conexion.Open();
return Convert.ToInt32(this.comando.ExecuteScalar());
}
catch (Exception ex)
{
//Console.WriteLine(ex.Message);
MessageBox.Show("proceso: " + ex.Message);
}
return 0;
}
public void GetFromDatabase()
{
string sql = $"SELECT * FROM `receipt` WHERE `id` = '{ID}'";
CreateFromRow(Mysql.RunQueryWithReturn(sql).RowData[0]);
}
private void Online()
{
Offline_delete();
gridOnline.Rows.Clear();
Mysql sql = new Mysql();
DataTable dt = sql.Select(@"
SELECT
IF(
p.fecha > DATE_SUB(NOW(), INTERVAL " + minutos + @" MINUTE)
,'ONLINE'
,'OFFLINE'
) as estado
,CONCAT(o.nombre ,' ', o.apellido) as operador
,s.sector
,p.hostname
,p.vr
,DATE_FORMAT(p.fecha, '%d/%m/%Y') as fecha
,DATE_FORMAT(p.fecha, '%H:%i') as hora
,ar.area
,f.acceso
from pc p
left join (
select id,nombre,apellido,id_sector,id_area,flag_acceso from operador
) as o
on o.id = p.id_operador
left join (
select id,sector from sector
) as s
on s.id = o.id_sector
left join (
select flag,acceso from acceso
) as f
on f.flag = o.flag_acceso
left join (
select id,area from area
) as ar
on ar.id = o.id_area
order by estado desc
");
if (dt.Rows.Count > 0)
{
foreach (DataRow r in dt.Rows)
{
gridOnline.Rows.Add(
r["estado"].ToString(),
r["operador"].ToString(),
r["sector"].ToString(),
r["area"].ToString(),
r["acceso"].ToString(),
r["hostname"].ToString(),
r["vr"].ToString(),
r["fecha"].ToString(),
r["hora"].ToString()
);
}
}
}
public List <SerializableObjects.InventorySlot> LoadInventory(Mysql mysql)
{
return(mysql.ReadInventory(dbid));
}
public bool ImportMastersFile()
{
this.Cursor = Cursors.WaitCursor;
int i = 1;
int ImportCount = 0;
bool result = true;
//ExcelTools.CheckExcellProcesses();
Excel.Application ExcelImportFile = new Excel.Application
{
DisplayAlerts = false
};
Excel.Workbook workbook = null;
Excel.Worksheet worksheet = null;
try
{
// Открываем книгу из папки с запускаемым файлом
workbook = ExcelImportFile.Workbooks.Open(eImportFile.Text);
// Получаем первую таблицу
worksheet = workbook.ActiveSheet as Excel.Worksheet;
while (true)
{
i++;
string fio = worksheet.Cells[i, 1].Text;
string dol = worksheet.Cells[i, 2].Text;
string tel = worksheet.Cells[i, 3].Text;
if ((fio == "") || (dol == "") || (tel == ""))
{
break;
}
if (Mysql.FindMasterInBase(fio))
{
string addition = "(число)";
for (int add = 1; add < 99999; add++)
{
addition = "(" + add.ToString() + ")";
if (!Mysql.FindMasterInBase(fio + addition))
{
break;
}
}
MessageBox.Show("Работник " + fio + " уже содержится в базе.\nВ базу " + fio + " будет импортирован под именем - " + fio + addition +
"\nВ Форму 4 данный работник будет выгружен без дополнения '" + addition + "'");
fio += addition;
if (!Mysql.AddNewMasterInBase(fio, dol, tel, ResId, Config.Companies[cbCompany.Text].Id))
{
MessageBox.Show("Ошибка при импорте работника - " + fio);
break;
}
else
{
ImportCount++;
}
}
else
{
if (!Mysql.AddNewMasterInBase(fio, dol, tel, ResId, Config.Companies[cbCompany.Text].Id))
{
MessageBox.Show("Ошибка при импорте работника - " + fio);
break;
}
else
{
ImportCount++;
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
result = false;
}
finally
{
MessageBox.Show("Импортировано - " + ImportCount.ToString() + " работников");
workbook.Close(false, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(worksheet);
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(workbook);
////Подготовка к убийству процесса Excel
int ExcelPID = 0;
int Hwnd = 0;
Hwnd = ExcelImportFile.Hwnd;
System.Diagnostics.Process ExcelProcess;
GetWindowThreadProcessId((IntPtr)Hwnd, out ExcelPID);
ExcelProcess = System.Diagnostics.Process.GetProcessById(ExcelPID);
////Конец подготовки к убийству процесса Excel
ExcelImportFile.Quit();
System.Runtime.InteropServices.Marshal.FinalReleaseComObject(ExcelImportFile);
GC.Collect();
GC.WaitForPendingFinalizers();
////Убийство процесса Excel
ExcelProcess.Kill();
ExcelProcess = null;
//ExcelTools.KillExcel();
this.Cursor = Cursors.Default;
}
return(result);
}
public void GetDados(StringBuilder query)
{
Mysql mysql = new Mysql();
this._dataSet = mysql.RecuperarDataSet(query);
}
private void btn_save_Click(object sender, EventArgs e)
{
if (cbRes.SelectedIndex < 0)
{
MessageBox.Show("Необходимо выбрать РЭС.");
}
else
{
bool err = false;
if ((l1.Visible) && (l1.Text == ""))
{
err = true;
}
if ((p1.Visible) && (p1.Text == ""))
{
err = true;
}
if ((p2.Visible) && (p2.Text == ""))
{
err = true;
}
if ((p3.Visible) && (p3.Text == ""))
{
err = true;
}
if ((p4.Visible) && (p4.Text == ""))
{
err = true;
}
if ((FiderId == int.MinValue) && err)
{
MessageBox.Show("Не все поля заполнены");
}
else
{
if (FiderId == int.MinValue) //Если это новый фидер
{
if (Mysql.FindFiderInBase(edFiderName.Text))
{
MessageBox.Show("В базе уже содержится " + edFiderName.Text + "\nДобавить объект с таким же именем невозможно!");
}
else
{
int FiderType = cbTypeVL.SelectedIndex;
if (Mysql.AddNewFiderInBase(edFiderName.Text, FiderType, Config.Reses[cbRes.Text].Id, Config.Companies[cbCompany.Text].Id, (int)TP.Value, (int)SZO.Value, (int)NP.Value, (int)Population.Value, P_load_l.Value, P_load_z.Value))
{
this.DialogResult = DialogResult.Yes;
}
else
{
this.DialogResult = DialogResult.No;
}
this.Hide();
}
}
else //Если это редактирование фидера
{
if (Mysql.EditFiderFromBase(FiderId, edFiderName.Text, (int)TP.Value, (int)SZO.Value, (int)NP.Value, (int)Population.Value, P_load_l.Value, P_load_z.Value))
{
this.DialogResult = DialogResult.Yes;
}
else
{
this.DialogResult = DialogResult.No;
}
this.Hide();
}
}
}
}
void ScanBGetBarcodeCallback(string barcode)
{
if (barcode != "Error")
{
Mysql mysql = new Mysql();
if (mysql.Connect())
{
string stm = "SELECT * FROM BODMSG WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,5";
DataSet ds = mysql.Select(stm);
DataTable dt = ds.Tables["table0"];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["STATUS"] == DBNull.Value)
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("板 " + barcode + " 状态栏位为空");
}));
Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】
}
else
{
if ((string)dt.Rows[0]["STATUS"] == "OFF")
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("板 " + barcode + " 未测试");
}));
Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】
}
else
{
stm = "SELECT * FROM BARBIND WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,15";
ds = mysql.Select(stm);
dt = ds.Tables["table0"];
if (dt.Rows.Count == 15)
{
stm = "INSERT INTO BODMSG (SCBODBAR, STATUS) VALUES('" + barcode + "','OFF')";
int rstnum = mysql.executeQuery(stm);
if (rstnum > 0)
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("板 " + barcode + " 解绑");
}));
short[] result = new short[15];
bool checkrst = true;
for (int i = 0; i < 15; i++)
{
DataRow[] drs = dt.Select(string.Format("PCSSER = '{0}'", (i + 1).ToString()));
if (drs.Length == 1)
{
try
{
result[i] = short.Parse((string)drs[0]["RESULT"]);
}
catch (Exception ex)
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage(ex.Message);
}));
checkrst = false;
break;
}
}
else
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("板 " + barcode + " 序号 " + (i + 1).ToString() + "索引数 " + drs.Length.ToString());
}));
checkrst = false;
break;
}
}
if (checkrst)
{
string str;
Fx5u_2.WriteMultD("D1020", result);
str = "B_BordInfo;";
for (int i = 0; i < 15; i++)
{
str += result[i].ToString() + ";";
}
str = str.Substring(0, str.Length - 1);
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage(str);
}));
Fx5u_2.SetM("M2604", true);//载具扫码-已测过【B轨道】
}
else
{
Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】
}
}
else
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("解绑失败");
}));
Fx5u_2.SetM("M2603", true);//载具扫码NG【B轨道】
}
}
else
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("板 " + barcode + " 记录数目不是15");
}));
Fx5u_2.SetM("M2605", true);//载具扫码-未测过【B轨道】
}
}
}
}
else
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("板 " + barcode + " 信息未录入");
}));
Fx5u_2.SetM("M2605", true); //载具扫码-未测过【A轨道】
}
Fx5u_2.SetM("M2602", true); //载具扫码OK【B轨道】
}
mysql.DisConnect();
}
else
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("扫码失败");
}));
Fx5u_2.SetM("M2603", true);//载具扫码NG【B轨道】
}
}
public IEnumerable <Member> Get()
{
Mysql mysqlGet = new Mysql();
return(mysqlGet.UserList());
}
private void button1_Click_1(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(richTextBox1.Text))
{
errorProvider1.SetError(richTextBox1, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox2.Text))
{
errorProvider1.SetError(textBox2, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox1.Text))
{
errorProvider1.SetError(textBox1, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox3.Text))
{
errorProvider1.SetError(textBox3, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox4.Text))
{
errorProvider1.SetError(textBox4, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox5.Text))
{
errorProvider1.SetError(textBox5, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox6.Text))
{
errorProvider1.SetError(textBox6, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox7.Text))
{
errorProvider1.SetError(textBox7, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox8.Text))
{
errorProvider1.SetError(textBox8, "Campo obligatorio");
}
if (string.IsNullOrEmpty(textBox9.Text))
{
errorProvider1.SetError(textBox9, "Campo obligatorio");
}
if (!string.IsNullOrEmpty(textBox2.Text) && !string.IsNullOrEmpty(textBox1.Text) &&
!string.IsNullOrEmpty(textBox3.Text) && !string.IsNullOrEmpty(textBox4.Text) &&
!string.IsNullOrEmpty(textBox5.Text) && !string.IsNullOrEmpty(textBox6.Text) &&
!string.IsNullOrEmpty(textBox7.Text) && !string.IsNullOrEmpty(textBox8.Text) &&
!string.IsNullOrEmpty(textBox9.Text) && !string.IsNullOrEmpty(richTextBox1.Text))
{
using (var mysql = new Mysql())
{
mysql.conexion();
mysql.cadenasql =
"INSERT INTO `items`(`Barcode`, `Descripcion`, `Impuesto`, `Precio`, `OnHand`, `Costo`, `Marca`, `Talla`, `Familia`, `Estilo`, `Genero`) VALUES (@ba,@de,@im,@pr,@on,@co,@ma,@ta,@fa,@es,@ge)";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.Parameters.AddWithValue("@ba", textBox2.Text);
mysql.comando.Parameters.AddWithValue("@de", richTextBox1.Text);
mysql.comando.Parameters.AddWithValue("@im", comboBox1.Text);
mysql.comando.Parameters.AddWithValue("@pr", textBox1.Text);
mysql.comando.Parameters.AddWithValue("@on", textBox3.Text);
mysql.comando.Parameters.AddWithValue("@co", textBox4.Text);
mysql.comando.Parameters.AddWithValue("@ma", textBox5.Text);
mysql.comando.Parameters.AddWithValue("@ta", textBox6.Text);
mysql.comando.Parameters.AddWithValue("@fa", textBox7.Text);
mysql.comando.Parameters.AddWithValue("@es", textBox8.Text);
mysql.comando.Parameters.AddWithValue("@ge", textBox9.Text);
mysql.comando.ExecuteNonQuery();
mysql.Dispose();
MessageBox.Show("La solicitud se proceso correctamente", "Acción realizada", MessageBoxButtons.OK, MessageBoxIcon.Information);
limpiar();
}
}
textBox2.Focus();
}
catch (MySqlException my)
{
MessageBox.Show("Este producto ya existe.Intente con otro código", "No se aceptan códigos repetidos", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
catch (Exception exec)
{
Mensaje.Error(exec, "67");
}
}
public void GetDados(StringBuilder query)
{
Mysql mysql = new Mysql();
this._dataSet = mysql.RecuperarDataSet(query);
}
public void DeactivateStorageRoom()
{
string sql = $"UPDATE `storagerooms` SET `deactivated` = '1' WHERE `id` = '{ID}';";
Mysql.RunQuery(sql);
}
private void TcpServer_Received(object sender, string e)
{
string restr = e.Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries)[0];
AddMessage("接收:" + restr);
Task.Run(() => {
try
{
if (Directory.Exists(WorkPath))
{
DirectoryInfo folder = new DirectoryInfo(WorkPath);
int cout = 0;
FileInfo[] files = folder.GetFiles(restr);
while (!(files.Length > 0 && !IsFileLocked(files[0])) && cout < 10)
{
files = folder.GetFiles(restr);
cout++;
System.Threading.Thread.Sleep(200);
}
if (cout < 10)
{
string[] vs = files[0].Name.Split(new string[] { "_" }, StringSplitOptions.RemoveEmptyEntries);
if (vs.Length == 3)
{
HObject img;
HOperatorSet.ReadImage(out img, files[0].FullName);
CameraIamge = new HImage(img);
if (!Directory.Exists(Path.Combine(ImageSavePath, vs[1])))
{
Directory.CreateDirectory(Path.Combine(ImageSavePath, vs[1]));
}
string[] vs1 = vs[2].Split(new string[] { "." }, StringSplitOptions.RemoveEmptyEntries);
if (!Directory.Exists(Path.Combine(ImageSavePath, vs[1], vs1[0])))
{
Directory.CreateDirectory(Path.Combine(ImageSavePath, vs[1], vs1[0]));
}
File.Copy(files[0].FullName, Path.Combine(ImageSavePath, vs[1], vs1[0], files[0].Name), true);
string str = files[0].FullName;
File.Delete(str);
Mysql mysql = new Mysql();
if (mysql.Connect())
{
string stm = "";
switch (vs[1])
{
case "M1":
stm = $"INSERT INTO aviproductdata (BoardID,PcsIndex,ResultItem1) VALUES ('{vs[0]}',{vs1[0]},'OK')";
break;
case "M2":
stm = $"UPDATE aviproductdata SET ResultItem2 = 'OK' WHERE BoardID = '{vs[0]}' AND PcsIndex = {vs1[0]}";
break;
case "M3":
stm = $"UPDATE aviproductdata SET ResultItem3 = 'OK' WHERE BoardID = '{vs[0]}' AND PcsIndex = {vs1[0]}";
break;
case "M4":
stm = $"UPDATE aviproductdata SET ResultItem4 = 'OK' WHERE BoardID = '{vs[0]}' AND PcsIndex = {vs1[0]}";
break;
default:
break;
}
int result = mysql.executeQuery(stm);
if (result < 1)
{
AddMessage("请注意，数据库插入失败");
}
StatusDataBase = true;
}
else
{
AddMessage("数据库未连接");
StatusDataBase = false;
}
mysql.DisConnect();
AddMessage($"{str}文件处理完成");
}
else
{
string str = files[0].FullName;
File.Delete(str);
AddMessage($"{str}文件名非法，已删除");
}
}
else
{
AddMessage($"获取文件{restr}超时");
}
}
}
catch (Exception ex)
{
AddMessage(ex.Message);
}
});
}
public void crearreporte()
{
int y = 1;
try
{
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
for (int x = 0; x < dataGridView1.Rows.Count; x++)
{
using (var mysql = new Mysql())
{
mysql.conexion();
mysql.cadenasql = "select count(*),Barcode,Descripcion,Precio,OnHand from items where Barcode=@co";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.Parameters.AddWithValue("@co", dataGridView1.Rows[x].Cells[0].Value.ToString());
mysql.comando.ExecuteNonQuery();
using (MySqlDataReader lee = mysql.comando.ExecuteReader())
{
while (lee.Read())
{
if (Int64.Parse(lee["count(*)"].ToString()) > 0)
{
if (x == 0)
{
updates(dataGridView1.Rows[x].Cells[0].Value.ToString(),
dataGridView1.Rows[x].Cells[1].Value.ToString(),
dataGridView1.Rows[x].Cells[2].Value.ToString(),
dataGridView1.Rows[x].Cells[3].Value.ToString(),
dataGridView1.Rows[x].Cells[4].Value.ToString(),
dataGridView1.Rows[x].Cells[5].Value.ToString(),
dataGridView1.Rows[x].Cells[6].Value.ToString(),
dataGridView1.Rows[x].Cells[7].Value.ToString(),
dataGridView1.Rows[x].Cells[8].Value.ToString(),
dataGridView1.Rows[x].Cells[9].Value.ToString(),
dataGridView1.Rows[x].Cells[10].Value.ToString());
sheet.Range["A" + y].Text = "Código";
sheet.Range["B" + y].Text = "Descripción";
sheet.Range["C" + y].Text = "Precio";
sheet.Range["D" + y].Text = "Cantidad";
sheet.Range["E" + y].Text = "Ingreso";
sheet.Range["F" + y].Text = "Cantidad Total";
sheet.Range["G" + y].Text = "Suma precio Total";
y++;
sheet.Range["A" + y].Text = lee["Barcode"].ToString();
sheet.Range["B" + y].Text = lee["Descripcion"].ToString();
sheet.Range["C" + y].NumberValue = double.Parse(lee["Precio"].ToString());
sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString());
sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString());
sheet.Range["F" + y].NumberValue = (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()));
sheet.Range["G" + y].NumberValue = ((double.Parse(lee["Precio"].ToString()) * (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()))));
y++;
}
else
{
updates(dataGridView1.Rows[x].Cells[0].Value.ToString(),
dataGridView1.Rows[x].Cells[1].Value.ToString(),
dataGridView1.Rows[x].Cells[2].Value.ToString(),
dataGridView1.Rows[x].Cells[3].Value.ToString(),
dataGridView1.Rows[x].Cells[4].Value.ToString(),
dataGridView1.Rows[x].Cells[5].Value.ToString(),
dataGridView1.Rows[x].Cells[6].Value.ToString(),
dataGridView1.Rows[x].Cells[7].Value.ToString(),
dataGridView1.Rows[x].Cells[8].Value.ToString(),
dataGridView1.Rows[x].Cells[9].Value.ToString(),
dataGridView1.Rows[x].Cells[10].Value.ToString());
sheet.Range["A" + y].Text = lee["Barcode"].ToString();
sheet.Range["B" + y].Text = lee["Descripcion"].ToString();
sheet.Range["C" + y].NumberValue = double.Parse(lee["Precio"].ToString());
sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString());
sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString());
sheet.Range["F" + y].NumberValue = (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()));
sheet.Range["G" + y].NumberValue = ((double.Parse(lee["Precio"].ToString()) * (double.Parse(lee["OnHand"].ToString()) + double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()))));
y++;
}
}
else
{
if (x == 0)
{
insertes(dataGridView1.Rows[x].Cells[0].Value.ToString(),
dataGridView1.Rows[x].Cells[1].Value.ToString(),
dataGridView1.Rows[x].Cells[2].Value.ToString(),
dataGridView1.Rows[x].Cells[3].Value.ToString(),
dataGridView1.Rows[x].Cells[4].Value.ToString(),
dataGridView1.Rows[x].Cells[5].Value.ToString(),
dataGridView1.Rows[x].Cells[6].Value.ToString(),
dataGridView1.Rows[x].Cells[7].Value.ToString(),
dataGridView1.Rows[x].Cells[8].Value.ToString(),
dataGridView1.Rows[x].Cells[9].Value.ToString(),
dataGridView1.Rows[x].Cells[10].Value.ToString());
sheet.Range["A" + y].Text = "Código";
sheet.Range["B" + y].Text = "Descripción";
sheet.Range["C" + y].Text = "Precio";
sheet.Range["D" + y].Text = "Cantidad";
sheet.Range["E" + y].Text = "Ingreso";
sheet.Range["F" + y].Text = "Cantidad Total";
sheet.Range["G" + y].Text = "Suma precio Total";
y++;
sheet.Range["A" + y].Text = dataGridView1.Rows[x].Cells[0].Value.ToString();
sheet.Range["B" + y].Text = dataGridView1.Rows[x].Cells[1].Value.ToString();
sheet.Range["C" + y].NumberValue = double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString());
sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString());
sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString());
sheet.Range["F" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString());
sheet.Range["G" + y].NumberValue = ((double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString()) * (double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()))));
y++;
}
else
{
insertes(dataGridView1.Rows[x].Cells[0].Value.ToString(),
dataGridView1.Rows[x].Cells[1].Value.ToString(),
dataGridView1.Rows[x].Cells[2].Value.ToString(),
dataGridView1.Rows[x].Cells[3].Value.ToString(),
dataGridView1.Rows[x].Cells[4].Value.ToString(),
dataGridView1.Rows[x].Cells[5].Value.ToString(),
dataGridView1.Rows[x].Cells[6].Value.ToString(),
dataGridView1.Rows[x].Cells[7].Value.ToString(),
dataGridView1.Rows[x].Cells[8].Value.ToString(),
dataGridView1.Rows[x].Cells[9].Value.ToString(),
dataGridView1.Rows[x].Cells[10].Value.ToString());
sheet.Range["A" + y].Text = dataGridView1.Rows[x].Cells[0].Value.ToString();
sheet.Range["B" + y].Text = dataGridView1.Rows[x].Cells[1].Value.ToString();
sheet.Range["C" + y].NumberValue = double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString());
sheet.Range["D" + y].NumberValue = Int64.Parse(lee["OnHand"].ToString());
sheet.Range["E" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString());
sheet.Range["F" + y].NumberValue = Int64.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString());
sheet.Range["G" + y].NumberValue = ((double.Parse(dataGridView1.Rows[x].Cells[3].Value.ToString()) * (double.Parse(dataGridView1.Rows[x].Cells[4].Value.ToString()))));
y++;
}
}
}
}
mysql.Dispose();
}
}
workbook.SaveToFile(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments) + "/reporteinventario.xls");
dataGridView1.DataSource = null;
}
catch (Exception xls)
{
MessageBox.Show(xls.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
public static void CreateNewPassword(string passwordInput)
{
string setQuery = $"UPDATE `admin_password` SET `admin_password` = '{SaltAndHashPassword(passwordInput)}' WHERE `id` = '1'";
Mysql.RunQuery(setQuery);
}
private void Awake()
{
mysql = FindObjectOfType <Mysql>();
}
public IEnumerable <History> GetHistory()
{
Mysql mysqlGet = new Mysql();
return(mysqlGet.HistortList());
}
public override void GetFromDatabase()
{
string sql = $"SELECT * FROM `order_transactions` WHERE `id` = {_id}";
CreateFromRow(Mysql.RunQueryWithReturn(sql).RowData[0]);
}
public string DeleteMember(int id)
{
Mysql mysqlGet = new Mysql();
return(mysqlGet.DeleteMember(id));
}
private void guardarcierre()
{
impri = false;
numero = "";
try
{
if (!string.IsNullOrEmpty(textBox2.Text) && !string.IsNullOrEmpty(textBox3.Text) &&
!string.IsNullOrEmpty(textBox1.Text) && !string.IsNullOrEmpty(textBox8.Text) &&
!string.IsNullOrEmpty(textBox4.Text) && !string.IsNullOrEmpty(textBox10.Text) && !string.IsNullOrEmpty(textBox9.Text) &&
!string.IsNullOrEmpty(textBox12.Text) && !string.IsNullOrEmpty(textBox11.Text) &&
!string.IsNullOrEmpty(textBox13.Text) && !string.IsNullOrEmpty(textBox14.Text) &&
!string.IsNullOrEmpty(textBox7.Text) && !string.IsNullOrEmpty(textBox5.Text) &&
!string.IsNullOrEmpty(textBox6.Text))
{
if (dataGridView1.Rows.Count > 0)
{
inicialf = Int32.Parse(dataGridView1.Rows[0].Cells[0].Value.ToString());
finalf = Int32.Parse(dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0].Value.ToString());
}
else
{
inicialf = 0;
finalf = 0;
}
if (dataGridView2.Rows.Count > 0)
{
inicialp = Int32.Parse(dataGridView2.Rows[0].Cells[0].Value.ToString());
finalp = Int32.Parse(dataGridView2.Rows[dataGridView2.Rows.Count - 1].Cells[0].Value.ToString());
}
else
{
inicialp = 0;
finalp = 0;
}
if (dataGridView3.Rows.Count > 0)
{
iniciala = Int32.Parse(dataGridView3.Rows[0].Cells[0].Value.ToString());
finala = Int32.Parse(dataGridView3.Rows[dataGridView3.Rows.Count - 1].Cells[0].Value.ToString());
}
else
{
iniciala = 0;
finala = 0;
}
using (var mysql = new Mysql())
{
mysql.conexion();
mysql.cadenasql = "INSERT INTO `cierre`(`Fecha`, `FacturaInicialf`, `FacturaFinalf`,`FacturaInicialp`,`FacturaFinalp`,`abonoinicial`, `abonofinal`, `VentasContado`, `Abonos`,`Fondo`,`VentasTarjeta`) VALUES (" +
"'" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + "'," +
"'" + inicialf + "'," +
"'" + finalf + "'," +
"'" + inicialp + "'," +
"'" + finalp + "'," +
"'" + iniciala + "'," +
"'" + finala + "'," +
"'" + double.Parse(textBox13.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "'," +
"'" + double.Parse(textBox4.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "'" +
",'" + double.Parse(textBox5.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "'" +
",'" + double.Parse(textBox14.Text).ToString("0.00000000", CultureInfo.InvariantCulture) + "')";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.ExecuteNonQuery();
mysql.Dispose();
impri = true;
}
using (var mysql2 = new Mysql())
{
mysql2.conexion();
mysql2.cadenasql = "select Max(Numero) from cierre";
mysql2.comando = new MySqlCommand(mysql2.cadenasql, mysql2.con);
mysql2.comando.ExecuteNonQuery();
using (var lee2 = mysql2.comando.ExecuteReader())
{
while (lee2.Read())
{
numero = lee2["Max(Numero)"].ToString();
}
}
mysql2.Dispose();
}
}
else
{
MessageBox.Show("Faltan datos", "Faltan datos", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
catch (Exception evo)
{
MessageBox.Show(evo.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public string EditMember(int id, string emId, string firstname, string lastname, string card, string tel, string address)
{
Mysql mysqlGet = new Mysql();
return(mysqlGet.EditMember(id, emId, firstname, lastname, card, tel, address));
}
public void formatodeactura()
{
string otrosabonos = "";
string inicial = "";
string nombre = "";
formato = "";
try
{
using (var mysql = new Mysql())
{
mysql.conexion2();
mysql.cadenasql = "select NumFactura,Abono,Fecha from abonos where Cedula='" + dataGridView1.CurrentRow.Cells[1].Value + "' and NumFactura='" + dataGridView1.CurrentRow.Cells[2].Value + "'";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.ExecuteNonQuery();
using (var reader = mysql.comando.ExecuteReader())
{
while (reader.Read())
{
otrosabonos += "\n" + "#" + reader["NumFactura"].ToString() + "\t " + "₡" + reader["Abono"].ToString() + "\n" + reader["Fecha"].ToString();
}
}
mysql.cadenasql = "select Inicial,Saldo from saldos where NumFactura='" + dataGridView1.CurrentRow.Cells[2].Value + "'";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.ExecuteNonQuery();
using (var reader = mysql.comando.ExecuteReader())
{
while (reader.Read())
{
inicial = reader["Inicial"].ToString();
saldoact = reader["Saldo"].ToString();
}
}
mysql.cadenasql = "select Nombre from clientes where Cedula='" + dataGridView1.CurrentRow.Cells[1].Value + "'";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.ExecuteNonQuery();
using (var reader = mysql.comando.ExecuteReader())
{
while (reader.Read())
{
nombre = reader["Nombre"].ToString();
}
}
mysql.cadenasql = "SELECT Fecha FROM saldos WHERE NumFactura='" + dataGridView1.CurrentRow.Cells[2].Value + "'";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.ExecuteNonQuery();
using (MySqlDataReader lee = mysql.comando.ExecuteReader())
{
while (lee.Read())
{
fechavenc = lee["Fecha"].ToString();
}
}
DateTime feg = DateTime.Parse(fechavenc);
//mysql.cadenasql = "SELECT DATE_ADD('date("+ fechavenc + ")',INTERVAL 90 DAY) AS fe";
mysql.cadenasql = "SELECT DATE_ADD('" + feg.ToString("yyyy-MM-dd hh:mm:ss tt") + "',INTERVAL 90 DAY)";
mysql.comando = new MySqlCommand(mysql.cadenasql, mysql.con);
mysql.comando.ExecuteNonQuery();
using (MySqlDataReader lee = mysql.comando.ExecuteReader())
{
while (lee.Read())
{
diasvencer = lee["DATE_ADD('" + feg.ToString("yyyy-MM-dd hh:mm:ss tt") + "',INTERVAL 90 DAY)"].ToString();
}
}
mysql.Dispose();
formato = ConfigurationManager.AppSettings["cadena2"] +
"\n------------------------------------------------" +
"\nFECHA DEL APARTADO:\n" + fechavenc +
"\nFECHA DE VENCIMIENTO:\n" + DateTime.Parse(diasvencer) + "\n" +
"\nCAJERO: " + dataGridView1.CurrentRow.Cells[5].Value +
"\nCLIENTE: " + nombre +
"\nSALDO INICIAL: " + inicial +
"\nSALDO ACTUAL: " + saldoact +
"\n------------------------------------------------" +
"\n\nABONOS HASTA EL MOMENTO:" +
"\n\nNo.Factura Monto abonado" +
otrosabonos +
"\n------------------------------------------------";
facturawr = new StreamWriter("Abonohistorico.txt");
facturawr.WriteLine(formato);
facturawr.Flush();
facturawr.Close();
}
}
catch (Exception err_0016)
{
Mensaje.Error(err_0016, "329");
}
}
public string SaveHistory(int EmId, string Name, string Surname, string Tel, string Date)
{
Mysql mysqlGet = new Mysql();
return(mysqlGet.SaveHistory(EmId, Name, Surname, Tel, Date));
}
public void Load()
{
Mysql mysql = FindObjectOfType <Mysql>();
Action ac = () =>
{
try {
List <ShipBaseStat> stats = mysql.ReadShipBaseStatsTable();
List <Experience> exp = mysql.ReadExperienceTable();
PlayerData data = mysql.ReadPlayerData(dbid);
List <PlayerSkillLevel> skills = mysql.ReadPlayerSkills(dbid);
this.stats = stats;
this.exp = exp;
this.data = data;
this.skills = skills;
if (!NetworkManager.traders.ContainsKey(dbid))
{
NetworkManager.traders.Add(dbid, mysql.ReadTraders());
}
List <SerializableObjects.Item> shipEquipment = LoadShipEquipment(mysql);
List <SerializableObjects.Equipment> playerEquipment = LoadPlayerEquipment(mysql);
List <SerializableObjects.InventorySlot> inventory = LoadInventory(mysql);
List <RandomLoot> loot = mysql.LoadPlayerLoot(dbid);
if (!GameServer.playerLoot.ContainsKey(id))
{
GameServer.playerLoot.Add(id, null);
}
GameServer.playerLoot[id] = loot;
foreach (RandomLoot l in loot)
{
ServerSend.OnLootDropped(id, l.id, l.position);
}
mysql.RemovePlayerLoot(dbid);
List <Buff> buffs = mysql.GetPlayerBuffs(dbid);
mysql.RemoveBuffs(dbid);
List <PlayerBaseStat> playerStats = mysql.ReadPlayerBaseStatsTable();
ThreadManager.ExecuteOnMainThread(() =>
{
LoadBaseStats();
//if (!data.is_on_ship) {
playerInstance = Instantiate(playerPrefab, new Vector3(data.X_PLAYER, data.Y_PLAYER, data.Z_PLAYER), Quaternion.identity);
playerCharacter = playerInstance.GetComponent <PlayerCharacter>();
playerMovement = playerInstance.GetComponent <PlayerMovement>();
playerCharacter.id = id;
playerCharacter.data = data;
playerInstance.transform.Find("PlayerSphere").GetComponent <SphereCollider>().radius = NetworkManager.visibilityRadius / 2;
playerInstance.transform.eulerAngles = new Vector3(0, data.Y_ROT_PLAYER, 0);
playerCharacter.pirate.transform.rotation = Quaternion.Euler(0, data.Y_ROT_PLAYER_CHILD, 0);
//enable collider for ship when we have player character
playerEnterCollider.enabled = true;
playerCharacter.clientPosition = new Vector3(data.X_PLAYER, data.Y_PLAYER, data.Z_PLAYER);
playerCharacter.clientRotation = Quaternion.Euler(0, data.Y_ROT_PLAYER, 0);
playerCharacter.childRotation = Quaternion.Euler(0, data.Y_ROT_PLAYER_CHILD, 0);
if (data.is_on_ship)
{
playerInstance.SetActive(false);
}
Inventory inv = this.inventory;
foreach (SerializableObjects.InventorySlot slot in inventory)
{
inv.Add(NetworkManager.SerializableToSlot(slot));
}
playerCharacter.stats = playerStats;
playerCharacter.Load();
ServerSend.SpawnShip(id, this);
ServerSend.OnGameStart(id, stats, playerCharacter.stats, exp, data);
ShipEquipment equipment = ship_equipment;
foreach (SerializableObjects.Item item in shipEquipment)
{
equipment.Add(NetworkManager.SerializableToItem(item), null);
}
foreach (SerializableObjects.Equipment eq in playerEquipment)
{
playerCharacter.equipment.Add(NetworkManager.SerializableToItem(eq.item), eq.slotType);
}
// Send the new player to all players
foreach (Client _client in GameServer.clients.Values)
{
if (_client.player != null)
{
if (_client.player.id != id)
{
ServerSend.SpawnShip(_client.id, this);
}
}
}
// Send all players to the new player
foreach (Client _client in GameServer.clients.Values)
{
if (_client.player != null)
{
if (_client.id != id)
{
ServerSend.SpawnShip(id, _client.player);
}
}
}
// Send the new player to all players except himself
foreach (Client _client in GameServer.clients.Values)
{
if (_client.player != null)
{
if (_client.player.id != id)
{
//ServerSend.SpawnPlayer(_client.id, player);
ServerSend.InstantiatePlayerCharacter(_client.id, id,
this.playerInstance.transform.position,
this.playerInstance.transform.eulerAngles.y);
}
}
}
// Send all players to the new player
foreach (Client _client in GameServer.clients.Values)
{
if (_client.player != null)
{
if (_client.id != id)
{
/*if(!_client.player.data.is_on_ship)
* ServerSend.SpawnPlayer(id, _client.player);*/
ServerSend.InstantiatePlayerCharacter(id, _client.player.id,
_client.player.playerInstance.transform.position,
_client.player.playerInstance.transform.eulerAngles.y);
}
}
}
spawnManager.SendAllGameObjects(id);
ServerSend.Recipes(id);
//send stats after all is loaded
ServerSend.Stats(id);
if (data.dead)
{
playerCharacter.Respawn();
}
foreach (RandomLoot l in loot)
{
StartCoroutine(GameServer.DespawnLoot(id, l, l.remainingTime));
}
foreach (Buff b in buffs)
{
playerCharacter.buffManager.AddBuff(b);
}
ServerSend.Buffs(id, id);
});
//LoadPlayerEquipment();
}
catch (Exception ex)
{
Debug.LogError(ex);
}
};
Task task = new Task(ac);
task.Start();
}
public IEnumerable <Member> ShowInfo(string EmId)
{
Mysql mysqlGet = new Mysql();
return(mysqlGet.ShowInfoList(EmId));
}
private void Offline_delete()
{
Mysql sql = new Mysql();
bool rs = sql.Ejecutar("delete from pc where fecha < DATE_SUB(NOW(), INTERVAL " + minutos + " MINUTE)");
}
public async Task <Level> GetAccount(long playerId)
{
try
{
Level account = null;
if (Constants.UseCacheServer) //Redis as cache server
{
string _Data = Redis.Players.StringGet(playerId.ToString()).ToString();
if (!string.IsNullOrEmpty(_Data) && _Data.Contains("#:#:#:#"))
{
string[] _Datas = _Data.Split(new string[1] {
"#:#:#:#"
}, StringSplitOptions.None);
if (!string.IsNullOrEmpty(_Datas[0]) && !string.IsNullOrEmpty(_Datas[1]))
{
account = new Level();
account.Avatar.LoadFromJSON(_Datas[0]);
account.LoadFromJSON(_Datas[1]);
}
}
else
{
using (Mysql db = new Mysql())
{
Player p = await db.Player.FindAsync(playerId);
if (p != null)
{
account = new Level();
account.Avatar.LoadFromJSON(p.Avatar);
account.LoadFromJSON(p.GameObjects);
Redis.Players.StringSet(playerId.ToString(), p.Avatar + "#:#:#:#" + p.GameObjects,
TimeSpan.FromHours(4));
}
}
;
}
}
else
{
using (Mysql db = new Mysql())
{
Player p = await db.Player.FindAsync(playerId);
if (p != null)
{
account = new Level();
account.Avatar.LoadFromJSON(p.Avatar);
account.LoadFromJSON(p.GameObjects);
}
}
}
return(account);
}
catch (Exception)
{
return(null);
}
}
void CheckBarcode(string barcode, int index)
{
if (barcode != "Error")
{
try
{
Mysql mysql = new Mysql();
if (mysql.Connect())
{
string stm = "SELECT * FROM BODMSG WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,5";
DataSet ds = mysql.Select(stm);
DataTable dt = ds.Tables["table0"];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["STATUS"] == DBNull.Value)
{
AddMessage("板 " + barcode + " 状态栏位为空");
switch (index)
{
case 0:
Fx5u.SetM("M2505", true);
break;
case 1:
Fx5u.SetM("M2507", true);
break;
default:
break;
}
}
else
{
if ((string)dt.Rows[0]["STATUS"] == "OFF")
{
AddMessage("板 " + barcode + " 是未测板");
switch (index)
{
case 0:
Fx5u.SetM("M2505", true);
break;
case 1:
Fx5u.SetM("M2507", true);
break;
default:
break;
}
}
else
{
stm = "INSERT INTO BODMSG (SCBODBAR, STATUS) VALUES('" + barcode + "','OFF')";
AddMessage("板 " + barcode + " 解绑");
mysql.executeQuery(stm);
stm = "SELECT * FROM BARBIND WHERE SCBODBAR = '" + barcode + "' ORDER BY SIDATE DESC LIMIT 0,96";
ds = mysql.Select(stm);
dt = ds.Tables["table0"];
if (dt.Rows.Count == 96)
{
//string datetimestr = (string)dt.Rows[0]["SIDATE"];
short[] result = new short[96];
bool checkrst = true;
for (int i = 0; i < 96; i++)
{
DataRow[] drs = dt.Select(string.Format("PCSSER = '{0}'", (BordIndex[i]).ToString()));
if (drs.Length == 1)
{
try
{
result[i] = short.Parse((string)drs[0]["RESULT"]);
}
catch (Exception ex)
{
AddMessage(ex.Message);
checkrst = false;
break;
}
}
else
{
AddMessage("板 " + barcode + " 序号 " + (BordIndex[i]).ToString() + "索引数 " + drs.Length.ToString());
checkrst = false;
break;
}
}
if (checkrst)
{
string str;
switch (index)
{
case 0:
Fx5u.WriteMultD("D1000", result);
str = "A_BordInfo;";
for (int i = 0; i < 96; i++)
{
str += result[i].ToString() + ";";
}
str = str.Substring(0, str.Length - 1);
AddMessage(str);
Fx5u.SetM("M2504", true);
break;
case 1:
Fx5u.WriteMultD("D1100", result);
str = "B_BordInfo;";
for (int i = 0; i < 96; i++)
{
str += result[i].ToString() + ";";
}
str = str.Substring(0, str.Length - 1);
AddMessage(str);
Fx5u.SetM("M2506", true);
break;
default:
break;
}
}
else
{
switch (index)
{
case 0:
Fx5u.SetM("M2505", true);
break;
case 1:
Fx5u.SetM("M2507", true);
break;
default:
break;
}
}
}
else
{
AddMessage("板 " + barcode + " 产品信息条目 " + dt.Rows.Count.ToString() + " < 96");
switch (index)
{
case 0:
Fx5u.SetM("M2505", true);
break;
case 1:
Fx5u.SetM("M2507", true);
break;
default:
break;
}
}
}
}
}
else
{
AddMessage("板 " + barcode + " 信息未录入");
switch (index)
{
case 0:
Fx5u.SetM("M2505", true);
break;
case 1:
Fx5u.SetM("M2507", true);
break;
default:
break;
}
}
}
else
{
AddMessage("Mysql数据库查询失败");
switch (index)
{
case 0:
Fx5u.SetM("M2505", true);
break;
case 1:
Fx5u.SetM("M2507", true);
break;
default:
break;
}
}
mysql.DisConnect();
}
catch (Exception ex)
{
AddMessage(ex.Message);
}
}
else
{
switch (index)
{
case 0:
Fx5u.SetM("M2505", true);
break;
case 1:
Fx5u.SetM("M2507", true);
break;
default:
break;
}
}
}
void mysql_OnError(object sender, Mysql.MysqlConnection.MysqlErrorEventArgs e)
{
MessageBox.Show(e.getException().Message);
}
public override void GetFromDatabase()
{
string sql = $"SELECT * FROM `temp_products` where `id` = '{ID}'";
CreateFromRow(Mysql.RunQueryWithReturn(sql).RowData[0]);
}
async void UpdateUI()
{
while (true)
{
await Task.Delay(200);
#region 更新界面
if (Fx5u.Connect)
{
EllipsePLCState.Fill = Brushes.Green;
}
else
{
EllipsePLCState.Fill = Brushes.Red;
}
if (Fx5u_2.Connect)
{
EllipsePLCState2.Fill = Brushes.Green;
}
else
{
EllipsePLCState2.Fill = Brushes.Red;
}
CycleText.Text = SWms.ToString() + " ms";
#endregion
#region 换班
if (LastBanci != GetBanci())
{
LastBanci = GetBanci();
Inifile.INIWriteValue(iniParameterPath, "Summary", "LastBanci", LastBanci);
LampGreenElapse = 0;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenElapse", LampGreenElapse.ToString());
LampGreenFlickerElapse = 0;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenFlickerElapse", LampGreenFlickerElapse.ToString());
LampYellowElapse = 0;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowElapse", LampYellowElapse.ToString());
LampYellowFlickerElapse = 0;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowFlickerElapse", LampYellowFlickerElapse.ToString());
LampRedElapse = 0;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampRedElapse", LampRedElapse.ToString());
await Task.Run(() =>
{
Mysql mysql = new Mysql();
try
{
int _result = -999;
if (mysql.Connect())
{
string stm = string.Format("INSERT INTO HA_F4_LIGHT (PM,LIGHT_ID,MACID,CLASS,LIGHT,SDATE,STIME,ALARM,TIME_1,TIME_2,TIME_3,TIME_4,TIME_5,GROUP1,TRACK,WORKSTATION) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','0','0','0','0','0','{8}','{9}','{10}')"
, _PM, _LIGHT_ID, _MACID, GetBanci(), LampColor.ToString(), DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("HHmmss"), "NA", _GROUP1, _TRACK, _WORKSTATION);
_result = mysql.executeQuery(stm);
}
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage("插入数据库灯信号" + _result.ToString());
}));
}
catch (Exception ex)
{
this.Dispatcher.Invoke(new Action(() =>
{
AddMessage(ex.Message);
}));
}
finally
{
mysql.DisConnect();
}
});
Fx5u_2.SetM("M2606", true);
CardLockFlag = true;
CardLockTime = DateTime.Now;
AddMessage("机台锁定!");
AddMessage(LastBanci + " 换班数据清零");
}
#endregion
}
}
async void BigDataRun()
{
int _LampColor = LampColor;
int count1 = 0;
LampGreenSw.Start();
bool first = true;
while (true)
{
await Task.Delay(1000);//每秒刷新
#region 报警
if (M300 != null && Fx5u_2.Connect)
{
for (int i = 0; i < AlarmList.Count; i++)
{
if (M300[i] != AlarmList[i].State && AlarmList[i].Content != "Null" && (LampGreenSw.Elapsed.TotalMinutes > 3 || first))
{
first = false;
LampGreenSw.Reset();
AlarmList[i].State = M300[i];
if (AlarmList[i].State)
{
CurrentAlarm = AlarmList[i].Content;
AlarmList[i].Start = DateTime.Now;
AlarmList[i].End = DateTime.Now;
AddMessage(AlarmList[i].Code + AlarmList[i].Content + "发生");
AlarmAction(i);//等待报警结束
}
}
}
}
#endregion
#region 灯号更新
switch (LampColor)
{
case 1:
LampGreenElapse += 1;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenElapse", LampGreenElapse.ToString());
break;
case 2:
LampGreenFlickerElapse += 1;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampGreenFlickerElapse", LampGreenFlickerElapse.ToString());
break;
case 3:
LampYellowElapse += 1;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowElapse", LampYellowElapse.ToString());
break;
case 4:
LampYellowFlickerElapse += 1;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampYellowFlickerElapse", LampYellowFlickerElapse.ToString());
break;
case 5:
LampRedElapse += 1;
Inifile.INIWriteValue(iniParameterPath, "BigData", "LampRedElapse", LampRedElapse.ToString());
break;
default:
break;
}
count1++;
if (_LampColor != LampColor || count1 > 60)
{
if (LampColor == 1 && _LampColor != LampColor)
{
LampGreenSw.Restart();
}
_LampColor = LampColor;
count1 = 0;
string result = await Task <string> .Run(() =>
{
try
{
int _result = -999;
Mysql mysql = new Mysql();
if (mysql.Connect())
{
string currentAlarm = LampColor == 4 ? CurrentAlarm : "NA";
string stm = string.Format("UPDATE HA_F4_LIGHT SET LIGHT = '{3}',SDATE = '{4}',STIME = '{5}',ALARM = '{6}',TIME_1 = '{8}',TIME_2 = '{9}',TIME_3 = '{10}',TIME_4 = '{11}',TIME_5 = '{12}' WHERE PM = '{0}' AND LIGHT_ID = '{1}' AND MACID = '{2}' AND CLASS = '{7}'"
, _PM, _LIGHT_ID, _MACID, LampColor.ToString(), DateTime.Now.ToString("yyyyMMdd"), DateTime.Now.ToString("HHmmss"), currentAlarm, GetBanci(), ((double)LampGreenElapse / 60).ToString("F2"), ((double)LampGreenFlickerElapse / 60).ToString("F2"), ((double)LampYellowElapse / 60).ToString("F2")
, ((double)LampYellowFlickerElapse / 60).ToString("F2"), ((double)LampRedElapse / 60).ToString("F2"));
_result = mysql.executeQuery(stm);
}
mysql.DisConnect();
return(_result.ToString());
}
catch (Exception ex)
{
return(ex.Message);
}
});
//AddMessage("更新灯信号" + result);
}
if (LampColor != 1)
{
LampGreenSw.Reset();
}
if (LampColor == 1 && LampGreenSw.Elapsed == TimeSpan.Zero)
{
LampGreenSw.Restart();
}
#endregion
#region 机台指标
#endregion
GreenElapse.Text = LampGreenSw.Elapsed.TotalMinutes.ToString("F1") + " min";
}
}
public override void GetFromDatabase()
{
string getQuery = $"SELECT * FROM `sale_transactions` WHERE `id` = '{_id}'";
CreateFromRow(Mysql.RunQueryWithReturn(getQuery).RowData[0]);
}
