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("未能获取到出库记录"); } }