/// <summary>
/// 增加一个工作任务
/// </summary>
/// <param name="model">工作任务实体类</param>
/// <returns></returns>
public bool CreateDALWORKTASKS(Model.WORKTASKS model)
{
int zy = int.Parse(System.Web.HttpContext.Current.Session["zyID"].ToString());
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into WORKTASKS(");
strSql.Append("WORKTASK,PROFESSIONALID,TASK_NUMBER)");
strSql.Append(" values(");
strSql.Append(":WORKTASK,:PROFESSIONALID,:TASK_NUMBER)");
OracleParameter[] parameters =
{
new OracleParameter(":WORKTASK", OracleType.NVarChar, 400),
new OracleParameter(":PROFESSIONALID", OracleType.Number, 9),
new OracleParameter(":TASK_NUMBER", OracleType.NVarChar, 8)
};
parameters[0].Value = model.WORKTASK;
parameters[1].Value = zy;
parameters[2].Value = PublicMethod.GetWORKTASKSNO(zy.ToString());
if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新工作任务
/// </summary>
/// <param name="model">工作任务实体类</param>
/// <returns></returns>
public bool UpdateDALWORKTASKS(Model.WORKTASKS model)
{
bool bl = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("update WORKTASKS set ");
strSql.Append("WORKTASK=:WORKTASK,");
//strSql.Append("TASK_NUMBER=:TASK_NUMBER ");
strSql.Append(" where WORKTASKID=:WORKTASKID ");
OracleParameter[] parameters =
{
new OracleParameter(":WORKTASK", OracleType.NVarChar, 200),
//new OracleParameter(":TASK_NUMBER", OracleType.NVarChar,8),
new OracleParameter(":WORKTASKID", OracleType.Number, 9),
};
parameters[0].Value = model.WORKTASK;
//parameters[1].Value = model.TASK_NUMBER;
parameters[1].Value = model.WORKTASKID;
if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
bl = true;
}
else
{
bl = false;
}
return(bl);
}
/// <summary>
/// 删除/禁用一个工作任务
/// </summary>
/// <param name="OperatorID">工作任务ID</param>
/// <returns></returns>
public bool DeleteDALWORKTASKS(Model.WORKTASKS model)
{
bool bl = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("delete WORKTASKS");
strSql.Append(" where WORKTASKID=:WORKTASKID ");
OracleParameter[] parameters =
{
new OracleParameter(":WORKTASKID", OracleType.Number, 9)
};
parameters[0].Value = model.WORKTASKID;
if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
bl = true;
}
else
{
bl = false;
}
return(bl);
}
