private void Search()
{
string strWhere = GetConduction();
dt = bProductionPlanSearch.GetProductionPlan(strWhere).Tables[0];
dt.Columns.Add("TECHNOLOGY_STATUS", Type.GetType("System.String"));
dt.Columns.Add("BTN_DOWN_LOAD", Type.GetType("System.String"));
if (dt.Rows.Count < 1)
{
txtSlipNumber.Clear();
txtSlipType.Clear();
txtSlipTypeName.Clear();
cboStatus.SelectedIndex = 0;
txtSlipDateFrom.Checked = false;
txtSlipDateTo.Checked = false;
dateTimePicker1.Checked = false;
dateTimePicker2.Checked = false;
//dgvData.DataSource = dt;
dgvData.Rows.Clear();
MessageBox.Show("查询的信息不存在!", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
Hashtable dwHt = new Hashtable();
Hashtable technologyHt = new Hashtable();
DataTable dtTechnology = bProductionPlanSearch.GetProductionTechnologyStatus(GetConductionTechnology()).Tables[0];
DataTable dtDw = bProductionPlanSearch.GetProductionDw(GetConductionDw()).Tables[0];
//技术判断是否结束
foreach (DataRow dr in dtTechnology.Rows)
{
string key = CConvert.ToString(dr["SLIP_NUMBER"]) + CConvert.ToString(dr["SCHEDULE_LINE_NUNBER"]) + CConvert.ToString(dr["LINE_NUMBER"]);
int count = CConvert.ToInt32(dr["COUNT"]);
int number = CConvert.ToInt32(dr["NUMBER"]);
if (count == number)
{
technologyHt.Add(key, "结束");
}
else if (number == 0)
{
technologyHt.Add(key, "未开始");
}
else if (count > number)
{
technologyHt.Add(key, "已开始");
}
}
//图纸判断有无
foreach (DataRow dr in dtDw.Rows)
{
string key = CConvert.ToString(dr["SLIP_NUMBER"]) + CConvert.ToString(dr["SCHEDULE_LINE_NUNBER"]) + CConvert.ToString(dr["LINE_NUMBER"]);
int count = CConvert.ToInt32(dr["COUNT"]);
int number = CConvert.ToInt32(dr["NUMBER"]);
if (count >= number && number != 0)
{
dwHt.Add(key, "有");
}
else if (number == 0)
{
dwHt.Add(key, "无");
}
}
//
foreach (DataRow dr in dt.Rows)
{
if (dr["PSPP_STATUS_FLAG"].ToString() == CConvert.ToString(CConstant.STATUS))
{
dr["PSPP_ACTUAL_START_TIME"] = DateTime.Now;
}
else if (dr["PSPP_STATUS_FLAG"].ToString() == CConvert.ToString(CConstant.STATUS_START))
{
dr["PSPP_ACTUAL_END_TIME"] = DateTime.Now;
}
if (dr["PSPP_STATUS_FLAG"].ToString() == CConvert.ToString(CConstant.STATUS_END))
{
dr["TECHNOLOGY_STATUS"] = "结束";
//dr["BTN_DOWN_LOAD"] = "结束";
}
//else
//{
//
string key = CConvert.ToString(dr["SLIP_NUMBER"]) + CConvert.ToString(dr["SCHEDULE_LINE_NUNBER"]) + CConvert.ToString(dr["PSPP_LINE_NUMBER"]);
if (technologyHt.Contains(key))
{
dr["TECHNOLOGY_STATUS"] = technologyHt[key];
}
else
{
dr["TECHNOLOGY_STATUS"] = "N/A";
}
if (dwHt.Contains(key))
{
dr["BTN_DOWN_LOAD"] = dwHt[key];
}
else
{
dr["BTN_DOWN_LOAD"] = "N/A";
}
//
//}
}
//dgvData.DataSource = dt;
try
{
if (dgvData.Rows.Count > 0)
{
dgvData.Rows.Clear();
}
foreach (DataRow dr in dt.Rows)
{
int currentRowIndex = dgvData.Rows.Add(1);
DataGridViewRow row = dgvData.Rows[currentRowIndex];
row.Cells["SLIP_NUMBER"].Value = dr["SLIP_NUMBER"];
row.Cells["TYPE_NAME"].Value = dr["SLIP_TYPE_NAME"];
row.Cells["PARTS_NAME"].Value = dr["PARTS_NAME"];
row.Cells["PRODUCTION_PROCESS_NAME"].Value = dr["PRODUCTION_PROCESS_NAME"];
row.Cells["BTN_DOWN_LOAD"].Value = dr["BTN_DOWN_LOAD"];
row.Cells["TECHNOLOGY_STATUS"].Value = dr["TECHNOLOGY_STATUS"];
row.Cells["START_PLAN_DATE"].Value = dr["PSPP_PLAN_START_DATE"];
row.Cells["END_PLAN_DATE"].Value = dr["PSPP_PLAN_END_DATE"];
row.Cells["PSPP_ACTUAL_START_TIME"].Value = dr["PSPP_ACTUAL_START_TIME"];
row.Cells["PSPP_ACTUAL_END_TIME"].Value = dr["PSPP_ACTUAL_END_TIME"];
row.Cells["WEIGHT"].Value = dr["WEIGHT"];
row.Cells["PRODUCTION_PROCESS_CODE"].Value = dr["PRODUCTION_PROCESS_CODE"];
row.Cells["SCHEDULE_LINE_NUNBER"].Value = dr["SCHEDULE_LINE_NUNBER"];
row.Cells["PSPP_LINE_NUMBER"].Value = dr["PSPP_LINE_NUMBER"];
row.Cells["PSPP_STATUS_FLAG"].Value = dr["PSPP_STATUS_FLAG"];
row.Cells["PARTS_CODE"].Value = dr["PARTS_CODE"];
row.Cells["PROCESS_STATUS"].Value = dr["PROCESS_STATUS"];
}
}
catch (Exception ex)
{ }
foreach (DataGridViewRow dgvr in dgvData.Rows)
{
if (dgvr.Cells["PROCESS_STATUS"].Value.ToString().Equals("0"))
{
dgvr.Cells["WEIGHT"].ReadOnly = true;
}
if (dgvr.Cells["PSPP_STATUS_FLAG"].Value.ToString() == CConvert.ToString(CConstant.STATUS))
{
dgvr.Cells["PSPP_ACTUAL_END_TIME"].ReadOnly = true;
}
if (dgvr.Cells["PSPP_STATUS_FLAG"].Value.ToString() == CConvert.ToString(CConstant.STATUS_START))
{
dgvr.Cells["PSPP_ACTUAL_START_TIME"].ReadOnly = true;
}
if ("2".Equals(CConvert.ToString(dgvr.Cells["PSPP_STATUS_FLAG"].Value)))
{
dgvr.Cells["CHK"].ReadOnly = true;
dgvr.Cells["PSPP_ACTUAL_START_TIME"].ReadOnly = true;
dgvr.Cells["PSPP_ACTUAL_END_TIME"].ReadOnly = true;
dgvr.Cells["WEIGHT"].ReadOnly = true;
}
#region delete
//string _oldSlipNumber = dgvData.Rows[i].Cells["SLIP_NUMBER"].Value.ToString();
//string productionProcessCode = dgvData.Rows[i].Cells["PRODUCTION_PROCESS_CODE"].Value.ToString();
//Hashtable dwHt = new Hashtable();
//DataTable productionProcessDt = bProductionProcess.GetList(" CODE = '" + productionProcessCode + "'").Tables[0];
//foreach (DataRow dr in productionProcessDt.Rows)
//{
// for (int l = 1; l <= 6; l++)
// {
// string dwCode = CConvert.ToString(dr["DRAWING_TYPE_CODE" + l]);
// if (string.IsNullOrEmpty(dwCode))
// {
// continue;
// }
// if (dwHt.ContainsKey(dwCode))
// {
// }
// else
// {
// dwHt.Add(dwCode, "");
// }
// }
//}
//foreach (DictionaryEntry de in dwHt)
//{
// DataTable drawingDt = new DataTable();
// string drawingcode = de.Key.ToString();
// drawingDt = bproductionDrawing.GetProductionDrawingUpload(" SLIP_NUMBER = '" + _oldSlipNumber + "'" + " AND DRAWING_CODE = '" + drawingcode + "'").Tables[0];
// if (drawingDt.Rows.Count > 0)
// {
// dgvData.Rows[i].Cells["BTN_DOWN_LOAD"].Value = "有";
// break;
// }
// else
// {
// dgvData.Rows[i].Cells["BTN_DOWN_LOAD"].Value = "无";
// }
//}
#endregion
}
}
}
