/// <summary>
/// 插入产品信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
///DateTime theDate = DateTime.Now;
// theDate.ToString("yyyy-MM-dd HH:mm:ss");
string dateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "insert into production (lineid,brakename,brakeid,brakecode,createtime,factory,remark)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')";
// strSql = string.Format(strSql, mdl.LineNum, mdl.ProductName, mdl.ProductID, mdl.ProductCode, dateTime, mdl.Factory, mdl.Remark);
//ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
//}
public Hashtable GetProductCTTable2()
{
Hashtable ctTable = new Hashtable();
try
{
DataSet dataSet = null;
//string strSql = "SELECT * FROM tlb_product ORDER BY CREATE_TIME ASC";
string strSql = "SELECT * FROM tlb_product ";
dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet != null)
{
foreach (DataRow row in dataSet.Tables[0].Rows)
{
ProductionMDL mdl = ProductionMDL.ParseDataRow(row);
CTUnitMDL unit = new CTUnitMDL();
unit.PN = mdl.PN;
unit.CT = mdl.CT;
unit.EMS = mdl.EMS;
unit.OP = mdl.OP;
ctTable.Add(mdl.PN, unit);
}
}
return(ctTable);
}
catch
{
throw;
}
}
/// <summary>
/// 插入产品信息
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
//DateTime theDate = DateTime.Now;
//theDate.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "insert into tlb_product (PN,PLID,NAME ,EMS,CREATE_TIME,CODE,TYPE,FACTORY,CT,OP,REMARK)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')";
strSql = string.Format(strSql, mdl.PN, mdl.PLID, mdl.Name, mdl.EMS, DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
, mdl.Code, mdl.CodeType, mdl.Factory, mdl.CT, mdl.OP, mdl.Remark);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
private void btAdd_Click(object sender, EventArgs e)
{
try
{
if (this.txtName.Text.Trim().Length < 1)
{
MessageBox.Show("请填写产品名称！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (this.txtID.Text.Trim().Length < 1)
{
MessageBox.Show("请填填写产品ID！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (this.txtCode.Text.Trim().Length < 1)
{
MessageBox.Show("请填填写产品编码！", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (isUpdate)
{
//Modidfy by guozq 2016-9-6
//production.LineNum = this.cbLineNum.SelectedIndex+1;
//production.ProductName = this.txtName.Text.Trim();
//production.ProductID = this.txtID.Text.Trim();
//production.ProductCode = this.txtCode.Text.Trim();
production.Factory = this.txtFactory.Text.Trim();
production.Remark = this.txtRemark.Text.Trim();
}
else
{
production = new ProductionMDL();
//production.LineNum = this.cbLineNum.SelectedIndex + 1;
//production.ProductName = this.txtName.Text.Trim();
//production.ProductID = this.txtID.Text.Trim();
//production.ProductCode = this.txtCode.Text.Trim();
production.Factory = this.txtFactory.Text.Trim();
production.Remark = this.txtRemark.Text.Trim();
}
//info.Remark = this.txtRemark.Text.Trim();
this.DialogResult = DialogResult.OK;
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
/// <summary>
/// 查询过去CTUNIT
/// </summary>
/// <param name="LineID"></param>
/// <param name="ems"></param>
/// <returns></returns>
public CTUnitMDL GetCTUnit(string lineid, int ems)
{
CTUnitMDL unit = null;
try
{
int id = 0;
Int32.TryParse(lineid, out id);
if (id <= 0)
{
return(null);
}
string strSql = "SELECT * FROM tlb_product WHERE PLID='{0}' AND EMS={1}";
strSql = string.Format(strSql, id.ToString(), ems);
DataSet dataSet = null;
dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
ProductionMDL mdl = ProductionMDL.ParseDataRow(dataSet.Tables[0].Rows[0]);
unit = new CTUnitMDL();
unit.PN = mdl.PN;
unit.CT = mdl.CT;
unit.EMS = mdl.EMS;
unit.OP = mdl.OP;
return(unit);
}
else
{
return(null);
}
}
catch
{
return(null);
}
}
public ProductionMDL GetProductInfo(string lineID, int ems)
{
ProductionMDL mdl = null;
try
{
string strSql = string.Empty;
int nline = 0;
Int32.TryParse(lineID, out nline);
if (nline <= 0)
{
return(null);
}
strSql = "select * from tlb_product where PLID='{0}' and EMS='{1}'";
strSql = string.Format(strSql, nline.ToString(), ems);
DataSet dataSet = MySqlDBHelper.ExecuteDataSet(MySqlDBHelper.Conn, CommandType.Text, strSql);
if (dataSet == null || dataSet.Tables.Count <= 0)
{
return(null);
}
//解析数据
mdl = ProductionMDL.ParseDataRow(dataSet.Tables[0].Rows[0]);
return(mdl);
}
catch
{
throw;
}
}
/// <summary>
/// 更新产品信息
/// </summary>
/// <param name="info"></param>
public int UpdateProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
strSql = "UPDATE tlb_product SET NAME='{0}',PN='{1}',CODE='{2}',TYPE={3},FACTORY='{4}',CT={5},OP={6},REMARK='{7}' WHERE EMS={8} AND PLID={9}";
strSql = string.Format(strSql, mdl.Name, mdl.PN, mdl.Code, mdl.CodeType, mdl.Factory, mdl.CT, mdl.OP, mdl.Remark, mdl.EMS, mdl.PLID);
ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql, null);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 更新产品信息
/// </summary>
/// <param name="info"></param>
public int UpdateProduction(ProductionMDL mdl)
{
int ret = 0;
string strSql = string.Empty;
try
{
//DateTime theDate = DateTime.Now;
//theDate.ToString("yyyy-MM-dd HH:mm:ss");
string dateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
strSql = "update production set lineid='{0}',brakename='{1}',brakeid='{2}',brakecode='{3}',factory='{4}',remark='{5}' where tid='{6}'";
// strSql = string.Format(strSql, mdl.LineNum, mdl.ProductName, mdl.ProductID, mdl.ProductCode, mdl.Factory, mdl.Remark, mdl.TID);
// ret = MySqlDBHelper.ExecuteNonQuery(MySqlDBHelper.Conn, CommandType.Text, strSql,null);
ret = SQLiteDBHelper.ExecuteNonQuery(strSql);
return(ret);
}
catch (Exception ex)
{
CLog.WriteErrLogInTrace(ex.Message);
return(0);
}
}
/// <summary>
/// 更新采集单元数据
/// </summary>
/// <param name="mdl"></param>
/// <param name="curUnit"></param>
/// <returns></returns>
public int UpdateAcqUnitData(ref AcqLineItemMDL mdl)
{
int ret = -1;
try
{
AcqLineDAL acqDal = new AcqLineDAL();
ProductDal pdal = new ProductDal();
//获取PN编码
//
ProductionMDL productmdl = pdal.GetProductInfo(mdl.PLID, mdl.EMS);
//存在产品编码
if (mdl == null || mdl.PN == string.Empty)
{
mdl.PN = "N/A";
}
mdl.PN = productmdl.PN;
////判断是存在有历史数据，有更新区间信息
////有历史数据
if (acqDal.AcqUintExist2(mdl.PLID, mdl.EMS, mdl.UNITID) > 0)
{
//获取当前区间的计数
//int percount = GetLastRangCount(mdl);
AcqLineItemMDL lastItem = GetLastUnit(mdl);
//加一个脉冲信号
lastItem.PR_COUNT += 1;
//加一个脉冲信号
CLog.WriteStationLog("PRE_COUNT", mdl.UNITID + "-" + lastItem.PR_COUNT.ToString());
//更新结束时间 和 当前开始时段的时间信息
mdl.TID = lastItem.TID;
mdl.TGNAME = lastItem.TGNAME;
mdl.PR_COUNT = lastItem.PR_COUNT;
mdl.START_TIME = lastItem.START_TIME;
mdl.END_TIME = DateTime.Now;
mdl.TIME_LENGTH = TimeRange.ExecDateDiffSecond(lastItem.START_TIME, mdl.END_TIME);
mdl.UPDATE_TIME = mdl.END_TIME;
ret = acqDal.UpdateAcqLineUint(mdl);
}
else///当前时段的新项目
{
int uintSeq = acqDal.IsUionAcqUint(mdl.UNITID, mdl.PLID);
mdl.START_TIME = DateTime.Now;
mdl.END_TIME = mdl.START_TIME;
//型号发生变化重新计数 同时表示换型了
if (uintSeq > 0)
{
uintSeq += 1;
string strSeq = String.Format("{0:D2}", uintSeq);
mdl.SetTID(mdl.START_TIME, mdl.PLID, mdl.TGNAME, strSeq);
}
// mdl.UPDATE_TIME = DateTime.Now;
if (productmdl != null || productmdl.OP != 0)
{
mdl.START_TIME = DateTime.Now.AddSeconds(-productmdl.OP);
}
else
{
mdl.START_TIME = DateTime.Now;
}
mdl.TIME_LENGTH = TimeRange.ExecDateDiffSecond(mdl.START_TIME, mdl.END_TIME);
//更新上一个区间产品的时间
AcqLineDAL updateDal = new AcqLineDAL();
updateDal.UpdateAclineUnitByLastUnit(DateTime.Now, mdl.PLID);
// modify by guozq 2018/3/26
//添加采集数据
ret = acqDal.AddAcqLine1(mdl);
}
}
catch
{
throw;
}
return(ret);
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
this.dataGridView1.CellValueChanged -= new DataGridViewCellEventHandler(dataGridView1_CellContentClick);
DataRow rd = null;
switch (e.ColumnIndex)
{
case 5:
ProductionInfo addInfoForm = new ProductionInfo();
addInfoForm.IsUpdate = true;
rd = this.infos.Rows[e.RowIndex];
ProductionMDL info = new ProductionMDL();
info.Load(rd);
addInfoForm.Production = info;
if (addInfoForm.ShowDialog() == DialogResult.OK)
{
ProductDal dal = new ProductDal();
if (dal.UpdateProduction(info) > 0)
{
this.LoadDataGridView();
MessageBox.Show("修改产品信息成功！");
}
else
{
MessageBox.Show("修改产品信息失败！");
}
}
break;
case 6:
if (MessageBox.Show("确定要删除该产品信息吗？", "系统提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
rd = this.infos.Rows[e.RowIndex];
int id = Convert.ToInt32(rd["tid"]);
ProductDal dal = new ProductDal();
if (dal.DeleteProduction(id) > 0)
{
this.LoadDataGridView();
}
else
{
MessageBox.Show("删除产品信息失败！");
}
}
break;
default:
break;
}
this.dataGridView1.CellValueChanged += new DataGridViewCellEventHandler(dataGridView1_CellContentClick);
}
private void btConvert_Click(object sender, EventArgs e)
{
if (this.txtPath.Text == null || this.txtPath.Text == String.Empty)
{
MessageBox.Show("请填选择导入文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
try
{
string selectFile = this.txtPath.Text.Trim();
if (selectFile == null || selectFile == string.Empty)
{
MessageBox.Show("未获导入数据信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
//if (openFileDialog.ShowDialog() == DialogResult.Yes)
//{
// csvTable = CSVFileHelper.OpenCSV(selectFile);
//}
//else
//{
// this.txtPath.Text = String.Empty;
// this.lbContent.Text = String.Empty;
//}
DataTable csvTable = null;
csvTable = CSVFileHelper.OpenCSV(selectFile);
if (csvTable == null || csvTable.Rows.Count <= 1)
{
MessageBox.Show("未获导入数据信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (csvTable.Columns == null)
{
MessageBox.Show("未获导入正确数据信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (csvTable.Columns.Count != 5)
{
MessageBox.Show("未获导入正确数据信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (csvTable.Columns[0].ColumnName != "PN")
{
MessageBox.Show("未获导入正确数据信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (MessageBox.Show("请确保产线为非生产状态，确定更新请选择‘是’", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.No)
{
return;
}
ProductDal dal = new ProductDal();
int countAdd = 0;
int countRef = 0;
int count = csvTable.Rows.Count;
double div = (double)count / 100;
double pogressValue = 0;
foreach (DataRow row in csvTable.Rows)
{
ProductionMDL mdl = new ProductionMDL();
mdl = ProductionMDL.ParseDataRow(row);
int ret = -1;
pogressValue += div;
if (dal.IsExist(mdl.PN) > 0)
{
ret = dal.UpdateProduction(mdl);
if (ret > 0)
{
countRef++;
UpdateContentInfo(mdl.PN + "更新成功", (int)div);
}
else
{
UpdateContentInfo(mdl.PN + "更新失败", (int)div);
}
}
else
{
ret = dal.InsertProduction(mdl);
if (ret > 0)
{
countAdd++;
UpdateContentInfo(mdl.PN + "入库成功", (int)div);
}
else
{
UpdateContentInfo(mdl.PN + "入库失败", (int)div);
}
}
}
// UpdateContentInfo((countAdd+countRef).ToString() + "记录入库成功！");
MessageBox.Show((countAdd + countRef).ToString() + "记录入库成功！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (System.Exception ex)
{
MessageBox.Show(ex.Message.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
