/// <summary>
/// 添加工作量
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddWorkload_Click(object sender, EventArgs e)
{
#region 数据验证
if (txtModel.Text.Trim().Length == 0)
{
MessageBox.Show("模型名称不能为空不能为空", "验证信息");
txtModel.Focus();
return;
}
if (txtWorkloadValue.Text.Trim().Length == 0)
{
MessageBox.Show("工作量值不能为空", "验证信息");
txtWorkloadValue.Focus();
return;
}
#endregion
//封装对象
DesignWorkload objDesignWorkload = new DesignWorkload()
{
Model = txtModel.Text.Trim(),
WorkloadValue = Convert.ToDecimal(txtWorkloadValue.Text.Trim()),
ModelDesc = txtModelDesc.Text.Trim()
};
//提交添加
try
{
int userId = objDesignWorkloadService.AddDesignWorkload(objDesignWorkload);
if (userId > 1)
{
//提示添加成功
MessageBox.Show("工作量添加成功", "提示信息");
//刷新显示
RefreshData();
//清空内容
foreach (Control item in Controls)
{
if (item is TextBox)
{
item.Text = "";
}
}
txtModel.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 添加工作量
/// </summary>
/// <param name="objDesignWorkload"></param>
/// <returns></returns>
public int AddDesignWorkload(DesignWorkload objDesignWorkload)
{
string sql = "insert into DesignWorkload (Model,WorkloadValue,ModelDesc)";
sql += " values('{0}',{1},'{2}');select @@identity";
sql = string.Format(sql, objDesignWorkload.Model, objDesignWorkload.WorkloadValue, objDesignWorkload.ModelDesc);
try
{
return(Convert.ToInt32(SQLHelper.GetSingleResult(sql)));
}
catch (SqlException ex)
{
throw new Exception("添加工作量时数据库访问异常" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改工作量
/// </summary>
/// <param name="objDesignWorkload"></param>
/// <returns></returns>
public int EditDesignWorkload(DesignWorkload objDesignWorkload)
{
string sql = "update DesignWorkload set Model='{0}',WorkloadValue={1},ModelDesc='{2}'";
sql += " where WorkloadId={3}";
sql = string.Format(sql, objDesignWorkload.Model, objDesignWorkload.WorkloadValue,
objDesignWorkload.ModelDesc, objDesignWorkload.WorkloadId);
try
{
return(SQLHelper.Update(sql));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常：" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 根据Id返回工作量对象
/// </summary>
/// <param name="workloadId"></param>
/// <returns></returns>
public DesignWorkload GetDesignWorkloadById(string workloadId)
{
string sql = "select WorkloadId,Model,WorkloadValue,ModelDesc from DesignWorkload where WorkloadId={0}";
sql = string.Format(sql, workloadId);
SqlDataReader objReader = SQLHelper.GetReader(sql);
DesignWorkload objDesignWorkload = null;
if (objReader.Read())
{
objDesignWorkload = new DesignWorkload()
{
WorkloadId = Convert.ToInt32(objReader["WorkloadId"]),
Model = objReader["Model"].ToString(),
WorkloadValue = Convert.ToDecimal(objReader["WorkloadValue"]),
ModelDesc = objReader["ModelDesc"].ToString()
};
}
objReader.Close();
return(objDesignWorkload);
}
/// <summary>
/// 提交修改工作量
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEditWorkload_Click(object sender, EventArgs e)
{
#region 数据验证
if (txtEditModel.Text.Trim().Length == 0)
{
MessageBox.Show("模型名称不能为空", "验证信息");
txtModel.Focus();
return;
}
if (txtEditWorkloadValue.Text.Trim().Length == 0)
{
MessageBox.Show("工作量值不能为空", "验证信息");
txtWorkloadValue.Focus();
return;
}
#endregion
//封装对象
DesignWorkload objDesignWorkload = new DesignWorkload()
{
WorkloadId = Convert.ToInt32(txtEditWorkloadId.Text.Trim()),
Model = txtEditModel.Text.Trim(),
WorkloadValue = Convert.ToDecimal(txtEditWorkloadValue.Text.Trim()),
ModelDesc = txtEditModelDesc.Text.Trim()
};
//提交修改
try
{
if (objDesignWorkloadService.EditDesignWorkload(objDesignWorkload) == 1)
{
MessageBox.Show("修改工作量成功！", "提示信息");
grbEditWorkload.Visible = false;
RefreshData();//同步刷新显示数据
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 修改工作量菜单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmiEditWorkload_Click(object sender, EventArgs e)
{
if (dgvDesignWorkload.RowCount == 0)
{
return;
}
if (dgvDesignWorkload.CurrentRow == null)
{
MessageBox.Show("请选中需要修改的工作量条目", "提示信息");
return;
}
string workloadId = dgvDesignWorkload.CurrentRow.Cells["WorkloadId"].Value.ToString();
DesignWorkload objDesignWorkload = objDesignWorkloadService.GetDesignWorkloadById(workloadId);
//初始化修改信息
grbEditWorkload.Visible = true;//显示
txtEditWorkloadId.Text = objDesignWorkload.WorkloadId.ToString();
txtEditModel.Text = objDesignWorkload.Model;
txtEditWorkloadValue.Text = objDesignWorkload.WorkloadValue.ToString();
txtEditModelDesc.Text = objDesignWorkload.ModelDesc;
txtEditWorkloadValue.Focus(); //获取焦点
txtEditWorkloadValue.SelectAll(); //全选，直接编辑
}
