//private void cobODPNo_SelectedIndexChanged(object sender, EventArgs e)
//{
// btnQueryByProjectId_Click(null, null);
//}
/// <summary>
/// 修改计划菜单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsmiEditDrawingPlan_Click(object sender, EventArgs e)
{
if (dgvDrawingPlan.RowCount == 0)
{
return;
}
if (dgvDrawingPlan.CurrentRow == null)
{
MessageBox.Show("请选中需要修改的计划条目", "提示信息");
return;
}
string drawingPlanId = dgvDrawingPlan.CurrentRow.Cells["DrawingPlanId"].Value.ToString();
DrawingPlan objDrawingPlan = objDrawingPlanService.GetDrawingPlanById(drawingPlanId);
//初始化修改信息
grbEditDrawingPlan.Visible = true;//显示修改框
IniModel(cobEditModel);
IniODPNo(cobEditODPNo);
txtEditDrawingPlanId.Text = objDrawingPlan.DrawingPlanId.ToString();
txtEditItem.Text = objDrawingPlan.Item;
txtEditModuleNo.Text = objDrawingPlan.ModuleNo.ToString();
cobEditModel.Text = objDrawingPlan.Model;
cobEditODPNo.Text = objDrawingPlan.ODPNo;
txtEditSubTotalWorkload.Text = objDrawingPlan.SubTotalWorkload.ToString();
dtpEditDrReleaseTarget.Text = objDrawingPlan.DrReleaseTarget.ToShortDateString();
dtpEditAddedDate.Text = objDrawingPlan.AddedDate.ToShortDateString();
}
/// <summary>
/// 根据计划编号返回单条计划记录
/// </summary>
/// <param name="drawingPlanId"></param>
/// <returns></returns>
public DrawingPlan GetDrawingPlanById(string drawingPlanId)
{
string sql = "select DrawingPlanId,UserAccount,DrawingPlan.ProjectId,ODPNo,Item,Model,ModuleNo,DrReleaseTarget,SubTotalWorkload,DrawingPlan.AddedDate,ProjectName from DrawingPlan";
sql += " inner join Projects on DrawingPlan.ProjectId=Projects.ProjectId";
sql += " inner join Users on Users.UserId=Projects.UserId";
sql += string.Format(" where DrawingPlanId = {0}", drawingPlanId);
SqlDataReader objReader = SQLHelper.GetReader(sql);
DrawingPlan objDrawingPlan = null;
if (objReader.Read())
{
objDrawingPlan = new DrawingPlan()
{
DrawingPlanId = Convert.ToInt32(objReader["DrawingPlanId"]),
UserAccount = objReader["UserAccount"].ToString(),
ProjectId = Convert.ToInt32(objReader["ProjectId"]),
ODPNo = objReader["ODPNo"].ToString(),
ProjectName = objReader["ProjectName"].ToString(),
Item = objReader["Item"].ToString(),
Model = objReader["Model"].ToString(),
ModuleNo = Convert.ToInt32(objReader["ModuleNo"]),
DrReleaseTarget = Convert.ToDateTime(objReader["DrReleaseTarget"]),
SubTotalWorkload = Convert.ToDecimal(objReader["SubTotalWorkload"]),
AddedDate = Convert.ToDateTime(objReader["AddedDate"])
};
}
objReader.Close();
return(objDrawingPlan);
}
/// <summary>
/// 修改制图计划记录
/// </summary>
/// <param name="objDrawingPlan"></param>
/// <returns></returns>
public int EditDrawingPlan(DrawingPlan objDrawingPlan)
{
string sql = "update DrawingPlan set ProjectId={0},Item='{1}',Model='{2}',ModuleNo='{3}',";
sql += "DrReleasetarget='{4}',SubTotalWorkload='{5}',AddedDate='{6}' where DrawingPlanId={7}";
sql = string.Format(sql, objDrawingPlan.ProjectId, objDrawingPlan.Item, objDrawingPlan.Model, objDrawingPlan.ModuleNo,
objDrawingPlan.DrReleaseTarget, objDrawingPlan.SubTotalWorkload, objDrawingPlan.AddedDate, objDrawingPlan.DrawingPlanId);
try
{
return(SQLHelper.Update(sql));
}
catch (SqlException ex)
{
throw new Exception("数据库操作出现异常：" + ex.Message);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 添加制图计划
/// </summary>
/// <param name="objDrawingPlan"></param>
/// <returns></returns>
public int AddDraingPlan(DrawingPlan objDrawingPlan)
{
string sql = "insert into DrawingPlan (ProjectId,Item,Model,ModuleNo,DrReleasetarget,SubTotalWorkload)";
sql += " values({0},'{1}','{2}','{3}','{4}','{5}');select @@identity";
sql = string.Format(sql, objDrawingPlan.ProjectId, objDrawingPlan.Item,
objDrawingPlan.Model, objDrawingPlan.ModuleNo, objDrawingPlan.DrReleaseTarget, objDrawingPlan.SubTotalWorkload);
try
{
return(Convert.ToInt32(SQLHelper.GetSingleResult(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 btnEditDrawingPlan_Click(object sender, EventArgs e)
{
#region 数据验证
if (cobEditModel.SelectedIndex == -1)
{
MessageBox.Show("请选择烟罩型号", "验证信息");
cobEditModel.Focus();
return;
}
if (txtEditModuleNo.Text.Trim().Length == 0)
{
MessageBox.Show("请输烟罩分段数量", "验证信息");
txtEditModuleNo.Focus();
return;
}
if (cobEditODPNo.SelectedIndex == -1)
{
MessageBox.Show("请输入选择或输入项目编号，如果没有，请到项目列表中添加后再选择", "验证信息");
cobEditODPNo.Focus();
return;
}
//验证数量是数字
if (!DataValidate.IsInteger(txtEditModuleNo.Text.Trim()))
{
MessageBox.Show("烟罩分段数量必须是数字", "验证信息");
txtEditModuleNo.Focus();
txtEditModuleNo.SelectAll();
return;
}
//验证计划日期大于添加日期
if (DateTime.Compare(dtpEditDrReleaseTarget.Value, dtpEditAddedDate.Value) < 0)
{
MessageBox.Show("计划发图日期必须大于添加日期，请认真检查", "验证信息");
return;
}
#endregion
//封装制图计划对象
DrawingPlan objDrawingPlan = new DrawingPlan()
{
DrawingPlanId = Convert.ToInt32(txtEditDrawingPlanId.Text),
ProjectId = Convert.ToInt32(cobEditODPNo.SelectedValue),
Item = txtEditItem.Text.Trim(),
Model = cobEditModel.Text,
ModuleNo = Convert.ToInt32(txtEditModuleNo.Text.Trim()),
DrReleaseTarget = Convert.ToDateTime(dtpEditDrReleaseTarget.Text),
SubTotalWorkload = Convert.ToDecimal(txtEditSubTotalWorkload.Text.Trim()),
AddedDate = Convert.ToDateTime(dtpEditAddedDate.Text.Trim())
};
//调用后台方法修改对象
try
{
if (objDrawingPlanService.EditDrawingPlan(objDrawingPlan) == 1)
{
MessageBox.Show("修改计划成功！", "提示信息");
grbEditDrawingPlan.Visible = false;
btnQueryAllPlan_Click(null, null);//同步刷新显示数据
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 添加计划记录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAddDrawingPlan_Click(object sender, EventArgs e)
{
#region 数据验证
if (cobModel.SelectedIndex == -1)
{
MessageBox.Show("请选择烟罩型号", "验证信息");
cobModel.Focus();
return;
}
if (txtModuleNo.Text.Trim().Length == 0)
{
MessageBox.Show("请输烟罩分段数量", "验证信息");
txtModuleNo.Focus();
return;
}
if (cobODPNo.SelectedIndex == -1)
{
MessageBox.Show("请输入选择或输入项目编号，如果没有，请到项目列表中添加后再选择", "验证信息");
cobODPNo.Focus();
return;
}
//验证数量是数字
if (!DataValidate.IsInteger(txtModuleNo.Text.Trim()))
{
MessageBox.Show("烟罩分段数量必须是数字", "验证信息");
txtModuleNo.Focus();
txtModuleNo.SelectAll();
return;
}
#endregion
//封装制图计划对象
DrawingPlan objDrawingPlan = new DrawingPlan()
{
ProjectId = Convert.ToInt32(cobODPNo.SelectedValue),
Item = txtItem.Text.Trim(),
Model = cobModel.Text,
ModuleNo = Convert.ToInt32(txtModuleNo.Text.Trim()),
DrReleaseTarget = Convert.ToDateTime(dtpDrReleaseTarget.Text),
SubTotalWorkload = Convert.ToDecimal(txtSubTotalWorkload.Text.Trim())
};
//提交添加
try
{
int drawingPlanId = objDrawingPlanService.AddDraingPlan(objDrawingPlan);
if (drawingPlanId > 1)
{
//提示添加成功
MessageBox.Show("制图计划添加成功", "提示信息");
//刷新显示
btnQueryByProjectId_Click(null, null);
//清空内容
//cobUserId.SelectedIndex = -1;//不清空制图人员
//cobModel.SelectedIndex = -1;//不清空型号
//foreach (Control item in Controls)
//{
// if (item == txtODPNo) return;//不清空ODPNo，方便查询
// if (item is TextBox)
// {
// item.Text = "";
// }
//}
txtSubTotalWorkload.Text = "";
txtModuleNo.Text = "";
txtItem.Text = "";
txtItem.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
