/// <summary>
/// 删除按钮事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tsBtnDel_Click(object sender, EventArgs e)
{
//确认删除
if (!Alert.confirm(Const.DEL_CONFIRM_MSG))
{
return;
}
//using (new SessionScope())
//{
var entity = (DayReportHc)gridView1.GetFocusedRow();
var workingFace = WorkingFace.Find(entity.WorkingFace.WorkingFaceId);
// 掘进工作面，只有一条巷道
var workingFaceHc = WorkingFaceHc.FindByWorkingFace(workingFace);
if (workingFaceHc != null)
{
DelHcjc(workingFaceHc.TunnelZy.TunnelId, workingFaceHc.TunnelFy.TunnelId,
workingFaceHc.TunnelQy.TunnelId, entity.BindingId,
workingFace,
workingFaceHc.TunnelZy.TunnelWid, workingFaceHc.TunnelFy.TunnelWid);
entity.Delete();
RefreshData();
// 向server端发送更新预警数据
var msg = new UpdateWarningDataMsg(entity.WorkingFace.WorkingFaceId,
Const.INVALID_ID,
DayReportHc.TableName, OPERATION_TYPE.DELETE, DateTime.Now);
SocketUtil.SendMsg2Server(msg);
}
else
{
Alert.alert("该工作面没有关联主运、辅运、切眼巷道");
}
//}
}
public SelectTunnelDlg(WorkingFace workingFace)
{
InitializeComponent();
//窗体属性设置
FormDefaultPropertiesSetter.SetEnteringFormDefaultProperties(this, Const_GM.TUNNEL_CHOOSE);
selectTunnelUserControl1.LoadData(workingFace);
}
private void SelectTunnelSimple_Load(object sender, EventArgs e)
{
if (System.IO.File.Exists(@"RecentWorkingfaces.xml"))
{
var doc = new XmlDocument();
doc.Load(@"RecentWorkingfaces.xml");
if (doc.DocumentElement != null)
{
var nodes = doc.DocumentElement.SelectNodes("/Workingfaces/Workingface");
if (nodes != null)
{
foreach (var workingface in (from XmlNode node in nodes
select node.SelectSingleNode("ID")
into selectSingleNode
where selectSingleNode != null
select selectSingleNode.InnerText
into id
select WorkingFace.TryFind(Convert.ToInt32(id))).Where(workingface => workingface != null))
{
cbxWorkingface.Items.Add(workingface);
}
}
}
}
}
public void LoadData(WorkingFace workingFace)
{
LoadData();
lstMineName.SelectedValue = workingFace.MiningArea.Horizontal.Mine.MineId;
lstHorizontalName.SelectedValue = workingFace.MiningArea.Horizontal.HorizontalId;
lstMiningAreaName.SelectedValue = workingFace.MiningArea.MiningAreaId;
lstWorkingFaceName.SelectedValue = workingFace.WorkingFaceId;
}
/// <summary>
/// 构造方法
/// </summary>
/// <param name="tunnelHcEntity">回采面实体</param>
public TunnelHcEntering(WorkingFace tunnelHcEntity)
{
_workingFace = ObjectCopier.Clone(tunnelHcEntity);
Text = Const_GM.TUNNEL_HC_CHANGE;
InitializeComponent();
FormDefaultPropertiesSetter.SetEnteringFormDefaultProperties(this, Const_GM.TUNNEL_HC_CHANGE);
}
public static bool JudgeWorkingFaceIsAssociated(WorkingFace workingFace)
{
using (new SessionScope())
{
var workingFaceLazy = WorkingFace.Find(workingFace.WorkingFaceId);
var tunnelZy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_ZY);
var tunnelFy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_FY);
var tunnelQy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_QY);
return(tunnelZy != null && tunnelFy != null && tunnelQy != null);
}
}
private void lstWorkingFaceName_SelectedIndexChanged(object sender, EventArgs e)
{
if (lstWorkingFaceName.SelectedItems.Count <= 0)
{
SelectedWorkingFace = null;
}
else
{
SelectedWorkingFace = (WorkingFace)lstWorkingFaceName.SelectedItem;
}
}
public static void LoadWorkingFaceName(ListControl lb, int
miningAreaId, String selectedText = "")
{
var workingFaces =
WorkingFace.FindAllByMiningAreaId(miningAreaId);
if (workingFaces != null)
{
DataBindListControl(lb, workingFaces, "WorkingFaceName",
"WorkingFaceId", selectedText);
}
}
private WorkingFace AddWorkingFace(MiningArea miningArea, String workingFaceName)
{
var workingFace = new WorkingFace
{
WorkingFaceName = workingFaceName,
MiningArea = miningArea,
WorkingfaceTypeEnum = WorkingfaceTypeEnum.HC
};
workingFace.Save();
return(workingFace);
}
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="sender"></param>
/// <param name="e"></param>
private void btnChooseWorkFace_Click(object sender, EventArgs e)
{
//工作面选择窗体
var selectWF = new SelectWorkingFaceDlg();
//巷道选择完毕
if (DialogResult.OK == selectWF.ShowDialog())
{
//巷道选择按钮Text改变
btnChooseWorkFace.Text = selectWF.SelectedWorkingFace.WorkingFaceName;
//实体赋值
jjWorkFaceEntity = selectWF.SelectedWorkingFace;
}
}
private Tunnel AddTunnel(WorkingFace workingFace, string tunnelName)
{
var type = tunnelName.Contains("横川") ? TunnelTypeEnum.HENGCHUAN : TunnelTypeEnum.OTHER;
var tunnel = new Tunnel
{
TunnelName = tunnelName,
WorkingFace = workingFace,
TunnelWid = 5,
BindingId = IDGenerator.NewBindingID(),
TunnelType = type
};
tunnel.Save();
return(tunnel);
}
/// <summary>
/// 获取班次中的时间范围，返回值例：起始时间2014-03-18 08:00:00.000，结束时间2014-03-18 16:00:00.000
/// </summary>
/// <param name="strWorkTimeName"></param>
/// <param name="strDate"></param>
/// <returns></returns>
//public static string[] GetDateShiftTimes(string strWorkTimeName, string strDate)
//{
// //select WORK_TIME_FROM,WORK_TIME_TO from T_WORK_TIME where WORK_TIME_NAME ='早班'
// string[] times = null;
// StringBuilder strSql = new StringBuilder();
// strSql.Append("SELECT ");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.WORK_TIME_FROM + ",");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.WORK_TIME_TO);
// strSql.Append(" FROM ");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.TABLE_NAME);
// strSql.Append(" WHERE ");
// strSql.Append(LibBusiness.WorkTimeDbConstNames.WORK_TIME_NAME);
// strSql.Append(" = ");
// strSql.Append("'" + strWorkTimeName + "'");
// DataSet ds = _database.ReturnDSNotOpenAndClose(strSql.ToString());
// if (ds != null)
// {
// DataTable dt = ds.Tables[0];
// if (dt != null)
// {
// //2014-03-05 15:43:45.000
// if (dt.Rows.Count > 0)
// {
// times = new string[2];
// times[0] = strDate + " " + dt.Rows[0][LibBusiness.WorkTimeDbConstNames.WORK_TIME_FROM].ToString();
// times[1] = strDate + " " + dt.Rows[0][LibBusiness.WorkTimeDbConstNames.WORK_TIME_TO].ToString();
// }
// }
// }
// return times;
//}
/// <summary>
/// 根据tunelID,查找巷道名称。若属于回采巷道，返回工作面名称
/// </summary>
/// <param name="tunelId"></param>
/// <returns></returns>
public static string GetTunelNameByTunelID(string tunelId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT ");
strSql.Append(TunnelInfoDbConstNames.TUNNEL_NAME + ",");
strSql.Append(TunnelInfoDbConstNames.TUNNEL_TYPE + ",");
strSql.Append(TunnelInfoDbConstNames.WORKINGFACE_ID);
strSql.Append(" FROM ");
strSql.Append(TunnelInfoDbConstNames.TABLE_NAME);
strSql.Append(" WHERE ");
strSql.Append(TunnelInfoDbConstNames.ID);
strSql.Append(" = ");
strSql.Append(tunelId);
DataTable dt =
_database.ReturnDSNotOpenAndClose(strSql.ToString()).Tables[0];
if (dt != null)
{
if (dt.Rows.Count > 0)
{
//判断是否属于回采巷道
if
(TunnelUtils.IsStoping((TunnelTypeEnum)Convert.ToInt32(dt.Rows[0][LibBusiness.TunnelInfoDbConstNames.TUNNEL_TYPE])))
{
//获取工作面名称
int workFaceId;
int.TryParse(dt.Rows[0][TunnelInfoDbConstNames.WORKINGFACE_ID].ToString(),
out workFaceId);
WorkingFace workingFace =
WorkingFace.Find(workFaceId);
if (workingFace != null)
{
return(workingFace.WorkingFaceName);
}
}
else
{
return
(dt.Rows[0][LibBusiness.TunnelInfoDbConstNames.TUNNEL_NAME].ToString());
}
}
}
return("");
}
/// <summary>
/// 窗体登陆时加载
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void PreWarningResultQuery_Load(object sender, EventArgs e)
{
#region 设定默认的时间
_dtpStartTime.ValueChanged -= _dtpStartTime_ValueChanged;
_dtpEndTime.ValueChanged -= _dtpStartTime_ValueChanged;
_dtpEndTime.Value = DateTime.Now;
_dtpStartTime.Value = DateTime.Now.AddDays(-1);
_dtpStartTime.ValueChanged += _dtpStartTime_ValueChanged;
_dtpEndTime.ValueChanged += _dtpStartTime_ValueChanged;
#endregion
//加载预警类型
//AddWarningType();
var workingFace = WorkingFace.FindAll();
_cbxSelWorkSurface.Items.Add("全部");
_cbxSelWorkSurface.SelectedIndex = 0;
foreach (var t in workingFace)
{
_cbxSelWorkSurface.Items.Add(t.WorkingFaceName);
}
//设置farpoint显示行列数
_fpTunelInfo.ActiveSheet.RowCount = 0;
for (var i = 5; i < COLUMN_COUNT; i++)
{
_fpTunelInfo.ActiveSheet.Columns[i].Visible = false;
}
//Mark By QinKai，若添加新的预警依据项，需要更改的内容
//加载预警依据的类别
var WaringItemTypeNames = Enum.GetNames(typeof(WarningReasonItems));
cbWarningType.SelectedIndex = 0;
for (var index = 0; index < WaringItemTypeNames.Length; index++)
{
infoCells[_iDetailsRowHeaderCount + index, 0].Text = WaringItemTypeNames[index];
infoCells[WaringItemTypeNames.Length + _iDetailsRowHeaderCount * 2 + index, 0].Text =
WaringItemTypeNames[index];
}
}
public static WorkingFaceHc FindByWorkingFace(WorkingFace workingFace)
{
using (new SessionScope())
{
var workingFaceLazy = WorkingFace.Find(workingFace.WorkingFaceId);
var tunnelZy = workingFaceLazy.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_ZY);
var tunnelFy = workingFaceLazy.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_FY);
var tunnelQy = workingFaceLazy.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_QY);
var tunnelOther = workingFaceLazy.Tunnels.Where(u => u.TunnelType == TunnelTypeEnum.OTHER).ToList();
var result = new WorkingFaceHc
{
WorkingFace = workingFace,
TunnelZy = tunnelZy,
TunnelFy = tunnelFy,
TunnelQy = tunnelQy,
TunnelOther = tunnelOther
};
return(result);
}
}
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;
}
}
public static List <WorkingFaceHc> FindAll()
{
var results = new List <WorkingFaceHc>();
using (new SessionScope())
{
var workingFaces = WorkingFace.FindAll();
results.AddRange(from workingFace in workingFaces
let tunnelZy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_ZY)
let tunnelFy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_FY)
let tunnelQy = workingFace.Tunnels.FirstOrDefault(u => u.TunnelType == TunnelTypeEnum.STOPING_QY)
let tunnelOther = workingFace.Tunnels.Where(u => u.TunnelType == TunnelTypeEnum.OTHER).ToList()
where tunnelZy != null && tunnelFy != null && tunnelQy != null
select new WorkingFaceHc
{
WorkingFace = workingFace,
TunnelZy = tunnelZy,
TunnelFy = tunnelFy,
TunnelQy = tunnelQy,
TunnelOther = tunnelOther
});
}
return(results);
}
//public SelectWorkingFaceDlg(params WorkingfaceTypeEnum[] workingfaceTypes)
//{
// InitializeComponent();
// //SetFilterOn(workingfaceTypes);
// this.selectWorkingFaceControl1.LoadData();
//}
//private void SetFilterOn(WorkingfaceTypeEnum workingfaceType)
//{
// this.selectWorkingFaceControl1.SetFilterOn(workingfaceType);
//}
//private void SetFilterOn(params WorkingfaceTypeEnum[] types)
//{
// //this.selectWorkingFaceControl1.SetFilterOn(types);
//}
private void btnOK_Click(object sender, EventArgs e)
{
SelectedWorkingFace = selectWorkingFaceControl1.SelectedWorkingFace;
DialogResult = DialogResult.OK;
}
private void btnTXT_Click(object sender, EventArgs e)
{
var ofd = new OpenFileDialog {
RestoreDirectory = true, Filter = @"文本文件(*.txt)|*.txt|所有文件(*.*)|*.*"
};
if (ofd.ShowDialog() != DialogResult.OK)
{
return;
}
var fileName = ofd.SafeFileName;
if (fileName != null)
{
var strs = fileName.Split('-');
var miningAreaName = strs[0];
var workingFaceName = strs[1];
var tunnelName = strs[2].Split('.')[0];
using (new SessionScope())
{
var miningArea = MiningArea.FindOneByMiningAreaName(miningAreaName);
if (miningArea == null)
{
Alert.confirm("该采区不存在，请先添加采区");
return;
}
var workingFace = WorkingFace.FindByWorkingFaceNameAndMiningAreaId(workingFaceName, miningArea.MiningAreaId);
if (workingFace == null)
{
if (Alert.confirm("该工作面不存在，是否创建该工作面？"))
{
workingFace = AddWorkingFace(miningArea, workingFaceName);
}
}
if (workingFace == null)
{
return;
}
if (workingFace.Tunnels != null &&
workingFace.Tunnels.FirstOrDefault(u => u.TunnelName == tunnelName) != null)
{
var tunnel = workingFace.Tunnels.FirstOrDefault(u => u.TunnelName == tunnelName);
selectTunnelUserControl1.LoadData(tunnel);
}
else
{
if (Alert.confirm("该巷道不存在，是否创建该巷道？"))
{
if (Tunnel.ExistsByTunnelNameAndWorkingFaceId(tunnelName, workingFace.WorkingFaceId))
{
Alert.alert("该巷道已经存在");
return;
}
var tunnel = AddTunnel(workingFace, tunnelName);
selectTunnelUserControl1.LoadData(tunnel);
}
}
}
txtWireName.Text = tunnelName.Split('.').Length > 0
? tunnelName.Split('.')[0] + "导线点"
: tunnelName + "导线点";
}
var sr = new StreamReader(ofd.FileName, Encoding.GetEncoding("GB2312"));
string duqu;
while ((duqu = sr.ReadLine()) != null)
{
var temp1 = duqu.Split('|');
if (temp1.Length == 1)
{
continue;
}
var daoxianname = temp1[0];
var daoxianx = temp1[1];
var daoxiany = temp1[2];
dgrdvWire.Rows.Add(1);
dgrdvWire[0, dgrdvWire.Rows.Count - 2].Value = daoxianname;
dgrdvWire[1, dgrdvWire.Rows.Count - 2].Value = daoxianx;
dgrdvWire[2, dgrdvWire.Rows.Count - 2].Value = daoxiany;
dgrdvWire[3, dgrdvWire.Rows.Count - 2].Value = "0";
dgrdvWire[4, dgrdvWire.Rows.Count - 2].Value = "2.5";
dgrdvWire[5, dgrdvWire.Rows.Count - 2].Value = "2.5";
}
}
/// <summary>
/// 删除GIS回采进尺图形信息
/// </summary>
/// <param name="hd1">主运顺槽id</param>
/// <param name="hd2">辅运顺槽id</param>
/// <param name="qy">切眼id</param>
/// <param name="bid">回采进尺的BindingID</param>
/// <param name="wfEntity">回采面实体</param>
/// <param name="zywid"></param>
/// <param name="fywid"></param>
private void DelHcjc(int hd1, int hd2, int qy, string bid, WorkingFace wfEntity, double zywid, double fywid)
{
//删除对应的回采进尺图形和数据表中的记录信息
var results = Global.cons.DelHCCD(hd1.ToString(CultureInfo.InvariantCulture),
hd2.ToString(CultureInfo.InvariantCulture), qy.ToString(CultureInfo.InvariantCulture), bid, zywid, fywid,
Global.searchlen);
if (results == null)
{
return;
}
//更新当前回采进尺后的回采进尺记录表信息
var count = results.Keys.Count;
var index = 0;
IPoint posnew = null;
foreach (var key in results.Keys)
{
var x = results[key].X;
var y = results[key].Y;
var z = results[key].Z;
wfEntity.SetCoordinate(x, y, z);
wfEntity.Save();
index += 1;
if (index == count - 1)
{
posnew = new PointClass {
X = x, Y = y, Z = z
};
}
}
//更新回采进尺表，将isdel设置0
var entity = DayReportHc.FindByBid(bid);
entity.IsDel = 0;
entity.SaveAndFlush();
//更新地质构造表中的信息
if (posnew == null)
{
return;
}
var hdIds = new List <int> {
hd1, hd2, qy
};
var dzxlist = Global.commonclss.GetStructsInfos(posnew, hdIds);
if (dzxlist.Count > 0)
{
GeologySpaceBll.DeleteGeologySpaceEntityInfos(wfEntity.WorkingFaceId); //删除工作面ID对应的地质构造信息
foreach (var key in dzxlist.Keys)
{
var geoinfos = dzxlist[key];
foreach (var tmp in geoinfos)
{
var geologyspaceEntity = new GeologySpace
{
WorkingFace = wfEntity,
TectonicType = Convert.ToInt32(key),
TectonicId = tmp.geoinfos[GIS_Const.FIELD_BID],
Distance = tmp.dist,
OnDateTime = DateTime.Now.ToShortDateString()
};
geologyspaceEntity.Save();
}
}
}
}
/// <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;
}
}
public SelectWorkingFaceControl(WorkingFace workingFace)
{
LoadData(workingFace);
}
public void cbxTunnel_SelectedIndexChanged(object sender, EventArgs e)
{
SelectedWorkingFace = cbxWorkingface.SelectedItem as WorkingFace;
}
/// <summary>
/// 验证
/// </summary>
/// <returns></returns>
private bool check()
{
//巷道是否选择
if (selectWorkingfaceSimple1.SelectedWorkingFace == null)
{
Alert.alert(Const.MSG_PLEASE_CHOOSE + Const_MS.TUNNEL + Const.SIGN_EXCLAMATION_MARK);
return(false);
}
if (selectWorkingfaceSimple1.SelectedWorkingFace != null)
{
using (new SessionScope())
{
var workingFace = WorkingFace.Find(selectWorkingfaceSimple1.SelectedWorkingFace.WorkingFaceId);
if (workingFace.Tunnels.Count != 1)
{
Alert.alert("您选择的巷道不是掘进巷道");
return(false);
}
}
}
//队别为空
if (Validator.IsEmpty(cboTeamName.Text))
{
Alert.alert(Const.MSG_PLEASE_TYPE_IN + Const_MS.TEAM_NAME + Const.SIGN_EXCLAMATION_MARK);
return(false);
}
//队别名称是否有特殊字符
if (Validator.checkSpecialCharacters(cboTeamName.Text))
{
Alert.alert(Const_MS.TEAM_NAME + Const.MSG_SP_CHAR + Const.SIGN_EXCLAMATION_MARK);
return(false);
}
//填报人是否有特殊字符
if (Validator.checkSpecialCharacters(cboSubmitter.Text))
{
Alert.alert(Const_MS.SUBMITTER + Const.MSG_SP_CHAR + Const.SIGN_EXCLAMATION_MARK);
return(false);
}
//datagridview验证
//只有一条数据时
if (dgrdvDayReportJJ.Rows.Count - 1 == 0)
{
//添加时判断为未录入进尺
if (Text == Const_MS.DAY_REPORT_JJ_ADD)
{
Alert.alert(Const.MSG_PLEASE_TYPE_IN + Const_MS.JC + Const.SIGN_EXCLAMATION_MARK);
return(false);
}
//修改时
var bResult = false;
//为空返回false，不数据时跳出循环
for (var i = 0; i < dgrdvDayReportJJ.ColumnCount; i++)
{
if (dgrdvDayReportJJ[i, 0].Value == null)
{
bResult = false;
}
else
{
bResult = true;
break;
}
}
if (!bResult)
{
Alert.alert(Const.MSG_PLEASE_TYPE_IN + Const_MS.JC);
return(bResult);
}
}
for (var i = 0; i < dgrdvDayReportJJ.RowCount; i++)
{
// 最后一行为空行时，跳出循环
if (i == dgrdvDayReportJJ.RowCount - 1)
{
break;
}
var cell = dgrdvDayReportJJ.Rows[i].Cells[C_WORK_PROGRESS] as DataGridViewTextBoxCell;
//进尺为空
if (cell.Value == null)
{
if (Const_MS.JJ == dgrdvDayReportJJ[C_WORK_PROGRESS, i].Value.ToString())
{
cell.Style.BackColor = Const.ERROR_FIELD_COLOR;
Alert.alert(Const_MS.JC + Const.MSG_NOT_NULL + Const.SIGN_EXCLAMATION_MARK);
return(false);
}
cell.Style.BackColor = Const.NO_ERROR_FIELD_COLOR;
}
else
{
cell.Style.BackColor = Const.NO_ERROR_FIELD_COLOR;
}
//进尺不为数字
if (cell.Value != null && !Validator.IsNumeric(cell.Value.ToString()))
{
cell.Style.BackColor = Const.ERROR_FIELD_COLOR;
Alert.alert(Const_MS.JC + Const.MSG_MUST_NUMBER + Const.SIGN_EXCLAMATION_MARK);
return(false);
}
cell.Style.BackColor = Const.NO_ERROR_FIELD_COLOR;
cell = dgrdvDayReportJJ.Rows[i].Cells[C_COMMENTS] as DataGridViewTextBoxCell;
}
//验证成功
return(true);
}
///// <param name="verticesBtmRet">Vector3_DW数据</param>
/// <summary>
/// 根据导线点坐标绘制巷道
/// </summary>
/// <summary>
/// 获得导线边线点坐标集
/// </summary>
/// <returns>导线边线点坐标集List</returns>
//private List<IPoint> GetTunnelPts(Vector3_DW[] verticesBtmRet)
//{
// var lstBtmRet = new List<IPoint>();
// try
// {
// Vector3_DW vector3dw;
// IPoint pt;
// for (int i = 0; i < verticesBtmRet.Length; i++)
// {
// vector3dw = new Vector3_DW();
// vector3dw = verticesBtmRet[i];
// pt = new PointClass();
// pt.X = vector3dw.X;
// pt.Y = vector3dw.Y;
// pt.Z = vector3dw.Z;
// if (!lstBtmRet.Contains(pt))
// {
// lstBtmRet.Add(pt);
// }
// }
// return lstBtmRet;
// }
// catch
// {
// return null;
// }
//}
#endregion 绘制导线点和巷道图形
private void btnMultTxt_Click(object sender, EventArgs e)
{
var ofd = new OpenFileDialog
{
RestoreDirectory = true,
Multiselect = true,
Filter = @"文本文件(*.txt)|*.txt|所有文件(*.*)|*.*"
};
_errorMsg = @"失败文件名：";
if (ofd.ShowDialog() != DialogResult.OK)
{
return;
}
var fileCount = ofd.FileNames.Length;
pbCount.Maximum = fileCount * 2;
pbCount.Value = 0;
foreach (var fileName in ofd.FileNames)
{
lblTotal.Text = fileCount.ToString(CultureInfo.InvariantCulture);
string safeFileName = null;
try
{
using (new SessionScope())
{
safeFileName = fileName.Substring(fileName.LastIndexOf(@"\", StringComparison.Ordinal) + 1);
var strs = safeFileName.Split('-');
var miningAreaName = strs[0];
var workingFaceName = strs[1];
var tunnelName = strs[2].Split('.')[0];
var miningArea = MiningArea.FindOneByMiningAreaName(miningAreaName);
if (miningArea == null)
{
Alert.confirm("该采区不存在，请先添加采区");
return;
}
var workingFace = WorkingFace.FindByWorkingFaceNameAndMiningAreaId(workingFaceName, miningArea.MiningAreaId);
if (workingFace == null)
{
workingFace = AddWorkingFace(miningArea, workingFaceName);
}
if (workingFace == null)
{
return;
}
Tunnel tunnel;
if (workingFace.Tunnels != null &&
workingFace.Tunnels.FirstOrDefault(u => u.TunnelName == tunnelName) != null)
{
tunnel = workingFace.Tunnels.FirstOrDefault(u => u.TunnelName == tunnelName);
}
else
{
tunnel = AddTunnel(workingFace, tunnelName);
}
var sr = new StreamReader(fileName, Encoding.GetEncoding("GB2312"));
string fileContent;
var wirePoints = new List <WirePoint>();
while ((fileContent = sr.ReadLine()) != null)
{
if (String.IsNullOrEmpty(fileContent))
{
continue;
}
var temp1 = fileContent.Split('|');
var pointName = temp1[0];
var pointX = temp1[1];
var pointY = temp1[2];
wirePoints.Add(new WirePoint
{
BindingId = IDGenerator.NewBindingID(),
WirePointName = pointName,
CoordinateX = Convert.ToDouble(pointX),
CoordinateY = Convert.ToDouble(pointY),
CoordinateZ = 0,
LeftDis = 2.5,
RightDis = 2.5,
TopDis = 0,
BottomDis = 0
});
}
if (wirePoints.Count < 2)
{
Alert.alert(Const_GM.WIRE_INFO_MSG_POINT_MUST_MORE_THAN_TWO);
throw new Exception();
}
var wire = Wire.FindOneByTunnelId(tunnel.TunnelId);
if (wire != null)
{
wire.WireName = tunnelName.Split('.').Length > 0
? tunnelName.Split('.')[0] + "导线点"
: tunnelName + "导线点";
wire.WirePoints = wirePoints;
}
else
{
wire = new Wire
{
Tunnel = tunnel,
CheckDate = DateTime.Now,
MeasureDate = DateTime.Now,
CountDate = DateTime.Now,
WireName =
tunnelName.Split('.').Length > 0
? tunnelName.Split('.')[0] + "导线点"
: tunnelName + "导线点",
WirePoints = wirePoints
};
}
wire.Save();
pbCount.Value++;
DrawWirePoint(wirePoints, "CHANGE");
double hdwid;
_dics = ConstructDics(tunnel, out hdwid);
UpdateHdbyPnts(tunnel.TunnelId, wirePoints, _dics, hdwid);
pbCount.Value++;
lblSuccessed.Text =
(Convert.ToInt32(lblSuccessed.Text) + 1).ToString(CultureInfo.InvariantCulture);
}
}
catch
{
pbCount.Value++;
lblError.Text =
(Convert.ToInt32(lblError.Text) + 1).ToString(CultureInfo.InvariantCulture);
_errorMsg += safeFileName + "\n";
btnDetails.Enabled = true;
}
}
UpdateWarningDataMsg msg;
if (selectTunnelUserControl1.SelectedTunnel != null)
{
msg = new UpdateWarningDataMsg(Const.INVALID_ID, selectTunnelUserControl1.SelectedTunnel.TunnelId,
Wire.TableName, OPERATION_TYPE.ADD, DateTime.Now);
}
else
{
msg = new UpdateWarningDataMsg(Const.INVALID_ID, 0,
Wire.TableName, OPERATION_TYPE.ADD, DateTime.Now);
}
SocketUtil.SendMsg2Server(msg);
Alert.alert("导入完成");
}
