private void radButton6_Click(object sender, EventArgs e)
{
try
{
//查询当前的laydown的数据
var numdata = db.DrillTools.Where(o => o.DrillId == DrillID && o.Basic == 1 && o.status == 1).ToList();
//判断是否有数据再删除
if (numdata.Count != 0)
{
//获取选中的项的group值，转化为int形的
int num = (int)Decimal.Parse(gvw_rack.Rows[gvw_rack.CurrentRow.Index].Cells[2].Value.ToString());
//linq的模糊查询，查出这三天数据，然后放到下一个gridview里面去
var datalist = db.DrillTools.Where(o => (int)o.Group == num && o.status == 1 && o.DrillId == DrillID).ToList();
DrillTools d = new DrillTools();
var data = db.DrillTools.Where(o => o.status == 0 && o.DrillId == DrillID).ToList();
for (int i = 0; i < 3; i++)
{
//获取当前的group的查询的条件
decimal number = (decimal)datalist[i].Group;
d = db.DrillTools.Where(o => o.Group == number && o.status == 1 && o.DrillId == DrillID).FirstOrDefault();
d.status = 0;
d.Group = data.Count / 3 + 1 + i % 3 * 0.1M;
//修改为当前的时间
d.Date = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.SaveChanges();
}
//刷新页面
setGridViewdata(1);
ToolManageForm_Load(sender, e);
}
}
catch { }
}
private void btn_add_Click(object sender, EventArgs e)
{
try
{
//判断txt_length里面只能输入数字
decimal a = Convert.ToDecimal(decimal.Parse(txt_length.Text));
//查询当前的status = 0 的条数，好计算group的值
var query = db.DrillTools.Where(o => o.status == 0 && o.DrillId == DrillID).ToList();
//查询当前井号下的所有数据，来操作order数据
var data = db.DrillTools.Where(o => o.DrillId == DrillID && o.Basic != 0).ToList();
//点击这个按钮之后向这个控件里添加数据
DrillTools d = new DrillTools();
for (int i = 0; i < 3; i++)
{
d.DrillId = DrillID;
d.Name = txt_well_name.Text.ToString();
d.Length = decimal.Parse(txt_length.Text);
d.Comment = txt_comment.Text;
//判断是否已经有基础数据了
//如果当前的数据大于1
int number = data.Count;
if (number > 1)
{
d.order = data[number - 1].order + i + 1;
}
else
{
d.order = data.Count + i + 1;
}
d.Date = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
d.Unit = txt_length_unit.Text;
d.Group = ((query.Count) / 3 + 1) + i % 3 * 0.1M;
d.Basic = 1;
d.status = 0;
d.dataMakeTime = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
d.dataMakePGM = "ToolManage";
d.dataMakeUser = username;
d.dataUpdTime = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
d.dataUpdPGM = "ToolManage";
d.dataUpdUser = username;
db.DrillTools.Add(d);
db.SaveChanges();
}
setGridViewdata(0);
//刷新页面
ToolManageForm_Load(sender, e);
}
catch
{
//弹出 在BHA length里面只能输入数字 的对话框
MessageBox.Show(lbl_message[0], lbl_message[1], MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
}
}
private void radButton7_Click(object sender, EventArgs e)
{
try
{
//首先判断有没有基础数据
var query = db.DrillTools.Where(o => o.Basic == 0 && o.DrillId == DrillID).ToList();
//如果没有数据，就弹出提示框：没有基础数据，请先更新基础数据！！
if (query.Count == 0)
{
MessageBox.Show(lbl_message[2], lbl_message[1], MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
}
//如果有基础数据就正常操作
else
{
//查询当前的laydown的数据
var numdata = db.DrillTools.Where(o => o.DrillId == DrillID && o.Basic == 1 && o.status == 0).ToList();
//判断是否有数据再删除
if (numdata.Count != 0)
{
//获取选中的项的group值，转化为int形的
int num = (int)Decimal.Parse(gvw_laydown.Rows[gvw_laydown.CurrentRow.Index].Cells[2].Value.ToString());
//linq的模糊查询，查出这三条数据，然后放到下一个gridview里面去
var datalist = db.DrillTools.Where(o => (int)o.Group == num && o.status == 0 && o.DrillId == DrillID).ToList();
DrillTools d = new DrillTools();
var data = db.DrillTools.Where(o => o.status == 2 && o.DrillId == DrillID).ToList();
for (int i = 0; i < 3; i++)
{
//获取当前的group的查询的条件
decimal number = (decimal)datalist[i].Group;
d = db.DrillTools.Where(o => o.Group == number && o.status == 0 && o.DrillId == DrillID).FirstOrDefault();
d.status = 2;
d.Group = data.Count / 3 + 1 + i % 3 * 0.1M;
//修改为当前的时间
d.Date = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.SaveChanges();
}
setGridViewdata(0);
ToolManageForm_Load(sender, e);
}
}
}
catch { }
}
private void radButton2_Click(object sender, EventArgs e)
{
try
{
//查询当前的laydown的数据
var numdata = db.DrillTools.Where(o => o.DrillId == DrillID && o.Basic == 1 && o.status == 2).ToList();
//判断是否有数据再删除
if (numdata.Count != 0)
{
//获取选中的项的group值，转化为int形的
int num = (int)Decimal.Parse(gvw_hole.Rows[gvw_hole.CurrentRow.Index].Cells[2].Value.ToString());
//linq的模糊查询，查出这三条数据，然后放到下一个gridview里面去
var datalist = db.DrillTools.Where(o => (int)o.Group == num && o.status == 2 && o.Basic == 1 && o.DrillId == DrillID).ToList();
//这里判断不能选择那条order=0的基础数据
if (datalist.Count >= 3)
{
DrillTools d = new DrillTools();
for (int i = 0; i < 3; i++)
{
//获取当前的group的查询的条件
decimal number = (decimal)datalist[i].Group;
d = db.DrillTools.Where(o => o.Group == number && o.status == 2 && o.DrillId == DrillID).FirstOrDefault();//.ToList().Last();
var data = db.DrillTools.Where(o => o.status == 1 && o.DrillId == DrillID).ToList();
d.status = 1;
d.Group = data.Count / 3 + 1 + i % 3 * 0.1M;
//修改为当前的时间
d.Date = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.SaveChanges();
}
}
else
{
//弹出 不能移动该条数据 的对话框
MessageBox.Show(lbl_message[3], lbl_message[1], MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
}
//刷新页面
setGridViewdata(2);
ToolManageForm_Load(sender, e);
}
}
catch { }
}
//点击这个按钮更新基础数据
private void radButton1_Click_1(object sender, EventArgs e)
{
try
{
try
{
SetValue("BHAName", txt_bha_name.Text);
AppDrill.BHAName = txt_bha_name.Text;
SetValue("BHALength", txt_bha_length.Text);
AppDrill.BHALength = txt_bha_length.Text;
SetValue("Length", txt_length.Text);
AppDrill.Length = txt_length.Text;
SetValue("Comment", txt_comment.Text);
AppDrill.Comment = txt_comment.Text;
}
catch { }
//判断输入框中输入的是设定的格式
decimal a = Convert.ToDecimal(Decimal.Parse(txt_bha_length.Text));
DrillTools data = new DrillTools();
data = db.DrillTools.Where(o => o.Basic == 0 && o.DrillId == DrillID).FirstOrDefault();
//如果查询到数据就做修改操作
if (data != null)
{
data.order = 0;
data.Name = txt_well_name.Text;
data.Length = Decimal.Parse(txt_bha_length.Text);
data.Date = DateTime.Parse(txt_date.Text);
data.Unit = txt_length_unit.Text;
db.SaveChanges();
ToolManageForm_Load(sender, e);
}
//如果没有查到数据就添加一条
else
{
DrillTools datalist = new DrillTools();
datalist.DrillId = DrillID;
datalist.Name = txt_well_name.Text.ToString();
datalist.Length = decimal.Parse(txt_bha_length.Text);
datalist.Comment = "BHA";
datalist.order = 0;
datalist.Date = DateTime.Parse(txt_date.Text);
datalist.Unit = txt_length_unit.Text;
datalist.Group = 0M;
datalist.Basic = 0;
datalist.status = 2;
datalist.dataMakeTime = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
datalist.dataMakePGM = "ToolManage";
datalist.dataMakeUser = username;
datalist.dataUpdTime = Convert.ToDateTime(System.DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
datalist.dataUpdPGM = "ToolManage";
datalist.dataUpdUser = username;
db.DrillTools.Add(datalist);
db.SaveChanges();
ToolManageForm_Load(sender, e);
}
}
catch
{
//弹出 在BHA length里面只能输入数字 的对话框
MessageBox.Show(lbl_message[0], lbl_message[1], MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
}
}
