/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.S_Student_Info GetModel(int st_id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 st_id,FK_belong_teacher,st_name,st_telphone,st_education,st_sex,st_nation,st_native,st_age,st_long,st_weight,st_class,st_disease,st_school,st_idcard,st_ballage,st_introducer,st_remark,FK_class_level,st_status,create_time,account_amount,student_openid from S_Student_Info ");
strSql.Append(" where st_id=@st_id");
SqlParameter[] parameters =
{
new SqlParameter("@st_id", SqlDbType.Int, 4)
};
parameters[0].Value = st_id;
DTcms.Model.S_Student_Info model = new DTcms.Model.S_Student_Info();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DTcms.Model.S_Student_Info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into S_Student_Info(");
strSql.Append("FK_belong_teacher,st_name,st_telphone,st_education,st_sex,st_nation,st_native,st_age,st_long,st_weight,st_class,st_disease,st_school,st_idcard,st_ballage,st_introducer,st_remark,FK_class_level,st_status,create_time,account_amount,student_openid)");
strSql.Append(" values (");
strSql.Append("@FK_belong_teacher,@st_name,@st_telphone,@st_education,@st_sex,@st_nation,@st_native,@st_age,@st_long,@st_weight,@st_class,@st_disease,@st_school,@st_idcard,@st_ballage,@st_introducer,@st_remark,@FK_class_level,@st_status,@create_time,@account_amount,@student_openid)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@FK_belong_teacher", SqlDbType.Int, 4),
new SqlParameter("@st_name", SqlDbType.NVarChar, 50),
new SqlParameter("@st_telphone", SqlDbType.NVarChar, 50),
new SqlParameter("@st_education", SqlDbType.NVarChar, 50),
new SqlParameter("@st_sex", SqlDbType.NVarChar, 50),
new SqlParameter("@st_nation", SqlDbType.NVarChar, 50),
new SqlParameter("@st_native", SqlDbType.NVarChar, 50),
new SqlParameter("@st_age", SqlDbType.NVarChar, 50),
new SqlParameter("@st_long", SqlDbType.NVarChar, 50),
new SqlParameter("@st_weight", SqlDbType.NVarChar, 50),
new SqlParameter("@st_class", SqlDbType.NVarChar, 50),
new SqlParameter("@st_disease", SqlDbType.NVarChar, 50),
new SqlParameter("@st_school", SqlDbType.NVarChar, 50),
new SqlParameter("@st_idcard", SqlDbType.NVarChar, 50),
new SqlParameter("@st_ballage", SqlDbType.NVarChar, 50),
new SqlParameter("@st_introducer", SqlDbType.NVarChar, 50),
new SqlParameter("@st_remark", SqlDbType.NVarChar, 50),
new SqlParameter("@FK_class_level", SqlDbType.Int, 4),
new SqlParameter("@st_status", SqlDbType.Int, 4),
new SqlParameter("@create_time", SqlDbType.DateTime),
new SqlParameter("@account_amount", SqlDbType.Int, 4),
new SqlParameter("@student_openid", SqlDbType.NVarChar, 50)
};
parameters[0].Value = model.FK_belong_teacher;
parameters[1].Value = model.st_name;
parameters[2].Value = model.st_telphone;
parameters[3].Value = model.st_education;
parameters[4].Value = model.st_sex;
parameters[5].Value = model.st_nation;
parameters[6].Value = model.st_native;
parameters[7].Value = model.st_age;
parameters[8].Value = model.st_long;
parameters[9].Value = model.st_weight;
parameters[10].Value = model.st_class;
parameters[11].Value = model.st_disease;
parameters[12].Value = model.st_school;
parameters[13].Value = model.st_idcard;
parameters[14].Value = model.st_ballage;
parameters[15].Value = model.st_introducer;
parameters[16].Value = model.st_remark;
parameters[17].Value = model.FK_class_level;
parameters[18].Value = model.st_status;
parameters[19].Value = model.create_time;
parameters[20].Value = model.account_amount;
parameters[21].Value = model.student_openid;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DTcms.Model.S_Student_Info DataRowToModel(DataRow row)
{
DTcms.Model.S_Student_Info model = new DTcms.Model.S_Student_Info();
if (row != null)
{
if (row["st_id"] != null && row["st_id"].ToString() != "")
{
model.st_id = int.Parse(row["st_id"].ToString());
}
if (row["FK_belong_teacher"] != null && row["FK_belong_teacher"].ToString() != "")
{
model.FK_belong_teacher = int.Parse(row["FK_belong_teacher"].ToString());
}
if (row["st_name"] != null)
{
model.st_name = row["st_name"].ToString();
}
if (row["st_telphone"] != null)
{
model.st_telphone = row["st_telphone"].ToString();
}
if (row["st_education"] != null)
{
model.st_education = row["st_education"].ToString();
}
if (row["st_sex"] != null)
{
model.st_sex = row["st_sex"].ToString();
}
if (row["st_nation"] != null)
{
model.st_nation = row["st_nation"].ToString();
}
if (row["st_native"] != null)
{
model.st_native = row["st_native"].ToString();
}
if (row["st_age"] != null)
{
model.st_age = row["st_age"].ToString();
}
if (row["st_long"] != null)
{
model.st_long = row["st_long"].ToString();
}
if (row["st_weight"] != null)
{
model.st_weight = row["st_weight"].ToString();
}
if (row["st_class"] != null)
{
model.st_class = row["st_class"].ToString();
}
if (row["st_disease"] != null)
{
model.st_disease = row["st_disease"].ToString();
}
if (row["st_school"] != null)
{
model.st_school = row["st_school"].ToString();
}
if (row["st_idcard"] != null)
{
model.st_idcard = row["st_idcard"].ToString();
}
if (row["st_ballage"] != null)
{
model.st_ballage = row["st_ballage"].ToString();
}
if (row["st_introducer"] != null)
{
model.st_introducer = row["st_introducer"].ToString();
}
if (row["st_remark"] != null)
{
model.st_remark = row["st_remark"].ToString();
}
if (row["FK_class_level"] != null && row["FK_class_level"].ToString() != "")
{
model.FK_class_level = int.Parse(row["FK_class_level"].ToString());
}
if (row["st_status"] != null && row["st_status"].ToString() != "")
{
model.st_status = int.Parse(row["st_status"].ToString());
}
if (row["create_time"] != null && row["create_time"].ToString() != "")
{
model.create_time = DateTime.Parse(row["create_time"].ToString());
}
if (row["account_amount"] != null && row["account_amount"].ToString() != "")
{
model.account_amount = int.Parse(row["account_amount"].ToString());
}
if (row["student_openid"] != null)
{
model.student_openid = row["student_openid"].ToString();
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DTcms.Model.S_Student_Info model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update S_Student_Info set ");
strSql.Append("FK_belong_teacher=@FK_belong_teacher,");
strSql.Append("st_name=@st_name,");
strSql.Append("st_telphone=@st_telphone,");
strSql.Append("st_education=@st_education,");
strSql.Append("st_sex=@st_sex,");
strSql.Append("st_nation=@st_nation,");
strSql.Append("st_native=@st_native,");
strSql.Append("st_age=@st_age,");
strSql.Append("st_long=@st_long,");
strSql.Append("st_weight=@st_weight,");
strSql.Append("st_class=@st_class,");
strSql.Append("st_disease=@st_disease,");
strSql.Append("st_school=@st_school,");
strSql.Append("st_idcard=@st_idcard,");
strSql.Append("st_ballage=@st_ballage,");
strSql.Append("st_introducer=@st_introducer,");
strSql.Append("st_remark=@st_remark,");
strSql.Append("FK_class_level=@FK_class_level,");
strSql.Append("st_status=@st_status,");
strSql.Append("create_time=@create_time,");
strSql.Append("account_amount=@account_amount,");
strSql.Append("student_openid=@student_openid");
strSql.Append(" where st_id=@st_id");
SqlParameter[] parameters =
{
new SqlParameter("@FK_belong_teacher", SqlDbType.Int, 4),
new SqlParameter("@st_name", SqlDbType.NVarChar, 50),
new SqlParameter("@st_telphone", SqlDbType.NVarChar, 50),
new SqlParameter("@st_education", SqlDbType.NVarChar, 50),
new SqlParameter("@st_sex", SqlDbType.NVarChar, 50),
new SqlParameter("@st_nation", SqlDbType.NVarChar, 50),
new SqlParameter("@st_native", SqlDbType.NVarChar, 50),
new SqlParameter("@st_age", SqlDbType.NVarChar, 50),
new SqlParameter("@st_long", SqlDbType.NVarChar, 50),
new SqlParameter("@st_weight", SqlDbType.NVarChar, 50),
new SqlParameter("@st_class", SqlDbType.NVarChar, 50),
new SqlParameter("@st_disease", SqlDbType.NVarChar, 50),
new SqlParameter("@st_school", SqlDbType.NVarChar, 50),
new SqlParameter("@st_idcard", SqlDbType.NVarChar, 50),
new SqlParameter("@st_ballage", SqlDbType.NVarChar, 50),
new SqlParameter("@st_introducer", SqlDbType.NVarChar, 50),
new SqlParameter("@st_remark", SqlDbType.NVarChar, 50),
new SqlParameter("@FK_class_level", SqlDbType.Int, 4),
new SqlParameter("@st_status", SqlDbType.Int, 4),
new SqlParameter("@create_time", SqlDbType.DateTime),
new SqlParameter("@account_amount", SqlDbType.Int, 4),
new SqlParameter("@student_openid", SqlDbType.NVarChar, 50),
new SqlParameter("@st_id", SqlDbType.Int, 4)
};
parameters[0].Value = model.FK_belong_teacher;
parameters[1].Value = model.st_name;
parameters[2].Value = model.st_telphone;
parameters[3].Value = model.st_education;
parameters[4].Value = model.st_sex;
parameters[5].Value = model.st_nation;
parameters[6].Value = model.st_native;
parameters[7].Value = model.st_age;
parameters[8].Value = model.st_long;
parameters[9].Value = model.st_weight;
parameters[10].Value = model.st_class;
parameters[11].Value = model.st_disease;
parameters[12].Value = model.st_school;
parameters[13].Value = model.st_idcard;
parameters[14].Value = model.st_ballage;
parameters[15].Value = model.st_introducer;
parameters[16].Value = model.st_remark;
parameters[17].Value = model.FK_class_level;
parameters[18].Value = model.st_status;
parameters[19].Value = model.create_time;
parameters[20].Value = model.account_amount;
parameters[21].Value = model.student_openid;
parameters[22].Value = model.st_id;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
