private void Trip_Delete(object sender, ASPxGridViewCustomDataCallbackEventArgs e, string tripId)
{
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = HttpContext.Current.User.Identity.Name;
elog.ActionLevel_isTRIP(SafeValue.SafeInt(tripId, 0));
elog.Remark = "Trip delete";
elog.log();
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
C2.CtmJobDet2 trip = C2.ManagerEdi.ORManager.GetObject(query) as C2.CtmJobDet2;
C2.ManagerEdi.ORManager.ExecuteDelete(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
//C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated);
//C2.Manager.ORManager.PersistChanges(trip);
//EGL_JobTrip_AfterEndTrip("", SafeValue.SafeString(trip.Det1Id, "0"));
string sql = string.Format(@"delete from job_cost where TripNo='{0}'", tripId);
C2.ManagerEdi.ORManager.ExecuteScalar(sql);
string re = HttpContext.Current.User.Identity.Name + "," + trip.Id + "," + trip.DriverCode;
e.Result = re;
}
private string Trip_New(string jobType, int tripId)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");
C2.CtmJobDet2 trip = C2.Manager.ORManager.GetObject(query) as C2.CtmJobDet2;
string sql = string.Format(@"select max(TripIndex) from CTM_JobDet2 where JobType=@JobType and JobNo=@JobNo");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@JobNo", no, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@JobType", jobType, SqlDbType.NVarChar, 100));
string maxIdex = SafeValue.SafeString(ConnectSql_mb.ExecuteScalar(sql, list).context, "//00");
int n = SafeValue.SafeInt(maxIdex.Substring(maxIdex.LastIndexOf("/") + 1), 0) + 1;
string str = (100 + n).ToString().Substring(1);
string fromCode = trip.ToCode;
string toCode = trip.FromCode;
trip.BookingDate = DateTime.Today;
trip.TripIndex = no + "/" + jobType + "/" + str;
trip.Self_Ind = "No";
trip.JobNo = no;
//trip.FromDate = DateTime.Today;
//trip.ToDate = DateTime.Today;
trip.CreateUser = HttpContext.Current.User.Identity.Name;
trip.CreateTime = DateTime.Now;
trip.UpdateUser = HttpContext.Current.User.Identity.Name;
trip.UpdateTime = DateTime.Now;
trip.JobType = jobType;
trip.TripCode = jobType;
trip.ReturnType = "Y";
trip.ToCode = toCode;
trip.FromCode = fromCode;
trip.Statuscode = "P";
C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(trip);
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isJOB(trip.Id);
elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Trip, 1, "");
return(trip.Id + "_" + trip.TripIndex);
}
private void Trip_Update(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
ASPxGridView grd = sender as ASPxGridView;
ASPxLabel lb_tripId = grd.FindEditFormTemplateControl("lb_tripId") as ASPxLabel;
string tripId = SafeValue.SafeString(lb_tripId.Text, "");
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id='" + tripId + "'");;
C2.CtmJobDet2 trip = C2.ManagerEdi.ORManager.GetObject(query) as C2.CtmJobDet2;
string Driver_old = "";
bool isNew = false;
if (trip == null)
{
isNew = true;
trip = new C2.CtmJobDet2();
}
else
{
Driver_old = trip.DriverCode;
}
ASPxDropDownEdit dde_Trip_ContNo = grd.FindEditFormTemplateControl("dde_Trip_ContNo") as ASPxDropDownEdit;
ASPxTextBox dde_Trip_ContId = grd.FindEditFormTemplateControl("dde_Trip_ContId") as ASPxTextBox;
//ASPxButtonEdit btn_CfsCode = grd.FindEditFormTemplateControl("btn_CfsCode") as ASPxButtonEdit;
//ASPxComboBox cbb_Trip_BayCode = grd.FindEditFormTemplateControl("cbb_Trip_BayCode") as ASPxComboBox;
//ASPxComboBox cbb_Carpark = grd.FindEditFormTemplateControl("cbb_Carpark") as ASPxComboBox;
ASPxComboBox cbb_Trip_TripCode = grd.FindEditFormTemplateControl("cbb_Trip_TripCode") as ASPxComboBox;
ASPxButtonEdit btn_DriverCode = grd.FindEditFormTemplateControl("btn_DriverCode") as ASPxButtonEdit;
ASPxButtonEdit btn_TowheadCode = grd.FindEditFormTemplateControl("btn_TowheadCode") as ASPxButtonEdit;
ASPxButtonEdit btn_ChessisCode = grd.FindEditFormTemplateControl("btn_ChessisCode") as ASPxButtonEdit;
//ASPxComboBox cbb_Trip_SubletFlag = grd.FindEditFormTemplateControl("cbb_Trip_SubletFlag") as ASPxComboBox;
//ASPxTextBox txt_SubletHauliername = grd.FindEditFormTemplateControl("txt_SubletHauliername") as ASPxTextBox;
//ASPxComboBox cbb_StageCode = grd.FindEditFormTemplateControl("cbb_StageCode") as ASPxComboBox;
//ASPxComboBox cbb_StageStatus = grd.FindEditFormTemplateControl("cbb_StageStatus") as ASPxComboBox;
ASPxComboBox cbb_Trip_StatusCode = grd.FindEditFormTemplateControl("cbb_Trip_StatusCode") as ASPxComboBox;
ASPxComboBox cmb_DoubleMounting = grd.FindEditFormTemplateControl("cmb_DoubleMounting") as ASPxComboBox;
ASPxDateEdit txt_FromDate = grd.FindEditFormTemplateControl("txt_FromDate") as ASPxDateEdit;
ASPxTextBox txt_Trip_fromTime = grd.FindEditFormTemplateControl("txt_Trip_fromTime") as ASPxTextBox;
ASPxDateEdit date_Trip_toDate = grd.FindEditFormTemplateControl("date_Trip_toDate") as ASPxDateEdit;
ASPxTextBox txt_Trip_toTime = grd.FindEditFormTemplateControl("txt_Trip_toTime") as ASPxTextBox;
ASPxMemo txt_Trip_Remark = grd.FindEditFormTemplateControl("txt_Trip_Remark") as ASPxMemo;
ASPxMemo txt_Trip_FromCode = grd.FindEditFormTemplateControl("txt_Trip_FromCode") as ASPxMemo;
ASPxMemo txt_Trip_ToCode = grd.FindEditFormTemplateControl("txt_Trip_ToCode") as ASPxMemo;
//ASPxSpinEdit spin_Price = grd.FindEditFormTemplateControl("spin_Price") as ASPxSpinEdit;
ASPxComboBox cbb_zone = grd.FindEditFormTemplateControl("cbb_zone") as ASPxComboBox;
//ASPxSpinEdit spin_Incentive1 = grd.FindEditFormTemplateControl("spin_Incentive1") as ASPxSpinEdit;
//ASPxSpinEdit spin_Incentive2 = grd.FindEditFormTemplateControl("spin_Incentive2") as ASPxSpinEdit;
//ASPxSpinEdit spin_Incentive3 = grd.FindEditFormTemplateControl("spin_Incentive3") as ASPxSpinEdit;
//ASPxComboBox cbb_Incentive4 = grd.FindEditFormTemplateControl("cbb_Incentive4") as ASPxComboBox;
//ASPxComboBox cbb_Overtime = grd.FindEditFormTemplateControl("cbb_Overtime") as ASPxComboBox;
ASPxMemo txt_driver_remark = grd.FindEditFormTemplateControl("txt_driver_remark") as ASPxMemo;
//ASPxComboBox cbb_OverDistance = grd.FindEditFormTemplateControl("cbb_OverDistance") as ASPxComboBox;
ASPxTextBox fromPackingLot = grd.FindEditFormTemplateControl("txt_FromPL") as ASPxTextBox;
ASPxTextBox toPackingLot = grd.FindEditFormTemplateControl("txt_ToPL") as ASPxTextBox;
//check_Trip_Status("0", trip.DriverCode,trip.Statuscode);
//ASPxSpinEdit spin_Charge1 = grd.FindEditFormTemplateControl("spin_Charge1") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge2 = grd.FindEditFormTemplateControl("spin_Charge2") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge3 = grd.FindEditFormTemplateControl("spin_Charge3") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge4 = grd.FindEditFormTemplateControl("spin_Charge4") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge5 = grd.FindEditFormTemplateControl("spin_Charge5") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge6 = grd.FindEditFormTemplateControl("spin_Charge6") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge7 = grd.FindEditFormTemplateControl("spin_Charge7") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge8 = grd.FindEditFormTemplateControl("spin_Charge8") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge9 = grd.FindEditFormTemplateControl("spin_Charge9") as ASPxSpinEdit;
//ASPxSpinEdit spin_Charge10 = grd.FindEditFormTemplateControl("spin_Charge10") as ASPxSpinEdit;
ASPxSpinEdit txt_trip_qty = grd.FindEditFormTemplateControl("txt_trip_qty") as ASPxSpinEdit;
ASPxButtonEdit txt_Trip_PkgsType = grd.FindEditFormTemplateControl("txt_Trip_PkgsType") as ASPxButtonEdit;
ASPxSpinEdit txt_trip_Wt = grd.FindEditFormTemplateControl("txt_trip_Wt") as ASPxSpinEdit;
ASPxSpinEdit txt_trip_M3 = grd.FindEditFormTemplateControl("txt_trip_M3") as ASPxSpinEdit;
if (dde_Trip_ContNo != null)
{
trip.ContainerNo = SafeValue.SafeString(dde_Trip_ContNo.Value);
}
if (dde_Trip_ContId != null)
{
trip.Det1Id = SafeValue.SafeInt(dde_Trip_ContId.Text, 0);
}
//trip.CfsCode = SafeValue.SafeString(btn_CfsCode.Value);
//trip.BayCode = SafeValue.SafeString(cbb_Trip_BayCode.Value);
if (btn_DriverCode != null)
{
trip.DriverCode = SafeValue.SafeString(btn_DriverCode.Value);
}
if (btn_TowheadCode != null)
{
trip.TowheadCode = SafeValue.SafeString(btn_TowheadCode.Value);
}
if (btn_ChessisCode != null)
{
trip.ChessisCode = SafeValue.SafeString(btn_ChessisCode.Value);
}
//trip.SubletFlag = SafeValue.SafeString(cbb_Trip_SubletFlag.Value);
//trip.SubletHauliername = SafeValue.SafeString(txt_SubletHauliername.Text);
if (cbb_Trip_TripCode != null)
{
trip.TripCode = SafeValue.SafeString(cbb_Trip_TripCode.Value);
}
if (cmb_DoubleMounting != null)
{
trip.DoubleMounting = SafeValue.SafeString(cmb_DoubleMounting.Value, "No");
}
//trip.StageCode = SafeValue.SafeString(cbb_StageCode.Value);
//trip.Carpark = SafeValue.SafeString(cbb_Carpark.Value);
//trip.StageStatus = SafeValue.SafeString(cbb_StageStatus.Value);
if (cbb_Trip_StatusCode != null)
{
trip.Statuscode = SafeValue.SafeString(cbb_Trip_StatusCode.Value);
}
if (txt_FromDate != null)
{
trip.FromDate = SafeValue.SafeDate(txt_FromDate.Date, new DateTime(1990, 1, 1));
}
if (txt_Trip_fromTime != null)
{
trip.FromTime = SafeValue.SafeString(txt_Trip_fromTime.Text);
}
if (date_Trip_toDate != null)
{
trip.ToDate = SafeValue.SafeDate(date_Trip_toDate.Date, new DateTime(1990, 1, 1));
}
if (txt_Trip_toTime != null)
{
trip.ToTime = SafeValue.SafeString(txt_Trip_toTime.Text);
}
if (txt_Trip_Remark != null)
{
trip.Remark = SafeValue.SafeString(txt_Trip_Remark.Text);
}
if (txt_Trip_FromCode != null)
{
trip.FromCode = SafeValue.SafeString(txt_Trip_FromCode.Text);
}
if (txt_Trip_ToCode != null)
{
trip.ToCode = SafeValue.SafeString(txt_Trip_ToCode.Text);
}
//trip.Incentive1 = SafeValue.SafeDecimal(spin_Price.Text);
if (cbb_zone != null)
{
trip.ParkingZone = SafeValue.SafeString(cbb_zone.Value);
}
//trip.Incentive1 = SafeValue.SafeDecimal(spin_Incentive1.Text);
//trip.Incentive2 = SafeValue.SafeDecimal(spin_Incentive2.Text);
//trip.Incentive3 = SafeValue.SafeDecimal(spin_Incentive3.Text);
//trip.Incentive4 = SafeValue.SafeDecimal(cbb_Incentive4.Value);
//trip.Overtime = SafeValue.SafeSqlString(cbb_Overtime.Value);
//trip.OverDistance = SafeValue.SafeSqlString(cbb_OverDistance.Value);
if (txt_driver_remark != null)
{
trip.Remark1 = SafeValue.SafeString(txt_driver_remark.Text);
}
if (fromPackingLot != null)
{
trip.FromParkingLot = SafeValue.SafeString(fromPackingLot.Text);
}
if (toPackingLot != null)
{
trip.ToParkingLot = SafeValue.SafeString(toPackingLot.Text);
}
//trip.Charge1 = SafeValue.SafeDecimal(spin_Charge1.Text);
//trip.Charge2 = SafeValue.SafeDecimal(spin_Charge2.Text);
//trip.Charge3 = SafeValue.SafeDecimal(spin_Charge3.Text);
//trip.Charge4 = SafeValue.SafeDecimal(spin_Charge4.Text);
//trip.Charge5 = SafeValue.SafeDecimal(spin_Charge5.Text);
//trip.Charge6 = SafeValue.SafeDecimal(spin_Charge6.Text);
//trip.Charge7 = SafeValue.SafeDecimal(spin_Charge7.Text);
//trip.Charge8 = SafeValue.SafeDecimal(spin_Charge8.Text);
//trip.Charge9 = SafeValue.SafeDecimal(spin_Charge9.Text);
//trip.Charge10 = SafeValue.SafeDecimal(spin_Charge10.Text);
if (txt_trip_qty != null)
{
trip.Qty = SafeValue.SafeInt(txt_trip_qty.Text, 0);
}
if (txt_Trip_PkgsType != null)
{
trip.PackageType = SafeValue.SafeString(txt_Trip_PkgsType.Text);
}
if (txt_trip_Wt != null)
{
trip.Weight = SafeValue.SafeDecimal(txt_trip_Wt.Text);
}
if (txt_trip_M3 != null)
{
trip.Volume = SafeValue.SafeDecimal(txt_trip_M3.Text);
}
if (isNew)
{
trip.JobNo = "0";
C2.ManagerEdi.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Inserted);
C2.ManagerEdi.ORManager.PersistChanges(trip);
Event_Log("", "TRIP", 1, SafeValue.SafeInt(trip.Id, 0), "");
}
else
{
C2.ManagerEdi.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Updated);
C2.ManagerEdi.ORManager.PersistChanges(trip);
Event_Log("", "TRIP", 3, SafeValue.SafeInt(trip.Id, 0), "");
//EGL_JobTrip_AfterEndTrip("", dde_Trip_ContId.Text);
}
string re = HttpContext.Current.User.Identity.Name + "," + trip.Id + "," + trip.DriverCode;
if (!trip.DriverCode.Equals(Driver_old))
{
re += "," + Driver_old;
}
Session["NameTrip_" + trip.Id] = "Id=" + trip.Id + "";
this.dsTrip.FilterExpression = Session["NameTrip_" + trip.Id].ToString();
if (this.grid_Trip.GetRow(0) != null)
{
this.grid_Trip.CancelEdit();
}
e.Result = re;
}
private void set_signed_barcode_byid(XtraReport rpt, string orderNo, string id, string httpPath, string filename)
{
QR q = new QR();
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJobDet2), "Id=" + id + "");
C2.CtmJobDet2 job = C2.Manager.ORManager.GetObject(query) as C2.CtmJobDet2;
//string text = string.Format(@"JobNo:" + orderNo);
Bitmap bt = q.Create_QR(httpPath);
string path = MapPath("~/files/barcode/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string fileName = id + ".png";
string filePath = path + fileName;
if (File.Exists(filePath))
{
File.Delete(filePath);
}
bt.Save(Server.MapPath("~/files/barcode/") + fileName);
DevExpress.XtraReports.UI.XRPictureBox qr_code = rpt.Report.FindControl("barcode", true) as DevExpress.XtraReports.UI.XRPictureBox;
if (qr_code != null)
{
qr_code.ImageUrl = "/files/barcode/" + fileName;
}
string Signature_Consignee = "";
string Signature_Driver = "";
string signature_time = "";
string signature_time1 = "";
string sql_signature = string.Format(@"select Id,FileType,FileName,FilePath,FileNote,CreateDateTime From CTM_Attachment where FileType='Signature' and RefNo=@RefNo and charindex(@sType, FileNote,0)>0 and TripId=@tripId");
List <ConnectSql_mb.cmdParameters> list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@RefNo", orderNo, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@sType", "Consignee", SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@tripId", id, SqlDbType.Int));
DataTable dt = ConnectSql_mb.GetDataTable(sql_signature, list);
if (dt.Rows.Count > 0)
{
if (job.EpodHardCopy == "HardCopy")
{
Signature_Consignee = dt.Rows[0]["FilePath"].ToString().Replace(@"/500", "");
}
else
{
Signature_Consignee = dt.Rows[0]["FilePath"].ToString();
}
signature_time = dt.Rows[0]["CreateDateTime"].ToString();
}
list = new List <ConnectSql_mb.cmdParameters>();
list.Add(new ConnectSql_mb.cmdParameters("@RefNo", orderNo, SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@sType", "Driver", SqlDbType.NVarChar, 100));
list.Add(new ConnectSql_mb.cmdParameters("@tripId", id, SqlDbType.Int));
dt = ConnectSql_mb.GetDataTable(sql_signature, list);
if (dt.Rows.Count > 0)
{
Signature_Driver = dt.Rows[0]["FilePath"].ToString();
signature_time1 = dt.Rows[0]["CreateDateTime"].ToString();
}
DevExpress.XtraReports.UI.XRPictureBox signature = rpt.Report.FindControl("signature", true) as DevExpress.XtraReports.UI.XRPictureBox;
if (signature != null)
{
signature.ImageUrl = Signature_Consignee;
}
DevExpress.XtraReports.UI.XRLabel time = rpt.Report.FindControl("lbl_time", true) as DevExpress.XtraReports.UI.XRLabel;
if (time != null)
{
time.Text = signature_time;
}
DevExpress.XtraReports.UI.XRPictureBox signature1 = rpt.Report.FindControl("signature1", true) as DevExpress.XtraReports.UI.XRPictureBox;
if (signature1 != null)
{
signature1.ImageUrl = Signature_Driver;
}
DevExpress.XtraReports.UI.XRLabel time1 = rpt.Report.FindControl("lbl_time1", true) as DevExpress.XtraReports.UI.XRLabel;
if (time1 != null)
{
time1.Text = signature_time1;
}
}
protected void grid_wh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string para = e.Parameters;
if (Request.QueryString["no"] != null)
{
try
{
#region list
if (list.Count > 0)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
string jobType = SafeValue.SafeString(Request.QueryString["type"]);
string client = SafeValue.SafeString(Request.QueryString["clientId"]);
#region OK
if (para == "OK")
{
string jobNo = "";
string refType = "";
bool action = false;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + no + "'");
C2.CtmJob job = C2.Manager.ORManager.GetObject(query) as C2.CtmJob;
C2.CtmJobDet2 trip = null;
if (job != null)
{
refType = SafeValue.SafeString(Request.QueryString["action"]);
jobNo = C2Setup.GetNextNo("", "CTM_Job_" + refType, DateTime.Today);
job.JobNo = jobNo;
job.QuoteNo = jobNo;
job.JobType = refType;
job.JobDate = DateTime.Now;
job.JobStatus = "Confirmed";
job.QuoteStatus = "None";
C2.Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(job);
C2Setup.SetNextNo("", "CTM_Job_" + refType, jobNo, DateTime.Today);
#region Trip
trip = new C2.CtmJobDet2();
string sql = string.Format(@"select max(TripIndex) from CTM_JobDet2 where JobType=@JobType and JobNo=@JobNo");
List <ConnectSql_mb.cmdParameters> list_cmd = new List <ConnectSql_mb.cmdParameters>();
list_cmd.Add(new ConnectSql_mb.cmdParameters("@JobNo", jobNo, SqlDbType.NVarChar, 100));
list_cmd.Add(new ConnectSql_mb.cmdParameters("@JobType", refType, SqlDbType.NVarChar, 100));
string maxIdex = SafeValue.SafeString(ConnectSql_mb.ExecuteScalar(sql, list_cmd).context, "//00");
int n = SafeValue.SafeInt(maxIdex.Substring(maxIdex.LastIndexOf("/") + 1), 0) + 1;
string str = (100 + n).ToString().Substring(1);
trip.BookingDate = DateTime.Today;
trip.TripIndex = jobNo + "/" + refType + "/" + str;
trip.JobNo = jobNo;
trip.FromDate = DateTime.Today;
trip.ToDate = DateTime.Today;
trip.CreateUser = HttpContext.Current.User.Identity.Name;
trip.CreateTime = DateTime.Now;
trip.UpdateUser = HttpContext.Current.User.Identity.Name;
trip.UpdateTime = DateTime.Now;
trip.JobType = refType;
trip.TripCode = refType;
trip.Remark = job.Remark;
trip.ToCode = job.DeliveryTo;
trip.FromCode = job.PickupFrom;
trip.Statuscode = "P";
C2.Manager.ORManager.StartTracking(trip, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(trip);
string userId = HttpContext.Current.User.Identity.Name;
C2.CtmJobEventLog elog = new C2.CtmJobEventLog();
elog.Platform_isWeb();
elog.Controller = userId;
elog.ActionLevel_isCONT(trip.Id);
elog.setActionLevel(trip.Id, CtmJobEventLogRemark.Level.Container, 1, "");
elog.log();
#endregion
}
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
decimal qty = list[i].qty;
decimal weight = list[i].weight;
decimal volume = list[i].volume;
decimal sku_qty = list[i].sku_qty;
decimal l = list[i].l;
decimal h = list[i].h;
decimal w = list[i].w;
string refNo = list[i].refNo;
string toLoc = list[i].toLoc;
if (qty > 0)
{
Wilson.ORMapper.OPathQuery query1 = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + id + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query1) as C2.JobHouse;
house.LineId = id;
house.CargoType = "OUT";
house.JobNo = jobNo;
house.ContNo = "";
house.JobType = refType;
house.QtyOrig = qty;
house.PackQty = sku_qty;
house.Weight = weight;
house.Volume = volume;
house.WeightOrig = weight;
house.VolumeOrig = volume;
house.LandStatus = "Normal";
house.DgClass = "Normal";
house.DamagedStatus = "Normal";
house.LengthPack = l;
house.WidthPack = w;
house.HeightPack = h;
house.RefNo = no;
house.Qty = qty;
house.OpsType = "Delivery";
house.ClientId = client;
house.CargoStatus = "P";
house.TripId = trip.Id;
house.TripIndex = trip.TripIndex;
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
int lineId = house.Id;
if (refType == "TR")
{
house.LineId = lineId;
house.Location = toLoc;
house.JobNo = jobNo;
house.TransferNo = jobNo;
house.RefNo = refNo;
house.CargoType = "IN";
house.RefNo = no;
house.CargoStatus = "P";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
}
action = true;
}
else
{
action = false;
}
}
if (action)
{
e.Result = "Action Success! No is " + jobNo;
}
else
{
e.Result = "Action Error!";
}
}
#endregion
#region New WDO Trip
if (para == "NewTrip")
{
bool action = false;
for (int i = 0; i < list.Count; i++)
{
int id = list[i].id;
decimal qty = list[i].qty;
decimal weight = list[i].weight;
decimal volume = list[i].volume;
decimal sku_qty = list[i].sku_qty;
decimal l = list[i].l;
decimal h = list[i].h;
decimal w = list[i].w;
string refNo = list[i].refNo;
string toLoc = list[i].toLoc;
if (qty > 0)
{
Wilson.ORMapper.OPathQuery query1 = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + id + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query1) as C2.JobHouse;
house.LineId = id;
house.CargoType = "OUT";
house.JobNo = no;
house.ContNo = "";
house.JobType = jobType;
house.QtyOrig = qty;
house.PackQty = sku_qty;
house.Weight = weight;
house.Volume = volume;
house.WeightOrig = weight;
house.VolumeOrig = volume;
house.LandStatus = "Normal";
house.DgClass = "Normal";
house.DamagedStatus = "Normal";
house.LengthPack = l;
house.WidthPack = w;
house.HeightPack = h;
house.RefNo = no;
house.Qty = qty;
house.OpsType = "Delivery";
house.ClientId = client;
house.TripIndex = SafeValue.SafeString(cbb_TripNo.Text);
house.TripId = SafeValue.SafeInt(cbb_TripNo.Value, 0);
house.CargoStatus = "P";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
}
action = true;
}
if (action)
{
e.Result = "Success";
}
else
{
e.Result = "Action Error!";
}
}
#endregion
}
else
{
e.Result = "Pls Select at least one Cargo";
}
#endregion
}
catch { }
}
}
