protected void grid_CustomDataCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomDataCallbackEventArgs e)
{
string paras = e.Parameters;
if (paras == "Assign")
{
ASPxSpinEdit spin_Qty = grid.FindRowCellTemplateControl(0, null, "spin_Qty") as ASPxSpinEdit;
ASPxSpinEdit spin_Weight = grid.FindRowCellTemplateControl(0, null, "spin_Weight") as ASPxSpinEdit;
ASPxSpinEdit spin_Volume = grid.FindRowCellTemplateControl(0, null, "spin_Volume") as ASPxSpinEdit;
ASPxDateEdit date_ShipDate = grid.FindRowCellTemplateControl(0, null, "date_ShipDate") as ASPxDateEdit;
ASPxComboBox cbb_ShipIndex = grid.FindRowCellTemplateControl(0, null, "cbb_ShipIndex") as ASPxComboBox;
ASPxTextBox txt_ShipPortCode = grid.FindRowCellTemplateControl(0, null, "txt_ShipPortCode") as ASPxTextBox;
ASPxComboBox cbb_ContIndex = grid.FindRowCellTemplateControl(0, null, "cbb_ContIndex") as ASPxComboBox;
DateTime now = DateTime.Now;
string jobNo = "";
string refNo = "";
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + lbl_Id.Text + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query) as C2.JobHouse;
if (house != null)
{
#region
refNo = house.JobNo;
C2.CtmJob job = new CtmJob();
jobNo = C2Setup.GetNextNo("", "CTM_Job_WDO", DateTime.Now);
job.JobNo = jobNo;
job.JobDate = DateTime.Now;
job.ClientId = house.ConsigneeInfo;
job.DeliveryTo = "";
C2.Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(job);
C2Setup.SetNextNo("", "CTM_Job_WDO", jobNo, now);
house.LineId = SafeValue.SafeInt(lbl_Id.Text, 0);
job.JobType = "WDO";
house.JobNo = jobNo;
house.RefNo = refNo;
house.CargoType = "OUT";
house.CargoStatus = "P";
house.QtyOrig = SafeValue.SafeDecimal(spin_Qty.Value);
house.WeightOrig = SafeValue.SafeDecimal(spin_Weight.Value);
house.VolumeOrig = SafeValue.SafeDecimal(spin_Volume.Value);
house.ShipDate = date_ShipDate.Date;
house.ShipIndex = SafeValue.SafeInt(cbb_ShipIndex.Value, 0);
house.ShipPortCode = txt_ShipPortCode.Text;
house.ContIndex = SafeValue.SafeString(cbb_ContIndex.Value);
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
#endregion
}
e.Result = "Action Success! No is " + jobNo;
}
}
protected void grid_wh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
if (Request.QueryString["no"] != null)
{
try
{
if (list.Count > 0)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
string jobNo = SafeValue.SafeString(Request.QueryString["JobNo"]);
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;
if (qty > 0)
{
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + id + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query) as C2.JobHouse;
if (house != null)
{
C2.JobReceipt rec = new JobReceipt();
rec.Qty = qty;
rec.Weight = weight;
rec.Volume = volume;
rec.JobNo = jobNo;
rec.LineId = id;
rec.HblNo = house.HblNo;
rec.BookingNo = house.BookingNo;
rec.CargoId = id;
rec.PackQty = sku_qty;
rec.Remark1 = house.Remark1;
rec.Remark2 = house.Remark2;
rec.Marking1 = house.Marking1;
rec.Marking2 = house.Marking2;
rec.Location = house.Location;
rec.CargoType = "IN";
rec.TrailerId = SafeValue.SafeInt(no, 0);
rec.TrailerNo = house.ContNo;
C2.Manager.ORManager.StartTracking(rec, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(rec);
}
action = true;
}
else
{
action = false;
break;
}
}
if (action)
{
e.Result = "Success";
}
else
{
e.Result = "Pls keyin the Qty";
}
}
else
{
e.Result = "Pls Select at least one Cargo";
}
}
catch { }
}
}
public static DataSet PrintDeliveryOrder(string orderNo, string jobType)
{
DataSet set = new DataSet();
ObjectQuery query = new ObjectQuery(typeof(C2.CtmJob), "JobNo='" + orderNo + "'", "");
ObjectSet objSet = C2.Manager.ORManager.GetObjectSet(query);
if (objSet.Count == 0 || objSet[0] == null)
{
return(set);
}
C2.CtmJob obj = objSet[0] as C2.CtmJob;
ObjectQuery query1 = new ObjectQuery(typeof(C2.JobHouse), "JobNo='" + orderNo + "'", "");
ObjectSet objSet1 = C2.Manager.ORManager.GetObjectSet(query1);
#region init column
DataTable mast = new DataTable("Mast");
DataTable det = new DataTable("Det");
mast.Columns.Add("JobNo");
mast.Columns.Add("JobDate");
mast.Columns.Add("JobType");
mast.Columns.Add("Haulier");
mast.Columns.Add("Attn");
mast.Columns.Add("DeliveryTo");
mast.Columns.Add("PickupFrom");
mast.Columns.Add("OceanBl");
mast.Columns.Add("Yard");
mast.Columns.Add("Carrier");
mast.Columns.Add("CrNo");
mast.Columns.Add("Contact1");
mast.Columns.Add("Contact2");
mast.Columns.Add("Tel1");
mast.Columns.Add("Fax1");
mast.Columns.Add("Terminal");
mast.Columns.Add("Permit");
mast.Columns.Add("LastDate");
mast.Columns.Add("Portnet");
mast.Columns.Add("Ft20");
mast.Columns.Add("Ft40");
mast.Columns.Add("Ft45");
mast.Columns.Add("Vessel");
mast.Columns.Add("Voyage");
mast.Columns.Add("Etd");
mast.Columns.Add("Eta");
mast.Columns.Add("Pol");
mast.Columns.Add("Pod");
mast.Columns.Add("ByWho");
mast.Columns.Add("ClientRefNo");
mast.Columns.Add("PartyName");
mast.Columns.Add("PartyAdd");
mast.Columns.Add("AgentName");
mast.Columns.Add("UserData2");
mast.Columns.Add("UserData3");
mast.Columns.Add("UserData4");
mast.Columns.Add("Outside");
mast.Columns.Add("Note1");
mast.Columns.Add("Note2");
mast.Columns.Add("UserId");
mast.Columns.Add("Remark");
mast.Columns.Add("SpecialInstruction");
mast.Columns.Add("WarehouseCode");
mast.Columns.Add("CrBkgNo");
mast.Columns.Add("TotalQty");
det.Columns.Add("No");
det.Columns.Add("JobNo");
det.Columns.Add("CargoStatus");
det.Columns.Add("CargoType");
det.Columns.Add("ContNo");
det.Columns.Add("BookingNo");
det.Columns.Add("HblNo");
det.Columns.Add("OpsType");
det.Columns.Add("Qty");
det.Columns.Add("PackType");
det.Columns.Add("SkuCode");
det.Columns.Add("Weight");
det.Columns.Add("PackQty");
det.Columns.Add("PackUom");
det.Columns.Add("Volume");
det.Columns.Add("Location");
det.Columns.Add("Length");
det.Columns.Add("Width");
det.Columns.Add("Height");
det.Columns.Add("Marking1");
det.Columns.Add("Marking2");
det.Columns.Add("Remark1");
#endregion
DataRow row = mast.NewRow();
string sql_haulier = "select Name,CrNo,Contact1,Contact2,Tel1,Fax1 from xxparty where partyid='" + obj.ClientId + "'";
DataTable tab_hauler = Helper.Sql.List(sql_haulier);
if (jobType == "gr")
{
row["JobType"] = "Goods Receipt Note".ToUpper();
}
if (jobType == "do")
{
row["JobType"] = "Delivery Order".ToUpper();
}
if (jobType == "tp")
{
row["JobType"] = "Transport Instruction".ToUpper();
}
if (jobType == "tr")
{
row["JobType"] = "Transfer Instruction".ToUpper();
}
row["Attn"] = obj.Terminalcode;
row["DeliveryTo"] = obj.DeliveryTo;
row["PickupFrom"] = obj.PickupFrom;
row["CrNo"] = "";
row["Contact1"] = "";
row["Contact2"] = "";
row["Tel1"] = "";
row["Fax1"] = "";
if (tab_hauler.Rows.Count > 0)
{
row["Haulier"] = tab_hauler.Rows[0]["Name"];
row["CrNo"] = tab_hauler.Rows[0]["CrNo"].ToString();
row["Contact1"] = tab_hauler.Rows[0]["Contact1"].ToString();
row["Contact2"] = tab_hauler.Rows[0]["Contact2"].ToString();
row["Tel1"] = tab_hauler.Rows[0]["Tel1"].ToString();
row["Fax1"] = tab_hauler.Rows[0]["Fax1"].ToString();
}
row["JobNo"] = orderNo;
row["JobDate"] = obj.EtdDate.ToString("dd/MM/yyyy");
row["Vessel"] = obj.Vessel;
row["Voyage"] = obj.Voyage;
row["Permit"] = obj.PermitNo;
string sql = "select name from xxparty where partyid='" + obj.ClientId + "'";
row["PartyName"] = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql), "");
sql = "select Address from xxparty where partyid='" + obj.ClientId + "'";
row["PartyAdd"] = SafeValue.SafeString(ConnectSql.ExecuteScalar(sql), "");
row["Etd"] = obj.EtdDate.ToString("dd/MM/yyyy");
row["Eta"] = obj.EtaDate.ToString("dd/MM/yyyy");
sql = "select name from [XXPort] where code='" + SafeValue.SafeString(obj.Pol, "") + "'";
row["Pol"] = SafeValue.SafeString(Helper.Sql.One(sql), "");
sql = "select name from [XXPort] where code='" + SafeValue.SafeString(obj.Pod, "") + "'";
row["Pod"] = SafeValue.SafeString(Helper.Sql.One(sql), "");
sql = "select name from xxparty where partyid='" + obj.CarrierId + "'";
row["Carrier"] = SafeValue.SafeString(Helper.Sql.One(sql), "");
row["OceanBl"] = obj.CarrierBlNo;
row["CrBkgNo"] = obj.CarrierBkgNo;
row["Yard"] = obj.YardRef;
row["ByWho"] = "";
row["ClientRefNo"] = obj.ClientRefNo;
row["UserData2"] = "";
row["SpecialInstruction"] = obj.SpecialInstruction;
row["Remark"] = obj.Remark;
row["UserId"] = HttpContext.Current.User.Identity.Name;
decimal total = 0;
for (int i = 0; i < objSet1.Count; i++)
{
C2.JobHouse house = objSet1[i] as C2.JobHouse;
DataRow row1 = det.NewRow();
row1["No"] = i + 1;
row1["JobNo"] = orderNo;
row1["ContNo"] = house.ContNo;
row1["CargoStatus"] = house.CargoStatus;
row1["CargoType"] = house.CargoType;
row1["Location"] = house.Location;
row1["BookingNo"] = house.BookingNo;
row1["HblNo"] = house.HblNo;
row1["Length"] = house.LengthPack;
row1["Width"] = house.WidthPack;
row1["Height"] = house.HeightPack;
row1["Weight"] = house.WeightOrig;
row1["Volume"] = house.WeightOrig;
row1["Qty"] = house.QtyOrig;
row1["PackType"] = house.PackTypeOrig;
row1["PackQty"] = house.PackQty;
row1["PackUom"] = house.PackUom;
total += house.QtyOrig;
det.Rows.Add(row1);
}
row["TotalQty"] = total;
mast.Rows.Add(row);
set.Tables.Add(mast);
set.Tables.Add(det);
return(set);
}
public static DataTable DsReceipt(string recNo)
{
DataTable tab = new DataTable();
#region init column
tab.Columns.Add("Title");
tab.Columns.Add("JobType");
tab.Columns.Add("BarCode");
tab.Columns.Add("CustCode");
tab.Columns.Add("Port");
tab.Columns.Add("RecNo");
tab.Columns.Add("RecDate");
tab.Columns.Add("RecTime");
tab.Columns.Add("RecFrom");
tab.Columns.Add("Markings");
tab.Columns.Add("Contents");
tab.Columns.Add("ContNo");
tab.Columns.Add("ComplDate");
tab.Columns.Add("ComplTime");
tab.Columns.Add("Qty");
tab.Columns.Add("PackType");
tab.Columns.Add("M3");
tab.Columns.Add("Weight");
tab.Columns.Add("UserId");
tab.Columns.Add("SpcRemark");
tab.Columns.Add("InternalExternal");
tab.Columns.Add("ForkLift");
tab.Columns.Add("Dn");
tab.Columns.Add("Tracing");
tab.Columns.Add("Wh");
tab.Columns.Add("Admin");
tab.Columns.Add("Sr");
tab.Columns.Add("Removal");
tab.Columns.Add("Ot");
tab.Columns.Add("LongLength");
tab.Columns.Add("OverWeight");
tab.Columns.Add("Sticker");
tab.Columns.Add("Ugt");
tab.Columns.Add("Sec");
tab.Columns.Add("Dg");
tab.Columns.Add("Misc");
tab.Columns.Add("Other");
tab.Columns.Add("Waive");
tab.Columns.Add("Total");
tab.Columns.Add("OtherRemarks");
tab.Columns.Add("VesVoy");
tab.Columns.Add("BillAmt");
tab.Columns.Add("DoNo");
tab.Columns.Add("IsCn");
tab.Columns.Add("Cn");
tab.Columns.Add("HblN");
tab.Columns.Add("JobOrder");
tab.Columns.Add("ClearRmk");
tab.Columns.Add("VehicleUser");
tab.Columns.Add("VehicleTel");
tab.Columns.Add("VehicleNric");
tab.Columns.Add("VehicleNo1");
tab.Columns.Add("VehicleNo2");
tab.Columns.Add("VehicleNo3");
tab.Columns.Add("QtyWord");
tab.Columns.Add("TotQty");
#endregion
ObjectQuery query = new ObjectQuery(typeof(C2.CtmJob), "JobNo='" + recNo + "'", "");
ObjectSet objSet = C2.Manager.ORManager.GetObjectSet(query);
C2.CtmJob job = objSet[0] as C2.CtmJob;
ObjectQuery query1 = new ObjectQuery(typeof(C2.JobHouse), "JobNo='" + recNo + "'", "");
ObjectSet objSet1 = C2.Manager.ORManager.GetObjectSet(query1);
DataRow row = tab.NewRow();
if (objSet1.Count > 0 && objSet1[0] != null)
{
C2.JobHouse obj = objSet1[0] as C2.JobHouse;
if (job.JobType == "DO")
{
row["Title"] = "DELIVERY NOTE";
}
if (job.JobType == "GR")
{
row["Title"] = "CARGO RECEIPT";
}
if (job.JobType == "TP")
{
row["Title"] = "CARGO DIRECT RELEASE";
}
row["JobType"] = obj.JobType;
row["BarCode"] = "04-" + job.JobNo + "-00";
row["RecNo"] = obj.JobNo;
row["RecDate"] = job.JobDate.ToString("dd/MM/yyyy");
row["RecTime"] = job.JobDate.ToString("HH:mm");
row["JobOrder"] = job.JobNo;
row["RecFrom"] = EzshipHelper.GetPartyName(obj.ClientId);
row["CustCode"] = obj.ClientId;
string agCode = "";
//row["Port"] = obj.JobType=="E" ? obj.PortDisc : obj.PortLoad;
row["Markings"] = obj.Marking1;
row["Contents"] = obj.Marking2;
row["ContNo"] = obj.ContNo;
row["ComplDate"] = job.UpdateDateTime.ToString("dd/MM/yyyy");
row["ComplTime"] = job.UpdateDateTime.ToString("HH:mm");
row["HblN"] = obj.HblNo;
row["Qty"] = obj.Qty.ToString();
row["PackType"] = obj.UomCode;
row["M3"] = obj.Volume.ToString("0.000");
row["Weight"] = obj.Weight.ToString("0.000");
row["UserId"] = job.CreateBy;
string value = SafeValue.SafeString("0.00");
row["ForkLift"] = value;
row["Dn"] = value;
row["Tracing"] = value;
row["Wh"] = value;
row["Admin"] = value;
row["Sr"] = value;
row["Removal"] = value;
row["Dg"] = value;
row["Sec"] = value;
row["LongLength"] = Helper.Safe.SafeDecimal(value).ToString("0.00");
row["OverWeight"] = Helper.Safe.SafeDecimal(value).ToString("0.00");
row["Sticker"] = Helper.Safe.SafeDecimal(value).ToString("0.00");
row["Ot"] = value;
row["Ugt"] = value;
row["Misc"] = value;
row["Other"] = value;
//if (obj.WaiveAmt == 0)
// row["Waive"] = "0.00";
//else
// row["Waive"] = "(" + obj.WaiveAmt.ToString("0.00") + ")";
row["Total"] = value;
row["OtherRemarks"] = obj.Remark1;
row["IsCn"] = "DELIVERY NOTE/OFFICIAL RECEIPT";
row["Cn"] = "";
row["VesVoy"] = job.Vessel + " / " + job.Voyage;
row["DoNo"] = "";
row["ClearRmk"] = "";
row["VehicleUser"] = "";
row["VehicleTel"] = "";
row["VehicleNric"] = "";
row["VehicleNo1"] = "";
row["VehicleNo2"] = "";
row["VehicleNo3"] = "";
NumberToMoney num = new NumberToMoney();
string s = num.NumberToCurrency(Convert.ToDecimal(obj.Qty));
row["QtyWord"] = s + " " + obj.UomCode;
row["TotQty"] = obj.Qty;
row["SpcRemark"] = "";
row["InternalExternal"] = S.Text("") == "CO-LOAD" ? "Internal" : "External";
}
tab.Rows.Add(row);
return(tab);
}
protected void grid_wh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
if (Request.QueryString["no"] != null)
{
try
{
if (list.Count > 0)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
string jobType = SafeValue.SafeString(Request.QueryString["jobType"]);
string client = SafeValue.SafeString(Request.QueryString["client"]);
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 jobNo = list[i].jobNo;
string refNo = list[i].refNo;
string toLoc = list[i].toLoc;
if (qty > 0)
{
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + id + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query) as C2.JobHouse;
house.ClientId = client;
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.JobNo = no;
house.TransferNo = jobNo;
house.RefNo = refNo;
house.CargoType = "OUT";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
int lineId = house.Id;
house.LineId = lineId;
house.Location = toLoc;
house.JobNo = no;
house.TransferNo = jobNo;
house.RefNo = refNo;
house.CargoType = "IN";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
action = true;
}
else
{
action = false;
break;
}
}
if (action)
{
e.Result = "Success";
}
else
{
e.Result = "Pls keyin the Qty";
}
}
else
{
e.Result = "Pls Select at least one Cargo";
}
}
catch { }
}
}
protected void grid_wh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string pars = e.Parameters;
string[] ar = pars.Split('_');
if (Request.QueryString["no"] != null)
{
try
{
if (ar.Length >= 2)
{
if (ar[0].Equals("Dimensionline"))
{
ASPxGridView grid = sender as ASPxGridView;
int rowIndex = SafeValue.SafeInt(ar[1], -1);
ASPxTextBox txt_Id = grid.FindRowCellTemplateControl(rowIndex, null, "txt_Id") as ASPxTextBox;
e.Result = txt_Id.Text;
}
}
else
{
#region
if (list.Count > 0)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
string type = SafeValue.SafeString(Request.QueryString["type"]);
string client = SafeValue.SafeString(Request.QueryString["client"]);
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;
if (qty > 0)
{
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id=" + id + "");
C2.JobHouse house = C2.Manager.ORManager.GetObject(query) as C2.JobHouse;
house.CargoStatus = "C";
house.JobNo = no;
house.ContNo = "";
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 = refNo;
house.ClientId = client;
house.LineId = id;
house.CargoType = type;
house.StockDate = DateTime.Now;
string jobType = "";
if (type == "IN")
{
jobType = "WGR";
}
else if (type == "OUT")
{
jobType = "WDO";
}
string res = Trip_New(jobType, house.TripId);
string[] str = res.Split('_');
house.TripId = SafeValue.SafeInt(str[0], 0);
house.TripIndex = str[1];
house.Qty = qty;
house.OpsType = "Delivery";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
action = true;
}
else
{
action = false;
break;
}
}
if (action)
{
e.Result = "Success";
}
else
{
e.Result = "Pls keyin the Qty";
}
}
else
{
e.Result = "Pls Select at least one Cargo";
}
#endregion
}
}
catch { }
}
}
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 { }
}
}
protected void grid_wh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
if (Request.QueryString["no"] != null)
{
try
{
if (list.Count > 0)
{
string no = SafeValue.SafeString(Request.QueryString["no"]);
string jobType = SafeValue.SafeString(Request.QueryString["jobType"]);
string jobNo = "";
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.CtmJob), "JobNo='" + no + "'");
C2.CtmJob job = C2.Manager.ORManager.GetObject(query) as C2.CtmJob;
if (job != null)
{
jobNo = C2Setup.GetNextNo("", "CTM_Job_DO", DateTime.Today);
job.JobNo = jobNo;
job.QuoteNo = "";
job.JobType = "DO";
job.JobDate = DateTime.Now;
job.JobStatus = "Confirmed";
C2.Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(job);
C2Setup.SetNextNo("", "CTM_Job_DO", jobNo, DateTime.Today);
}
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;
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.CargoType = "OUT";
house.JobNo = jobNo;
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";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
}
else
{
}
}
e.Result = "Success";
}
else
{
e.Result = "Pls Select at least one Cargo";
}
}
catch { }
}
}
protected void grid_wh_CustomDataCallback(object sender, ASPxGridViewCustomDataCallbackEventArgs e)
{
string pars = e.Parameters;
string[] ar = pars.Split('_');
if (ar.Length >= 2)
{
if (ar[0].Equals("Uploadline"))
{
ASPxGridView grid = sender as ASPxGridView;
int rowIndex = SafeValue.SafeInt(ar[1], -1);
ASPxTextBox txt_Id = grid.FindRowCellTemplateControl(rowIndex, null, "txt_Id") as ASPxTextBox;
ASPxTextBox txt_ContNo = grid.FindRowCellTemplateControl(rowIndex, null, "txt_ContNo") as ASPxTextBox;
e.Result = txt_Id.Text + "_" + txt_ContNo.Text;
}
if (ar[0].Equals("Dimensionline"))
{
ASPxGridView grid = sender as ASPxGridView;
int rowIndex = SafeValue.SafeInt(ar[1], -1);
ASPxTextBox txt_Id = grid.FindRowCellTemplateControl(rowIndex, null, "txt_Id") as ASPxTextBox;
e.Result = txt_Id.Text;
}
if (ar[0].Equals("Copyonline"))
{
ASPxGridView grid = sender as ASPxGridView;
int rowIndex = SafeValue.SafeInt(ar[1], -1);
ASPxTextBox txt_Id = grid.FindRowCellTemplateControl(rowIndex, null, "txt_Id") as ASPxTextBox;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id='" + txt_Id.Text + "'");
C2.JobHouse job = C2.Manager.ORManager.GetObject(query) as C2.JobHouse;
if (job != null)
{
job.SkuCode = job.BkgSKuCode;
job.PackQty = job.BkgSkuQty;
job.PackUom = job.BkgSkuUnit;
job.WeightOrig = job.Weight;
job.VolumeOrig = job.Volume;
C2.Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(job);
e.Result = "Success";
}
}
if (ar[0].Equals("CopyonCargoline"))
{
ASPxGridView grid = sender as ASPxGridView;
int rowIndex = SafeValue.SafeInt(ar[1], -1);
ASPxTextBox txt_Id = grid.FindRowCellTemplateControl(rowIndex, null, "txt_Id") as ASPxTextBox;
ASPxComboBox cbb_CargoCount = grid.FindRowCellTemplateControl(rowIndex, null, "cbb_CargoCount") as ASPxComboBox;
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id='" + txt_Id.Text + "'");
C2.JobHouse job = C2.Manager.ORManager.GetObject(query) as C2.JobHouse;
if (job != null)
{
int count = SafeValue.SafeInt(cbb_CargoCount.Value, 0);
for (int i = 0; i < count; i++)
{
C2.Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(job);
job.LineId = job.Id;
C2.Manager.ORManager.StartTracking(job, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(job);
Wilson.ORMapper.OPathQuery query1 = new Wilson.ORMapper.OPathQuery(typeof(C2.Dimension), "HouseId='" + txt_Id.Text + "'");
ObjectSet objSet = C2.Manager.ORManager.GetObjectSet(query1);
for (int j = 0; j < objSet.Count; j++)
{
C2.Dimension d = objSet[i] as C2.Dimension;
d.HouseId = job.Id;
C2.Manager.ORManager.StartTracking(d, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(d);
}
}
e.Result = "Success";
}
}
}
}
