private void tsb_retrive_Click(object sender, EventArgs e) { if (this.dgv_list.RowCount <= 0) { return; } int rowIndex = this.dgv_list.CurrentCell.RowIndex; if (rowIndex < 0) { return; } DataGridViewRow row = dgv_list.Rows[rowIndex]; string t_id = row.Cells["WFA_ID"].Value.ToString(); if (t_id == null) { MessageBox.Show("请选择一条记录"); return; } MYWORKRECORD mwr = new MYWORKRECORD(); mwr.WORD_ID = row.Cells["WFA_ID"].Value.ToString(); mwr.STEP_ID = row.Cells["Current_STEP_ID"].Value.ToString(); mwr.USERNAME = HYPDM.WinUI.WorkFlow.CommonFuns.NewInstance.LoginInfo.LoginID; mwr.WORK_TYPE = m_workSpace.QUERYTYPE; m_MyWorkSpaceService.DeleteRecord(mwr); init(); }
public DataTable GetListFromTableAdd(DataTable p_dt, MYWORKRECORD mwr) { string sqlText = "Select WORD_ID,STEP_ID from MYWORKRECORD WHERE USERNAME='******' AND WORK_TYPE= " + mwr.WORK_TYPE; System.Data.DataTable dtd = this.DataAccessor.QueryDataTable(sqlText); //DataTable t_dt = new DataTable() ; DataTable t_dt = p_dt.Clone(); for (int i = 0; i < p_dt.Rows.Count; i++) { for (int j = 0; j < dtd.Rows.Count; j++) { string t1 = p_dt.Rows[i][0].ToString(); string t2 = dtd.Rows[j][0].ToString(); string t11 = p_dt.Rows[i]["Current_STEP_ID"].ToString(); string t21 = dtd.Rows[j][1].ToString(); if (t1.Equals(t2) && t11.Equals(t21)) { t_dt.ImportRow(p_dt.Rows[i]); break; } } } return(t_dt); }
public void DeleteRecord(MYWORKRECORD c) { string sqlText = "DELETE MYWORKRECORD " + "WHERE WORD_ID='"+c.WORD_ID+"' " + "AND STEP_ID='"+c.STEP_ID+"' " + "AND WORK_TYPE="+c.WORK_TYPE+" " + "AND USERNAME='******' "; this.DataAccessor.QueryDataTable(sqlText); }
public void DeleteRecord(MYWORKRECORD c) { string sqlText = "DELETE MYWORKRECORD " + "WHERE WORD_ID='" + c.WORD_ID + "' " + "AND STEP_ID='" + c.STEP_ID + "' " + "AND WORK_TYPE=" + c.WORK_TYPE + " " + "AND USERNAME='******' "; this.DataAccessor.QueryDataTable(sqlText); }
public void SaveRecord(MYWORKRECORD c) { string sqlText = "INSERT MYWORKRECORD (WORD_ID,STEP_ID,WORK_TYPE,USERNAME) VALUES('" + c.WORD_ID + "','" + c.STEP_ID + "'," + c.WORK_TYPE + ",'" + c.USERNAME + "') "; this.DataAccessor.QueryDataTable(sqlText); }
private void dgv_list_init(int p_type, bool p_isDelete) { m_dt = HYPDM.WinUI.WorkFlow.FlowDetail.GetWorkDetail(HYPDM.WinUI.WorkFlow.CommonFuns.NewInstance.LoginInfo.LoginID, p_type); MYWORKRECORD mwr = new MYWORKRECORD(); mwr.USERNAME = HYPDM.WinUI.WorkFlow.CommonFuns.NewInstance.LoginInfo.LoginID; mwr.WORK_TYPE = m_workSpace.QUERYTYPE; if (p_isDelete) { m_dt = m_MyWorkSpaceService.GetListFromTableAdd(m_dt, mwr); } else { m_dt = m_MyWorkSpaceService.GetListFromTableRemove(m_dt, mwr); } this.dgv_list.DataSource = m_dt; this.ucPaging1.SourceDataGridView = this.dgv_list; //changeGridRowColor(); }
private void dgv_list_init(int p_type,bool p_isDelete) { m_dt = HYPDM.WinUI.WorkFlow.FlowDetail.GetWorkDetail(HYPDM.WinUI.WorkFlow.CommonFuns.NewInstance.LoginInfo.LoginID, p_type); MYWORKRECORD mwr=new MYWORKRECORD(); mwr.USERNAME=HYPDM.WinUI.WorkFlow.CommonFuns.NewInstance.LoginInfo.LoginID; mwr.WORK_TYPE = m_workSpace.QUERYTYPE; if (p_isDelete) { m_dt = m_MyWorkSpaceService.GetListFromTableAdd(m_dt, mwr); } else { m_dt = m_MyWorkSpaceService.GetListFromTableRemove(m_dt, mwr); } this.dgv_list.DataSource = m_dt; this.ucPaging1.SourceDataGridView = this.dgv_list; //changeGridRowColor(); }
private void tsl_delete_Click(object sender, EventArgs e) { if (this.dgv_list.RowCount <= 0) return; int rowIndex = this.dgv_list.CurrentCell.RowIndex; if (rowIndex < 0) return; DataGridViewRow row = dgv_list.Rows[rowIndex]; string t_id = row.Cells["WFA_ID"].Value.ToString(); if (t_id == null) { MessageBox.Show("请选择一条记录"); return; } MYWORKRECORD mwr = new MYWORKRECORD(); mwr.WORD_ID = row.Cells["WFA_ID"].Value.ToString(); mwr.STEP_ID = row.Cells["Current_STEP_ID"].Value.ToString(); mwr.USERNAME = HYPDM.WinUI.WorkFlow.CommonFuns.NewInstance.LoginInfo.LoginID; mwr.WORK_TYPE = m_workSpace.QUERYTYPE; m_MyWorkSpaceService.SaveRecord(mwr); init(); }
public void SaveRecord(MYWORKRECORD c) { string sqlText = "INSERT MYWORKRECORD (WORD_ID,STEP_ID,WORK_TYPE,USERNAME) VALUES('" +c.WORD_ID+"','" +c.STEP_ID+"'," +c.WORK_TYPE+",'" +c.USERNAME+"') "; this.DataAccessor.QueryDataTable(sqlText); }
public DataTable GetListFromTableRemove(DataTable p_dt,MYWORKRECORD mwr) { string sqlText = "Select WORD_ID,STEP_ID from MYWORKRECORD WHERE USERNAME='******' AND WORK_TYPE= " + mwr.WORK_TYPE; System.Data.DataTable dtd = this.DataAccessor.QueryDataTable(sqlText); //DataTable t_dt = new DataTable(); DataTable t_dt = p_dt.Clone(); for (int i = 0; i < p_dt.Rows.Count; i++) { bool flag = true; for (int j = 0; j < dtd.Rows.Count; j++) { string t1 = p_dt.Rows[i][0].ToString(); string t2 = dtd.Rows[j][0].ToString(); string t11 = p_dt.Rows[i]["Current_STEP_ID"].ToString(); string t21 = dtd.Rows[j][1].ToString(); if (t1.Equals(t2) && t11.Equals(t21)) { flag = false; break; } } if(flag){ t_dt.ImportRow(p_dt.Rows[i]); } } return t_dt; }