Ejemplo n.º 1
0
        public void wd_DataGrid_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)        //撤销
        {
            if (e.Item.ItemIndex == -1)
            {
                return;
            }
            Business bus = new Business();
            //撤消提现
            string hy_num = e.Item.Cells[13].Text.Trim();
            string money  = e.Item.Cells[6].Text.Trim();

            if (e.CommandName == "chexiaobutton")
            {
                //ATI
                if (true)
                {
                    return;
                }
                Decimal d = Convert.ToDecimal(e.Item.Cells[6].Text.Trim());              //金额

                if (bus.BankOperation(Convert.ToInt32(hy_num), Convert.ToDecimal(money)))
                {
                    this.update_zt("撤消", getCpUser(), hy_num);
                    bus.BankLog_updatebz(Convert.ToInt32(e.Item.Cells[0].Text.Trim()), Convert.ToInt32(hy_num), "撤消提现");
                    this.update_zt("已撤消", getCpUser(), e.Item.Cells[0].Text.Trim());
                                  //Response.Write("<script>alert('撤消提现成功!')</script>");
                }
                else
                {
                    Response.Write("<script>alert('撤消提现失败!')</script>");
                }
            }
            //处理提现
            if (e.CommandName == "chulibutton")
            {
                //2012.7.5   set jweotai
                int teasye_id = Convert.ToInt32(e.Item.Cells[0].Text.Trim());
                int hy_numInt = Convert.ToInt32(hy_num);

                c.process(teasye_id);
                databind();
                //ati end

                if (bus.BankLog_updatebz(Convert.ToInt32(e.Item.Cells[0].Text.Trim()), Convert.ToInt32(hy_num), "提现成功"))
                {
                    string  y    = e.Item.Cells[6].Text.Trim();
                    Decimal ee   = -Convert.ToDecimal(e.Item.Cells[6].Text.Trim());
                    string  str3 = "update Bank_log set balance=" + ee + " where tx_id='" + e.Item.Cells[0].Text.Trim() + "'";
                    DBbase.excuteSql(str3);                    //2007.3.6张加  体现成功后将体现金额改成负数。
                    this.update_zt("已处理", getCpUser(), e.Item.Cells[0].Text.Trim());
                    ///Response.Write("<script>alert('111111!')</script>");
                }
                else
                {
                    //Response.Write("<script>alert('2222222!')</script>");
                }
            }
        }
Ejemplo n.º 2
0
        private void update_zt(string zt, string Manager, string id)
        {
            string str_update = "update Bank_tixian set zt='" + zt + "' , chuliren='" + Manager + "' where id=" + id;

            try
            {
                string str_update_time = "update Bank_tixian set fktime='" + System.DateTime.Now.ToString() + "' where id=" + id;
                DBbase.excuteSql(str_update);
                DBbase.excuteSql(str_update_time);
            }
            catch
            {
            }
            databind();            //数据绑定datagrid
        }
Ejemplo n.º 3
0
        private void wd_DataGrid_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
        {
            string id;

            if (this.deletehid.Value == "1")                                                                                //如果删除i数据id为1
            {
                if (e.Item.ItemIndex == 0 && wd_DataGrid.PageCount != 1 && wd_DataGrid.Items.Count == e.Item.ItemIndex + 1) //如果最后一页只有一条记录删除记录后显示前一页
                {
                    if (wd_DataGrid.PageCount == 1)                                                                         //如果只有一页只有一条记录删除记录后显示第一页
                    {
                        id = wd_DataGrid.DataKeys[e.Item.ItemIndex].ToString();                                             //选择id
                        DBbase.excuteSql("delete from DaiGou where id=" + id);                                              //执行sql
                        //Response.Write("<script language=javascript>alert('系统提醒您:删除成功!')</script>");
                        wd_DataGrid.CurrentPageIndex = 0;                                                                   //初始态
                        //this.databind();//数据从新绑定
                        Response.Write("<script language=javascript>window.location.href=window.location.href;</script>");
                    }
                    else
                    {
                        id = wd_DataGrid.DataKeys[e.Item.ItemIndex].ToString();                      //选定id
                        DBbase.excuteSql("delete from DaiGou where id=" + id);                       //执行sql
                        //Response.Write("<script language=javascript>alert('系统提醒您:删除成功!')</script>");
                        wd_DataGrid.CurrentPageIndex = wd_DataGrid.PageCount - 2;                    //显示前一页
                        //this.databind();//数据从新绑定
                        Response.Write("<script language=javascript>window.location.href=window.location.href;</script>");
                    }
                }
                else
                {
                    id = wd_DataGrid.DataKeys[e.Item.ItemIndex].ToString();                   //选定id
                    DBbase.excuteSql("delete  from DaiGou where id=" + id);                   //执行sql
                    //Response.Write("<script language=javascript>alert('系统提醒您:删除成功!')</script>");
                    //this.databind();//数据从新绑定
                    Response.Write("<script language=javascript>window.location.href=window.location.href;</script>");
                }
                this.deletehid.Value = "";
            }
        }