public bool Insert(MODELBASE_BANK MODELBASE_BANK) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO BASE_BANK(BANKID,BANKNAME,MEMO) "); str.Append("VALUES(@BANKID,@BANKNAME,@MEMO)"); SqlParameter[] para = { new SqlParameter("@BANKID", SqlDbType.VarChar, 30), new SqlParameter("@BANKNAME", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_BANK.BANKID; para[1].Value = MODELBASE_BANK.BANKNAME; para[2].Value = MODELBASE_BANK.MEMO; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool Update(MODELBASE_BANK MODELBASE_BANK) { StringBuilder str = new StringBuilder(); str.Append("UPDATE BASE_BANK SET BANKNAME=@BANKNAME,MEMO=@MEMO "); str.Append("WHERE BANKID=@BANKID"); SqlParameter[] para = { new SqlParameter("@BANKNAME", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50), new SqlParameter("@BANKID", SqlDbType.VarChar, 50) }; para[0].Value = MODELBASE_BANK.BANKNAME; para[1].Value = MODELBASE_BANK.MEMO; para[2].Value = MODELBASE_BANK.BANKID; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
private void toolSubmit_Click(object sender, EventArgs e) { try { if (txtName.Text.Trim() == "") { mes.Show("请输入组名称!"); txtName.Focus(); return; } MODELBASE_BANK MODELBASE_BANK = new MODELBASE_BANK(); MODELBASE_BANK.BANKNAME = txtName.Text; MODELBASE_BANK.MEMO = txtMemo.Text; if (txtID.Text == "") { MODELBASE_BANK.BANKID = GETTABLEID.GetTableID("", "base_bank"); if (BLLBASE_BANK.Insert(MODELBASE_BANK)) { toolSearch_Click(null, null); dgList.ClearSelection(); dgList.CurrentCell = dgList.Rows[dgList.Rows.Count - 1].Cells[1]; dgList_SelectionChanged(null, null); } else { mes.Show("添加失败,请重新点击保存按钮!"); return; } } else { MODELBASE_BANK.BANKID = txtID.Text; if (BLLBASE_BANK.Update(MODELBASE_BANK)) { dgList.CurrentRow.Cells["BANKNAME"].Value = MODELBASE_BANK.BANKNAME; dgList.CurrentRow.Cells["MEMO"].Value = MODELBASE_BANK.MEMO; } else { mes.Show("修改失败,请重新点击保存按钮!"); return; } } //DisEnableControl(gbDetail); dgList.Enabled = true; toolAdd.Text = "添加"; toolDelete.Enabled = true; toolSearch.Enabled = true; } catch (Exception ex) { log.Write(ex.Message, MsgType.Error); mes.Show(ex.Message); } }