private void updated_to_container(string user) { CtmJobDet1Biz det1Bz = new CtmJobDet1Biz(trip.Det1Id); CtmJobDet1 det1 = det1Bz.getData(); if (det1 != null) { bool canSave = false; canSave = canSave || updated_to_container_contNo(det1); canSave = canSave || updated_to_container_status(det1); if (canSave) { det1Bz.update(user); } } }
private void inserted_to_container(string user) { C2.CtmJobDet1Biz bz = new CtmJobDet1Biz(this.trip.Det1Id); C2.CtmJobDet1 det1 = bz.getData(); if (det1 != null) { string sql = string.Format(@"select count(*) from ctm_jobdet2 where (StatusCode='P' or StatusCode='S') and Det1Id=@Det1Id"); List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>(); list.Add(new ConnectSql_mb.cmdParameters("@Det1Id", det1.Id, SqlDbType.Int)); int cc = SafeValue.SafeInt(ConnectSql_mb.ExecuteScalar(sql, list), 0); if (cc > 0) { det1.StatusCode = "InTransit"; bz.update(user); } } }
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)); }