private void SaveKqPosition(int?status)
{
List <Model_Service.MenJin.Kq_Position> resutls = new List <Model_Service.MenJin.Kq_Position>();
for (int i = 0; i < this.dgvUserR.Rows.Count; i++)
{
DataRowView drv = this.dgvUserR.Rows[i].DataBoundItem as DataRowView;
for (int j = 0; j < this.dgvUserR.Columns.Count; j++)
{
string strColumnName = this.dgvUserR.Columns[j].Name;
if (strcolumns.Contains(strColumnName))
{
continue;
}
if (this.dgvUserR.Rows[i].Cells[j].Selected)
{
var model = new Model_Service.MenJin.Kq_Position();
model.Id = new Model_Service.MenJin.Kq_PositionId();
var machineModel = this.machinesBLL.GetModelByName(strColumnName);
model.Id.MachineId = machineModel.Id;
model.Id.UserId = drv["UserId"].TryInt().Value;
model.status = status ?? -1;
resutls.Add(model);
}
}
}
if (resutls.Count <= 0)
{
MessageBox.Show("您尚未选择任何单元格");
return;
}
if (this.machinesBLL.SaveKq_PositionList(resutls))
{
MessageBox.Show("保存成功");
for (int i = 0; i < this.dgvUserR.Rows.Count; i++)
{
DataRow dr = (this.dgvUserR.Rows[i].DataBoundItem as DataRowView).Row;
for (int j = 0; j < this.dgvUserR.Columns.Count; j++)
{
string strColumnName = this.dgvUserR.Columns[j].Name;
if (strcolumns.Contains(strColumnName))
{
continue;
}
if (this.dgvUserR.Rows[i].Cells[j].Selected)
{
if (status == null)
{
dr[strColumnName] = DBNull.Value;
}
else
{
dr[strColumnName] = status;
}
}
}
dr.AcceptChanges();
}
}
}
private void dgvUserR_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (e.ColumnIndex < 0 || e.RowIndex < 0)
{
return;
}
string strColumnName = this.dgvUserR.Columns[e.ColumnIndex].Name;
if (strcolumns.Contains(strColumnName))
{
return;
}
DataRowView drv = this.dgvUserR.Rows[e.RowIndex].DataBoundItem as DataRowView;
int _userId = drv["UserId"].TryInt().Value;
var result = this.dgvUserR.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.TryInt();
var machineModel = this.machinesBLL.GetModelByName(strColumnName);
if (result == null)
{
var model = new Model_Service.MenJin.Kq_Position();
model.Id = new Model_Service.MenJin.Kq_PositionId();
model.Id.MachineId = machineModel.Id;
model.Id.UserId = _userId;
model.status = 0;
if (this.machinesBLL.SaveKq_Position(model))
{
this.dgvUserR.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = 0;
}
}
else
{
if (result.Value == 0)
{
var model = new Model_Service.MenJin.Kq_Position();
model.Id = new Model_Service.MenJin.Kq_PositionId();
model.Id.MachineId = machineModel.Id;
model.Id.UserId = _userId;
model.status = 0;
if (this.machinesBLL.SaveKq_Position(model))
{
this.dgvUserR.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = 1;
}
}
else
{
if (this.machinesBLL.DelKq_Position(_userId, machineModel.Id))
{
this.dgvUserR.Rows[e.RowIndex].Cells[e.ColumnIndex].Value = DBNull.Value;
}
}
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "系统错误", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Error);
}
}