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