/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.CLASSBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CLASSBASE(");
strSql.Append("HEADTEACHERID,GRADEID,NAME,KIDCOUNT)");
strSql.Append(" values (");
strSql.Append("@HEADTEACHERID,@GRADEID,@NAME,@KIDCOUNT)");
OleDbParameter[] parameters = {
new OleDbParameter("@HEADTEACHERID", OleDbType.SmallInt),
new OleDbParameter("@GRADEID", OleDbType.SmallInt),
new OleDbParameter("@NAME", OleDbType.VarChar,30),
new OleDbParameter("@KIDCOUNT", OleDbType.SmallInt)};
parameters[0].Value = model.HEADTEACHERID;
parameters[1].Value = model.GRADEID;
parameters[2].Value = model.NAME;
parameters[3].Value = model.KIDCOUNT;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.CLASSCOURSE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CLASSCOURSE(");
strSql.Append("CLASSID,COURSEID,ATTENDANCE,TEACHERID,SUMMARY)");
strSql.Append(" values (");
strSql.Append("@CLASSID,@COURSEID,@ATTENDANCE,@TEACHERID,@SUMMARY)");
OleDbParameter[] parameters = {
new OleDbParameter("@CLASSID", OleDbType.SmallInt),
new OleDbParameter("@COURSEID", OleDbType.SmallInt),
new OleDbParameter("@ATTENDANCE", OleDbType.Double),
new OleDbParameter("@TEACHERID", OleDbType.SmallInt),
new OleDbParameter("@SUMMARY", OleDbType.VarChar,255)};
parameters[0].Value = model.CLASSID;
parameters[1].Value = model.COURSEID;
parameters[2].Value = model.ATTENDANCE;
parameters[3].Value = model.TEACHERID;
parameters[4].Value = model.SUMMARY;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.KIDPAYMENT model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into KIDPAYMENT(");
strSql.Append("KIDID,CHARGEID,PAYMENT,PAYDATE)");
strSql.Append(" values (");
strSql.Append("@KIDID,@CHARGEID,@PAYMENT,@PAYDATE)");
OleDbParameter[] parameters = {
new OleDbParameter("@KIDID", OleDbType.SmallInt),
new OleDbParameter("@CHARGEID", OleDbType.SmallInt),
new OleDbParameter("@PAYMENT", OleDbType.Double),
new OleDbParameter("@PAYDATE", OleDbType.Date)};
parameters[0].Value = model.KIDID;
parameters[1].Value = model.CHARGEID;
parameters[2].Value = model.PAYMENT;
parameters[3].Value = model.PAYDATE;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.KIDCOURSE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into KIDCOURSE(");
strSql.Append("KIDID,COURSEID,ATTENDANCE,PERFORMANCE,CREDIT)");
strSql.Append(" values (");
strSql.Append("@KIDID,@COURSEID,@ATTENDANCE,@PERFORMANCE,@CREDIT)");
OleDbParameter[] parameters = {
new OleDbParameter("@KIDID", OleDbType.SmallInt),
new OleDbParameter("@COURSEID", OleDbType.SmallInt),
new OleDbParameter("@ATTENDANCE", OleDbType.Double),
new OleDbParameter("@PERFORMANCE", OleDbType.VarChar,255),
new OleDbParameter("@CREDIT", OleDbType.SmallInt)};
parameters[0].Value = model.KIDID;
parameters[1].Value = model.COURSEID;
parameters[2].Value = model.ATTENDANCE;
parameters[3].Value = model.PERFORMANCE;
parameters[4].Value = model.CREDIT;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.CHARGEBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into CHARGEBASE(");
strSql.Append("NAME,GRADEID,CHARGE,CHARGEDATE,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@NAME,@GRADEID,@CHARGE,@CHARGEDATE,@DESCRIPTION)");
OleDbParameter[] parameters = {
new OleDbParameter("@NAME", OleDbType.VarChar,255),
new OleDbParameter("@GRADEID", OleDbType.Integer,4),
new OleDbParameter("@CHARGE", OleDbType.Integer,4),
new OleDbParameter("@CHARGEDATE", OleDbType.Date),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255)};
parameters[0].Value = model.NAME;
parameters[1].Value = model.GRADEID;
parameters[2].Value = model.CHARGE;
parameters[3].Value = model.CHARGEDATE;
parameters[4].Value = model.DESCRIPTION;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.KIDATTENDANCE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into KIDATTENDANCE(");
strSql.Append("KIDID,COURSEID,ISATTEND,ATTENDDATE,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@KIDID,@COURSEID,@ISATTEND,@ATTENDDATE,@DESCRIPTION)");
OleDbParameter[] parameters = {
new OleDbParameter("@KIDID", OleDbType.SmallInt),
new OleDbParameter("@COURSEID", OleDbType.SmallInt),
new OleDbParameter("@ISATTEND", OleDbType.Boolean,1),
new OleDbParameter("@ATTENDDATE", OleDbType.Date),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255)};
parameters[0].Value = model.KIDID;
parameters[1].Value = model.COURSEID;
parameters[2].Value = model.ISATTEND;
parameters[3].Value = model.ATTENDDATE;
parameters[4].Value = model.DESCRIPTION;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.KIDCMDRECORD model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into KIDCMDRECORD(");
strSql.Append("KIDID,COMMAND,USERNAME)");
strSql.Append(" values (");
strSql.Append("@KIDID,@COMMAND,@USERNAME)");
OleDbParameter[] parameters = {
new OleDbParameter("@KIDID", OleDbType.SmallInt),
new OleDbParameter("@COMMAND", OleDbType.VarChar,255),
new OleDbParameter("@USERNAME", OleDbType.VarChar,255)};
parameters[0].Value = model.KIDID;
parameters[1].Value = model.COMMAND;
parameters[2].Value = model.USERNAME;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.TEACHERBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into TEACHERBASE(");
strSql.Append("JOBNUMBER,NAME,SEX,PHOTO,PHONE,EXPHONE,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@JOBNUMBER,@NAME,@SEX,@PHOTO,@PHONE,@EXPHONE,@DESCRIPTION)");
OleDbParameter[] parameters = {
new OleDbParameter("@JOBNUMBER", OleDbType.VarChar,255),
new OleDbParameter("@NAME", OleDbType.VarChar,30),
new OleDbParameter("@SEX", OleDbType.Boolean,1),
new OleDbParameter("@PHOTO", OleDbType.Binary,0),
new OleDbParameter("@PHONE", OleDbType.VarChar,20),
new OleDbParameter("@EXPHONE", OleDbType.VarChar,20),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255)};
parameters[0].Value = model.JOBNUMBER;
parameters[1].Value = model.NAME;
parameters[2].Value = model.SEX;
parameters[3].Value = model.PHOTO;
parameters[4].Value = model.PHONE;
parameters[5].Value = model.EXPHONE;
parameters[6].Value = model.DESCRIPTION;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.DEVICEBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into DEVICEBASE(");
strSql.Append("NAME,FUNDING,LOSSINFO,PURCHASEPLAN,INVESTMENT,PURCHASEDATE,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@NAME,@FUNDING,@LOSSINFO,@PURCHASEPLAN,@INVESTMENT,@PURCHASEDATE,@DESCRIPTION)");
OleDbParameter[] parameters = {
new OleDbParameter("@NAME", OleDbType.VarChar,50),
new OleDbParameter("@FUNDING", OleDbType.Double),
new OleDbParameter("@LOSSINFO", OleDbType.VarChar,255),
new OleDbParameter("@PURCHASEPLAN", OleDbType.VarChar,255),
new OleDbParameter("@INVESTMENT", OleDbType.Double),
new OleDbParameter("@PURCHASEDATE", OleDbType.Date),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255)};
parameters[0].Value = model.NAME;
parameters[1].Value = model.FUNDING;
parameters[2].Value = model.LOSSINFO;
parameters[3].Value = model.PURCHASEPLAN;
parameters[4].Value = model.INVESTMENT;
parameters[5].Value = model.PURCHASEDATE;
parameters[6].Value = model.DESCRIPTION;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.GRADEBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into GRADEBASE(");
strSql.Append("NAME,HEADTEACHERID,TUITION,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@NAME,@HEADTEACHERID,@TUITION,@DESCRIPTION)");
OleDbParameter[] parameters = {
new OleDbParameter("@NAME", OleDbType.VarChar,255),
new OleDbParameter("@HEADTEACHERID", OleDbType.Integer,4),
new OleDbParameter("@TUITION", OleDbType.Integer,4),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255)};
parameters[0].Value = model.NAME;
parameters[1].Value = model.HEADTEACHERID;
parameters[2].Value = model.TUITION;
parameters[3].Value = model.DESCRIPTION;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.MEETINGBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into MEETINGBASE(");
strSql.Append("NAME,DESCRITION,MEETINGDATE,ATTENDANCE,SUMMARY)");
strSql.Append(" values (");
strSql.Append("@NAME,@DESCRITION,@MEETINGDATE,@ATTENDANCE,@SUMMARY)");
OleDbParameter[] parameters = {
new OleDbParameter("@NAME", OleDbType.VarChar,255),
new OleDbParameter("@DESCRITION", OleDbType.VarChar,255),
new OleDbParameter("@MEETINGDATE", OleDbType.Date),
new OleDbParameter("@ATTENDANCE", OleDbType.Double),
new OleDbParameter("@SUMMARY", OleDbType.VarChar,255)};
parameters[0].Value = model.NAME;
parameters[1].Value = model.DESCRITION;
parameters[2].Value = model.MEETINGDATE;
parameters[3].Value = model.ATTENDANCE;
parameters[4].Value = model.SUMMARY;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.USERBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into USERBASE(");
strSql.Append("USERNAME,PWD,ROLEID)");
strSql.Append(" values (");
strSql.Append("@USERNAME,@PWD,@ROLEID)");
OleDbParameter[] parameters = {
new OleDbParameter("@USERNAME", OleDbType.VarChar,50),
new OleDbParameter("@PWD", OleDbType.VarChar,255),
new OleDbParameter("@ROLEID", OleDbType.SmallInt)};
parameters[0].Value = model.USERNAME;
parameters[1].Value = model.PWD;
parameters[2].Value = model.ROLEID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.KIDBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into KIDBASE(");
strSql.Append("STUDENTID,GURDIANID,NAME,AGE,HEIGHT,WEIGHT,SEX,INDATE,INSURANCE,CLASSID,PHOTO,MEDICALRECORD,TRANSFERRECORD,SHUTTLEROUTE,TEACHERADVICE)");
strSql.Append(" values (");
strSql.Append("@STUDENTID,@GURDIANID,@NAME,@AGE,@HEIGHT,@WEIGHT,@SEX,@INDATE,@INSURANCE,@CLASSID,@PHOTO,@MEDICALRECORD,@TRANSFERRECORD,@SHUTTLEROUTE,@TEACHERADVICE)");
OleDbParameter[] parameters = {
new OleDbParameter("@STUDENTID", OleDbType.VarChar,255),
new OleDbParameter("@GURDIANID", OleDbType.Integer,4),
new OleDbParameter("@NAME", OleDbType.VarChar,30),
new OleDbParameter("@AGE", OleDbType.SmallInt),
new OleDbParameter("@HEIGHT", OleDbType.Double),
new OleDbParameter("@WEIGHT", OleDbType.Double),
new OleDbParameter("@SEX", OleDbType.Boolean,1),
new OleDbParameter("@INDATE", OleDbType.Date),
new OleDbParameter("@INSURANCE", OleDbType.Double),
new OleDbParameter("@CLASSID", OleDbType.SmallInt),
new OleDbParameter("@PHOTO", OleDbType.Binary,0),
new OleDbParameter("@MEDICALRECORD", OleDbType.VarChar,255),
new OleDbParameter("@TRANSFERRECORD", OleDbType.VarChar,255),
new OleDbParameter("@SHUTTLEROUTE", OleDbType.VarChar,255),
new OleDbParameter("@TEACHERADVICE", OleDbType.VarChar,255)};
parameters[0].Value = model.STUDENTID;
parameters[1].Value = model.GURDIANID;
parameters[2].Value = model.NAME;
parameters[3].Value = model.AGE;
parameters[4].Value = model.HEIGHT;
parameters[5].Value = model.WEIGHT;
parameters[6].Value = model.SEX;
parameters[7].Value = model.INDATE;
parameters[8].Value = model.INSURANCE;
parameters[9].Value = model.CLASSID;
parameters[10].Value = model.PHOTO;
parameters[11].Value = model.MEDICALRECORD;
parameters[12].Value = model.TRANSFERRECORD;
parameters[13].Value = model.SHUTTLEROUTE;
parameters[14].Value = model.TEACHERADVICE;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.GURDIANBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into GURDIANBASE(");
strSql.Append("RELATIONSHIP,NAME,IDNUMBER,AGE,SEX,PHOTO,PHONE,EXPHONE,ADDRESS,FAMILYINFO)");
strSql.Append(" values (");
strSql.Append("@RELATIONSHIP,@NAME,@IDNUMBER,@AGE,@SEX,@PHOTO,@PHONE,@EXPHONE,@ADDRESS,@FAMILYINFO)");
OleDbParameter[] parameters = {
new OleDbParameter("@RELATIONSHIP", OleDbType.VarChar,20),
new OleDbParameter("@NAME", OleDbType.VarChar,30),
new OleDbParameter("@IDNUMBER", OleDbType.VarChar,20),
new OleDbParameter("@AGE", OleDbType.SmallInt),
new OleDbParameter("@SEX", OleDbType.Boolean,1),
new OleDbParameter("@PHOTO", OleDbType.Binary,0),
new OleDbParameter("@PHONE", OleDbType.VarChar,20),
new OleDbParameter("@EXPHONE", OleDbType.VarChar,20),
new OleDbParameter("@ADDRESS", OleDbType.VarChar,255),
new OleDbParameter("@FAMILYINFO", OleDbType.VarChar,255)};
parameters[0].Value = model.RELATIONSHIP;
parameters[1].Value = model.NAME;
parameters[2].Value = model.IDNUMBER;
parameters[3].Value = model.AGE;
parameters[4].Value = model.SEX;
parameters[5].Value = model.PHOTO;
parameters[6].Value = model.PHONE;
parameters[7].Value = model.EXPHONE;
parameters[8].Value = model.ADDRESS;
parameters[9].Value = model.FAMILYINFO;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.ROLEBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into ROLEBASE(");
strSql.Append("NAME,DESCRIPTION)");
strSql.Append(" values (");
strSql.Append("@NAME,@DESCRIPTION)");
OleDbParameter[] parameters = {
new OleDbParameter("@NAME", OleDbType.VarChar,255),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255)};
parameters[0].Value = model.NAME;
parameters[1].Value = model.DESCRIPTION;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.ROLEBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update ROLEBASE set ");
strSql.Append("NAME=@NAME,");
strSql.Append("DESCRIPTION=@DESCRIPTION");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@NAME", OleDbType.VarChar,255),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.NAME;
parameters[1].Value = model.DESCRIPTION;
parameters[2].Value = model.ID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.CLASSBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update CLASSBASE set ");
strSql.Append("HEADTEACHERID=@HEADTEACHERID,");
strSql.Append("GRADEID=@GRADEID,");
strSql.Append("NAME=@NAME,");
strSql.Append("KIDCOUNT=@KIDCOUNT");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@HEADTEACHERID", OleDbType.SmallInt),
new OleDbParameter("@GRADEID", OleDbType.SmallInt),
new OleDbParameter("@NAME", OleDbType.VarChar,30),
new OleDbParameter("@KIDCOUNT", OleDbType.SmallInt),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.HEADTEACHERID;
parameters[1].Value = model.GRADEID;
parameters[2].Value = model.NAME;
parameters[3].Value = model.KIDCOUNT;
parameters[4].Value = model.ID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.KIDPAYMENT model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.KIDATTENDANCE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update KIDATTENDANCE set ");
strSql.Append("KIDID=@KIDID,");
strSql.Append("COURSEID=@COURSEID,");
strSql.Append("ISATTEND=@ISATTEND,");
strSql.Append("ATTENDDATE=@ATTENDDATE,");
strSql.Append("DESCRIPTION=@DESCRIPTION");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@KIDID", OleDbType.SmallInt),
new OleDbParameter("@COURSEID", OleDbType.SmallInt),
new OleDbParameter("@ISATTEND", OleDbType.Boolean,1),
new OleDbParameter("@ATTENDDATE", OleDbType.Date),
new OleDbParameter("@DESCRIPTION", OleDbType.VarChar,255),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.KIDID;
parameters[1].Value = model.COURSEID;
parameters[2].Value = model.ISATTEND;
parameters[3].Value = model.ATTENDDATE;
parameters[4].Value = model.DESCRIPTION;
parameters[5].Value = model.ID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.GURDIANATTENDANCE model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.KIDCOURSE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update KIDCOURSE set ");
strSql.Append("KIDID=@KIDID,");
strSql.Append("COURSEID=@COURSEID,");
strSql.Append("ATTENDANCE=@ATTENDANCE,");
strSql.Append("PERFORMANCE=@PERFORMANCE,");
strSql.Append("CREDIT=@CREDIT");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@KIDID", OleDbType.SmallInt),
new OleDbParameter("@COURSEID", OleDbType.SmallInt),
new OleDbParameter("@ATTENDANCE", OleDbType.Double),
new OleDbParameter("@PERFORMANCE", OleDbType.VarChar,255),
new OleDbParameter("@CREDIT", OleDbType.SmallInt),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.KIDID;
parameters[1].Value = model.COURSEID;
parameters[2].Value = model.ATTENDANCE;
parameters[3].Value = model.PERFORMANCE;
parameters[4].Value = model.CREDIT;
parameters[5].Value = model.ID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.KIDBASE model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.GURDIANATTENDANCE model)
{
return dal.Update(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.KIDBASE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update KIDBASE set ");
strSql.Append("STUDENTID=@STUDENTID,");
strSql.Append("GURDIANID=@GURDIANID,");
strSql.Append("NAME=@NAME,");
strSql.Append("AGE=@AGE,");
strSql.Append("HEIGHT=@HEIGHT,");
strSql.Append("WEIGHT=@WEIGHT,");
strSql.Append("SEX=@SEX,");
strSql.Append("INDATE=@INDATE,");
strSql.Append("INSURANCE=@INSURANCE,");
strSql.Append("CLASSID=@CLASSID,");
strSql.Append("PHOTO=@PHOTO,");
strSql.Append("MEDICALRECORD=@MEDICALRECORD,");
strSql.Append("TRANSFERRECORD=@TRANSFERRECORD,");
strSql.Append("SHUTTLEROUTE=@SHUTTLEROUTE,");
strSql.Append("TEACHERADVICE=@TEACHERADVICE");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@STUDENTID", OleDbType.VarChar,255),
new OleDbParameter("@GURDIANID", OleDbType.Integer,4),
new OleDbParameter("@NAME", OleDbType.VarChar,30),
new OleDbParameter("@AGE", OleDbType.SmallInt),
new OleDbParameter("@HEIGHT", OleDbType.Double),
new OleDbParameter("@WEIGHT", OleDbType.Double),
new OleDbParameter("@SEX", OleDbType.Boolean,1),
new OleDbParameter("@INDATE", OleDbType.Date),
new OleDbParameter("@INSURANCE", OleDbType.Double),
new OleDbParameter("@CLASSID", OleDbType.SmallInt),
new OleDbParameter("@PHOTO", OleDbType.Binary,0),
new OleDbParameter("@MEDICALRECORD", OleDbType.VarChar,255),
new OleDbParameter("@TRANSFERRECORD", OleDbType.VarChar,255),
new OleDbParameter("@SHUTTLEROUTE", OleDbType.VarChar,255),
new OleDbParameter("@TEACHERADVICE", OleDbType.VarChar,255),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.STUDENTID;
parameters[1].Value = model.GURDIANID;
parameters[2].Value = model.NAME;
parameters[3].Value = model.AGE;
parameters[4].Value = model.HEIGHT;
parameters[5].Value = model.WEIGHT;
parameters[6].Value = model.SEX;
parameters[7].Value = model.INDATE;
parameters[8].Value = model.INSURANCE;
parameters[9].Value = model.CLASSID;
parameters[10].Value = model.PHOTO;
parameters[11].Value = model.MEDICALRECORD;
parameters[12].Value = model.TRANSFERRECORD;
parameters[13].Value = model.SHUTTLEROUTE;
parameters[14].Value = model.TEACHERADVICE;
parameters[15].Value = model.ID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.KIDBASE model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.KIDPAYMENT model)
{
return dal.Add(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.KIDPAYMENT model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update KIDPAYMENT set ");
strSql.Append("KIDID=@KIDID,");
strSql.Append("CHARGEID=@CHARGEID,");
strSql.Append("PAYMENT=@PAYMENT,");
strSql.Append("PAYDATE=@PAYDATE");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@KIDID", OleDbType.SmallInt),
new OleDbParameter("@CHARGEID", OleDbType.SmallInt),
new OleDbParameter("@PAYMENT", OleDbType.Double),
new OleDbParameter("@PAYDATE", OleDbType.Date),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.KIDID;
parameters[1].Value = model.CHARGEID;
parameters[2].Value = model.PAYMENT;
parameters[3].Value = model.PAYDATE;
parameters[4].Value = model.ID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.CLASSCOURSE model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update CLASSCOURSE set ");
strSql.Append("CLASSID=@CLASSID,");
strSql.Append("COURSEID=@COURSEID,");
strSql.Append("ATTENDANCE=@ATTENDANCE,");
strSql.Append("TEACHERID=@TEACHERID,");
strSql.Append("SUMMARY=@SUMMARY");
strSql.Append(" where ID=@ID");
OleDbParameter[] parameters = {
new OleDbParameter("@CLASSID", OleDbType.SmallInt),
new OleDbParameter("@COURSEID", OleDbType.SmallInt),
new OleDbParameter("@ATTENDANCE", OleDbType.Double),
new OleDbParameter("@TEACHERID", OleDbType.SmallInt),
new OleDbParameter("@SUMMARY", OleDbType.VarChar,255),
new OleDbParameter("@ID", OleDbType.Integer,4)};
parameters[0].Value = model.CLASSID;
parameters[1].Value = model.COURSEID;
parameters[2].Value = model.ATTENDANCE;
parameters[3].Value = model.TEACHERID;
parameters[4].Value = model.SUMMARY;
parameters[5].Value = model.ID;
int rows=DbHelperOleDb.ExecuteSql(strSql.ToString(),parameters);
if (rows > 0)
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ForKids.DB.Model.CLASSCOURSE model)
{
return dal.Update(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(ForKids.DB.Model.CLASSCOURSE model)
{
return dal.Add(model);
}
