private string update_house(int id, DateTime shipDate, string shipIndex
, string portCode, string contIndex, object qty, object weight, object volume)
{
string result = "";
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)
{
#region
house.ShipDate = shipDate;
house.ShipIndex = SafeValue.SafeInt(shipIndex, 0);
house.ShipPortCode = portCode;
house.ContIndex = contIndex;
house.QtyOrig = SafeValue.SafeDecimal(qty);
house.WeightOrig = SafeValue.SafeDecimal(weight);
house.VolumeOrig = SafeValue.SafeDecimal(volume);
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(house);
result = "Save Success!";
#endregion
}
return(result);
}
protected void grid_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
int id = SafeValue.SafeInt(Request.QueryString["id"], 0);
string jobNo = SafeValue.SafeString(Request.QueryString["no"]);
Wilson.ORMapper.OPathQuery job = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id='" + id + "'");
C2.JobHouse house = C2.Manager.ORManager.GetObject(job) as C2.JobHouse;
e.NewValues["HouseId"] = id;
e.NewValues["Qty"] = 1;
e.NewValues["ProcessQty1"] = 0;
e.NewValues["ProcessQty2"] = 0;
e.NewValues["ProcessQty3"] = 0;
e.NewValues["JobNo"] = jobNo;
e.NewValues["DateEntry"] = DateTime.Now;
e.NewValues["DatePlan"] = DateTime.Now;
//e.NewValues["DateInspect"] = DateTime.Now;
//e.NewValues["DateProcess"] = DateTime.Now;
e.NewValues["ProcessType"] = "";
e.NewValues["ProcessStatus"] = "Pending";
e.NewValues["LotNo"] = house.BookingNo;
e.NewValues["LocationCode"] = "";
e.NewValues["Specs1"] = "";
e.NewValues["Specs2"] = "";
e.NewValues["Specs3"] = "";
e.NewValues["Specs4"] = "";
e.NewValues["Remark1"] = "";
e.NewValues["Remark2"] = "";
}
private string update_cont(int id, string jobNo, string contNo, string sealNo, string contType, DateTime schedule, string contIndex
, string clearStatus, DateTime clearDate, string verify, DateTime verifyDate, string remark, DateTime valiDate, DateTime scheduleStartDate)
{
string result = "";
#region list
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "JobNo='" + jobNo + "' and ContNo='" + contIndex + "'");
ObjectSet objSet = C2.Manager.ORManager.GetObjectSet(query);
if (objSet.Count > 0)
{
#region
for (int j = 0; j < objSet.Count; j++)
{
C2.JobHouse house = objSet[j] as C2.JobHouse;
house.ContNo = contNo;
house.OpsType = "Export";
house.CargoStatus = "C";
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(house);
}
#endregion
}
string sql = "";
List <ConnectSql_mb.cmdParameters> cmd = new List <ConnectSql_mb.cmdParameters>();
sql = string.Format(@"update ctm_jobdet1 set ContainerNo=@ContainerNo,SealNo=@SealNo,
ContainerType=@ContainerType,ScheduleDate=@ScheduleDate,StatusCode=@StatusCode,CustomsClearDate=@CustomsClearDate,
CustomsClearStatus=@CustomsClearStatus,CustomsVerifyInd=@CustomsVerifyInd,CustomsVerifyDate=@CustomsVerifyDate,CustomsRemark=@CustomsRemark,ValiDate=@ValiDate,ScheduleStartDate=@ScheduleStartDate
where JobNo=@JobNo and ContainerNo=@ContNo");
cmd = new List <ConnectSql_mb.cmdParameters>();
cmd.Add(new ConnectSql_mb.cmdParameters("@ContainerNo", contNo, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@SealNo", sealNo, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@ContainerType", contType, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@JobNo", jobNo, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@ContNo", contIndex, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@StatusCode", "Export", SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@ScheduleDate", schedule, SqlDbType.DateTime));
cmd.Add(new ConnectSql_mb.cmdParameters("@CustomsClearDate", clearDate, SqlDbType.DateTime));
cmd.Add(new ConnectSql_mb.cmdParameters("@CustomsClearStatus", clearStatus, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@CustomsVerifyInd", verify, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@CustomsVerifyDate", verifyDate, SqlDbType.DateTime));
cmd.Add(new ConnectSql_mb.cmdParameters("@CustomsRemark", remark, SqlDbType.NVarChar));
cmd.Add(new ConnectSql_mb.cmdParameters("@ValiDate", valiDate, SqlDbType.DateTime));
cmd.Add(new ConnectSql_mb.cmdParameters("@ScheduleStartDate", scheduleStartDate, SqlDbType.DateTime));
ConnectSql_mb.sqlResult res = ConnectSql_mb.ExecuteNonQuery(sql, cmd);
if (res.status)
{
result = "Save Success!";
}
#endregion
return(result);
}
private void insert_data(string jobNo, string refNo, int id, int shipIndex, DateTime shipDate, string postCode, string contIndex, decimal qty, decimal weight, decimal volume)
{
string contNo = "C_" + contIndex;
string sql = string.Format(@"select count(*) from ctm_jobdet1 where JobNo='{0}' and ContainerNo='{1}'", jobNo, contNo);
int n = SafeValue.SafeInt(ConnectSql_mb.ExecuteScalar(sql), 0);
if (n == 0)
{
create_cont(jobNo, contNo, shipDate);
}
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)
{
#region
refNo = house.JobNo;
house.OpsType = "Export";
house.LineId = id;
house.JobType = "EXP";
house.JobNo = jobNo;
house.RefNo = refNo;
house.CargoType = "OUT";
house.CargoStatus = "P";
house.QtyOrig = qty;
house.WeightOrig = weight;
house.VolumeOrig = volume;
house.ShipDate = shipDate;
house.ShipIndex = shipIndex;
house.ShipPortCode = postCode;
house.ContIndex = contNo;
house.ContNo = house.ContIndex;
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(house);
#endregion
}
ObjectQuery query1 = new ObjectQuery(typeof(C2.JobStock), "OrderId=" + id + "", "");
ObjectSet objSet = C2.Manager.ORManager.GetObjectSet(query1);
if (objSet.Count > 0)
{
for (int j = 0; j < objSet.Count; j++)
{
C2.JobStock s = objSet[j] as C2.JobStock;
s.OrderId = house.Id;
s.LineId = id;
C2.Manager.ORManager.StartTracking(s, Wilson.ORMapper.InitialState.Inserted);
C2.Manager.ORManager.PersistChanges(s);
}
}
}
private string update_house(int id, DateTime deliveryDate, object qty, object weight, object volume, object sendMode)
{
string result = "";
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)
{
#region
//house.DeliveryDate = deliveryDate;
house.QtyOrig = SafeValue.SafeDecimal(qty);
house.WeightOrig = SafeValue.SafeDecimal(weight);
house.VolumeOrig = SafeValue.SafeDecimal(volume);
//house.SendMode = SafeValue.SafeString(sendMode);
C2.Manager.ORManager.StartTracking(house, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(house);
result = "Success";
#endregion
}
return(result);
}
private void updateStatus(ASPxGridView grid, string Id, ASPxGridViewCustomDataCallbackEventArgs e, int rowIndex)
{
try
{
Wilson.ORMapper.OPathQuery query = new Wilson.ORMapper.OPathQuery(typeof(C2.JobHouse), "Id='" + Id + "'");
C2.JobHouse jo = C2.Manager.ORManager.GetObject(query) as C2.JobHouse;
if (jo.CargoStatus == "USE")
{
jo.CargoStatus = "ORDER";
}
if (jo.CargoStatus == "ORDER")
{
jo.CargoStatus = "IN";
}
else if (jo.CargoStatus == "IN")
{
jo.CargoStatus = "PICKED";
}
else if (jo.CargoStatus == "PICKED")
{
jo.CargoStatus = "OUT";
}
else if (jo.CargoStatus == "OUT")
{
jo.CargoStatus = "SHIPMENT";
}
else if (jo.CargoStatus == "SHIPMENT")
{
jo.CargoStatus = "DEPARTURE";
}
string role = EzshipHelper.GetUseRole();
if (role == "Admin")
{
if (jo.CargoStatus == "DEPARTURE")
{
jo.CargoStatus = "GR";
}
if (jo.CargoStatus == "GR")
{
jo.CargoStatus = "DO";
}
else if (jo.CargoStatus == "DO")
{
jo.CargoStatus = "SEND";
}
else if (jo.CargoStatus == "PICKED")
{
jo.CargoStatus = "OUT";
}
else if (jo.CargoStatus == "SEND")
{
jo.CargoStatus = "COMPLETED";
}
}
C2.Manager.ORManager.StartTracking(jo, Wilson.ORMapper.InitialState.Updated);
C2.Manager.ORManager.PersistChanges(jo);
L.Audit(jo.CargoStatus, "DJ", jo.Id.ToString(), "", "", "");
}
catch (Exception ex)
{ throw new Exception(ex.Message); }
}
