private void btn上一条记录_Click(object sender, EventArgs e) { DataTable dtOuter1; SqlDataAdapter daOuter1; BindingSource bsOuter1; SqlCommandBuilder cbOuter1; List <int> idList = new List <int>(); daOuter1 = new SqlDataAdapter("SELECT * FROM " + tablename1 + " WHERE 生产指令编号='" + __生产指令编号 + "' ORDER BY ID ASC;", conn); cbOuter1 = new SqlCommandBuilder(daOuter); dtOuter1 = new DataTable(tablename1); bsOuter1 = new BindingSource(); daOuter1.Fill(dtOuter1); for (int i = 0; i < dtOuter1.Rows.Count; i++) { idList.Add(Convert.ToInt32(dtOuter1.Rows[i]["ID"])); } int nowLocateion = idList.IndexOf(Convert.ToInt32(dtOuter.Rows[0]["ID"])); if (0 == nowLocateion) { MessageBox.Show("此消息为第一条"); return; } try { HandOver previous = new HandOver(mainform, idList[nowLocateion - 1]); previous.ShowDialog(); } catch { } }
private void Btn交接班_Click(object sender, EventArgs e) { Boolean b = checkUser(Parameter.userName, Parameter.userRole, "岗位交接班记录"); if (b) { CS.HandOver myform = new CS.HandOver(mainform); myform.ShowDialog(); } else { MessageBox.Show("您无权查看该页面!"); return; } }