public List <BOM_Struct> GetAllStruct()
{
List <BOM_Struct> structList = new List <BOM_Struct>();
BOM_Struct structs = new BOM_Struct
{
Id = 1,
BOM_Id = 1,
Is_Delete = "0",
Material_Id = 1,
Parent_Id = 0,
Create_Date = DateTime.Now
};
structList.Add(structs);
structs = new BOM_Struct
{
Id = 2,
BOM_Id = 1,
Is_Delete = "0",
Material_Id = 2,
Parent_Id = 1,
Create_Date = DateTime.Now
};
structList.Add(structs);
return(structList);
}
public List <BOM_Struct> GetStructListByMaterialId(int material_id)
{
var structList = new List <BOM_Struct>();
BOM_Struct bomStruct = GetStructByMaterialId(material_id);
structList = GetAllStructByBOMId(1).FindAll(s => s.Parent_Id == bomStruct.Id);
return(structList);
}
/// <summary>
/// 添加同级或下级
/// </summary>
private void BOMStructAddByMaterial(int _parentId)
{
var materialForm = new SelectExistingFile();
materialForm.ShowDialog();
if (materialForm.DialogResult == DialogResult.OK)
{
var id = Convert.ToInt32(focus_node.GetValue("Id"));
var parts = materialForm.parts;
var m = new BOM_Struct {
Id = id + 1, Parent_Id = _parentId, Material_Id = Convert.ToInt32(parts[0])
};
structList.Add(m);
TreeDataBind(structList, treeList1);
}
}
/// <summary>
/// 粘贴同级或下级
/// </summary>
/// <param name="_parentId"></param>
private void BOMStructPasteByMaterial(int _parentId)
{
var structId = Convert.ToInt32(focus_node.GetValue("Id"));
var referStructId = Convert.ToInt32(referNode.GetValue("Id"));
var bomId = Convert.ToInt32(referNode.GetValue("BOM_Id"));
if (bmReferMaterial.Items["btnCopyMaterial"].Tag == "ReferMaterialCopy")
{
var m = new BOM_Struct {
Id = structId + 1, Parent_Id = _parentId, Material_Id = referMaterialId, BOM_Id = bom_id, Is_Refer = "1", ReferBOM_Id = 0
};
structList.Add(m);
}
else
{
var m = structList.Find(s => s.Id == structId && s.BOM_Id == bom_id);
if (m == null)
{
return;
}
var referStructList = productStructService.GetBOMStructListByParentId(referStructId, bomId);
m = new BOM_Struct {
Id = m.Id + 1, Parent_Id = _parentId, BOM_Id = bom_id, Material_Id = referStructList[0].Material_Id
};
structList.Add(m);
for (int i = 0; i < referStructList.Count; i++)
{
var _list = new List <BOM_Struct>();
productStructService.GetChildBOMStruct(referStructList[i].Id, ref _list);
var parent_id = m.Id;
for (int j = 0; j < _list.Count; j++)
{
m = new BOM_Struct {
Id = m.Id + 1, Parent_Id = parent_id, BOM_Id = bom_id, Material_Id = _list[j].Material_Id
};
structList.Add(m);
}
}
}
TreeDataBind(structList, treeList1);
}
public bool UpdateBOMStruct(BOM_Struct bomStruct)
{
var sql = "Update bom_struct set bom_id=" + bomStruct.BOM_Id + ",material_id=" + bomStruct.Material_Id + ",parent_id=" + bomStruct.Parent_Id + " where id=" + bomStruct.Id + "";
return(false);
}
/// <summary>
/// 添加BOM结构数据
/// </summary>
/// <param name="bomStruct"></param>
/// <returns></returns>
public bool AddBOMStruct(BOM_Struct bomStruct)
{
var sql = "insert into bom_struct(bom_id,material_id,parent_id) values(" + bomStruct.BOM_Id + "," + bomStruct.Material_Id + "," + bomStruct.Parent_Id + ")";
return(false);
}