public ActionResult AddReceiveTransportPoint(int?synchroReceiveAddressId)
{
AddReceiveTransportPointModel model = new AddReceiveTransportPointModel();
if (synchroReceiveAddressId.HasValue)//如果是通过同步收货地址打开的新增收货地址界面，那么会有通过接口过来的待同步地址ID
{
var result = MGJH_TransportPointBLL.GetSynchroReceivePointByID(synchroReceiveAddressId.Value);
if (result.DataResult == null)
{
return(Content(result.Message));
}
var tempModel = result.DataResult;
model.AddressName = tempModel.AddressName;
model.CustomerName = tempModel.CustomerName;
model.AddressArea = tempModel.AddressArea;
model.AddressCode = tempModel.AddressCode;
model.SourceID = synchroReceiveAddressId;
}
//AddReceiveTransportPointModel model = new AddReceiveTransportPointModel();
//在查询出的收货地址前面加上一条记录--表示无上级收货地址
List <SuperiorAddressModel> superiorAddress = new List <SuperiorAddressModel>();
superiorAddress.Add(new SuperiorAddressModel()
{
ID = -1, AddressName = @UIText.Noting
});
superiorAddress.AddRange(MGJH_TransportPointBLL.GetAddSuperiorAddress());
model.SuperiorAddressSelectList = new SelectList(superiorAddress, "ID", "AddressName");
return(PartialView("_AddReceiveTransportPoint", model));
}
public ActionResult AddReceiveTransportPoint(AddReceiveTransportPointModel model)
{
if (ModelState.IsValid)
{
var result = MGJH_TransportPointBLL.AddReceiveTransportPoint(model, base.CurrentUserID);
string temp = string.Format("ReceiveTransportPointAddressName:{0} SourceID:{1}", model.AddressName, model.SourceID);
base.DoLog(OperationTypeEnum.Add, result, temp);
return(Json(result));
}
else
{
//在查询出的收货地址前面加上一条记录--表示无上级收货地址
List <SuperiorAddressModel> superiorAddress = new List <SuperiorAddressModel>();
superiorAddress.Add(new SuperiorAddressModel()
{
ID = -1, AddressName = @UIText.Noting
});
superiorAddress.AddRange(MGJH_TransportPointBLL.GetAddSuperiorAddress());
model.SuperiorAddressSelectList = new SelectList(superiorAddress, "ID", "AddressName");
return(PartialView("_AddReceiveTransportPoint", model));
}
}
public static OperationResult AddReceiveTransportPoint(AddReceiveTransportPointModel model, int currentUserID)
{
#region 参数
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@SettingType", SqlDbType.TinyInt),
new SqlParameter("@AddressName", SqlDbType.NVarChar),
new SqlParameter("@AddressCode", SqlDbType.NVarChar),
new SqlParameter("@CustomerName", SqlDbType.NVarChar),
new SqlParameter("@AddressArea", SqlDbType.NVarChar),
new SqlParameter("@SuperiorAddressID", SqlDbType.Int),
new SqlParameter("@IsUnloadPoint", SqlDbType.Bit),
new SqlParameter("@EFType", SqlDbType.TinyInt),
new SqlParameter("@EFInfo", SqlDbType.NVarChar),
new SqlParameter("@UnloadTime", SqlDbType.Int),
new SqlParameter("@UnloadTimeError", SqlDbType.Int),
new SqlParameter("@CreateUser", SqlDbType.Int),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@SourceID", SqlDbType.Int),
};
paras[0].Value = 2; //2-收货点
paras[1].Value = model.AddressName.Trim();
paras[2].Value = model.AddressCode.Trim();
paras[3].Value = model.CustomerName.Trim();
paras[4].Value = model.AddressArea.Trim();
//无上级收货地址时，SuperiorAddressID赋空值
if (model.SuperiorAddressID == -1)
{
paras[5].Value = DBNull.Value;
}
else
{
paras[5].Value = model.SuperiorAddressID;
}
paras[6].Value = model.IsUnloadPoint;
//不是卸货点，紧紧是收货点时，以下信息为空
if (model.IsUnloadPoint == false)
{
paras[7].Value = DBNull.Value;
paras[8].Value = DBNull.Value;
paras[9].Value = DBNull.Value;
paras[10].Value = DBNull.Value;
}
else //是卸货点时
{
paras[7].Value = model.EFType;
paras[8].Value = ChangeCoordinateSystem(model.EFType, model.EFInfo, 1); //地图坐标转车机坐标,存入数据库
//暂时去掉预计卸货时长和误差 操作人：戴天辰
paras[9].Value = DBNull.Value;
paras[10].Value = DBNull.Value;
//paras[9].Value = model.UnloadTime * 60; //数据库存的UnloadTime以秒为单位
//if (model.UnloadTimeError == null) //误差前台没有做验证，这里做下处理
//{
// paras[10].Value = DBNull.Value;
//}
//else
//{
// paras[10].Value = model.UnloadTimeError * 60; //数据库存的UnloadTimeError以秒为单位
//}
}
paras[11].Value = currentUserID;
paras[12].Value = DateTime.Now;
paras[13].Value = model.SourceID ?? (object)DBNull.Value;
#endregion
#region SQL
string sql = @"INSERT INTO dbo.MGJH_TransportPointSetting
( [SettingType]
,[AddressName]
,[AddressCode]
,[CustomerName]
,[AddressArea]
,[SuperiorAddressID]
,[IsUnloadPoint]
,[EFType]
,[EFInfo]
,[UnloadTime]
,[UnloadTimeError]
,[CreateUser]
,[CreateTime] )
VALUES ( @SettingType ,
@AddressName,
@AddressCode,
@CustomerName ,
@AddressArea,
@SuperiorAddressID,
@IsUnloadPoint ,
@EFType,
@EFInfo,
@UnloadTime ,
@UnloadTimeError,
@CreateUser,
@CreateTime )";
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
#endregion
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
