private void InventoryEdit_Load(object sender, EventArgs e)
{
var data = new InInventoryQuery().GetInventoryData(ObjectID);
if (data != null)
{
Com_Material_Input.Items.Clear();
var items = new MaterialsQuery().GetMaterials();
var lists = items.Where(t => t.ObjectID == data.MaterialID);
Com_Material_Input.DataSource = lists.ToList();
Com_Material_Input.DisplayMember = "MaterialName";
Com_Material_Input.ValueMember = "ObjectID";
Com_Material_Input.SelectedIndexChanged += new EventHandler(Com_Material_Input_SelectedIndexChanged);
Com_Material_Input.SelectedValue = data.MaterialID;
Com_Material_Input_SelectedIndexChanged(sender, e);
Num_Number_Input.Value = (decimal)data.Number;
OldNumber = data.Number;
Num_Price_InPut.Value = (decimal)data.Price;
Time_InPutTime_Input.Value = DateTime.FromFileTimeUtc((long)data.CreatedTime);
Txt_Mark_Input.Text = data.Mark;
}
else
{
MessageBox.Show("未获取到入库记录信息");
}
}
private void Com_Material_Input_SelectedIndexChanged(object sender, EventArgs e)
{
if (Com_Material_Input.SelectedIndex == -1)
{
return;
}
var materialID = Com_Material_Input.SelectedValue.ToString();
var material = new MaterialsQuery().GetMatrerial(materialID);
Txt_Unit_Input.Text = material.UnitName;
}
private void Com_Material_Input_TextUpdate(object sender, EventArgs e)
{
var items = new MaterialsQuery().GetMaterials();
if (!String.IsNullOrEmpty(Com_Material_Input.Text))
{
var list = items.Where(t => t.MaterialName.Contains(Com_Material_Input.Text));
BingInvertory(list.ToList());
Com_Material_Input.SelectionStart = Com_Material_Input.Text.Length;
Com_Material_Input.DroppedDown = true;
Cursor = Cursors.Default;
}
else
{
BingInvertory(items);
}
}
private void Material_Load(object sender, EventArgs e)
{
Com_MaterialUnit.Items.Clear();
var unitItem = new UnitsQuery().GetUnitsList();
Com_MaterialUnit.ValueMember = "ObjectID";
Com_MaterialUnit.DisplayMember = "UnitsName";
Com_MaterialUnit.DataSource = unitItem;
if (!IsEdit)
{
var materialId = Guid.NewGuid().ToString();
while (unitItem.Any(t => materialId == t.ObjectID))
{
materialId = Guid.NewGuid().ToString();
}
Txt_MaterialID.Text = materialId;
}
else
{
MaterialItems items = new MaterialsQuery().GetMatrerial(MaterialID);
if (items != null)
{
Txt_MaterialID.Text = items.ObjectID;
Txt_MaterialName.Text = items.MaterialName;
Com_MaterialUnit.SelectedValue = items.UnitID;
if (items.IsEnable == "Y")
{
Rbtn_Yes.Checked = true;
}
else
{
Rbtn_No.Checked = true;
}
}
}
}
public async Task <QueryResult <Material> > FindAsync(MaterialsQuery materialsQuery)
{
var orderBy = String.Join(", ", materialsQuery.OrderBys.ToList());
var materials = _context.Materials.FromSqlRaw(
"EXEC dbo.FindMaterials {0}, {1}, {2}, {3}",
materialsQuery.Page,
materialsQuery.ItemsPerPage,
orderBy,
materialsQuery.Name
);
var totalCount = CallStaticFunc <int>("TotalCountFindMaterials", new List <SqlParameter>()
{
new SqlParameter("@name", materialsQuery.Name)
});
return(new QueryResult <Material>()
{
TotalItems = totalCount,
Items = materials.ToList(),
});
}
private void OutventoryEdit_Load(object sender, EventArgs e)
{
var data = new OutInventroyQuery().GetInventoryOutData(ObjectID);
if (data != null)
{
Com_Material_OutPut.Items.Clear();
var items = new MaterialsQuery().GetMaterials();
var lists = items.Where(t => t.ObjectID == data.MaterialID);
Com_Material_OutPut.DataSource = lists.ToList();
Com_Material_OutPut.DisplayMember = "MaterialName";
Com_Material_OutPut.ValueMember = "ObjectID";
Com_Material_OutPut.SelectedIndexChanged += new EventHandler(Com_Material_OutPut_SelectedIndexChanged);
Com_Material_OutPut.SelectedValue = data.MaterialID;
Com_Material_OutPut_SelectedIndexChanged(sender, e);
Num_Number_OutPut.Value = (decimal)data.Number;
OldNumber = data.Number;
Time_OutPutTime_Output.Value = DateTime.FromFileTimeUtc((long)data.CreatedTime);
Txt_Mark_OutPut.Text = data.Mark;
var users = new UserQuery().GetUsers().Where(t => t.IsEnable.Equals("可用"));
Com_UsingUser.DataSource = users.ToList();
Com_UsingUser.DisplayMember = "UserName";
Com_UsingUser.ValueMember = "ObjectID";
Com_UsingUser.SelectedValue = data.UserID;
}
else
{
MessageBox.Show("未能获取到出库记录");
}
}
public async Task <QueryResult <Material> > FindAsync(MaterialsQuery query)
{
return(await _materials.FindAsync(query));
}
