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>"); } } }
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 }
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 = ""; } }