//获取指定需要同步的收货地址信息
public static SelectResult <EditSynchroReceivePointModel> GetSynchroReceivePointByID(int id)
{
List <SqlParameter> paras = new List <SqlParameter>()
{
new SqlParameter()
{
ParameterName = "@ID",
SqlDbType = SqlDbType.Int,
},
};
paras[0].Value = id;
string sql = @"SELECT sr.ID
,sr.CustomerName
,sr.AddressName
,sr.AddressCode
,sr.AddressArea
FROM dbo.MGJH_SynchroReceiveAddress sr
WHERE sr.ID=@ID";
List <EditSynchroReceivePointModel> list = ConvertToList <EditSynchroReceivePointModel> .Convert(MSSQLHelper.ExecuteDataTable(CommandType.Text, sql, paras.ToArray()));
EditSynchroReceivePointModel data = null;
string msg = string.Empty;
if (list == null)
{
msg = PromptInformation.DBError;
}
else if (list.Count == 0)
{
msg = PromptInformation.NotExists;
}
else
{
data = list[0];
}
return(new SelectResult <EditSynchroReceivePointModel>()
{
DataResult = data,
Message = msg
});
}
public ActionResult EditSynchroReceivePoint(EditSynchroReceivePointModel model)
{
if (ModelState.IsValid)
{
var result = MGJH_TransportPointBLL.EditSynchroReceivePoint(model, base.CurrentUserID);
base.DoLog(OperationTypeEnum.Edit, result, "SynchroReceiveID:" + model.ID);
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("_EditSynchroReceivePoint", model));
}
}
//将要同步的收货地址信息添加到收货点设定表中
public static OperationResult EditSynchroReceivePoint(EditSynchroReceivePointModel 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 = 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.ID; //为同步收货地址表MGJH_SynchroReceiveAddress的ID，关联MGJH_TransportPointSetting表的SourceID字段
#endregion
#region SQL
string sql = @"INSERT INTO dbo.MGJH_TransportPointSetting
( [SettingType]
,[AddressName]
,[AddressCode]
,[CustomerName]
,[AddressArea]
,[SuperiorAddressID]
,[IsUnloadPoint]
,[EFType]
,[EFInfo]
,[UnloadTime]
,[UnloadTimeError]
,[CreateUser]
,[CreateTime]
,SourceID)
VALUES ( @SettingType ,
@AddressName,
@AddressCode,
@CustomerName ,
@AddressArea,
@SuperiorAddressID,
@IsUnloadPoint ,
@EFType,
@EFInfo,
@UnloadTime ,
@UnloadTimeError,
@CreateUser,
@CreateTime ,
@SourceID )";
bool result = MSSQLHelper.ExecuteNonQuery(CommandType.Text, sql, paras.ToArray()) > 0;
#endregion
return(new OperationResult()
{
Success = result,
Message = result ? PromptInformation.OperationSuccess : PromptInformation.DBError
});
}
