public void exportcsv(ref DataGridViewCommon dgv, string link, string filename)
{
try
{
//StreamWriter sw = new StreamWriter(link + @"\" + filename + ".csv" ,false);
SaveFileDialog dialog = new SaveFileDialog();
dialog.Filter = "Text File|*.txt";
dialog.FileName = link + @"\" + filename + ".csv";
var result = dialog.ShowDialog();
if (result != DialogResult.OK)
{
return;
}
StringBuilder builder = new StringBuilder();
int rowcount = dgv.Rows.Count;
int columncount = dgv.Columns.Count;
for (int i = 0; i < rowcount; i++)
{
List <string> cols = new List <string>();
for (int j = 0; j < columncount - 1; j++)
{
cols.Add(dgv.Rows[i].Cells[j].Value.ToString() + @",");
}
builder.AppendLine(string.Join("\t", cols.ToArray()));
}
System.IO.File.WriteAllText(dialog.FileName, builder.ToString());
MessageBox.Show("Save ok. Filename: " + link + @"\" + filename + ".csv");
}
catch
{
MessageBox.Show("ERROR. Please create folder " + link + " to save as...");
return;
}
}
private void SelectProductTypeData()
{
//调用查询接口
radGridView1.DataSource = null;
DataSet dataSet = serviceClient.SelectProductContinairCapacity("");
DataTable dataTable = dataSet.Tables[0];
typeNoData.Clear();
if (dataTable.Rows.Count > 0)
{
//显示数据
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dr = typeNoData.NewRow();
dr[DATA_ORDER] = i + 1;
dr[DATA_TYPENO_NAME] = dataTable.Rows[i][0].ToString();
dr[DATA_CONTAINER_CAPACITY] = dataTable.Rows[i][1].ToString();
dr[DATA_USER_NAME] = dataTable.Rows[i][2].ToString();
dr[DATA_UPDATE_DATE] = dataTable.Rows[i][3].ToString();
dr[DATA_DESCRIBLE] = dataTable.Rows[i][4].ToString();
typeNoData.Rows.Add(dr);
}
radGridView1.DataSource = typeNoData;
SetGridReadOnly();
}
else
{
typeNoData.Clear();
radGridView1.DataSource = typeNoData;
}
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, true);
SetGridReadOnly();
}
public void exportcsv(ref DataGridViewCommon dgv, string link, string filename)
{
try
{
StringBuilder builder = new StringBuilder();
int rowcount = dgv.Rows.Count;
int columncount = dgv.Columns.Count;
List <string> cols = new List <string>();
for (int i = 0; i < dgv.ColumnCount; i++)
{
cols.Add(dgv.Columns[i].HeaderText + @"|");
}
builder.AppendLine(string.Join("\t", cols.ToArray()));
for (int i = 0; i < rowcount; i++)
{
cols = new List <string>();
for (int j = 0; j < columncount; j++)
{
cols.Add(dgv.Rows[i].Cells[j].Value.ToString() + @"|");
}
builder.AppendLine(string.Join("\t", cols.ToArray()));
}
System.IO.File.WriteAllText(link + @"\" + filename + ".csv", builder.ToString());
MessageBox.Show("Save ok. Filename: " + link + @"\" + filename + ".csv");
}
catch
{
MessageBox.Show("ERROR. Please create folder " + link + " to save as...");
return;
}
}
public void exportexcel(ref DataGridViewCommon dgv, string link, string filename)
{
try
{
Excel.Application excelApp = new Excel.Application();
excelApp.Workbooks.Add();
Excel.Worksheet ws = excelApp.ActiveSheet;
// column headings
for (int i = 0; i < dgv.Columns.Count; i++)
{
ws.Cells[1, (i + 1)] = dgv.Columns[i].HeaderText;
}
// rows
for (int i = 0; i < dgv.Rows.Count; i++)
{
for (int j = 0; j < dgv.Columns.Count; j++)
{
if (dgv[j, i].Value != null)
{
ws.Cells[(i + 2), (j + 1)] = dgv[j, i].Value.ToString();
}
}
}
excelApp.Visible = true;
ws.SaveAs(link + @"\" + filename + ".xlsx");
}
catch
{
MessageBox.Show("ERROR. Please create folder " + link + " to save as...");
return;
}
}
async private void InitControl()
{
//type no
cb_typeNo.Items.Clear();
cb_material_typeNo.Items.Clear();
cb_station.Items.Clear();
try
{
DataTable dt = (await serviceClient.SelectProductContinairCapacityAsync("")).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
cb_typeNo.Items.Add(dt.Rows[i][0]);
cb_material_typeNo.Items.Add(dt.Rows[i][0]);
}
cb_typeNo.Items.Add("");
//station
dt = null;//(await serviceClient.SelectStationAsync("", "")).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
cb_station.Items.Add(dt.Rows[i][1]);
}
cb_station.Items.Add("");
}
catch (Exception ex)
{
LogHelper.Log.Error(ex.Message + "\r\n" + ex.StackTrace);
}
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewMaterial, false);
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewPackage, false);
}
private void UserManager_Load(object sender, EventArgs e)
{
serviceClient = new MesService.MesServiceClient();
InitDataTable();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
this.radGridView1.ReadOnly = true;
SelectAllUser();
}
public ProductionControllerChartNCVCForm(ref DataGridViewCommon _dgv, string _model, string _line, DateTime _datefrom, DateTime _dateto, int _confirm_status) : this()
{
dgv = _dgv;
model = _model;
line = _line;
datefrom = _datefrom;
dateto = _dateto;
confirm_status = _confirm_status; //=0 la date, =1 la time
}
private void Init()
{
serviceClient = new MesService.MesServiceClient();
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewSn, false);
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewPackage, false);
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewMaterial, false);
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewCheck, false);
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewQuanlity, false);
this.radGridViewSn.ReadOnly = true;
this.radGridViewPackage.ReadOnly = true;
this.radGridViewMaterial.ReadOnly = true;
this.radGridViewCheck.ReadOnly = true;
this.radGridViewQuanlity.ReadOnly = true;
InitDataTable();
this.panel_sn.Visible = true;
this.panel_sn.Dock = DockStyle.Fill;
this.tool_sn_exportFilter.Items.Clear();
this.tool_sn_exportFilter.Items.Add(GridViewExport.ExportFormat.EXCEL);
this.tool_sn_exportFilter.Items.Add(GridViewExport.ExportFormat.HTML);
this.tool_sn_exportFilter.Items.Add(GridViewExport.ExportFormat.PDF);
this.tool_sn_exportFilter.Items.Add(GridViewExport.ExportFormat.CSV);
this.tool_sn_exportFilter.SelectedIndex = 0;
this.tool_package_exportFilter.Items.Clear();
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.EXCEL);
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.HTML);
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.PDF);
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.CSV);
this.tool_package_exportFilter.SelectedIndex = 0;
this.tool_material_exportFilter.Items.Clear();
this.tool_material_exportFilter.Items.Add(GridViewExport.ExportFormat.EXCEL);
this.tool_material_exportFilter.Items.Add(GridViewExport.ExportFormat.HTML);
this.tool_material_exportFilter.Items.Add(GridViewExport.ExportFormat.PDF);
this.tool_material_exportFilter.Items.Add(GridViewExport.ExportFormat.CSV);
this.tool_material_exportFilter.SelectedIndex = 0;
this.tool_productCheck_exportFilter.Items.Clear();
this.tool_productCheck_exportFilter.Items.Add(GridViewExport.ExportFormat.EXCEL);
this.tool_productCheck_exportFilter.Items.Add(GridViewExport.ExportFormat.HTML);
this.tool_productCheck_exportFilter.Items.Add(GridViewExport.ExportFormat.PDF);
this.tool_productCheck_exportFilter.Items.Add(GridViewExport.ExportFormat.CSV);
this.tool_productCheck_exportFilter.SelectedIndex = 0;
this.tool_quanlity_exportFilter.Items.Clear();
this.tool_quanlity_exportFilter.Items.Add(GridViewExport.ExportFormat.EXCEL);
this.tool_quanlity_exportFilter.Items.Add(GridViewExport.ExportFormat.HTML);
this.tool_quanlity_exportFilter.Items.Add(GridViewExport.ExportFormat.PDF);
this.tool_quanlity_exportFilter.Items.Add(GridViewExport.ExportFormat.CSV);
this.tool_quanlity_exportFilter.SelectedIndex = 0;
if (MESMainForm.currentUsetType != 0)
{
this.tool_materialClearDB.Enabled = false;
this.tool_packageClearDB.Enabled = false;
this.tool_productCheckClearDB.Enabled = false;
this.tool_quanlityClearDB.Enabled = false;
this.tool_SNClearDB.Enabled = false;
}
this.tool_SNClearDB.Visible = false;
this.radDock1.ActiveWindow = this.dw_snHistory;
}
async private void SelectStationList(string processName)
{
//调用查询接口
if (string.IsNullOrEmpty(processName))
{
return;
}
radGridView1.DataSource = null;
DataSet dataSet = await serviceClient.SelectStationListAsync(processName);
DataTable dataTable = dataSet.Tables[0];
stationData.Clear();
this.groupbox_graph.Controls.Clear();
if (dataTable.Rows.Count > 0)
{
this.radGridView1.BeginEdit();
//显示数据
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dr = stationData.NewRow();
var originID = dataTable.Rows[i][0].ToString();
var stationName = dataTable.Rows[i][1].ToString();
if (originID == (i + 1).ToString())
{
dr[DATA_ORDER] = originID;
}
else
{
//修改ID
var row = serviceClient.UpdateProcessOrder(processName, stationName, i + 1, MESMainForm.currentUser);
SelectStationList(processName);
return;
}
dr[DATA_STATION_NAME] = stationName;
dr[DATA_USER_NAME] = dataTable.Rows[i][2].ToString();
dr[DATA_UPDATE_DATE] = dataTable.Rows[i][3].ToString();
stationData.Rows.Add(dr);
//this.radGridView1.Rows[i].Cells[0].Value = dataTable.Rows[i][0].ToString();
}
this.radGridView1.DataSource = stationData;
this.radGridView1.EndEdit();
NetronLightGraph();
}
else
{
stationData.Clear();
radGridView1.DataSource = stationData;
this.radGridView1.Rows.AddNew();
}
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, true);
this.radGridView1.AllowRowHeaderContextMenu = false;
this.radGridView1.Columns[0].ReadOnly = true;
this.radGridView1.Columns[2].ReadOnly = true;
this.radGridView1.Columns[3].ReadOnly = true;
stationDataTemp = stationData.Copy();
}
//main
public ProductionControllerChart_CForm(string _model, string _line, string _process, ref DataGridViewCommon _dgv_C, int i, int _confirm_status_C) : this()
{
model = _model;
line = _line;
process = _process;
dgv = _dgv_C;
rowselect = i;
confirm_status_C = _confirm_status_C;
datefrom = DateTime.Parse(dgv.Rows[i].Cells["colStarday"].Value.ToString());
}
private void Init()
{
serviceClient = new MesService.MesServiceClient();
pmListTemp = new List <ProductMaterial>();
pmStockList = new List <ProductMaterial>();
this.radDock1.ActiveWindow = this.dw_materialBind;
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewBind, true);
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewStock, false);
BindingDataSource();
InitDataTable();
InitMaterialRID();
}
//detail
public ProductionControllerChart_CForm(ref DataGridViewCommon _dgv_C, string _model_C, string _line_C, string _process_C, int _confirm_status_C) : this()
{
model = _model_C;
line = _line_C;;
process = _process_C;
dgv = _dgv_C;
process_lbl.Text = _process_C;
datefrom = DateTime.Parse(dgv.Rows[dgv.RowCount - 1].Cells["colTime"].Value.ToString());
date_lbl.Text = datefrom.ToString();
process_lbl.Text = _process_C;
confirm_status_C = _confirm_status_C;
}
async private void QueryPcbaMsg()
{
LogHelper.Log.Info("start...");
if (this.tb_pcbasn.Text != "")
{
this.currentPage = 1;//根据条件查询
this.bindingNavigatorPositionItem.Text = currentPage.ToString();
}
this.radGridView1.DataSource = null;
this.radGridView1.Update();
var pcbaMesObj = (await serviceClientTest.QueryPCBAMesAsync(this.tb_pcbasn.Text, currentPage, pageSize));
if (pcbaMesObj.BindNumber % pageSize > 0)
{
pageCount = pcbaMesObj.BindNumber / pageSize + 1;
}
else
{
pageCount = pcbaMesObj.BindNumber / pageSize;
}
var dtSource = InitBindRowSource();
this.radGridView1.BeginEdit();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
this.radGridView1.MasterTemplate.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.None;
var dt = pcbaMesObj.BindHistoryData.Tables[0];
this.radGridView1.DataSource = dt;
bindingSource.DataSource = dtSource;
this.bindingNavigator.BindingSource = bindingSource;
this.radGridView1.ReadOnly = true;
foreach (var rowInfo in this.radGridView1.Rows)
{
var bindingState = rowInfo.Cells[5].Value.ToString();
var pcbaState = rowInfo.Cells[6].Value.ToString();
var outterState = rowInfo.Cells[7].Value.ToString();
if (bindingState == "已解除绑定")
{
rowInfo.Cells[5].Style.ForeColor = Color.Red;
}
if (pcbaState == "异常")
{
rowInfo.Cells[6].Style.ForeColor = Color.PaleVioletRed;
}
if (outterState == "异常")
{
rowInfo.Cells[7].Style.ForeColor = Color.PaleVioletRed;
}
}
this.radGridView1.EndEdit();
this.radGridView1.BestFitColumns();
}
private void ProductPackageDetail_Load(object sender, EventArgs e)
{
this.tool_package_exportFilter.Items.Clear();
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.EXCEL);
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.HTML);
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.PDF);
this.tool_package_exportFilter.Items.Add(GridViewExport.ExportFormat.CSV);
this.tool_package_exportFilter.SelectedIndex = 0;
serviceClient = new MesService.MesServiceClient();
DataGridViewCommon.SetRadGridViewProperty(this.radGridViewPackage, false);
this.radGridViewPackage.ReadOnly = true;
LoadDataSource(this.outCaseCode);
}
private void Init()
{
this.status_username.Text = MESMainForm.currentUser;
this.cb_curprocess.DropDownStyle = ComboBoxStyle.DropDownList;
this.cb_processItem.DropDownStyle = ComboBoxStyle.DropDownList;
serviceClient = new MesService.MesServiceClient();
serviceClientTest = new MesServiceTest.MesServiceClient();
stationListTemp = new List <string>();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, true);
this.radGridView1.AllowRowHeaderContextMenu = false;
DataSource();
RefreshCurrentProcess();
this.cb_processItem.Text = serviceClientTest.SelectCurrentTProcess();
}
private void TestLogDetail_Load(object sender, EventArgs e)
{
InitLogDataSource();
serviceClient = new MesService.MesServiceClient();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
SetGroup();
this.radGridView1.ReadOnly = true;
this.pickerStartTime.Text = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00";
this.pickerEndTime.Text = DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59";
var ds = serviceClient.SelectTestLogDataDetail(productSn, "", "");
SetConditions();
LoadDataSource(ds);
}
private void MaterialDetailMsg_Load(object sender, EventArgs e)
{
this.tool_exportFilter.Items.Clear();
this.tool_exportFilter.Items.Add(GridViewExport.ExportFormat.EXCEL);
this.tool_exportFilter.Items.Add(GridViewExport.ExportFormat.HTML);
this.tool_exportFilter.Items.Add(GridViewExport.ExportFormat.PDF);
this.tool_exportFilter.Items.Add(GridViewExport.ExportFormat.CSV);
this.tool_exportFilter.SelectedIndex = 0;
serviceClient = new MesService.MesServiceClient();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
this.radGridView1.ReadOnly = true;
InitDataTable();
SelectMaterialDetail(this.materialCode);
}
public void exportexcelGA1(ref DataGridViewCommon dgv, string link, string filename, string model, string line, string dateFrom, string dateTo)
{
try
{
Excel.Application excelApp = new Excel.Application();
excelApp.Workbooks.Add();
Excel.Worksheet ws = excelApp.ActiveSheet;
ws.Cells[1, 1] = "Model:"; ws.Cells[1, 2] = model;
ws.Cells[1, 3] = "Line:"; ws.Cells[1, 4] = line;
ws.Cells[2, 1] = "From;"; ws.Cells[2, 2] = dateFrom;
ws.Cells[2, 3] = "To:"; ws.Cells[2, 4] = dateTo;
// column headings
for (int i = 0; i < dgv.Columns.Count; i++)
{
ws.Cells[4, (i + 1)] = dgv.Columns[i].HeaderText;
}
// rows
for (int j = 0; j < dgv.Columns.Count; j++)
{
for (int i = 0; i < dgv.Rows.Count; i++)
{
ws.Cells[(i + 5), (j + 1)] = dgv[j, i].Value.ToString();
if (i < dgv.RowCount - 1)
{
if (dgv.Rows[i].Cells["process"].Value.ToString() == dgv.Rows[i + 1].Cells["process"].Value.ToString())
{
ws.Range[ws.Cells[i + 5, 1], ws.Cells[i + 6, 1]].Merge();
}
}
}
}
excelApp.Visible = true;
if (link.Length == 3)
{
ws.SaveAs(link + filename + ".xlsx");
}
else
{
ws.SaveAs(link + @"\" + filename + ".xlsx");
}
}
catch
{
MessageBox.Show("ERROR. Please create folder " + link + " to save as...");
return;
}
}
private void colorViewForFailAndBlank(ref DataGridViewCommon dgv)
{
int rowCount = dgv.BindingContext[dgv.DataSource, dgv.DataMember].Count;
for (int i = 0; i < rowCount; i++)
{
if (dgv["thurst", i].Value.ToString() == "NG" || dgv["Thurst", i].Value.ToString() == String.Empty)
{
dgv["thurst", i].Style.BackColor = Color.Red;
}
if (dgv["noise", i].Value.ToString() == "NG" || dgv["Noise", i].Value.ToString() == String.Empty)
{
dgv["noise", i].Style.BackColor = Color.Red;
}
}
}
async private void Material_Load(object sender, EventArgs e)
{
serviceClient = new MesService.MesServiceClient();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, true);
materialCodeTemp = new List <string>();
rlbx_explain.Text = "在新行添加物料名称、物料库存，右键行头可删除行数据";
//设置第一列为只读
this.radGridView1.DataSource = DataSource();
SelectMaterial();//查询数据
this.radGridView1.Columns[0].ReadOnly = true;
this.radGridView1.CellBeginEdit += RadGridView1_CellBeginEdit;
this.radGridView1.CellEndEdit += RadGridView1_CellEndEdit;
this.radGridView1.ContextMenuOpening += RadGridView1_ContextMenuOpening;
this.radGridView1.MouseDown += RadGridView1_MouseDown;
}
async private void Init()
{
serviceClient = new MesService.MesServiceClient();
//packageProduct = new MesService.PackageProduct();
InitCaseCodeList();
//获取型号
cb_typeNo.Items.Clear();
DataTable dt = null;// (await serviceClient.SelectProductTypeNoAsync("")).Tables[0];
for (int i = 0; i < dt.Rows.Count; i++)
{
cb_typeNo.Items.Add(dt.Rows[i][0].ToString());
}
cb_typeNo.Items.Add("");
DataSource();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
}
private void ProductType_Load(object sender, EventArgs e)
{
mesService = new MesService.MesServiceClient();
modifyTypeNoTemp = new List <string>();
InitDataSource();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, true);
SelectServiceData("");
btn_commit.Click += Btn_commit_Click;
btn_select.Click += Btn_select_Click;
btn_clear_server.Click += Btn_clear_server_Click;
this.radGridView1.ContextMenuOpening += RadGridView1_ContextMenuOpening;
this.radGridView1.MouseDown += RadGridView1_MouseDown;
this.radGridView1.CellBeginEdit += RadGridView1_CellBeginEdit;
this.radGridView1.CellEndEdit += RadGridView1_CellEndEdit;
}
private void Init()
{
serviceClient = new MesService.MesServiceClient();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
this.radGridView1.Columns[0].Width = 15;
var len1 = ConfigurationManager.AppSettings["snLength1"].ToString();
var len2 = ConfigurationManager.AppSettings["snLength2"].ToString();
if (!string.IsNullOrEmpty(len1) && !string.IsNullOrEmpty(len2))
{
if (!int.TryParse(len1, out snLength1) || !int.TryParse(len2, out snLength2))
{
MessageBox.Show("配置文件格式错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
async private void SelectMaterialMsg()
{
DataTable dt = (await serviceClient.SelectMaterialAsync(this.tb_inputMsg.Text, MesService.MaterialStockState.PUT_IN_STOCK_AND_STATEMENT)).Tables[0];
DataTable data = new DataTable();
data.Columns.Add("序号");
data.Columns.Add("物料编码");
data.Columns.Add("物料名称");
data.Columns.Add("库存状态");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = data.NewRow();
var materialCode = dt.Rows[i][0].ToString();
var materialPN = AnalysisMaterialCode.GetMaterialPN(materialCode);
dr["序号"] = i + 1;
dr["物料编码"] = materialCode;
dr["物料名称"] = serviceClient.SelectMaterialName(materialPN);
var stockState = dt.Rows[i][6].ToString();
if (stockState == "2")
{
stockState = "已使用完成";
}
else if (stockState == "3")
{
stockState = "已经结单";
}
else if (stockState == "1")
{
stockState = "正常使用";
}
dr["库存状态"] = stockState;
data.Rows.Add(dr);
}
}
this.radGridView1.DataSource = data;
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
this.radGridView1.ReadOnly = true;
this.radGridView1.MasterTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.None;
this.radGridView1.BestFitColumns();
}
async private void Init()
{
serviceClient = new MesService.MesServiceClient();
if (MESMainForm.currentUsetType != 0)
{
this.tool_clearDB.Enabled = false;
}
rbtn_today.Checked = true;
this.radGridView1.Dock = DockStyle.Fill;
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
DataGridViewCommon.SetRadGridViewProperty(this.gridProgrameVersion, false);
DataGridViewCommon.SetRadGridViewProperty(this.gridSpec, false);
this.radGridView1.ReadOnly = true;
this.gridSpec.ReadOnly = true;
this.gridProgrameVersion.ReadOnly = true;
var dt = (await serviceClient.SelectProductContinairCapacityAsync("")).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
this.tool_queryCondition.Items.Add(dt.Rows[i][0].ToString());
}
}
//init treeview
string path = @"D:\work\project\FigKey\RetrospectiveSystem\project\IIS";
ImageList imageList = new ImageList();
imageList.Images.Add("open", Resources.FolderList32);
//LoadTreeView.SetTreeNoByFilePath(this.treeView1,path,new ImageList());
//TreeViewData.PopulateTreeView(path, this.treeView1);
this.pickerStartTime.Text = DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00";
this.pickerEndTime.Text = DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59";
//this.tool_exportCondition.Items.Add(GridViewExport.ExportFormat.EXCEL.ToString());
//this.tool_exportCondition.Items.Add(GridViewExport.ExportFormat.HTML.ToString());
//this.tool_exportCondition.Items.Add(GridViewExport.ExportFormat.PDF.ToString());
this.tool_exportCondition.Items.Add(GridViewExport.ExportFormat.CSV.ToString());
this.tool_exportCondition.SelectedIndex = 0;
this.radDock1.ActiveWindow = this.tool_logData;
this.label_delStatus.Visible = false;
}
private void Init()
{
serviceClient = new MesService.MesServiceClient();
serviceClientTest = new MesServiceTest.MesServiceClient();
modifyTypeNoTemp = new List <string>();
modifyProductTypeNoList = new List <BasicConfig>();
materialCodeTemp = new List <BasicConfig>();
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, true);
this.radGridView1.AllowRowHeaderContextMenu = false;
var bMaterialCode = int.TryParse(ConfigurationManager.AppSettings["materialLength"].ToString(), out materialCodeLength);
int.TryParse(ConfigurationManager.AppSettings["IsAutoAdd"].ToString(), out IsAutoAdd);
this.menu_exportCondition.Items.Add(GridViewExport.ExportFormat.EXCEL.ToString());
this.menu_exportCondition.Items.Add(GridViewExport.ExportFormat.HTML.ToString());
this.menu_exportCondition.Items.Add(GridViewExport.ExportFormat.PDF.ToString());
this.menu_exportCondition.Items.Add(GridViewExport.ExportFormat.CSV.ToString());
this.menu_exportCondition.Text = GridViewExport.ExportFormat.EXCEL.ToString();
DataSource();
RefreshData();
if (!bMaterialCode)
{
MessageBox.Show("配置参数格式错误！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void SelectMaterial()
{
//调用查询接口
radGridView1.DataSource = null;
DataSet dataSet = serviceClient.SelectMaterialPN();
DataTable dataTable = dataSet.Tables[0];
materialData.Clear();
if (dataTable.Rows.Count > 0)
{
//显示数据
for (int i = 0; i < dataTable.Rows.Count; i++)
{
DataRow dr = materialData.NewRow();
dr[DATA_ORDER] = i + 1;
dr[DATA_MATERIAL_CODE] = dataTable.Rows[i][0].ToString();
dr[DATA_MATERIAL_NAME] = dataTable.Rows[i][1].ToString();
dr[DATA_USER_NAME] = dataTable.Rows[i][2].ToString();
dr[DATA_UPDATE_DATE] = dataTable.Rows[i][3].ToString();
dr[DATA_DESCRIBLE] = dataTable.Rows[i][4].ToString();
materialData.Rows.Add(dr);
}
radGridView1.DataSource = materialData;
}
else
{
materialData.Clear();
radGridView1.DataSource = materialData;
}
DataGridViewCommon.SetRadGridViewProperty(this.radGridView1, false);
this.radGridView1.Columns[0].ReadOnly = true;
this.radGridView1.Columns[1].ReadOnly = true;
materialCodeTemp.Clear();
modifyTypeNoTemp.Clear();
modifyProductTypeNoList.Clear();
}
public void exportmoving(ref DataGridViewCommon dgv, string codestatus)
{
string datetime = DateTime.Now.ToString("yyyy-MM-dd");
string partname = "";
try
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet; //sheet 2
object misValue = System.Reflection.Missing.Value;
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open(@"D:\VT CP\ExportMoving.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); //add data sheet1
#region codeName
if (codestatus == "Bàn Giao")
{
xlWorkSheet.Cells[2, 3] = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "BG/CĐ_" + UserData.GetUserData().FactoryCode;
xlWorkSheet.Cells[6, 6] = "X";
partname = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "_BG_" + UserData.GetUserData().FactoryCode + "_";
}
if (codestatus == "Mượn")
{
xlWorkSheet.Cells[2, 3] = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "M/CĐ_" + UserData.GetUserData().FactoryCode;
xlWorkSheet.Cells[6, 14] = "X";
partname = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "_M_" + UserData.GetUserData().FactoryCode + "_";
}
if (codestatus == "Trả")
{
xlWorkSheet.Cells[2, 3] = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "T/CĐ_" + UserData.GetUserData().FactoryCode;
xlWorkSheet.Cells[6, 22] = "X";
partname = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "_T_" + UserData.GetUserData().FactoryCode + "_";
}
if (codestatus == "Thuê")
{
xlWorkSheet.Cells[2, 3] = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "TH/CĐ_" + UserData.GetUserData().FactoryCode;
xlWorkSheet.Cells[6, 30] = "X";
partname = dgv.Rows[0].Cells["col_code_name"].Value.ToString() + "_TH_" + UserData.GetUserData().FactoryCode + "_";
}
#endregion
#region factory and reason
xlWorkSheet.Cells[9, 8] = dgv.Rows[0].Cells["col_reason_tranfer"].Value.ToString();
xlWorkSheet.Cells[11, 8] = dgv.Rows[0].Cells["col_factory_tranfer_cd"].Value.ToString();
xlWorkSheet.Cells[11, 26] = dgv.Rows[0].Cells["col_factory_received_cd"].Value.ToString();
#endregion
#region tableform
//số thứ tự
for (int i = 0; i < dgv.RowCount; i++)
{
xlWorkSheet.Cells[i + 15, 1] = i + 1;
xlWorkSheet.Cells[i + 15, 3] = dgv.Rows[i].Cells["col_machine_name"].Value.ToString();
xlWorkSheet.Cells[i + 15, 17] = dgv.Rows[i].Cells["col_machine_model"].Value.ToString();
xlWorkSheet.Cells[i + 15, 23] = dgv.Rows[i].Cells["col_machine_serial"].Value.ToString();
if (dgv.Rows[i].Cells["col_machine_costvalue"].Value.ToString() == "0")
{
xlWorkSheet.Cells[i + 15, 28] = "";
}
else
{
xlWorkSheet.Cells[i + 15, 28] = dgv.Rows[i].Cells["col_machine_costvalue"].Value.ToString();
}
xlWorkSheet.Cells[i + 15, 32] = dgv.Rows[i].Cells["col_comments_machine"].Value.ToString();
}
#endregion
#region confirm received and register date time format form
xlWorkSheet.Cells[44, 2] = dgv.Rows[0].Cells["col_confirm_received"].Value.ToString();
//xlWorkSheet.Cells[47, 24] = dgv.Rows[0].Cells["col_registration_date_time"].Value.ToString().Substring(8, 2); //day
//xlWorkSheet.Cells[47, 29] = dgv.Rows[0].Cells["col_registration_date_time"].Value.ToString().Substring(5, 2); //month
//xlWorkSheet.Cells[47, 33] = dgv.Rows[0].Cells["col_registration_date_time"].Value.ToString().Substring(0, 4); //year
string[] arrListStr = dgv.Rows[0].Cells["col_registration_date_time"].Value.ToString().Split('/');
xlWorkSheet.Cells[47, 24] = arrListStr[0]; //day
xlWorkSheet.Cells[47, 29] = arrListStr[1]; //month
xlWorkSheet.Cells[47, 33] = arrListStr[2].Substring(0, 4); //year
#endregion
xlWorkBook.SaveAs("D:\\VT CP\\Moving_" + codestatus + "_" + partname + datetime + ".xlsx", Excel.XlFileFormat.xlWorkbookDefault, misValue, misValue, misValue,
misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
MessageBox.Show("Excel file created, you can find in the folder D:\\VT CP", "Notice", MessageBoxButtons.OK, MessageBoxIcon.Information);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Workbooks.Open("D:\\VT CP\\Moving_" + codestatus + "_" + partname + datetime + ".xlsx");
xlApp.Visible = true;
}
catch
{
MessageBox.Show("ERROR. Please create folder file ");
return;
}
}
public AddMaintenanceMachineVTForm(ref DataGridViewCommon _dgv, string _machine_model) : this()
{
dgv = _dgv;
machine_model = _machine_model;
}
