?? zkadd.cs
字號(hào):
DataBase myDB = new DataBase();
yanset = myDB.RunProcedure("get_yanxin","yan");
return yanset;
}
/// <summary>
/// 得到一個(gè)空的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; //顯示一個(gè)空的
myset = myDB.RunProcedure("up_get_ceng_info",myParamers,"null_lay");
return myset;
}
/// <summary>
/// 添加datagrid的列標(biāo)題
/// </summary>
/// <param name="myset">空的層位dataset</param>
/// <param name="yanset">下拉框的填充</param>
/// <param name="k_id">所添加的鉆孔的id號(hào)</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()["底板坐標(biāo)x"]));
GridTableStyle.GridColumnStyles[2].MappingName = "底板坐標(biāo)x";
GridTableStyle.GridColumnStyles[2].HeaderText = "底板坐標(biāo)x";
GridTableStyle.GridColumnStyles[2].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[2].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["底板坐標(biāo)y"]));
GridTableStyle.GridColumnStyles[3].MappingName = "底板坐標(biāo)y";
GridTableStyle.GridColumnStyles[3].HeaderText = "底板坐標(biāo)y";
GridTableStyle.GridColumnStyles[3].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[3].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["底板坐標(biāo)z"]));
GridTableStyle.GridColumnStyles[4].MappingName = "底板坐標(biāo)z";
GridTableStyle.GridColumnStyles[4].HeaderText = "底板坐標(biāo)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()["等級(jí)"]));
GridTableStyle.GridColumnStyles[10].MappingName = "等級(jí)";
GridTableStyle.GridColumnStyles[10].HeaderText = "等級(jí)";
GridTableStyle.GridColumnStyles[10].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[10].NullText = string.Empty;
GridTableStyle.GridColumnStyles.Add(new DataGridTextBoxColumn(objcengCM .GetItemProperties()["鉆孔序號(hào)"]));
GridTableStyle.GridColumnStyles[11].MappingName = "鉆孔序號(hào)";
GridTableStyle.GridColumnStyles[11].HeaderText = "鉆孔序號(hào)";
GridTableStyle.GridColumnStyles[11].Alignment = HorizontalAlignment.Left;
GridTableStyle.GridColumnStyles[11].Width =0; //隱藏起來(lái)不讓用戶輸入
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["鉆孔序號(hào)"].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 添加鉆孔有關(guān)的煤層信息 ，在地圖關(guān)聯(lián)鉆孔中添加相應(yīng)的紀(jì)錄
/// <summary>
/// 將與null_set關(guān)聯(lián)的datagrid里面的數(shù)據(jù)更新回?cái)?shù)據(jù)庫(kù)
/// </summary>
/// <returns></returns>
private bool add_lay()
{
DataBase myDB = new DataBase();
string selectaa = " select ceng.煤層名稱, ceng.止煤深度, ceng.底板坐標(biāo)x, ceng.底板坐標(biāo)y, ceng.底板坐標(biāo)z, ceng.煤層偽厚, ceng.煤層傾角, ceng.利用厚度, ceng.頂板巖性, ceng.底板巖性, ceng.鉆孔序號(hào), ceng.等級(jí) from 煤層關(guān)聯(lián)鉆孔 as ceng where 1>2";
if(myDB.Run_change(selectaa,this.null_Set,"null_lay"))
{
return true;
}
else
{
return false;
}
}
/// <summary>
/// 添加鉆孔關(guān)聯(lián)地圖的紀(jì)錄
/// </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,"鉆孔編號(hào)不能為空",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,"孔口坐標(biāo)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,"孔口坐標(biāo)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,"孔口坐標(biāo)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不需要驗(yàn)證。
}
if(submit_ok)
{
get_value(); //得到數(shù)據(jù)。準(zhǔn)備往數(shù)據(jù)庫(kù)里面添加
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();
//發(fā)送在圖上加點(diǎn)的事件
this.Send(xx,yy,zz,idd);
show_add_lay();
this.Cursor = Cursors.Default;
}
else
{
MessageBox.Show("鉆孔相關(guān)地圖記錄添加錯(cuò)誤","錯(cuò)誤提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
}
else
{
MessageBox.Show("該鉆孔信息已經(jīng)存在","錯(cuò)誤提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
else
{
MessageBox.Show("請(qǐng)將必需的數(shù)據(jù)填充完畢后再提交","錯(cuò)誤提示",MessageBoxButtons.OK,MessageBoxIcon.Warning);
}
}
private void button_add_ceng_Click(object sender, System.EventArgs e)
{
if(add_lay())
{
MessageBox.Show("相關(guān)煤層信息添加成功！","系統(tǒng)信息",MessageBoxButtons.OK,MessageBoxIcon.Information);
}
else
{
MessageBox.Show("相關(guān)煤層信息添加失敗！","錯(cuò)誤信息",MessageBoxButtons.OK,MessageBoxIcon.Error);
}
}
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -