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; } }