public int Delete(SysAddresserInfo entity)
{
try
{
Object result = baseDao.Delete <SysAddresserInfo>(entity);
int iReturn = Convert.ToInt32(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用ActivityDirectRules时，访问Delete时出错", ex);
}
}
public long Insert(SysAddresserInfo entity)
{
try
{
Object result = baseDao.Insert <SysAddresserInfo>(entity);
long iReturn = Convert.ToInt64(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用ActivityDirectRules时，访问Update时出错", ex);
}
}
public string AddOrderInfo(string username, SysOrderInfo orderinfo, SysAddresserInfo addresserinfo,
SysReceiverInfo receiverinfo, ref int status)
{
var param = new StatementParameterCollection();
param.AddInParameter("@OrderNo", DbType.AnsiString, orderinfo.OrderNo);
param.AddInParameter("@ShipperName", DbType.String, orderinfo.ShipperName);
param.AddInParameter("@ShipperPhone", DbType.AnsiString, orderinfo.ShipperPhone);
param.AddInParameter("@UserName", DbType.AnsiString, username);
param.AddInParameter("@PickupNumber", DbType.Int32, orderinfo.PickupNumber);
param.AddInParameter("@Status", DbType.Int32, orderinfo.Status);
param.AddInParameter("@LogisticsSingle", DbType.AnsiString, addresserinfo.LogisticsSingle);
param.AddInParameter("@RussiaCityId", DbType.Int64, addresserinfo.RussiaCityId);
param.AddInParameter("@RussiaAddress", DbType.String, addresserinfo.RussiaAddress);
param.AddInParameter("@CargoNumber", DbType.Int32, addresserinfo.CargoNumber);
param.AddInParameter("@PickupDate", DbType.DateTime, addresserinfo.PickupDate);
param.AddInParameter("@PickupWay", DbType.Int32, addresserinfo.PickupWay);
param.AddInParameter("@GoodsType", DbType.Int32, addresserinfo.GoodsType);
param.AddInParameter("@TransportationWay", DbType.AnsiString, addresserinfo.TransportationWay);
param.AddInParameter("@ProtectPrice", DbType.Decimal, addresserinfo.ProtectPrice);
param.AddInParameter("@PolicyFee", DbType.Decimal, addresserinfo.PolicyFee);
param.AddInParameter("@GoodsWeight", DbType.Decimal, addresserinfo.GoodsWeight);
param.AddInParameter("@BoxLong", DbType.Decimal, addresserinfo.BoxLong);
param.AddInParameter("@BoxWidth", DbType.Decimal, addresserinfo.BoxWidth);
param.AddInParameter("@BoxHeight", DbType.Decimal, addresserinfo.BoxHeight);
param.AddInParameter("@ParcelSingle", DbType.AnsiString, receiverinfo.ParcelSingle);
param.AddInParameter("@ChinaCityId", DbType.Int64, receiverinfo.ChinaCityId);
param.AddInParameter("@ChinaAddress", DbType.String, receiverinfo.ChinaAddress);
param.AddInParameter("@ReceiverName", DbType.String, receiverinfo.ReceiverName);
param.AddInParameter("@ReceiverPhone", DbType.AnsiString, receiverinfo.ReceiverPhone);
param.AddInParameter("@PackagingWay", DbType.Int32, receiverinfo.PackagingWay);
param.AddInParameter("@ExpressWay", DbType.Int32, receiverinfo.ExpressWay);
param.AddInParameter("@GoodsDesc", DbType.String, receiverinfo.GoodsDesc);
param.AddInParameter("@ParcelWeight", DbType.Decimal, receiverinfo.ParcelWeight);
param.AddInParameter("@ChinaCourierNumber", DbType.AnsiString, receiverinfo.ChinaCourierNumber);
param.AddInParameter("@Desc", DbType.String, receiverinfo.Desc);
param.AddOutParameter("@result", DbType.String, 100);
param.AddParameter("@message", DbType.Int32, 0, 32, ParameterDirection.ReturnValue);
var s = baseDao.VisitDataReaderBySp <object>("CreateOrder_Proc", param, x =>
{
return(x);
});
status = Convert.ToInt32(param["@message"].Value);
return(param[31].Value.ToString());
}
public string AddOrderInfo(string username, SysOrderInfo orderinfo, SysAddresserInfo addresserinfo,
SysReceiverInfo receiverinfo, ref int status)
{
return(orderDao.AddOrderInfo(username, orderinfo, addresserinfo, receiverinfo, ref status));
}
public int UpdateAddressInfo(SysAddresserInfo entity)
{
return(addresserInfoDao.Update(entity));
}
public ActionResult CreateOrder(string ordersingle, string shappername, string shipperphone, string pickupnumber, string russiacityid, string russiaaddress, string logisticsSingle, string cargonumber, string pickupdate, string pickupWay, string goodstype, string transportationway, string protectprice, string policyfee, string goodsweight, string boxlong, string boxwidth, string boxheight, string parcelsingle, string chinacityid, string chinaaddress, string receivername, string receiverphone, string packagingway, string expressway, string goodsdesc, string parcelweight, string chinacouriernumber, string desc)
{
var result = new ResponseJsonResult <string>();
result.Status = 0;
result.Message = "未知错误";
var username = User.Identity.Name;
var userProvider = new UserLoginProvider();
var _user = userProvider.GetUser(username);
if (_user != null)
{
var cusmer = UserService.GetCustomerByUid(_user.Id);
if (cusmer != null && !string.IsNullOrEmpty(_user.DisplayName) && !string.IsNullOrEmpty(_user.Phone))
{
var orderinfo = new SysOrderInfo();
orderinfo.OrderNo = ordersingle.Trim();
orderinfo.PickupNumber = Convert.ToInt32(pickupnumber);
orderinfo.ShipperName = shappername.Trim();
orderinfo.ShipperPhone = shipperphone.Trim();
orderinfo.Status = (int)OrderStatusEnum.Processing;
var addresserInfo = new SysAddresserInfo();
addresserInfo.BoxHeight = Convert.ToDecimal(boxheight);
addresserInfo.BoxWidth = Convert.ToDecimal(boxwidth);
addresserInfo.BoxLong = Convert.ToDecimal(boxlong);
addresserInfo.GoodsWeight = Convert.ToDecimal(goodsweight);
addresserInfo.PolicyFee = Convert.ToDecimal(policyfee);
addresserInfo.ProtectPrice = Convert.ToDecimal(protectprice);
addresserInfo.TransportationWay = Convert.ToInt32(transportationway);
addresserInfo.GoodsType = Convert.ToInt32(goodstype);
addresserInfo.PickupWay = Convert.ToInt32(pickupWay);
addresserInfo.PickupDate = Convert.ToDateTime(pickupdate);
addresserInfo.CargoNumber = Convert.ToInt32(cargonumber);
addresserInfo.LogisticsSingle = logisticsSingle.Trim();
addresserInfo.RussiaAddress = russiaaddress.Trim();
addresserInfo.RussiaCityId = Convert.ToInt64(russiacityid);
var receiverInfo = new SysReceiverInfo();
receiverInfo.ParcelSingle = parcelsingle.Trim();
receiverInfo.ChinaCityId = Convert.ToInt64(chinacityid);
receiverInfo.ChinaAddress = chinaaddress.Trim();
receiverInfo.ReceiverName = receivername.Trim();
receiverInfo.ReceiverPhone = receiverphone.Trim();
receiverInfo.PackagingWay = Convert.ToInt32(packagingway);
receiverInfo.ExpressWay = Convert.ToInt32(expressway);
receiverInfo.GoodsDesc = goodsdesc.Trim();
receiverInfo.ParcelWeight = Convert.ToDecimal(parcelweight);
receiverInfo.ChinaCourierNumber = chinacouriernumber.Trim();
receiverInfo.Desc = desc.Trim();
var status = 0;
var provider = new OrderInfoProvider();
var message = provider.AddOrderInfo(username, orderinfo, addresserInfo, receiverInfo, ref status);
if (status == 1)
{
result.Status = 1;
if (!string.IsNullOrEmpty(addresserInfo.LogisticsSingle))
{
var logistics = new SysLogisticsInfo();
logistics.LogisticsDesc = "订单处理中";
logistics.LogisticsSingle = addresserInfo.LogisticsSingle;
logistics.Status = false;
logistics.UpdateDate = DateTime.Now;
logistics.CreateDate = DateTime.Now;
logistics.IsDelete = false;
ISysLogisticsInfoRepository logisticsInfo = DALFactory.SysLogisticsInfoDao;
logisticsInfo.Insert(logistics);
}
}
result.Message = message;
}
}
else
{
result.Message = "客户信息不完整，暂时不能下单";
}
return(Json(result));
}
