public static int deleteRecord(Manager obj) { string strSQL = "delete from tbmanager where managerid='" + obj.managerid + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int updateRecord(UpImage obj) { string strSQL = "update upImage set savepath='" + obj.savepath + "',magazineId='" + obj.magazineId + "',sequence=" + obj.sequence + ",imageDesc='" + obj.imageDesc + "',uptime='" + obj.uptime + "',articleId='" + obj.articleId + "' where imageId='" + obj.imageId + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteshenqingRecord(yuyuehuiyi obj) { string strSQL = "delete from shenqinghuiyi where huiyiname='" + obj.huiyiname + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(Users obj) { string strSQL = "delete from tbusers where userid='" + obj.userid + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(UpImage obj) { string strSQL = "insert into upImage(imageId,savepath,magazineId,sequence,imageDesc,uptime,articleId) values('" + obj.imageId + "','" + obj.savepath + "','" + obj.magazineId + "'," + obj.sequence + ",'" + obj.imageDesc + "','" + obj.uptime + "','" + obj.articleId + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Magazine obj) { string strSQL = "insert into magazine(magazineId,magazineName,mdescription,magazineKey) values('" + obj.magazineId + "','" + obj.magazineName + "','" + obj.mdescription + "','" + obj.magazineKey + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int updateRecord(Magazine obj) { string strSQL = "update magazine set magazineName='" + obj.magazineName + "',mdescription='" + obj.mdescription + "',magazineKey='" + obj.magazineKey + "' where magazineId='" + obj.magazineId + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(Article obj) { string strSQL = "delete from article where articleId='" + obj.articleId + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int updateRecord(Article obj) { string strSQL = "update article set articleName='" + obj.articleName + "',articleKey='" + obj.articleKey + "',author='" + obj.author + "',adescription='" + obj.adescription + "',limits='" + obj.limits + "',magazineId='" + obj.magazineId + "' where articleId='" + obj.articleId + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int updateRecord(Equip obj) { string strSQL = "update equipment set status='" + obj.status + "' where equipcode='" + obj.equipcode + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Article obj) { string strSQL = "insert into article(articleId,articleName,articleKey,author,adescription,limits,magazineId) values('" + obj.articleId + "','" + obj.articleName + "','" + obj.articleKey + "','" + obj.author + "','" + obj.adescription + "','" + obj.limits + "','" + obj.magazineId + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(Equip obj) { string strSQL = "delete from equipment where equipid='" + obj.equipid + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Equip obj) { string strSQL = "insert into equipment(equipname,location,status,equipcode) values('" + obj.equipname + "','" + obj.location + "','" + obj.status + "','" + obj.equipcode + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int updateRecord(Manager obj) { string strSQL = "update tbmanager set managername='" + obj.managername + "' where managerid='" + obj.managerid + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Admin obj) { string strSQL = "insert into admin(adminname,adminkey,adminphone) values('" + obj.adminname + "','" + obj.adminkey + "','" + obj.adminphone + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Users obj) { string strSQL = "insert into users(username,password) values('" + obj.username + "','" + obj.password + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(Admin obj) { string strSQL = "delete from admin where adminid='" + obj.adminname + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Equiprecord obj) { string strSQL = "insert into equiprecord(equipid,adminname,recorddate) values('" + obj.equipid + "','" + obj.adminname + "','" + obj.recorddate + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(Magazine obj) { string strSQL = "delete from magazine where magazineId='" + obj.magazineId + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(myUser obj) { string strSQL = "insert into myuser(username,userkey,userphone) values('" + obj.username + "','" + obj.userkey + "','" + obj.userphone + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Users obj) { string strSQL = "insert into tbusers(userid,username,userpwd) values('" + obj.userid + "','" + obj.username + "','" + obj.userpwd + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(myUser obj) { string strSQL = "delete from myuser where userid='" + obj.username + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int updateRecord(Users obj) { string strSQL = "update tbusers set username='******' where userid='" + obj.userid + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string j = GridView1.DataKeys[e.RowIndex].Value.ToString(); string sqlstr = "delete from magazine where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; string sqlstr1 = "delete from article where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; string sqlstr2 = "delete from upImage where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; string sqlstr3 = "select* from upImage where magazineId='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'"; DataTable dt = DBOper.execQueryBySQLText(sqlstr3); for (int k = 0; k < dt.Rows.Count; k++) { string path1 = dt.Rows[k]["savepath"].ToString(); File.Delete(path1); } int i = DBOper.execNonQueryBySQLText(sqlstr2); i = DBOper.execNonQueryBySQLText(sqlstr1); if (DBOper.execNonQueryBySQLText(sqlstr) == 1) { BindData(searchCon()); } else { ComTool.Alert("删除失败"); } string dePath = "./image/" + j + "/"; string path = Server.MapPath(dePath); Directory.Delete(path); }
public static int deleteRecord(UpImage obj) { string strSQL = "delete from upImage where imageId='" + obj.imageId + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(roomBook obj) { string strSQL = "insert into roombook(username,roomid,begintime,endtime) values('" + obj.username + "','" + obj.roomid + "','" + obj.begintime + "','" + obj.endtime + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertshenqingRecord(yuyuehuiyi obj) { string strSQL = "insert into shenqinghuiyi(huiyiname,shijian,shenhe) values('" + obj.huiyiname + "','" + obj.shijian + "','" + "0" + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int deleteRecord(roomBook obj) { string strSQL = "delete from roombook where username='******' and roomid = '" + obj.roomid + "' and begintime = '" + obj.begintime + "' and endtime = '" + obj.endtime + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
//public static int delRecord(yuyuehuiyi obj) //{ // string strSQL = "delete from shenqinghuiyi where huiyiid='" + obj.huiyiid + "'"; // int iRet = DBOper.execNonQueryBySQLText(strSQL); // return iRet; //} public static int updateshenheRecord(yuyuehuiyi obj) { string strSQL = "update shenqinghuiyi set shenhe='" + "1" + "' where huiyiname='" + obj.huiyiname + "'"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }
public static int insertRecord(Manager obj) { string strSQL = "insert into tbmanager(managername,managerpwd,telephone) values('" + obj.managername + "','" + obj.managerpwd + "','" + obj.telephone + "')"; int iRet = DBOper.execNonQueryBySQLText(strSQL); return(iRet); }