/// <summary>
/// 添加通用技术要求
/// </summary>
/// <param name="objGeneralRequirement"></param>
/// <returns></returns>
public int AddGeneralRequirement(GeneralRequirement objGeneralRequirement)
{
string sql = "insert into GeneralRequirements (ProjectId,TypeId,InputPower,MARVEL,ANSULPrePipe,ANSULSystem,RiskLevel)";
sql += " values({0},{1},'{2}','{3}','{4}','{5}',{6});select @@identity";
sql = string.Format(sql, objGeneralRequirement.ProjectId, objGeneralRequirement.TypeId, objGeneralRequirement.InputPower,
objGeneralRequirement.MARVEL, objGeneralRequirement.ANSULPrePipe, objGeneralRequirement.ANSULSystem, objGeneralRequirement.RiskLevel);
try
{
return(Convert.ToInt32(SQLHelper.GetSingleResult(sql)));
}
catch (SqlException ex)
{
//2627
if (ex.Number == 2627)
{
throw new Exception("项目号重复,不能添加重复的通用技术要求");
}
else
{
throw new Exception("添加通用技术要求时数据库访问异常" + ex.Message);
}
}
catch (Exception ex)
{
throw ex;
}
}
public FrmRequirements(Project objProject) : this()
{
txtODPNo.Text = objProject.ODPNo;
txtProjectId.Text = objProject.ProjectId.ToString();
GeneralRequirement objGeneralRequirement =
objRequirementService.GetGeneralRequirementByODPNo(objProject.ODPNo);
if (objGeneralRequirement == null)
{
btnGeneralRequirement.Text = "添加通用技术要求";
}
else
{
btnGeneralRequirement.Text = "修改通用技术要求";
cobTypeName.Text = objGeneralRequirement.TypeName;
cobInputPower.Text = objGeneralRequirement.InputPower;
cobMARVEL.Text = objGeneralRequirement.MARVEL;
cobANSULPrepipe.Text = objGeneralRequirement.ANSULPrePipe;
cobANSULSystem.Text = objGeneralRequirement.ANSULSystem;
txtGeneralRequirementId.Text = objGeneralRequirement.GeneralRequirementId.ToString();
cobRiskLevel.Text = objGeneralRequirement.RiskLevel.ToString();
}
btnSpecialRequirement.Text = "添加特殊技术要求";
dgvSpecialRequirements.AutoGenerateColumns = false;
dgvSpecialRequirements.DataSource = objRequirementService.GetSpecialRequirementsByODPNo(objProject.ODPNo);
}
/// <summary>
/// 根据条件返回单个通用技术要求
/// </summary>
/// <param name="whereSql"></param>
/// <returns></returns>
public GeneralRequirement GetGeneralRequirementByWhereSql(string whereSql)
{
string sql = "select GeneralRequirementId,GeneralRequirements.ProjectId,ODPNo,ProjectTypes.TypeId,TypeName,InputPower,MARVEL,ANSULPrePipe,ANSULSystem,RiskLevel,MainAssyPath from GeneralRequirements";
sql += " inner join Projects on Projects.ProjectId=GeneralRequirements.ProjectId";
sql += " inner join ProjectTypes on ProjectTypes.TypeId=GeneralRequirements.TypeId";
sql += whereSql;
SqlDataReader objReader = SQLHelper.GetReader(sql);
GeneralRequirement objGeneralRequirement = null;
if (objReader.Read())
{
objGeneralRequirement = new GeneralRequirement()
{
GeneralRequirementId = Convert.ToInt32(objReader["GeneralRequirementId"]),
ProjectId = Convert.ToInt32(objReader["ProjectId"]),
ODPNo = objReader["ODPNo"].ToString(),
TypeId = Convert.ToInt32(objReader["TypeId"]),
TypeName = objReader["TypeName"].ToString(),
InputPower = objReader["InputPower"].ToString(),
MARVEL = objReader["MARVEL"].ToString(),
ANSULPrePipe = objReader["ANSULPrePipe"].ToString(),
ANSULSystem = objReader["ANSULSystem"].ToString(),
MainAssyPath = objReader["MainAssyPath"].ToString(),
RiskLevel = Convert.ToInt32(objReader["RiskLevel"])
};
}
objReader.Close();
return(objGeneralRequirement);
}
/// <summary>
/// 下拉选择项目后自动切换
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void cobODPNo_SelectedIndexChanged(object sender, EventArgs e)
{
if (cobODPNo.SelectedIndex == -1)
{
return;
}
objProject = objProjectService.GetProjectByODPNo(cobODPNo.Text);
objGeneralRequirement = objRequirementService.GetGeneralRequirementByODPNo(cobODPNo.Text);
txtBPONo.Text = objProject.BPONo;
txtProjectName.Text = objProject.ProjectName;
RefreshTree();
RefreshDgv();
if (objGeneralRequirement == null)
{
MessageBox.Show("请注意，项目通用技术要求没有添加，可能导致发货清单无法正常输出", "提示信息");
btnCeilingPackingList.Enabled = false;
btnPrintCeilingPackingList.Enabled = false;
btnSaveToExcel.Enabled = false;
}
else
{
txtTypeName.Text = objGeneralRequirement.TypeName;
txtMainAssyPath.Text = objGeneralRequirement.MainAssyPath;
if (objGeneralRequirement.MainAssyPath.Length > 0 && Program.ObjCurrentUser.UserGroupId < 3)
{
btnCeilingPackingList.Enabled = true;
}
if (dgvCeilingPackingList.RowCount > 0)
{
btnPrintCeilingPackingList.Enabled = true;
btnSaveToExcel.Enabled = true;
}
}
}
/// <summary>
/// 刷新通用技术要求
/// </summary>
private void RefreshGeneralRequirement()
{
GeneralRequirement objGeneralRequirement =
objRequirementService.GetGeneralRequirementByODPNo(cobODPNo.Text);
if (objGeneralRequirement == null)
{
txtTypeName.Text = "";
txtInputPower.Text = "";
txtMARVEL.Text = "";
txtANSULPrePipe.Text = "";
txtANSULSystem.Text = "";
txtGeneralRequirementId.Text = "";
txtRiskLevel.Text = "";
}
else
{
txtTypeName.Text = objGeneralRequirement.TypeName;
txtInputPower.Text = objGeneralRequirement.InputPower;
txtMARVEL.Text = objGeneralRequirement.MARVEL;
txtANSULPrePipe.Text = objGeneralRequirement.ANSULPrePipe;
txtANSULSystem.Text = objGeneralRequirement.ANSULSystem;
txtGeneralRequirementId.Text = objGeneralRequirement.GeneralRequirementId.ToString();
txtRiskLevel.Text = objGeneralRequirement.RiskLevel.ToString();
}
}
/// <summary>
/// 更新天花烟罩总装配地址到通用技术要求中
/// </summary>
/// <param name="objGeneralRequirement"></param>
/// <returns></returns>
public int UpdateMainAssyPath(GeneralRequirement objGeneralRequirement)
{
string sql = "update GeneralRequirements set MainAssyPath='{0}' where GeneralRequirementId={1}";
sql = string.Format(sql, objGeneralRequirement.MainAssyPath, objGeneralRequirement.GeneralRequirementId);
try
{
return(SQLHelper.Update(sql));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常：" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 修改通用技术要求
/// </summary>
/// <param name="objGeneralRequirement"></param>
/// <returns></returns>
public int EditGeneralRequirement(GeneralRequirement objGeneralRequirement)
{
string sql = "update GeneralRequirements set ProjectId={0},TypeId={1},InputPower='{2}',MARVEL='{3}',";
sql += "ANSULPrePipe='{4}',ANSULSystem='{5}',RiskLevel={6} where GeneralRequirementId={7}";
sql = string.Format(sql, objGeneralRequirement.ProjectId, objGeneralRequirement.TypeId, objGeneralRequirement.InputPower,
objGeneralRequirement.MARVEL, objGeneralRequirement.ANSULPrePipe, objGeneralRequirement.ANSULSystem,
objGeneralRequirement.RiskLevel, objGeneralRequirement.GeneralRequirementId);
try
{
return(SQLHelper.Update(sql));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常：" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 通用技术要求添加/修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnGeneralRequirement_Click(object sender, EventArgs e)
{
#region 数据验证
if (cobTypeName.SelectedIndex == -1)
{
MessageBox.Show("请选择项目类型", "验证信息");
cobTypeName.Focus();
return;
}
if (cobRiskLevel.SelectedIndex == -1)
{
MessageBox.Show("请选择项目等级", "验证信息");
cobANSULSystem.Focus();
return;
}
if (cobInputPower.SelectedIndex == -1)
{
MessageBox.Show("请选择电制", "验证信息");
cobInputPower.Focus();
return;
}
if (cobMARVEL.SelectedIndex == -1)
{
MessageBox.Show("请选择MARVEL", "验证信息");
cobMARVEL.Focus();
return;
}
if (cobANSULPrepipe.SelectedIndex == -1)
{
MessageBox.Show("请选择ANSUL预埋", "验证信息");
cobANSULPrepipe.Focus();
return;
}
if (cobANSULSystem.SelectedIndex == -1)
{
MessageBox.Show("请选择ANSUL系统", "验证信息");
cobANSULSystem.Focus();
return;
}
#endregion
if (txtGeneralRequirementId.Text.Trim().Length == 0)
{
//提交添加
//封装对象
GeneralRequirement objGeneralRequirement = new GeneralRequirement()
{
ProjectId = Convert.ToInt32(txtProjectId.Text.Trim()),
TypeId = Convert.ToInt32(cobTypeName.SelectedValue),
InputPower = cobInputPower.Text,
MARVEL = cobMARVEL.Text,
ANSULPrePipe = cobANSULPrepipe.Text,
ANSULSystem = cobANSULSystem.Text,
RiskLevel = Convert.ToInt32(cobRiskLevel.Text)
};
//提交添加
try
{
int GeneralRequirementId = objRequirementService.AddGeneralRequirement(objGeneralRequirement);
if (GeneralRequirementId > 1)
{
//提示添加成功
MessageBox.Show("通用技术要求添加成功", "提示信息");
//刷新显示
btnGeneralRequirement.Text = "修改通用技术要求";
txtGeneralRequirementId.Text = GeneralRequirementId.ToString();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
//封装对象
GeneralRequirement objGeneralRequirement = new GeneralRequirement()
{
GeneralRequirementId = Convert.ToInt32(txtGeneralRequirementId.Text.Trim()),
ProjectId = Convert.ToInt32(txtProjectId.Text.Trim()),
TypeId = Convert.ToInt32(cobTypeName.SelectedValue),
InputPower = cobInputPower.Text,
MARVEL = cobMARVEL.Text,
ANSULPrePipe = cobANSULPrepipe.Text,
ANSULSystem = cobANSULSystem.Text,
RiskLevel = Convert.ToInt32(cobRiskLevel.Text)
};
//提交修改
//调用后台方法修改对象
try
{
if (objRequirementService.EditGeneralRequirement(objGeneralRequirement) == 1)
{
MessageBox.Show("修改通用技术要求成功！", "提示信息");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
