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 Btn_Save_Input_Click(object sender, EventArgs e)
{
if (Com_Material_Input.SelectedIndex == -1)
{
MessageBox.Show("请选择入库物品");
return;
}
else if (Num_Number_Input.Value == 0)
{
MessageBox.Show("入库数量不得为0");
return;
}
var item = new InventoryItems()
{
ObjectID = ObjectID,
MaterialID = Com_Material_Input.SelectedValue.ToString(),
Price = (double)Num_Price_InPut.Value,
Number = (double)Num_Number_Input.Value,
CreatedTime = Time_InPutTime_Input.Value.ToFileTimeUtc(),
Mark = Txt_Mark_Input.Text
};
try
{
var isISuccess = new InInventoryQuery().DoUpdateInventory(item);
if (isISuccess)
{
var IsCSuccess = new CurrentInventoryQuery().DoUpdateCurrentInventory(item.MaterialID, -(OldNumber - item.Number));
if (IsCSuccess)
{
MessageBox.Show("修改成功");
this.Close();
}
else
{
MessageBox.Show("记录修改成功，但当前库存更新失败，请联系管理员进行库存盘点。");
}
}
else
{
MessageBox.Show("记录修改失败，请关闭窗口重试。");
}
}
catch (Exception exp)
{
MessageBox.Show("保存失败，" + exp.Message);
}
}
void BingInPutQuery()
{
// GridView_InPut.AutoGenerateColumns = false;
var pMaterial = txt_InventoeyIn_MaterialName.Text;
var pStartTime = Time_Start_Input.Value.Date.ToFileTimeUtc();
var pFinishTime = Time_Finish_Input.Value.AddDays(1).Date.AddMilliseconds(-1).ToFileTimeUtc();
var tableItem = new InInventoryQuery().GetInventoryInData(pMaterial, pStartTime, pFinishTime);
var newTable = tableItem.Clone();
newTable.Columns[6].DataType = typeof(string);
foreach (DataRow dr in tableItem.Rows)
{
newTable.LoadDataRow(new object[] { dr[0], dr[1], dr[2], dr[3], dr[4], dr[5], DateTime.FromFileTimeUtc(long.Parse(dr["Createdtime"].ToString())).ToShortDateString(), dr[7] }, true);
}
GridView_InPut.DataSource = newTable;
GridView_InPut.Columns["ObjectID"].Visible = false;
GridView_InPut.Columns["MaterialID"].Visible = false;
}
