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