Car/Admin/Log/AddOut.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Car.Admin.Log
{
    public partial class AddOut : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!this.IsPostBack) 
            {
                DataTable dt = DBUtility.DbHelperSQL.Query("select * from CarLog where CarID = '" + Request.QueryString["CarID"] + "' and Flag = 0 and Category = 1 order by InfoID desc").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    TextBox4.Text = "【" + dt.Rows[0]["UserType"].ToString() + "】" + dt.Rows[0]["UserLoginName"].ToString();
                    TextBox3.Text = dt.Rows[0]["CarID"].ToString();
                    TextBox1.Text = ReturnName(dt.Rows[0]["OptionInfoID"].ToString());
                    TextBox2.Text = DateTime.Parse(dt.Rows[0]["AddDate"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                    TextBox1.ReadOnly = true;
                    TextBox2.ReadOnly = true;
                    TextBox3.ReadOnly = true;
                    TextBox4.ReadOnly = true;
                }
                else 
                {
                    ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), System.DateTime.Now.Ticks.ToString(), "layer.alert('车牌号没有停车记录！', {icon: 2,kin: 'layer-ext-moon',closeBtn: 0}, function () { location.href = 'OutLog.aspx';})", true);
                }
            }
        }


        public string ReturnName(string str)
        {
            return DBUtility.DbHelperSQL.GetSingle("select Title from UserOption where InfoID = " + str).ToString();
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            DataTable dt = DBUtility.DbHelperSQL.Query("select * from CarLog where CarID = '" + Request.QueryString["CarID"] + "' and Flag = 0 and Category = 1 order by InfoID desc").Tables[0];
            Hashtable ht = new Hashtable();
            ht.Add("Flag", 1);
            ht.Add("LogID", dt.Rows[0]["LogID"].ToString());
            ht.Add("Category", 2);
            ht.Add("UserType", dt.Rows[0]["UserType"].ToString());
            ht.Add("OptionInfoID", dt.Rows[0]["OptionInfoID"].ToString());
            List<DBUtility.CommandInfo> list = new List<DBUtility.CommandInfo>();
            if (dt.Rows[0]["UserType"].ToString() == "临时用户")
            {
                ht.Add("CarID", dt.Rows[0]["CarID"].ToString());
                ht.Add("UserLoginName", dt.Rows[0]["UserLoginName"].ToString());
            }
            else
            {
                if (decimal.Parse(Text1.Value) > decimal.Parse(DBUtility.DbHelperSQL.GetSingle("select UserMoney from UserTable where InfoID = '" + dt.Rows[0]["UserInfoID"].ToString() + "'").ToString()))