public JsonResult Index(string loginid, string loginpw, string mIP, string CoID, string macAddr)
{
if (mIP.Length < 9)
{
mIP = "127.0.0.1";
}
macAddr = macAddr.Split('|')[0];
TransportResultSet transportResultSet = new TransportResultSet();
if (loginid != "" && loginid != null && loginpw != "" && loginpw != null)
{
if ((Authenticate(loginid, loginpw, CoID, macAddr, mIP)) == false)
{
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "로그인 할수 없습니다.";
}
else
{
//FormsAuthentication.SetAuthCookie(loginid, false);
transportResultSet.Message = "";
transportResultSet.Code = ResultCodeEnum.OK;
}
}
else
{
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "입력값이 올바르지 않습니다.";
}
return Json(transportResultSet);
}
/// <summary>
/// 반품및 G마켓 해외배송 판별(Core 도착확인 수정포함)
/// </summary>
/// <param name="orderNum">주문번호(체결번호)</param>
/// <returns> 0 : 정상 , 1 : 취소/반품, 2 : G마켓 해외배송, -11 : 에러</returns>
public TransportResultSet CheckCoreTranseportState(int contrNo)
{
TransportResultSet result = new TransportResultSet();
TransportClaimInfoT transportClaimInfoT = new TransportGMKTCoreDac().TransportClaimInfo(contrNo);
if (transportClaimInfoT != null)
{
if (transportClaimInfoT.ClaimSolStat != "S4" && (transportClaimInfoT.ClaimType == "CR" || transportClaimInfoT.ClaimType == "CO"))
{
result.KeyValue = contrNo.ToString();
result.Code = ResultCodeEnum.Error;
result.Message = "반품/취소된 상품 입니다.";
return result;
}
else if (transportClaimInfoT.IsChange == "Y" || transportClaimInfoT.IsCancel == "Y")
{
result.KeyValue = contrNo.ToString();
result.Code = ResultCodeEnum.Error;
result.Message = "반품/취소된 상품 입니다.";
return result;
}
else if ( !String.IsNullOrEmpty(transportClaimInfoT.OverSeaBundleNO) )
{
result.KeyValue = contrNo.ToString();
result.Code = ResultCodeEnum.Error;
result.Message = "G마켓 해외배송 상품입니다.";
return result;
}
else
{
result.KeyValue = contrNo.ToString();
result.Code = ResultCodeEnum.OK;
result.Message = "";
return result;
}
}
else
{
result.KeyValue = contrNo.ToString();
result.Code = ResultCodeEnum.Error;
result.Message = "배송정보가 존재하지 않습니다.";
return result;
}
}
/// <summary>
/// 도착 확인 스캔
/// </summary>
/// <param name="scanNumber">송장번호</param>
/// <param name="userID">사용자 아이디</param>
/// <returns>스캔 결과</returns>
public TransportResultSet ArriveScan(int scanNumber, string userID)
{
TransportResultSet transportResultSet = new TransportResultSet();
GepWarehouse gepWarehouse = new TransportGepWarehouseDac().FindOne(scanNumber);
if (gepWarehouse == null)
{
gepWarehouse = new GepWarehouse();
gepWarehouse.contr_no = scanNumber;
gepWarehouse.state = WarehouseStateEnum.Arrival;
gepWarehouse.arrived_dt = DateTime.Now;
gepWarehouse.arrived_id = userID;
gepWarehouse.isCanceled = false;
gepWarehouse.label_print_dt = DateTime.Now;
gepWarehouse.label_print_id = userID;
}
else if (gepWarehouse.state == WarehouseStateEnum.Arrival)
{
transportResultSet.KeyValue = scanNumber.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "이미 도착확인된 상품입니다.";
return transportResultSet;
}
else if (gepWarehouse.state != WarehouseStateEnum.Ready)
{
transportResultSet.KeyValue = scanNumber.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = String.Format("이미 처리된 상품입니다.\n (상태: {0})", gepWarehouse.state);
return transportResultSet;
}
//배송상태 체크
transportResultSet = new TransportCommonBiz().CheckCoreTranseportState(scanNumber);
if (ResultCodeEnum.Error == transportResultSet.Code)
return transportResultSet;
/*
//2012.04.14 jdkim SetGepWarehouseFromOrderData()로 변경
//주문정보 및 국내배송정보조회
GepTransInfo gepTransInfo = new TransportCommonBiz().GetGepTransInfoData(scanNumber, ref gepWarehouse);
if (gepTransInfo == null)
{
transportResultSet.KeyValue = scanNumber.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "Gep 배송 정보가 없습니다.";
return transportResultSet;
}
*/
transportResultSet = new TransportCommonBiz().SetGepWarehouseFromOrderData(scanNumber.ToString(), userID, ref gepWarehouse);
if (ResultCodeEnum.OK != transportResultSet.Code)
return transportResultSet;
//Warehouse 저장
new TransportGepWarehouseDac().Save(gepWarehouse);
//상태변경
if (!new TransportCommonBiz().SetTransportState(scanNumber, WarehouseStateEnum.Arrival, userID))
{
transportResultSet.KeyValue = scanNumber.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "gopm상태값 변경에 문제가 있습니다.";
return transportResultSet;
}
//국내 배송완료
TransportD4UpdateT transportD4UpdateT = new TransportCommonBiz().TransportD4Update(scanNumber, userID, "S", "GEP국내배송처리", "N");
if (transportD4UpdateT.Error != 0)
{
transportResultSet.KeyValue = scanNumber.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "국내배송 도착확인 처리에 문제가 있습니다.";
//Result.Message = D4Data.RetMsg;
return transportResultSet;
}
transportResultSet.KeyValue = scanNumber.ToString();
transportResultSet.Code = ResultCodeEnum.OK;
transportResultSet.Message = "";
return transportResultSet;
}
/// <summary>
/// 무게 수신 정보 저장
/// </summary>
/// <param name="contrNo">체결번호</param>
/// <param name="scanWeight">무게</param>
/// <param name="userID">사용자 아이디</param>
/// <returns>무게 수신 결과</returns>
public TransportResultSet SetDeliveryReadyWeightSave(int contrNo, int scanWeight, string userID)
{
TransportResultSet transportResultSet = new TransportResultSet();
transportResultSet.KeyValue = contrNo.ToString();
GepWarehouse gepWarehouse = new TransportGepWarehouseDac().FindOne(contrNo);
if (gepWarehouse == null)
{
transportResultSet.KeyValue = contrNo.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "GEP 물류센터정보에 등록되어 있지 않는 건입니다.";
return transportResultSet;
}
if (gepWarehouse.state != WarehouseStateEnum.Arrival && gepWarehouse.state != WarehouseStateEnum.PackingBox)
{
transportResultSet.KeyValue = contrNo.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "상품 상태값이 배송준비 스캔할 수 없는 상태입니다.";
return transportResultSet;
}
var tw = (from t in gepWarehouse.trans_way_hist
orderby t.reg_dt descending
select t).ToList();
int Cost = new TransportCommonBiz().GetTransportCostForWeight(scanWeight,
gepWarehouse.sitetransinfo.sender_iso_country_code,
gepWarehouse.sitetransinfo.receiver_iso_country_code,
gepWarehouse.sitetransinfo.trans_way,
ShippingRateTypeEnum.GmktToExpress);
if (Cost == 0)
{
transportResultSet.KeyValue = contrNo.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "배송비 계산에 문제가 있습니다.";
return transportResultSet;
}
gepWarehouse.trns_cost.real_weight = scanWeight;
gepWarehouse.trns_cost.real_transport_cost = Cost;
gepWarehouse.trns_cost.reg_dt = DateTime.Now;
gepWarehouse.trns_cost.reg_id = userID;
gepWarehouse.check_weight_dt = DateTime.Now;
gepWarehouse.check_weight_id = userID;
//new TransportGepWarehouseDac().Save(gepWarehouse);
//if (!new TransportCommonBiz().SetTransportState(contrNo, WarehouseStateEnum.PackingBox, userID))
//{
// transportResultSet.KeyValue = contrNo.ToString();
// transportResultSet.Code = ResultCodeEnum.Error;
// transportResultSet.Message = "gopm상태값 변경에 문제가 있습니다.";
// return transportResultSet;
//}
if (false == new TransportCommonBiz().SetTransportState(ref gepWarehouse, WarehouseStateEnum.PackingBox, userID))
{
transportResultSet.KeyValue = contrNo.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "gopm상태값 변경에 문제가 있습니다.";
return transportResultSet;
}
//상태변경하고 저장
new TransportGepWarehouseDac().Save(gepWarehouse);
//실측무게 배송비 전달용
transportResultSet.KeyValue = Cost.ToString();
if (scanWeight > 2000)
{
transportResultSet.Code = ResultCodeEnum.MustChagneEMS;
transportResultSet.Message = "EMS로 전환 요청";
}
else
{
transportResultSet.Code = ResultCodeEnum.OK;
transportResultSet.Message = "";
//gep 무게 업데이트
new TransportCommonBiz().SetGepItemWeight(gepWarehouse.transinfo.gep_item_id.ToString(), scanWeight);
}
return transportResultSet;
}
/// <summary>
/// 배송대기 스캔
/// </summary>
/// <param name="scanValue">체결번호</param>
/// <param name="userID">사용자 아이디</param>
/// <returns>스캔 결과</returns>
public TransportResultSet SetDeliveryReadyWaitScan(int scanValue, string userID)
{
TransportResultSet transportResultSet = new TransportResultSet();
transportResultSet.KeyValue = scanValue.ToString();
GepWarehouse gepWarehouse = new TransportGepWarehouseDac().FindOne(scanValue);
if (gepWarehouse == null)
{
transportResultSet = new TransportCommonBiz().CheckCoreTranseportState(scanValue);
if (0 < transportResultSet.Message.IndexOf("해외배송"))
{
return transportResultSet;
}
else
{
transportResultSet.KeyValue = scanValue.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "GEP 물류센터정보에 등록되어 있지 않는 건입니다.";
return transportResultSet;
}
}
var q = (from t in gepWarehouse.trans_way_hist
orderby t.reg_dt descending
select t).ToList();
if (q[0].transport_way != "SP" && q[0].transport_way != "RR")
{
transportResultSet.Message = "GEP-EMS 해외배송건 입니다.";
transportResultSet.Code = ResultCodeEnum.Error;
return transportResultSet;
}
if (gepWarehouse.state != WarehouseStateEnum.PackingBox && gepWarehouse.state != WarehouseStateEnum.Submitting)
{
transportResultSet.KeyValue = scanValue.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "상품 상태값이 배송대기 스캔할 수 없는 상태입니다.";
return transportResultSet;
}
//배송상태 체크
transportResultSet = new TransportCommonBiz().CheckCoreTranseportState(scanValue);
if (ResultCodeEnum.Error == transportResultSet.Code)
return transportResultSet;
transportResultSet.Code = ResultCodeEnum.OK;
transportResultSet.Message = "";
return transportResultSet;
}
/// <summary>
/// 배송준비 스캔
/// </summary>
/// <param name="scanValue">송장번호</param>
/// <returns>스캔 결과</returns>
public TransportResultSet SetDeliveryReadyScan(int scanValue)
{
TransportResultSet transportResultSet = new TransportResultSet();
transportResultSet.KeyValue = scanValue.ToString();
GepWarehouse gepWarehouse = new TransportGepWarehouseDac().FindOne(scanValue);
if (gepWarehouse == null)
{
transportResultSet = new TransportCommonBiz().CheckCoreTranseportState(scanValue);
if (0 < transportResultSet.Message.IndexOf("해외배송"))
{
return transportResultSet;
}
else
{
transportResultSet.KeyValue = scanValue.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "GEP 물류센터정보에 등록되어 있지 않는 건입니다.";
return transportResultSet;
}
}
if (gepWarehouse.state != WarehouseStateEnum.Arrival && gepWarehouse.state != WarehouseStateEnum.PackingBox)
{
transportResultSet.KeyValue = scanValue.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "상품 상태값이 배송준비 스캔할 수 없는 상태입니다.";
return transportResultSet;
}
if (gepWarehouse.trans_way_hist == null)
{
transportResultSet.Message = "상품 배송 방법 정보가 없습니다";
transportResultSet.Code = ResultCodeEnum.Error;
return transportResultSet;
}
var q = (from t in gepWarehouse.trans_way_hist
orderby t.reg_dt descending
select t).ToList();
if(q.Count == 0)
{
transportResultSet.Message = "상품 배송 방법 정보가 없습니다";
transportResultSet.Code = ResultCodeEnum.Error;
return transportResultSet;
}
string transWayCode = new TransportCommonBiz().GetTransWayCode(q[0].transport_way);
if (transWayCode != "SP" && transWayCode != "RR")
{
transportResultSet.Message = "GEP-EMS 해외배송건 입니다.";
transportResultSet.Code = ResultCodeEnum.Error;
return transportResultSet;
}
//배송상태 체크
transportResultSet = new TransportCommonBiz().CheckCoreTranseportState(scanValue);
if (ResultCodeEnum.Error == transportResultSet.Code)
return transportResultSet;
transportResultSet.Message = "";
transportResultSet.Code = ResultCodeEnum.OK;
return transportResultSet;
}
/// <summary>
/// GepWarehouse 정보를 gep 통합주문정보와 gmkt주문정보에서 가져온다.
/// </summary>
/// <param name="scanValue"></param>
/// <param name="userID"></param>
/// <param name="gepWarehouse"></param>
/// <returns></returns>
public TransportResultSet SetGepWarehouseFromOrderData(string scanValue, string userID, ref GepWarehouse gepWarehouse)
{
TransportResultSet result = new TransportResultSet();
result.KeyValue = scanValue;
result.Code = ResultCodeEnum.OK;
result.Message = "";
//gmkt 에서 데이터 가져오기
OrderInfoT gmktOrder = new TransportGMKTCoreDac().OrderInfo(Util.GetSafeInt(scanValue));
if (null == gmktOrder)
{
result.KeyValue = scanValue;
result.Code = ResultCodeEnum.Error;
result.Message = "G마켓 주문 정보가 없습니다.";
return result;
}
//GEP 에서 데이터 가져오기
GEPOrderInfoT gepOrder = new GEPOrderDac().GetGEPOrderInfo(Query.EQ("GMKTOrder.ContrNo", Util.GetSafeInt(scanValue)));
if (null == gepOrder)
{
result.KeyValue = scanValue;
result.Code = ResultCodeEnum.Error;
result.Message = "GEP 통합주문 정보가 없습니다.";
return result;
}
if (String.IsNullOrEmpty(gepOrder.ExportSiteTrans.trans_way) || "0" == gepOrder.ExportSiteTrans.trans_way)
{
result.KeyValue = scanValue;
result.Code = ResultCodeEnum.Error;
result.Message = "GEP 통합주문 정보에 Site배송방법이 없습니다.";
return result;
}
//라벨출력일
gepWarehouse.gsm_label_print_dt = gmktOrder.LabelPrintDt;
gepWarehouse.gsm_label_print_id = gmktOrder.SellerId;
if (null == gepWarehouse.transinfo)
gepWarehouse.transinfo = new GepTransInfo();
gepWarehouse.transinfo.contr_no = Util.GetSafeInt(scanValue);
//Gep통합주문정보 --> TransInfo
//Gep통합주문정보 --> item 정보
CovertTo(gepOrder, ref gepWarehouse.transinfo);
//gmkt주문정보 --> TransInfo
CovertTo(gmktOrder, ref gepWarehouse.transinfo);
gepWarehouse.transinfo.chg_dt = DateTime.Now;
gepWarehouse.transinfo.chg_id = userID;
//Gep통합주문정보 --> GEP에 배송방법
gepWarehouse.transinfo.trans_way = new TransportCommonBiz().GetTransWayInfo(gepOrder.ExportSiteTrans.trans_way);
gepWarehouse.transinfo.trans_way.reg_dt = DateTime.Now;
gepWarehouse.transinfo.trans_way.reg_id = userID;
//GOPM 배송방법 이력
if (null == gepWarehouse.trans_way_hist)
gepWarehouse.trans_way_hist = new List<GepTransWay>();
gepWarehouse.trans_way_hist.Add(gepWarehouse.transinfo.trans_way);
//사이트 주문일로부터 5일이상 경과 시 배송방법 EMS전환
if ((gepWarehouse.transinfo.gep_payment_dt.AddDays(5)) < DateTime.Now
&& gepWarehouse.transinfo.trans_way.transport_way != "EMS")
{
GepTransWay gepTransWay = new TransportCommonBiz().GetTransWayInfo("EMS");
gepTransWay.reg_dt = DateTime.Now.AddSeconds(1);
gepTransWay.reg_id = userID;
gepTransWay.transport_way = "EMS-2";
gepWarehouse.trans_way_hist.Add(gepTransWay);
gepWarehouse.transinfo.trans_way = gepTransWay;
}
//사이트 배송지 정보
if (gepOrder.ExportSiteTrans == null)
{
result.KeyValue = scanValue;
result.Code = ResultCodeEnum.Error;
result.Message = "GEP 사이트별 가변 배송정보가 없습니다.";
return result;
}
gepWarehouse.sitetransinfo = gepOrder.ExportSiteTrans;
//보내는 사람 주소
//사이트별 배송지 정보
TaInfo ta = new TaInfoBiz().FindTaUser(gmktOrder.BuyerId);
if (ta == null)
{
result.KeyValue = gmktOrder.BuyerId;
result.Code = ResultCodeEnum.Error;
result.Message = "TA 사용자 정보가 없습니다.";
return result;
}
ConvertTo(ta, ref gepWarehouse.sitetransinfo);
//발송인 국가 전화번호
if ("KR" != gepWarehouse.sitetransinfo.sender_iso_country_code)
gepWarehouse.sitetransinfo.sender_country_code = new TransportCommonBiz().GetNationPhoneNo(gepWarehouse.sitetransinfo.sender_iso_country_code);
//수취인 국가 전화번호
gepWarehouse.sitetransinfo.receiver_country_code = new TransportCommonBiz().GetNationPhoneNo(gepWarehouse.sitetransinfo.receiver_iso_country_code);
//예상무게
if (0 < Util.GetSafeLong(gepOrder.Item.gep_id))
{
gepWarehouse.trns_cost = new TransportCommonBiz().GetTransportCostForOrigin(Util.GetSafeLong(gepOrder.Item.gep_id)
, gepWarehouse.transinfo.clone_item_no
, ""
, gepWarehouse.sitetransinfo.sender_iso_country_code
, gepWarehouse.sitetransinfo.receiver_iso_country_code
, gepWarehouse.sitetransinfo.trans_way
, userID
, ShippingRateTypeEnum.GmktToExpress);
}
else
{
gepWarehouse.trns_cost = new TransportCommonBiz().GetTransportCostForOrigin(gepWarehouse.transinfo.clone_item_no
, ""
, gepWarehouse.sitetransinfo.sender_iso_country_code
, gepWarehouse.sitetransinfo.receiver_iso_country_code
, gepWarehouse.sitetransinfo.trans_way
, userID
, ShippingRateTypeEnum.GmktToExpress);
}
//상품 영문명
GepItemsData gepitem = new GepItemsBiz().GepItemView(gepWarehouse.transinfo.gep_item_id.ToString());
if ( !String.IsNullOrEmpty(gepitem.src_info.mcategory.cid) )
{
CategoryGmktEngInfoT category = GetGmktMiddleCategoryEngName(gepitem.src_info.mcategory.cid);
if (null != category && !String.IsNullOrEmpty(category.EngName))
gepWarehouse.transinfo.gep_mcategory_ename = category.EngName;
if ( !String.IsNullOrEmpty(gepitem.src_info.eng_name) )
gepWarehouse.transinfo.gep_item_ename = gepitem.src_info.eng_name;
}
return result;
}
/// <summary>
/// 배송대기 스캔
/// </summary>
/// <param name="scanValue">송장번호</param>
/// <param name="userID">사용자 아이디</param>
/// <returns>스캔 결과</returns>
public TransportResultSet SetDeliveryReadyWaitScan(int scanValue, string userID)
{
TransportResultSet transportResultSet = new TransportResultSet();
transportResultSet.KeyValue = scanValue.ToString();
GepWarehouse gepWarehouse = new TransportGepWarehouseDac().FindOne(scanValue);
if (gepWarehouse == null)
{
transportResultSet = new TransportCommonBiz().CheckCoreTranseportState(scanValue);
if (0 < transportResultSet.Message.IndexOf("해외배송"))
{
return transportResultSet;
}
else
{
transportResultSet.KeyValue = scanValue.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "GEP 물류센터정보에 등록되어 있지 않는 건입니다.";
return transportResultSet;
}
}
var q = (from t in gepWarehouse.trans_way_hist
orderby t.reg_dt descending
select t).ToList();
if (q.Count == 0)
{
transportResultSet.Message = "상품 배송 방법 정보가 없습니다";
transportResultSet.Code = ResultCodeEnum.Error;
return transportResultSet;
}
if (q[0].transport_way.IndexOf("EMS") < 0)
{
transportResultSet.Message = "항공소형포장건 입니다.";
transportResultSet.Code = ResultCodeEnum.Error;
return transportResultSet;
}
if (gepWarehouse.state != WarehouseStateEnum.PackingBox && gepWarehouse.state != WarehouseStateEnum.Submitting)
{
transportResultSet.KeyValue = scanValue.ToString();
transportResultSet.Code = ResultCodeEnum.Error;
transportResultSet.Message = "상품 상태값이 배송대기 스캔할 수 없는 상태입니다.";
return transportResultSet;
}
//int CheckResult = new TransportCommonBiz().CheckCoreTranseportState(gepWarehouse.contr_no);
//int TranseportCheck = new TransportCommonBiz().CheckCoreTranseportState(scanValue);
//if (TranseportCheck == 1)
//{
// transportResultSet.KeyValue = scanValue.ToString();
// transportResultSet.Code = ResultCodeEnum.Error;
// transportResultSet.Message = "반품된 상품 입니다.";
// return transportResultSet;
//}
//if (TranseportCheck == -11)
//{
// transportResultSet.KeyValue = scanValue.ToString();
// transportResultSet.Code = ResultCodeEnum.Error;
// transportResultSet.Message = "G마켓 해외배송 상품입니다.";
// return transportResultSet;
//}
//if (TranseportCheck < 0)
//{
// transportResultSet.KeyValue = scanValue.ToString();
// transportResultSet.Code = ResultCodeEnum.Error;
// transportResultSet.Message = "에러 입니다.";
// return transportResultSet;
//}
//배송상태 체크
transportResultSet = new TransportCommonBiz().CheckCoreTranseportState(scanValue);
if (ResultCodeEnum.Error == transportResultSet.Code)
return transportResultSet;
transportResultSet.Code = ResultCodeEnum.OK;
transportResultSet.Message = "";
return transportResultSet;
}
