public int Update(ProductJobRecord info)
{
string commandText = string.Format("update ProductJobRecord set productID={0}, num={1}, arrivalNum={2} where ID={3}",
info.ProductID, info.Number, info.ArrivalNum, info.ID);
return(DbHelperAccess.executeNonQuery(commandText));
}
public int Insert(ProductJobRecord info)
{
try
{
//string commandText = @"insert into Users(userName,userPassword,userLevel,userPhone,userAddress) values (
//?userName,?userPassword,?userLevel,?userPhone,?userAddress)";
string commandText = string.Format("insert into ProductJobRecord(productID, num, jobID) values('{0}', '{1}', '{2}')",
info.ProductID, info.Number, info.JobID);
return(DbHelperAccess.executeNonQuery(commandText));
}
catch (Exception ex)
{
throw ex;
}
}
