void reloadModelName()
{
List <string> data = BomModelModelDAO.getInstance().getListModelName();
txtModel.DataSource = data;
//txtModel.Text = "";
}
public void addNewPlan(PlanModel plan)
{
if (plan.component_id < 1)
{
throw new Exception("Please select component");
}
if (String.IsNullOrEmpty(plan.model_name) || String.IsNullOrWhiteSpace(plan.model_name))
{
throw new Exception("Plan model cannot leave empty");
}
if (plan.plan_data < 0)
{
throw new Exception("Plan data must greater than 0");
}
if (plan.plan_line < 0)
{
throw new Exception("Plan line must greater than 0");
}
decimal model_id = BomModelModelDAO.getInstance().getIdByName(plan.model_name);
plan.model_id = model_id;
if (PlanDao.getInstance().isExist(plan))
{
throw new Exception("Plan existed");
}
PlanDao.getInstance().add(plan);
}
void reloadModelName(decimal component_id)
{
List <string> data = BomModelModelDAO.getInstance().getListModelName(component_id);
txtModel.DataSource = data;
//txtModel.Text = "";
}
public void saveBomModel(BOM_Model_Model model)
{
if (model.component_id < 1)
{
throw new Exception("Please select component first");
}
BomModelModelDAO.getInstance().add(model);
}
public void delete(BOM_Model_Model model)
{
if (model.component_id < 1)
{
throw new Exception("Please select component first");
}
if (String.IsNullOrEmpty(model.model_name) || String.IsNullOrWhiteSpace(model.model_name))
{
throw new Exception("No model was delete");
}
if (!BomModelModelDAO.getInstance().delete(model))
{
throw new Exception("Cannot delete model");
}
}
public void updateBomModel(BOM_Model_Model model)
{
if (model.component_id < 1)
{
throw new Exception("Invalid component");
}
if (String.IsNullOrEmpty(model.model_name) || String.IsNullOrWhiteSpace(model.model_name))
{
throw new Exception("Invalid model name");
}
if (model.model_value < 0)
{
throw new Exception("Model value must greater than 0");
}
BomModelModelDAO.getInstance().update(model);
}
private async Task process()
{
BomModelModelDAO.getInstance().clearData();
BOMDao.getInstance().clearData();
string filePath = txtPath.Text;
XSSFWorkbook workbook;
using (FileStream file = new FileStream(filePath, FileMode.Open, FileAccess.Read))
{
workbook = new XSSFWorkbook(file);
}
int errCount = 0;
var sheet = workbook.GetSheet("BOM");
var mainRow = sheet.GetRow(1);
int rowCount = 0;
for (int row = 2; row <= sheet.LastRowNum; row++)
{
if (sheet.GetRow(row) != null) //null is when the row only contains empty cells
{
rowCount += 1;
var curRow = sheet.GetRow(row);
string componentName = curRow.GetCell(2).StringCellValue;
string componentDescription = curRow.GetCell(3).StringCellValue;
decimal id = -1;
if (!BOMDao.getInstance().isExist(componentName))
{
BOMDao.getInstance().add(new BOM_Model {
component_name = componentName, object_description = componentDescription
});
}
id = BOMDao.getInstance().getComponentIdByName(componentName);
for (int i = 4; i <= curRow.LastCellNum; i++)
{
try
{
var x = curRow.GetCell(i).NumericCellValue;
string model = mainRow.GetCell(i).StringCellValue;
decimal num = Convert.ToDecimal(x);
if (num < 1)
{
continue;
}
BomModelModelDAO.getInstance().add(new BOM_Model_Model {
component_id = id, model_name = model, model_value = num
});
Console.WriteLine(String.Format("{0} || {1}", x, model));
}
catch (Exception ex)
{
errCount += 1;
Console.WriteLine(String.Format("loi tai row {0} col {1}", row, i));
Console.WriteLine(ex.Message);
}
}
Console.WriteLine(string.Format("Row {0} = {1} : {2}", row, sheet.GetRow(row).GetCell(2).StringCellValue, sheet.GetRow(row).GetCell(3).StringCellValue));
}
}
MessageBox.Show($"Done {rowCount} row");
btnProcess.Enabled = true;
}