//添加实验室
public int addClassroom(T_ClassRoom classroom)
{
int n = 0;
string str = ConfigurationManager.ConnectionStrings["SmartLaboratory"].ConnectionString;
using (SqlConnection conn = new SqlConnection(str))
{
conn.Open();
SqlCommand cmd = new SqlCommand("addClassRoom", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter[] parameters = new SqlParameter[]
{ new SqlParameter("@classroomID", classroom.F_ClassRoomID),
new SqlParameter("@classroomName", classroom.F_ClassRoomName),
new SqlParameter("@classTypeCode", classroom.F_ClassTypeCode),
new SqlParameter("@classFunction", classroom.F_ClassFunction),
new SqlParameter("@isDelete", classroom.F_IsDelete),
new SqlParameter("@classRoomLocation", classroom.F_ClassRoomLocation),
new SqlParameter("@classDescription", classroom.F_ClassDescription),
new SqlParameter("@classRoomRemark", classroom.F_ClassRoomRemark),
new SqlParameter("@remark", classroom.F_Remark) };
cmd.Parameters.AddRange(parameters);
n = cmd.ExecuteNonQuery();
}
return(n);
}
//根据实验室编号，获得该实验室信息
public T_ClassRoom getClassroomInfoByF_ClassRoomID(string classroomID)
{
T_ClassRoom classroom = new T_ClassRoom();
string str = ConfigurationManager.ConnectionStrings["SmartLaboratory"].ConnectionString;
using (SqlConnection conn = new SqlConnection(str))
{
conn.Open();
SqlCommand cmd = new SqlCommand("getClassroomInfoByF_ClassRoomID", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter parameter = new SqlParameter();
cmd.Parameters.Add("@classRoomID", SqlDbType.NVarChar);
cmd.Parameters["@classRoomID"].Value = classroomID;
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
classroom.F_ClassRoomID = dr[0].ToString();
classroom.F_ClassRoomName = dr[1].ToString();
classroom.F_ClassTypeCode = dr[2].ToString();
classroom.F_ClassFunction = dr[3].ToString();
classroom.F_IsDelete = Convert.ToBoolean(dr[4]);
classroom.F_ClassRoomLocation = dr[5].ToString();
classroom.F_ClassDescription = dr[6].ToString();
classroom.F_ClassRoomRemark = dr[7].ToString();
classroom.F_Remark = dr[8].ToString();
classroom.F_LastModifier = dr[14].ToString();
classroom.F_LastModifyDate = Convert.ToDateTime(dr[15]);
}
}
return(classroom);
}
public string deleteClassroom(string F_ClassRoomID)
{
T_ClassRoom classroom = new T_ClassRoom();
classroom.F_ClassRoomID = F_ClassRoomID;
classroom = dalClassroom.Select(classroom);
string message = dalClassroom.Delete(classroom);
return(message);
}
public string addClassRoom(string[] info, bool isDelete)
{
T_ClassRoom classroom = new T_ClassRoom();
classroom.F_ClassRoomID = info[0];
classroom.F_ClassRoomName = info[1];
classroom.F_ClassTypeCode = new BLL.Dictionary().getDictionaryKEY(info[2]);
classroom.F_ClassFunction = info[3];
classroom.F_IsDelete = isDelete;
classroom.F_ClassRoomLocation = info[4];
classroom.F_ClassDescription = info[5];
classroom.F_ClassRoomRemark = info[6];
classroom.F_Remark = info[7];
string message = dalClassroom.Insert(classroom);
return(message);
}
public string[] getClassroomInfo(string F_ClassRoomID)
{
string[] info = new string[10];
T_ClassRoom classroom = new T_ClassRoom();
classroom.F_ClassRoomID = F_ClassRoomID;
classroom = dalClassroom.Select(classroom);
info[0] = classroom.F_ClassRoomName;
info[1] = new BLL.Dictionary().getDictionaryValue(classroom.F_ClassTypeCode);
info[2] = classroom.F_ClassFunction;
info[3] = classroom.F_ClassRoomLocation;
info[4] = classroom.F_ClassDescription;
info[5] = classroom.F_ClassRoomRemark;
info[6] = classroom.F_Remark;
info[7] = classroom.F_LastModifier;
info[8] = classroom.F_LastModifyDate.ToString();
info[9] = F_ClassRoomID;
return(info);
}
public bool existClassroom(string F_ClassRoomID)
{
T_ClassRoom classroom = new T_ClassRoom();
classroom.F_ClassRoomID = F_ClassRoomID;
classroom = dalClassroom.Select(classroom);
if (classroom == null)
{
return(false);
}
else
{
if (!classroom.F_ClassRoomID.Equals(null))
{
return(true);
}
else
{
return(false);
}
}
}
