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