public static void LoadCoalSeamsName(DataGridView dgv)
{
var coalSeams = CoalSeams.FindAll();
if (coalSeams != null)
{
DataBindListControl(dgv, coalSeams);
}
}
//public static void LoadWorkingFaceName(DataGridView dgv, int miningAreaId)
//{
// var workingFaces = WorkingFace.FindAllByMiningAreaId(miningAreaId);
// if (workingFaces != null) DataBindListControl(dgv, workingFaces);
//}
public static void LoadCoalSeamsName(ListControl lb, String
selectedText = "")
{
var coalSeams = CoalSeams.FindAll();
if (coalSeams != null)
{
DataBindListControl(lb, coalSeams,
"CoalSeamsName", "CoalSeamsId", selectedText);
}
}
private void AddTunnelInfo()
{
// 验证
if (!Check())
{
DialogResult = DialogResult.None;
return;
}
DialogResult = DialogResult.OK;
//创建巷道实体
var workingFace = selectWorkingFaceControl1.SelectedWorkingFace;
using (new SessionScope())
{
workingFace = WorkingFace.Find(workingFace.WorkingFaceId);
if (workingFace.Tunnels.FirstOrDefault(u => u.TunnelName == txtTunnelName.Text) != null)
{
Alert.alert("该工作面下已有同名巷道！");
return;
}
}
var tunnel = new Tunnel
{
TunnelName = txtTunnelName.Text,
TunnelSupportPattern = cboSupportPattern.Text,
WorkingFace = selectWorkingFaceControl1.SelectedWorkingFace,
Lithology = (Lithology)cboLithology.SelectedItem,
TunnelType = (TunnelTypeEnum)cboTunnelType.SelectedValue,
CoalOrStone = cboCoalOrStone.Text,
CoalSeams = CoalSeams.FindAll().First(),
BindingId = IDGenerator.NewBindingID(),
TunnelWid = 5
};
//设计长度
if (txtDesignLength.Text != "")
{
tunnel.TunnelDesignLength = Convert.ToInt32(txtDesignLength.Text);
}
if (txtDesignArea.Text != "")
{
tunnel.TunnelDesignArea = Convert.ToInt32(txtDesignLength.Text);
}
//巷道信息登录
tunnel.Save();
Alert.alert("提交成功！");
}
/// <summary>
/// <煤层>信息修改
/// </summary>
/// <param name="mineEntity"><煤层>实体</param>
/// <returns>成功与否：true，false</returns>
public static bool updateCoalSeamsInfo(CoalSeams coalSeamsEntity)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("UPDATE " + CoalSeamsDbConstNames.TABLE_NAME);
sqlStr.Append(" SET");
sqlStr.Append(" " + CoalSeamsDbConstNames.COAL_SEAMS_NAME +
" = '" + coalSeamsEntity.CoalSeamsName + "'");
sqlStr.Append(" WHERE " + CoalSeamsDbConstNames.COAL_SEAMS_ID +
" = " + coalSeamsEntity.CoalSeamsId);
ManageDataBase db = new
ManageDataBase(DATABASE_TYPE.GeologyMeasureDB);
bool bResult = db.OperateDB(sqlStr.ToString());
return(bResult);
}
/// <summary>
/// <煤层>信息登录
/// </summary>
/// <param name="coalSeamsEntity"><煤层>实体</param>
/// <returns>成功与否：true，false</returns>
public static bool insertCoalSeamsInfo(CoalSeams coalSeamsEntity)
{
StringBuilder sqlStr = new StringBuilder();
sqlStr.Append("INSERT INTO " +
CoalSeamsDbConstNames.TABLE_NAME);
sqlStr.Append(" (" + CoalSeamsDbConstNames.COAL_SEAMS_NAME);
sqlStr.Append(" )");
sqlStr.Append(" VALUES (");
sqlStr.Append(" '" + coalSeamsEntity.CoalSeamsName + "'");
sqlStr.Append(" )");
ManageDataBase db = new
ManageDataBase(DATABASE_TYPE.GeologyMeasureDB);
bool bResult = db.OperateDB(sqlStr.ToString());
return(bResult);
}
private void beDelete_ButtonClick(object sender, ButtonPressedEventArgs e)
{
if (!Alert.confirm("确认删除数据？"))
{
return;
}
switch (_typeFlag)
{
case FlagManangingMineName:
// 矿井名称管理
DeleteInfo <Mine>();
gridControl1.DataSource = CollectionHelper.ConvertTo(Mine.FindAll());
break;
case FlagManangingHorizontal:
// 水平名称管理
DeleteInfo <Horizontal>();
gridControl1.DataSource = CollectionHelper.ConvertTo(Horizontal.FindAll());
break;
case FlagManangingMiningArea:
// 采区名称管理
DeleteInfo <MiningArea>();
gridControl1.DataSource = CollectionHelper.ConvertTo(MiningArea.FindAll());
break;
case FlagManangingWorkingFace:
// 工作面名称管理
DeleteInfo <WorkingFace>();
gridControl1.DataSource = CollectionHelper.ConvertTo(WorkingFace.FindAll());
break;
case FlagManangingCoalSeam:
// 煤层名称管理
DeleteInfo <CoalSeams>();
gridControl1.DataSource = CollectionHelper.ConvertTo(CoalSeams.FindAll());
break;
}
}
private void UpdateTunnelInfo()
{
if (!Check())
{
DialogResult = DialogResult.None;
return;
}
DialogResult = DialogResult.OK;
Tunnel.WorkingFace = selectWorkingFaceControl1.SelectedWorkingFace;
//巷道名称
Tunnel.TunnelName = txtTunnelName.Text;
//支护方式
Tunnel.TunnelSupportPattern = cboSupportPattern.Text;
//围岩类型
Tunnel.Lithology = (Lithology)cboLithology.SelectedItem;
Tunnel.CoalSeams = CoalSeams.FindAll().First();
Tunnel.TunnelWid = 5;
//设计长度
if (txtDesignLength.Text != "")
{
Tunnel.TunnelDesignLength = Convert.ToInt32(txtDesignLength.Text);
}
if (txtDesignArea.Text != "")
{
Tunnel.TunnelDesignArea = Convert.ToInt32(txtDesignLength.Text);
}
//煤巷岩巷
if (cboCoalOrStone.Text != "")
{
Tunnel.CoalOrStone = cboCoalOrStone.Text;
}
Tunnel.Save();
Alert.alert("提交成功！");
}
private void btnReadMultTxt_Click(object sender, EventArgs e)
{
var ofd = new OpenFileDialog
{
RestoreDirectory = true,
Filter = @"文本文件(*.txt)|*.txt|所有文件(*.*)|*.*",
Multiselect = true
};
if (ofd.ShowDialog() != DialogResult.OK)
{
return;
}
_errorMsg = @"失败文件名：";
pbCount.Maximum = ofd.FileNames.Length;
pbCount.Value = 0;
lblTotal.Text = ofd.FileNames.Length.ToString(CultureInfo.InvariantCulture);
foreach (var fileName in ofd.FileNames)
{
var encoder = TxtFileEncoding.GetEncoding(fileName, Encoding.GetEncoding("GB2312"));
var sr = new StreamReader(fileName, encoder);
string duqu;
while ((duqu = sr.ReadLine()) != null)
{
try
{
var str = duqu.Split('|');
var borehole = Borehole.FindOneByBoreholeNum(str[0]) ??
new Borehole {
BindingId = IDGenerator.NewBindingID()
};
borehole.BoreholeNumber = str[0];
borehole.GroundElevation = Convert.ToDouble(str[3]);
borehole.CoordinateX = Convert.ToDouble(str[1].Split(',')[0]);
borehole.CoordinateY = Convert.ToDouble(str[1].Split(',')[1]);
borehole.CoordinateZ = 0;
borehole.CoalSeamsTexture = String.Empty;
// 创建钻孔岩性实体
var boreholeLithology = new BoreholeLithology
{
Borehole = borehole,
Lithology = Lithology.FindOneByCoal(),
FloorElevation = Convert.ToDouble(str[4]),
CoalSeamsName = CoalSeams.FindAll().First().CoalSeamsName,
Thickness = Convert.ToDouble(str[2]),
CoordinateX = Convert.ToDouble(str[1].Split(',')[0]),
CoordinateY = Convert.ToDouble(str[1].Split(',')[1]),
CoordinateZ = 0
};
borehole.BoreholeLithologys = new[] { boreholeLithology };
DrawZuanKong(borehole, boreholeLithology);
borehole.Save();
}
catch (Exception)
{
lblError.Text =
(Convert.ToInt32(lblError.Text) + 1).ToString(CultureInfo.InvariantCulture);
lblSuccessed.Text =
(Convert.ToInt32(lblSuccessed.Text) - 1).ToString(CultureInfo.InvariantCulture);
_errorMsg += fileName.Substring(fileName.LastIndexOf(@"\", StringComparison.Ordinal) + 1) + "\n";
btnDetails.Enabled = true;
}
}
lblSuccessed.Text =
(Convert.ToInt32(lblSuccessed.Text) + 1).ToString(CultureInfo.InvariantCulture);
pbCount.Value++;
}
Alert.alert("导入成功！");
}
/// <summary>
/// 带参数的构造方法
/// </summary>
/// <param name="typeFlag"></param>
/// <param name="id"></param>
public CommonManagement(int typeFlag, int id)
{
InitializeComponent();
Id = id;
_typeFlag = typeFlag;
switch (typeFlag)
{
case FlagManangingMineName:
{
// 窗口标题
Text = @"矿井名称管理";
AddIdColumn("编号", "MineId");
// 矿井名称
gridView1.Columns.Add(new GridColumn
{
Caption = @"矿井名称",
FieldName = "MineName",
VisibleIndex = gridView1.Columns.Count
});
AddDeleteButton();
gridControl1.DataSource = CollectionHelper.ConvertTo(Mine.FindAll());
}
break;
case FlagManangingHorizontal:
{
Text = @"水平名称管理";
AddIdColumn("编号", "HorizontalId");
// 矿井名称
gridView1.Columns.Add(new GridColumn
{
Caption = @"水平名称",
FieldName = "HorizontalName",
VisibleIndex = gridView1.Columns.Count
});
gridView1.Columns.Add(new GridColumn
{
Caption = @"所在矿区",
FieldName = "Mine",
ColumnEdit = lueMine,
VisibleIndex = gridView1.Columns.Count,
FilterMode = ColumnFilterMode.DisplayText
});
AddDeleteButton();
lueMine.DataSource = Mine.FindAll();
gridControl1.DataSource = CollectionHelper.ConvertTo(Horizontal.FindAll());
}
break;
case FlagManangingMiningArea:
{
Text = @"采区名称管理";
AddIdColumn("编号", "MiningAreaId");
// 矿井名称
gridView1.Columns.Add(new GridColumn
{
Caption = @"采区名称",
FieldName = "MiningAreaName",
VisibleIndex = gridView1.Columns.Count
});
// 所属水平
gridView1.Columns.Add(new GridColumn
{
Caption = @"所在水平",
FieldName = "Horizontal",
ColumnEdit = lueHorizontal,
VisibleIndex = gridView1.Columns.Count,
FilterMode = ColumnFilterMode.DisplayText
});
AddDeleteButton();
lueHorizontal.DataSource = Horizontal.FindAll();
gridControl1.DataSource = CollectionHelper.ConvertTo(MiningArea.FindAll());
}
break;
case FlagManangingWorkingFace:
{
Text = @"工作面名称管理";
AddIdColumn("编号", "WorkingFaceId");
// 矿井名称
gridView1.Columns.Add(new GridColumn
{
Caption = @"工作面名称",
FieldName = "WorkingFaceName",
VisibleIndex = gridView1.Columns.Count
});
gridView1.Columns.Add(new GridColumn
{
Caption = @"所在采区",
FieldName = "MiningArea",
ColumnEdit = lueMiningArea,
VisibleIndex = gridView1.Columns.Count,
FilterMode = ColumnFilterMode.DisplayText
});
AddDeleteButton();
lueMiningArea.DataSource = MiningArea.FindAll();
gridControl1.DataSource = CollectionHelper.ConvertTo(WorkingFace.FindAll());
}
break;
case FlagManangingCoalSeam:
{
//// 窗口标题
Text = @"煤层名称管理";
gridView1.Columns.Add(new GridColumn
{
Caption = @"编号",
FieldName = "CoalSeamsId",
MaxWidth = 60,
VisibleIndex = gridView1.Columns.Count
});
// 矿井名称
gridView1.Columns.Add(new GridColumn
{
Caption = @"煤层名称",
FieldName = "CoalSeamsName",
VisibleIndex = gridView1.Columns.Count
});
AddDeleteButton();
gridControl1.DataSource = CollectionHelper.ConvertTo(CoalSeams.FindAll());
}
break;
}
}
