public bool Update(MODELwaterMeterPosition MODELwaterMeterPosition) { StringBuilder str = new StringBuilder(); str.Append("UPDATE waterMeterPosition SET waterMeterPositionName=@waterMeterPositionName,MEMO=@MEMO "); str.Append("WHERE waterMeterPositionId=@waterMeterPositionId"); SqlParameter[] para = { new SqlParameter("@waterMeterPositionName", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50), new SqlParameter("@waterMeterPositionId", SqlDbType.VarChar, 50) }; para[0].Value = MODELwaterMeterPosition.waterMeterPositionName; para[1].Value = MODELwaterMeterPosition.MEMO; para[2].Value = MODELwaterMeterPosition.waterMeterPositionId; if (DBUtility.DbHelperSQL.ExecuteSql(str.ToString(), para) > 0) { return(true); } else { return(false); } }
public bool Insert(MODELwaterMeterPosition MODELwaterMeterPosition) { StringBuilder str = new StringBuilder(); str.Append("INSERT INTO waterMeterPosition(waterMeterPositionId,waterMeterPositionName,MEMO) "); str.Append("VALUES(@waterMeterPositionId,@waterMeterPositionName,@MEMO)"); SqlParameter[] para = { new SqlParameter("@waterMeterPositionId", SqlDbType.VarChar, 30), new SqlParameter("@waterMeterPositionName", SqlDbType.VarChar, 50), new SqlParameter("@MEMO", SqlDbType.VarChar, 50) }; para[0].Value = MODELwaterMeterPosition.waterMeterPositionId; para[1].Value = MODELwaterMeterPosition.waterMeterPositionName; para[2].Value = MODELwaterMeterPosition.MEMO; 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; } MODELwaterMeterPosition MODELwaterMeterPosition = new MODELwaterMeterPosition(); MODELwaterMeterPosition.waterMeterPositionName = txtName.Text; MODELwaterMeterPosition.MEMO = txtMemo.Text; if (txtID.Text == "") { MODELwaterMeterPosition.waterMeterPositionId = GETTABLEID.GetTableID("", "waterMeterPosition"); if (BLLwaterMeterPosition.Insert(MODELwaterMeterPosition)) { 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 { MODELwaterMeterPosition.waterMeterPositionId = txtID.Text; if (BLLwaterMeterPosition.Update(MODELwaterMeterPosition)) { dgList.CurrentRow.Cells["waterMeterPositionName"].Value = MODELwaterMeterPosition.waterMeterPositionName; dgList.CurrentRow.Cells["MEMO"].Value = MODELwaterMeterPosition.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); } }