二次开发：数据库连接

maomao891205 · 发表于 2013-5-12 16:52

小弟在做毕业设计，是基于ug的典型工艺库的信息管理系统开发。用visual c++6.0编程，其他部分应该没太大问题，但是数据库死活连不上啊！！急死了，马上就要交了。。。麻烦大家帮帮忙吧。。。跪求。。。我把我的程序贴上来：
首先是。h文件的代码：
// MaterialInfo.h : main header file for the MATERIALINFO DLL
//

#if !defined(AFX_MATERIALINFO_H__72DE1E8C_6732_4AF8_9DBB_582D57FEAF73__INCLUDED_)
#define AFX_MATERIALINFO_H__72DE1E8C_6732_4AF8_9DBB_582D57FEAF73__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000

#ifndef __AFXWIN_H__
#error include 'stdafx.h' before including this file for PCH
#endif

#include "resource.h" // main symbols

/*===========================================*/
#ifndef MATERIALINFO_H_INCLUDED
#define MATERIALINFO_H_INCLUDED

#include <windows.h>
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <conio.h>
#include <process.h>
#include <uf.h>
#include <uf_defs.h>
#include <uf_exit.h>
#include <uf_ui.h>
#include <uf_styler.h>
#include <uf_mb.h>
#include <uf_part.h>
#include <uf_cfi.h>
#include <uf_assem.h>
#include <uf_layout.h>
#include <uf_curve.h>
#include <uf_defs.h>
#include <uf_modl.h>
#include <uf_drf.h>
#include <uf_drf_types.h>
#include <uf_obj.h>

#ifdef __cplusplus
extern "C" {
#endif

/*------------------ UIStyler Dialog Definitions  ------------------- */
/* The following values are definitions into your UIStyler dialog. */
/* These values will allow you to modify existing objects within your */
/* dialog. They work directly with the NX Open API,                */
/* UF_STYLER_ask_value, UF_STYLER_ask_values, and UF_STYLER_set_value.*/
/*------------------------------------------------------------------- */

#define MAT_LABEL_0                   ("LABEL_0")
#define MAO_MATERIALINFO             ("MATERIALINFO")
#define MAO_MATERIAL                ("MATERIAL")
#define MAO_PARTINFO                ("PARTINFO")
#define MAO_PART                      ("PART")
#define MAO_NAME                      ("NAME")
#define MAO_PARTNAME                ("PARTNAME")
#define MAO_STD_NO1                   ("STD_NO1")
#define MAO_NO                      ("NO")
#define MAO_NOTE                      ("NOTE")
#define MAO_BTN                      ("BTN")
#define MAO_DIALOG_OBJECT_COUNT       ( 10 )

/*---------------- UIStyler Callback Prototypes --------------- */
/* The following function prototypes define the callbacks    */
/* specified in your UIStyler built dialog.  You are REQUIRED to*/
/* create the associated function for each prototype.  You must */
/* use the same function name and parameter list when creating  */
/* your callback function.                                     */
/*------------------------------------------------------------- */

int MAO_constructor_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

int MAO_destructor_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

int MAO_ok_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

int MAO_apply_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

int MAO_cancel_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

int MAO_mao_type_sel ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

int MAO_partname_type_sel ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

int MAO_btn_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data);

#ifdef __cplusplus
}
#endif

#endif /* MATERIALINFO_H_INCLUDED */

////////////////////////////////////////////////////////////////////////////

//{{AFX_INSERT_LOCATION}}
// Microsoft Visual C++ will insert additional declarations immediately before the previous line.

#endif // !defined(AFX_MATERIALINFO_H__72DE1E8C_6732_4AF8_9DBB_582D57FEAF73__INCLUDED_)

然后。cpp：高亮部分是我的连接代码
// MaterialInfo.cpp : Defines the initialization routines for the DLL.
//

#include "stdafx.h"
#include "MaterialInfo.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/* The following definition defines the number of callback entries */
/* in the callback structure:                                     */
/* UF_STYLER_callback_info_t MAT_cbs */
#define MAO_CB_COUNT ( 6 + 1 ) /* Add 1 for the terminator */

CString strtemp;
CString str_tmp1,str_tmp2,str_tmp3,str_tmp4,str_tmp5,str_tmp6;

//add_mark：添加标志；
int add_mark=0;
char DbType;

//定义数据库指针
CDatabase *m_pdatabase;
CRecordset *m_pset;
_ConnectionPtr m_DBCnt;
_RecordsetPtr  m_pRecordset;

/*--------------------------------------------------------------------------*/
static UF_STYLER_callback_info_t MAO_cbs[MAO_CB_COUNT] =
{
{UF_STYLER_DIALOG_INDEX, UF_STYLER_CONSTRUCTOR_CB  , 0, MAO_constructor_cb},
{UF_STYLER_DIALOG_INDEX, UF_STYLER_DESTRUCTOR_CB , 0, MAO_destructor_cb},
{UF_STYLER_DIALOG_INDEX, UF_STYLER_APPLY_CB       , 0, MAO_apply_cb},
{MAO_MATERIAL          , UF_STYLER_ACTIVATE_CB    , 0, MAO_mao_type_sel},
{MAO_PART             , UF_STYLER_ACTIVATE_CB    , 0, MAO_partname_type_sel},
{MAO_BTN             , UF_STYLER_ACTIVATE_CB    , 0, MAO_btn_cb},
{UF_STYLER_NULL_OBJECT, UF_STYLER_NO_CB, 0, 0 }
};

/*------------------------------------------------------------*/
static UF_MB_styler_actions_t actions[] = {
{ "MaterialInfo.dlg",  NULL, MAO_cbs,  UF_MB_STYLER_IS_NOT_TOP },
{ NULL,  NULL,  NULL,  0 } /* This is a NULL terminated list */
};

/*------------------------------------------------------------*/
extern void ufsta (char *param, int *retcode, int rlen)
{
int  error_code;

if ( (UF_initialize()) != 0)
      return;

if ( (error_code = UF_MB_add_styler_actions ( actions ) ) != 0 )
{
      char fail_message[133];

      UF_get_fail_message(error_code, fail_message);
      printf ( "%s\n", fail_message );
}

UF_terminate();
return;
}

/*------------------------------------------------------------*/
extern void ufusr(char *param, int *retcode, int rlen)
{
int  response = 0;
int  error_code = 0;

if ( ( UF_initialize() ) != 0 )
         return;

if ( ( error_code = UF_STYLER_create_dialog ( "MaterialInfo.dlg",
         MAO_cbs,    /* Callbacks from dialog */
         MAO_CB_COUNT, /* number of callbacks*/
         NULL,       /* This is your client data */
         &response ) ) != 0 )
{
      char fail_message[133];

      /* Get the user function fail message based on the fail code.*/
      UF_get_fail_message(error_code, fail_message);
      UF_UI_set_status (fail_message);
      printf ( "%s\n", fail_message );
}

UF_terminate();
return;
}

/*------------------------------------------------------------*/
extern int ufusr_ask_unload (void)
{
   /* unload immediately after application exits*/
   return ( UF_UNLOAD_IMMEDIATELY );

   /*via the unload selection dialog... */
   /*return ( UF_UNLOAD_SEL_DIALOG ); */
   /*when UG terminates...             */
   /*return ( UF_UNLOAD_UG_TERMINATE ); */
}

/*------------------------------------------------------------*/
extern void ufusr_cleanup (void)
{
return;
}

/*-------------------------------------------------------------------------*/
/*---------------------- UIStyler Callback Functions ----------------------*/
/*-------------------------------------------------------------------------*/
//在构造函数中初始化，将数据库中的产品列表信息调入显示窗口中

