sql_xiugai.c~

教学资源管理系统教室分配子系统,也是一个毕业设计.minigui下的!

#include <stdio.h>

#include <minigui/common.h>
#include <minigui/minigui.h>
#include <minigui/gdi.h>
#include <minigui/window.h>
#include <minigui/control.h>

#define IDC_HOUR   100
#define IDC_MINUTE 110
#define IDC_SECOND 120
#define IDL_DAXIA  200
#define IDL_ZIXI   610
#define IDL_JIAOSHI 420
#define IDL_RIQI    530
#define IDL_JILU    630

#define IDC_PROMPT 300
#define _LANG_ZHCN 1

static CTRLDATA CtrlMyDate[] =
{ 
/*********************************/
    {
        CTRL_COMBOBOX,
        WS_VISIBLE | CBS_DROPDOWNLIST | CBS_NOTIFY,
        10, 15, 50, 25,
        IDL_JILU,
        "1",
        80
    },
/***********************/


    {
        CTRL_COMBOBOX,
        WS_VISIBLE | CBS_DROPDOWNLIST | CBS_NOTIFY,
        60, 15, 100, 25,
        IDL_DAXIA,
        "",
        80
    },

    {
        CTRL_COMBOBOX,
        WS_VISIBLE | CBS_DROPDOWNLIST | CBS_NOTIFY,
        160, 15, 100, 25,
        IDL_ZIXI,
        "1,2节",
        80
    },
    {
        CTRL_COMBOBOX,
        WS_VISIBLE | CBS_DROPDOWNLIST | CBS_NOTIFY,
        260, 15, 100, 25,
        IDL_JIAOSHI,
        "202",
        80
    },
    {
        CTRL_COMBOBOX,
        WS_VISIBLE | CBS_DROPDOWNLIST | CBS_NOTIFY,
        360, 15, 100, 25,
        IDL_RIQI,
        "2008/04/1",
        80
    },


    {
        CTRL_BUTTON,
        WS_VISIBLE | BS_DEFPUSHBUTTON | WS_TABSTOP | WS_GROUP,
        10, 90, 130, 25,
        IDOK, 
#ifdef _LANG_ZHCN
        "确定",
#else
        "OK",
#endif
        0
    },
    {
        "button",
        WS_VISIBLE | BS_PUSHBUTTON | WS_TABSTOP,
        210, 90, 130, 25,
        IDCANCEL,
#ifdef _LANG_ZHCN
        "取消",
#else
        "Cancel",
#endif
        0
    },
};

static DLGTEMPLATE DlgMyDate =
{
    WS_BORDER | WS_CAPTION,
    WS_EX_NONE,
    300, 300, 500, 150,

    "修改记录",

    

    0, 0,
    TABLESIZE(CtrlMyDate),
	NULL,
    0
};

/*********************/
static const char* jilu [] =
{
	"1",
	"2",
	"3",
	"4",
	"5",
	"6",
	"7",
	"8",
	"9",
	"10",

};
/*********************/
static const char* daxia [] =
{
    "星期一",
    "星期二",
    "星期三",
    "星期四",
    "星期五",
    "星期六",
    "星期日",
};

/*********************************************/
static const char* jiaoshi [] =
{
    "202",
    "203",
    "204",
    "205",
    "206",
    "207",
    "208",
};
static const char* ke [] =
{
    "1,2节",
    "3,4节",
    "5,6节",
    "7,8节",
    "晚自习",
};
static const char* riqi [] =
{
    "2008/04/1",
    "2008/04/2",
    "2008/04/3",
    "2008/04/4",
    "2008/04/5",
};

