}//function ExcelTsql /// <summary> /// 将填充的DataSet写入Sql中 /// </summary> /// <param name="ConID">会议ID</param> /// 作者:吴若彤 /// 创建时间:2014-9-22 /// 修改时间:2014-9-22 public void ExcelToSqlFill(int ConID) { DataSet ds = ExcelTsql(); SqlConnection sqlConn = SqlHelperDB.GetConnection(); for (int i = 0; i < ds.Tables["table"].Rows.Count; i++) { string sqlcmdstring = String.Format("Insert into OutConMember values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", ConID, ds.Tables["table"].Rows[i][1], ds.Tables["table"].Rows[i][2], ds.Tables["table"].Rows[i][3], ds.Tables["table"].Rows[i][4], ds.Tables["table"].Rows[i][5], ds.Tables["table"].Rows[i][0], '0'); SqlCommand cmd = new SqlCommand(sqlcmdstring, sqlConn); DB.SqlHelperDB.ExecuteSql(DB.SqlHelperDB.ConnectionString, sqlcmdstring); } sqlConn.Close(); } //function ExcelToSqlFill
} // function UpdateARecord /// <summary> /// 判断登陆用户是否存在 /// </summary> /// <param name="id">用户账号</param> /// <param name="pwd">用户密码</param> /// <returns>用户信息</returns> /// 作者:王宇昊 /// 创建时间:2014-09-18 /// 修改时间:2014-09-18 public EmployeeModel IsExist(string id, string pwd) { EmployeeModel Employee = new EmployeeModel(); //返回值 string strSqlCmd; // 存储数据库命令语句 strSqlCmd = string.Format("select * from Employee where EmId ='{0}'and EmPassword = '******'", id, pwd); SqlConnection sqlConn = SqlHelperDB.GetConnection(); SqlCommand sqlCmd = new SqlCommand(strSqlCmd, sqlConn); sqlConn.Open(); SqlDataReader sqlDR = sqlCmd.ExecuteReader(); if (sqlDR.Read()) { Employee.EmId = Convert.ToInt32(sqlDR[0].ToString()); Employee.EmName = sqlDR[1].ToString(); Employee.EmPermission = sqlDR[2].ToString(); Employee.EmSex = sqlDR[3].ToString(); Employee.EmDepart = sqlDR[4].ToString(); Employee.EmPhone = sqlDR[5].ToString(); Employee.EmEmail = sqlDR[6].ToString(); Employee.EmCompany = sqlDR[7].ToString(); Employee.EmDuties = sqlDR[8].ToString(); Employee.EmPassword = sqlDR[9].ToString(); sqlDR.Close(); sqlConn.Close(); return(Employee); } else { Employee.EmPermission = "ER"; return(Employee); } }// function IsExist()