public void Add(SmartCampus.Entity.BASE_STUDENT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into BASE_STUDENT("); strSql.Append("STUDENTID,USERNAME,PWD,SEX,CARDNUMBER,SDATE,EDATE,PHOTO,ADDRESS"); strSql.Append(") values ("); strSql.Append("@STUDENTID,@USERNAME,@PWD,@SEX,@CARDNUMBER,@SDATE,@EDATE,@PHOTO,@ADDRESS"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@STUDENTID", SqlDbType.Int, 4), new SqlParameter("@USERNAME", SqlDbType.VarChar, 12), new SqlParameter("@PWD", SqlDbType.VarChar, 32), new SqlParameter("@SEX", SqlDbType.VarChar, 2), new SqlParameter("@CARDNUMBER", SqlDbType.VarChar, 20), new SqlParameter("@SDATE", SqlDbType.DateTime), new SqlParameter("@EDATE", SqlDbType.DateTime), new SqlParameter("@PHOTO", SqlDbType.VarChar, 200), new SqlParameter("@ADDRESS", SqlDbType.VarChar, 200) }; parameters[0].Value = model.STUDENTID; parameters[1].Value = model.USERNAME; parameters[2].Value = model.PWD; parameters[3].Value = model.SEX; parameters[4].Value = model.CARDNUMBER; parameters[5].Value = model.SDATE; parameters[6].Value = model.EDATE; parameters[7].Value = model.PHOTO; parameters[8].Value = model.ADDRESS; SqlServerHelper.ExecuteSql(strSql.ToString(), parameters); }
public bool Update(SmartCampus.Entity.BASE_STUDENT model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update BASE_STUDENT set "); strSql.Append(" STUDENTID = @STUDENTID , "); strSql.Append(" USERNAME = @USERNAME , "); strSql.Append(" PWD = @PWD , "); strSql.Append(" SEX = @SEX , "); strSql.Append(" CARDNUMBER = @CARDNUMBER , "); strSql.Append(" SDATE = @SDATE , "); strSql.Append(" EDATE = @EDATE , "); strSql.Append(" PHOTO = @PHOTO , "); strSql.Append(" ADDRESS = @ADDRESS "); strSql.Append(" where STUDENTID=@STUDENTID "); SqlParameter[] parameters = { new SqlParameter("@STUDENTID", SqlDbType.Int, 4), new SqlParameter("@USERNAME", SqlDbType.VarChar, 12), new SqlParameter("@PWD", SqlDbType.VarChar, 32), new SqlParameter("@SEX", SqlDbType.VarChar, 2), new SqlParameter("@CARDNUMBER", SqlDbType.VarChar, 20), new SqlParameter("@SDATE", SqlDbType.DateTime), new SqlParameter("@EDATE", SqlDbType.DateTime), new SqlParameter("@PHOTO", SqlDbType.VarChar, 200), new SqlParameter("@ADDRESS", SqlDbType.VarChar, 200) }; parameters[9].Value = model.STUDENTID; parameters[10].Value = model.USERNAME; parameters[11].Value = model.PWD; parameters[12].Value = model.SEX; parameters[13].Value = model.CARDNUMBER; parameters[14].Value = model.SDATE; parameters[15].Value = model.EDATE; parameters[16].Value = model.PHOTO; parameters[17].Value = model.ADDRESS; int rows = SqlServerHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public SmartCampus.Entity.BASE_STUDENT GetEntity(int studentid) { StringBuilder strSql = new StringBuilder(); strSql.Append("select STUDENTID, USERNAME, PWD, SEX, CARDNUMBER, SDATE, EDATE, PHOTO, ADDRESS "); strSql.Append(" from BASE_STUDENT "); strSql.Append(" where STUDENTID=@STUDENTID "); SqlParameter[] parameters = { new SqlParameter("@STUDENTID", SqlDbType.Int, 4) }; parameters[0].Value = studentid; SmartCampus.Entity.BASE_STUDENT model = new SmartCampus.Entity.BASE_STUDENT(); DataSet ds = SqlServerHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["STUDENTID"].ToString() != "") { model.STUDENTID = int.Parse(ds.Tables[0].Rows[0]["STUDENTID"].ToString()); } model.USERNAME = ds.Tables[0].Rows[0]["USERNAME"].ToString(); model.PWD = ds.Tables[0].Rows[0]["PWD"].ToString(); model.SEX = ds.Tables[0].Rows[0]["SEX"].ToString(); model.CARDNUMBER = ds.Tables[0].Rows[0]["CARDNUMBER"].ToString(); if (ds.Tables[0].Rows[0]["SDATE"].ToString() != "") { model.SDATE = DateTime.Parse(ds.Tables[0].Rows[0]["SDATE"].ToString()); } if (ds.Tables[0].Rows[0]["EDATE"].ToString() != "") { model.EDATE = DateTime.Parse(ds.Tables[0].Rows[0]["EDATE"].ToString()); } model.PHOTO = ds.Tables[0].Rows[0]["PHOTO"].ToString(); model.ADDRESS = ds.Tables[0].Rows[0]["ADDRESS"].ToString(); return(model); } else { return(null); } }