//
//保存
//
private void btn_Save_Click(object sender, RoutedEventArgs e)
{
Maticsoft.BLL.OrderLabSet _M_LabSetInfo = new Maticsoft.BLL.OrderLabSet();
Maticsoft.BLL.LabInfo _M_LabInfo = new Maticsoft.BLL.LabInfo();
Maticsoft.Model.OrderLabSet _LabSet = new Maticsoft.Model.OrderLabSet();
_LabSet = _M_LabSetInfo.GetModel(cmb_BatchNo.Text.Trim());
if (_LabSet == null) //如果未保存过此批号的信息
{
Save_LabInfo();
}
else
{
if (System.Windows.Forms.MessageBox.Show("工单：" + txb_OrderID.Text.ToString()
+ "\r\n批号：" + cmb_BatchNo.Text.ToString()
+ "已经存在，继续将替换原有工单！\r\n是否继续添加", "系统提示",
MessageBoxButtons.OKCancel, MessageBoxIcon.Error) == DialogResult.OK)
{
lab_State.Content = "正在删除数据.....";
//删除原有数据
_M_LabSetInfo.Delete(_LabSet.Lab_ID);
_M_LabInfo.Delete(_LabSet.Lab_ID.ToString());
//添加新数据数据
Save_LabInfo();
}
}
}
//
//载入工单标签信息
//
private void btn_Lad_OrderLabInfo_Click(object sender, RoutedEventArgs e)
{
try
{
_WTT_LabInfo.Clear(); //清空列表
Maticsoft.Model.OrderLabSet _LabSet = MCP_CS._M_OrderLabSet.GetModel(cmb_BatchNo.Text.Trim());
if (_LabSet != null)
{
cmb_LabTemplate.Text = _LabSet.LabName;
txb_Batch_OptionCount.Text = _LabSet.Count;
DataSet ds = MCP_CS._M_labInfo.GetList("Lab_ID = '" + _LabSet.Lab_ID + "'");
//
if (ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)//遍历ds
{
_WTT_LabInfo.Add(new Maticsoft.Model.LabInfo()
{
Name = dr["Name"].ToString(), Value = dr["Value"].ToString()
});
}
}
}
else
{
My_MessageBox.My_MessageBox_Message("未找到该工单的标签信息！");
}
//
}
//获取异常信息
catch (Exception ex) { My_MessageBox.My_MessageBox_Message("加载模板信息过程中发生错误!\r\n" + ex.Message); }
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Maticsoft.Model.OrderLabSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_OrderLabSet(");
strSql.Append("OrderID,BachNo,LabName,Count,ID_Key)");
strSql.Append(" values (");
strSql.Append("@OrderID,@BachNo,@LabName,@Count,@ID_Key)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.VarChar, 50),
new SqlParameter("@BachNo", SqlDbType.VarChar, 50),
new SqlParameter("@LabName", SqlDbType.VarChar, 50),
new SqlParameter("@Count", SqlDbType.VarChar, 50),
new SqlParameter("@ID_Key", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.BachNo;
parameters[2].Value = model.LabName;
parameters[3].Value = model.Count;
parameters[4].Value = model.ID_Key;
object obj = dbs.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.OrderLabSet DataRowToModel(DataRow row)
{
Maticsoft.Model.OrderLabSet model = new Maticsoft.Model.OrderLabSet();
if (row != null)
{
if (row["OrderID"] != null)
{
model.OrderID = row["OrderID"].ToString();
}
if (row["BachNo"] != null)
{
model.BachNo = row["BachNo"].ToString();
}
if (row["LabName"] != null)
{
model.LabName = row["LabName"].ToString();
}
if (row["Lab_ID"] != null && row["Lab_ID"].ToString() != "")
{
model.Lab_ID = decimal.Parse(row["Lab_ID"].ToString());
}
if (row["Count"] != null)
{
model.Count = row["Count"].ToString();
}
if (row["ID_Key"] != null && row["ID_Key"].ToString() != "")
{
model.ID_Key = decimal.Parse(row["ID_Key"].ToString());
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Maticsoft.Model.OrderLabSet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_OrderLabSet set ");
strSql.Append("OrderID=@OrderID,");
strSql.Append("LabName=@LabName,");
strSql.Append("Count=@Count,");
strSql.Append(" where Lab_ID=@Lab_ID");
SqlParameter[] parameters =
{
new SqlParameter("@OrderID", SqlDbType.VarChar, 50),
new SqlParameter("@LabName", SqlDbType.VarChar, 50),
new SqlParameter("@Count", SqlDbType.VarChar, 50),
new SqlParameter("@BachNo", SqlDbType.VarChar, 50),
new SqlParameter("@Lab_ID", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.OrderID;
parameters[1].Value = model.LabName;
parameters[2].Value = model.Count;
parameters[3].Value = model.BachNo;
parameters[4].Value = model.Lab_ID;
int rows = dbs.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.OrderLabSet GetModel(string BatchNo)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrderID,BachNo,LabName,Lab_ID,Count,ID_Key from tb_OrderLabSet ");
strSql.Append(" where BachNo=@BachNo");
SqlParameter[] parameters =
{
new SqlParameter("@BachNo", SqlDbType.VarChar, 50)
};
parameters[0].Value = BatchNo;
Maticsoft.Model.OrderLabSet model = new Maticsoft.Model.OrderLabSet();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Maticsoft.Model.OrderLabSet GetModel(decimal Lab_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 OrderID,BachNo,LabName,Lab_ID,Count from tb_OrderLabSet ");
strSql.Append(" where Lab_ID=@Lab_ID");
SqlParameter[] parameters =
{
new SqlParameter("@Lab_ID", SqlDbType.Decimal)
};
parameters[0].Value = Lab_ID;
Maticsoft.Model.OrderLabSet model = new Maticsoft.Model.OrderLabSet();
DataSet ds = dbs.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
