public static OperationResult EditPickUpTransportPoint(EditPickUpTransportPointModel model, int currentUserID)
{
string _EFInfo = ChangeCoordinateSystem(model.EFType, model.EFInfo, 1); //地图坐标转车机坐标,存入数据库
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter("@AddressName", SqlDbType.NVarChar),
new SqlParameter("@AddressCode", SqlDbType.NVarChar),
new SqlParameter("@EFType", SqlDbType.TinyInt),
new SqlParameter("@EFInfo", SqlDbType.NVarChar),
new SqlParameter("@UpdateUser", SqlDbType.Int),
new SqlParameter("@UpdateTime", SqlDbType.DateTime),
new SqlParameter("@ID", SqlDbType.Int),
};
paras[0].Value = model.AddressName.Trim();
paras[1].Value = model.AddressCode.Trim();
paras[2].Value = model.EFType;
paras[3].Value = _EFInfo;
paras[4].Value = currentUserID;
paras[5].Value = DateTime.Now;
paras[6].Value = model.ID;
#region SQL
string sql = @"UPDATE dbo.MGJH_TransportPointSetting
SET AddressName = @AddressName ,
AddressCode = @AddressCode ,
EFType = @EFType ,
EFInfo = @EFInfo ,
UpdateUser = @UpdateUser,
UpdateTime = @UpdateTime
WHERE ID = @ID";
#endregion
int result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray());
string msg = string.Empty;
switch (result)
{
case 1:
msg = PromptInformation.OperationSuccess;
break;
case 0:
msg = PromptInformation.NotExists;
break;
case -1:
msg = PromptInformation.DBError;
break;
}
return(new OperationResult()
{
Success = result > 0,
Message = msg
});
}
public ActionResult EditPickUpTransportPoint(EditPickUpTransportPointModel model)
{
if (ModelState.IsValid)
{
var result = MGJH_TransportPointBLL.EditPickUpTransportPoint(model, base.CurrentUserID);
base.DoLog(OperationTypeEnum.Edit, result, "PickUpTransportID:" + model.ID);
return(Json(result));
}
else
{
return(PartialView("_EditPickUpTransportPoint", model));
}
}
public static SelectResult <EditPickUpTransportPointModel> GetPickUpTransportPointByID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ID",
SqlDbType = SqlDbType.Int,
},
};
paras[0].Value = id;
string sql = @"SELECT ID
,SettingType
,AddressName
,AddressCode
,EFType
,EFInfo
FROM dbo.MGJH_TransportPointSetting
WHERE ID=@ID";
List <EditPickUpTransportPointModel> list = ConvertToList <EditPickUpTransportPointModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
EditPickUpTransportPointModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
data.EFInfo = ChangeCoordinateSystem(data.EFType, data.EFInfo, 2); //将取出的车机坐标转成地图坐标，显示
}
return(new SelectResult <EditPickUpTransportPointModel>()
{
DataResult = data,
Message = msg
});
}
