public int Insert(ProductJob info, List <ProductJobRecord> records)
{
try
{
//string commandText = @"insert into Users(userName,userPassword,userLevel,userPhone,userAddress) values (
//?userName,?userPassword,?userLevel,?userPhone,?userAddress)";
string commandText = string.Format("insert into ProductJob(name, jobTime, comment, status) values('{0}', '{1}', '{2}', '{3}')", info.Name, info.JobTime, info.Comment, info.Status);
DbHelperAccess.executeNonQuery(commandText);
int ProductJobID = DbHelperAccess.executeMax("ID", "ProductJob");
ProductJobRecordDao dao = new ProductJobRecordDao();
foreach (ProductJobRecord record in records)
{
record.JobID = ProductJobID;
dao.Insert(record);
}
return(ProductJobID);
}
catch (Exception ex)
{
throw ex;
}
}
public static ProductJobRecordDao getInstance()
{
if (dao == null)
{
dao = new ProductJobRecordDao();
}
return(dao);
}
public void Update(ProductJob info, List <ProductJobRecord> records)
{
string commandText = string.Format("update ProductJob set name='{0}', jobTime='{1}', comment='{2}' where ID={3}",
info.Name, info.JobTime, info.Comment, info.ID);
DbHelperAccess.executeNonQuery(commandText);
ProductJobRecordDao.getInstance().DeleteByJobID(info.ID);
foreach (ProductJobRecord record in records)
{
record.JobID = info.ID;
ProductJobRecordDao.getInstance().Insert(record);
}
}