/// <summary>
/// 添加项目库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddProjectVault_Click(object sender, EventArgs e)
{
#region 数据验证
if (txtVaultName.Text.Trim().Length == 0)
{
MessageBox.Show("请输入项目库名称", "验证信息");
txtVaultName.Focus();
return;
}
#endregion
//封装对象
ProjectVault objProjectVault = new ProjectVault()
{
VaultName = txtVaultName.Text.Trim()
};
//提交添加
try
{
int vaultId = objProjectVaultService.AddProjectVault(objProjectVault);
if (vaultId > 1)
{
//提示添加成功
MessageBox.Show("项目库添加成功", "提示信息");
//刷新显示
dgvProjectVaults.DataSource = objProjectVaultService.GetAllProjectVaults();
//清空内容
txtVaultName.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 添加项目库
/// </summary>
/// <param name="objProjectVault"></param>
/// <returns></returns>
public int AddProjectVault(ProjectVault objProjectVault)
{
string sql = "insert into ProjectVaults (VaultName) values('{0}');select @@identity";
sql = string.Format(sql, objProjectVault.VaultName);
try
{
return(Convert.ToInt32(SQLHelper.GetSingleResult(sql)));
}
catch (SqlException ex)
{
if (ex.Number == 2627)
{
throw new Exception("库名称重复,不能添加重复的项目库");
}
else
{
throw new Exception("添加项目库时数据库访问异常" + ex.Message);
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改项目库
/// </summary>
/// <param name="objProjectVault"></param>
/// <returns></returns>
public int EditProjectValult(ProjectVault objProjectVault)
{
string sql = "update ProjectVaults set VaultName='{0}' where VaultId={1}";
sql = string.Format(sql, objProjectVault.VaultName, objProjectVault.VaultId);
try
{
return(SQLHelper.Update(sql));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常：" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据项目库Id返回项目库对象
/// </summary>
/// <param name="vaultId"></param>
/// <returns></returns>
public ProjectVault GetProjectVaultById(string vaultId)
{
string sql = "select VaultId,VaultName from ProjectVaults";
sql += string.Format(" where VaultId={0}", vaultId);
SqlDataReader objReader = SQLHelper.GetReader(sql);
ProjectVault objProjectVault = null;
if (objReader.Read())
{
objProjectVault = new ProjectVault()
{
VaultId = Convert.ToInt32(objReader["VaultId"]),
VaultName = objReader["VaultName"].ToString()
};
}
objReader.Close();
return(objProjectVault);
}
/// <summary>
/// 修改项目库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmiEditProjectValut_Click(object sender, EventArgs e)
{
btnAddProjectVault.Visible = false;
btnEditProjectVault.Visible = true;
if (dgvProjectVaults.RowCount == 0)
{
return;
}
if (dgvProjectVaults.CurrentRow == null)
{
MessageBox.Show("请选中需要修改的项目库名称", "提示信息");
return;
}
string vaultId = dgvProjectVaults.CurrentRow.Cells["VaultId"].Value.ToString();
ProjectVault objProjectVault = objProjectVaultService.GetProjectVaultById(vaultId);
//初始化修改信息
txtVaultId.Text = objProjectVault.VaultId.ToString();
txtVaultName.Text = objProjectVault.VaultName;
}
/// <summary>
/// 提交修改项目库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEditProjectVault_Click(object sender, EventArgs e)
{
#region 数据验证
if (txtVaultName.Text.Trim().Length == 0)
{
MessageBox.Show("项目库名称不能为空", "验证信息");
txtVaultName.Focus();
return;
}
#endregion
//封装项目跟踪对象
ProjectVault objProjectVault = new ProjectVault()
{
VaultId = Convert.ToInt32(txtVaultId.Text.Trim()),
VaultName = txtVaultName.Text.Trim()
};
//调用后台方法修改对象
try
{
if (objProjectVaultService.EditProjectValult(objProjectVault) == 1)
{
MessageBox.Show("修改项目库名称成功！", "提示信息");
//刷新内容
dgvProjectVaults.DataSource = objProjectVaultService.GetAllProjectVaults();
//清空内容
txtVaultId.Text = "";
txtVaultName.Text = "";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
btnAddProjectVault.Visible = true;
btnEditProjectVault.Visible = false;
}
