//确认交班
        protected void Button1_Click(object sender, EventArgs e)
        {
            //将数据写入交班表里面
            Model.Shift_Exc model = new Model.Shift_Exc();
            // model.UserId = "";  登陆UserId
            if (ShiftDdl.SelectedIndex == 0)
            {
                MessageBox.Show(this, "请先选择交班班次");
                return;
            }

            //判断该天班次是否提交

            //string str = "where shift_id = '"+Convert.ToInt32(ShiftDdl.SelectedValue)+"'";

            string data = System.DateTime.Now.ToString("yyyy-MM-dd");

            /*and CONVERT(VARCHAR(100), shift_dateTime, 23) = '" + data + "'*/

            //userid 先写死
            string str = "where UserId = '" + UserNow.UserID + "' and shift_id = '" + Convert.ToInt32(ShiftDdl.SelectedValue) + "'";

            int count = seBll.GetRecordCount(str);

            if (count > 0)
            {
                MessageBox.Show(this, "当日班次已提交,请重新选择");
                return;
            }


            //从入账表里面获取该用户的所有收账记录,然后将记录循环新增到交班历史表中
            //获取Session["UserId"],先写死
            string strWhere = UserNow.UserID;
            //更新所有的账的是否交班状态
            DataSet ds = gaBll.GetSumInfo(strWhere);

            gaBll.Updatesis(strWhere);
            int Result = 0;

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                model.shift_id = Convert.ToInt32(ShiftDdl.SelectedValue);
                //model.shift_money = Convert.ToDecimal((Session["Sum"]));
                model.shift_state    = "已确认";
                model.shift_dateTime = System.DateTime.Now;
                model.ga_name        = row["ga_name"].ToString();
                model.ga_number      = row["ga_number"].ToString();
                model.ga_unit        = row["ga_unit"].ToString();
                if (row["ga_num"].ToString().Trim() == null || row["ga_num"].ToString().Trim() == "" || row["ga_num"].ToString().Trim() == " ")
                {
                    model.ga_num = 0;
                }
                else
                {
                    model.ga_num = Convert.ToInt32(row["ga_num"]);
                }
                if (row["ga_sum_price"] == null)
                {
                    model.ga_price = 0;
                }
                else
                {
                    model.ga_price = Convert.ToDecimal(row["ga_price"]);
                }
                model.ga_zffs_id = Convert.ToInt32(row["ga_zffs_id"]);
                model.ga_date    = Convert.ToDateTime(row["ga_date"]);
                model.ga_Type    = Convert.ToInt32(row["ga_Type"]);
                if (row["ga_sum_price"] == null)
                {
                    model.ga_sum_price = 0;
                }
                else
                {
                    model.ga_sum_price = Convert.ToDecimal(row["ga_sum_price"]);
                }
                model.ga_roomNumber = row["ga_roomNumber"].ToString();
                model.UserId        = Convert.ToInt32(UserNow.UserID);
                Result = seBll.Add(model);

                //修改是否交班状态
                int userid = Convert.ToInt32(Session["UserID"]);
                gaBll.Updatesis(userid.ToString());

                ////再删除入账表数据,再插入到历史表中

                //gaBll.ShiftDelete("1");
            }
            if (Result > 0)
            {
                // MessageBox.Show(this, "确认交班报表成功");
                ClientScript.RegisterStartupScript(GetType(), "message", "<script language='javascript'>alert('确认交班报表成功');</script>");
                isdis = 1;
            }

            MethPaySumDataBind();
            GridView2DataBind(pageSize, pageIndex);
        }