public void InsertAnalisysRepairMan(ProcessRepair Objmod)
{
try
{
OpenConnection();
string StrInsert = string.Format(@"INSERT INTO dbo.AnalysisRepairMan VALUES(@data,@hora,@user,@id,@action,@location,@partnumber)");
using (cmd = new SqlCommand(StrInsert, conn))
{
string data = DateTime.Now.ToString("yyyy/MM/dd");
string hora = DateTime.Now.ToString("HH:mm:ss");
cmd.Parameters.AddWithValue("@data", data);
cmd.Parameters.AddWithValue("@hora", hora);
cmd.Parameters.AddWithValue("@user", Objmod.RepairMan);
cmd.Parameters.AddWithValue("@id", Objmod.EntradaId);
cmd.Parameters.AddWithValue("@action", Objmod.ActionRepainMan);
cmd.Parameters.AddWithValue("@location", Objmod.LocationSmd);
cmd.Parameters.AddWithValue("@partnumber", Objmod.PartNumber);
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw new Exception("Error to the register the RepairMan " + ex.Message);
}
finally
{
ClosedConnection();
}
}
/// <summary>
///
/// </summary>
/// <param name="mod"></param>
public void UptadeRepair(ProcessRepair mod)
{
try
{
OpenConnection();
string str = string.Format(@"UPDATE PrincipalProcessRepair SET UN =@un,DefectCauseId=@defectCause,LocationSMD=@location,Lote=@lote,ActionId=@action,TecnicoResponsavel=@tec,StatusRepair=@statusRepair WHERE EntradaId =@cod");
using (cmd = new SqlCommand(str, conn))
{
cmd.Parameters.AddWithValue("@cod", mod.EntradaId);
cmd.Parameters.AddWithValue("@un", mod.UN);
cmd.Parameters.AddWithValue("@defectCause", mod.DefectCauseId);
cmd.Parameters.AddWithValue("@location", mod.LocationSmd);
cmd.Parameters.AddWithValue("@lote", mod.lote);
cmd.Parameters.AddWithValue("@action", mod.ActionId);
cmd.Parameters.AddWithValue("@tec", mod.TecnicoResponsavel);
cmd.Parameters.AddWithValue("@statusRepair", mod.statusRepair);
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw new Exception("Error to the Update : " + ex.Message);
}
finally
{
ClosedConnection();
}
}
public void RegitrarReparoMainNPC(ProcessRepair objAdd)
{
try
{
OpenConnection();
string str = string.Format(@"INSERT INTO dbo.PrincipalProcessRepair VALUES(@data,@hora,@entradaId,@ProductId,
@unitId,@un,@inspProcessId,@defectCauseId,@locationId,@LocationSmd,@DefectImputId,
@lote,@partnumber,@actionId,@statusId,@repair,@comentario,'TERMINATE','','','','NPC','0','0')");
using (cmd = new SqlCommand(str, conn))
{
string data = DateTime.Now.ToString("yyyy/MM/dd");
string hora = DateTime.Now.ToString("HH:mm:ss");
cmd.Parameters.AddWithValue("@data", data);
cmd.Parameters.AddWithValue("@hora", hora);
cmd.Parameters.AddWithValue("@entradaId", objAdd.EntradaId);
cmd.Parameters.AddWithValue("@ProductId", objAdd.ProductId);
cmd.Parameters.AddWithValue("@unitId", objAdd.Unitid);
cmd.Parameters.AddWithValue("@un", objAdd.UN);
cmd.Parameters.AddWithValue("@inspProcessId", objAdd.InsProcessID);
cmd.Parameters.AddWithValue("@defectCauseId", objAdd.DefectCauseId);
cmd.Parameters.AddWithValue("@locationId", objAdd.LocationId);
cmd.Parameters.AddWithValue("@LocationSmd", objAdd.LocationSmd);
cmd.Parameters.AddWithValue("@DefectImputId", objAdd.DefectImputId);
cmd.Parameters.AddWithValue("@lote", objAdd.lote);
cmd.Parameters.AddWithValue("@partnumber", objAdd.PartNumber);
cmd.Parameters.AddWithValue("@actionId", objAdd.ActionId);
cmd.Parameters.AddWithValue("@statusId", objAdd.StatusId);
cmd.Parameters.AddWithValue("@repair", objAdd.RepairMan);
cmd.Parameters.AddWithValue("@comentario", objAdd.Comment);
//if (string.IsNullOrEmpty(Convert.ToString(objAdd.EntradaSMDId)))
//{
// cmd.Parameters.AddWithValue("@entradaSMDid", DBNull.Value);
//}
//else
//{
// cmd.Parameters.AddWithValue("@entradaSMDid", objAdd.EntradaSMDId);
//}
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw new Exception("Error to the register: " + ex.Message);
}
finally
{
ClosedConnection();
}
}
public void RegitrarReparoMainNUll(ProcessRepair objAdd)
{
try
{
OpenConnection();
string str = string.Format(@"INSERT INTO dbo.PrincipalProcessRepair VALUES(@data,@hora,@entradaId,@ProductId,
@unitId,'',@inspProcessId,'70','26','N/A','9',
'','','14',@statusId,@repair,@comentario,'WAITING','','','','CQP','0','0')");
using (cmd = new SqlCommand(str, conn))
{
string data = DateTime.Now.ToString("yyyy/MM/dd");
string hora = DateTime.Now.ToString("HH:mm:ss");
cmd.Parameters.AddWithValue("@data", data);
cmd.Parameters.AddWithValue("@hora", hora);
cmd.Parameters.AddWithValue("@entradaId", objAdd.EntradaId);
cmd.Parameters.AddWithValue("@ProductId", objAdd.ProductId);
cmd.Parameters.AddWithValue("@unitId", objAdd.Unitid);
cmd.Parameters.AddWithValue("@inspProcessId", objAdd.Unitid);
cmd.Parameters.AddWithValue("@statusId", objAdd.StatusId);
cmd.Parameters.AddWithValue("@repair", objAdd.RepairMan);
cmd.Parameters.AddWithValue("@comentario", objAdd.Comment);
//if (string.IsNullOrEmpty(Convert.ToString(objAdd.EntradaSMDId)))
//{
// cmd.Parameters.AddWithValue("@entradaSMDid", DBNull.Value);
//}
//else
//{
// cmd.Parameters.AddWithValue("@entradaSMDid", objAdd.EntradaSMDId);
//}
cmd.ExecuteNonQuery();
}
}
catch (SqlException ex)
{
throw new Exception("Error to the register: " + ex.Message);
}
finally
{
ClosedConnection();
}
}
public void UpdateUserName(ProcessRepair objModel)
{
OpenConnection();
string strUpdate = string.Format(@"UPDATE TecnicoMaisPlaca SET UserName = @user WHERE EntradaId =@cod");
using (cmd = new SqlCommand(strUpdate, conn))
{
cmd.Parameters.AddWithValue("@cod", objModel.EntradaId);
cmd.Parameters.AddWithValue("@user", objModel.RepairMan);
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
ClosedConnection();
}
}
}
