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