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 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_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);
}
}
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);
}
}
//上传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);
}
