//插入资料用
public static IList<EY_Scale_Value> GetRegNo1(EY_Scale_Value_PK id)
{
using (ISession session = SessionHelper.GetSession())
{
IQuery query = session.CreateQuery("from EY_Scale_Value as a where a.Id = :s ");
query.SetParameter("s", id);
return query.List<EY_Scale_Value>();
}
}
public void Writelog(string Oldvalue, string Newvalue, string matrname, EY_Scale_Value_PK idd)
{
IList<EY_Scale_Value> zzz = EY_Scale_Value_Dao.GetRegNo1(idd);
foreach (EY_Scale_Value t in zzz)
{
EY_DataChange_Log LOG = new EY_DataChange_Log();
LOG.OldValue = Oldvalue;
LOG.NewValue = Newvalue;
LOG.Operator1 = textBoxX4.Text;
LOG.Date = System.DateTime.Now;
LOG.RegNo = t.Id.RegNo;
LOG.CheckNo = t.Id.CheckNo;
LOG.MatrName = t.Matrname;
LOG.RowName = matrname;
EY_DataChange_Log_DAO.Save(LOG);
}
}
public static void Update_ToErpFlag(EY_Scale_Value_PK spl, string st)
{
using (ISession session = SessionHelper.GetSession())
{
IQuery query = session.CreateQuery("update EY_Scale_Value as a set a.ToErpFlag = :t where a.Id= :s ");
query.SetParameter("s", spl);
query.SetString("t", st);
//query.SetString("k", cell);
query.ExecuteUpdate();
}
}
public static IList<EY_Scale_Value> Update_Status(EY_Scale_Value_PK spl , string st)
{
using (ISession session = SessionHelper.GetSession())
{
IQuery query = session.CreateQuery("update EY_Scale_Value as a set a.Status = :t where a.Id= :s and a.FinalValue !='' and a.FinalValue != 0");
query.SetParameter("s", spl);
query.SetString("t", st);
//query.SetString("k", cell);
query.ExecuteUpdate();
// return query.List<EY_Scale_Value>();
return null;
}
}
public static IList<EY_Scale_Value> Update_OnlyValue(EY_Scale_Value_PK spl,decimal finalvalue)
{
using (ISession session = SessionHelper.GetSession())
{
IQuery query = session.CreateQuery("update EY_Scale_Value as a set a.FinalValue=:t where a.id= :s");
query.SetParameter("s", spl);
query.SetDecimal("t", finalvalue);
query.ExecuteUpdate();
// return query.List<EY_Scale_Value>();
return null;
}
}
//上传ERP
private void buttonX1_Click(object sender, EventArgs e)
{
string mess = "";
int k = 0;
int count = Convert.ToInt32(this.dataGridViewX1.Rows.Count.ToString());
for (int i = 0; i < count; i++)
{
DataGridViewCheckBoxCell checkCell = (DataGridViewCheckBoxCell)this.dataGridViewX1.Rows[i].Cells["Column2"];
Boolean flag = Convert.ToBoolean(checkCell.Value);
if (flag == true)
{
if (this.dataGridViewX1.Rows[i].Cells[6].Value.ToString().Trim() == "未上传")
{
string date = Convert.ToDateTime(this.dataGridViewX1.Rows[i].Cells[1].Value).ToString("yyyyMMddHHmmss").Substring(0,8).Trim();
string time = Convert.ToDateTime(this.dataGridViewX1.Rows[i].Cells[1].Value).ToString("yyyyMMddHHmmss").Substring(8, 6).Trim();
double water = Convert.ToDouble(this.dataGridViewX1.Rows[i].Cells[5].Value);
string str1 = water.ToString("0.00");
mess = "N" + "###" + this.dataGridViewX1.Rows[i].Cells[2].Value.ToString().Trim() + "###" + str1 + "###" + date + "###" + time;
tbdipdo tbdipdo = new tbdipdo();
tbdipdo.TimeStamp = Convert.ToDecimal(DateTime.Now.ToString("yyyyMMddHHmmss"));
tbdipdo.Status = "N";
tbdipdo.SerialNo = Convert.ToDecimal(k);
tbdipdo.Header = "192.168.100.92" + "PJKFPTC" + DateTime.Now.ToString("yyyyMMddHHmmss");
tbdipdo.QueueId = "PJKFPTC";
tbdipdo.Data = mess;
tbdipdo_DAO.TBDIPDOSAVE(tbdipdo);
try
{
EY_Scale_Value_PK SPL = new EY_Scale_Value_PK();
SPL.RegNo = Convert.ToString(this.dataGridViewX1.Rows[i].Cells[2].Value);
SPL.CheckNo = Convert.ToString(this.dataGridViewX1.Rows[i].Cells[3].Value);
EY_Scale_Value_Dao.Update_ToErpFlag(SPL, "1");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
//EY_Scale_Value_PK SPL = new EY_Scale_Value_PK();
//SPL.RegNo = Convert.ToString(this.dataGridViewX1.Rows[i].Cells[2].Value);
//SPL.CheckNo = Convert.ToString(this.dataGridViewX1.Rows[i].Cells[3].Value);
//EY_Scale_Value_Dao.Update_ToErpFlag(SPL, "1");
k++;
}
}
}
MessageBox.Show("上传成功" + k.ToString() + "笔数据");
IList<EY_Scale_Value> EY_Scale_Value = EY_Scale_Value_Dao.GetScaleToErp("0");
displaydatagridview(EY_Scale_Value);
}
/// <summary>
/// 计算最终结果
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonX5_Click(object sender, EventArgs e)
{
int Row = dataGridViewX1.Rows.GetRowCount(DataGridViewElementStates.Displayed) - 1;
if (Row < 1)
{
//MessageBox.Show("没有数据可以ji", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
Decimal finalvalue;
int ss = EY_Scale_Value_Status();
if (ss == 0)
{
int rowcount = dataGridViewX1.SelectedRows.Count;
//int RowCount = dataGridViewX1.Rows.GetRowCount(DataGridViewElementStates.Displayed) - 1;
for (int i = 0; i < rowcount; i++)
{
Decimal watervalue = 0, Min0 = 0;
Decimal Min = Convert.ToDecimal(dataGridViewX1.SelectedRows[i].Cells[6].Value);
Decimal hengwgt2 = Convert.ToDecimal(dataGridViewX1.SelectedRows[i].Cells[7].Value);
Decimal Min1 = Convert.ToDecimal(dataGridViewX1.SelectedRows[i].Cells[8].Value);
Decimal hengwgt4 = Convert.ToDecimal(dataGridViewX1.SelectedRows[i].Cells[9].Value);
if (Min > 0)
Min0 = Min;
if (hengwgt2 < Min0 && hengwgt2 > 0)
Min0 = hengwgt2;
if (Min1 < Min0 && Min1 > 0)
Min0 = Min1;
if (hengwgt4 < Min0 && hengwgt4 > 0)
Min0 = hengwgt4;
Decimal final = (Convert.ToDecimal(dataGridViewX1.SelectedRows[i].Cells[4].Value) + Convert.ToDecimal(dataGridViewX1.SelectedRows[i].Cells[5].Value) - Min0) * 100 / Convert.ToDecimal(dataGridViewX1.SelectedRows[i].Cells[5].Value);
// IList<MTSICS_VO.EY_MatrTable> MatrTable = new List<EY_MatrTable>();
if (Convert.ToString(dataGridViewX1.SelectedRows[i].Cells[13].Value) != "DB")
{
string matrname = Convert.ToString(dataGridViewX1.SelectedRows[i].Cells[3].Value);
IList<EY_MatrTable> regNoList = EY_MatrTable_DAO.GetMatrTableWaterValue(matrname);
foreach (EY_MatrTable t in regNoList)
{
if (Convert.ToString(dataGridViewX1.SelectedRows[i].Cells[13].Value) == "XY")
{
if (t.Water_Range_Less == 8 && t.Water_Range_Grater == 8)
watervalue = t.Water_Value;
}
if ((t.Water_Range_Less == 0) && (t.Water_Range_Grater == 0))
{
watervalue = t.Water_Value;
}
//if (final <= t.Water_Range_Less && final > t.Water_Range_Grater &&( t.Water_Range_Less < final && final <= t.Water_Range_Grater))
// watervalue = t.Water_Value;
if (t.Water_Range_Less <= final && final < t.Water_Range_Grater)
watervalue = t.Water_Value;
//if (final > t.Water_Range_Grater)
// watervalue = t.Water_Value;
}
finalvalue = final + watervalue;
}
else
{
finalvalue = final;
}
dataGridViewX1.SelectedRows[i].Cells[10].Value = finalvalue;
EY_Scale_Value_PK SPL = new EY_Scale_Value_PK();
SPL.RegNo = Convert.ToString(dataGridViewX1.SelectedRows[i].Cells[1].Value);
SPL.CheckNo = Convert.ToString(dataGridViewX1.SelectedRows[i].Cells[2].Value);
//string regNo = Convert.ToString(dataGridViewX1.SelectedRows[i].Cells[6].Value);
// EY_Scale_Value_Dao.Update_OnlyValue(SPL, finalvalue);
//IList<EY_Scale_Value> zz = EY_Scale_Value_Dao.GetRegNo1(SPL);
//foreach (EY_Scale_Value t in zz)
// t.FinalValue = finalvalue;
EY_Scale_Value_Dao.Update_OnlyValue(SPL, finalvalue);
}
//saveIt();
}
buttonX3.Focus();
}
//修改数据
private void buttonX2_Click(object sender, EventArgs e)
{
int Row = dataGridViewX1.Rows.GetRowCount(DataGridViewElementStates.Displayed) - 1;
if (Row < 1)
{
MessageBox.Show("没有数据可以修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
int ss = EY_Scale_Value_Status();
if (ss == 0)
{
try
{
int RowCount = dataGridViewX1.Rows.GetRowCount(DataGridViewElementStates.Displayed) - 1;
for (int i = 0; i < RowCount; i++)
{
EY_Scale_Value EY_Scale_Value_Vo = new EY_Scale_Value();
EY_Scale_Value_PK ssss = new EY_Scale_Value_PK();
ssss.RegNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[1].Value);
ssss.CheckNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[2].Value);
EY_Scale_Value_Vo.Id = ssss;
IList<EY_Scale_Value> zzz = EY_Scale_Value_Dao.GetRegNo1(ssss);
foreach (EY_Scale_Value t in zzz)
{
EY_Scale_Value_Vo.Matrname = t.Matrname;
EY_Scale_Value_Vo.Date = t.Date;
EY_Scale_Value_Vo.PanWgt = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[4].Value);
if (EY_Scale_Value_Vo.PanWgt != t.PanWgt)
{
Writelog(Convert.ToString(t.PanWgt), Convert.ToString(EY_Scale_Value_Vo.PanWgt), "盘重",ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.YangWgt = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[5].Value);
if (EY_Scale_Value_Vo.YangWgt != t.YangWgt)
{
Writelog(Convert.ToString(t.YangWgt), Convert.ToString(EY_Scale_Value_Vo.YangWgt), "样重", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.HengWgt1 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[6].Value);
if (EY_Scale_Value_Vo.HengWgt1 != t.HengWgt1)
{
Writelog(Convert.ToString(t.HengWgt1), Convert.ToString(EY_Scale_Value_Vo.HengWgt1), "恒重1", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.HengWgt2 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[7].Value);
if (EY_Scale_Value_Vo.HengWgt2 != t.HengWgt2)
{
Writelog(Convert.ToString(t.HengWgt2), Convert.ToString(EY_Scale_Value_Vo.HengWgt2), "恒重2", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.HengWgt3 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[8].Value);
if (EY_Scale_Value_Vo.HengWgt3 != t.HengWgt3)
{
Writelog(Convert.ToString(t.HengWgt3), Convert.ToString(EY_Scale_Value_Vo.HengWgt3), "恒重3", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.HengWgt4 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[9].Value);
if (EY_Scale_Value_Vo.HengWgt4 != t.HengWgt4)
{
Writelog(Convert.ToString(t.HengWgt4), Convert.ToString(EY_Scale_Value_Vo.HengWgt4), "恒重4", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.FinalValue = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[10].Value);
if (EY_Scale_Value_Vo.FinalValue != t.FinalValue)
{
Writelog(Convert.ToString(t.FinalValue), Convert.ToString(EY_Scale_Value_Vo.FinalValue), "结果", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.Operator1 = t.Operator1;
EY_Scale_Value_Vo.Operator2 = Convert.ToString(dataGridViewX1.Rows[i].Cells[12].Value);
if (EY_Scale_Value_Vo.Operator2 != t.Operator2)
{
Writelog(Convert.ToString(t.Operator2), Convert.ToString(EY_Scale_Value_Vo.Operator2), "备注", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
EY_Scale_Value_Vo.Mem1 = Convert.ToString(dataGridViewX1.Rows[i].Cells[13].Value);
if (EY_Scale_Value_Vo.Mem1 != t.Mem1)
{
Writelog(Convert.ToString(t.Mem1 ), Convert.ToString(EY_Scale_Value_Vo.Mem1), "备注", ssss);
EY_Scale_Value_Vo.Flag = t.Flag + 1;
}
// EY_Scale_Value_Vo.ToErpFlag = "0";
//数据被修改过
EY_Scale_Value_Vo.Status = t.Status;
EY_Scale_Value_Vo.ToErpFlag = t.ToErpFlag;
//EY_Scale_Value_Vo.Mem1 = t.Mem1;
}
EY_Scale_Value_Dao.Update(EY_Scale_Value_Vo);
}
MessageBox.Show("修改数据成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else {
MessageBox.Show("已产制报表，无法修改数据，请联系管理员");
}
}
//保存数据
private void buttonX1_Click(object sender, EventArgs e)
{
try
{
int RowCount = dataGridViewX1.Rows.GetRowCount(DataGridViewElementStates.Displayed) - 1;
for (int i = 0; i < RowCount; i++)
{
EY_Scale_Value EY_Scale_Value_Vo = new EY_Scale_Value();
EY_Scale_Value_PK spk = new EY_Scale_Value_PK();
// EY_Scale_Value_Vo.Date = Convert.ToDateTime(dataGridViewX1.Rows[i].Cells[0].Value);
EY_Scale_Value_Vo.Date = Convert.ToDateTime(dataGridViewX1.Rows[i].Cells[0].Value);
spk.RegNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[1].Value);
spk.CheckNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[2].Value);
// EY_Scale_Value_Vo.RegNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[1].Value);
// EY_Scale_Value_Vo.CheckNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[2].Value);
EY_Scale_Value_Vo.Id = spk;
EY_Scale_Value_Vo.Matrname = Convert.ToString(dataGridViewX1.Rows[i].Cells[3].Value);
EY_Scale_Value_Vo.PanWgt = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[4].Value);
EY_Scale_Value_Vo.YangWgt = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[5].Value);
EY_Scale_Value_Vo.HengWgt1 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[6].Value);
EY_Scale_Value_Vo.HengWgt2 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[7].Value);
EY_Scale_Value_Vo.HengWgt3 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[8].Value);
EY_Scale_Value_Vo.HengWgt4 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[9].Value);
EY_Scale_Value_Vo.FinalValue = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[10].Value);
EY_Scale_Value_Vo.Operator1 = Convert.ToString(dataGridViewX1.Rows[i].Cells[11].Value);
EY_Scale_Value_Vo.Operator2 = Convert.ToString(dataGridViewX1.Rows[i].Cells[12].Value);
EY_Scale_Value_Vo.Mem1 = Convert.ToString(dataGridViewX1.Rows[i].Cells[13].Value);
////上传ERP标志位
//EY_Scale_Value_Vo.ToErpFlag = "0";
////修改标志位
//EY_Scale_Value_Vo.Flag = "0";
////产制报表后变Y后数据不可修改
//EY_Scale_Value_Vo.Status = "N";
if (EY_Scale_Value_Dao.GetRegNo1(EY_Scale_Value_Vo.Id).Count==0)
{
EY_Scale_Value_Vo.ToErpFlag = "0";
EY_Scale_Value_Vo.Flag = 0;
EY_Scale_Value_Vo.Status = "N";
EY_Scale_Value_Dao.Create(EY_Scale_Value_Vo);
}else
{
EY_Scale_Value_Dao.Update(EY_Scale_Value_Vo);
}
}
MessageBox.Show("保存数据成功");
}
catch(Exception ex)
{
MessageBox.Show("该批次已保存，请勿重复点击");
MessageBox.Show(ex.Message);
}
finally
{
SessionHelper.CloseSession();
}
}
//后台保存数据用
private void saveIt()
{
int ss = EY_Scale_Value_Status();
if (ss == 0)
{
try
{
int RowCount = dataGridViewX1.Rows.GetRowCount(DataGridViewElementStates.Displayed) - 1;
for (int i = 0; i < RowCount; i++)
{
EY_Scale_Value EY_Scale_Value_Vo = new EY_Scale_Value();
EY_Scale_Value_PK spk = new EY_Scale_Value_PK();
// EY_Scale_Value_Vo.Date = Convert.ToDateTime(dataGridViewX1.Rows[i].Cells[0].Value);
EY_Scale_Value_Vo.Date = Convert.ToDateTime(dataGridViewX1.Rows[i].Cells[0].Value);
spk.RegNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[1].Value);
spk.CheckNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[2].Value);
// EY_Scale_Value_Vo.RegNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[1].Value);
// EY_Scale_Value_Vo.CheckNo = Convert.ToString(dataGridViewX1.Rows[i].Cells[2].Value);
EY_Scale_Value_Vo.Id = spk;
EY_Scale_Value_Vo.Matrname = Convert.ToString(dataGridViewX1.Rows[i].Cells[3].Value);
EY_Scale_Value_Vo.PanWgt = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[4].Value);
EY_Scale_Value_Vo.YangWgt = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[5].Value);
EY_Scale_Value_Vo.HengWgt1 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[6].Value);
EY_Scale_Value_Vo.HengWgt2 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[7].Value);
EY_Scale_Value_Vo.HengWgt3 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[8].Value);
EY_Scale_Value_Vo.HengWgt4 = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[9].Value);
EY_Scale_Value_Vo.FinalValue = Convert.ToDecimal(dataGridViewX1.Rows[i].Cells[10].Value);
EY_Scale_Value_Vo.Operator1 = Convert.ToString(dataGridViewX1.Rows[i].Cells[11].Value);
EY_Scale_Value_Vo.Operator2 = Convert.ToString(dataGridViewX1.Rows[i].Cells[12].Value);
EY_Scale_Value_Vo.Mem1 = Convert.ToString(dataGridViewX1.Rows[i].Cells[13].Value);
EY_Scale_Value_Vo.ToErpFlag = "0";
EY_Scale_Value_Vo.Flag = 0;
EY_Scale_Value_Vo.Status = "N";
if (EY_Scale_Value_Dao.GetRegNo1(EY_Scale_Value_Vo.Id).Count == 0)
{
//EY_Scale_Value_Vo.ToErpFlag = "0";
//EY_Scale_Value_Vo.Flag = "0";
//EY_Scale_Value_Vo.Status = "N";
EY_Scale_Value_Dao.Create(EY_Scale_Value_Vo);
}
else
{
EY_Scale_Value_Dao.Update(EY_Scale_Value_Vo);
}
}
// MessageBox.Show("保存数据成功");
}
catch (Exception ex)
{
MessageBox.Show("saveit方法报错");
MessageBox.Show(ex.Message);
}
//finally
//{
// SessionHelper.CloseSession();
//}
}
}
//获取数据库数据，产制报表
private DataTable GetData()
{
DataTable table = new DataTable("table1");
//使用自动增量时必须设置为SqlInt64
//table.Columns.Add("id", typeof(SqlInt64));
//table.Columns["id"].AutoIncrement = true;
// table.Columns.Add("id", typeof(SqlInt32));
//设置主键，主键可以是一个或者多个DataColumns对象组成的数组
DataColumn[] key = new DataColumn[2];
// key[0] = table.Columns["id"];
// table.PrimaryKey = key;
//SqlString相当于SQL SERVER类型中的nvarchar
MessageBox.Show("报表产制中，产制完毕会弹出，请稍候....");
table.Columns.Add("日期", typeof(SqlDateTime));
table.Columns.Add("案件接收编号", typeof(SqlString));
table.Columns.Add("检验批号", typeof(SqlString));
table.Columns.Add("料名", typeof(SqlString));
//key[0] = table.Columns["案件接收编号"];
//key[1] = table.Columns["中文名称"];
//table.PrimaryKey = key;
//table.Columns.Add("料名", typeof(SqlString));
table.Columns.Add("盘重", typeof(SqlDecimal));
table.Columns.Add("样重", typeof(SqlDecimal));
table.Columns.Add("恒重1", typeof(SqlDecimal));
table.Columns.Add("恒重2", typeof(SqlDecimal));
table.Columns.Add("恒重3", typeof(SqlDecimal));
table.Columns.Add("恒重4", typeof(SqlDecimal));
table.Columns.Add("结果", typeof(SqlDecimal));
table.Columns.Add("检测员1", typeof(SqlString));
table.Columns.Add("检测员2", typeof(SqlString));
table.Columns.Add("备注", typeof(SqlString));
//table.Columns.Add("年龄", typeof(SqlInt32));
//table.Columns.Add("出生日期", typeof(SqlDateTime));
DateTime tem = dateTimePicker2.Value;
string year = tem.Year.ToString();
string month = tem.Month.ToString();
string day = tem.Day.ToString();
string date = year + "/" + month + "/" + day;
MessageBox.Show(date + " 00:00:00");
String ss = date + " 00:00:00";
// String ss = tem.ToString().Substring(0, 9).Trim() + " 00:00:00";
tem = DateTime.Parse(ss);
IList<EY_Batch> allBatch = EY_Batch_DAO.LoadByTime(tem, tem.AddHours(24));
int i = 0;
foreach (EY_Batch t in allBatch)
{
IList<EY_RegNo_DI> reg = EY_RegNo_DI_DAO.GetRegNo1(t.BatchNo);
foreach (EY_RegNo_DI a in reg)
{
EY_Scale_Value_PK id = new EY_Scale_Value_PK();
id.RegNo = a.RegNo;
id.CheckNo = a.CheckNo;
// EY_Scale_Value_Dao.Update_Status(id , "Y");
IList<EY_Scale_Value> scale = EY_Scale_Value_Dao.GetRegNo(id);
foreach (EY_Scale_Value b in scale)
{
i++;
DataRow row = table.NewRow();
// row["id"] = 1 + i;
row["日期"] = b.Date;
row["案件接收编号"] = b.Id.RegNo;
row["检验批号"] = b.Id.CheckNo;
row["料名"] = b.Matrname;
//IList<EY_MatrTable> MatrNameList = EY_MatrTable_DAO.GetMatrName(ss[1].Trim());
//foreach (EY_MatrTable s in MatrNameList)
//{
// row["料名"] = s.MatrName;
//}
row["盘重"] = b.PanWgt;
row["样重"] = b.YangWgt;
row["恒重1"] = b.HengWgt1;
row["恒重2"] = b.HengWgt2;
row["恒重3"] = b.HengWgt3;
row["恒重4"] = b.HengWgt4;
row["结果"] = b.FinalValue;
row["检测员1"] = b.Operator1 + "";
row["检测员2"] = b.Operator2+"";
row["备注"] = b.Mem1 + "";
table.Rows.Add(row);
}
EY_Scale_Value_Dao.Update_Status(id, "Y");
}
}
// row["出生日期"] = new DateTime(1990, 10, 23);
return table;
}
//判断数据是否产制报表，如果产制报表不可修改
private int EY_Scale_Value_Status()
{
int flag = 0;
EY_Scale_Value EY_Scale_Value = new EY_Scale_Value();
EY_Scale_Value_PK spk = new EY_Scale_Value_PK();
spk.RegNo = Convert.ToString(dataGridViewX1.CurrentRow.Cells[1].Value);
spk.CheckNo = Convert.ToString(dataGridViewX1.CurrentRow.Cells[2].Value);
EY_Scale_Value.Id = spk;
IList<EY_Scale_Value> EY_Scale_value_Status = EY_Scale_Value_Dao.GetRegNo1(EY_Scale_Value.Id);
foreach (EY_Scale_Value t in EY_Scale_value_Status)
{
if (t.Status == "Y")
{
// MessageBox.Show("已产制报表，数据不可修改，请联系管理人员");
flag = 1;
}
}
return flag;
}
/// <summary>
/// 添加平行样
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonX8_Click(object sender, EventArgs e)
{
try
{
EY_Scale_Value_PK spk = new EY_Scale_Value_PK();
spk.RegNo = Convert.ToString(dataGridViewX1.SelectedCells[1].Value);
spk.CheckNo = Convert.ToString(dataGridViewX1.SelectedCells[2].Value);
EY_RegNo_DI temVo = new EY_RegNo_DI();
IList<EY_RegNo_DI> regCount = new List<EY_RegNo_DI>();
regCount = EY_RegNo_DI_DAO.GetRegNoCount(spk.RegNo);
dataGridViewX1.Rows.Insert(dataGridViewX1.CurrentCell.RowIndex + 1, 1);
int RowCount1 = dataGridViewX1.Rows.GetRowCount(DataGridViewElementStates.Displayed) - 1;
int a = regCount.Count + 1;
dataGridViewX1.Rows[dataGridViewX1.CurrentCell.RowIndex + 1].Cells[0].Value = System.DateTime.Now;
dataGridViewX1.Rows[dataGridViewX1.CurrentCell.RowIndex + 1].Cells[1].Value = dataGridViewX1.SelectedCells[1].Value + "_" + a;
dataGridViewX1.Rows[dataGridViewX1.CurrentCell.RowIndex + 1].Cells[2].Value = dataGridViewX1.SelectedCells[2].Value;
dataGridViewX1.Rows[dataGridViewX1.CurrentCell.RowIndex + 1].Cells[3].Value = dataGridViewX1.SelectedCells[3].Value;
IList<EY_RegNo_DI> regList = new List<EY_RegNo_DI>();
regList = EY_RegNo_DI_DAO.GetRegNo3(Convert.ToString(dataGridViewX1.SelectedCells[1].Value));
temVo.RegNo = dataGridViewX1.SelectedCells[1].Value + "_" + a;
temVo.RevDateTime = DateTime.Now;
temVo.Status = "Y";
temVo.Batch = regList[0].Batch;
temVo.CheckNo = regList[0].CheckNo;
temVo.MatrNo = regList[0].MatrNo;
temVo.CName = regList[0].CName;
EY_RegNo_DI_DAO.Save(temVo);
}
catch
{
MessageBox.Show("必须指定案件接收编号才能使用此功能");
}
finally
{
SessionHelper.CloseSession();
}
}