}//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()