int MAO_constructor_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data)
{
UF_STYLER_item_value_type_t item_data;

   /* Make sure User Function is available. */
   if ( UF_initialize() != 0)
      return ( UF_UI_CB_CONTINUE_DIALOG );

   /* ---- Enter your callback code here ----- */
/*-------------数据库初始化-------------*/
//----在构造函数中初始化数据库，并将材料信息显示在界面中----

char JigPath[120];
strcpy(JigPath,getenv("UGII_USER_DIR"));

//CString strtemp;
strtemp = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
strtemp = strtemp + JigPath;
strtemp = strtemp + "\\application\\Mao_Manage.mdb";

try
{
CoInitialize(NULL);
      m_DBCnt.CreateInstance(__uuidof(Connection));
{
m_DBCnt->Open(strtemp.GetBuffer(strtemp.GetLength()),"","",adModeUnknown);
}
}
   catch(_com_error e)
   {
      AfxMessageBox("数据库连接失败，确认数据库设置是否正确!");
   return TRUE;
   }

//设置按钮属性
item_data.item_id=MAO_BTN;
item_data.item_attr=UF_STYLER_SENSITIVITY;
item_data.subitem_index=1;
item_data.value.integer=FALSE;
UF_STYLER_set_value(dialog_id, &item_data);

item_data.item_id=MAO_BTN;
item_data.item_attr=UF_STYLER_SENSITIVITY;
item_data.subitem_index=2;
item_data.value.integer=FALSE;
UF_STYLER_set_value(dialog_id, &item_data);

//初始化SingleList
//从数据库中选择类型，并列出

_variant_t var1;
CString str1;

item_data.item_id=MAO_MATERIAL;
item_data.item_attr=UF_STYLER_LIST_DELETE;
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
item_data.count=0;
UF_STYLER_set_value(dialog_id, &item_data);

item_data.item_id=MAO_MATERIAL;
item_data.item_attr=UF_STYLER_LIST_INSERT;
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;

if(m_DBCnt->State)
{
      m_pRecordset.CreateInstance(__uuidof(Recordset));
try
   {
   m_pRecordset->Open("SELECT Distinct MATERIAL FROM MATERIAL_INFO",
            m_DBCnt.GetInterfacePtr(),
            adOpenDynamic,
            adLockOptimistic,
            adCmdText);
   try
   {
while(!m_pRecordset->adoEOF)
{
if(!m_pRecordset->adoEOF)
var1=m_pRecordset->GetCollect("MATERIAL");
if(var1.vt != VT_NULL)
{
str1=(LPCSTR)_bstr_t(var1);

item_data.value.string=str1.GetBuffer(str1.GetLength());
item_data.indicator=UF_STYLER_STRING_VALUE;
UF_STYLER_set_value(dialog_id, &item_data);
}
if(!m_pRecordset->adoEOF)
{
m_pRecordset->MoveNext();
}
}
m_pRecordset->Close();
}
catch(_com_error *e)
{
            AfxMessageBox(e->ErrorMessage());
}
}
catch(_com_error *e)
{
            AfxMessageBox(e->ErrorMessage());
}
}

   UF_terminate ();

/* Callback acknowledged, do not terminate dialog */
return (UF_UI_CB_CONTINUE_DIALOG);
/* A return value of UF_UI_CB_EXIT_DIALOG will not be accepted */
/* for this callback type.  You must continue dialog construction.*/

}

/*------------------------------------------------------------*/
int MAO_destructor_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data)
{
   /* Make sure User Function is available. */
   if ( UF_initialize() != 0)
      return ( UF_UI_CB_CONTINUE_DIALOG );

   /* ---- Enter your callback code here ----- */

   m_DBCnt->Close(); //关闭ADO连接
   m_DBCnt= NULL;
   CoUninitialize();

   UF_terminate ();

/* Callback acknowledged, do not terminate dialog.             */
/* A return value of UF_UI_CB_EXIT_DIALOG will not be accepted  */
/* for this callback type.  You must continue dialog destruction*/
return (UF_UI_CB_CONTINUE_DIALOG);

}

/*------------------------------------------------------------*/
int MAO_apply_cb ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data)
{
   /* Make sure User Function is available. */
   if ( UF_initialize() != 0)
      return ( UF_UI_CB_CONTINUE_DIALOG );

   /* ---- Enter your callback code here ----- */

   UF_terminate ();

/* Callback acknowledged, do not terminate dialog                */
/* A return value of UF_UI_CB_EXIT_DIALOG will not be accepted */
/* for this callback type.  You must respond to your apply button.*/
return (UF_UI_CB_CONTINUE_DIALOG);

}

/*------------------------------------------------------------*/
int MAO_mao_type_sel ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data)
{
UF_STYLER_item_value_type_t item_data;

   /* Make sure User Function is available. */
   if ( UF_initialize() != 0)
      return ( UF_UI_CB_CONTINUE_DIALOG );

   /* ---- Enter your callback code here ----- */

_variant_t var;
CString str,str1,str001,str002;
   char name[100]="";
// int i=0,j,k,m=0;
//锁定按钮
item_data.item_id=MAO_BTN;
item_data.item_attr=UF_STYLER_SENSITIVITY;
item_data.subitem_index=1;
item_data.value.integer=FALSE;
UF_STYLER_set_value(dialog_id, &item_data);

item_data.item_id=MAO_BTN;
item_data.item_attr=UF_STYLER_SENSITIVITY;
item_data.subitem_index=2;
item_data.value.integer=FALSE;
UF_STYLER_set_value(dialog_id, &item_data);

item_data.item_id=MAO_MATERIAL;
item_data.item_attr=UF_STYLER_VALUE;
item_data.indicator=UF_STYLER_STRING_VALUE;
UF_STYLER_ask_value(dialog_id, &item_data);
strcpy(name,item_data.value.string);

//在材料类框中选中一项后，获取其中的字符串，以此作为关键字从数据库中搜索匹配的材料；
//将匹配的记录显示在零件名称框中。显示方式：名称+牌号，以确保唯一性。

item_data.item_id=MAO_PART;
item_data.item_attr=UF_STYLER_LIST_DELETE;
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
item_data.count=0;
UF_STYLER_set_value(dialog_id, &item_data);

item_data.item_id=MAO_PART;
item_data.item_attr=UF_STYLER_LIST_INSERT;
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;

str="SELECT NAME,BRAND FROM MATERIAL_INFO WHERE MATERIAL=\'";
str=str+name;
str=str+"\'";

if(m_DBCnt->State)
{
      m_pRecordset.CreateInstance(__uuidof(Recordset));
      try
   {
   m_pRecordset->Open((LPCSTR)str,
            m_DBCnt.GetInterfacePtr(),
            adOpenDynamic,
            adLockOptimistic,
            adCmdText);
try
{
while(!m_pRecordset->adoEOF)
{
var=m_pRecordset->GetCollect("NAME");
if(var.vt != VT_NULL)
{
str001=(LPCSTR)_bstr_t(var);
}
else
str001="";
var=m_pRecordset->GetCollect("BRAND");
if(var.vt != VT_NULL)
   {
str002=(LPCSTR)_bstr_t(var);
   }
   else
str002="";

   str1=str001+"*****";
   str1=str1+str002;

   item_data.value.string=str1.GetBuffer(str1.GetLength());
   item_data.indicator=UF_STYLER_STRING_VALUE;
   UF_STYLER_set_value(dialog_id, &item_data);

   m_pRecordset->MoveNext();
}
m_pRecordset->Close();
m_pRecordset=NULL;
}
catch(_com_error *e)
{
            AfxMessageBox(e->ErrorMessage());
}
   }
   catch(_com_error *e)
{
         AfxMessageBox(e->ErrorMessage());
}
}

   UF_terminate ();

/* Callback acknowledged, do not terminate dialog */
return (UF_UI_CB_CONTINUE_DIALOG);

/* or Callback acknowledged, terminate dialog. */
/* return ( UF_UI_CB_EXIT_DIALOG );             */

}

