页面获取grid中的数据


function edit() {
eval("var data ="+ grid.colsToJson("rowId","C1==1"));
var datas = data.join(",").split(",");
//var factIncomeId = grid.getSelectedId();
if(datas==null||datas==""){
skysz.msg.info("请选择要编辑的收款清单的数据。");
return false;
}
var statuses = grid.colsToArray("6","C1==1",true);
for ( var i = 0; i < statuses.length; i++) {
var status = statuses[i];
if (status!='未提交') {
skysz.msg.info("已提交或已拆分的收款清单不能编辑,请重新选择.");
return false;
}
}
var gridData = grid.colsToArray("rowId","(C1==1)");
var ids="[";
ids+=gridData;
ids+="]"
audit.book.receiptDetail.window = skysz.window.modalWindow("收款清单登记 》编辑", 800,
450, '../app/audit/book/receiptDetailEdit.jsp?id='+ids );
}
var delIds="";
function del() {
eval("var data ="+ grid.colsToJson("rowId","C1==1"));
var datas = data.join(",").split(",");
//var factIncomeId = grid.getSelectedId();
if(datas==null||datas==""){
skysz.msg.info("请选择要删除的收款清单的数据。");
return false;
}
var statuses = grid.colsToArray("6","C1==1",true);
for ( var i = 0; i < statuses.length; i++) {
var status = statuses[i];
if (status!='未提交') {
skysz.msg.info("已提交或已拆分的收款清单不能删除,请重新选择.");
return false;
}
}
var gridData = grid.colsToArray("rowId","(C1==1)");
var ids="[";
ids+=gridData;
ids+="]";
delIds=ids;
skysz.msg.confirm('你确定要删除所选中信息?', detail_delete_do);
}
function detail_delete_do(flag) {
var url = "${delete}";
if (skysz.msg.isConfirmBack(flag)) {
skysz.ajax.post(url, "id=" + delIds, delete_callBack);
}
}
var delete_actionResponse ={};
function delete_callBack(actionResponse){
//success
if(skysz.msg.isReturnBack(delete_actionResponse,actionResponse)){
grid.refreash();
//销毁返回对象。
skysz.ajax.destroyActionResponse(delete_actionResponse);
}
}

function submit() {
eval("var data ="+ grid.colsToJson("rowId","C1==1"));
var datas = data.join(",").split(",");
//var factIncomeId = grid.getSelectedId();
if(datas==null||datas==""){
skysz.msg.info("请选择要提交的收款清单的数据。");
return false;
}
var statuses = grid.colsToArray("6","C1==1",true);
for ( var i = 0; i < statuses.length; i++) {
var status = statuses[i];
if (status!='未提交') {
skysz.msg.info("已提交或已拆分的收款清单不能提交,请重新选择.");
return false;
}
}
var payTypes = grid.colsToArray("2","C1==1",true);
for ( var i = 0; i < payTypes.length; i++) {
var payType = payTypes[i];
if (payType!=payTypes[0]) {
skysz.msg.info("缴款类型不一致,请重新选择.");
return false;
}
}
var gridData = grid.colsToArray("rowId","(C1==1)");
var ids="[";
ids+=gridData;
ids+="]"
audit.book.receiptDetail.window = skysz.window.modalWindow("收款清单登记 》提交", 600,
200, '../app/audit/book/receiptDetailSubmit.jsp?id='+ids );
}
function saveFactPay() {
//将grid中的数据转换成JSON.
var gridJson = grid.colsToJson("0,1,2,3,4,5");
//调用后台的保存方法.
form.submit("${save}", 'grid=' + gridJson, addSaveCallBack);
}
//操作grid.
factPay_add_operateGrid = {
checkValue : function() {

//得到所有行.
var rows = grid.getRowsNum();
if (rows == 0)
return true;

var items = grid.getAllItemIds().split(",");

for ( var i = 0; i < items.length; i++) {
var rowId = grid.getRowId(i); //得到行Id
if (!grid.validateRow("C1!=''", rowId)) {
skysz.msg.info("收款日期为必填项目,请填写完整.");
return false;
}

if (!grid.validateRow("C3!=''", rowId)) {
skysz.msg.info("营业厅名称为必填项目,请填写完整.");
return false;
}

//缴款金额不能为0的判断.
if (grid.validateRow("C4==0", rowId)) {
skysz.msg.info("金额不能为0,请重新填写.");
return false;
}

}
return true;
}
}




