//加载测量数据 private void ReflashData() { string s检验工位 = this.s检验工位; if (s检验工位 == "") { return; } SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { string sSQL = @" select * from [dbo].[检验值] a left join [dbo].[检验标准档案] b on a.发射器编号 = b.发射器ID where isnull(a.已取值,0) = 0 and a.dtmCreate >= '{0}' and a.发射器编号 in (select 发射器ID from [dbo].[发射器档案设置] where [检验工位] = '{1}') order by a.iID "; sSQL = string.Format(sSQL, dtmStart.ToString("yyyy-MM-dd HH:mm:ss"), s检验工位); System.Data.DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dt != null && dt.Rows.Count > 0) { s发射器ID = dt.Rows[0]["发射器编号"].ToString().Trim(); s量具品名 = dt.Rows[0]["量具品名"].ToString().Trim(); s测定项目 = dt.Rows[0]["测定项目"].ToString().Trim(); s测定项目日文 = dt.Rows[0]["测定项目日文"].ToString().Trim(); s尺寸公差 = dt.Rows[0]["尺寸公差"].ToString().Trim(); decimal d上限 = 9999999999999; if (dt.Rows[0]["上限"].ToString().Trim() != "") { d上限 = BaseFunction.ReturnDecimal(dt.Rows[0]["上限"]); } decimal d下限 = 0; if (dt.Rows[0]["下限"].ToString().Trim() != "") { d下限 = BaseFunction.ReturnDecimal(dt.Rows[0]["下限"]); } d测量值 = BaseFunction.ReturnDecimal(dt.Rows[0]["测量数值"]); if (d测量值 <= d上限 && d测量值 >= d下限) { sStatus = "OK"; } else { sStatus = "NG"; Interaction.Beep(); } Model.工作台测量 mod = new 业务.Model.工作台测量(); mod.发射器ID = BaseFunction.ReturnInt(dt.Rows[0]["发射器编号"]); mod.工作台 = s检验工位; mod.量具品名 = dt.Rows[0]["量具品名"].ToString().Trim(); mod.测定项目 = dt.Rows[0]["测定项目"].ToString().Trim(); mod.测定项目日文 = dt.Rows[0]["测定项目日文"].ToString().Trim(); mod.规格 = dt.Rows[0]["规格"].ToString().Trim(); mod.尺寸公差 = dt.Rows[0]["尺寸公差"].ToString().Trim(); if (dt.Rows[0]["下限"].ToString().Trim() != "") { mod.限 = BaseFunction.ReturnDecimal(dt.Rows[0]["下限"]); } if (dt.Rows[0]["上限"].ToString().Trim() != "") { mod.限 = BaseFunction.ReturnDecimal(dt.Rows[0]["上限"]); } mod.测量值 = BaseFunction.ReturnDecimal(dt.Rows[0]["测量数值"]); mod.原始值 = BaseFunction.ReturnDecimal(dt.Rows[0]["测量数值"]); mod.备注 = dt.Rows[0]["备注"].ToString().Trim(); mod.检验员 = sUserName; mod.班组 = this.s班组; mod.检验时间 = BaseFunction.ReturnDate(dt.Rows[0]["dtmCreate"]); mod.操作员 = sUserName; mod.SourceID = BaseFunction.ReturnLong(dt.Rows[0]["iID"]); DAL.工作台测量 dal = new 业务.DAL.工作台测量(); sSQL = dal.Add(mod); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" update [dbo].[检验值] set [已取值] = 1 where iID = {0} "; sSQL = string.Format(sSQL, mod.SourceID); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); } tran.Commit(); } catch (Exception ee) { tran.Rollback(); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
private void ReflashData() { string s检验工位 = lookUpEdit检验工位.Text.Trim(); if (s检验工位 == "") { return; } if (dateEdit单据日期.Text.Trim() == "" || dateEdit单据日期.DateTime < BaseFunction.ReturnDate("2018-10-01")) { return; } SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString); conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { string sSQL = @" select * from [dbo].[检验值] a left join [dbo].[检验标准档案] b on a.发射器编号 = b.发射器ID where isnull(a.已取值,0) = 0 and a.dtmCreate >= '{0}' and a.发射器编号 in (select 发射器ID from [dbo].[发射器档案设置] where [检验工位] = '{1}') order by a.iID "; sSQL = string.Format(sSQL, dateEdit单据日期.DateTime.ToString("yyyy-MM-dd HH:mm:ss"), s检验工位); DataTable dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; if (dt != null && dt.Rows.Count > 0) { txt发射器ID.EditValue = dt.Rows[0]["发射器编号"].ToString().Trim(); txt量具品名.EditValue = dt.Rows[0]["量具品名"].ToString().Trim(); txt测定项目.EditValue = dt.Rows[0]["测定项目"].ToString().Trim(); txt测定项目日文.EditValue = dt.Rows[0]["测定项目日文"].ToString().Trim(); txt尺寸公差.EditValue = dt.Rows[0]["尺寸公差"].ToString().Trim(); decimal d上限 = 9999999999999; if (dt.Rows[0]["上限"].ToString().Trim() != "") { d上限 = BaseFunction.ReturnDecimal(dt.Rows[0]["上限"]); txt上限.EditValue = d上限; } else { txt上限.EditValue = "MAX"; } decimal d下限 = 0; if (dt.Rows[0]["下限"].ToString().Trim() != "") { d下限 = BaseFunction.ReturnDecimal(dt.Rows[0]["下限"]); txt下限.EditValue = d下限; } decimal d测量值 = BaseFunction.ReturnDecimal(dt.Rows[0]["测量数值"]); txt测量值.EditValue = d测量值; if (d测量值 <= d上限 && d测量值 >= d下限) { txtStatus.Text = "OK"; txtStatus.ForeColor = Color.Black; } else { txtStatus.Text = "NG"; txtStatus.ForeColor = Color.Red; } Model.工作台测量 mod = new 业务.Model.工作台测量(); mod.发射器ID = BaseFunction.ReturnInt(dt.Rows[0]["发射器编号"]); mod.工作台 = s检验工位; mod.量具品名 = dt.Rows[0]["量具品名"].ToString().Trim(); mod.测定项目 = dt.Rows[0]["测定项目"].ToString().Trim(); mod.测定项目日文 = dt.Rows[0]["测定项目日文"].ToString().Trim(); mod.规格 = dt.Rows[0]["规格"].ToString().Trim(); mod.尺寸公差 = dt.Rows[0]["尺寸公差"].ToString().Trim(); if (dt.Rows[0]["下限"].ToString().Trim() != "") { mod.限 = BaseFunction.ReturnDecimal(dt.Rows[0]["下限"]); } if (dt.Rows[0]["上限"].ToString().Trim() != "") { mod.限 = BaseFunction.ReturnDecimal(dt.Rows[0]["上限"]); } mod.测量值 = BaseFunction.ReturnDecimal(dt.Rows[0]["测量数值"]); mod.原始值 = BaseFunction.ReturnDecimal(dt.Rows[0]["测量数值"]); mod.备注 = dt.Rows[0]["备注"].ToString().Trim(); mod.检验员 = txt检验员.Text.Trim(); mod.检验时间 = BaseFunction.ReturnDate(dt.Rows[0]["dtmCreate"]); mod.操作员 = sUserName; mod.SourceID = BaseFunction.ReturnLong(dt.Rows[0]["iID"]); DAL.工作台测量 dal = new 业务.DAL.工作台测量(); sSQL = dal.Add(mod); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" update [dbo].[检验值] set [已取值] = 1 where iID = {0} "; sSQL = string.Format(sSQL, mod.SourceID); DbHelperSQL.ExecuteNonQuery(tran, CommandType.Text, sSQL); sSQL = @" select top 20 * from 工作台测量 where 工作台 = '{0}' and dtmCreate >= dateadd(hour,-2,getdate()) and isnull(删除人,'') = '' order by iID desc "; sSQL = string.Format(sSQL, s检验工位); dt = DbHelperSQL.ExecuteDataset(tran, CommandType.Text, sSQL).Tables[0]; gridControl1.DataSource = dt; gridView1.FocusedRowHandle = 0; txt序号.EditValue = dt.Rows[0]["iID"].ToString().Trim(); SetTxtEnable(false); } tran.Commit(); } catch (Exception ee) { tran.Rollback(); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }