/// <summary>
/// 将记录集转为LogisticsModel实体类 (LogisticsModel)
/// </summary>
/// <param name="dr">记录集</param>
/// <param name="fileds">字段名列表</param>
/// <returns>LogisticsModel</returns>
protected QuartzInAction.Model.LogisticsModel Populate_LogisticsModel(IDataReader reader,
Dictionary <string, string> fileds, string _conStr)
{
QuartzInAction.Model.LogisticsModel model = new QuartzInAction.Model.LogisticsModel();
//物流信息内容
if (fileds.ContainsKey("Context") && !Convert.IsDBNull(reader["Context"]))
{
model.Context = reader["Context"].ToString();
}
//查询时间
if (fileds.ContainsKey("LDTime") && !Convert.IsDBNull(reader["LDTime"]))
{
DateTime lDTime;
if (DateTime.TryParse(reader["LDTime"].ToString(), out lDTime))
{
model.LDTime = lDTime;
}
}
return(model);
}
/// <summary>
/// 添加数据到快递公司送货状态最新消息数据表
/// </summary>
/// <param name="id">快递公司送货状态表Id</param>
/// <param name="entity">最新消息数据实体</param>
/// <returns></returns>
public QuartzInAction.Model.LogisticsModel AddEntity(int id, QuartzInAction.Model.LogisticsModel entity,
string _conStr)
{
StringBuilder sql = new StringBuilder(100);
sql.Append(" INSERT INTO [LData](DId,Context,LDTime,LDFTime,Status,AreaCode,AreaName) ");
sql.Append(" VALUES (@DId,@Context,@LDTime,@LDFTime,@Status,@AreaCode,@AreaName) ");
SqlParameter[] parameters = new SqlParameter[]
{
new SqlParameter()
{
ParameterName = "@DId", SqlDbType = SqlDbType.Int, Value = id
},
new SqlParameter()
{
ParameterName = "@Context",
SqlDbType = SqlDbType.NVarChar,
Size = 2000,
Value = (entity.Context ?? string.Empty)
},
new SqlParameter()
{
ParameterName = "@LDTime",
SqlDbType = SqlDbType.VarChar,
Size = 100,
Value = (entity.LDTime != null ? entity.LDTime : DateTime.Now)
},
new SqlParameter()
{
ParameterName = "@LDFTime",
SqlDbType = SqlDbType.VarChar,
Size = 100,
Value = (entity.LDFTime ?? string.Empty)
},
new SqlParameter()
{
ParameterName = "@Status",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = (entity.Status ?? string.Empty)
},
new SqlParameter()
{
ParameterName = "@AreaCode",
SqlDbType = SqlDbType.VarChar,
Size = 50,
Value = (entity.AreaCode ?? string.Empty)
},
new SqlParameter()
{
ParameterName = "@AreaName",
SqlDbType = SqlDbType.VarChar,
Size = 500,
Value = (entity.AreaName ?? string.Empty)
}
};
try
{
if (SqlServerHelper.ExecuteNonQuery(sql.ToString(), parameters, _conStr) > 0)
{
return(entity);
}
else
{
return(null);
}
}
catch (Exception ex)
{
return(null);
}
}