/**
* 新增
*
* @return
*/
public ActionResponse save() {
ActionResponse ar = new ActionResponse(ResponseType.FAILURE);
String payType = this.getParameter("payType");
List<String[]> grid = super.getGrid("grid");
List<ReceiptDetail> rdList = new ArrayList<ReceiptDetail>();
if (CollectionUtils.isNotEmpty(grid)) {
for (String[] str : grid) {
ReceiptDetail rd = new ReceiptDetail();
rd.setPayType(payType);
rd.setAmount(Double.parseDouble(str[4]));
rd.setHall(new Hall(Long.parseLong(str[3])));
rd.setRemark(str[5]);
rd.setStatus("1");
rd.setBusinessDate(DateUtils.toDate(str[1]));
rd.setEnable(true);
this.setWho(rd);
rdList.add(rd);
}
}
receiptDetailService.insertAll(rdList);
ar.setResponseType(ResponseType.SUCCESS_SAVE);
return ar;
}

/**
* 编辑
*
* @return
*/
public ActionResponse update() {
ActionResponse ar = new ActionResponse(ResponseType.FAILURE);
String payType = this.getParameter("payType");
List<String[]> grid = super.getGrid("grid");
List<ReceiptDetail> insertList = new ArrayList<ReceiptDetail>();
List<ReceiptDetail> updateList = new ArrayList<ReceiptDetail>();
if (CollectionUtils.isNotEmpty(grid)) {
for (String[] str : grid) {
ReceiptDetail rd = null;
if (str[0].indexOf("K") != -1) {
rd = new ReceiptDetail();
} else {
rd = this.receiptDetailService.get(Long.parseLong(str[0]));
}
rd.setPayType(payType);
rd.setAmount(Double.parseDouble(str[5]));
rd.setHall(new Hall(Long.parseLong(str[4])));
rd.setRemark(str[6]);
rd.setStatus("1");
rd.setBusinessDate(DateUtils.toDate(str[2]));
rd.setEnable(true);
this.setWho(rd);
if (str[0].indexOf("K") != -1) {
insertList.add(rd);
} else {
updateList.add(rd);
}
}
}
if (CollectionUtils.isNotEmpty(insertList)) {
receiptDetailService.insertAll(insertList);
}
if (CollectionUtils.isNotEmpty(updateList)) {
receiptDetailService.updateAll(updateList);
}
ar.setResponseType(ResponseType.SUCCESS_SAVE);
return ar;
}
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace 保存GRID数据示例 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button2_Click(object sender, EventArgs e) { //提示是否修改 #region//--------修改数据就将数据保存并显示 if (MessageBox.Show("是否保存数据?", "系统消息", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK) { #region ..........这里是保存数据代码 //结束编辑 dataGridView1.EndEdit(); //重新用表格数据填充数据容器 OleDbDataAdapter Ada = new OleDbDataAdapter(); DataTable table = (DataTable)dataGridView1.DataSource; //重新启动连接 String ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + "/驱动.mdb"; //用Buider方法更新数据 using (OleDbConnection connection = new OleDbConnection(ConnectionString)) { Ada.SelectCommand = new OleDbCommand("SELECT * FROM 表", connection); OleDbCommandBuilder builder = new OleDbCommandBuilder(Ada); Ada.UpdateCommand = builder.GetUpdateCommand(); try { //更新数据数据时 Ada.Update(table); table.AcceptChanges(); MessageBox.Show("操作已成功!数据将全部被保存......", "系统消息", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2); } catch (System.Data.OleDb.OleDbException ex) { throw new Exception(ex.Message); } } #endregion } #endregion #region //--------不修改就初始化显示以前数据 else { MessageBox.Show("用户取消操作,数据将恢复到初始状态......"); OleDbConnection A = new OleDbConnection(); A.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + "/驱动.mdb"; try { A.Open(); DataSet B = new DataSet(); string sqlStr = "Select * from 表"; OleDbDataAdapter C = new OleDbDataAdapter(sqlStr, A); C.Fill(B); dataGridView1.DataSource = B.Tables[0]; } catch (System.Data.OleDb.OleDbException ex) { throw new Exception(ex.Message); } finally { A.Close(); } } #endregion } private void button1_Click(object sender, EventArgs e) { OleDbConnection A = new OleDbConnection(); A.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + System.Windows.Forms.Application.StartupPath + "/驱动.mdb"; try { A.Open(); DataSet B = new DataSet(); string sqlStr = "Select * from 表"; OleDbDataAdapter C = new OleDbDataAdapter(sqlStr, A); C.Fill(B); dataGridView1.DataSource = B.Tables[0]; } catch (System.Data.OleDb.OleDbException ex) { throw new Exception(ex.Message); } finally { A.Close(); } } private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { } } }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值