📄 zkadd.cs
字号:
DataBase myDB = new DataBase();
yanset = myDB.RunProcedure("get_yanxin","yan");
return yanset;
}
/// <summary>
/// 得到一个空的dataset以接受煤层信息的输入
/// </summary>
/// <returns>DataSet 空的 包含煤层信息字段</returns>
private DataSet get_null_lay()
{
DataSet myset = new DataSet();
DataBase myDB = new DataBase();
SqlParameter[] myParamers={new SqlParameter("@k_id",SqlDbType.Char,10)} ;
myParamers[0].Value = 0; //显示一个空的
myset = myDB.RunProcedure("up_get_ceng_info",myParamers,"null_lay");
return myset;
}
/// <summary>
/// 添加datagrid的列标题
/// </summary>
/// <param name="myset">空的层位dataset</param>
/// <param name="yanset">下拉框的填充</param>
/// <param name="k_id">所添加的钻孔的id号</param>
private void Addstyle(DataSet myset,DataSet yanset,int k_id)
{
CurrencyManager objcengCM;
GridTableStyle = new DataGridTableStyle();
GridTableStyle.MappingName = "null_lay";
objcengCM = (System.Windows.Forms.CurrencyManager)this.BindingContext[myset.Tables[0]];
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["煤层名称"]));
GridTableStyle.GridColumnStyles[0].MappingName = "煤层名称";
GridTableStyle.GridColumnStyles[0].HeaderText = "煤层名称";
GridTableStyle.GridColumnStyles[0].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[0].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["止煤深度"]));
GridTableStyle.GridColumnStyles[1].MappingName = "止煤深度";
GridTableStyle.GridColumnStyles[1].HeaderText = "止煤深度";
GridTableStyle.GridColumnStyles[1].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[1].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["底板坐标x"]));
GridTableStyle.GridColumnStyles[2].MappingName = "底板坐标x";
GridTableStyle.GridColumnStyles[2].HeaderText = "底板坐标x";
GridTableStyle.GridColumnStyles[2].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[2].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["底板坐标y"]));
GridTableStyle.GridColumnStyles[3].MappingName = "底板坐标y";
GridTableStyle.GridColumnStyles[3].HeaderText = "底板坐标y";
GridTableStyle.GridColumnStyles[3].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[3].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["底板坐标z"]));
GridTableStyle.GridColumnStyles[4].MappingName = "底板坐标z";
GridTableStyle.GridColumnStyles[4].HeaderText = "底板坐标z";
GridTableStyle.GridColumnStyles[4].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[4].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["煤层伪厚"]));
GridTableStyle.GridColumnStyles[5].MappingName = "煤层伪厚";
GridTableStyle.GridColumnStyles[5].HeaderText = "煤层伪厚";
GridTableStyle.GridColumnStyles[5].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[5].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["利用厚度"]));
GridTableStyle.GridColumnStyles[6].MappingName = "利用厚度";
GridTableStyle.GridColumnStyles[6].HeaderText = "利用厚度";
GridTableStyle.GridColumnStyles[6].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[6].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["煤层倾角"]));
GridTableStyle.GridColumnStyles[7].MappingName = "煤层倾角";
GridTableStyle.GridColumnStyles[7].HeaderText = "煤层倾角";
GridTableStyle.GridColumnStyles[7].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[7].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridComboBoxColumn(yanset.Tables["yan"],0,0));
GridTableStyle.GridColumnStyles[8].MappingName = "顶板岩性";
GridTableStyle.GridColumnStyles[8].HeaderText = "顶板岩性";
GridTableStyle.GridColumnStyles[8].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[8].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridComboBoxColumn(yanset.Tables["yan"],0,0));
GridTableStyle.GridColumnStyles[9].MappingName = "底板岩性";
GridTableStyle.GridColumnStyles[9].HeaderText = "底板岩性";
GridTableStyle.GridColumnStyles[9].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[9].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["等级"]));
GridTableStyle.GridColumnStyles[10].MappingName = "等级";
GridTableStyle.GridColumnStyles[10].HeaderText = "等级";
GridTableStyle.GridColumnStyles[10].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[10].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["钻孔序号"]));
GridTableStyle.GridColumnStyles[11].MappingName = "钻孔序号";
GridTableStyle.GridColumnStyles[11].HeaderText = "钻孔序号";
GridTableStyle.GridColumnStyles[11].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[11].Width =0; //隐藏起来不让用户输入
GridTableStyle.GridColumnStyles[11].NullText = k_id.ToString();
GridTableStyle.GridColumnStyles[11].ReadOnly = true;
}
private void show_add_lay()
{
this.null_Set = get_null_lay();
null_Set.Tables[0].Columns["钻孔序号"].DefaultValue = this.k_id;
DataSet yanset = new DataSet();
yanset = get_fill();
Addstyle(this.null_Set,yanset,this.k_id);
this.dataGrid_lay.DataSource = this.null_Set;
this.dataGrid_lay.DataMember="null_lay";
this.dataGrid_lay.TableStyles.Add(this.GridTableStyle);
}
#endregion
#region 添加钻孔有关的煤层信息 ，在地图关联钻孔中添加相应的纪录
/// <summary>
/// 将与null_set关联的datagrid里面的数据更新回数据库
/// </summary>
/// <returns></returns>
private bool add_lay()
{
DataBase myDB = new DataBase();
string selectaa = " select ceng.煤层名称, ceng.止煤深度, ceng.底板坐标x, ceng.底板坐标y, ceng.底板坐标z, ceng.煤层伪厚, ceng.煤层倾角, ceng.利用厚度, ceng.顶板岩性, ceng.底板岩性, ceng.钻孔序号, ceng.等级 from 煤层关联钻孔 as ceng where 1>2";
if(myDB.Run_change(selectaa,this.null_Set,"null_lay"))
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 添加钻孔关联地图的纪录
/// </summary>
/// <param name="kong_id">钻孔的id</param>
/// <param name="map_id">地图的id</param>
/// <returns></returns>
private bool add_map_kong(int kong_id,int map_id)
{
DataBase myDB = new DataBase();
SqlParameter[] myParamers={
new SqlParameter("@k_id",SqlDbType.Int),
new SqlParameter("@map_id",SqlDbType.Int)
};
myParamers[0].Value = kong_id;
myParamers[1].Value = map_id;
if(myDB.RunProcedure_Nr("up_add_map_kong",myParamers))
{
return true;
}
else
{
return false;
}
}
#endregion
private void txt_no_Validated(object sender, System.EventArgs e)
{
bool no = (this.txt_no.Text.Length == 0);
setErr(no,this.txt_no,"钻孔编号不能为空",ref this.bk_no);
}
private void txt_lay_Validated(object sender, System.EventArgs e)
{
bool no = (this.txt_lay.Text.Length == 0);
setErr(no,this.txt_lay,"终孔层位不能为空",ref this.bk_lay);
}
private void txt_com_Validated(object sender, System.EventArgs e)
{
bool no = (this.txt_com.Text.Length == 0);
setErr(no,this.txt_com,"施工单位不能为空",ref this.bk_com);
}
private void numericUpDown_x_Validated(object sender, System.EventArgs e)
{
bool no = (Convert.ToDouble(this.numericUpDown_x.Value) == 0);
setErr(no,this.numericUpDown_x,"孔口坐标X不能为“0”",ref this.bk_x);
}
private void numericUpDown_y_Validated(object sender, System.EventArgs e)
{
bool no = (Convert.ToDouble(this.numericUpDown_y.Value) == 0);
setErr(no,this.numericUpDown_y,"孔口坐标Y不能为“0”",ref this.bk_y);
}
private void numericUpDown_z_Validated(object sender, System.EventArgs e)
{
bool no = (Convert.ToDouble(this.numericUpDown_z.Value) == 0);
setErr(no,this.numericUpDown_z,"孔口坐标Z不能为“0”",ref this.bk_z);
}
private void numericUpDown_h_Validated(object sender, System.EventArgs e)
{
bool no = (Convert.ToDouble(this.numericUpDown_h.Value) == 0);
setErr(no,this.numericUpDown_h,"终孔深度不能为“0”",ref this.bk_h);
}
private void button_add_kong_Click(object sender, System.EventArgs e)
{
bool submit_ok = false;
if(this.point ==false)
{
submit_ok = bk_no & bk_x & bk_y & bk_z & bk_h & bk_com & bk_lay;
}
else
{
submit_ok = bk_no & bk_z & bk_h & bk_com & bk_lay; //图上添加的,x，y不需要验证。
}
if(submit_ok)
{
get_value(); //得到数据。准备往数据库里面添加
if(kong_isin(this.k_no))
{
if(add_kong_ok())
{
if(add_map_kong(this.k_id,1))
{
this.Cursor = Cursors.WaitCursor;
this.button_add_kong.Enabled = false;
this.button_add_ceng.Enabled = true;
double xx = Convert.ToDouble(this.numericUpDown_x.Value);
double yy = Convert.ToDouble(this.numericUpDown_y.Value);
double zz = Convert.ToDouble(this.numericUpDown_z.Value);
string idd = this.txt_no.Text.Trim();
//发送在图上加点的事件
this.Send(xx,yy,zz,idd);
show_add_lay();
this.Cursor = Cursors.Default;
}
else
{
MessageBox.Show("钻孔相关地图记录添加错误","错误提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
}
else
{
MessageBox.Show("该钻孔信息已经存在","错误提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("请将必需的数据填充完毕后再提交","错误提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
private void button_add_ceng_Click(object sender, System.EventArgs e)
{
if(add_lay())
{
MessageBox.Show("相关煤层信息添加成功！","系统信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
else
{
MessageBox.Show("相关煤层信息添加失败！","错误信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -