dingdan/guihuan.aspx.cs

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using dao;

public partial class dingdan_guihuan : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        int id = Int32.Parse(Request.QueryString["id"]);
        string cl=Request.QueryString["cl"];
        string sysj = Request.QueryString["sysj"];
        string sql = "";
        try
        {
       


            DateTime dt1 = Convert.ToDateTime(System.DateTime.Now.ToShortDateString());
            DateTime dt2 = Convert.ToDateTime(sysj);
            TimeSpan ts = dt1 - dt2;
            int sub = ts.Days;     //sub就是两天相差的天数
            if (sub == 0) {
                sub = 1;
            }
            int jga=0;
              sql = "select jg from zuche where zcid='" + cl + "'";//根据ID查询这个表信息
            DataTable dt = DBHelper.GetDataSet(sql);
            if (dt.Rows.Count > 0)
            {
                jga = int.Parse(dt.Rows[0]["jg"].ToString());
            }
            int all = jga * sub;

            sql="update zuche set zt='空闲' where zcid='"+cl+"'";
            DBHelper.ExecuteCommand(sql);

            sql = "update dingdan set zt='完成',jzsj='" + System.DateTime.Now.ToString() + "',jg='" + all + "',zysj='"+sub+"' where ddid='"+id+"'";
            DBHelper.GetDataSet(sql);
        }
        catch (Exception ex)
        {

        }
        MessageBox.ShowAndRedirect(this, "归还成功！", "dingdan.aspx");




    }
}