zkadd.cs

煤矿信息管理系统是基于SuperMap Object

			this.numericUpDown_x.TabIndex = 1;
			this.numericUpDown_x.ThousandsSeparator = true;
			this.numericUpDown_x.Validated += new System.EventHandler(this.numericUpDown_x_Validated);
			// 
			// dateTimePicker_data
			// 
			this.dateTimePicker_data.Location = new System.Drawing.Point(286, 99);
			this.dateTimePicker_data.Name = "dateTimePicker_data";
			this.dateTimePicker_data.Size = new System.Drawing.Size(98, 21);
			this.dateTimePicker_data.TabIndex = 7;
			// 
			// txt_other
			// 
			this.txt_other.Location = new System.Drawing.Point(86, 128);
			this.txt_other.Multiline = true;
			this.txt_other.Name = "txt_other";
			this.txt_other.Size = new System.Drawing.Size(298, 48);
			this.txt_other.TabIndex = 8;
			this.txt_other.Text = "";
			// 
			// txt_com
			// 
			this.txt_com.Location = new System.Drawing.Point(286, 73);
			this.txt_com.Name = "txt_com";
			this.txt_com.Size = new System.Drawing.Size(98, 21);
			this.txt_com.TabIndex = 6;
			this.txt_com.Text = "";
			this.txt_com.Validated += new System.EventHandler(this.txt_com_Validated);
			// 
			// label10
			// 
			this.label10.Location = new System.Drawing.Point(38, 144);
			this.label10.Name = "label10";
			this.label10.Size = new System.Drawing.Size(32, 16);
			this.label10.TabIndex = 23;
			this.label10.Text = "备注";
			// 
			// label11
			// 
			this.label11.Location = new System.Drawing.Point(206, 81);
			this.label11.Name = "label11";
			this.label11.Size = new System.Drawing.Size(76, 16);
			this.label11.TabIndex = 20;
			this.label11.Text = "施工单位(*)";
			// 
			// label12
			// 
			this.label12.Location = new System.Drawing.Point(206, 104);
			this.label12.Name = "label12";
			this.label12.Size = new System.Drawing.Size(76, 16);
			this.label12.TabIndex = 19;
			this.label12.Text = "施工时间(*)";
			// 
			// label13
			// 
			this.label13.Location = new System.Drawing.Point(6, 77);
			this.label13.Name = "label13";
			this.label13.Size = new System.Drawing.Size(80, 16);
			this.label13.TabIndex = 2;
			this.label13.Text = "孔口坐标Y(*)";
			// 
			// label14
			// 
			this.label14.Location = new System.Drawing.Point(6, 102);
			this.label14.Name = "label14";
			this.label14.Size = new System.Drawing.Size(80, 16);
			this.label14.TabIndex = 3;
			this.label14.Text = "孔口坐标Z(*)";
			// 
			// label15
			// 
			this.label15.Location = new System.Drawing.Point(206, 30);
			this.label15.Name = "label15";
			this.label15.Size = new System.Drawing.Size(76, 16);
			this.label15.TabIndex = 21;
			this.label15.Text = "终孔深度(*)";
			// 
			// label16
			// 
			this.label16.Location = new System.Drawing.Point(14, 28);
			this.label16.Name = "label16";
			this.label16.Size = new System.Drawing.Size(72, 17);
			this.label16.TabIndex = 0;
			this.label16.Text = "钻孔编号(*)";
			// 
			// txt_no
			// 
			this.txt_no.Location = new System.Drawing.Point(88, 23);
			this.txt_no.Name = "txt_no";
			this.txt_no.Size = new System.Drawing.Size(96, 21);
			this.txt_no.TabIndex = 0;
			this.txt_no.Text = "";
			this.txt_no.Validated += new System.EventHandler(this.txt_no_Validated);
			// 
			// txt_lay
			// 
			this.txt_lay.Location = new System.Drawing.Point(286, 48);
			this.txt_lay.Name = "txt_lay";
			this.txt_lay.Size = new System.Drawing.Size(98, 21);
			this.txt_lay.TabIndex = 5;
			this.txt_lay.Text = "";
			this.txt_lay.Validated += new System.EventHandler(this.txt_lay_Validated);
			// 
			// label17
			// 
			this.label17.Location = new System.Drawing.Point(206, 54);
			this.label17.Name = "label17";
			this.label17.Size = new System.Drawing.Size(76, 16);
			this.label17.TabIndex = 22;
			this.label17.Text = "终孔层位(*)";
			// 
			// label18
			// 
			this.label18.Location = new System.Drawing.Point(6, 53);
			this.label18.Name = "label18";
			this.label18.Size = new System.Drawing.Size(80, 17);
			this.label18.TabIndex = 1;
			this.label18.Text = "孔口坐标X(*)";
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.dataGrid_lay);
			this.groupBox2.Location = new System.Drawing.Point(8, 192);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(688, 186);
			this.groupBox2.TabIndex = 9;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "钻孔煤层信息";
			// 
			// dataGrid_lay
			// 
			this.dataGrid_lay.CaptionVisible = false;
			this.dataGrid_lay.DataMember = "";
			this.dataGrid_lay.Dock = System.Windows.Forms.DockStyle.Fill;
			this.dataGrid_lay.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid_lay.Location = new System.Drawing.Point(3, 17);
			this.dataGrid_lay.Name = "dataGrid_lay";
			this.dataGrid_lay.Size = new System.Drawing.Size(682, 166);
			this.dataGrid_lay.TabIndex = 0;
			// 
			// erp
			// 
			this.erp.ContainerControl = this;
			// 
			// ZKAdd
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(704, 389);
			this.Controls.Add(this.groupBox4);
			this.Controls.Add(this.groupBox3);
			this.Controls.Add(this.groupBox2);
			this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedToolWindow;
			this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
			this.Name = "ZKAdd";
			this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen;
			this.Text = "钻孔数据添加";
			this.groupBox4.ResumeLayout(false);
			this.groupBox3.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.numericUpDown_h)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.numericUpDown_z)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.numericUpDown_y)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.numericUpDown_x)).EndInit();
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataGrid_lay)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		#region 得到输入的数据、验证数据

		private void get_value()
		{
			this.k_no = this.txt_no.Text.Trim();
			this.k_x = Convert.ToDouble(this.numericUpDown_x.Value);
			this.k_y = Convert.ToDouble(this.numericUpDown_y.Value);
			this.k_z = Convert.ToDouble(this.numericUpDown_z.Value);
			this.k_h = Convert.ToDouble(this.numericUpDown_h.Value);
			this.k_other = this.txt_other.Text.Trim();
			this.k_com = this.txt_com.Text.Trim();
			this.k_date = (DateTime)this.dateTimePicker_data.Value;
			this.k_lay = this.txt_lay.Text.Trim();
		}
		/// <summary>
		/// 设置错误信息和去掉错误信息
		/// </summary>
		/// <param name="no">是否错误</param>
		/// <param name="control">错误的对象</param>
		/// <param name="errstring">错误的信息</param>
		private void setErr(bool no,System.Windows.Forms.Control control,string errstring,ref bool b_ok)
		{
			if(no)
			{
				this.erp.SetError(control,errstring);
				b_ok = false;
			}
			else
			{ 
				this.erp.SetError(control,"");
				b_ok = true;
			}
		}

			
		#endregion

		#region 添加钻孔的基本信息 、添加相关煤层信息

		/// <summary>
		/// 判断钻孔是否存在
		/// </summary>
		/// <param name="k_no">钻孔的编号</param>
		/// <returns>true or false 不存在返回true</returns>
		private bool kong_isin(string  k_no)
		{
			DataBase myDB = new DataBase();
			SqlParameter[] myParamers={
											new SqlParameter("@k_id",SqlDbType.Char,10),
											new SqlParameter("@count",SqlDbType.Int)
										};
			myParamers[0].Value = k_no;
			myParamers[1].Direction = ParameterDirection.Output;
			if(myDB.RunProcedure_Nr("up_find_kong",myParamers))  
			{
				int m = Convert.ToInt32(myParamers[1].Value);
				if(m==0)
				{
					return true;
				}
				else
				{
					return false;
				}
			}
			else
			{
				return false;
			}
			
		}


		/// <summary>
		/// 开始添加钻孔的基本信息，并且得到该条纪录的id号
		/// </summary>
		/// <returns>添加是否成功</returns>
		private bool add_kong_ok()
		{
			DataBase myDB = new DataBase();
			SqlParameter[] myParamers={
										  new SqlParameter("@k_bianhao",SqlDbType.Char,10),
										  new SqlParameter("@x",SqlDbType.Float),
										  new SqlParameter("@y",SqlDbType.Float),
										  new SqlParameter("@z",SqlDbType.Float),
										  new SqlParameter("@shigong_time",SqlDbType.DateTime),
										  new SqlParameter("@shigong_danwei",SqlDbType.Char,30),
										  new SqlParameter("@beizhu",SqlDbType.VarChar,500),
										  new SqlParameter("@kong_shendu",SqlDbType.Float),
										  new SqlParameter("@kong_cengwei",SqlDbType.Char,5),
										  new SqlParameter("@k_id",SqlDbType.Int,4)       
									  } ;

			myParamers[0].Value = this.k_no;
			myParamers[1].Value = this.k_x;
			myParamers[2].Value = this.k_y;
			myParamers[3].Value = this.k_z;
			myParamers[4].Value = this.k_date;
			myParamers[5].Value = this.k_com;
			myParamers[6].Value = this.k_other;
			myParamers[7].Value = this.k_h;
			myParamers[8].Value = this.k_lay;
			myParamers[9].Direction = ParameterDirection.Output;
			if(myDB.RunProcedure_Nr("up_add_kong",myParamers))
			{
				this.k_id = Convert.ToInt32(myParamers[9].Value);
				return true;
			}
			else
			{
				MessageBox.Show("添加钻孔信息错误！","错误信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
				return false;
			}
		}


		/// <summary>
		/// 得到所有的填充选项
		/// </summary>
		/// <returns>DataSet 包含填充信息</returns>
		private DataSet get_fill()
		{
			DataSet yanset = new DataSet();