public int insertNuitrack(NuitrackEntity nuitrackEntity)
{
using (var conn = DbUtil.getConn())
{
const string insert = "INSERT INTO bdl_nuitrack (`fk_user_id`, `status`) VALUES (@Fk_user_id, @Status)";
return(conn.Execute(insert, nuitrackEntity));
}
}
//确认按钮，关闭此窗体
private void Button_OK(object sender, RoutedEventArgs e)
{
//this.Hide();
NuitrackScan nuitrackScan = new NuitrackScan
{
Owner = Window.GetWindow(this),
ShowActivated = true,
ShowInTaskbar = false,
WindowStartupLocation = WindowStartupLocation.CenterScreen
};
SkeletonLengthDAO skeletonLengthDAO = new SkeletonLengthDAO();
NuitrackEntity nuitrackEntity = new NuitrackEntity();
//if (skeletonLengthDAO.GetPk_user_idByStatus(1) == null)
//{
// this.Hide();
// nuitrackScan.ShowDialog();
// G_NfcTipTwoStatus = 0;
// this.Close();
// return;
//}
if (skeletonLengthDAO.GetPk_user_idByStatus(1) != null)
{
nuitrackEntity = skeletonLengthDAO.GetPk_user_idByStatus(1);
nuitrackScan.Pk_User_Id = nuitrackEntity.Fk_user_id;
skeletonLengthDAO.updateStatusByFk_user_id(nuitrackEntity);
}
SkeletonLengthEntity skeletonLengthEntity = new SkeletonLengthEntity();
if (skeletonLengthDAO.GetByPk_User_Id(nuitrackScan.Pk_User_Id) != null)
{
skeletonLengthEntity = skeletonLengthDAO.GetByPk_User_Id(nuitrackScan.Pk_User_Id);
if (skeletonLengthEntity.Weigth > 0)
{
nuitrackScan.Weigth.Text = skeletonLengthEntity.Weigth.ToString();
}
nuitrackScan.Man_Height.Text = skeletonLengthEntity.Height.ToString();
nuitrackScan.Shoulder_width.Text = skeletonLengthEntity.Shoulder_width.ToString();
nuitrackScan.Arm_length_up.Text = skeletonLengthEntity.Arm_length_up.ToString();
nuitrackScan.Arm_length_down.Text = skeletonLengthEntity.Arm_length_down.ToString();
nuitrackScan.Leg_length_up.Text = skeletonLengthEntity.Leg_length_up.ToString();
nuitrackScan.Leg_length_down.Text = skeletonLengthEntity.Leg_length_down.ToString();
nuitrackScan.Body_length.Text = skeletonLengthEntity.Body_length.ToString();
}
//this.Hide();
nuitrackScan.ShowDialog();
G_NfcTipTwoStatus = 0;
//this.Close();
Application.Current.Shutdown();
}
public void updateStatusByFk_user_id(NuitrackEntity nuitrackEntity)
{
string sql = @"update bdl_nuitrack set status=0 where fk_user_id = @Fk_user_id";
using (var conn = DbUtil.getConn())
{
try
{
conn.Execute(sql, nuitrackEntity);
}
catch (Exception ex)
{
}
}
}