/*------------------------------------------------------------*/
int MAO_partname_type_sel ( int dialog_id,
         void * client_data,
         UF_STYLER_item_value_type_p_t callback_data)
{
UF_STYLER_item_value_type_t item_data;
   /* Make sure User Function is available. */
   if ( UF_initialize() != 0)
      return ( UF_UI_CB_CONTINUE_DIALOG );

   /* ---- Enter your callback code here ----- */
//选中一种材料后，改变按钮属性：保存/删除变得可用
//设置按钮属性
item_data.item_id=MAO_BTN;
item_data.item_attr=UF_STYLER_SENSITIVITY;
item_data.subitem_index=1;
item_data.value.integer=TRUE;
UF_STYLER_set_value(dialog_id, &item_data);

item_data.item_id=MAO_BTN;
item_data.item_attr=UF_STYLER_SENSITIVITY;
item_data.subitem_index=2;
item_data.value.integer=TRUE;
UF_STYLER_set_value(dialog_id, &item_data);

//选中一种材料后，一条记录被唯一确定，下一步从数据库中定位该记录，
//并将有关字段显示在相应输入框中。

char name[120]="",name1[60]="",name2[60];
int i=0,j,k,m=0;

item_data.item_id=MAO_MATERIAL;
item_data.item_attr=UF_STYLER_VALUE;
      item_data.indicator=UF_STYLER_STRING_VALUE;
      UF_STYLER_ask_value(dialog_id, &item_data);
      strcpy(name,item_data.value.string);

//显示材料类型名称
item_data.item_id=MAO_NAME;
item_data.item_attr=UF_STYLER_VALUE;
item_data.value.integer=TRUE;
item_data.count=1;
item_data.value.string=name;
UF_STYLER_set_value(dialog_id, &item_data);
str_tmp2=name;

item_data.item_id=MAO_PART;
item_data.item_attr=UF_STYLER_VALUE;
      item_data.indicator=UF_STYLER_STRING_VALUE;
      UF_STYLER_ask_value(dialog_id, &item_data);
      strcpy(name,item_data.value.string);

j=strlen(name);
while(name!='*')
8 E* {, ~2 D& [) F, q/ J' [ {# q/ p% V0 `2 F" J; p. @
name1=name;
+ W* `- c1 \( d7 h& f# ]' M) J i++;
9 p4 t9 W9 }% v& O) M- L }
) r* u! _$ y3 Z# u name1='\0';2 B% C4 G2 m5 Y9 z" B9 k; D5 D

: T/ @$ c2 L7 @5 O for(k=i+5;k<j;k++)5 B$ G9 D6 \7 e5 E1 k8 g# y
{
! W. |9 M: k0 b8 z2 u! V name2[m]=name[k];# J) J- |, @( L, k
m++;3 V& h* z7 J6 m4 \1 k
}$ ~5 m) S3 m3 f
name2[m]='\0';
. ~6 a; i8 l% b8 q, R //name1: 材料类型名称；name2: 零件名称! `) o2 F% b5 |3 {

0 e2 d- [2 V! i! z" m* r" u. p2 y+ [, ^% T+ m* `6 ~7 V( e9 a
//显示零件名称
6 H1 D! R& o0 j" X. D1 ] item_data.item_id=MAO_PARTNAME;( o8 @7 u- {1 S3 \8 f5 R8 q
item_data.item_attr=UF_STYLER_VALUE;7 t" j, |: t1 _4 J: z+ H6 `
item_data.value.integer=TRUE;
0 b: a; v, K- X, Z item_data.count=1;
( s0 h% Q. v( u" N8 z item_data.value.string=name1;* ~3 ^& h& q9 ?. r( X
UF_STYLER_set_value(dialog_id, &item_data);
9 i/ h; \  t9 K$ e6 W! A( B5 w
) x* y# k, M- @. H//显示零件材料牌号
# G  A- j1 k4 c" T4 c item_data.item_id=MAO_NO;
! L4 `) J) }8 x# m0 W) f% V item_data.item_attr=UF_STYLER_VALUE;
& O$ @& q7 T/ {! J- E( u6 G7 x- A item_data.value.integer=TRUE;# d3 I2 m* J( C
item_data.count=1;7 [+ [- Y' x# W3 m
item_data.value.string=name2;
4 d/ L3 `+ p( W( E4 n UF_STYLER_set_value(dialog_id, &item_data);
' ?+ j) U6 b- A  |) V . w7 H' ]! c: ~  h3 l- o( _
str_tmp3=name1;5 E4 @' C" G+ `. r
str_tmp4=name2;
5 }1 ?+ U' P* j2 D+ M6 w. P
% a0 B- S- p4 p$ b) A( } _variant_t var1;- U! H5 d! S: D+ b0 k: _6 c8 Y
CString str,str1,str2;
# ~7 h4 k1 V& \) l3 \. B" `" S6 w  B7 P1 \
str="SELECT * FROM MATERIAL_INFO WHERE NAME=\'";
4 b! D  V- H0 Q2 Q' w: O# N, C str=str+name1;. m+ ^2 {: g- ~- S1 d# K
str=str+"\' and BRAND=\'";
" x1 Y. A& ]/ Q1 B* u3 [ str=str+name2;
  K$ `1 N0 `# k4 e7 x7 Y0 a/ p$ [ str=str+"\'";
2 Y  L. |( G8 b" s( H0 J5 W# s: L7 Z0 M2 Y: |2 @  l! L, c$ l, z* N
if(m_DBCnt->State)
" [2 O" j$ q; E, c4 P+ ~  Q# ] {! Z8 g( }) }- ~+ Z2 Q
         m_pRecordset.CreateInstance(__uuidof(Recordset));
, N& x7 R! d0 H" U          try" O8 U8 |) [+ V
{5 S. P9 F. s% z( x5 @* O( n
m_pRecordset->Open(str.GetBuffer(str.GetLength()),       ) e8 {0 i# t" K9 q5 b0 }' _: W
            m_DBCnt.GetInterfacePtr(),1 ^% |4 p- w* i/ P8 r$ c) Q- t: L
            adOpenDynamic,7 y9 J% w  L9 [' `, f4 r
            adLockOptimistic,
( |0 T0 }0 [$ ]; E             adCmdText);
6 S0 G' e- Q7 p2 r( j0 x/ r$ r/ j, q, U+ ?" J
   if(!m_pRecordset->adoEOF)
' Z- j% Y  M$ M) P1 _ var1=m_pRecordset->GetCollect("IID");9 R# x% X6 v  m
   if(var1.vt != VT_NULL). p; ^# l6 v  I- f
str1=(LPCSTR)_bstr_t(var1);
+ l, F- i7 f8 E" X. K    else$ Y7 l1 _4 Y! e+ F/ ?( f+ D
   str1="";8 ~, S9 i5 R4 R$ W3 W
   str_tmp1=str1;) n0 W( _( {: u& D3 L$ \8 t
1 `1 i- k6 Y' v2 B
   if(!m_pRecordset->adoEOF) ( ]: E$ U. Z8 ~
var1=m_pRecordset->GetCollect("GB_CODE");
2 c' A) |5 k$ v. W$ I- y    if(var1.vt != VT_NULL)
2 t, j# J8 v. I str1=(LPCSTR)_bstr_t(var1);
3 W5 U! M: z. }" P1 D3 a  D" X& ]    else
. v! t* C5 O6 o3 ~9 B5 j    str1="";
& p$ ~! ]) q! R8 t9 T    if(!m_pRecordset->adoEOF); |8 J$ h% o% }7 G3 R6 C. R. G
var1=m_pRecordset->GetCollect("NOTE");0 q3 E4 U9 v5 J% I# d1 Z
   if(var1.vt != VT_NULL)
+ P5 d' Y" f$ H- D, m" b str2=(LPCSTR)_bstr_t(var1);9 G  ~6 G* S' {
   else1 o# V/ S. w% N+ x. k, Z
   str2="";" g  |+ k; G, r$ r
}! Y- y) {9 Z# i" U" w- H! [4 o  D
catch(_com_error *e)* U: {. r; V# d
{
5 |) w6 v7 e1 x# ]    AfxMessageBox(e->ErrorMessage());
" _0 p0 \# i6 G }" g; ^$ k7 o0 N( Y
m_pRecordset->Close();+ {8 J: {7 [2 q4 X  m
}
( U- X) n- N0 j& g) B+ T* r$ Q8 z2 N+ D
//显示国标代号3 U) F- d7 ^( c6 l/ o' W: ]% o
//显示备注) Q- x, t6 K7 g3 H* k% j
item_data.item_id=MAO_STD_NO1;
' }& E6 M- X$ Z) y5 ~2 L item_data.item_attr=UF_STYLER_VALUE;0 ?' x8 g- x" X/ B8 K
item_data.value.integer=TRUE;
2 {, _+ v1 u  `) s8 H% Y2 }( L item_data.count=1;6 Q7 g' ], u7 C0 r+ }9 a
item_data.value.string=str1.GetBuffer(str1.GetLength());0 R  @, j4 A9 r+ F) \
UF_STYLER_set_value(dialog_id, &item_data);
: U& w. q! }% o0 J# G1 k# Y2 E3 V/ W: J
item_data.item_id=MAO_NOTE;
+ k: L# i) Q& x# G item_data.item_attr=UF_STYLER_VALUE;# P5 {- @3 P3 x6 f& e. e1 [' X& ]
item_data.value.integer=TRUE;
3 I0 i. Y/ ]0 | item_data.count=1;2 q  @5 V: g5 v
item_data.value.string=str2.GetBuffer(str2.GetLength());
- r, q( ~7 c1 ~9 W. m2 H. B UF_STYLER_set_value(dialog_id, &item_data);
& B$ E5 D1 `9 ^" G2 A9 w9 D9 G( D  d, P. Q6 o
str_tmp5=str1;
! \  {. j5 Z2 ^* t7 d str_tmp6=str2;, l2 X8 M* o7 w2 Y2 }+ X

- S; O" N) G2 o( ]7 F4 @9 D    UF_terminate ();# i1 q. H1 q+ h" Z/ w# J

- p4 o7 D* H( U% F /* Callback acknowledged, do not terminate dialog */3 h0 L2 e: m0 _7 O& P/ D' }
return (UF_UI_CB_CONTINUE_DIALOG); # X9 m+ D2 Y4 n! ]  f+ p

4 ?# |5 _9 ^: q7 A /* or Callback acknowledged, terminate dialog. */% T( s' s9 \+ g  A: i7 s! t
/* return ( UF_UI_CB_EXIT_DIALOG );             */
3 d( i$ p0 _1 U$ k+ ]! T- Y% m/ n' |4 n3 p, M" t5 F
}
" e6 U" A9 [; Y& ~% {% `
1 m3 H" u1 b3 |! X  C3 y5 }; R1 y
8 |4 v6 P& V7 l6 X6 K! y/*------------------------------------------------------------*/
5 ^, o: @" L8 \8 t" e" N$ ^int MAO_btn_cb ( int dialog_id,; ^5 \9 J, i9 i0 Y# T
         void * client_data,9 [% _7 s0 a& @( a
         UF_STYLER_item_value_type_p_t callback_data)
1 a6 C9 B6 [% S" x2 `6 S{% M5 J. k/ \: ]
UF_STYLER_item_value_type_t item_data,item_data1;9 O5 i8 }. D# q" b: ^! S
   /* Make sure User Function is available. */  / d0 R: `8 [' N+ ~( i
   if ( UF_initialize() != 0)
# C) B8 S3 _, S, A- l( x! z3 p- l       return ( UF_UI_CB_CONTINUE_DIALOG );
: p( i, ~2 [2 O+ ]  }- }
5 B+ {; f# p. K    /* ---- Enter your callback code here ----- */
* E7 k$ z" z$ d0 d9 M+ e: k/ y$ I+ l$ M, e
_variant_t var;
$ \" W3 R. q# o7 h; P. ` CString str,str0;
9 g6 g9 W; r1 r9 {! a5 h# L* N, j2 j* ?
//获取按钮的索引值
$ O8 t5 F( z% n( a int BtnNdx;! L% P- V' W/ r9 B
item_data.item_attr=UF_STYLER_VALUE;
9 B$ {* ?$ I& w2 r item_data.item_id=MAO_BTN;
0 _6 Z8 n& ~" @ item_data.indicator=UF_STYLER_INTEGER_VALUE;
# X1 X& X, {/ A/ J# ?5 x UF_STYLER_ask_value(dialog_id, &item_data); 9 Y% S2 {5 ]& W1 ]8 C* ?
BtnNdx=item_data.value.integer; ! F3 l' x/ r3 c' }$ [1 E/ L- H

+ B1 Q7 Q( f; N: x//添加新材料7 {' D# U( w9 l& o/ z9 C
if(BtnNdx==0), d5 s9 Z. q+ L; x  V# ~0 S1 {* h
{
* U) I6 Y/ v; ]$ n0 _ add_mark=1;
; y& p# g' X% e7 G+ x
1 S1 W+ a! q' X5 H //点击添加后,清空输入框中的内容, T! J. |* L# @* U  s
item_data.item_id=MAO_PARTNAME; //零件类名称
3 X8 @+ ~6 s3 R: c4 ` item_data.item_attr=UF_STYLER_VALUE;  g, s/ V7 O+ }9 }- {
item_data.value.integer=FALSE;
+ H8 y( P# k+ p6 ]8 O5 L, k UF_STYLER_set_value(dialog_id, &item_data);
; I6 E( ^6 B5 Z$ z8 z- C item_data.value.integer=TRUE;
& o2 [$ ~- u8 p5 h; s* e UF_STYLER_set_value(dialog_id, &item_data);* m# ]! T. ^/ y4 \$ a' v* N  a) _
6 J/ ~0 B0 E6 C, }2 r+ v2 U) v
item_data.item_id=MAO_NO; //零件牌号
6 i" [5 y; ?- L, W+ U5 _ item_data.item_attr=UF_STYLER_VALUE;8 u' [2 B2 l6 {" J0 k9 j" i( g7 w
item_data.value.integer=FALSE;' |. l( e# y1 a0 ?% o2 _
UF_STYLER_set_value(dialog_id, &item_data);
6 D, k8 F5 X0 Y( {; [% t item_data.value.integer=TRUE;
( V. Y7 s# [' n' c( Q& `0 d
2 ^5 a: o' r0 \* |* P! O item_data.item_id=MAO_STD_NO1; //标准代号
; }% G! a9 P: Z' q8 e item_data.item_attr=UF_STYLER_VALUE;& ^( y. W! I7 M# v
item_data.value.integer=FALSE;
, _, a( P) u; L/ Z! u# Q$ J9 g: C UF_STYLER_set_value(dialog_id, &item_data);
3 U$ T% u* P$ B* F item_data.value.integer=TRUE;% U. V" Z3 o0 _$ M. G8 q9 M

7 @0 F0 A# [( y3 z item_data.item_id=MAO_NOTE; //备注
. _  h& q+ }+ j& K2 S  S5 O item_data.item_attr=UF_STYLER_VALUE;
- d1 Z+ k# G9 z item_data.value.integer=FALSE;
9 c- A" d, T9 s+ B3 y$ f UF_STYLER_set_value(dialog_id, &item_data);
- @3 b; f: j) s( j3 s) B8 s  ^ item_data.value.integer=TRUE;/ i# C3 D( M0 R
}
0 e! f% x2 y+ s1 A  w+ f, H( B; l2 D9 i* X! V, k
//保存修改后的信息
  b' M# Z- ^# E) s# Z if(BtnNdx==1). ]# h: H2 z  ]( m
{
" D  ^" n( W: o% _ char temp1[80]="",temp2[80]="",temp3[80]="";& `" m  q) K! M3 V5 a/ `  K" c
char temp4[40]="",temp5[200]="";
/ z, b7 k/ x# t5 s8 k' i1 S8 P' ^5 d
//获取当前输入框中的信息
& D4 [& {* q4 y+ k. `0 Y$ `( e" ]. { item_data.item_id=MAO_NAME;
0 j% y( A7 \) o0 g7 w1 H item_data.item_attr=UF_STYLER_VALUE; - d' S$ E' `" V  w1 o5 w
      item_data.indicator=UF_STYLER_STRING_VALUE; 7 n' r: E+ p' I- k
      UF_STYLER_ask_value(dialog_id, &item_data);
! g4 G3 q9 L! Z- s" D# H6 y! b+ w       strcpy(temp1,item_data.value.string);1 [" Q4 k5 x; m" N

' F, m3 _2 n* Y- |! u9 | item_data.item_id=MAO_PARTNAME;
2 c) u# X2 ]& r2 C3 V. S item_data.item_attr=UF_STYLER_VALUE; 7 D0 R0 b7 a) E& p
      item_data.indicator=UF_STYLER_STRING_VALUE; * m6 ?: k2 ~2 p' _
      UF_STYLER_ask_value(dialog_id, &item_data);
" j6 _0 Y, F- F7 S1 J: r2 v8 z3 x0 |0 i       strcpy(temp2,item_data.value.string);. ?$ _5 j9 s% A: z: o

" W4 a& k9 F) Y item_data.item_id=MAO_NO;
$ m2 h' P5 G3 u& c$ L9 {' G. L item_data.item_attr=UF_STYLER_VALUE; . S8 o; H1 d' o1 v6 w
      item_data.indicator=UF_STYLER_STRING_VALUE; $ d0 I/ ^! H- V5 w/ ]3 Z8 X% o
      UF_STYLER_ask_value(dialog_id, &item_data);
* {, G1 V0 q4 S, g. A       strcpy(temp3,item_data.value.string);$ ?7 l. l( v- ]8 F1 y1 I/ z
3 j$ e4 V5 `* s; I# a; j1 F5 u
item_data.item_id=MAO_STD_NO1;' x4 f$ l* r& x
item_data.item_attr=UF_STYLER_VALUE;
6 e# H$ \3 }* z" `       item_data.indicator=UF_STYLER_STRING_VALUE;
/ ]0 x0 S6 S& d& m$ F       UF_STYLER_ask_value(dialog_id, &item_data); 8 H8 l: E. G% U% w
      strcpy(temp4,item_data.value.string);2 A+ |# h! F2 F% L& u8 v
7 ~. h, e7 O# B
item_data.item_id=MAO_NOTE;, a7 G4 U+ A* W6 |8 d2 V! J$ E1 }
item_data.item_attr=UF_STYLER_VALUE;
. S1 m+ e5 G: b/ A0 g$ w       item_data.indicator=UF_STYLER_STRING_VALUE; + K. G' r% Q( L7 _
      UF_STYLER_ask_value(dialog_id, &item_data); + J# s) ?5 w4 x% A: M. x: P
      strcpy(temp5,item_data.value.string);  S" k+ L$ e3 D4 ]5 T
# K0 o6 f  M" }" c
if (add_mark!=1)% ~. A' A; ?) {* [
{
5 W! ?% o8 o' a5 W% w5 P if((strcmp(str_tmp2,temp1)==0)&&(strcmp(str_tmp3,temp2)==0)&&- N2 t$ L0 g  i7 C7 f4 ^; s( |
(strcmp(str_tmp4,temp3)==0)&&(strcmp(str_tmp5,temp4)==0)&&
# ?! l& s4 u! f/ } (strcmp(str_tmp6,temp5)==0))+ p4 P: b7 f  U- g4 ~
{
' H# ~8 T. Y0 p return (UF_UI_CB_CONTINUE_DIALOG);
) q+ Y& ]3 p, Z+ e- Y }2 i* m6 L$ ?8 A5 E  G% N+ u$ c, Z
else8 {# a# l3 L* U, e
{7 ~; z; r: \  H3 o
int info;. e3 P0 a% N! X% c# q
info=MessageBox(NULL,"纪录已经改变，是否保存？","信息提示",MB_YESNO);: k4 D2 B' f7 X; @8 M
if(info==7)
# u6 l3 j( Y( l9 L1 O return ( UF_UI_CB_CONTINUE_DIALOG );
' h. ]/ r! w3 x( ^1 f0 r //如果选择"是"，则保存修改后的信息* w+ ~4 m* M- i- n- ~' _

) n& S7 }- ^' T% s8 L if(temp1[0]==NULL)
3 z7 w9 u( ]' I$ P# |. l- m; i {
* D4 p" _  u, } uc1601("材料类别不能为空!",1);
/ g" r9 r: i1 u return (UF_UI_CB_CONTINUE_DIALOG);. g- ]+ _& _; x& z$ A5 x1 \' O
}
# P& v; o  |, T0 C8 H$ k
! g0 ?+ a9 y3 f: P0 \. e str="SELECT NAME,BRAND FROM MATERIAL_INFO WHERE NAME=\'";
+ M4 h. @+ e  Y) h0 t7 v. { str=str+str_tmp3;
- A8 I% \$ m0 {+ i$ [( U str=str+"\' and BRAND=\'";
6 ]( d% w% M# c+ J- a9 j' ~2 r; b str=str+str_tmp3;# h5 `; E8 t- M2 E/ }. u
str=str+"\'";& f6 G) {: H$ l1 a

2 Q- D/ G% A2 P7 x2 G if(m_DBCnt->State)  d# C) B/ K- a) v
{
+ @( J: ~2 M  X          m_pRecordset.CreateInstance(__uuidof(Recordset));$ R& s# A, O. _1 `
         try% m' J( M+ N) p3 G0 x
{
  X, i& V7 |6 `. C# Y% L m_pRecordset->Open(str.GetBuffer(str.GetLength()),       . b' q0 x; Y, e& a
            m_DBCnt.GetInterfacePtr(),, H1 F9 J1 @/ v- |2 Y2 t. H7 O
      adOpenDynamic,5 d0 p0 u" n2 G/ h3 d. `) T  L6 G
   adLockOptimistic,
! e: e$ j! u7 @8 F/ V* M. i6 ~: ?    adCmdText);1 g$ ?# ?3 c# ^' R& l
}
) C2 K/ \( k! d! w" Q+ [; ~ catch(_com_error *e); {  U" A8 B& `7 x
{
" B+ ^$ H7 a! z" l5 c# q5 t    AfxMessageBox(e->ErrorMessage());
% \& l# l2 O3 f' g7 Y }7 H2 H, i, ]: F) N. s% e4 ~* W/ Y
// if(DbType=='2')
  b2 J  p# R2 ]/ Q* V8 V+ { {
4 d: Y4 ]1 D: q& o) j/ w# n, ~- J1 w str="DELETE FROM MATERIAL_INFO WHERE IID=";
2 Y6 ~! S: q- x$ B  [ str=str+str_tmp1;4 e- m1 `' h) E3 G  }
try" Z/ h! F! U5 V- l: f- \
{
' ]8 }& c1 L) ]: u/ h m_DBCnt->Execute(str.GetBuffer(str.GetLength()),NULL,adCmdText);
' T# D5 n& U. w( ]" s/ z6 V4 m# _) p m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);/ I; o) a! N- }/ J0 q" ^1 m0 U
}
, I, N( B0 M8 h' g+ n catch(_com_error& e)
5 I* z# f- f( T: D" F {
: m. o9 f! ]3 e1 G9 {3 x# E }
- `9 M+ B* V2 J' }- d str="INSERT INTO MATERIAL_INFO VALUES(";
7 X  u8 z- i" \$ C str=str+str_tmp1;
6 G6 V. s2 ?7 z0 [7 m str=str+",\'";
  m" x" j% U9 k str=str+temp1+"\',\'"+temp2+"\',\'"+temp3+"\',\'"+temp4+"\',\'"+temp5+"\')";
$ J) ?3 J+ ]# ^* v( ^- f }% U2 O9 V, C  |/ o$ d+ ]6 `- x
try  H8 k$ @; q1 T3 ?6 o3 z, h
{
' @$ K" a9 N& ~; {/ d$ p m_DBCnt->Execute(str.GetBuffer(str.GetLength()),NULL,adCmdText);
. h  B7 `( h0 v/ W5 a$ d5 S m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);" F# [6 G# w5 D! S# D6 s9 |
} . T( E- @" d9 K- B( G, o
catch(_com_error &e). V; c/ @  |8 t  @% f4 }4 Q
      {  _6 }2 j* u' x  J
// AfxMessageBox(e.ErrorMessage());
+ j% X! l' i6 `6 ~8 x1 f* Y       }
5 H' z5 Y: p1 {, J; v6 B8 q, f# t" W+ X& X3 a& N; T
AfxMessageBox("修改成功！");
0 J. q& B  I5 ~) G, M }) p2 T6 x* \! L0 Q7 r

$ U8 a( K8 L% M2 B4 d if(m_DBCnt->State); _$ S0 T, ^+ g! M' o
{- H5 u  B3 F# [6 J0 ^& |
   m_pRecordset.CreateInstance(__uuidof(Recordset));
6 O0 L9 w6 w( o7 k8 X# |: c       try5 G/ ~6 t9 f, R" p
{, ^% m4 Y6 }% s- u7 S$ o
m_pRecordset->Open("SELECT * FROM MATERIAL_INFO ORDER BY IID ASC",: v) u5 C# U3 B7 g
            m_DBCnt.GetInterfacePtr(),0 i/ e2 C3 _/ Q. c( h% B
            adOpenDynamic,4 E3 }' y/ V; J- ]- _: I4 ^
            adLockOptimistic,
! [! B! `; c1 _+ M7 |4 O             adCmdText);* H* y. Q1 N  i
}9 ]& E) @0 F  L, O
catch(_com_error *e)
8 N0 s8 h& M# K$ d& u: _; _ { 0 J8 T. o4 ~- }
   AfxMessageBox(e->ErrorMessage());
/ Y: m4 |+ F  @& q: q$ @9 ] }
$ ~; ]! H, j; E }5 Z5 i0 X* l2 z7 ]0 z. \
}}# m6 P" q: |0 b0 X7 M4 I( V
//点击过添加按钮，现在保存的是新添加的记录，保存完成后将添加标记add_mark=06 j3 D/ n5 {/ M" d
if (add_mark==1)0 T$ U) U6 Q" z, O. T9 c
{9 E6 h9 _& V! g5 o( y" r- y
if(temp1[0]==NULL)
6 Y4 u% l7 T- |( ^# }5 ^! p; k  \ {! q, E5 M( g, l, N7 L/ ~' [
uc1601("材料类别不能为空!",1);
5 Q' x" W6 g/ N" t return (UF_UI_CB_CONTINUE_DIALOG);
6 i7 R6 H. s5 n) H& ^# d1 e0 o8 `! U }
. B4 x  L' a# [0 X8 e9 H$ U/ b$ m2 ` //确定当前表中的最大ID号
! F( m4 W# U$ R* S0 }8 l2 t9 F$ ?& Q //select MAX(IID) from MATERIAL_INFO
# ~5 e& y' d7 s* U. W. l if(m_DBCnt->State)( u: j8 h. r0 b6 c  y( h
{
( d4 ?7 x8 S" l7 l  K. A m_pRecordset.CreateInstance(__uuidof(Recordset));
4 \% A( V. |" L try
, w" t# o8 m" X! B1 F0 Y {; W) }( V8 d- o* r
m_pRecordset->Open("SELECT * FROM MATERIAL_INFO ORDER BY IID DESC",6 o/ a9 o! p. ~. x. H& m! I
m_DBCnt.GetInterfacePtr(),8 D: U. Y. K5 \
adOpenDynamic,
8 y2 c0 E+ V4 R8 J, r adLockOptimistic,4 {+ r- g9 o9 {
adCmdText);4 O+ q; Z6 Z( i/ X9 {* b) E8 ^
}: x5 b! Y6 l; A, \# p* k
catch(_com_error *e)
6 ?7 j" u5 T: c) T# N* Q { 6 V4 y4 c1 Z% s" H1 X, x2 l9 x
AfxMessageBox(e->ErrorMessage());  y. O% r5 w. s# B  Q4 Q3 Q
}
- X6 ?# R3 J. M7 ]& s }4 l. g" Q. t. L$ H0 t5 x+ [) _
try7 y1 I! Q7 O: \: u
{( l5 ^' N+ h% a! q& a4 }7 Y: N
if(!m_pRecordset->adoEOF). N+ u- Z$ H* R! x5 ]+ g
{
  W# U; K7 I6 g var = m_pRecordset->GetCollect("IID");, D4 y  f3 ^3 M2 k( O0 k
if(var.vt != VT_NULL)
4 Y+ o6 v6 g4 P3 P str=(LPCSTR)_bstr_t(var);
4 t! \- Y: c7 x$ a% C" b else7 {3 y9 a4 Q5 `# u) ^
str="";
; R# F. g! g! g0 H  g }
9 Z- I: c9 @* v% E4 q( [ }
( @$ s2 Y7 q2 d  n$ }9 G+ M) f catch(_com_error& e)# C& J+ m3 q) O/ `1 S' Z
      {
6 O. K7 T& ?3 q3 X AfxMessageBox(e.ErrorMessage());! f) Z( ?9 l7 a+ b: a
      }, x, l3 r5 e% N. N- ~4 h

* U9 B. L& v1 z9 t str0="INSERT INTO MATERIAL_INFO VALUES(";& T# x& b1 L, e& b
str0=str0+str;8 R# ?6 G" Y2 |/ u. m; i/ I
str0=str0+"+1,"; //在原有最大号上加1
  W- S; |7 U  Q5 |$ i' [ str0=str0+"\'";+ A- A7 {% X) w0 _6 l
str0=str0+temp1;
6 Q1 L$ D+ @5 U9 {3 ?0 R2 p- t  J str0=str0+"\',\'";4 P. O, M$ _# Q5 \! M7 S$ k' N4 @4 k
str0=str0+temp2;# |0 n1 M  K4 r
str0=str0+"\',\'";% g' T& u) M: |8 c6 r6 x, K
str0=str0+temp3;0 F+ _3 I: c- D8 I1 u! ^0 n9 e
str0=str0+"\',\'";
9 B9 ^: J1 ]" `* @ str0=str0+temp4;1 R# u$ H4 f! S: ]9 M  X1 f4 |
str0=str0+"\',\'";
1 a& d0 R( ]  ^6 F4 }9 ^ str0=str0+temp5;
$ n, p' m! \- ^  N* \* y* t* ~ str0=str0+"\')";# l5 a1 D2 P* H

) C/ u+ b* {  J* S7 t* w try: D" `& U# N' x
{- ~& E/ z$ n9 w/ f9 o% a' p
m_DBCnt->Execute(str0.GetBuffer(str0.GetLength()),NULL,adCmdText);( V: d4 Q* o# e) r! A+ X
m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);) h" f$ I. e8 q9 r- u& q) z! m0 B
} " O" E5 w/ G5 Z/ b5 z& C( U
catch(_com_error& e)  }& [9 M& y: g4 Q0 a. _
      {! I( E. @% d# \: j5 g, g' `
// AfxMessageBox(e.ErrorMessage());
" V5 y# Q3 {5 k8 D" }       }
' t3 N" A3 {6 X9 |% A2 L AfxMessageBox("新记录添加成功！");
2 q3 v$ e& N& W. D3 a4 j m_pRecordset->Close();
# R) j+ g+ O( `. }& a# C7 Z4 u( v7 [' [$ h9 T. Y
add_mark=0;
2 E" Y7 q& a0 A2 g4 E5 B  I# i//添加或修改后的保存完成,并设置add_mark为"0",即未添加状态( b3 j5 L! U" B$ O; q

2 l# t6 m, ?& r1 j2 j }
/ K! P" W# ^8 a6 m* ]+ R//下一步是刷新屏幕,将添加完后的信息重新显示在屏幕上6 D- h/ @  F; W3 ^
//材料类型单选列表框
8 ~. n  {. h8 g item_data.item_id=MAO_MATERIAL;' x! X/ e8 ~: u6 [0 d# S
item_data.item_attr=UF_STYLER_LIST_DELETE; 7 S# S* w4 i) k
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;3 W0 ~$ Y3 D7 m
item_data.count=0; 4 M) `9 @* M  T4 |
UF_STYLER_set_value(dialog_id, &item_data);/ B7 [5 e& D( F* O5 j& g& H
) i, e! V; E3 ]5 L7 ?' y+ r9 C
item_data.item_id=MAO_MATERIAL;+ _9 U# ?9 S. z  Q* u6 H
item_data.item_attr=UF_STYLER_LIST_INSERT;$ T' ]  t; u/ E7 ~
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
7 q6 e4 T8 V& R2 s1 i2 q7 [( a2 h' g+ C( D5 I
//零件类列表框) }, ?- q$ l3 m& E: [# s" v
item_data1.item_id=MAO_PART;
# C: W* k3 d5 _# V& {4 Q$ L item_data1.item_attr=UF_STYLER_LIST_DELETE;
* s& K4 `$ S! n5 Y; a+ r item_data1.subitem_index=UF_STYLER_NO_SUB_INDEX;. V( f: B/ ^: y( Y" V  E
item_data1.count=0;
. F" F' ^, g: f6 Y( s. @' k UF_STYLER_set_value(dialog_id, &item_data1);; `# {/ ^* O' M3 J0 G  e: k

5 u  |/ r2 J' s! \& i" K if(m_DBCnt->State)
  B% k3 A8 g# y {
3 g$ v) _# k% U9 f3 e: A       m_pRecordset.CreateInstance(__uuidof(Recordset));  \6 I" e  s9 L
try; J# E  D7 t. d% j% ?1 A* U  s) f
   {0 s$ f- t) B9 b" Y! s. i9 g( ^
m_pRecordset->Open("SELECT Distinct MATERIAL FROM MATERIAL_INFO",
8 y6 [5 t& o" c             m_DBCnt.GetInterfacePtr(),
+ o; W7 J- S6 b8 o             adOpenDynamic,
3 j- y- \% D* i             adLockOptimistic,
3 ]  F, ~  s3 m) R  T0 q) ], p             adCmdText);5 T8 V- v1 O0 ]  a' Y
try  T9 W7 w# j9 ?. k* E
{             : l! {  ~, R: A: |1 {. P0 ]
while(!m_pRecordset->adoEOF)& O0 a( y$ r# \5 g% e# R. [
{
0 e/ d; p, q% U9 w if(!m_pRecordset->adoEOF)0 n( y6 S' K2 B" y$ e
var=m_pRecordset->GetCollect("MATTYPE");
' d" m- d5 `/ H$ |  W! Z" W. l if(var.vt != VT_NULL)
, X: @) R& B$ o1 D7 \, j# f {
+ }+ o1 t8 G$ r: T str=(LPCSTR)_bstr_t(var);( U+ {! C7 K( {7 y
item_data.value.string=str.GetBuffer(str.GetLength());
9 h$ q; \" Y& B, ^( p7 O, x2 R4 W item_data.indicator=UF_STYLER_STRING_VALUE;; Z9 F; d% f) V+ k, I# x( H* Y
UF_STYLER_set_value(dialog_id, &item_data);' }& x$ ]. M4 s# }% O* d; ^
}
! `% O4 b% ~4 X; x if(!m_pRecordset->adoEOF)" X  r- {! {' |8 L
m_pRecordset->MoveNext();
4 x! Y0 D/ `' w2 l }
+ u. q# q9 D/ Q) F/ `% t m_pRecordset->Close();
3 W5 J$ m" k; P$ M }% _* m' r( {8 J' }
catch(_com_error *e)% s2 R8 U- m. x) j" y
{/ Z& k+ L2 \* W1 v. S4 X/ P+ U
            AfxMessageBox(e->ErrorMessage());- T! m' J9 M- D3 T$ [
}
; r6 ^# p, ]* w" ]. d7 O+ S }
! D( b& d% Z2 z+ i5 T catch(_com_error *e)
9 D5 c, U5 r3 W* s2 v: B+ B {
/ v; r( x5 e2 c             AfxMessageBox(e->ErrorMessage());
3 J. h0 r8 ^1 s! y" a. D9 s2 y9 S' i }# s% d9 J) ~. m1 {+ n6 g/ c
}
6 K6 X, X0 c; k, O; `* B8 c//锁定按钮
4 m0 `( K( m9 A% D; y3 @0 I item_data.item_id=MAO_BTN;: |6 B/ x# w' B- _1 ?
item_data.item_attr=UF_STYLER_SENSITIVITY;
) N) {" H" I- V" } item_data.subitem_index=1;! T" H& D2 q; [5 W/ J+ A8 I
item_data.value.integer=FALSE;# J$ u) _8 x' ]6 S6 U1 j
UF_STYLER_set_value(dialog_id, &item_data);
0 M$ D7 N$ b% q4 I4 Q3 a1 J, K! [' M. Z1 Q; O
item_data.item_id=MAO_BTN;
: C& w8 S1 M9 O% r% R item_data.item_attr=UF_STYLER_SENSITIVITY;; f* F5 f- n: ?; k% i
item_data.subitem_index=2;# n6 W, Y( X/ g* D( j5 K
item_data.value.integer=FALSE;
2 m+ s, \* B2 Q5 Y UF_STYLER_set_value(dialog_id, &item_data);
# p" y. W2 d' p( E0 h; b5 N1 h1 z6 i7 g
}
' G9 t. |' ^) e3 i9 D4 |: i6 N2 Z
2 y4 B. y" D$ p# w/ {+ f$ o//删除材料信息$ V) X1 j3 p8 d2 H. G3 y6 b
if(BtnNdx==2)8 ?& G4 l7 s. }* v2 M
{, o  w) c* H/ L
str="DELETE FROM MATERIAL_INFO WHERE IID=";
5 u/ r7 u# l( w/ n' F' ]8 _ str0="SELECT * FROM MATERIAL_INFO WHERE IID=";
+ T7 z8 i, ~" J& j* O& ? str=str+str_tmp1;
+ T9 D; a) r* U6 r3 O str0=str0+str_tmp1;
7 P- U  [, z0 \# ^1 @% q% `! f( ?/ b3 @
int info=-1;
- G( n; h) \6 S" w# h info=MessageBox(NULL,"您确实要删除选中的纪录吗？","信息提示",MB_YESNO);" g( ~" q6 c4 q& |' d) O
if(info==7) //选择"否"
3 W/ [) u1 j3 `9 Y6 r) | {
- R& U; L: y3 z! o1 B$ C) N3 L return ( UF_UI_CB_CONTINUE_DIALOG );4 @$ d- A, `- x
}
' X) q$ W# [$ c& g; O4 K else
% K) G  c6 E2 h3 E: o3 w( | {. d0 i5 Z# S% H8 l% Q) C1 [
if(m_DBCnt->State)* Y- o. R0 B3 J/ B' T' R' @  ~
{2 r; x  V$ a' ~2 G
         m_pRecordset.CreateInstance(__uuidof(Recordset));1 |8 y. O8 c& G  f  y* x- d3 t
         try4 \4 m' V- }' x$ [, ^
{* E5 a: V& c0 \" W# t/ F9 p
m_pRecordset->Open(str0.GetBuffer(str0.GetLength()),8 }2 C5 \- R% H) k$ x
            m_DBCnt.GetInterfacePtr(),
. e0 {5 U+ \+ R7 ^9 A             adOpenDynamic,5 F8 O8 q& V. D$ k2 H# P
   adLockOptimistic,
; D& o8 Y. x4 v             adCmdText);) M4 W: e3 {6 A; e# I. G: `* n
}
" a1 `% s6 T+ D( C1 M, \ catch(_com_error *e)
0 }5 S0 T& f2 V9 }. h% A# M. u# [7 M {' O, o/ _( e  j
//    AfxMessageBox(e->ErrorMessage());
3 r- e9 k) y5 E2 ~ }
' Q2 a3 D( d- p% H try
5 O: H  ?0 `# c7 R3 D5 Q {
# C7 g* z# ]  H+ X1 x, ~ m_DBCnt->Execute(str.GetBuffer(str.GetLength()),NULL,adCmdText);
. |' j5 B; q, u* G: P m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);' b' s: w8 i+ J6 T) ~" B) n0 \
} & G, X7 o7 q7 x: a1 G/ s
catch(_com_error& e)  b' _& a8 O# Q; L: q' m5 J( c
      {) H. M3 t/ S5 {
// AfxMessageBox(e.ErrorMessage());- ]. K% B3 b1 ^' G  o
      }
0 ]0 {9 v3 w9 w/ |0 q0 z AfxMessageBox("删除成功！");
7 l1 b& m# _9 G7 p; K- y
' \0 n5 @" G8 w0 j7 Z+ c5 Y m_pRecordset->Close();& k) o' V0 J- g5 G2 `, S( \  u- V
}" b  A& I1 @) W" V3 E, P2 |. [
//删除成功后刷新记录显示
# ^/ ^  z7 i7 `//材料类型单选列表框
$ L5 q# P8 V: }$ \1 i item_data.item_id=MAO_MATERIAL;  [' i* N& g  |# L! P$ u
item_data.item_attr=UF_STYLER_LIST_DELETE; 3 I) K: a& m5 C% j" Q0 v
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
4 O7 O1 U; K/ X item_data.count=0; 3 u! f$ R1 |% X) x4 t. }
UF_STYLER_set_value(dialog_id, &item_data);# p5 W+ G9 K/ [
1 c# M5 Z4 w3 z) r" \
item_data.item_id=MAO_MATERIAL;; Y- W' M- k- a/ J& B( o
item_data.item_attr=UF_STYLER_LIST_INSERT;
, A2 ?0 P# O# @6 p4 z item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
) F2 j: c" j' T  [& j2 D, j5 D! `" Y( P8 e5 T
//零件类列表框% w% A* ^2 z. F5 S7 c
item_data1.item_id=MAO_PART;
5 D3 }5 t8 l3 y6 G$ h2 J% p item_data1.item_attr=UF_STYLER_LIST_DELETE;
+ i+ q* }  G% Q  w. g9 r) W4 K item_data1.subitem_index=UF_STYLER_NO_SUB_INDEX;
" H+ y8 j) y' U item_data1.count=0;
$ c) w: f* [6 N4 a# A( l UF_STYLER_set_value(dialog_id, &item_data1);# x" O* N+ p- R+ y; y# O

/ `3 R" b% b0 H3 U! B8 P if(m_DBCnt->State)# T0 V2 e- \% l
{
, N3 Y' Z( s3 ]% \2 b& L       m_pRecordset.CreateInstance(__uuidof(Recordset));
2 u% M4 @6 b2 I; i. M& [ try
5 W7 I( Q; r$ o; i2 b; }" F& o    {4 l6 n4 g1 n( }* F8 R( l8 R6 ]
m_pRecordset->Open("SELECT Distinct MATERIAL FROM MATERIAL_INFO",
. R- L. H. ^! X5 O/ X( d  {0 I             m_DBCnt.GetInterfacePtr(),. H. C8 D3 y, _4 u
            adOpenDynamic,& V3 \# {$ r* [% Y! ^
            adLockOptimistic,) v  o* w  Z1 M' U6 K
            adCmdText);
* n3 v8 M' ?# [% W/ ]' x try
" s4 H2 c& l! i; N) ]+ s/ x {
+ Q) T" c# b, s8 a: v1 C- e, J' o while(!m_pRecordset->adoEOF)0 w8 @/ i7 n, @7 L" ^0 H
{( W1 F) E; N4 V
if(!m_pRecordset->adoEOF)
1 r+ r5 O$ e( `, h0 \3 N% q$ b var=m_pRecordset->GetCollect("MATERIAL");
+ P4 I1 B; |! N if(var.vt != VT_NULL), V) c, _. R8 c% ~: @, u
{6 e. v& N9 D4 f! _; k3 C9 C
str=(LPCSTR)_bstr_t(var);# O! o' y6 H+ M+ j4 h1 a3 N
item_data.value.string=str.GetBuffer(str.GetLength());
( n4 |9 j+ n9 X; t' h4 V item_data.indicator=UF_STYLER_STRING_VALUE;
* Q$ G. \: y4 n( [! F/ k, } UF_STYLER_set_value(dialog_id, &item_data);  O5 a1 f, G: E
}
1 a4 ^' I. d" z% Q; M5 N5 Y! I if(!m_pRecordset->adoEOF)
  N- G' R& y4 |# {7 ^$ _ m_pRecordset->MoveNext();* I" i& J& P# Q0 M
}# X: V2 a" v8 M8 b4 R; _
m_pRecordset->Close();) `& [+ l- y0 e0 s
}; I6 h# C( W6 X
catch(_com_error *e), r0 @  L) A6 e% z; A: V: |
{% u6 r" f7 B. I# u
            AfxMessageBox(e->ErrorMessage());
! [9 v  P' W7 h/ E. R2 ~ }/ k# u$ U& j) R$ i
}6 t" g3 F9 [: R8 s% n. F
catch(_com_error *e)
9 M. X8 F0 w& k( X4 Z* b* p { # W/ q  x: |. G7 S5 i+ I6 b
            AfxMessageBox(e->ErrorMessage());
0 o, \+ |% r  S/ o; P6 R4 j1 ^ }
& p1 }# K6 B7 R* V }! R, ~5 g! R3 B# b* V4 Y6 [
//锁定按钮
& z: {7 ~2 V2 `* N' _6 O item_data.item_id=MAO_BTN;
5 p4 x9 p- w# W item_data.item_attr=UF_STYLER_SENSITIVITY;5 M% K) {) K( T8 q. g7 J, o7 f4 ?
item_data.subitem_index=1;4 D% S# \* L1 q/ x
item_data.value.integer=FALSE;
8 k" i& G( f% L/ o$ g, F9 u3 I: C UF_STYLER_set_value(dialog_id, &item_data);* n% O  q+ |- H$ M& A9 v6 g, D' C# Q
+ u: i3 x8 D5 t2 j1 U3 \1 ]
item_data.item_id=MAO_BTN;9 \( C! \" h% I# U) D% d) U
item_data.item_attr=UF_STYLER_SENSITIVITY;# L- d1 v' D* T  a7 g* M
item_data.subitem_index=2;
" n4 X, w8 ^6 o; `& v item_data.value.integer=FALSE;
/ W' g6 J6 {2 X3 X$ m- @7 M UF_STYLER_set_value(dialog_id, &item_data);' T: i2 P9 h- s4 Q0 @8 o
- t; m6 t% o% H0 F0 B7 ~& m3 F) H2 Y) d
}
. Q! r# Q. O* l4 U3 x. t7 a }
% M  Z8 O" C8 A% l1 |' o- M' d% H, K, b& }% j
//帮助信息
4 Y3 C4 Q; z" y* N4 u' s( i- |1 ~ if(BtnNdx==3)
6 Y4 O  t) \& [8 b* S {
  s  f" M! B7 M3 h8 n char nc_env[100]="",hlp_path[100]="";  Y$ _# g8 w, Q! T
strcpy(nc_env,getenv("UGII_USER_DIR"));
- x3 ?1 U, [+ D  x) P. C strcpy(hlp_path,nc_env);( E/ f" O% X4 \& Z! L
strcat(nc_env,"\\Help\\iexplore.exe");
$ W& U& z: ~% Y2 o" M2 M6 f strcat(hlp_path,"\\Help\\MaterialInfo.htm");
/ P0 s: D( Q% ^% o; B
2 M7 I/ _6 [. h8 l( |; S spawnl(1,nc_env,nc_env,hlp_path,NULL);# A: X& ]7 w% G. A# F& a8 |
}
% t1 R. _8 E& z) E4 n  I: d# E# [* |8 k% ]* A
//退出# ~% T" ?$ A* P- e% m6 L! N
if(BtnNdx==4)9 G  R& D7 q+ {2 \3 Y: `
{3 \7 h) t$ s' U1 j
return ( UF_UI_CB_EXIT_DIALOG );
& \, F. d6 u( k5 @1 V6 M }  |! s' ~1 O' k6 e" ~  ]

. Q' a- \6 ]+ {. O//IID,MATERIAL,NAME,BRAND,GB_CODE,NOTE;( \, K* @* J# Z6 {8 }
//MAT_NAME,MAT_PARTNAME,MAT_NO,MAT_STD_NO1,MAT_NOTE: i* s# C* }/ m4 e# `! a, }
//按钮:添加,保存,删除,帮助,退出
! W. V) k  O. E/ Y& ^    UF_terminate ();9 F+ `* O; r. G5 H
# o& |) {  C$ z# _4 J% a# I" ^
/* Callback acknowledged, do not terminate dialog */
- b9 o3 P, o5 g0 H  t4 e return (UF_UI_CB_CONTINUE_DIALOG); 6 t3 k) D) l2 P1 b; Y
2 `, D# {2 ^1 Z6 F" A
/* or Callback acknowledged, terminate dialog. */; E0 c7 b* q* |6 B6 p, U
/* return ( UF_UI_CB_EXIT_DIALOG );             */
" R' [; D7 l$ @5 s5 W6 f# b. z: G5 s- v' l
}, }7 g  x; X2 X3 S- r( \
8 F1 H; w2 y0 }4 X2 T
  Z) v# f5 b1 E- N3 D+ _: @4 n7 o

		自动登录	找回密码
密码			注册

[疑难] 二次开发：数据库连接