private void Btn_Save_OutPut_Click(object sender, EventArgs e)
{
if (Com_Material_OutPut.SelectedIndex < 0)
{
MessageBox.Show("请选择出库物品");
return;
}
else if (Com_UsingUser.SelectedIndex < 0)
{
MessageBox.Show("请选择领用人");
return;
}
else if (Num_Number_OutPut.Value <= 0)
{
MessageBox.Show("请输入领用数量");
return;
}
try
{
var item = new InventoryItems
{
ObjectID = ObjectID,
MaterialID = Com_Material_OutPut.SelectedValue.ToString(),
UserID = Com_UsingUser.SelectedValue.ToString(),
Number = (double)Num_Number_OutPut.Value,
CreatedTime = Time_OutPutTime_Output.Value.ToFileTimeUtc(),
Mark = Txt_Mark_OutPut.Text
};
var isOSuccess = new OutInventroyQuery().DoInventoryUpdate(item);
if (isOSuccess)
{
var isCSuccess = new CurrentInventoryQuery().DoUpdateCurrentInventory(item.MaterialID, -(item.Number - OldNumber));
if (isCSuccess)
{
MessageBox.Show("修改成功");
this.Close();
}
else
{
MessageBox.Show("出库记录修改成功，但库存修改失败，请联系管理员进行库存盘点。");
}
}
else
{
MessageBox.Show("修改失败，请关闭窗口重试。");
}
}
catch (Exception exp)
{
MessageBox.Show("保存失败，" + exp.Message);
}
}
void BingOutPutQuery()
{
GridView_OutPut.AutoGenerateColumns = false;
var pMaterial = Txt_Material_OutPut.Text;
var pStartTime = Time_Start_OutPut.Value.Date.ToFileTimeUtc();
var pFinishTime = Time_Finish_OutPut.Value.AddDays(1).Date.AddMilliseconds(-1).ToFileTimeUtc();
var tableItem = new OutInventroyQuery().GetInventoryOutData(pMaterial, pStartTime, pFinishTime);
var newTable = tableItem.Clone();
newTable.Columns[10].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], dr[6], dr[7], dr[8], dr[9], DateTime.FromFileTimeUtc(long.Parse(dr["Createdtime"].ToString())).ToShortDateString(), dr[11] }, true);
}
GridView_OutPut.DataSource = newTable;
GridView_OutPut.Columns[12].Visible = false;
}
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("未能获取到出库记录");
}
}
