/// <summary>
/// 更新工序
/// </summary>
/// <param name="model">工序实体类</param>
/// <returns></returns>
public bool UpdateDALPROCESS_TEMP(Model.PROCESS model)
{
bool bl = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("update PROCESS_TEMP set ");
strSql.Append("NAME=:NAME");
strSql.Append(" where PROCESSID=:PROCESSID ");
OracleParameter[] parameters =
{
new OracleParameter(":NAME", OracleType.NVarChar, 600),
new OracleParameter(":PROCESSID", OracleType.Number, 9),
};
parameters[0].Value = model.NAME;
parameters[1].Value = model.PROCESSID;
if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
bl = true;
}
else
{
bl = false;
}
return(bl);
}
/// <summary>
/// 增加一个工序
/// </summary>
/// <param name="model">工序实体类</param>
/// <returns></returns>
public bool CreateDALPROCESS(Model.PROCESS model)
{
//传参-专业与工作任务
int gzrw = int.Parse(System.Web.HttpContext.Current.Session["gzrwID"].ToString());
int zy = int.Parse(System.Web.HttpContext.Current.Session["zyID"].ToString());
//获取数据库中已经存在的SERIALNUMBER的最大值
DataSet ds = OracleHelper.Query("select SERIALNUMBER from (select SERIALNUMBER from PROCESS where WORKTASKID='" + gzrw + "' order by SERIALNUMBER desc nulls last) where ROWNUM = 1");
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PROCESS(");
strSql.Append("NAME,WORKTASKID,PROFESSIONALID,DANWEIID,ISOMUX,SERIALNUMBER)");
strSql.Append(" values(");
strSql.Append(":NAME,:WORKTASKID,:PROFESSIONALID,:DANWEIID,:ISOMUX,:SERIALNUMBER)");
OracleParameter[] parameters =
{
new OracleParameter(":NAME", OracleType.NVarChar, 200),
new OracleParameter(":WORKTASKID", OracleType.Number, 9),
new OracleParameter(":PROFESSIONALID", OracleType.Number, 9),
new OracleParameter(":DANWEIID", OracleType.Number, 10),
new OracleParameter(":ISOMUX", OracleType.NVarChar, 18),
new OracleParameter(":SERIALNUMBER", OracleType.Number, 9)
};
parameters[0].Value = model.NAME;
parameters[1].Value = gzrw;
parameters[2].Value = zy;
parameters[3].Value = 200000000;
parameters[4].Value = PublicMethod.GetPROCESSNO(gzrw.ToString());
try
{
parameters[5].Value = int.Parse(ds.Tables[0].Rows[0]["SERIALNUMBER"].ToString()) + 1;
}
catch
{
parameters[5].Value = 1;
}
if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一个工序
/// </summary>
/// <param name="model">工序实体类</param>
/// <returns></returns>
public bool CreateDALPROCESS_TEMP(Model.PROCESS model)
{
//传参-专业与工作任务
int gzrw = int.Parse(System.Web.HttpContext.Current.Session["gzrwID"].ToString());
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into PROCESS_TEMP (");
strSql.Append("NAME,WORKTASKID,STATUS,DEPTNUMBER,DATEINPUT,PERSONID)");
strSql.Append(" values(");
strSql.Append(":NAME,:WORKTASKID,:STATUS,:DEPTNUMBER,:DATEINPUT,:PERSONID)");
OracleParameter[] parameters =
{
new OracleParameter(":NAME", OracleType.NVarChar, 600),
new OracleParameter(":WORKTASKID", OracleType.Number, 9),
new OracleParameter(":STATUS", OracleType.NVarChar, 10),
new OracleParameter(":DEPTNUMBER", OracleType.NVarChar, 20),
new OracleParameter(":DATEINPUT", OracleType.DateTime),
new OracleParameter(":PERSONID", OracleType.Number, 9)
};
parameters[0].Value = model.NAME;
parameters[1].Value = gzrw;
parameters[2].Value = "保存";
parameters[3].Value = "000000000";
parameters[4].Value = System.DateTime.Now;
parameters[5].Value = "343";
if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 删除/禁用一个工序
/// </summary>
/// <param name="OperatorID">工序ID</param>
/// <returns></returns>
public bool DeleteDALPROCESS_TEMP(Model.PROCESS model)
{
bool bl = true;
StringBuilder strSql = new StringBuilder();
strSql.Append("delete PROCESS_TEMP");
strSql.Append(" where PROCESSID=:PROCESSID ");
OracleParameter[] parameters =
{
new OracleParameter(":PROCESSID", OracleType.Number, 9)
};
parameters[0].Value = model.PROCESSID;
if (OracleHelper.ExecuteSql(strSql.ToString(), parameters) >= 1)
{
bl = true;
}
else
{
bl = false;
}
return(bl);
}
