public static int updatePassword(string userId, string pssword, string psd)//根据二维码设置人员信息 { try { string sqlStr = "select * from MeUserInfo where uId=" + userId + " and uPassword='******'"; DataSet dt = SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (dt.Tables[0].Rows.Count > 0) { string sqlStr1 = "update MeUserInfo set uPassword='******' where uId=" + userId; int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sqlStr1); if (i > 0) { return(i); } return(-1); } else { return(-1); } } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(-1); } }
public static int setloginState(string userId, string loginState)//根据二维码设置人员信息 { try { string sqlStr = "update MeUserInfo set loginState=" + loginState + " where uId=" + userId; int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (i > 0) { return(i); } return(-1); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(-1); } }
public static int setMeeterInfo(string QRcode, string checkTime, string mID, string meetid)//根据二维码设置人员信息 { try { string sqlStr = "update MePerAttend set attendState=1,attendTime='" + checkTime + "',manageId='" + mID + "' where QRcode='" + QRcode + "' and meetingId=" + meetid; int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (i > 0) { return(i); } return(-1); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(-1); } }
public static DataTable getMeeter(string id) //根据会议获取人员信息 { try { string sqlStr = "select MePerAttend.*,MeDelegation.* from MePerAttend,MeDelegation where MePerAttend.meetingId=" + id + " and MeDelegation.id=MePerAttend.delegationId order by MePerAttend.delegationId"; DataSet dt = SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (dt.Tables[0].Rows.Count > 0) { return(dt.Tables[0]); } return(null); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(null); } }
public static DataTable getCheck(string QRcode)//根据会议获取人员信息 { try { string sqlStr = "select * from MePerAttend where QRcode='" + QRcode + "'"; DataSet dt = SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (dt.Tables[0].Rows.Count > 0) { return(dt.Tables[0]); } return(null); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(null); } }
public static int updateNumber(string totalNum, string arriveNum, string noarriveNum, string meetingId)//根据二维码设置人员信息 { try { string sqlStr = "update MeNumber set nTotal='" + totalNum + "',nReal='" + arriveNum + "',nNotArrive='" + noarriveNum + "' where meetingId=" + meetingId; int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (i > 0) { return(i); } return(-1); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(-1); } }
public static DataTable getIsMeeting(string meetingId)// { try { string sqlStr = "select * from MeNumber where meetingId=" + meetingId; DataSet dt = SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (dt.Tables[0].Rows.Count > 0) { return(dt.Tables[0]); } return(null); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(null); } }
public static DataTable getMeet(string time, string departID)//根据时间获取会议信息 { try { string sqlStr = "select * from MeMeetInfo where mDate='" + time + "' and mDeptCode='" + departID + "'"; DataSet dt = SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (dt.Tables[0].Rows.Count > 0) { return(dt.Tables[0]); } return(null); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(null); } }
public static DataRow Login(string userName, string userPwd) { try { string sq = "select * from MeUserInfo where uId='" + userName + "' and uPassword='******'"; DataSet obj = SqlHelper.ExecuteDataset(SqlHelper.GetConnSting(), CommandType.Text, sq); if (obj.Tables[0].Rows.Count > 0) { if (obj.Tables[0].Rows[0]["uId"].ToString() == userName && obj.Tables[0].Rows[0]["uPassword"].ToString() == userPwd) { return(obj.Tables[0].Rows[0]); } } return(null); } catch (SystemException e) { ErrorHandle.showError(e); return(null); } }
public static int insertNumber(string meetingId)//根据二维码设置人员信息 { //string totalNum, string arriveNum,string noarriveNum, try { string sqlStr = "insert MeNumber(meetingId,state) values(" + meetingId + ",0)"; //"insert MeNumber(nTotal,nReal,nNotArrive,meetingId) values('" + totalNum + "','" + arriveNum + "','" + noarriveNum + "'," + meetingId + ")"; int i = SqlHelper.ExecuteNonQuery(SqlHelper.GetConnSting(), CommandType.Text, sqlStr); if (i > 0) { return(i); } return(-1); } catch (SyntaxErrorException e) { ErrorHandle.showError(e); return(-1); } }