public List<BOM> GetAllBOM()
{
var bomList = new List<BOM>();
var bom = new BOM
{
Id = 1,
Name = "测试数据1",
Version = "1.0",
Status = "未归档",
Is_Delete = "0",
Parent_Id = 1,
Type = "设计BOM",
Create_Date = DateTime.Now,
Create_User_Id = 1,
Description = "测试数据1"
};
var bom1 = new BOM
{
Id = 2,
Name = "测试数据2",
Version = "1.1",
Status = "已归档",
Is_Delete = "0",
Parent_Id = 2,
Type = "工装BOM",
Create_Date = DateTime.Now,
Create_User_Id = 1,
Description = "测试数据2"
};
bomList.Add(bom);
bomList.Add(bom1);
return bomList;
}
/// <summary>
/// 创建BOM
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddProjectBOM(object sender, EventArgs e)
{
if (bom != null) { }
else
{
bom = new BOM
{
Id = Convert.ToInt32(txtProductName.Text),
Name = txtProductName.Text,
Status = "0",
Is_Delete = "0",
Type = "0",
Create_Date = Convert.ToDateTime(txtCreateDate.Text)
};
}
var result = productStructService.AddORUpdateBOM(bom);
if (result)
{
this.Hide();
}
}
public bool AddORUpdateBOM(BOM bom)
{
var sql = new StringBuilder();
if (bom.Id == 0)
{
sql.Clear();
//添加
sql.AppendLine("insert into bom (name,number,parent_id,belong_task,type,status,is_delete,description,version)");
sql.AppendLine("values ('" + bom.Name + "','" + bom.Number + "','" + bom.Parent_Id + "','" + bom.Belong_Task + "',");
sql.AppendLine("'" + bom.Type + "','" + bom.Status + "','" + bom.Is_Delete + "','" + bom.Description + "','" + bom.Version + "'");
return true;
}
else
{
//修改
sql.Clear();
sql.AppendLine("update bom set name='" + bom.Name + "',number='" + bom.Number + "',parent_id=" + bom.Parent_Id + ",");
sql.AppendLine("belong_task='" + bom.Belong_Task + "',type='" + bom.Type + "',status='" + bom.Status + "',is_delete='" + bom.Is_Delete + "',");
sql.AppendLine("description='" + bom.Description + "',version='" + bom.Version + "' where id=" + bom.Id + "");
return false;
}
}