/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Student.Model.STUDENT_JOBSTATUS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update STUDENT_JOBSTATUS set ");
strSql.Append("STUNO=@STUNO,");
strSql.Append("ENTNO=@ENTNO,");
strSql.Append("JOBTITLE=@JOBTITLE,");
strSql.Append("SALARY=@SALARY,");
strSql.Append("STATUS=@STATUS,");
strSql.Append("STATUSTIME=@STATUSTIME,");
strSql.Append("IF_CURRENT=@IF_CURRENT,");
strSql.Append("MEMO=@MEMO");
strSql.Append(" where STATUSNO=@STATUSNO");
SqlParameter[] parameters =
{
new SqlParameter("@STUNO", SqlDbType.VarChar, 10),
new SqlParameter("@ENTNO", SqlDbType.Decimal, 9),
new SqlParameter("@JOBTITLE", SqlDbType.VarChar, 100),
new SqlParameter("@SALARY", SqlDbType.Int, 4),
new SqlParameter("@STATUS", SqlDbType.VarChar, 200),
new SqlParameter("@STATUSTIME", SqlDbType.DateTime),
new SqlParameter("@IF_CURRENT", SqlDbType.Int, 4),
new SqlParameter("@MEMO", SqlDbType.VarChar, 2000),
new SqlParameter("@STATUSNO", SqlDbType.Decimal, 9)
};
parameters[0].Value = model.STUNO;
parameters[1].Value = model.ENTNO;
parameters[2].Value = model.JOBTITLE;
parameters[3].Value = model.SALARY;
parameters[4].Value = model.STATUS;
parameters[5].Value = model.STATUSTIME;
parameters[6].Value = model.IF_CURRENT;
parameters[7].Value = model.MEMO;
parameters[8].Value = model.STATUSNO;
int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Student.Model.STUDENT_JOBSTATUS DataRowToModel(DataRow row)
{
Student.Model.STUDENT_JOBSTATUS model = new Student.Model.STUDENT_JOBSTATUS();
if (row != null)
{
if (row["STATUSNO"] != null && row["STATUSNO"].ToString() != "")
{
model.STATUSNO = decimal.Parse(row["STATUSNO"].ToString());
}
if (row["STUNO"] != null)
{
model.STUNO = row["STUNO"].ToString();
}
if (row["ENTNO"] != null && row["ENTNO"].ToString() != "")
{
model.ENTNO = decimal.Parse(row["ENTNO"].ToString());
}
if (row["JOBTITLE"] != null)
{
model.JOBTITLE = row["JOBTITLE"].ToString();
}
if (row["SALARY"] != null && row["SALARY"].ToString() != "")
{
model.SALARY = int.Parse(row["SALARY"].ToString());
}
if (row["STATUS"] != null)
{
model.STATUS = row["STATUS"].ToString();
}
if (row["STATUSTIME"] != null && row["STATUSTIME"].ToString() != "")
{
model.STATUSTIME = DateTime.Parse(row["STATUSTIME"].ToString());
}
if (row["IF_CURRENT"] != null && row["IF_CURRENT"].ToString() != "")
{
model.IF_CURRENT = int.Parse(row["IF_CURRENT"].ToString());
}
if (row["MEMO"] != null)
{
model.MEMO = row["MEMO"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public decimal Add(Student.Model.STUDENT_JOBSTATUS model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into STUDENT_JOBSTATUS(");
strSql.Append("STUNO,ENTNO,JOBTITLE,SALARY,STATUS,STATUSTIME,IF_CURRENT,MEMO)");
strSql.Append(" values (");
strSql.Append("@STUNO,@ENTNO,@JOBTITLE,@SALARY,@STATUS,@STATUSTIME,@IF_CURRENT,@MEMO)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@STUNO", SqlDbType.VarChar, 10),
new SqlParameter("@ENTNO", SqlDbType.Decimal, 9),
new SqlParameter("@JOBTITLE", SqlDbType.VarChar, 100),
new SqlParameter("@SALARY", SqlDbType.Int, 4),
new SqlParameter("@STATUS", SqlDbType.VarChar, 200),
new SqlParameter("@STATUSTIME", SqlDbType.DateTime),
new SqlParameter("@IF_CURRENT", SqlDbType.Int, 4),
new SqlParameter("@MEMO", SqlDbType.VarChar, 2000)
};
parameters[0].Value = model.STUNO;
parameters[1].Value = model.ENTNO;
parameters[2].Value = model.JOBTITLE;
parameters[3].Value = model.SALARY;
parameters[4].Value = model.STATUS;
parameters[5].Value = model.STATUSTIME;
parameters[6].Value = model.IF_CURRENT;
parameters[7].Value = model.MEMO;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToDecimal(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Student.Model.STUDENT_JOBSTATUS GetModel(decimal STATUSNO)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 STATUSNO,STUNO,ENTNO,JOBTITLE,SALARY,STATUS,STATUSTIME,IF_CURRENT,MEMO from STUDENT_JOBSTATUS ");
strSql.Append(" where STATUSNO=@STATUSNO");
SqlParameter[] parameters =
{
new SqlParameter("@STATUSNO", SqlDbType.Decimal)
};
parameters[0].Value = STATUSNO;
Student.Model.STUDENT_JOBSTATUS model = new Student.Model.STUDENT_JOBSTATUS();
DataSet ds = SqlHelper.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
