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 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); } }
public ProductJob FindByID(int ID) { string commandText = string.Format("select * from ProductJob where ID={0}", ID); DataRow dr = DbHelperAccess.executeQueryGetOneRow(commandText); ProductJob job = new ProductJob(); if (dr != null) { job.ID = (int)dr["ID"]; job.Name = dr["name"] as string; job.JobTime = (DateTime)dr["jobTime"]; job.Status = (int)dr["status"]; job.Comment = dr["comment"] as string; return(job); } return(null); }