/// <summary>
		/// 更新幼儿园信息
		/// </summary>
		/// <param name="gardenInfo">要更改的GardenInfo</param>
		/// <returns>返回影响的行数</returns>
		public int UpdateGardenInfo(GardenInfo gardenInfo)
		{
			int rowEffected = 0;

			try
			{
				DBCommandWrapper dbComWrapper = db.GetStoredProcCommandWrapper("UpdateGarden_Info");
				dbComWrapper.AddInParameter("@info_gardenID",DbType.String,gardenInfo.GardenID);
				dbComWrapper.AddInParameter("@info_gardenName",DbType.String,gardenInfo.GardenName);
				dbComWrapper.AddInParameter("@info_gardenRegCode",DbType.String,gardenInfo.GardenRegCode);
				dbComWrapper.AddInParameter("@info_gardenAddr",DbType.String,gardenInfo.GardenAddr);
				dbComWrapper.AddInParameter("@info_gardenContact",DbType.String,gardenInfo.GardenContact);
				dbComWrapper.AddInParameter("@info_gardenFeature",DbType.String,gardenInfo.GardenFeature);
				dbComWrapper.AddInParameter("@info_gardenGraphLocation",DbType.Binary,gardenInfo.GardenImage);
				dbComWrapper.AddOutParameter("@rowEffected",DbType.Int32,4);

				db.ExecuteNonQuery(dbComWrapper);

				rowEffected = Convert.ToInt32(dbComWrapper.GetParameterValue("@rowEffected"));
			}
			catch(Exception ex)
			{
				throw ex;
			}

			return rowEffected;
		}
Exemple #2
0
		/// <summary>
		/// 调用DataAccess层更新幼儿园信息
		/// </summary>
		/// <param name="gardenInfo">要更改的GardenInfo</param>
		/// <returns>返回影响的行数</returns>
		public int UpdateGardenInfo(GardenInfo gardenInfo)
		{
			int rowsAffected = 0;
			
			using(GardenInfoDataAccess gardenInfoDataAccess = new GardenInfoDataAccess())
			{
				rowsAffected = gardenInfoDataAccess.UpdateGardenInfo(gardenInfo);
			}

			return rowsAffected;
		}
Exemple #3
0
		//保存园所信息
		private void simpleButton_GardenInfoSave_Click(object sender, System.EventArgs e)
		{
		
			if(!validateDataIsEmpty())//校验数据是否合法
			{
				CPTT.SystemFramework.GardenInfo gardenInfoInstance = new CPTT.SystemFramework.GardenInfo();

				if(gardenInfo.Tables[0].Rows.Count == 0)//数据库中没有园所数据做插入
				{
					gardenInfoInstance.GardenID = Guid.NewGuid().ToString();
					gardenInfoInstance.GardenName = textEdit_GardenName.Text.Trim();
					gardenInfoInstance.GardenRegCode = textEdit_GardenRegCode.Text.Trim();
					gardenInfoInstance.GardenAddr = textEdit_GardenAddress.Text.Trim();
					gardenInfoInstance.GardenContact = textEdit_GardenContact.Text.Trim();
					gardenInfoInstance.GardenFeature = textEdit_GardenFeature.Text.Trim();
					gardenInfoInstance.GardenImage = writeInImage;

					try
					{
						int rowEffected = 0;
						GardenInfoSystem gardenInfoSystem = new GardenInfoSystem();
						rowEffected = gardenInfoSystem.InsertGardenInfo(gardenInfoInstance);
	
						if(rowEffected > 0)
						{
							MessageBox.Show("园所信息插入成功!","系统提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
						}
						else
						{
							MessageBox.Show("园所信息插入失败,请重试!","系统提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
						}
					}
					catch(Exception ex)
					{
						CPTT.SystemFramework.Util.WriteLog(ex.Message,CPTT.SystemFramework.Util.EXCEPTION_LOG_TITLE);
						MessageBox.Show("园所信息插入失败,请重试!","系统提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
					}
				}
				else//数据库中存在园所信息做修改
				{
					gardenInfoInstance.GardenID = gardenInfo.Tables[0].Rows[0]["info_gardenID"].ToString();
					gardenInfoInstance.GardenName = textEdit_GardenName.Text.Trim();
					gardenInfoInstance.GardenRegCode = textEdit_GardenRegCode.Text.Trim();
					gardenInfoInstance.GardenAddr = textEdit_GardenAddress.Text.Trim();
					gardenInfoInstance.GardenContact = textEdit_GardenContact.Text.Trim();
					gardenInfoInstance.GardenFeature = textEdit_GardenFeature.Text.Trim();
					gardenInfoInstance.GardenImage = writeInImage;

					try
					{
						int rowEffected = 0;
						GardenInfoSystem gardenInfoSystem = new GardenInfoSystem();
						rowEffected = gardenInfoSystem.UpdateGardenInfo(gardenInfoInstance);
	
						if(rowEffected > 0)
						{
							MessageBox.Show("园所信息修改成功!","系统提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
						}
						else
						{
							MessageBox.Show("园所信息修改失败,请重试!","系统提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
						}
					}
					catch(Exception ex)
					{
						CPTT.SystemFramework.Util.WriteLog(ex.Message,CPTT.SystemFramework.Util.EXCEPTION_LOG_TITLE);
						MessageBox.Show("园所信息修改失败,请重试!","系统提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
					}
				}
			}
			else
			{
				MessageBox.Show("请检查数据填写是否规范!","系统提示!",MessageBoxButtons.OK,MessageBoxIcon.Information);
			}
		}
Exemple #4
0
		/// <summary>
		/// 调用BusinessRule层更新幼儿园信息
		/// </summary>
		/// <param name="gardenInfo">要更改的GardenInfo</param>
		/// <returns>返回影响的行数</returns>
		public int UpdateGardenInfo(GardenInfo gardenInfo)
		{
			return new GardenInfoRule().UpdateGardenInfo(gardenInfo);
		}
Exemple #5
0
		/// <summary>
		/// 调用BusinessRule层插入幼儿园信息
		/// </summary>
		/// <param name="gardenInfo">要插入的GardenInfo</param>
		/// <returns>返回影响的行数</returns>
		public int InsertGardenInfo(GardenInfo gardenInfo)
		{
			return new GardenInfoRule().InsertGardenInfo(gardenInfo);
		}