/// <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); } }