public void CreatePostStatus(LogisticsStatus ls)
{
SqlParameter[] param = new SqlParameter[] {
SqlUtilities.GenerateInputNVarcharParameter("@bar_code", 50, ls.TrackNum),
SqlUtilities.GenerateInputNVarcharParameter("@status", 50, ls.Status),
SqlUtilities.GenerateInputNVarcharParameter("@location", 50, ls.Location),
SqlUtilities.GenerateInputNVarcharParameter("@to_country", 50, ls.ToCountry),
SqlUtilities.GenerateInputDateTimeParameter("@disposal_time", ls.DisposalTime),
SqlUtilities.GenerateInputParameter("@is_arrive", SqlDbType.Bit, ls.IsArrive),
SqlUtilities.GenerateInputDateTimeParameter("@create_time", ls.CreateTime)
};
string sql = "INSERT INTO post_status (bar_code, status, location, to_country, disposal_time, is_arrive, create_time) VALUES(@bar_code, @status, @location, @to_country, @disposal_time, @is_arrive, @create_time)";
SqlHelper.ExecuteNonQuery(CommandType.Text, sql, param);
}
public static void CreatePostStatus(LogisticsStatus ls)
{
dal.CreatePostStatus(ls);
}
