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);
}
