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;
}
