/// <summary>
/// 查询数据
/// </summary>
private void readData()
{
if (this._nodeno > 0)
{
BLL.WORKNODE worknodebll = new BLL.WORKNODE();
Model.WORKNODE worknodemdl = new Model.WORKNODE();
worknodemdl = worknodebll.GetModel(_nodeno);
if (worknodemdl == null) //新增工作节点功能时
{
blankData();
}
else //修改工作节点功能时
{
this.te_nodename.Text = worknodemdl.NODENAME;
this.te_memo.Text = worknodemdl.MEMO;
}
}
}
/// <summary>
/// 查询数据
/// </summary>
private void ReadData(string nodename)
{
string condition = "";
BLL.WORKNODE worknodeBll = new BLL.WORKNODE();
Model.WORKNODE worknodeMdl = new Model.WORKNODE();
worknodeMdl = worknodeBll.GetModel(nodename);
int worknodeno = worknodeMdl.NODENO;
if (worknodeno > 0)
{
BLL.NODEMATERIALS nodematerialsBll = new BLL.NODEMATERIALS();
condition = " D.NODENAME = '" + nodename + "'";
this.gc_nodematerials.DataSource = nodematerialsBll.GetList(condition).Tables[0];
this.gridView1.BestFitColumns();
DBUtility.ToolHelper.DrawRowIndicator(gridView1, 40);
DBUtility.ToolHelper.SetLineColorofGridView(this.gridView1);
}
}
/// <summary>
/// 初始化左侧列表工作节点数据
/// </summary>
private void init_node()
{
//初始化工作节点列表数据
BLL.WORKNODE worknodeBll = new BLL.WORKNODE();
Model.WORKNODE worknodeMdl = new Model.WORKNODE();
clbc_node.Items.Clear();
List <Model.WORKNODE> worknodeList = new List <Model.WORKNODE>();
worknodeList = worknodeBll.GetModelList("");
foreach (Model.WORKNODE l in worknodeList)
{
clbc_node.Items.Add(l.NODENAME);
}
//默认显示第一个工作流的节点数据
if (clbc_node.Items.Count > 0)
{
string worknodename = clbc_node.Items[0].Value.ToString();
ReadData(worknodename);
}
}
/// <summary>
/// 保存数据方法
/// </summary>
/// <returns></returns>
private bool saveData()
{
try
{
BLL.WORKNODE worknodebll = new BLL.WORKNODE();
Model.WORKNODE worknodemdl = new Model.WORKNODE();
if (this.te_nodename.Text == "")
{
MessageBox.Show("工作节点名称不能为空!", "提示信息");
return(false);
}
if (this._enumStatus == StatusClass.AddNew) //新增工作节点
{
worknodemdl.NODENAME = this.te_nodename.Text;
worknodemdl.MEMO = this.te_memo.Text;
worknodebll.Add(worknodemdl);
return(true);
}
else if (this._enumStatus == StatusClass.Edit) //修改工作节点
{
worknodemdl.NODENO = this._nodeno;
worknodemdl.NODENAME = this.te_nodename.Text;
worknodemdl.MEMO = this.te_memo.Text;
worknodebll.Update(worknodemdl);
return(true);
}
return(true);
}
catch (Exception exception)
{
MessageBox.Show("保存失败!", exception.Message);
return(false);
}
}
//新增时初始化节点列表
public void init()
{
BLL.MATERIAL_INFO materialBll = new BLL.MATERIAL_INFO();
Model.MATERIAL_INFO materialMdl = new Model.MATERIAL_INFO();
BLL.WORKNODE worknodeBll = new BLL.WORKNODE();
Model.WORKNODE worknodeMdl = new Model.WORKNODE();
BLL.TEACHER_INFO teacherBll = new BLL.TEACHER_INFO();
Model.TEACHER_INFO teacherMdl = new Model.TEACHER_INFO();
if (_enumStatus == StatusClass.AddNew)
{
//初始化材料名称下拉列表数据
worknodeMdl = worknodeBll.GetModel(nodematerialsaddMdl.NODENAME);
int nodeno = worknodeMdl.NODENO;
DataSet materialds = materialBll.GetList(" MATERIALNO not in(select MATERIALNO from NODEMATERIALS where NODENO = " + nodeno.ToString() + " and MATERIALNO is not null)");
this.cbb_materialname.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
cbb_materialname.Properties.Items.Clear();
cbb_materialname.EditValue = null;
cbb_materialname.Properties.NullText = "--请选择--";
for (int i = 0; i < materialds.Tables[0].Rows.Count; i++)
{
string materialname = materialds.Tables[0].Rows[i]["MATERIALNAME"].ToString();
this.cbb_materialname.Properties.Items.Add(materialname);
}
//初始化教师姓名下拉列表数据
DataSet teacherds = teacherBll.GetAllList();
this.cbb_name.Properties.Items.Clear();
cbb_name.EditValue = null;
cbb_name.Properties.NullText = "--请选择--";
for (int i = 0; i < teacherds.Tables[0].Rows.Count; i++)
{
string teachername = teacherds.Tables[0].Rows[i]["NAME"].ToString();
this.cbb_name.Properties.Items.Add(teachername);
}
}
else if (_enumStatus == StatusClass.Edit)
{
//初始化材料名称下拉列表数据
worknodeMdl = worknodeBll.GetModel(nodematerialsaddMdl.NODENAME);
int nodeno = worknodeMdl.NODENO;
DataSet materialds = materialBll.GetList(" MATERIALNO not in(select MATERIALNO from NODEMATERIALS where NODENO = " + nodeno.ToString() + " and MATERIALNO is not null)");
this.cbb_materialname.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;
cbb_materialname.Properties.Items.Clear();
cbb_materialname.EditValue = nodematerialsaddMdl.MATERIALNAME;
for (int i = 0; i < materialds.Tables[0].Rows.Count; i++)
{
string materialname = materialds.Tables[0].Rows[i]["MATERIALNAME"].ToString();
this.cbb_materialname.Properties.Items.Add(materialname);
}
this.cbb_materialname.Properties.Items.Add(nodematerialsaddMdl.MATERIALNAME);
//初始化教师姓名下拉列表数据
DataSet teacherds = teacherBll.GetAllList();
this.cbb_name.Properties.Items.Clear();
cbb_name.EditValue = nodematerialsaddMdl.NAME;
for (int i = 0; i < teacherds.Tables[0].Rows.Count; i++)
{
string teachername = teacherds.Tables[0].Rows[i]["NAME"].ToString();
this.cbb_name.Properties.Items.Add(teachername);
}
this.te_nodename.Text = nodematerialsaddMdl.NODENAME;
this.de_begintime.Text = nodematerialsaddMdl.BEGINTIME.ToString();
this.de_endtime.Text = nodematerialsaddMdl.ENDTIME.ToString();
this.te_memo.Text = nodematerialsaddMdl.MEMO;
}
}
/// <summary>
/// 保存数据方法
/// </summary>
/// <returns></returns>
private bool saveData()
{
try
{
BLL.MATERIAL_INFO materialBll = new BLL.MATERIAL_INFO();
Model.MATERIAL_INFO materialMdl = new Model.MATERIAL_INFO();
BLL.WORKNODE worknodeBll = new BLL.WORKNODE();
Model.WORKNODE worknodeMdl = new Model.WORKNODE();
BLL.TEACHER_INFO teacherBll = new BLL.TEACHER_INFO();
Model.TEACHER_INFO teacherMdl = new Model.TEACHER_INFO();
BLL.NODEMATERIALS nodematerialsBll = new BLL.NODEMATERIALS();
Model.NODEMATERIALS nodematerialsMdl = new Model.NODEMATERIALS();
if (this.cbb_materialname.Text == "")
{
MessageBox.Show("材料信息不能为空!", "提示信息");
return(false);
}
if (this.cbb_name.Text == "")
{
MessageBox.Show("负责教师不能为空!", "提示信息");
return(false);
}
if (this.de_begintime.Text == "")
{
MessageBox.Show("开始日期不能为空!", "提示信息");
return(false);
}
if (this.de_endtime.Text == "")
{
MessageBox.Show("截止日期不能为空!", "提示信息");
return(false);
}
//获取工作节点编号
worknodeMdl = worknodeBll.GetModel(this.te_nodename.Text);
int nodeno = worknodeMdl.NODENO;
nodematerialsMdl.NODENO = nodeno;
//获取材料编号
materialMdl = materialBll.GetModel(this.cbb_materialname.Text);
nodematerialsMdl.MATERIALNO = materialMdl.MATERIALNO;
//获取教师编号
teacherMdl = teacherBll.GetModel(this.cbb_name.Text);
nodematerialsMdl.TEACHERNO = teacherMdl.TEACHERNO;
nodematerialsMdl.BEGINTIME = ToolHelper.ConvertToDateTime(this.de_begintime.Value);
nodematerialsMdl.ENDTIME = ToolHelper.ConvertToDateTime(this.de_endtime.Value);
nodematerialsMdl.MEMO = this.te_memo.Text;
if (this._enumStatus == StatusClass.AddNew) //新增节点材料信息
{
nodematerialsBll.Add(nodematerialsMdl);
return(true);
}
else if (this._enumStatus == StatusClass.Edit) //修改节点材料信息
{
nodematerialsMdl.NODEMATERIALSNO = _nodematerialsno;
nodematerialsBll.Update(nodematerialsMdl);
return(true);
}
return(true);
}
catch (Exception exception)
{
MessageBox.Show("保存失败!", exception.Message);
return(false);
}
}
/// <summary>
/// 保存数据方法
/// </summary>
/// <returns></returns>
private bool saveData()
{
try
{
BLL.WORKFLOWSET workflowsetbll = new BLL.WORKFLOWSET();
Model.WORKFLOWSET workflowsetmdl = new Model.WORKFLOWSET();
BLL.WORKNODE worknodeBll = new BLL.WORKNODE();
Model.WORKNODE worknodeMdl = new Model.WORKNODE();
BLL.WORKFLOW workflowBll = new BLL.WORKFLOW();
Model.WORKFLOW workflowMdl = new Model.WORKFLOW();
if (this.cbb_nodename.Text == "")
{
MessageBox.Show("工作节点不能为空!", "提示信息");
return(false);
}
if (this.cbb_nodeorder.Text == "")
{
MessageBox.Show("节点顺序不能为空!", "提示信息");
return(false);
}
if (this.de_begintime.Text == "")
{
MessageBox.Show("开始日期不能为空!", "提示信息");
return(false);
}
if (this.de_endtime.Text == "")
{
MessageBox.Show("截止日期不能为空!", "提示信息");
return(false);
}
if (this._enumStatus == StatusClass.AddNew) //新增工作流节点
{
//获取工作流编号
workflowMdl = workflowBll.GetModel(workflowsetaddMdl.WORKFLOWNAME);
int workflowno = workflowMdl.WORKFLOWNO;
workflowsetmdl.WORKFLOWNO = workflowno;
//获取工作节点编号
worknodeMdl = worknodeBll.GetModel(this.cbb_nodename.Text);
workflowsetmdl.NODENO = worknodeMdl.NODENO;
workflowsetmdl.NODEORDER = ToolHelper.ConvertToInt(this.cbb_nodeorder.Text);
workflowsetmdl.BEGINTIME = ToolHelper.ConvertToDateTime(this.de_begintime.Text);
workflowsetmdl.ENDTIME = ToolHelper.ConvertToDateTime(this.de_endtime.Text);
workflowsetbll.Add(workflowsetmdl);
return(true);
}
else if (this._enumStatus == StatusClass.Edit) //修改工作节点
{
//获取工作流编号
workflowMdl = workflowBll.GetModel(workflowsetaddMdl.WORKFLOWNAME);
int workflowno = workflowMdl.WORKFLOWNO;
workflowsetmdl.WORKFLOWNO = workflowno;
worknodeMdl = worknodeBll.GetModel(this.cbb_nodename.Text);
workflowsetmdl.NODENO = worknodeMdl.NODENO;
workflowsetmdl.NODEORDER = ToolHelper.ConvertToInt(this.cbb_nodeorder.Text);
workflowsetmdl.BEGINTIME = ToolHelper.ConvertToDateTime(this.de_begintime.Text);
workflowsetmdl.ENDTIME = ToolHelper.ConvertToDateTime(this.de_endtime.Text);
workflowsetmdl.SETNO = setno;
workflowsetbll.Update(workflowsetmdl);
return(true);
}
return(true);
}
catch (Exception exception)
{
MessageBox.Show("保存失败!", exception.Message);
return(false);
}
}
