void exclusion_listctrl::on_add_command()
{
long new_row;
new_row = add_empty_row() ;
edit_row( new_row );
}
void exclusion_listctrl::on_edit_command()
{
long selected_row = get_selected_item_id();
if ( selected_row != -1 )
{
edit_row( selected_row );
}
}
void server_answer(http_request_t req, socket_t * clientSocket,db_t * db)
{
if(!strncmp(req.uri,"/db/editw/",10))
{
edit_row(req,clientSocket, db);
}
else
if(!strncmp(req.uri,"/db/edit/",9))
{
edit(req,clientSocket, db);
}
else
if(strpbrk(req.uri,"0123456789"))
{
if(!strcmp(req.method,"GET"))
get_row(req,clientSocket, db);
else
if(!strcmp(req.method,"DELETE"))
db_delete(req,db);
}
else
if(!strncmp(req.uri,"/db/paste/",10))
{
if(!strcmp(req.method,"GET"))
post_new_row_get(req,clientSocket);
else
if(!strcmp(req.method,"POST"))
post_new_row_post(req,clientSocket,db);
}
else
if (!strcmp(req.uri, "/db"))
{
start_page(clientSocket,db);
}
else
if(!strncmp(req.uri,"/db/",4))
{
get_bd(req,clientSocket,db);
}
}
void CAllDlg::OnBnClickedEditButton()
{
// TODO: Add your control notification handler code here
CString strArr[20];
int n_field,nCurSel;
CString q;
UpdateData(TRUE);
switch(tab_id)
{
case TAB_NHAP_ID:
ptr_cKmysql->select_table(NHAP_TABLE);
q.Empty();
q.Format(CString("DELETE FROM nhap WHERE dot_nhap='%s' AND ms_hang='%s';"),m_vDotNhap,m_vTenHangBrif);
if(!ptr_cKmysql->query(q)) goto error_del;
n_field=N_NHAP_FIELD;
strArr[0]=m_vTenHangBrif;
strArr[1]=m_vSoLuongKgN;
strArr[2]=m_vDotNhap;
strArr[3]=m_vSoLuongCayN;
strArr[4]=m_vDonGia;
strArr[5]=m_vThueNhap;
strArr[6]=m_vComment;
break;
case TAB_XUAT_ID:
ptr_cKmysql->select_table(XUAT_TABLE);
q.Empty();
q.Format(CString("DELETE FROM xuat WHERE dot_nhap='%s' AND ms_hang='%s';"),m_vDotNhap,m_vTenHangBrif);
if(!ptr_cKmysql->query(q)) goto error_del;
n_field=N_XUAT_FIELD;
strArr[0]=m_vTenHangBrif;
strArr[1]=m_vSoLuongKgX;
strArr[2]=m_vDotNhap;
strArr[3]=m_vSoLuongCayX;
strArr[4]=m_vDonGia;
strArr[5]=m_vThueNhap;
strArr[6]=m_vNgayXuat;
strArr[7]=m_vComment;
break;
case TAB_DOT_ID:
n_field=4;
ptr_cKmysql->select_table("dot");
q.Empty();
q.Format(CString("DELETE FROM dot WHERE dot_nhap='%s';"),m_vDotNhap);
if(!ptr_cKmysql->query(q)) goto error_del;
strArr[0]=m_vDotNhap;
strArr[1]=m_vChungTu;
strArr[2]=m_vNgayNhap;
strArr[3]=m_vComment;
break;
case TAB_HANG_ID:
// ptr_cKmysql->select_table("hang");
// n_field=4;
// strArr[0]=m_vDotNhap;
// strArr[1]=m_vTenHangBrif;
// strArr[2]=m_vTenHangFull;
// strArr[3]=m_vComment;
goto exit;
break;
default:
n_field=0;
goto exit;
}
if(ptr_cKmysql->insert_row(strArr,n_field))
{
AfxMessageBox(_T("đã sửa xong!"));
nCurSel = m_cAllList.GetNextItem(-1 , LVNI_FOCUSED | LVNI_SELECTED);
edit_row(nCurSel,strArr,n_field);
}
else
{
error_del:
AfxMessageBox(_T("ko sửa được!"));
}
exit:
;
}
