public FixRepairModel GetFixRepairByID(int id) { SqlParameter param = new SqlParameter("@ID", SqlDbType.Int); param.Value = id; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixRepairByID", CommandType.StoredProcedure); dr.Read(); FixRepairModel fixRepair = new FixRepairModel(); if (dr.HasRows) { fixRepair.ID = Convert.ToInt32(dr[0]); fixRepair.FixID = dr[1].ToString(); fixRepair.FixName = dr[2].ToString(); fixRepair.RepairDate = Convert.ToDateTime(dr[3]); fixRepair.EndDate = Convert.ToDateTime(dr[4]); fixRepair.MainHead = dr[5].ToString(); fixRepair.ServiceFee = Convert.ToDouble(dr[6]); fixRepair.MaterielFee = Convert.ToDouble(dr[7]); fixRepair.RepairSum = Convert.ToDouble(dr[8]); fixRepair.RepairMemo = dr[9].ToString(); fixRepair.Sign = Convert.ToInt32(dr[10]); fixRepair.RepairUnit = dr[11].ToString(); } dr.Close(); return(fixRepair); }
public List <FixRepairModel> GetFixRepairByCondition(string condition) { SqlParameter param = new SqlParameter("@Condition", SqlDbType.VarChar, 255); param.Value = condition; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetFixRepairByCondition", CommandType.StoredProcedure, param); List <FixRepairModel> list = new List <FixRepairModel>(); while (dr.Read()) { FixRepairModel fixRepair = new FixRepairModel(); fixRepair.ID = Convert.ToInt32(dr[0]); fixRepair.FixID = dr[1].ToString(); fixRepair.FixName = dr[2].ToString(); fixRepair.RepairDate = Convert.ToDateTime(dr[3]); fixRepair.EndDate = Convert.ToDateTime(dr[4]); fixRepair.MainHead = dr[5].ToString(); fixRepair.ServiceFee = Convert.ToDouble(dr[6]); fixRepair.MaterielFee = Convert.ToDouble(dr[7]); fixRepair.RepairSum = Convert.ToDouble(dr[8]); fixRepair.RepairMemo = dr[9].ToString(); fixRepair.Sign = Convert.ToInt32(dr[10]); fixRepair.RepairUnit = dr[11].ToString(); list.Add(fixRepair); } dr.Close(); return(list); }
public List <FixRepairModel> GetAllFixRepair() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllFixRepair", CommandType.StoredProcedure); List <FixRepairModel> list = new List <FixRepairModel>(); while (dr.Read()) { FixRepairModel fixRepair = new FixRepairModel(); fixRepair.ID = Convert.ToInt32(dr[0]); fixRepair.FixID = dr[1].ToString(); fixRepair.FixName = dr[2].ToString(); fixRepair.RepairDate = Convert.ToDateTime(dr[3]); fixRepair.EndDate = Convert.ToDateTime(dr[4]); fixRepair.MainHead = dr[5].ToString(); fixRepair.ServiceFee = Convert.ToDouble(dr[6]); fixRepair.MaterielFee = Convert.ToDouble(dr[7]); fixRepair.RepairSum = Convert.ToDouble(dr[8]); fixRepair.RepairMemo = dr[9].ToString(); fixRepair.Sign = Convert.ToInt32(dr[10]); fixRepair.RepairUnit = dr[11].ToString(); list.Add(fixRepair); } dr.Close(); return(list); }
public List <RoomModel> GetRoomByCondition(string condition) { SqlParameter param = new SqlParameter("@Condition", SqlDbType.VarChar, 255); param.Value = condition; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetRoomByCondition", CommandType.StoredProcedure, param); List <RoomModel> list = new List <RoomModel>(); while (dr.Read()) { RoomModel room = new RoomModel(); room.Code = dr[0].ToString(); room.RoomID = dr[1].ToString(); room.State = Convert.ToInt32(dr[2]); room.PaName = dr[3].ToString(); room.SunnyName = dr[4].ToString(); room.RoomUseName = dr[5].ToString(); room.IndoorName = dr[6].ToString(); room.RoomFormatName = dr[7].ToString(); room.BuildArea = Convert.ToDouble(dr[8]); room.UseArea = Convert.ToDouble(dr[9]); list.Add(room); } dr.Close(); return(list); }
public List <BaseInfoModel> ShowBaseInfo() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowBaseInfo", CommandType.StoredProcedure); dr.Read(); List <BaseInfoModel> list = new List <BaseInfoModel>(); if (dr.HasRows) { BaseInfoModel baseInfo = new BaseInfoModel(); baseInfo.ID = Convert.ToInt32(dr[0]); baseInfo.HomeName = dr[1].ToString(); baseInfo.MainHead = dr[2].ToString(); baseInfo.BuildDate = Convert.ToDateTime(dr[3]); baseInfo.BuildArea = Convert.ToDouble(dr[4]); baseInfo.Amount = Convert.ToInt32(dr[5]); baseInfo.Address = dr[6].ToString(); baseInfo.GreenArea = Convert.ToDouble(dr[7]); baseInfo.RoadArea = Convert.ToDouble(dr[8]); baseInfo.Tel = dr[9].ToString(); baseInfo.ParkingArea = Convert.ToDouble(dr[10]); baseInfo.Memo = dr[11].ToString(); list.Add(baseInfo); } dr.Close(); return(list); }
public EmployeeModel GetEmployeeByID(int id) { SqlParameter param = new SqlParameter("@ID", SqlDbType.Int); param.Value = id; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetEmployeeByID", CommandType.StoredProcedure, param); dr.Read(); EmployeeModel employee = new EmployeeModel(); if (dr.HasRows) { employee.EmlpoyeeName = dr[0].ToString(); employee.Sex = Convert.ToInt32(dr[1]); employee.Arrage = dr[2].ToString(); employee.Tel = dr[3].ToString(); employee.Mobile = dr[4].ToString(); employee.PhotoPath = dr[5].ToString(); employee.ID = Convert.ToInt32(dr[6]); employee.Address = dr[7].ToString(); employee.CardID = dr[8].ToString(); } dr.Close(); return(employee); }
public List <UserModel> UserLogin(string userName, string password) { SqlParameter[] param = { new SqlParameter("@UID", SqlDbType.VarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 20) }; param[0].Value = userName; param[1].Value = password; SqlDataReader dr = SqlHelp.ExecuteReader("prc_Login", CommandType.StoredProcedure, param); dr.Read(); List <UserModel> list = new List <UserModel>(); if (dr.HasRows) { UserModel user = new UserModel(); user.ID = Convert.ToInt32(dr[0]); user.SubID = Convert.ToInt32(dr[1]); user.UID = dr[2].ToString(); user.Password = dr[3].ToString(); user.Name = dr[4].ToString(); user.UserType = Convert.ToInt32(dr[5]); user.Code = dr[6].ToString(); list.Add(user); } dr.Close(); return(list); }
public List <HomeHoldModel> GetAllHomeHold() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetHomeHold", CommandType.StoredProcedure); List <HomeHoldModel> list = new List <HomeHoldModel>(); while (dr.Read()) { HomeHoldModel homeHold = new HomeHoldModel(); homeHold.ID = Convert.ToInt32(dr[0]); homeHold.Code = dr[1].ToString(); homeHold.UserName = dr[2].ToString(); homeHold.UID = dr[3].ToString(); homeHold.Tel = dr[4].ToString(); homeHold.Contact = dr[5].ToString(); homeHold.Mobile = dr[6].ToString(); homeHold.Email = dr[7].ToString(); homeHold.CardID = dr[8].ToString(); homeHold.OwnerID = dr[9].ToString(); homeHold.Unit = dr[10].ToString(); homeHold.RoomID = dr[11].ToString(); list.Add(homeHold); } dr.Close(); return(list); }
public HomeHoldModel ShowHomeHoldByID(string id) { SqlParameter param = new SqlParameter("@Code", SqlDbType.NVarChar, 20); param.Value = id; SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowHomeHoldByID", CommandType.StoredProcedure, param); dr.Read(); HomeHoldModel homeHold = new HomeHoldModel(); if (dr.HasRows) { homeHold.UserName = dr[0].ToString(); homeHold.Tel = dr[1].ToString(); homeHold.Contact = dr[2].ToString(); homeHold.Email = dr[3].ToString(); homeHold.OwnerID = dr[4].ToString(); homeHold.Unit = dr[5].ToString(); homeHold.Mobile = dr[6].ToString(); homeHold.CardID = dr[7].ToString(); homeHold.Memo = dr[8].ToString(); } dr.Close(); return(homeHold); }
public PavilionModel GetPavilionByID(string paID) { SqlParameter param = new SqlParameter("@PaID", SqlDbType.VarChar, 3); param.Value = paID; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetPavilionByID", CommandType.StoredProcedure, param); dr.Read(); PavilionModel pavilion = new PavilionModel(); if (dr.HasRows) { pavilion.PaID = dr[0].ToString(); pavilion.Name = dr[1].ToString(); pavilion.Layer = Convert.ToInt32(dr[2]); pavilion.Height = Convert.ToDouble(dr[3]); pavilion.Area = Convert.ToDouble(dr[4]); pavilion.BuildDate = Convert.ToDateTime(dr[5]); pavilion.Memo = dr[6].ToString(); pavilion.TypeName = dr[7].ToString(); pavilion.TypeID = Convert.ToInt32(dr[8]); } dr.Close(); return(pavilion); }
public RoomModel GetRoomByID(string code) { SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 9); param.Value = code; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetRoomByID", CommandType.StoredProcedure, param); dr.Read(); RoomModel room = new RoomModel(); if (dr.HasRows) { room.Code = dr[0].ToString(); room.RoomID = dr[1].ToString(); room.State = Convert.ToInt32(dr[2]); room.PaName = dr[3].ToString(); room.SunnyID = Convert.ToInt32(dr[4]); room.SunnyName = dr[5].ToString(); room.RoomUseID = Convert.ToInt32(dr[6]); room.RoomUseName = dr[7].ToString(); room.IndoorID = Convert.ToInt32(dr[8]); room.IndoorName = dr[9].ToString(); room.RoomFormatID = Convert.ToInt32(dr[10]); room.RoomFormatName = dr[11].ToString(); room.BuildArea = Convert.ToDouble(dr[12]); room.UseArea = Convert.ToDouble(dr[13]); } dr.Close(); return(room); }
public int CheckRooms(string code) { SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 5); param.Value = code; SqlDataReader dr = SqlHelp.ExecuteReader("prc_CheckRooms", CommandType.StoredProcedure, param); dr.Read(); int result = Convert.ToInt32(dr[0]); return(result); }
public int CheckHomePark(int ParkID) { SqlParameter param = new SqlParameter("@ParkID", SqlDbType.Int); param.Value = ParkID; SqlDataReader dr = SqlHelp.ExecuteReader("prc_CheckHomePark", CommandType.StoredProcedure, param); dr.Read(); int result = Convert.ToInt32(dr[0]); return(result); }
public int CheckRoom(string paID) { SqlParameter param = new SqlParameter("@PaID", SqlDbType.VarChar, 3); param.Value = paID; SqlDataReader dr = SqlHelp.ExecuteReader("prc_CheckRoomForHold", CommandType.StoredProcedure, param); dr.Read(); int result = Convert.ToInt32(dr[0]); return(result); }
public int GetMaxID() { int id = -1; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetPavilionMaxID", CommandType.StoredProcedure); dr.Read(); if (dr[0].ToString() != "") { id = Convert.ToInt32(dr[0]); } dr.Close(); return(id); }
public List <TypeModel> GetCodeTable() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetCodeTable", CommandType.StoredProcedure); List <TypeModel> list = new List <TypeModel>(); while (dr.Read()) { TypeModel type = new TypeModel(); type.ID = Convert.ToInt32(dr[0]); type.TypeName = dr[1].ToString(); list.Add(type); } dr.Close(); return(list); }
public bool CheckUserByUID(string uid) { bool flag = false; SqlParameter param = new SqlParameter("@UID", SqlDbType.VarChar, 20); param.Value = uid; SqlDataReader dr = SqlHelp.ExecuteReader("prc_CheckUserByUID", CommandType.StoredProcedure, param); dr.Read(); if (dr.HasRows) { flag = true; } dr.Close(); return(flag); }
public List <ChargeFreeTypeModel> GetChargeFreeType() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetChargeFreeType", CommandType.StoredProcedure); List <ChargeFreeTypeModel> list = new List <ChargeFreeTypeModel>(); while (dr.Read()) { ChargeFreeTypeModel chargefree = new ChargeFreeTypeModel(); chargefree.TypeID = Convert.ToInt32(dr[0]); chargefree.TypeName = dr[1].ToString(); chargefree.Price = Convert.ToDouble(dr[2]); chargefree.Format = dr[3].ToString(); list.Add(chargefree); } dr.Close(); return(list); }
public List <BaseParkModel> GetBasePark() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetBasePark", CommandType.StoredProcedure); List <BaseParkModel> list = new List <BaseParkModel>(); while (dr.Read()) { BaseParkModel basePark = new BaseParkModel(); basePark.ParkID = Convert.ToInt32(dr[0]); basePark.Name = dr[1].ToString(); basePark.Amount = Convert.ToInt32(dr[2]); basePark.Memo = dr[3].ToString(); list.Add(basePark); } dr.Close(); return(list); }
public List <NewsModel> ShowNews() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowNews", CommandType.StoredProcedure); List <NewsModel> list = new List <NewsModel>(); while (dr.Read()) { NewsModel news = new NewsModel(); news.ID = Convert.ToInt32(dr[0]); news.Title = dr[1].ToString(); news.NoticeDate = Convert.ToDateTime(dr[2]); news.NoticeContent = dr[3].ToString(); list.Add(news); } dr.Close(); return(list); }
public bool CheckUser(string uid, string password) { bool flag = false; SqlParameter[] param = { new SqlParameter("@UID", SqlDbType.VarChar, 20), new SqlParameter("@Password", SqlDbType.VarChar, 20) }; param[0].Value = uid; param[1].Value = password; SqlDataReader dr = SqlHelp.ExecuteReader("prc_CheckUser", CommandType.StoredProcedure, param); dr.Read(); if (dr.HasRows) { flag = true; } dr.Close(); return(flag); }
public List <FixModel> GetAllFix() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllFix", CommandType.StoredProcedure); List <FixModel> list = new List <FixModel>(); while (dr.Read()) { FixModel fix = new FixModel(); fix.FixID = dr[0].ToString(); fix.Name = dr[1].ToString(); fix.Amount = Convert.ToInt32(dr[2]); fix.Factory = dr[3].ToString(); fix.FactoryDate = Convert.ToDateTime(dr[4]); list.Add(fix); } dr.Close(); return(list); }
public List <RoomModel> GetAllRoomNotUsed(string code) { SqlParameter param = new SqlParameter("@Code", SqlDbType.VarChar, 5); param.Value = code; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetAllRoomNotUsed", CommandType.StoredProcedure, param); List <RoomModel> list = new List <RoomModel>(); while (dr.Read()) { RoomModel room = new RoomModel(); room.RoomID = dr[0].ToString(); room.Code = dr[1].ToString(); list.Add(room); } dr.Close(); return(list); }
public List <EmployeeModel> ShowEmployee() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowEmployee", CommandType.StoredProcedure); List <EmployeeModel> list = new List <EmployeeModel>(); while (dr.Read()) { EmployeeModel employee = new EmployeeModel(); employee.EmlpoyeeName = dr[0].ToString(); employee.Sex = Convert.ToInt32(dr[1]); employee.Arrage = dr[2].ToString(); employee.Tel = dr[3].ToString(); employee.PhotoPath = dr[4].ToString(); list.Add(employee); } dr.Close(); return(list); }
public List <TypeModel> GetType(string typeCode) { SqlParameter param = new SqlParameter("@TableName", SqlDbType.VarChar, 10); param.Value = typeCode; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetType", CommandType.StoredProcedure, param); List <TypeModel> list = new List <TypeModel>(); while (dr.Read()) { TypeModel type = new TypeModel(); type.ID = Convert.ToInt32(dr[0]); type.Name = dr[1].ToString(); list.Add(type); } dr.Close(); return(list); }
public List <AdModel> ShowAllAd() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowAllAd", CommandType.StoredProcedure); List <AdModel> list = new List <AdModel>(); while (dr.Read()) { AdModel ad = new AdModel(); ad.ID = Convert.ToInt32(dr[0]); ad.AdName = dr[1].ToString(); ad.PhotoPath = @"~\" + dr[2].ToString(); ad.Url = dr[3].ToString(); ad.AddDate = Convert.ToDateTime(dr[4]); list.Add(ad); } dr.Close(); return(list); }
public NewsModel ShowNewsByID(int id) { SqlParameter param = new SqlParameter("@ID", SqlDbType.Int, 5); param.Value = id; SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowNewsByID", CommandType.StoredProcedure, param); dr.Read(); NewsModel news = new NewsModel(); if (dr.HasRows) { news.Title = dr[0].ToString(); news.NoticeDate = Convert.ToDateTime(dr[1]); news.NoticeContent = dr[2].ToString(); } dr.Close(); return(news); }
public ChargeFreeTypeModel GetChargeFreeTypeByID(int typeID) { SqlParameter param = new SqlParameter("@TypeID", SqlDbType.Int); param.Value = typeID; SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetChargeFreeTypeByID", CommandType.StoredProcedure, param); dr.Read(); ChargeFreeTypeModel chargefree = new ChargeFreeTypeModel(); if (dr.HasRows) { chargefree.TypeName = dr[0].ToString(); chargefree.Price = Convert.ToDouble(dr[1]); chargefree.Format = dr[2].ToString(); } dr.Close(); return(chargefree); }
public List <HomeRepairModel> GetHomeRepair() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_GetHomeRepair", CommandType.StoredProcedure); List <HomeRepairModel> list = new List <HomeRepairModel>(); while (dr.Read()) { HomeRepairModel homerepair = new HomeRepairModel(); homerepair.ID = dr[0].ToString(); homerepair.Code = dr[1].ToString(); homerepair.RepairDate = Convert.ToDateTime(dr[2]); homerepair.RepairText = dr[3].ToString(); homerepair.Sign = Convert.ToInt32(dr[4]); homerepair.RoomID = dr[5].ToString(); list.Add(homerepair); } dr.Close(); return(list); }
public List <AreaFactModel> ShowAllAreafact() { SqlDataReader dr = SqlHelp.ExecuteReader("prc_ShowAllAreafact", CommandType.StoredProcedure); List <AreaFactModel> list = new List <AreaFactModel>(); while (dr.Read()) { AreaFactModel arefact = new AreaFactModel(); arefact.ID = Convert.ToInt32(dr[0]); arefact.FactName = dr[1].ToString(); arefact.MainHead = dr[2].ToString(); arefact.Tel = dr[3].ToString(); arefact.Memo = dr[5].ToString(); arefact.TypeName = dr[6].ToString(); list.Add(arefact); } dr.Close(); return(list); }