protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次Id
string strShipId = Request.Params["ShipId"];
//船舶Id
string strV_Id = Request.Params["V_Id"];
//箱号
string strContainerNo = Request.Params["ContainerNo"];
//目标贝号
string strEndBayno = Request.Params["EndBayno"];
//用户ID
string strUserId = Request.Params["UserId"];
//strShipId = "195";
//strV_Id = "6321";
//strContainerNo = "CXDU2283528";
//strEndBayno = "050304";
//strUserId = "215";
AppLog log = new AppLog(Request);
log.strBehavior = "移贝";
log.strBehaviorURL = "/Move/MoveBay.aspx";
log.strAccount = strUserId;
try
{
if (strShipId == null || strV_Id == null || strContainerNo == null || strEndBayno == null || strUserId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，移贝失败！").DicInfo());
log.LogCatalogFailure(string.Format("参数错误，移贝失败"));
return;
}
da.BeginTransaction();
IMoveBay iMoveBay = new IMoveBay(log);
iMoveBay.setDataAccess(da);
//校验目标贝位号是否存在
if (!iMoveBay.isExistBayno(strV_Id, strEndBayno))
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "错误贝位号").DicInfo());
log.LogCatalogFailure(string.Format("错误贝位号"));
return;
}
string strOperareName = string.Empty;
string strSql = string.Format(@"select distinct name
from SYSTEM_USER_TABLE
where user_id='{0}'",
strUserId);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strOperareName = Convert.ToString(dt.Rows[0]["name"]);
}
//获取待移集装箱信息
strSql =
string.Format(@"select size_con,bayno
from con_image
where container_no='{0}' and ship_id={1}",
strContainerNo, strShipId);
dt = da.ExecuteTable(strSql);
if (dt.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "待移集装箱号不存在").DicInfo());
log.LogCatalogFailure(string.Format("待移集装箱号不存在"));
return;
}
if (Convert.ToInt16(dt.Rows[0]["size_con"]) == 20)
{
Json = iMoveBay.MoveBayOfTwenty(strShipId, strContainerNo, Convert.ToString(dt.Rows[0]["bayno"]), strEndBayno, strOperareName);
}
else
{
Json = iMoveBay.MoveBayOfForty(strShipId, strContainerNo, Convert.ToString(dt.Rows[0]["bayno"]), strEndBayno, strOperareName);
}
if (Json != null)
{
return;
}
da.CommitTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "上传成功！").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
da.RollbackTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：移贝发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：移贝发生异常。{1}", ex.Source, ex.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
//身份校验
if (!InterfaceTool.IdentityVerify(Request))
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "身份认证错误！").DicInfo());
return;
}
//航次Id
string strShipId = Request.Params["ShipId"];
//船舶Id
string strV_Id = Request.Params["V_Id"];
//箱号1
string strContainerNo1 = Request.Params["ContainerNo1"];
//箱号2
string strContainerNo2 = Request.Params["ContainerNo2"];
//目标贝号
string strEndBayno = Request.Params["EndBayno"];
//用户ID
string strUserId = Request.Params["UserId"];
//strShipId = "195";
//strV_Id = "6321";
////strContainerNo1 = "FCIU4708678";
//strContainerNo1 = "ZGXU2382004";
//strContainerNo2 = "CXDU2375239";
//strEndBayno = "090484";
//strUserId = "215";
AppLog log = new AppLog(Request);
log.strBehavior = "双吊";
log.strBehaviorURL = "/Move/DoubleLift.aspx";
log.strAccount = strUserId;
try
{
if (strShipId == null || strV_Id == null || strContainerNo1 == null || strContainerNo2 == null || strEndBayno == null || strUserId == null)
{
Json = JsonConvert.SerializeObject(new DicPackage(false, null, "参数错误，双吊失败！").DicInfo());
return;
}
da.BeginTransaction();
IMoveBay iMoveBay = new IMoveBay(log);
iMoveBay.setDataAccess(da);
//校验目标贝位号是否存在
if (!iMoveBay.isExistBayno(strV_Id, strEndBayno))
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "错误贝位号").DicInfo());
log.LogCatalogFailure(string.Format("错误贝位号"));
return;
}
//后通目标贝位号
String backEndBayno = Convert.ToString((Convert.ToInt16(strEndBayno.Substring(0, 2)) + 2)).PadLeft(2, '0') + strEndBayno.Substring(2).PadLeft(4, '0');
//校验后通目标贝位号是否存在
if (!iMoveBay.isExistBayno(strV_Id, backEndBayno))
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, Convert.ToString(strEndBayno.Substring(0, 2)) + "贝不通贝").DicInfo());
log.LogCatalogFailure(string.Format(Convert.ToString(strEndBayno.Substring(0, 2)) + "贝不通贝"));
return;
}
string strOperareName = string.Empty;
string strSql = string.Format(@"select distinct name
from SYSTEM_USER_TABLE
where user_id='{0}'",
strUserId);
var dt = new Leo.SqlServer.DataAccess(RegistryKey.KeyPathTallySqlServer).ExecuteTable(strSql);
if (dt.Rows.Count > 0)
{
strOperareName = Convert.ToString(dt.Rows[0]["name"]);
}
//获取待移集装箱信息
strSql =
string.Format(@"select size_con,bayno
from con_image
where container_no='{0}' and ship_id={1}",
strContainerNo1, strShipId);
var dt1 = da.ExecuteTable(strSql);
if (dt1.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "待调集装箱号不存在").DicInfo());
log.LogCatalogFailure(string.Format("待调集装箱号不存在"));
return;
}
strSql =
string.Format(@"select size_con,bayno
from con_image
where container_no='{0}' and ship_id={1}",
strContainerNo2, strShipId);
var dt2 = da.ExecuteTable(strSql);
if (dt2.Rows.Count <= 0)
{
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "待调集装箱号不存在").DicInfo());
log.LogCatalogFailure(string.Format("待调集装箱号不存在"));
return;
}
Json = iMoveBay.DoubleLift(strShipId, strContainerNo1, Convert.ToString(dt1.Rows[0]["bayno"]), strContainerNo2, Convert.ToString(dt2.Rows[0]["bayno"]), strEndBayno, strOperareName);
if (Json != null)
{
return;
}
da.CommitTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(true, null, "上传成功！").DicInfo());
log.LogCatalogSuccess();
}
catch (Exception ex)
{
da.RollbackTransaction();
Json = JsonConvert.SerializeObject(new DicPackage(false, null, string.Format("{0}：双吊发生异常。{1}", ex.Source, ex.Message)).DicInfo());
log.LogCatalogFailure(string.Format("{0}：双吊发生异常。{1}", ex.Source, ex.Message));
}
}
