//删除联系人 public void DeletePerson() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "delete TXL_Persons from TXL_Persons where PersonID=" + _personID + ""; myObj.ExecuteSqlStr();//删除数据 }
//删除分组 public void Delete() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "delete from TXL_Cats where CatName='" + _catName.ToString() + "' and UserID=" + _userID + ""; myObj.ExecuteSqlStr();//删除记录 }
//添加联系人 public void AddPersons() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "insert into TXL_Persons (UserID,PersonName,PersonTel,PersonCel,PersonAddress,PersonQQ,CatId,Remark) values(" + _userID + ",'" + _name + "','" + _tel + "','" + _personCel + "','" + _address + "','" + _qq + "','" + _catId + "','" + _remark + "')"; myObj.ExecuteSqlStr();//确认插入数据 }
//添加分组 public void Add() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "insert into TXL_Cats (UserID,catname) values(" + _userID + ",'" + _catName + "') "; myObj.ExecuteSqlStr();//确认插入数据 }
//删除分组时删除分组内联系人 public void Dele() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "delete [TXL_Person] where UserID=" + _userID + " and CatId=" + _catId + ""; myObj.ExecuteSqlStr(); }
//修改TXL_Persons public void ChangPerson() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "update [TXL_Persons] set PersonName='" + _personName + "',PersonTel='" + _tel + "',PersonCel='" + _personCel + "',PersonAddress='" + _address + "',PersonQQ='" + _qq + "',CatId=" + _catId + ",Remark='" + _remark + "' where PersonId=" + _personId + ""; myObj.ExecuteSqlStr(); }
//注册账号 public void Add() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "insert into TXL_Safe (UserName,Question,Answer) values('" + _userName + "','" + _question + "','" + _answer + "') "; myObj.ExecuteSqlStr();//确认插入数据 }
//编辑分组名称 public void Update() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "update TXL_Cats set catname='" + _catName + "' where UserID=" + _userID + " and CatId=" + _catId + ""; myObj.ExecuteSqlStr();//删除记录 }
//添加账号 public void Add() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "insert into TXL_Users(UserName,Pass) values('" + _userName + "','" + _pass + "')"; myObj.ExecuteSqlStr(); }
//修改ndt委托 public void Changndt() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "update [CONSIGN_ndt] set ndt_no='" + _ndt_no + "',ndt_wtrq='" + _ndt_wtrq + "',ndt_sjdw='" + _ndt_sjdw + "',ndt_wtr='" + _ndt_wtr + "',ndt_sjdwdz='" + _ndt_sjdwdz + "',ndt_tel='" + _ndt_tel + "',ndt_name='" + _ndt_name + "',ndt_jsdw='" + _ndt_jsdw + "',ndt_gcbh='" + _ndt_gcbh + "',ndt_fgcmc='" + _ndt_fgcmc + "',ndt_fgcbh='" + _ndt_fgcbh + "',ndt_gclb='" + _ndt_gclb + "',ndt_jjlx='" + _ndt_jjlx + "',ndt_jjgg='" + _ndt_jjgg + "',ndt_jjjb='" + _ndt_jjjb + "',ndt_cz='" + _ndt_cz + "',ndt_jcsj='" + _ndt_jcsj + "',ndt_hflx='" + _ndt_hflx + "',ndt_hjfs='" + _ndt_hjfs + "',ndt_pkxs='" + _ndt_pkxs + "',ndt_bmzl='" + _ndt_bmzl + "',ndt_jjcs='" + _ndt_jjcs + "',ndt_zjy='" + _ndt_zjy + "',ndt_jcxm='" + _ndt_jcxm + "',ndt_jcbz='" + _ndt_jcbz + "',ndt_hejb='" + _ndt_hejb + "',ndt_jcbi='" + _ndt_jcbi + "',ndt_jcsl='" + _ndt_jcsl + "',ndt_wcrq='" + _ndt_wcrq + "',ndt_sm='" + _ndt_sm + "',ndt_jsr='" + _ndt_jsr + "',ndt_jsrq='" + _ndt_jsrq + "' where ndt_id=" + _ndt_id + ""; myObj.ExecuteSqlStr(); }
//添加工程编号 public void Addndtno() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "insert into CONSIGN_ndt (UserID,ndt_no) values(" + _UserID + ",'" + _ndt_no + "') "; myObj.ExecuteSqlStr();//确认插入数据 }
//添加NDT委托 public void Addcon_ndt() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "insert into CONSIGN_ndt (UserID,ndt_no,ndt_wtrq,ndt_sjdw,ndt_wtr,ndt_sjdwdz,ndt_tel,ndt_name,ndt_jsdw,ndt_gcbh,ndt_fgcmc,ndt_fgcbh,ndt_gclb,ndt_jjlx,ndt_jjgg,ndt_jjjb,ndt_cz,ndt_jcsj,ndt_hflx,ndt_hjfs,ndt_pkxs,ndt_bmzl,ndt_jjcs,ndt_zjy,ndt_jcxm,ndt_jcbz,ndt_hejb,ndt_jcbi,ndt_jcsl,ndt_wcrq,ndt_sm,ndt_jsr,ndt_jsrq) values(" + 10 + ",'" + _ndt_no + "','" + _ndt_wtrq + "','" + _ndt_sjdw + "','" + _ndt_wtr + "','" + _ndt_sjdwdz + "','" + _ndt_tel + "','" + _ndt_name + "','" + _ndt_jsdw + "','" + _ndt_gcbh + "','" + _ndt_fgcmc + "','" + _ndt_fgcbh + "','" + _ndt_gclb + "','" + _ndt_jjlx + "','" + _ndt_jjgg + "','" + _ndt_jjjb + "','" + _ndt_cz + "','" + _ndt_jcsj + "','" + _ndt_hflx + "','" + _ndt_hjfs + "','" + _ndt_pkxs + "','" + _ndt_bmzl + "','" + _ndt_jjcs + "','" + _ndt_zjy + "','" + _ndt_jcxm + "','" + _ndt_jcbz + "','" + _ndt_hejb + "','" + _ndt_jcbi + "','" + _ndt_jcsl + "','" + _ndt_wcrq + "','" + _ndt_sm + "','" + _ndt_jsr + "','" + _ndt_jsrq + "')"; myObj.ExecuteSqlStr();//确认插入数据 }
//编辑分组名称 public void Update() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "update TXL_Cats set catname='" + _catName + "' where UserID=" + _userID + " and CatId="+_catId+""; myObj.ExecuteSqlStr();//删除记录 }
//删除工程 public void Deletendt() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "delete from CONSIGN_ndt where ndt_no='" + _ndt_no + "' and UserID=" + _UserID + ""; myObj.ExecuteSqlStr();//删除记录 }
//添加联系人 public void AddPersons() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "insert into TXL_Persons (UserID,PersonName,PersonTel,PersonCel,PersonAddress,PersonQQ,CatId,Remark) values(" + _userID + ",'" + _name + "','" + _tel + "','"+_personCel+"','"+_address+"','" + _qq + "','" + _catId + "','"+_remark+"')"; myObj.ExecuteSqlStr();//确认插入数据 }
//删除分组时删除分组内联系人 public void Dele() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "delete [TXL_Person] where UserID="+_userID+" and CatId="+_catId+""; myObj.ExecuteSqlStr(); }
//修改TXL_Persons public void ChangPerson() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "update [TXL_Persons] set PersonName='"+_personName+"',PersonTel='"+_tel+"',PersonCel='"+_personCel+"',PersonAddress='"+_address+"',PersonQQ='"+_qq+"',CatId="+_catId+",Remark='"+_remark+"' where PersonId="+_personId+""; myObj.ExecuteSqlStr(); }
//编辑工程编号 public void Updatendtno() { AccessDB myObj = new AccessDB(); myObj.SqlStr = "update CONSIGN_ndt set ndt_no='" + _ndt_no + "' where UserID=" + _UserID + " and ndt_id=" + _ndt_id + ""; myObj.ExecuteSqlStr();//删除记录 }