public BizResult insert(string user, CtmJobDet2 par) { setData(null); if (par == null) { throw new Exception("data is null"); } BizResult res = new BizResult(); if (inserting_verify(res, user, par)) { Manager.ORManager.StartTracking(par, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(par); res.status = true; trip = par; resetOldValues(); inserted_to_container(user); C2.CtmJobEventLog elog = new C2.CtmJobEventLog(); elog.Platform_isBackend(); elog.Controller = user; elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 1); elog.log(); } return(res); }
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); }
public BizResult delete(string user) { BizResult res = new BizResult(); if (trip == null || trip.Id == 0) { res.context = "Data is empty"; } else { if (updating_verify(res, user, trip)) { C2.CtmJobEventLog elog = new C2.CtmJobEventLog(); elog.Platform_isBackend(); elog.Controller = user; elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 2); //=========== deleting_reSequence_autoFixIncentive(); Manager.ORManager.ExecuteDelete <CtmJobDet2>("Id=" + trip.Id); res.status = true; deleted_removeCost(); elog.log(); } } return(res); }
public BizResult update(string user) { BizResult res = new BizResult(); if (trip == null) { res.context = "Data is empty"; return(res); } if (updating_verify(res, user, trip)) { updated_before(user); Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(trip); res.status = true; updated_Status_changed(user); updated_reSequence_autoFixIncentive(); updated_to_container(user); updated_to_house(user); updated_to_cost(user); resetOldValues(); C2.CtmJobEventLog elog = new C2.CtmJobEventLog(); elog.Platform_isBackend(); elog.Controller = user; elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 3, " Status[" + trip.Statuscode + "]FromDate[" + trip.FromDate.ToString("yyyyMMdd") + "]"); elog.log(); } return(res); }
private bool inserting_verify(BizResult bzR, string user, CtmJobDet1 par) { bool res = false; string role = SafeValue.SafeString(ConnectSql.ExecuteScalar(string.Format("select role from [user] where Name='{0}'", user))); CtmJob job = Manager.ORManager.GetObject(new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + par.JobNo + "'")) as CtmJob; if (job == null) { bzR.context = "Can not find this job"; } else { if (role.ToLower() == "client") { switch (job.JobStatus) { case "Booked": res = true; break; case "Cancel": bzR.context = "This job have been cancel"; break; case "Reject": case "Confirmed": case "Completed": case "Closed": default: bzR.context = "No permission"; break; } } else { switch (job.JobStatus) { case "Booked": case "Cancel": bzR.context = "Requair confirm this job"; break; case "Completed": case "Closed": bzR.context = "This Job have completed"; break; default: res = true; break; } } } return(res); }
public void ContainerDetail_readyExport(string info) { JObject job = (JObject)JsonConvert.DeserializeObject(HttpUtility.UrlDecode(Server.UrlDecode(info))); bool status = false; string context = ""; string user = SafeValue.SafeString(job["user"]); int contId = SafeValue.SafeInt(job["contId"], 0); decimal wt = SafeValue.SafeDecimal(job["wt"], 0); string remark = SafeValue.SafeString(job["remark"]); string mobileNo = SafeValue.SafeString(job["mobileNo"]); if (contId > 0) { C2.CtmJobDet1Biz bz = new C2.CtmJobDet1Biz(contId); C2.CtmJobDet1 det1 = bz.getData(); if (det1 != null) { det1.Weight = wt; det1.StatusCode = "Customer-LD"; det1.CfsStatus = "Completed"; det1.ScheduleStartDate = DateTime.Now; det1.ScheduleStartTime = DateTime.Now.ToString("HH:mm"); det1.CompletionDate = det1.ScheduleStartDate; det1.CompletionTime = det1.ScheduleStartTime; det1.Remark2 = remark; C2.BizResult result = bz.update("skip"); if (result.status) { status = true; C2.CtmJobEventLog elog = new C2.CtmJobEventLog(); elog.Platform_isWeb(); elog.Controller = user; elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, -1, "Container Ready Export [" + mobileNo + "]: " + (remark.Length > 0 ? " :" + remark : "")); elog.log(); } } } else { context = "Data Error"; } Common.WriteJsonP(status, Common.StringToJson(context)); }
public BizResult delete_RowDeleting(string user) { BizResult res = new BizResult(); if (trip == null || trip.Id == 0) { res.context = "Data is empty"; } else { if (updating_verify(res, user, trip)) { deleting_reSequence_autoFixIncentive(); res.status = true; deleted_removeCost(); } } return(res); }
private void updating_verify_diffJobType_tripType(BizResult bzR, CtmJob job, CtmJobDet2 par) { if (job != null && trip != null) { if (par.TripCode.Equals("IMP") || par.TripCode.Equals("EXP")) { if (job != null) { if (job.JobType.Equals("EXP") && par.TripCode.Equals("IMP")) { bzR.context = "Export Job can not save IMP trip"; } if (job.JobType.Equals("IMP") && par.TripCode.Equals("EXP")) { bzR.context = "Import Job can not save EXP trip"; } } } } }
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); }
public BizResult update(string user) { BizResult res = new BizResult(); if (det1 == null) { throw new Exception("data is null"); } if (updating_verify(res, user, det1)) { det1.ScheduleDate = SafeValue_mb.DateTime_ClearTime(det1.ScheduleDate); det1.ScheduleTime = SafeValue_mb.convertTimeFormat(det1.ScheduleTime); det1.ServiceType = (SafeValue.SafeString(det1.ServiceType).Equals("") ? default_ServiceType : det1.ServiceType); Manager.ORManager.StartTracking(det1, Wilson.ORMapper.InitialState.Updated); Manager.ORManager.PersistChanges(det1); res.status = true; //========== log container no changed C2.CtmJobEventLog elog = new C2.CtmJobEventLog(); elog.Platform_isBackend(); elog.Controller = user; if (oldv_containerNo != null && det1.ContainerNo != null && !oldv_containerNo.Equals(det1.ContainerNo)) { elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, -1, "ContainerNo[" + oldv_containerNo + "]->[" + det1.ContainerNo + "]"); elog.log(); } updated_Status_changed(user); updated_to_trip(); updated_to_house(user); resetOldValues(); elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, 3); elog.log(); } return(res); }
public BizResult insert(string user, CtmJobDet1 par) { setData(null); if (par == null) { throw new Exception("data is null"); } BizResult res = new BizResult(); if (inserting_verify(res, user, par)) { par.ScheduleDate = SafeValue_mb.DateTime_ClearTime(par.ScheduleDate); par.ScheduleTime = SafeValue_mb.convertTimeFormat(par.ScheduleTime); par.ScheduleStartDate = SafeValue_mb.DateTime_ClearTime(par.ScheduleStartDate); par.ServiceType = (SafeValue.SafeString(par.ServiceType).Equals("") ? default_ServiceType : par.ServiceType); Manager.ORManager.StartTracking(par, Wilson.ORMapper.InitialState.Inserted); Manager.ORManager.PersistChanges(par); res.status = true; det1 = par; updated_Status_changed(user); resetOldValues(); oldv_ServiceType = "";//==== update trips by service type. inserted_auto_CreateTrip(user); updated_to_trip(); resetOldValues(); C2.CtmJobEventLog elog = new C2.CtmJobEventLog(); elog.Platform_isBackend(); elog.Controller = user; elog.setActionLevel(det1.Id, CtmJobEventLogRemark.Level.Container, 1); elog.log(); } return(res); }
private void container_new() { C2.CtmJob job = C2.Manager.ORManager.GetObject(new Wilson.ORMapper.OPathQuery <C2.CtmJob>("JobNo='" + txt_JobNo.Text + "'")); if (job != null) { string user = HttpContext.Current.User.Identity.Name; C2.CtmJobDet1Biz det1Bz = new C2.CtmJobDet1Biz(0); C2.CtmJobDet1 det1 = new C2.CtmJobDet1(); det1.JobNo = job.JobNo; det1.RequestDate = DateTime.Now; det1.CfsInDate = DateTime.Now; det1.CfsOutDate = DateTime.Now; det1.YardPickupDate = DateTime.Now; det1.YardReturnDate = DateTime.Now; det1.CdtDate = DateTime.Now; det1.YardExpiryDate = DateTime.Now; det1.F5Ind = "N"; det1.UrgentInd = "N"; det1.StatusCode = "New"; //det1.YardCode = job.YardCode; //det1.YardAddress = job.YardRef; #region container sss string values = ""; if (btn_ContNo.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo.Text; det1.ContainerType = txt_ContType.Text; det1.SealNo = txt_SealNo.Text; det1.YardAddress = btn_YardAddress.Text; det1.Remark = txt_Remark.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType.Value); det1.UrgentInd = txt_Urgent.Text; det1.Permit = txt_Permit.Text; det1.DgClass = txt_dg.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo1.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo1.Text; det1.ContainerType = txt_ContType1.Text; det1.SealNo = txt_SealNo1.Text; det1.YardAddress = btn_YardAddress1.Text; det1.Remark = txt_Remark1.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry1.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time1.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight1.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType1.Value); det1.UrgentInd = txt_Urgent1.Text; det1.Permit = txt_Permit1.Text; det1.DgClass = txt_dg1.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo2.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo2.Text; det1.ContainerType = txt_ContType2.Text; det1.SealNo = txt_SealNo2.Text; det1.YardAddress = btn_YardAddress2.Text; det1.Remark = txt_Remark2.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry2.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time2.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight2.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType2.Value); det1.UrgentInd = txt_Urgent2.Text; det1.Permit = txt_Permit2.Text; det1.DgClass = txt_dg2.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo3.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo3.Text; det1.ContainerType = txt_ContType3.Text; det1.SealNo = txt_SealNo3.Text; det1.YardAddress = btn_YardAddress3.Text; det1.Remark = txt_Remark3.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry3.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time3.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight3.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType3.Value); det1.UrgentInd = txt_Urgent3.Text; det1.Permit = txt_Permit3.Text; det1.DgClass = txt_dg3.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo4.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo4.Text; det1.ContainerType = txt_ContType4.Text; det1.SealNo = txt_SealNo4.Text; det1.YardAddress = btn_YardAddress4.Text; det1.Remark = txt_Remark4.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry4.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time4.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight4.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType4.Value); det1.UrgentInd = txt_Urgent4.Text; det1.Permit = txt_Permit4.Text; det1.DgClass = txt_dg4.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo5.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo5.Text; det1.ContainerType = txt_ContType5.Text; det1.SealNo = txt_SealNo5.Text; det1.YardAddress = btn_YardAddress5.Text; det1.Remark = txt_Remark5.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry5.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time5.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight5.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType5.Value); det1.UrgentInd = txt_Urgent5.Text; det1.Permit = txt_Permit5.Text; det1.DgClass = txt_dg5.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo6.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo6.Text; det1.ContainerType = txt_ContType6.Text; det1.SealNo = txt_SealNo6.Text; det1.YardAddress = btn_YardAddress6.Text; det1.Remark = txt_Remark6.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry6.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time6.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight6.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType6.Value); det1.UrgentInd = txt_Urgent6.Text; det1.Permit = txt_Permit6.Text; det1.DgClass = txt_dg6.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo7.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo7.Text; det1.ContainerType = txt_ContType7.Text; det1.SealNo = txt_SealNo7.Text; det1.YardAddress = btn_YardAddress7.Text; det1.Remark = txt_Remark7.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry7.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time7.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight7.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType7.Value); det1.UrgentInd = txt_Urgent7.Text; det1.Permit = txt_Permit7.Text; det1.DgClass = txt_dg7.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo8.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo8.Text; det1.ContainerType = txt_ContType8.Text; det1.SealNo = txt_SealNo8.Text; det1.YardAddress = btn_YardAddress8.Text; det1.Remark = txt_Remark8.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry8.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time8.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight8.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType8.Value); det1.UrgentInd = txt_Urgent8.Text; det1.Permit = txt_Permit8.Text; det1.DgClass = txt_dg8.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (btn_ContNo9.Text.Trim().Length > 0) { det1.ContainerNo = btn_ContNo9.Text; det1.ContainerType = txt_ContType9.Text; det1.SealNo = txt_SealNo9.Text; det1.YardAddress = btn_YardAddress9.Text; det1.Remark = txt_Remark9.Text; det1.ScheduleDate = SafeValue.SafeDate(date_YardExpiry9.Date, new DateTime(1990, 1, 1)); det1.ScheduleTime = txt_time9.Text; det1.Weight = SafeValue.SafeDecimal(txt_Weight9.Text); det1.ServiceType = SafeValue.SafeString(cmb_ServiceType9.Value); det1.UrgentInd = txt_Urgent9.Text; det1.Permit = txt_Permit9.Text; det1.DgClass = txt_dg9.Text; det1.JobType = job.JobType; det1.Br = job.CarrierBkgNo; C2.BizResult bRes = det1Bz.insert(user, det1); if (!bRes.status) { values = bRes.context; } } if (values.Length == 0) { values = "Success"; } Response.Write("<script>parent.Popup_ContainerBatchAdd_callback('" + values + "');</script>"); #endregion } }
private bool updating_verify(BizResult bzR, string user, CtmJobDet2 par) { bool res = false; string role = SafeValue.SafeString(ConnectSql.ExecuteScalar(string.Format("select role from [user] where Name='{0}'", user))); if (role.ToLower() == "client") { bzR.context = "No permission"; return(res); } if (role.ToLower().Equals("driver")) { if (trip.DriverCode.Equals(user) || trip.DriverCode2.Equals(user) || trip.DriverCode11.Equals(user) || trip.DriverCode12.Equals(user)) { } else { bzR.context = "No permission"; return(res); } } CtmJobDet1 det1 = Manager.ORManager.GetObject <CtmJobDet1>(par.Det1Id); CtmJob job = Manager.ORManager.GetObject(new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + par.JobNo + "'")) as CtmJob; if (job == null) { bzR.context = "Mast data is empty"; } else { switch (job.StatusCode) { case "CLS": bzR.context = "This Job have been completed"; break; case "CNL": bzR.context = "This Job have been Canceled"; break; default: break; } //switch (job.JobStatus) //{ // case "Booked": // bzR.context = "Requair confirm job"; // break; // case "Cancel": // bzR.context = "This job have been cancel"; // break; // case "Reject": // bzR.context = "This job have been Reject"; // break; // case "Completed": // case "Closed": // bzR.context = "This job have been Completed"; // break; // default: // break; //} if (det1 != null) { //if (det1.StatusCode == "Completed") //{ // bzR.context = "This container have been Completed"; //} } updating_verify_diffJobType_tripType(bzR, job, par); if (bzR.context.Length == 0) { res = true; } } return(res); }
private bool inserting_verify(BizResult bzR, string user, CtmJobDet2 par) { bool res = updating_verify(bzR, user, par); return(res); }