public static int JobDetailInsert(JobDetail detail) { String sqlstring = string.Format(@"Insert into jobDetail (jobid,specsID,checkTime,ischecked,checkdetailList) Values({0},{1},'{2}',{3},'{4}') ", detail.JobID, detail.SpecsID, detail.CheckTime, detail.isChecked ? 1 : 0, detail.CheckDetailList); DataAccess.ExecuteNonQuery(sqlstring); int result = Int32.Parse(DataAccess.ExecuteScalar("select max(id) from jobdetail").ToString()); int checkP = Int32.Parse(DataAccess.ExecuteScalar(String.Format("select count(*) from jobdetail where jobid={0}", detail.JobID)).ToString()); DataAccess.ExecuteNonQuery(String.Format("Update JobMain set CheckPosition={1} where id={0}", detail.JobID, checkP)); return(result); }
public static JobMain FindJobMainBySQL(String sqlString) { JobMain result = new JobMain(); using (IDataReader dr = DataAccess.ExecuteReader(sqlString)) { if (dr.Read()) { result.ID = Int32.Parse(dr["ID"].ToString()); result.JobDate = DateTime.Parse(dr["JobDate"].ToString()); result.UserID = Int32.Parse(dr["UserID"].ToString()); result.BeginTime = DateTime.Parse(dr["beginTime"].ToString()); result.EndTime = (dr["EndTime"] == DBNull.Value) ? default(DateTime) : DateTime.Parse(dr["EndTime"].ToString()); result.IsUploaded = (dr["IsUploaded"] == DBNull.Value) ? false : Boolean.Parse(dr["isUploaded"].ToString()); result.NeedCheckPosition = (dr["NeedCheckPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["NeedCheckPosition"].ToString()); result.CheckPosition = (dr["CheckPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["CheckPosition"].ToString()); result.PassPosition = (dr["PassPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["PassPosition"].ToString()); result.IsFull = (dr["IsFull"] == DBNull.Value) ? false : Boolean.Parse(dr["IsFull"].ToString()); result.TrainCode = (dr["TrainCode"] == DBNull.Value) ? "" : dr["TrainCode"].ToString(); dr.Close(); } else { return(null); } } using (IDataReader dr = DataAccess.ExecuteReader(String.Format("Select * from JobDetail where Jobid={0}", result.ID))) { while (dr.Read()) { JobDetail item = new JobDetail(); item.ID = Int32.Parse(dr["ID"].ToString()); item.JobID = result.ID; item.SpecsID = Int32.Parse(dr["SpecsID"].ToString()); item.CheckTime = (dr["CheckTime"] == DBNull.Value) ? default(DateTime) : DateTime.Parse(dr["CheckTime"].ToString()); item.isChecked = (dr["isChecked"] == DBNull.Value) ? false : Boolean.Parse(dr["isChecked"].ToString()); item.CheckDetailList = (dr["CheckDetailList"] == DBNull.Value) ? "" : dr["checkDetailList"].ToString(); item.BarCode = (dr["BarCode"] == DBNull.Value) ? "" : dr["BarCode"].ToString(); result.Items.Add(item); } dr.Close(); } return(result); }
private void btnSave_Click(object sender, EventArgs e) { foreach (ListViewItem item in lvMain.Items) { SpecsDetail detail = CurrentSpecs.FindByID(Int32.Parse(item.Tag.ToString())); detail.isChecked = item.Checked; } JobDetail jobdetail = CurrentJob.FindBySpecsID(CurrentSpecs.ID); if (jobdetail == null) { jobdetail = new JobDetail(); } jobdetail.JobID = CurrentJob.ID; jobdetail.SpecsID = CurrentSpecs.ID; jobdetail.CheckTime = DateTime.Now; jobdetail.isChecked = CurrentSpecs.IsCheckAll; jobdetail.CheckDetailList = CurrentSpecs.CheckDetailList; CurrentJob.Items.Add(jobdetail); if (jobdetail.ID == 0) { jobdetail.ID = DbFactory.JobDetailInsert(jobdetail); CurrentJob.CheckPosition += CurrentJob.CheckPosition; } else { DbFactory.JobDetailUpdate(jobdetail); } //DbFactory.SaveJob(CurrentJob); Specs spec = DbFactory.FindBySequence(CurrentSpecs.Sequence + 1); if (spec != null) { CurrentSpecs = spec; InitView(); } else { //work done. MessageBox.Show("已经检查到最大序号!"); } }
private void btnSave_Click(object sender, EventArgs e) { foreach (ListViewItem item in lvMain.Items) { SpecsDetail detail = CurrentSpecs.FindByID(Int32.Parse(item.Tag.ToString())); detail.isChecked = item.Checked; } JobDetail jobdetail = CurrentJob.FindBySpecsID(CurrentSpecs.ID); if (jobdetail == null) { jobdetail = new JobDetail(); } jobdetail.JobID = CurrentJob.ID; jobdetail.SpecsID = CurrentSpecs.ID; jobdetail.CheckTime = DateTime.Now; jobdetail.isChecked = CurrentSpecs.IsCheckAll; jobdetail.CheckDetailList = CurrentSpecs.CheckDetailList; CurrentJob.Items.Add(jobdetail); if (jobdetail.ID == 0) { jobdetail.ID = DbFactory.JobDetailInsert(jobdetail); CurrentJob.CheckPosition += CurrentJob.CheckPosition; } else DbFactory.JobDetailUpdate(jobdetail); //DbFactory.SaveJob(CurrentJob); Specs spec = DbFactory.FindBySequence(CurrentSpecs.Sequence + 1); if (spec != null) { CurrentSpecs = spec; InitView(); } else { //work done. MessageBox.Show("已经检查到最大序号!"); } }
public void SetCheckToSpecs(Specs spec) { JobDetail detail = FindBySpecsID(spec.ID); if (detail != null) { foreach (string kv in detail.CheckDetailList.Split(',')) { String[] checkresults = kv.Split('='); if (checkresults.Length == 2) { int spid = Int32.Parse(checkresults[0]); bool ispass = checkresults[1] == "1" ? true : false; SpecsDetail spdetail = spec.FindByID(spid); if (spdetail != null) { spdetail.isChecked = ispass; spdetail.isDone = true; } } } spec.IsCheckAll = true; } }
public static JobMain FindJobMainBySQL(String sqlString) { JobMain result = new JobMain(); using (IDataReader dr = DataAccess.ExecuteReader(sqlString)) { if (dr.Read()) { result.ID = Int32.Parse(dr["ID"].ToString()); result.JobDate = DateTime.Parse(dr["JobDate"].ToString()); result.UserID = Int32.Parse(dr["UserID"].ToString()); result.BeginTime = DateTime.Parse(dr["beginTime"].ToString()); result.EndTime = (dr["EndTime"] == DBNull.Value) ? default(DateTime) : DateTime.Parse(dr["EndTime"].ToString()); result.IsUploaded = (dr["IsUploaded"] == DBNull.Value) ? false : Boolean.Parse(dr["isUploaded"].ToString()); result.NeedCheckPosition = (dr["NeedCheckPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["NeedCheckPosition"].ToString()); result.CheckPosition = (dr["CheckPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["CheckPosition"].ToString()); result.PassPosition = (dr["PassPosition"] == DBNull.Value) ? 0 : Int32.Parse(dr["PassPosition"].ToString()); result.IsFull = (dr["IsFull"] == DBNull.Value) ? false : Boolean.Parse(dr["IsFull"].ToString()); result.TrainCode = (dr["TrainCode"] == DBNull.Value) ? "" : dr["TrainCode"].ToString(); dr.Close(); } else return null; } using (IDataReader dr = DataAccess.ExecuteReader(String.Format("Select * from JobDetail where Jobid={0}", result.ID))) { while (dr.Read()) { JobDetail item = new JobDetail(); item.ID = Int32.Parse(dr["ID"].ToString()); item.JobID = result.ID; item.SpecsID = Int32.Parse(dr["SpecsID"].ToString()); item.CheckTime = (dr["CheckTime"] == DBNull.Value) ? default(DateTime) : DateTime.Parse(dr["CheckTime"].ToString()); item.isChecked = (dr["isChecked"] == DBNull.Value) ? false : Boolean.Parse(dr["isChecked"].ToString()); item.CheckDetailList = (dr["CheckDetailList"] == DBNull.Value) ? "" : dr["checkDetailList"].ToString(); item.BarCode = (dr["BarCode"] == DBNull.Value) ? "" : dr["BarCode"].ToString(); result.Items.Add(item); } dr.Close(); } return result; }
public static int JobDetailUpdate(JobDetail detail) { return DataAccess.ExecuteNonQuery(String.Format(@"Update jobDetail set ischecked={0},checkTime='{1}',checkDetailList= '{2}',BarCode='{5}' where jobid={3} and specsID={4} ", detail.isChecked ? 1 : 0, detail.CheckTime, detail.CheckDetailList, detail.JobID, detail.SpecsID, detail.BarCode)); }
public static int JobDetailInsert(JobDetail detail) { String sqlstring = string.Format(@"Insert into jobDetail (jobid,specsID,checkTime,ischecked,checkdetailList,barCode) Values({0},{1},'{2}',{3},'{4}','{5}') ", detail.JobID, detail.SpecsID, detail.CheckTime, detail.isChecked ? 1 : 0, detail.CheckDetailList, detail.BarCode); DataAccess.ExecuteNonQuery(sqlstring); int result = Int32.Parse(DataAccess.ExecuteScalar("select max(id) from jobdetail").ToString()); int checkP = Int32.Parse(DataAccess.ExecuteScalar(String.Format("select count(*) from jobdetail where jobid={0}",detail.JobID)).ToString()); sqlstring = String.Format("Update JobMain set CheckPosition={1} where id={0}", detail.JobID, checkP); if (detail.isChecked) sqlstring = String.Format("Update JobMain set CheckPosition={1},PassPosition=PassPosition+1 where id={0}", detail.JobID, checkP); DataAccess.ExecuteNonQuery(sqlstring); return result; }