能帮我解读下下面的代码吗?我刚学C#,不怎么看的懂!先谢谢咯
public List<LibInfo> getLibInfo(string sql)
{
List<LibInfo> liList = new List<LibInfo>(); using (SqlConnection conn = new SqlConnection(DBHelper.ConnStr))
{
SqlCommand command = new SqlCommand(sql, conn);
conn.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
LibInfo li = new LibInfo(); li.LibId = Convert.ToInt32(reader["WareHouseId"]);
li.LibName = reader["WareHouseName"].ToString(); liList.Add(li);
}
reader.Close();
reader.Dispose();
}
conn.Close();
conn.Dispose();
}
return liList;
} /// <summary>
/// 用户登录验证
/// </summary>
/// <param name="id"></param>
/// <param name="pwd"></param>
/// <returns></returns> public UserInfo getUserInfo(string id)
{
UserInfo ui = new UserInfo(); string sql = string.Format("SELECT * FROM userInfo WHERE userName='{0}'", id); using (SqlConnection conn = new SqlConnection(DBHelper.ConnStr))
{
SqlCommand command = new SqlCommand(sql, conn);
conn.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
ui.UserName = reader["UserName"].ToString();
ui.UserPwd = reader["UserPwd"].ToString();
ui.ShortName = reader["ShortEMPName"].ToString();
ui.Position = reader["Position"].ToString();
ui.EmpName1 = reader["EmpName"].ToString();
ui.Address = reader["Address"].ToString();
ui.TelNo = reader["TelNo"].ToString();
}
reader.Close();
reader.Dispose();
}
conn.Close();
conn.Dispose();
}
return ui;
}
public int ModifyUserInfo(string sql)
{
int number = 0;
using (SqlConnection conn = new SqlConnection(DBHelper.ConnStr))
{
SqlCommand command = new SqlCommand(sql, conn);
try
{
conn.Open();
number = command.ExecuteNonQuery();
}
catch (System.Exception e)
{
;
}
finally
{
conn.Close();
conn.Dispose();
}
}
return number;
}
}
}
public List<LibInfo> getLibInfo(string sql)
{
List<LibInfo> liList = new List<LibInfo>(); using (SqlConnection conn = new SqlConnection(DBHelper.ConnStr))
{
SqlCommand command = new SqlCommand(sql, conn);
conn.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
while (reader.Read())
{
LibInfo li = new LibInfo(); li.LibId = Convert.ToInt32(reader["WareHouseId"]);
li.LibName = reader["WareHouseName"].ToString(); liList.Add(li);
}
reader.Close();
reader.Dispose();
}
conn.Close();
conn.Dispose();
}
return liList;
} /// <summary>
/// 用户登录验证
/// </summary>
/// <param name="id"></param>
/// <param name="pwd"></param>
/// <returns></returns> public UserInfo getUserInfo(string id)
{
UserInfo ui = new UserInfo(); string sql = string.Format("SELECT * FROM userInfo WHERE userName='{0}'", id); using (SqlConnection conn = new SqlConnection(DBHelper.ConnStr))
{
SqlCommand command = new SqlCommand(sql, conn);
conn.Open(); using (SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection))
{
if (reader.Read())
{
ui.UserName = reader["UserName"].ToString();
ui.UserPwd = reader["UserPwd"].ToString();
ui.ShortName = reader["ShortEMPName"].ToString();
ui.Position = reader["Position"].ToString();
ui.EmpName1 = reader["EmpName"].ToString();
ui.Address = reader["Address"].ToString();
ui.TelNo = reader["TelNo"].ToString();
}
reader.Close();
reader.Dispose();
}
conn.Close();
conn.Dispose();
}
return ui;
}
public int ModifyUserInfo(string sql)
{
int number = 0;
using (SqlConnection conn = new SqlConnection(DBHelper.ConnStr))
{
SqlCommand command = new SqlCommand(sql, conn);
try
{
conn.Open();
number = command.ExecuteNonQuery();
}
catch (System.Exception e)
{
;
}
finally
{
conn.Close();
conn.Dispose();
}
}
return number;
}
}
}
{
List<LibInfo> liList = new List<LibInfo>();2、
li.LibId = Convert.ToInt32(reader["WareHouseId"]);
li.LibName = reader["WareHouseName"].ToString();3、
public int ModifyUserInfo(string sql)
{
int number = 0;
using (SqlConnection conn = new SqlConnection(DBHelper.ConnStr))
{
SqlCommand command = new SqlCommand(sql, conn);
try
{
conn.Open();
number = command.ExecuteNonQuery();
}
catch (System.Exception e)
{
;
}
finally
{
conn.Close();
conn.Dispose();
}
}
return number;
}
}
都是什么意思啊
2。public UserInfo getUserInfo(string id)这个方法是通过用户id来获得你要的信息,
3.public int ModifyUserInfo(string sql)
这个方法,你懂吧,就是修改用户信息的,我觉得修改用户信息应该通过Id来修改,你传一个sql语句,莫非还想写一个方法吧,这样太烦了吧!呵呵,还有哪里不懂的,就问我吧!
那这句是什么意思?
li.LibId = Convert.ToInt32(reader["WareHouseId"]);
li.LibName = reader["WareHouseName"].ToString();
ToInt32又是?
获取仓库编号,Convert.ToInt32()是仓库编号的数据类型转换成32Bit整型li.LibName = reader["WareHouseName"].ToString();
获取仓库名称,并转换成字符串型