/// <summary>
/// 修改PathEmpRelation信息
/// </summary>
/// <param name="pathEmpRelation">线路员工关系类对象</param>
/// <returns>此次操作影响的行数</returns>
public int UpdatePathEmpRelation(PathEmpRelationModel pathEmpRelation,out string strMessage)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@Id",SqlDbType.Int),
new SqlParameter("@PathNo",SqlDbType.VarChar,20),
new SqlParameter("@Empid",SqlDbType.Int),
};
para[0].Value = pathEmpRelation.Id;
para[1].Value = pathEmpRelation.PathNo;
para[2].Value = pathEmpRelation.EmpID;
int result = help.RunProcedureByInt("update_Path_Emp_Relation", para, out strMessage);
return result;
}
/// <summary>
/// 修改PathEmpRelation信息
/// </summary>
/// <returns>返回操作结果 1表示成功</returns>
private int UpdatePathEmpRelation()
{
try
{
//存入日志
LogSave.Messages("[FrmPathEmp]", LogIDType.UserLogID, "修改员工路径关系信息，路线编号："
+ this.tbPathNo.Text + "，员工姓名：" + this.cbEmp.SelectedText.ToString() + "。");
KJ128NModel.PathEmpRelationModel model = new PathEmpRelationModel();
model.Id = Convert.ToInt32(dgvMain.CurrentRow.Cells["Id"].Value.ToString());
if (this.cbEmp.SelectedValue != null)
{
model.EmpID = Convert.ToInt32(this.cbEmp.SelectedValue.ToString());
}
else
{
MessageBox.Show("修改员工信息不存在", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return 0;
}
model.PathNo = this.tbPathNo.Text;
string strMessage = "";
int count = pathEmpRelationbll.UpdatePathEmpRelation(model,out strMessage);
bool flag = (count == 1 ? true : false);
if (flag)
{
this.vspnlAdd.Visible = false;
return 1;
}
else
{
return 0;
}
}
catch
{
return 0;
}
}
/// <summary>
/// 增加PathEmpRelation信息
/// </summary>
/// <param name="pathEmpRelation">线路员工关系类对象</param>
/// <returns>此次操作影响的行数</returns>
public int InsertPathEmpRelation_cjg(PathEmpRelationModel pathEmpRelation)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@PathNo",SqlDbType.VarChar,20),
new SqlParameter("@EmpNo",SqlDbType.VarChar,20),
};
para[0].Value = pathEmpRelation.PathNo;
para[1].Value = pathEmpRelation.EmpNo;
int result = help.RunProcedureByInt("insert_Path_Emp_Relation", para, out outStr);
return result;
}
/// <summary>
/// 修改PathEmpRelation信息
/// </summary>
/// <param name="pathEmpRelation">线路员工关系类对象</param>
/// <returns>此次操作影响的行数</returns>
public int UpdatePathEmpRelation_cjg(PathEmpRelationModel pathEmpRelation)
{
if (pathEmpRelationDal == null)
{
pathEmpRelationDal = new PathEmpRelationDal();
}
string strMessage="";
int result = pathEmpRelationDal.UpdatePathEmpRelation(pathEmpRelation,out strMessage);
return result;
}
/// <summary>
/// 增加PathEmpRelation信息
/// </summary>
/// <param name="pathEmpRelation">线路员工关系类对象</param>
/// <returns>此次操作影响的行数</returns>
public int InsertPathEmpRelation_cjg(PathEmpRelationModel pathEmpRelation)
{
if (pathEmpRelationDal == null)
{
pathEmpRelationDal = new PathEmpRelationDal();
}
int result = pathEmpRelationDal.InsertPathEmpRelation_cjg(pathEmpRelation);
return result;
}
/// <summary>
/// 增加PathEmpRelation信息
/// </summary>
/// <param name="pathEmpRelation">线路员工关系类对象</param>
/// <returns>此次操作影响的行数</returns>
public int InsertPathEmpRelation(PathEmpRelationModel pathEmpRelation,out string strMessage)
{
if (pathEmpRelationDal == null)
{
pathEmpRelationDal = new PathEmpRelationDal();
}
int result = pathEmpRelationDal.InsertPathEmpRelation(pathEmpRelation,out strMessage);
return result;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (Check())
{
PathEmpRelationModel pathEmpModel = new PathEmpRelationModel();
pathEmpModel.PathNo = cmbPathID.Text;
pathEmpModel.EmpID = int.Parse(cmbEmp.SelectedValue.ToString());
string strMessage = "";
int rowCount = 0;
switch (m_type)
{
case 1://添加
try
{
rowCount=pathEmpBll.InsertPathEmpRelation(pathEmpModel, out strMessage);
if (strMessage.Equals("Succeeds"))
{
if (rowCount > 0)
{
SetShowInfo("保存成功", Color.Black);
}
else
{
SetShowInfo("添加重复数据", Color.Red);
return;
}
}
else
{
SetShowInfo("保存失败", Color.Red);
return;
}
}
catch
{
SetShowInfo("保存失败", Color.Red);
return;
}
break;
case 2://修改
pathEmpModel.Id = int.Parse(txtID.Text);
try
{
pathEmpBll.UpdatePathEmpRelation(pathEmpModel,out strMessage);
if (strMessage.Equals("Succeeds"))
{
SetShowInfo("修改成功", Color.Black);
}
else
{
SetShowInfo("修改失败", Color.Red);
return;
}
}
catch
{
SetShowInfo("修改失败", Color.Red);
return;
}
break;
}
if (!New_DBAcess.IsDouble) //单机版，直接刷新
{
m_frmPathManage.SetTreeViewPathEmp();
m_frmPathManage.BindData("");
}
else //热备版，启用定时器
{
m_frmPathManage.HostBackRefresh(true);
}
}
}
