//审批表插入一条数据 public void submission() { String software_name = cb_software.GetItemText(cb_software.Items[cb_software.SelectedIndex]); String model_name = tbd_model.Text; if ((rb_beta.Checked || rb_official.Checked) && software_name != null && model_name != null) { shenpi _shenpi = new shenpi(); _shenpi.username = username; _shenpi.software = software_name; _shenpi.model = model_name; _shenpi.version = cb_version.Text; _shenpi.model_tips = "未填写"; if (rb_beta.Checked) { _shenpi.use_time = dateTimePicker.Value; } _shenpi.is_read = 0; _shenpi.is_through = 0; _shenpi.send_time = DateTime.Now; db.shenpi.Add(_shenpi); db.SaveChanges(); MessageBox.Show("已提交申请"); } else { MessageBox.Show("请完善申请信息!"); } }
void DataGridViewX_SendList_CellContentClick(object sender, DataGridViewCellEventArgs e) //申请列表 点击事件 { int column = dgv_send_list.CurrentCell.ColumnIndex; int row = dgv_send_list.CurrentCell.RowIndex; shenpi _shenpi = new shenpi(); _shenpi = (shenpi)shenpi_read_list[row]; //通过 if (column == 7) { //修改 审批表(审批状态)、软件权限表(用户拥有软件权限) //修改审批表 var shenpiList = from u in db.shenpi where u.Id == _shenpi.Id select u; var shenpiListObject = shenpiList.FirstOrDefault(); shenpiListObject.is_read = 1; shenpiListObject.is_through = 1; shenpiListObject.read_time = DateTime.Now; //软件权限表添加一条记录 permission _permission = new permission(); _permission.username = _shenpi.username; _permission.software = _shenpi.software; _permission.model = _shenpi.model; _permission.version = _shenpi.version; db.permission.Add(_permission); //指定状态。 db.Entry <shenpi>(shenpiListObject).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //更新 前端显示 -> 申请列表 和 授权记录; //清空前端数据 dgv_send_list.Rows.Clear(); shenpi_read_list.Clear(); dgv_read_list.Rows.Clear(); //同时更新 用户管理页面 -> 用户列表数据 dgv_user_control.Rows.Clear(); list_user_control.Clear(); //重新载入 权限审批页面 -> 申请列表 initSendListData(); initReadListData(); //刷新 用户管理页面 data_user_initialize(); } //拒绝 if (column == 8) { //修改 审批表(审批状态) var shenpiList = from u in db.shenpi where u.Id == _shenpi.Id select u; var shenpiListObject = shenpiList.FirstOrDefault(); shenpiListObject.is_read = 1; shenpiListObject.is_through = 0; shenpiListObject.read_time = DateTime.Now; db.Entry <shenpi>(shenpiListObject).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); //更新 前端显示 -> 申请列表 和 授权记录 //清空前端数据 dgv_send_list.Rows.Clear(); shenpi_read_list.Clear(); dgv_read_list.Rows.Clear(); //重新载入 权限审批页面 -> 申请列表 initSendListData(); initReadListData(); } }