private void btn_confirm_Click(object sender, System.Windows.RoutedEventArgs e)
{
try
{
ObjectModule.Local.Equipment ge = new ObjectModule.Local.Equipment();
ge.DEPARTMENT = StaticRes.Global.Current_User.DEPARTMENT;
ge.EQUIP_ID = this.txt_equipID.Text;
ge.EQUIP_MAKER = this.txt_equipMaker.Text;
ge.EQUIP_MODEL = this.txt_equipModel.Text;
ge.LOCID = this.txt_locID.Text;
ge.UPDATED_BY = StaticRes.Global.Current_User.USER_ID;
ge.UPDATED_TIME = System.DateTime.Now;
if (lb_title.Content.ToString() == "Add Equipment")
{
Logic.Common.Equipment_Insert(ge);
Common.Reports.LogFile.Log("Register machine : " + ge.EQUIP_ID + " by user:"******"Update machine : " + ge.EQUIP_ID + " by user:"******"Successful !!", "Message", MessageBoxButton.OK, MessageBoxImage.Asterisk);
Machine_Search();
this.MaskActionPage.Visibility = Visibility.Collapsed;
kb.CurrentTextBox = txt_equipID_Search;
}
catch (Exception ee)
{
MessageBox.Show(ee.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
public static ObjectModule.Local.Equipment Equip_Infor(string Equip_ID)
{
if (Equip_ID.Length == 0)
{
throw new System.Exception("Please input Equip ID first !!\n请先输入装备ID!!");
}
DataTable dt = DataProvider.Local.Equipment.Select(Equip_ID);
if (dt.Rows.Count == 0)
{
throw new System.Exception("Invalid Equip ID !!\n无效的装备ID!!");
}
DataTable dt_tracking = DataProvider.Local.Tracking.Equip_Status_Check(Equip_ID);
if (dt_tracking.Rows.Count > 0)
{
throw new System.Exception("This machine already withdraw one epoxy , please return \n这台机器已经撤出一个环氧树脂,请返回！！" + dt_tracking.Rows[0]["PART_ID"].ToString() + " first !!");
}
ObjectModule.Local.Equipment ge = new ObjectModule.Local.Equipment(dt.Rows[0]);
return(ge);
}
public static bool Update(ObjectModule.Local.Equipment ge)
{
try
{
string sql = @"Update Equipment set EQUIP_MAKER=@EQUIP_MAKER,EQUIP_MODEL=@EQUIP_MODEL,LOCID=@LOCID,
UPDATED_TIME =@UPDATED_TIME,UPDATED_BY=@UPDATED_BY where EQUIP_ID=@EQUIP_ID and DEPARTMENT=@DEPARTMENT ";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql);
cmd.Parameters.Add("@EQUIP_MAKER", System.Data.SqlDbType.VarChar).Value = ge.EQUIP_MAKER;
cmd.Parameters.Add("@EQUIP_MODEL", System.Data.SqlDbType.VarChar).Value = ge.EQUIP_MODEL;
cmd.Parameters.Add("@LOCID", System.Data.SqlDbType.VarChar).Value = ge.LOCID;
cmd.Parameters.Add("@UPDATED_TIME", System.Data.SqlDbType.DateTime).Value = ge.UPDATED_TIME;
cmd.Parameters.Add("@UPDATED_BY", System.Data.SqlDbType.VarChar).Value = ge.UPDATED_BY;
cmd.Parameters.Add("@EQUIP_ID", System.Data.SqlDbType.VarChar).Value = ge.EQUIP_ID;
cmd.Parameters.Add("@DEPARTMENT", System.Data.SqlDbType.VarChar).Value = ge.DEPARTMENT;
return(Common.DB.SqlDB.SetData(cmd, StaticRes.Local));
}
catch (SqlException ee)
{
throw ee;
}
}
public static bool Insert(ObjectModule.Local.Equipment ge)
{
try
{
string sql = @"insert into Equipment
(EQUIP_ID,DEPARTMENT,EQUIP_MAKER,EQUIP_MODEL,LOCID,UPDATED_TIME,UPDATED_BY)
VALUES
(@EQUIP_ID,@DEPARTMENT,@EQUIP_MAKER,@EQUIP_MODEL,@LOCID,@UPDATED_TIME,@UPDATED_BY)";
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand(sql);
cmd.Parameters.Add("@EQUIP_MAKER", System.Data.SqlDbType.VarChar).Value = ge.EQUIP_MAKER;
cmd.Parameters.Add("@EQUIP_MODEL", System.Data.SqlDbType.VarChar).Value = ge.EQUIP_MODEL;
cmd.Parameters.Add("@LOCID", System.Data.SqlDbType.VarChar).Value = ge.LOCID;
cmd.Parameters.Add("@UPDATED_TIME", System.Data.SqlDbType.DateTime).Value = ge.UPDATED_TIME;
cmd.Parameters.Add("@UPDATED_BY", System.Data.SqlDbType.VarChar).Value = ge.UPDATED_BY;
cmd.Parameters.Add("@EQUIP_ID", System.Data.SqlDbType.VarChar).Value = ge.EQUIP_ID;
cmd.Parameters.Add("@DEPARTMENT", System.Data.SqlDbType.VarChar).Value = ge.DEPARTMENT;
return(Common.DB.SqlDB.SetData(cmd, StaticRes.Local));
}
catch (SqlException ee)
{
throw ee;
}
}
public static bool Equipment_Update(ObjectModule.Local.Equipment ge)
{
return(DataProvider.Local.Equipment.Update(ge));
}
public static bool Equipment_Insert(ObjectModule.Local.Equipment ge)
{
return(DataProvider.Local.Equipment.Insert(ge));
}
