예제 #1
0
 public void AddTrafficReport(TrafficeFlowReport model)
 {
     dareport.AddTrafficReport(model);
 }
예제 #2
0
        public ActionResult TrafficReport(TrafficeFlowReport model)
        {
            if (ModelState.IsValid)
            {
                model.CrUser = CurrentUserModel.Current.UserID;
                model.StationID = CurrentUserModel.Current.StationID;
                new BLReports().AddTrafficReport(model);
                return Content("<script>alert('添加成功');window.location.href='/report/TrafficReport';</script>");

            }
            return View(model);
        }
예제 #3
0
        public void AddTrafficReport(TrafficeFlowReport model)
        {
            try
            {
                string strSQL = @"
                                if exists (select id from TrafficFlowReport
                                            where stationid=@stationid
                                            and reportdate=@reportdate)
                                begin
                                    update TrafficFlowReport set
                                    DownAmount=@DownAmount,
                                    TruckAmount=@TruckAmount,
                                    MoreThan30=@MoreThan30,
                                    MoreThan100=@MoreThan100,
                                    EngineeringVehicles=@EngineeringVehicles,
                                    EasyAccess=@EasyAccess,
                                    CrUser=@CrUser,
                                    crtime=getdate()
                                    where stationid=@stationid
                                    and reportdate=@reportdate
                                end
                                else
                                begin
                                    insert into TrafficFlowReport(ReportDate,StationID,DownAmount,TruckAmount,MoreThan30,MoreThan100,EngineeringVehicles,EasyAccess,CrUser)
                                        values(@ReportDate,@StationID,@DownAmount,@TruckAmount,@MoreThan30,@MoreThan100,@EngineeringVehicles,@EasyAccess,@CrUser)
                                end  ";

                SqlParameter[] parms = new SqlParameter[]{
                new SqlParameter("@reportdate",SqlDbType.DateTime),
                new SqlParameter("@DownAmount",SqlDbType.Int),
                new SqlParameter("@TruckAmount",SqlDbType.Int),
                new SqlParameter("@MoreThan30",SqlDbType.Int),
                new SqlParameter("@MoreThan100",SqlDbType.Int),
                new SqlParameter("@EngineeringVehicles",SqlDbType.Int),
                new SqlParameter("@EasyAccess",SqlDbType.Int),
                new SqlParameter("@cruser",SqlDbType.Int),
                new SqlParameter("@stationid",SqlDbType.Int),
            };

                parms[0].Value = model.ReportDate;
                parms[1].Value = model.DownAmount;
                parms[2].Value = model.TruckAmount;
                parms[3].Value = model.MoreThan30;
                parms[4].Value = model.MoreThan100;
                parms[5].Value = model.EngineeringVehicles;
                parms[6].Value = model.EasyAccess;
                parms[7].Value = model.CrUser;
                parms[8].Value = model.StationID;
                SqlHelper.ExecuteNonQuery(SqlHelper.SQLConnectString, CommandType.Text, strSQL, parms);
            }
            catch (Exception ex)
            {
                throw;
            }
        }