static void prompt (HWND hDlg)
{

    char date [1024] = "你修改的内容：\n";

    int hour = SendDlgItemMessage(hDlg, IDC_HOUR, CB_GETSPINVALUE, 0, 0);
    int min = SendDlgItemMessage(hDlg, IDC_MINUTE, CB_GETSPINVALUE, 0, 0);
    int sel = SendDlgItemMessage(hDlg, IDL_DAXIA, CB_GETCURSEL, 0, 0);
    int sel2 = SendDlgItemMessage(hDlg, IDL_ZIXI, CB_GETCURSEL, 0, 0);
    int sel3 = SendDlgItemMessage(hDlg, IDL_JIAOSHI, CB_GETCURSEL, 0, 0);
    int sel4 = SendDlgItemMessage(hDlg, IDL_RIQI, CB_GETCURSEL, 0, 0);
    int sel5 = SendDlgItemMessage(hDlg, IDL_JILU, CB_GETCURSEL, 0, 0);

    sprintf (date, "修改记录%s %s 第 %s 教室:%s",jilu[sel5], daxia [sel],ke[sel2], jiaoshi[sel3]);
    ////////*申请的记录插入到数据库中*/////////
    sql_db_update(daxia [sel],ke[sel2], jiaoshi[sel3] ,riqi[sel4],jilu[sel5] );
//    printf("%d %d %d %d\n",sel,sel2,sel3,sel4);
    /////////////////
    MessageBox (hDlg, date, "申请内容", MB_OK | MB_ICONINFORMATION);

}

static int MyDateBoxProc (HWND hDlg, int message, WPARAM wParam, LPARAM lParam)
{
    int i;
    switch (message) {
    case MSG_INITDIALOG:
        SendDlgItemMessage(hDlg, IDC_HOUR, CB_SETSPINFORMAT, 0, (LPARAM)"%02d");
        SendDlgItemMessage(hDlg, IDC_HOUR, CB_SETSPINRANGE, 0, 23);
        SendDlgItemMessage(hDlg, IDC_HOUR, CB_SETSPINVALUE, 20, 0);
        SendDlgItemMessage(hDlg, IDC_HOUR, CB_SETSPINPACE, 1, 1);

        SendDlgItemMessage(hDlg, IDC_MINUTE, CB_SETSPINFORMAT, 0, (LPARAM)"%02d");
        SendDlgItemMessage(hDlg, IDC_MINUTE, CB_SETSPINRANGE, 0, 59);
        SendDlgItemMessage(hDlg, IDC_MINUTE, CB_SETSPINVALUE, 0, 0);
        SendDlgItemMessage(hDlg, IDC_MINUTE, CB_SETSPINPACE, 1, 2);

        for (i = 0; i < 7; i++) {
            SendDlgItemMessage(hDlg, IDL_DAXIA, CB_ADDSTRING, 0, (LPARAM)daxia [i]);
        }
/***********************************************************************/
        for (i = 0; i < 5; i++) {
            SendDlgItemMessage(hDlg, IDL_ZIXI, CB_ADDSTRING, 0, (LPARAM)ke [i]);
        }
        for (i = 0; i < 7; i++) {
            SendDlgItemMessage(hDlg, IDL_JIAOSHI, CB_ADDSTRING, 0, (LPARAM)jiaoshi [i]);
        }

        for (i = 0; i < 5; i++) {
            SendDlgItemMessage(hDlg, IDL_RIQI, CB_ADDSTRING, 0, (LPARAM)riqi [i]);
        }

        for (i = 0; i < 10; i++) {
            SendDlgItemMessage(hDlg, IDL_JILU, CB_ADDSTRING, 0, (LPARAM)jilu [i]);
        }
/**********************************************************************/

//向窗口发送消息
        SendDlgItemMessage(hDlg, IDL_DAXIA, CB_SETCURSEL, 0, 0);
	SendDlgItemMessage(hDlg, IDL_ZIXI, CB_SETCURSEL, 0, 0);
	SendDlgItemMessage(hDlg, IDL_JIAOSHI, CB_SETCURSEL, 0, 0);
	SendDlgItemMessage(hDlg, IDL_RIQI, CB_SETCURSEL, 0, 0);
	SendDlgItemMessage(hDlg, IDL_JILU, CB_SETCURSEL, 0, 0);

        return 1;
        
    case MSG_COMMAND:
        switch (wParam) {
        case IDOK:
            prompt (hDlg);
        case IDCANCEL:
            EndDialog (hDlg, wParam);
            break;
        }
        break;
        
    }
    
    return DefaultDialogProc (hDlg, message, wParam, lParam);
}

int xiugai (hwnd)
{

    
    DlgMyDate.controls = CtrlMyDate;
    
    DialogBoxIndirectParam (&DlgMyDate, hwnd, MyDateBoxProc, 0L);

    return 0;
}

#ifndef _LITE_VERSION
#include <minigui/dti.c>
#endif