private WeightDesignData GetWeightDesignData()
{
if (dataForm == null)
{
dataForm = new WeightDataMangeForm();
}
WeightDesignData data = new WeightDesignData();
data.Id = bllWeightDesign.GetMaxId();
data.DesignData_Name = txtDesignDataName.Text;
data.DesignData_Submitter = txtDesignDataSumlieter.Text;
data.Helicopter_Name = txtHelicopterName.Text;
data.DataRemark = txtDagtaRemark.Text;
data.LastModify_Time = DateTime.Now.ToString();
data.DesignTaking_Weight = (txtDesignTakingWeight.Text == string.Empty ? 0 : Convert.ToDouble(txtDesignTakingWeight.Text));
data.MainSystem_Name = string.Empty;
if (weightArithmetic != null)
{
WeightSortData sortData = weightArithmetic.ExportDataToWeightSort();
data.MainSystem_Name = WeightDataMangeForm.GetMainSystemWeight(sortData);
}
if (adjustData != null)
{
WeightSortData sortData = adjustData.weightAdjustData;
data.MainSystem_Name = WeightDataMangeForm.GetMainSystemWeight(sortData);
}
return(data);
}
/// <summary>
/// 确定事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnConfirm_Click(object sender, EventArgs e)
{
string strErroInfo = PageVerification();
if (strErroInfo != string.Empty)
{
XLog.Write(strErroInfo);
return;
}
if (strType == "weightDesign")
{
WeightDesignData weight = GetWeightDesignData();
bool IsAdd = bllWeightDesign.Add(weight);
if (IsAdd)
{
XLog.Write("重量设计结果发布数据库成功");
}
}
if (strType == "coreEnvelopeDesign" || strType == "coreEnvelopeCut")
{
CoreEnvelopeDesign core = GetCoreEnvelopeDesignData();
bool IsAdd = bllCoreEnvelopeDesign.Add(core);
if (IsAdd)
{
if (strType == "coreEnvelopeDesign")
{
XLog.Write("重心包线设计结果发布数据库成功");
}
if (strType == "coreEnvelopeCut")
{
XLog.Write("重心包线剪裁结果发布数据库成功");
}
}
}
this.Close();
}
private WeightDesignData GetWeightDesignData()
{
if (dataForm == null)
{
dataForm = new WeightDataMangeForm();
}
WeightDesignData data = new WeightDesignData();
data.Id = bllWeightDesign.GetMaxId();
data.DesignData_Name = txtDesignDataName.Text;
data.DesignData_Submitter = txtDesignDataSumlieter.Text;
data.Helicopter_Name = txtHelicopterName.Text;
data.DataRemark = txtDagtaRemark.Text;
data.LastModify_Time = DateTime.Now.ToString();
data.DesignTaking_Weight = (txtDesignTakingWeight.Text == string.Empty ? 0 : Convert.ToDouble(txtDesignTakingWeight.Text));
data.MainSystem_Name = string.Empty;
if (weightArithmetic != null)
{
WeightSortData sortData = weightArithmetic.ExportDataToWeightSort();
data.MainSystem_Name = WeightDataMangeForm.GetMainSystemWeight(sortData);
}
if (adjustData != null)
{
WeightSortData sortData = adjustData.weightAdjustData;
data.MainSystem_Name = WeightDataMangeForm.GetMainSystemWeight(sortData);
}
return data;
}
/// <summary>
/// 新建事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnNew_Click(object sender, EventArgs e)
{
weightDesinData = new WeightDesignData();
strOperType = CommonMessage.operNew;
SetPageButton();
IntiControl();
SetOperTitle(strOperType);
}
/// <summary>
/// 确认修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnConfirmModify_Click(object sender, EventArgs e)
{
//页面验证信息
string strErroInfo = PageVerificationInfo();
if (strErroInfo != string.Empty)
{
XLog.Write(strErroInfo);
return;
}
GetPageWeightDeisignData();
if (strOperType == CommonMessage.operNew || strOperType == CommonMessage.operJYNew)
{
bool IsAdd = bllDesignData.Add(weightDesinData);
if (IsAdd)
{
if (strOperType == CommonMessage.operJYNew)
{
XLog.Write("基于新建成功");
}
else
{
XLog.Write("新建成功");
}
}
}
if (strOperType == CommonMessage.operEdit)
{
bool IsEdit = bllDesignData.Update(weightDesinData);
if (IsEdit)
{
XLog.Write("修改成功");
}
}
strOperType = CommonMessage.operConfirm;
SetPageButton();
BindWeightData();
SetOperTitle(string.Empty);
foreach (TreeNode node in treeViewList.Nodes[0].Nodes)
{
if (node.Name == weightDesinData.Id.ToString())
{
treeViewList.SelectedNode = node;
selNode = node;
}
}
weightDesinData = null;
}
/// <summary>
/// 基于新建
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnJYNew_Click(object sender, EventArgs e)
{
if (selNode == null || selNode.Level == 0)
{
XLog.Write("请选择重量设计数据");
return;
}
strOperType = CommonMessage.operJYNew;
SetPageButton();
SetOperTitle(strOperType);
weightDesinData = GetWeightDesignData(Convert.ToInt32(selNode.Name));
}
private void btnConfirmCancle_Click(object sender, EventArgs e)
{
strOperType = CommonMessage.operCancle;
SetPageButton();
SetOperTitle(string.Empty);
SettingPageData();
weightDesinData = null;
}
private void treeViewList_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
selNode = e.Node;
treeViewList.SelectedNode = e.Node;
weightDesinData = new WeightDesignData();
//SettingPageData();
}
/// <summary>
/// 获取重量设计数据
/// </summary>
/// <param name="strPath"></param>
/// <returns></returns>
private WeightDesignData GetXmlWeightDesignData(string strPath)
{
WeightDesignData weightData = null;
try
{
if (!File.Exists(strPath))
{
return weightData;
}
weightData = new WeightDesignData();
weightData.Id = bllDesignData.GetMaxId();
string path = string.Empty;
XmlNode node = null;
XmlDocument doc = new XmlDocument();
doc.Load(strPath);
//设计数据名称
path = "重量设计数据/设计数据名称";
node = doc.SelectSingleNode(path);
weightData.DesignData_Name = node.InnerText;
//设计数据提交者
path = "重量设计数据/设计数据提交者";
node = doc.SelectSingleNode(path);
weightData.DesignData_Submitter = node.InnerText;
//直升机名称
path = "重量设计数据/直升机名称";
node = doc.SelectSingleNode(path);
weightData.Helicopter_Name = node.InnerText;
//数据备注
path = "重量设计数据/数据备注";
node = doc.SelectSingleNode(path);
weightData.DataRemark = node.InnerText;
//最后修改日期
path = "重量设计数据/最后修改日期";
node = doc.SelectSingleNode(path);
weightData.LastModify_Time = node.InnerText;
//设计起飞重量
path = "重量设计数据/设计起飞重量";
node = doc.SelectSingleNode(path);
weightData.DesignTaking_Weight = Convert.ToDouble(node.InnerText);
//重量分类名称
path = "重量设计数据/重量分类名称";
string strSortName = doc.SelectSingleNode(path).InnerText;
//重量列表
path = "重量设计数据/重量列表";
node = doc.SelectSingleNode(path);
string strMainSystemWeight = string.Empty;
string strFH = "、";
XmlNodeList nodelist = node.ChildNodes;
if (nodelist.Count > 0)
{
strMainSystemWeight = strSortName + "|";
foreach (XmlNode childNode in node.ChildNodes)
{
strMainSystemWeight += childNode.ChildNodes[1].InnerText + strFH
+ childNode.ChildNodes[0].InnerText + strFH + childNode.ChildNodes[2].InnerText + strFH
+ childNode.ChildNodes[3].InnerText + strFH + childNode.ChildNodes[5].InnerText + strFH + "|";
}
}
weightData.MainSystem_Name = strMainSystemWeight;
}
catch
{
XLog.Write("导入文件\"" + strPath + "\"格式错误");
MessageBox.Show("导入文件\"" + strPath + "\"格式错误");
}
return weightData;
}
/// <summary>
/// 获取tables数据
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
private DataTable GetTableExcleData(WeightDesignData designData, WeightSortData sortData)
{
DataTable table = GetTableExcleStruct();
DataRow drFirst = table.NewRow();
drFirst["DesignData_Name"] = designData.DesignData_Name;
drFirst["DesignData_Submitter"] = designData.DesignData_Submitter;
drFirst["Helicopter_Name"] = designData.Helicopter_Name;
drFirst["DataRemark"] = designData.DataRemark;
drFirst["LastModify_Time"] = designData.LastModify_Time;
drFirst["DesignTaking_Weight"] = designData.DesignTaking_Weight;
table.Rows.Add(drFirst);
DataRow dr = null;
if (sortData != null && sortData.lstWeightData.Count > 0)
{
foreach (WeightData data in sortData.lstWeightData)
{
if (data == sortData.lstWeightData.First())
{
if (table.Rows.Count > 0)
{
table.Rows[0]["Sort_Name"] = sortData.sortName;
table.Rows[0]["ID"] = data.nID;
table.Rows[0]["Weight_Name"] = data.weightName;
table.Rows[0]["Weight_Unit"] = "千克";
table.Rows[0]["Weight_Remark"] = data.strRemark;
table.Rows[0]["Prarent_ID"] = data.nParentID;
table.Rows[0]["Weight_Value"] = data.weightValue;
}
}
else
{
dr = table.NewRow();
dr["DesignData_Name"] = string.Empty;
dr["DesignData_Submitter"] = string.Empty;
dr["Helicopter_Name"] = string.Empty;
dr["DataRemark"] = string.Empty;
dr["LastModify_Time"] = string.Empty;
dr["DesignTaking_Weight"] = string.Empty;
dr["Sort_Name"] = string.Empty;
dr["ID"] = data.nID;
dr["Weight_Name"] = data.weightName;
dr["Weight_Unit"] = "千克";
dr["Weight_Remark"] = data.strRemark;
dr["Prarent_ID"] = data.nParentID;
dr["Weight_Value"] = data.weightValue;
table.Rows.Add(dr);
}
}
}
return table;
}
/// <summary>
/// 获取Excel文件的重量设计对象
/// </summary>
/// <param name="strFilePath"></param>
/// <returns></returns>
private WeightDesignData GetExcelWeightDesignData(string strFilePath)
{
WeightDesignData weightData = null;
try
{
if (File.Exists(strFilePath))
{
ExcelLib OpExcel = new ExcelLib();
//指定操作的文件
OpExcel.OpenFileName = strFilePath;
//打开文件
if (OpExcel.OpenExcelFile() == false)
{
return weightData;
}
//取得所有的工作表名称
string[] strSheetsName = OpExcel.getWorkSheetsName();
//默认操作第一张表
OpExcel.SetActiveWorkSheet(1);
System.Data.DataTable table;
table = OpExcel.getAllCellsValue();
OpExcel.CloseExcelApplication();
int count = table.Rows.Count;
if (count > 0)
{
string strSortName = string.Empty;
weightData = new WeightDesignData();
weightData.Id = bllDesignData.GetMaxId() + 1;
weightData.DesignData_Name = table.Rows[0][0].ToString();
weightData.DesignData_Submitter = table.Rows[0][1].ToString();
weightData.Helicopter_Name = table.Rows[0][2].ToString();
weightData.DataRemark = table.Rows[0][3].ToString();
weightData.LastModify_Time = table.Rows[0][4].ToString();
weightData.DesignTaking_Weight = Convert.ToDouble(table.Rows[0][5]);
if (table.Rows[0][6] is DBNull || table.Rows[0][6].ToString() == string.Empty)
{
weightData.MainSystem_Name = string.Empty;
}
else
{
strSortName = table.Rows[0][6].ToString();
string strMainSystemWeight = strSortName + "|";
string strFH = "、";
for (int i = 0; i < count; i++)
{
strMainSystemWeight += table.Rows[i][8].ToString() + strFH
+ table.Rows[i][7].ToString() + strFH + table.Rows[i][9].ToString() + strFH
+ table.Rows[i][10].ToString() + strFH + table.Rows[i][12].ToString() + "|";
}
weightData.MainSystem_Name = strMainSystemWeight;
}
}
}
}
catch
{
XLog.Write("导入文件\"" + strFilePath + "\"格式错误");
MessageBox.Show("导入文件\"" + strFilePath + "\"格式错误");
return null;
}
return weightData;
}
