/// <summary> /// 根据物料获取孔号iHoleIndex(0至11),若该治具不携带该物料则返回-1. /// </summary> public int this[MaterialItem materialItem] { get { return(MaterialItems?.IndexOf(materialItem) ?? -1); } }
public bool IsMaterialOK(string code, string No, out bool isDunguyenvanLieu, out List <MaterialItems> materials, out double Quantity) //code :P511 , No : 1900010 { bool _NVL = false; List <NVLTheoLSX> _listNVL = ListNVL(code, No); List <LSX_SFTTA> _listSFTTA = ListSFTTA(code, No); List <MaterialItems> ListMaterials = new List <MaterialItems>(); if (_listNVL.Count == 0) { isDunguyenvanLieu = false; materials = null; Quantity = 0; return(false); } if (_listSFTTA.Count == 1) { foreach (var item in _listNVL) { MaterialItems materialItems = new MaterialItems(); materialItems.Material = item.NVL_TB003; materialItems.PlanQty = item.NVLCan_TB004; materialItems.NeedQty = (double)((_listSFTTA[0].SLOutput_TA011 + _listSFTTA[0].SLBaoPhe_TA012) / _listSFTTA[0].SLKeHoach_TA010 * item.NVLCan_TB004); materialItems.Current = item.NVLLanh_TB005; materialItems.Percent = (item.NVLCan_TB004 != 0) ? materialItems.Current / materialItems.NeedQty : 1; if (materialItems.Percent < 1) { materialItems.Status = "NO"; } else { materialItems.Status = "YES"; } ListMaterials.Add(materialItems); } } if (ListMaterials.Select(d => d.Percent).Min() < 1) { isDunguyenvanLieu = false; } else { isDunguyenvanLieu = true; } materials = ListMaterials; Quantity = _listSFTTA[0].SLOutput_TA011 + _listSFTTA[0].SLBaoPhe_TA012; return(isDunguyenvanLieu); }
private void Btn_Save_Click(object sender, EventArgs e) { if (String.IsNullOrEmpty(Txt_MaterialName.Text)) { MessageBox.Show("请输入物品名称"); return; } else if (Com_MaterialUnit.SelectedIndex < 0) { MessageBox.Show("请选择计量单位"); return; } try { var item = new MaterialItems() { ObjectID = Txt_MaterialID.Text, MaterialName = Txt_MaterialName.Text, UnitID = Com_MaterialUnit.SelectedValue.ToString(), IsEnable = Rbtn_Yes.Checked ? "Y" : "N" }; var result = IsEdit ? new MaterialsQuery().UpdateMaterial(item) : new MaterialsQuery().InsertMaterials(item); if (result) { MessageBox.Show("保存成功"); if (IsEdit) { this.Close(); } else { var unitId = Guid.NewGuid().ToString(); while (new MaterialsQuery().GetMatrerial(unitId) != null) { unitId = Guid.NewGuid().ToString(); } Txt_MaterialID.Text = unitId; Txt_MaterialName.Text = String.Empty; } } } catch (Exception exp) { MessageBox.Show("保存失败," + exp.Message); } }
/// <summary> /// 修改物品 /// </summary> /// <param name="units"></param> /// <returns></returns> public bool UpdateMaterial(MaterialItems material) { string sql = "Update table_materials set MaterialName=@MaterialName,MaterialUnit=@MaterialUnit,IsEnable=@IsEnable where ObjectID=@ObjectID"; SQLiteParameter[] sqlparamter = new SQLiteParameter[] { new SQLiteParameter("@ObjectID", material.ObjectID), new SQLiteParameter("@MaterialName", material.MaterialName), new SQLiteParameter("@MaterialUnit", material.UnitID), new SQLiteParameter("@IsEnable", material.IsEnable), }; return(SqlHelper.ExecuteNonQuery(sql, sqlparamter) == 1); }
/// <summary> /// 新增物品 /// </summary> /// <param name="units"></param> /// <returns></returns> public bool InsertMaterials(MaterialItems material) { string sql = "INSERT into table_materials (ObjectID,MaterialName,MaterialUnit,IsEnable,IsDelete) VALUES(@ObjectID,@MaterialName,@MaterialUnit,@IsEnable,@IsDelete)"; SQLiteParameter[] sqlparamter = new SQLiteParameter[] { new SQLiteParameter("@ObjectID", material.ObjectID), new SQLiteParameter("@MaterialName", material.MaterialName), new SQLiteParameter("@MaterialUnit", material.UnitID), new SQLiteParameter("@IsEnable", material.IsEnable), new SQLiteParameter("@IsDelete", "N") }; return(SqlHelper.ExecuteNonQuery(sql, sqlparamter) == 1); }