public BizResult delete_RowDeleting(string user) { BizResult res = new BizResult(); if (det1 == null || det1.Id == 0) { res.context = "Data is empty"; } else { if (updating_verify(res, user, det1)) { res.status = true; System.Collections.ObjectModel.Collection <C2.CtmJobDet2> det2 = C2.Manager.ORManager.GetCollection <C2.CtmJobDet2>("det1Id=" + det1.Id); C2.CtmJobDet2Biz det2Bz = new CtmJobDet2Biz(0); foreach (C2.CtmJobDet2 temp in det2) { det2Bz.setData(temp); det2Bz.delete(user); } //string sql = string.Format(@"delete from ctm_jobdet2 where det1Id=@Id"); //List<ConnectSql_mb.cmdParameters> list = new List<ConnectSql_mb.cmdParameters>(); //list.Add(new ConnectSql_mb.cmdParameters("@Id", det1.Id, SqlDbType.Int)); //ConnectSql_mb.sqlResult sqlRes = ConnectSql_mb.ExecuteNonQuery(sql, list); } } return(res); }
private void inserted_auto_CreateTrip(string user) { CtmJob job = Manager.ORManager.GetObject(new Wilson.ORMapper.OPathQuery <CtmJob>("JobNo='" + det1.JobNo + "'")); if (job != null) { CtmJobDet2Biz det2Bz = new CtmJobDet2Biz(0); CtmJobDet2 det2 = new CtmJobDet2(); det2.JobNo = det1.JobNo; det2.Det1Id = det1.Id; det2.ContainerNo = det1.ContainerNo; det2.FromDate = det1.ScheduleDate; det2.FromTime = det1.ScheduleTime; det2.ToDate = det1.ScheduleDate; det2.ToTime = det1.ScheduleTime; det2.Statuscode = "P"; det2.SubletFlag = "N"; det2.Overtime = "Normal"; det2.OverDistance = "N"; if (job.JobType == "IMP") { det2.TripCode = "IMP"; det2.FromCode = job.PickupFrom; det2.ToCode = job.DeliveryTo; det2Bz.insert(user, det2); det2.TripCode = "RET"; det2.FromCode = job.DeliveryTo; det2.ToCode = det1.YardAddress; det2Bz.insert(user, det2); } if (job.JobType == "EXP") { det2.TripCode = "COL"; det2.FromCode = det1.YardAddress; det2.ToCode = job.PickupFrom; det2Bz.insert(user, det2); det2.TripCode = "EXP"; det2.FromCode = job.PickupFrom; det2.ToCode = job.DeliveryTo; det2Bz.insert(user, det2); } if (job.JobType == "LOC") { det2.TripCode = "LOC"; det2.FromCode = job.PickupFrom; det2.ToCode = job.DeliveryTo; det2Bz.insert(user, det2); } } }
public BizResult delete(string user) { BizResult res = new BizResult(); if (det1 == null || det1.Id == 0) { res.context = "Data is empty"; } else { if (updating_verify(res, user, det1)) { string sql = string.Format(@"delete from ctm_jobdet1 where Id=@Id"); List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>(); list.Add(new ConnectSql_mb.cmdParameters("@Id", det1.Id, SqlDbType.Int)); ConnectSql_mb.sqlResult sqlRes = ConnectSql_mb.ExecuteNonQuery(sql, list); if (sqlRes.status) { res.status = true; CtmJobEventLog lg = new CtmJobEventLog(); lg.Platform_isBackend(); lg.Controller = user; //lg.JobNo = det1.JobNo; //lg.ContainerNo = det1.ContainerNo; //lg.Remark = "ContDelete"; lg.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, 2); lg.log(); System.Collections.ObjectModel.Collection <C2.CtmJobDet2> det2 = C2.Manager.ORManager.GetCollection <C2.CtmJobDet2>("det1Id=" + det1.Id); C2.CtmJobDet2Biz det2Bz = new CtmJobDet2Biz(0); foreach (C2.CtmJobDet2 temp in det2) { det2Bz.setData(temp); det2Bz.delete(user); } //sql = string.Format(@"delete from ctm_jobdet2 where det1Id=@Id"); //ConnectSql_mb.ExecuteNonQuery(sql, list); } } } return(res); }