protected void bt_AddCate_Click(object sender, EventArgs e)
{
lb_Error.Text = "";
try
{
CY.GFive.Core.Business.ParentCode pct = CY.GFive.Core.Business.ParentCode.GetInstance("RoomState");
if (pct == null)
{
ParentCode pc = new ParentCode();
pc.Des = "寝室状态";
pc.PCateCode = "RoomState";
pc.PName = "RoomState";
pc.Save();
}
CateCode ncc = new CateCode();
ncc.Code = tb_CateCode.Text;
ncc.CateName = tb_CateName.Text.Trim();
ncc.CateDes = tb_CateName.Text;
ncc.ParentCode = "RoomState";
ncc.Save();
tb_CateCode.Text = "";
tb_CateName.Text = "";
BindddlRoomState();
}
catch (Exception ex)
{
lb_Error.Text = "错误:" + ex.Message;
}
}
public IList<ClassRoom> Fill(CateCode cate, CateCode state)
{
if (cate == null || state == null)
{
return null;
}
IList<Core.Business.ClassRoom> classRoomlist = new List<Core.Business.ClassRoom>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Cate", SqlDbType.NVarChar, cate.Code, 30);
sql.AddParameter("@State", SqlDbType.NVarChar, state.Code, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillClassRoomCateState);
if (reader != null)
{
while (reader.Read())
{
Core.Business.ClassRoom classRoom = new Core.Business.ClassRoom();
if (!reader.IsDBNull(0)) classRoom.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) classRoom.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) classRoom.Name = reader.GetString(2);
if (!reader.IsDBNull(3)) classRoom.RoomCate = reader.GetString(3);
if (!reader.IsDBNull(4)) classRoom.AvailNum = reader.GetInt32(4);
if (!reader.IsDBNull(5)) classRoom.RoomState = reader.GetString(5);
if (!reader.IsDBNull(6)) classRoom.Multimedia = reader.GetString(6);
classRoom.MarkOld();
classRoomlist.Add(classRoom);
}
reader.Close();
}
return classRoomlist;
}
//添加记录类型
protected void btn_AddRcdCate_Click(object sender, EventArgs e)
{
lab_Error.Text = "";
try
{
CY.GFive.Core.Business.ParentCode pctemp = CY.GFive.Core.Business.ParentCode.GetInstance("RoomRcdCate");
if (pctemp == null)
{
ParentCode pc = new ParentCode();
pc.Des = "寝室记录类型";
pc.PCateCode = "RoomRcdCate";
pc.PName = "RoomRcdCate";
pc.Save();
}
CateCode cc = new CateCode();
//备注:RRC为RoomRcdCate简写
cc.CateDes =txt_name.Text.Trim();
cc.CateName =txt_name.Text.Trim();
cc.Code ="RRC"+txt_code.Text.Trim();
cc.ParentCode = "RoomRcdCate";
bool temp = CateCode.IsExist(cc.Code);
if (temp)
{
Page.ClientScript.RegisterStartupScript(typeof(string), "", "alert('编号已存在');", true);
return;
}
cc.Save();
txt_code.Text = "";
txt_name.Text = "";
BindRcdCate();
}
catch (Exception ex)
{
lab_Error.Text = "错误:" + ex.Message;
}
}
//[DepartmentCode]=@DepartCode AND [StaffCate]=@StaffCate
public IList<StaffInfo> Fill(CateCode staffTeacherCode, Department Depart)
{
if (staffTeacherCode == null || Depart == null)
return GetAllStaffInfo();
IList<Core.Business.StaffInfo> staffInfolist = new List<Core.Business.StaffInfo>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@DepartCode", SqlDbType.NVarChar, Depart.DepartCode, 30);
sql.AddParameter("@StaffCate", SqlDbType.NVarChar, staffTeacherCode.Code, 30);
SqlDataReader reader = sql.ExecuteSqlReader(SqlFillStaffInfoWithParam);
if (reader != null)
{
while (reader.Read())
{
Core.Business.StaffInfo staffInfo = new Core.Business.StaffInfo();
if (!reader.IsDBNull(0)) staffInfo.Id = reader.GetInt32(0);
if (!reader.IsDBNull(1)) staffInfo.Code = reader.GetString(1);
if (!reader.IsDBNull(2)) staffInfo.Name = reader.GetString(2);
if (!reader.IsDBNull(3)) staffInfo.Gender = reader.GetString(3);
if (!reader.IsDBNull(4)) staffInfo.Nation = reader.GetString(4);
if (!reader.IsDBNull(5)) staffInfo.Origin = reader.GetString(5);
if (!reader.IsDBNull(6)) staffInfo.IdentifyCode = reader.GetString(6);
if (!reader.IsDBNull(7)) staffInfo.Birthday = reader.GetDateTime(7);
if (!reader.IsDBNull(8)) staffInfo.PoliticalCode = reader.GetString(8);
if (!reader.IsDBNull(9)) staffInfo.JoinDate = reader.GetDateTime(9);
if (!reader.IsDBNull(10)) staffInfo.EducateLvl = reader.GetString(10);
if (!reader.IsDBNull(11)) staffInfo.ScholarLvl = reader.GetString(11);
if (!reader.IsDBNull(12)) staffInfo.TitleLvl = reader.GetString(12);
if (!reader.IsDBNull(13)) staffInfo.QualityLvl = reader.GetString(13);
if (!reader.IsDBNull(14)) staffInfo.TeachSubject = reader.GetString(14);
if (!reader.IsDBNull(15)) staffInfo.OriginWork = reader.GetString(15);
if (!reader.IsDBNull(16)) staffInfo.GraduteSchool = reader.GetString(16);
if (!reader.IsDBNull(17)) staffInfo.ProfessName = reader.GetString(17);
if (!reader.IsDBNull(18)) staffInfo.SchoolTypeCode = reader.GetString(18);
if (!reader.IsDBNull(19)) staffInfo.Address = reader.GetString(19);
if (!reader.IsDBNull(20)) staffInfo.CellPhone = reader.GetString(20);
if (!reader.IsDBNull(21)) staffInfo.Phone = reader.GetString(21);
if (!reader.IsDBNull(22)) staffInfo.StaffCate = reader.GetString(22);
if (!reader.IsDBNull(23)) staffInfo.Photo = reader.GetString(23);
if (!reader.IsDBNull(24)) staffInfo.DepartmentCode = reader.GetString(24);
if (!reader.IsDBNull(25)) staffInfo.Des = reader.GetString(25);
if (!reader.IsDBNull(26)) staffInfo.AttachmentCode = reader.GetString(26);
if (!reader.IsDBNull(27)) staffInfo.Positon = reader.GetString(27);
if (!reader.IsDBNull(28)) staffInfo.Password = reader.GetString(28);
staffInfo.MarkOld();
staffInfolist.Add(staffInfo);
}
reader.Close();
}
return staffInfolist;
}
