public int DeleteHomeRepair(string id) { SqlParameter param = new SqlParameter("@ID", SqlDbType.VarChar, 18); param.Value = id; int result = SqlHelp.ExecuteNonQuery("prc_DeleteHomeRepair", CommandType.StoredProcedure, param); return(result); }
public int DeleteBasePark(int parkID) { SqlParameter param = new SqlParameter("@ParkID", SqlDbType.Int); param.Value = parkID; int result = SqlHelp.ExecuteNonQuery("prc_DeleteBasePark", CommandType.StoredProcedure, param); return(result); }
public int UpdateHomeRepairCheck(HomeRepairModel homerepair) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@OwnerText", SqlDbType.Text) }; param[0].Value = homerepair.ID; param[1].Value = homerepair.OwnerText; int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeRepairCheck", CommandType.StoredProcedure, param); return(result); }
public int UpdateChargeFreeType(ChargeFreeTypeModel chargeFeeType) { SqlParameter[] param = { new SqlParameter("@TypeID", SqlDbType.Int), new SqlParameter("@Price", SqlDbType.Float) }; param[0].Value = chargeFeeType.TypeID; param[1].Value = chargeFeeType.Price; int result = SqlHelp.ExecuteNonQuery("prc_UpdateChargeFreeType", CommandType.StoredProcedure, param); return(result); }
public int DeleteFix(string fixID) { SqlParameter param = new SqlParameter("@FixID", SqlDbType.VarChar, 18); param.Value = fixID; int result = SqlHelp.ExecuteNonQuery("prc_DeleteFix", CommandType.StoredProcedure, param); return(result); }
public int UpdateHomeReportForProcess(HomeReportModel homereport) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@FinishText", SqlDbType.Text) }; param[0].Value = homereport.ID; param[1].Value = homereport.FinshText; int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeReportForProcess", CommandType.StoredProcedure, param); return(result); }
public int DeletePavilion(string paID) { SqlParameter param = new SqlParameter("@PaID", SqlDbType.VarChar, 3); param.Value = paID; int result = SqlHelp.ExecuteNonQuery("prc_DeletePavilion", CommandType.StoredProcedure, param); return(result); }
public int UpdatePassword(int id, string password) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@password", SqlDbType.VarChar, 20) }; param[0].Value = id; param[1].Value = password; int result = SqlHelp.ExecuteNonQuery("prc_UpdatePassword", CommandType.StoredProcedure, param); return(result); }
public int DeleteNews(int id) { SqlParameter param = new SqlParameter("@ID", SqlDbType.Int); param.Value = id; int result = SqlHelp.ExecuteNonQuery("prc_DeleteNews", CommandType.StoredProcedure, param); return(result); }
public int UpdateFixRepairForSign(FixRepairModel fixRepair) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@Sign", SqlDbType.Int) }; param[0].Value = fixRepair.ID; param[1].Value = fixRepair.Sign; int result = SqlHelp.ExecuteNonQuery("prc_UpdateFixRepairForSign", CommandType.StoredProcedure, param); return(result); }
public int DeleteRoom(string code) { SqlParameter param = new SqlParameter("@code", SqlDbType.VarChar, 9); param.Value = code; int result = SqlHelp.ExecuteNonQuery("prc_DeleteRoom", CommandType.StoredProcedure, param); return(result); }
public int InsertType(TypeModel type) { SqlParameter[] param = { new SqlParameter("@TypeID", SqlDbType.Int), new SqlParameter("@Name", SqlDbType.VarChar, 20) }; param[0].Value = type.TypeID; param[1].Value = type.Name; int result = SqlHelp.ExecuteNonQuery("prc_InsertType", CommandType.StoredProcedure, param); return(result); }
public int InsertChargeFeeType(ChargeFreeTypeModel chargeFeeType) { SqlParameter[] param = { new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Price", SqlDbType.Float), new SqlParameter("@Format", SqlDbType.VarChar, 20) }; param[0].Value = chargeFeeType.TypeName; param[1].Value = chargeFeeType.Price; param[2].Value = chargeFeeType.Format; int result = SqlHelp.ExecuteNonQuery("prc_InsertChargeFeeType", CommandType.StoredProcedure, param); return(result); }
public int UpdateHomeFreeForBargian(HomeFreeModel homeFree) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@FactPayMent", SqlDbType.Money), new SqlParameter("@HandleName", SqlDbType.VarChar, 20) }; param[0].Value = homeFree.ID; param[1].Value = homeFree.FactPayment; param[2].Value = homeFree.HandleName; int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeFreeForBargian", CommandType.StoredProcedure, param); return(result); }
public int InsertNotice(NewsModel news) { SqlParameter[] param = { new SqlParameter("@Title", SqlDbType.VarChar, 50), new SqlParameter("@NoticeContent", SqlDbType.Text), new SqlParameter("@NoticePerSon", SqlDbType.VarChar, 20) }; param[0].Value = news.Title; param[1].Value = news.NoticeContent; param[2].Value = news.NoticePerson; int result = SqlHelp.ExecuteNonQuery("prc_InsertNews", CommandType.StoredProcedure, param); return(result); }
public int InsertBasePark(BaseParkModel basePark) { SqlParameter[] param = { new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Amount", SqlDbType.Int), new SqlParameter("@Memo", SqlDbType.VarChar, 50) }; param[0].Value = basePark.Name; param[1].Value = basePark.Amount; param[2].Value = basePark.Memo; int result = SqlHelp.ExecuteNonQuery("prc_InsertBasePark", CommandType.StoredProcedure, param); return(result); }
public int InsertAd(AdModel ads) { SqlParameter[] param = { new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@PhotoPath", SqlDbType.VarChar, 255), new SqlParameter("@Url", SqlDbType.VarChar, 255) }; param[0].Value = ads.AdName; param[1].Value = ads.PhotoPath; param[2].Value = ads.Url; int result = SqlHelp.ExecuteNonQuery("prc_InsertAd", CommandType.StoredProcedure, param); return(result); }
public int UpdateHomeReport(HomeReportModel homereport) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@ReportDate", SqlDbType.DateTime, 10), new SqlParameter("@ReportText", SqlDbType.Text), new SqlParameter("@ReportMemo", SqlDbType.Text) }; param[0].Value = homereport.ID; param[1].Value = homereport.ReportDate; param[2].Value = homereport.ReportText; param[3].Value = homereport.ReportMemo; int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeReport", CommandType.StoredProcedure, param); return(result); }
public int UpdateHomeRepairForProcess(HomeRepairModel homerepair) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@Varperson", SqlDbType.VarChar, 20), new SqlParameter("@VarText", SqlDbType.Text), new SqlParameter("@RepairUnit", SqlDbType.VarChar, 50) }; param[0].Value = homerepair.ID; param[1].Value = homerepair.Varperson; param[2].Value = homerepair.VarText; param[3].Value = homerepair.RepairUnit; int result = SqlHelp.ExecuteNonQuery("prc_UpdateHomeRepairForProcess", CommandType.StoredProcedure, param); return(result); }
public int InsertHomeRepair(HomeRepairModel homerepair) { SqlParameter[] param = { new SqlParameter("@ID", SqlDbType.VarChar, 18), new SqlParameter("@Code", SqlDbType.VarChar, 9), new SqlParameter("@RepairText", SqlDbType.Text), new SqlParameter("@RepairMemo", SqlDbType.Text) }; param[0].Value = homerepair.ID; param[1].Value = homerepair.Code; param[2].Value = homerepair.RepairText; param[3].Value = homerepair.RepairMemo; int result = SqlHelp.ExecuteNonQuery("prc_InsertHomeRepair", CommandType.StoredProcedure, param); return(result); }
public int InsertAreaFact(AreaFactModel areafact) { SqlParameter[] param = { new SqlParameter("@FactName", SqlDbType.VarChar, 50), new SqlParameter("@MainHead", SqlDbType.VarChar, 20), new SqlParameter("@Tel", SqlDbType.VarChar, 13), new SqlParameter("@TypeID", SqlDbType.Int), new SqlParameter("@Memo", SqlDbType.Text) }; param[0].Value = areafact.FactName; param[1].Value = areafact.MainHead; param[2].Value = areafact.Tel; param[3].Value = areafact.TypeID; param[4].Value = areafact.Memo; int result = SqlHelp.ExecuteNonQuery("prc_InsertAreaFact", CommandType.StoredProcedure, param); return(result); }
public int InsertFix(FixModel fix) { SqlParameter[] param = { new SqlParameter("@FixID", SqlDbType.VarChar, 18), new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Amount", SqlDbType.Int), new SqlParameter("@Factory", SqlDbType.VarChar, 20), new SqlParameter("@FactoryDate", SqlDbType.DateTime, 10) }; param[0].Value = fix.FixID; param[1].Value = fix.Name; param[2].Value = fix.Amount; param[3].Value = fix.Factory; param[4].Value = fix.FactoryDate; int result = SqlHelp.ExecuteNonQuery("prc_InsertFix", CommandType.StoredProcedure, param); return(result); }
public int InsertHomeFree(HomeFreeModel homeFree) { SqlParameter[] param = { new SqlParameter("@Code", SqlDbType.VarChar, 9), new SqlParameter("@TypeID", SqlDbType.Int), new SqlParameter("@Number", SqlDbType.Float), new SqlParameter("@StartDate", SqlDbType.DateTime, 10), new SqlParameter("@PayDate", SqlDbType.DateTime, 10), new SqlParameter("@AddName", SqlDbType.VarChar, 20) }; param[0].Value = homeFree.Code; param[1].Value = homeFree.TypeID; param[2].Value = homeFree.Number; param[3].Value = homeFree.StartDate; param[4].Value = homeFree.PayDate; param[5].Value = homeFree.AddName; int result = SqlHelp.ExecuteNonQuery("prc_InsertHomeChargeFee", CommandType.StoredProcedure, param); return(result); }
public int InsertHomePark(HomeParkModel homePark) { SqlParameter[] param = { new SqlParameter("@ParkID", SqlDbType.Int), new SqlParameter("@Code", SqlDbType.VarChar, 9), new SqlParameter("@CarID", SqlDbType.VarChar, 20), new SqlParameter("@Type", SqlDbType.VarChar,20), new SqlParameter("@BuyDate", SqlDbType.DateTime, 10), new SqlParameter("@Color", SqlDbType.VarChar, 20) }; param[0].Value = homePark.ParkID; param[1].Value = homePark.Code; param[2].Value = homePark.CarID; param[3].Value = homePark.Type; param[4].Value = homePark.BuyDate; param[5].Value = homePark.Color; int result = SqlHelp.ExecuteNonQuery("prc_InsertHomePark", CommandType.StoredProcedure, param); return(result); }
public bool BackupDataBase(string path) { SqlParameter param = new SqlParameter("@Path", SqlDbType.VarChar, 255); param.Value = path; try { SqlHelp.ExecuteNonQuery("prc_BackupDataBase", CommandType.StoredProcedure, param); } catch { return(false); } return(true); }
public int UpdateRoom(RoomModel room) { SqlParameter[] param = { new SqlParameter("@Code", SqlDbType.VarChar, 9), new SqlParameter("@SunnyID", SqlDbType.Int), new SqlParameter("@IndoorID", SqlDbType.Int), new SqlParameter("@RoomUseID", SqlDbType.Int), new SqlParameter("@RoomFormatID", SqlDbType.Int), new SqlParameter("@BuildArea", SqlDbType.Float), new SqlParameter("@UseArea", SqlDbType.Float) }; param[0].Value = room.Code; param[1].Value = room.SunnyID; param[2].Value = room.IndoorID; param[3].Value = room.RoomUseID; param[4].Value = room.RoomFormatID; param[5].Value = room.BuildArea; param[6].Value = room.UseArea; int result = SqlHelp.ExecuteNonQuery("prc_UpdateRoom", CommandType.StoredProcedure, param); return(result); }
public int UpdateEmployee(EmployeeModel employee) { SqlParameter[] param = { new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@ID", SqlDbType.Int), new SqlParameter("@Arrage", SqlDbType.VarChar, 20), new SqlParameter("@Address", SqlDbType.VarChar, 30), new SqlParameter("@Tel", SqlDbType.VarChar, 12), new SqlParameter("@Mobile", SqlDbType.VarChar, 12), new SqlParameter("@PhotoPath", SqlDbType.VarChar, 255) }; param[0].Value = employee.EmlpoyeeName; param[1].Value = employee.ID; param[2].Value = employee.Arrage; param[3].Value = employee.Address; param[4].Value = employee.Tel; param[5].Value = employee.Mobile; param[6].Value = employee.PhotoPath; int result = SqlHelp.ExecuteNonQuery("prc_UpdateEmployee", CommandType.StoredProcedure, param); return(result); }
public int InsertPavilion(PavilionModel pavilion) { SqlParameter[] param = { new SqlParameter("@PaID", SqlDbType.VarChar, 3), new SqlParameter("@Name", SqlDbType.VarChar, 20), new SqlParameter("@Layer", SqlDbType.SmallInt), new SqlParameter("@Height", SqlDbType.Float), new SqlParameter("@Area", SqlDbType.Float), new SqlParameter("@BuildDate", SqlDbType.DateTime, 10), new SqlParameter("@Memo", SqlDbType.Text), new SqlParameter("@TypeID", SqlDbType.Int) }; param[0].Value = pavilion.PaID; param[1].Value = pavilion.Name; param[2].Value = pavilion.Layer; param[3].Value = pavilion.Height; param[4].Value = pavilion.Area; param[5].Value = pavilion.BuildDate; param[6].Value = pavilion.Memo; param[7].Value = pavilion.TypeID; int result = SqlHelp.ExecuteNonQuery("prc_InsertPavilion", CommandType.StoredProcedure, param); return(result); }
public int UpdateFixRepair(FixRepairModel fixRepair) { SqlParameter[] param = { new SqlParameter("@FixID", SqlDbType.VarChar, 18), new SqlParameter("@RepairDate", SqlDbType.DateTime, 10), new SqlParameter("@EndDate", SqlDbType.DateTime, 10), new SqlParameter("@MainHead", SqlDbType.VarChar, 20), new SqlParameter("@ServiceFee", SqlDbType.Money), new SqlParameter("@MaterielFee", SqlDbType.Money), new SqlParameter("@RepairSum", SqlDbType.Money), new SqlParameter("@RepairMemo", SqlDbType.Text), new SqlParameter("@Sign", SqlDbType.Int), new SqlParameter("@RepairUnit", SqlDbType.VarChar, 50) }; param[0].Value = fixRepair.FixID; param[1].Value = fixRepair.RepairDate; param[2].Value = fixRepair.EndDate; param[3].Value = fixRepair.MainHead; param[4].Value = fixRepair.ServiceFee; param[5].Value = fixRepair.MaterielFee; param[6].Value = fixRepair.RepairSum; param[7].Value = fixRepair.RepairMemo; param[8].Value = fixRepair.Sign; param[9].Value = fixRepair.RepairUnit; int result = SqlHelp.ExecuteNonQuery("prc_UpdateFixRepair", CommandType.StoredProcedure, param); return(result); }
public int InsertBaseInfo(BaseInfoModel baseinfo) { SqlParameter[] param = { new SqlParameter("@HomeName", SqlDbType.VarChar, 20), new SqlParameter("@MainHead", SqlDbType.VarChar, 20), new SqlParameter("@BuildDate", SqlDbType.DateTime, 10), new SqlParameter("@BuildArea", SqlDbType.Float), new SqlParameter("@Amount", SqlDbType.Int, 4), new SqlParameter("@Address", SqlDbType.VarChar, 255), new SqlParameter("@GreenArea", SqlDbType.Float), new SqlParameter("@RoadArea", SqlDbType.Float), new SqlParameter("@Tel", SqlDbType.VarChar, 18), new SqlParameter("@ParkingArea", SqlDbType.Float), new SqlParameter("@Memo", SqlDbType.Text) }; param[0].Value = baseinfo.HomeName; param[1].Value = baseinfo.MainHead; param[2].Value = baseinfo.BuildDate; param[3].Value = baseinfo.BuildArea; param[4].Value = baseinfo.Amount; param[5].Value = baseinfo.Address; param[6].Value = baseinfo.GreenArea; param[7].Value = baseinfo.RoadArea; param[8].Value = baseinfo.Tel; param[9].Value = baseinfo.ParkingArea; param[10].Value = baseinfo.Memo; int result = SqlHelp.ExecuteNonQuery("prc_InsertBaseInfo", CommandType.StoredProcedure, param); return(result); }