二次开发：数据库连接

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!='*')1 A  ]2 y3 Y5 c) ~
{6 b6 L# }. |' f* |
name1=name;6 ^* e/ \( l8 i
i++;
2 ~2 q( S+ q/ P$ e8 p }6 g+ E9 q+ U" ]# B
name1='\0';
) A4 ~# k) p  j* o$ A* R" p! Y( J, ~1 `8 z' E' w, x
for(k=i+5;k<j;k++)  M4 Y% S  w- n. Z; L
{
. j1 v. j' L# _; U) @/ F name2[m]=name[k];
" q5 k0 {+ y3 k0 K9 c m++;  F7 X& p" g$ b2 I# i
}
% y" y5 ], i9 u name2[m]='\0';3 v2 b+ q0 [% Q6 B) q
//name1: 材料类型名称；name2: 零件名称
0 |/ v2 ^, h# ]; p1 ~$ T3 u7 j: a( s( J+ ?5 u" w9 V. Y- u

. o  }8 f5 I1 c+ _//显示零件名称7 ~% p! P0 a8 Z. N- w
item_data.item_id=MAO_PARTNAME;- h, f- V( E' L$ k- H% Z
item_data.item_attr=UF_STYLER_VALUE;0 V4 V+ o+ }/ J$ V! K; w
item_data.value.integer=TRUE;
4 R7 A; {0 k0 \+ o/ | item_data.count=1;
0 V6 e" r2 j; J' T9 j# l; ^ item_data.value.string=name1;
/ s2 _# b7 ^) P+ s3 D$ F" n: G UF_STYLER_set_value(dialog_id, &item_data);
* q, y. h9 J' m9 t0 I% q  G0 j; e8 w
//显示零件材料牌号3 L, ?- C4 k4 Y" N& u1 C9 i# [
item_data.item_id=MAO_NO;
" v* F; w# \& Y5 D item_data.item_attr=UF_STYLER_VALUE;7 H5 z" G5 _8 R, L
item_data.value.integer=TRUE;
% C* p% I6 v- V, G$ ~  H item_data.count=1;- o! N8 ?% {8 ]) \' V
item_data.value.string=name2;
0 I- [* w' d5 v' I9 }) R UF_STYLER_set_value(dialog_id, &item_data);6 W1 C6 `/ N2 u+ ^5 ]) ?% P( O

4 T+ x5 c1 s5 w7 n# k str_tmp3=name1;. @2 b2 C7 P6 f- h0 @5 M6 D( J
str_tmp4=name2;2 b5 f9 O( t: m# |- `8 \! r

2 M# Z- t7 _3 }. q1 Q _variant_t var1;
7 L; v# n3 w; ~0 D CString str,str1,str2;
& l0 a: w; K6 O. I0 e7 T/ T; m3 c
; ^) A; F: w; f: n str="SELECT * FROM MATERIAL_INFO WHERE NAME=\'";: C1 H4 X2 C4 l5 U
str=str+name1;
" a4 T. ]4 C% s/ n str=str+"\' and BRAND=\'";
* D$ E0 F+ b* u' J& `# g str=str+name2;
* i! T: V% {1 A, d0 c- t; d6 |( q str=str+"\'";
/ [" J" G7 j: ~  M) g9 u& D. y
$ ~0 U3 N) J* \+ \4 K2 U if(m_DBCnt->State)& X0 \) V+ w9 m
{
( g* e$ j/ |" s+ n! X! f! y! k          m_pRecordset.CreateInstance(__uuidof(Recordset));
, b. U* f2 x) d# p          try
" W! r9 A* z3 c) P {: ]: g8 P5 D4 _
m_pRecordset->Open(str.GetBuffer(str.GetLength()),       0 r9 Q, P+ D# Q+ C: v
            m_DBCnt.GetInterfacePtr(),
1 l' n! v. x" B/ d) B$ }# Q             adOpenDynamic,) U9 V0 D4 x7 _" P8 L6 ]$ U
            adLockOptimistic,1 J3 N, \* a  n8 H
            adCmdText);# s# `" g3 ?- L- ]6 r, a  I

* |' X/ H7 ^0 _    if(!m_pRecordset->adoEOF)
& f7 ^9 D( k4 h3 L( F. ~ var1=m_pRecordset->GetCollect("IID");4 {/ ?9 `% a$ L% G/ Z
   if(var1.vt != VT_NULL)# y5 t: N- s- n: T2 C" [
str1=(LPCSTR)_bstr_t(var1);/ e2 T0 N+ w" m* z% C4 [
   else0 I6 B! Q( S) _. v( F; |4 q5 e
   str1="";
) S' h* x0 h; r. b+ \1 W  a- l    str_tmp1=str1;
8 t: }% y3 R* C9 j7 |; u8 p6 f/ z& ~/ i- Y, `- c5 {5 X2 i; e* R4 I
   if(!m_pRecordset->adoEOF) * }! h/ O9 F, n- W6 b4 {
var1=m_pRecordset->GetCollect("GB_CODE");
3 }5 d, |' g" V' r6 M; g  F+ [    if(var1.vt != VT_NULL)- D5 @1 L) r+ [' r5 q
str1=(LPCSTR)_bstr_t(var1);
" ]! U2 V  e  q7 T- @/ K/ ?    else
. @2 R+ y0 S4 g# R    str1="";2 c4 ?0 t8 j, t
   if(!m_pRecordset->adoEOF)% {2 B0 o- F) W# Y0 z
var1=m_pRecordset->GetCollect("NOTE");
& k% k. c* g% A7 `' F    if(var1.vt != VT_NULL)
  _3 M0 }) M+ I8 j# [ str2=(LPCSTR)_bstr_t(var1);
3 t" R; g9 R1 Y    else
# X: V0 g& }, ?% Z6 q4 ?- x  @5 ?, r    str2="";
/ \5 d, u6 @$ H" H% @ }8 V- v) |0 |" [. P
catch(_com_error *e)
' O2 }: X" R8 R" t8 @! }5 n {
, I) d9 M4 r8 {. x" z    AfxMessageBox(e->ErrorMessage());
; R: z) K/ A' s* G }6 \+ a" p% x- b! U0 O) W
m_pRecordset->Close();" I3 E$ n( s3 Z1 c/ h
}: y, C4 d5 F, u4 s7 x3 Z* F
' r, p- U% F7 @0 J4 s% n( r2 K  n
//显示国标代号+ ?! ]8 |+ `# N, o: R: Q
//显示备注
. a- J& c$ U1 H8 ^8 F item_data.item_id=MAO_STD_NO1;5 `! ~. f+ Z9 Y' s  g
item_data.item_attr=UF_STYLER_VALUE;# Q1 {  {: x$ ^. _$ t) ^
item_data.value.integer=TRUE;9 e( {9 a0 j& u
item_data.count=1;. z8 ^/ @" b; H& _" ~( c5 M2 g# F
item_data.value.string=str1.GetBuffer(str1.GetLength());; `9 t- B9 ~" O2 q& X$ \, x+ P( H6 H
UF_STYLER_set_value(dialog_id, &item_data);# y6 q1 M5 c; o2 q
+ v% `) \; `3 w$ T4 }
item_data.item_id=MAO_NOTE;+ T1 V0 Q$ P! c$ v$ s& j/ q0 p% h
item_data.item_attr=UF_STYLER_VALUE;& X) q6 |; n% J) V0 B! A; g
item_data.value.integer=TRUE;
" i+ ^* b: c" T: C; U" l/ G" n item_data.count=1;# ^0 {5 M2 S: v2 m3 F
item_data.value.string=str2.GetBuffer(str2.GetLength());2 R& W0 l- q) N( C
UF_STYLER_set_value(dialog_id, &item_data);
, y: M# D0 @8 P- P( N) h# D
" n  E7 I/ H2 R str_tmp5=str1;6 W6 F8 a; q: k7 E! S2 t
str_tmp6=str2;
% M$ Z$ M  M- @* p+ o4 V7 X5 y0 b" i, V
   UF_terminate ();! S- ?' E1 _7 r1 b- c8 Y( Q0 Y8 x

) _9 D$ \' P2 z! n( C0 N7 R /* Callback acknowledged, do not terminate dialog *// J" i6 o, j& f
return (UF_UI_CB_CONTINUE_DIALOG); 2 y" A4 ~6 n4 T& s
# A* u: [. ?4 B# l+ R: k8 B/ X
/* or Callback acknowledged, terminate dialog. */
. W: Q) e2 g9 c1 n$ u0 g$ F /* return ( UF_UI_CB_EXIT_DIALOG );             */5 `% G( Y) d, F0 {; k5 K

8 d0 h8 q1 x% b! e  y6 w}
1 ]% U2 _" Q# o
( {0 ~4 x: d" Y, R! d' b. N. e0 W3 p' N
/*------------------------------------------------------------*/+ T$ m+ @! k: n- w+ \) i+ q  g* ~; V1 t
int MAO_btn_cb ( int dialog_id,
5 P5 u) w8 i: V# J  W          void * client_data,$ ~7 f3 M; z$ n' ]  _0 ]
         UF_STYLER_item_value_type_p_t callback_data)3 I7 o( I0 |4 `2 F# u  V2 b
{" {- s( C  H! k6 g4 b
UF_STYLER_item_value_type_t item_data,item_data1;" X" P: `6 e5 I* O0 e. v
   /* Make sure User Function is available. */  / [  W" o# Q- q% D, }2 y- t
   if ( UF_initialize() != 0) 7 z3 C! N) k/ s2 |' r0 ?
      return ( UF_UI_CB_CONTINUE_DIALOG );
8 p; X4 R3 F9 R; }5 x* t
& c" Q/ H1 W+ H5 \5 A3 g/ H    /* ---- Enter your callback code here ----- */
3 ?1 J, a! x; v; K1 Y5 @  i, c1 G, F( G# @7 R0 Q
_variant_t var;
* g, b2 j9 L/ d2 { CString str,str0;! F3 i/ U& e4 B$ s8 \

% P5 \) v3 Y$ n5 j//获取按钮的索引值6 _) C; t' d2 r' u, G; p
int BtnNdx;
% v' w4 X+ M, `% W+ F8 Q item_data.item_attr=UF_STYLER_VALUE; % r( x1 F" D- l0 b5 A  B, J/ ^
item_data.item_id=MAO_BTN;
& b- I/ `0 \# J% \$ l3 I item_data.indicator=UF_STYLER_INTEGER_VALUE;
/ p1 e' A& U# O6 b/ o1 K" V UF_STYLER_ask_value(dialog_id, &item_data);
1 U/ {8 m4 a$ p7 U BtnNdx=item_data.value.integer;
6 u2 r7 ^( Q) _5 G2 A5 ^0 C2 G
2 }! t! |8 `) g2 k' z//添加新材料
) w( u' ]) F% @4 P( [3 _* T if(BtnNdx==0)% x, w! w# h( O# x/ d/ x0 S
{
9 @. G  m& f* D/ ?. j. J$ } add_mark=1;- c8 P# ]3 r. K" s, z" T4 `" _0 Z
( L1 z2 `: {* p8 v! y
//点击添加后,清空输入框中的内容' U) d# e2 M9 r; W* I
item_data.item_id=MAO_PARTNAME; //零件类名称
! B3 C2 ^7 Y# `6 M% j item_data.item_attr=UF_STYLER_VALUE;
6 X' ^! g9 t" ]' g item_data.value.integer=FALSE;
3 e1 J: h. U' f) b; F6 Z8 Q UF_STYLER_set_value(dialog_id, &item_data);
" z8 x+ \6 N( w$ R item_data.value.integer=TRUE;
$ Q# @0 S& H9 B" q UF_STYLER_set_value(dialog_id, &item_data);2 Z' t! D# W  v( p/ e
" }4 q, I6 F/ y$ f/ x
item_data.item_id=MAO_NO; //零件牌号
  m# @7 ?. E. I' f- @ item_data.item_attr=UF_STYLER_VALUE;
- V. v2 T+ t% U; R  `& D. Y item_data.value.integer=FALSE;! @5 x4 Y, ?6 `3 z) `2 k
UF_STYLER_set_value(dialog_id, &item_data);
; V. p9 g# n# {# s) o. ^1 z  }7 Q item_data.value.integer=TRUE;
' y4 f$ ~+ t2 Y, D/ J5 p# D0 Z+ ^7 `. ?
item_data.item_id=MAO_STD_NO1; //标准代号
4 N2 a/ a$ X7 k3 W* R& _ item_data.item_attr=UF_STYLER_VALUE;
9 K8 Y; X5 }, v3 A5 G0 e; N0 d, c item_data.value.integer=FALSE;
2 k1 e) j$ G2 M2 K& _ UF_STYLER_set_value(dialog_id, &item_data);, p; X; M1 K9 a! [& O( |" ]3 g, u
item_data.value.integer=TRUE;! \6 r% X$ l. Z  m- G
% D+ Z$ K8 h" q# t. l, L2 w
item_data.item_id=MAO_NOTE; //备注
4 |6 e2 y* b7 f8 S item_data.item_attr=UF_STYLER_VALUE;- j0 i1 v* G* }( S2 g
item_data.value.integer=FALSE;7 L- `6 Q) _+ r5 V  [: Y8 c
UF_STYLER_set_value(dialog_id, &item_data);) a: P, {0 I7 w1 Y/ u/ M: U) q
item_data.value.integer=TRUE;
5 F6 P) ^8 X. v: n$ U5 ~4 Q9 p3 ^ }' j- C( g3 L2 }# S7 ~3 l
% @+ C/ n0 s5 j4 c/ z
//保存修改后的信息
2 D& P' }1 V' ~+ g8 k1 q! E! ^5 Z if(BtnNdx==1)% h$ S6 |8 {7 V& H
{
4 Z/ |( M, O0 |9 I$ ^5 N char temp1[80]="",temp2[80]="",temp3[80]="";+ O) ?& D, Y/ Z3 |" W4 a5 b; A
char temp4[40]="",temp5[200]="";
& C1 ^# r0 h# W( x( u- n6 W* _8 U! J) ?, c/ v5 z% c
//获取当前输入框中的信息5 ]: T: T  f& ^
item_data.item_id=MAO_NAME;
$ `, A6 ^9 \# Q# A. s item_data.item_attr=UF_STYLER_VALUE; / x4 S9 ]3 k, k# e& C" ?. {
      item_data.indicator=UF_STYLER_STRING_VALUE;
: Z  H- n  X9 o- d" z       UF_STYLER_ask_value(dialog_id, &item_data); 9 t9 ]( k0 j; }3 o+ I0 V% t
      strcpy(temp1,item_data.value.string);% ]" w! O: l8 j# X$ y1 f9 d8 \

3 H- F$ C6 e5 d item_data.item_id=MAO_PARTNAME;
1 @4 u& b4 A# v$ d item_data.item_attr=UF_STYLER_VALUE;
, S4 p* H" `$ W1 G( l! z$ V% `       item_data.indicator=UF_STYLER_STRING_VALUE; ' D8 @! a1 A! u% c1 v# s5 a+ G
      UF_STYLER_ask_value(dialog_id, &item_data); 9 @6 \* ^" p- ^0 H- l* z
      strcpy(temp2,item_data.value.string);
6 n; s! d2 m4 m/ |' m7 Q
  g# h3 K1 ^: E: U& V7 j item_data.item_id=MAO_NO;8 Q/ V, l$ V6 E8 v8 n9 \1 M" H
item_data.item_attr=UF_STYLER_VALUE; 8 B9 W1 ]; c) |' x# M
      item_data.indicator=UF_STYLER_STRING_VALUE;
) I0 `: U6 l. {2 T* C       UF_STYLER_ask_value(dialog_id, &item_data);
4 a; r4 m  H6 G) ~       strcpy(temp3,item_data.value.string);: z; _! `' Y. b

6 C3 v' _- l, g item_data.item_id=MAO_STD_NO1;# x2 y4 ~$ W- E  Y8 U7 n. u  H) `. K
item_data.item_attr=UF_STYLER_VALUE;
% W% s4 X3 E( f" z- @       item_data.indicator=UF_STYLER_STRING_VALUE;
: |3 n$ Z* }9 {9 A7 _( n$ ~- B       UF_STYLER_ask_value(dialog_id, &item_data);
' r  l8 S0 g4 q' f" q5 I% d       strcpy(temp4,item_data.value.string);% {3 c( c) n% A. G8 b9 `

* N* u8 d1 p2 {. i+ ? item_data.item_id=MAO_NOTE;$ Z& i7 k% t$ P3 }2 l, Q
item_data.item_attr=UF_STYLER_VALUE;
: ~# Y# L/ F3 U: |       item_data.indicator=UF_STYLER_STRING_VALUE; + q+ Z) L: T3 B. y1 _  Q3 P! R
      UF_STYLER_ask_value(dialog_id, &item_data); 5 S% g' T+ U# ^" o( R2 W2 s( I- w9 p5 {
      strcpy(temp5,item_data.value.string);! n; d+ F6 _) E# B

/ H. n5 I* w  f if (add_mark!=1)( G( [! Q& }/ D" k: |0 D4 c  I. h- U
{
% ?1 U/ j2 z+ ]2 q if((strcmp(str_tmp2,temp1)==0)&&(strcmp(str_tmp3,temp2)==0)&&
4 `9 W7 B( m  l. e5 @- d (strcmp(str_tmp4,temp3)==0)&&(strcmp(str_tmp5,temp4)==0)&&
' E; G6 ^' ~- {8 L+ n% x (strcmp(str_tmp6,temp5)==0))
( P! e7 s( [. _0 \1 G  @ {
3 i. s6 b. c8 x8 Z- j return (UF_UI_CB_CONTINUE_DIALOG);0 l; |# Q5 U4 A3 i$ X- m( }
}
/ Z3 A. I& u3 p) }6 ~( G else
9 z$ @  q; ]0 a& G6 L {. }; l3 u7 _( W; M; ]; d
int info;
# X2 s  H( ?" X1 t/ q info=MessageBox(NULL,"纪录已经改变，是否保存？","信息提示",MB_YESNO);) x; ]: L. [. q. ^$ a) ?! K
if(info==7). b7 |: p  B/ ^9 _4 B# r
return ( UF_UI_CB_CONTINUE_DIALOG );6 m8 W- V) o' f" _
//如果选择"是"，则保存修改后的信息
: }1 u9 E: x1 g 5 o' M: e) W7 R
if(temp1[0]==NULL)/ j& k3 v' W! C  l
{
0 |' u) `9 D% ` uc1601("材料类别不能为空!",1);
; j; L; l0 K5 {  k return (UF_UI_CB_CONTINUE_DIALOG);# r( u' Y' [6 E9 \
}; L8 c$ L/ q) a& j6 m8 X3 V

; Z) }; h; p. }1 r% U7 n str="SELECT NAME,BRAND FROM MATERIAL_INFO WHERE NAME=\'";! E% P' o+ u& u
str=str+str_tmp3;& B! D" K5 K# I8 }2 A
str=str+"\' and BRAND=\'";6 B5 ]2 w' b7 J  q" t
str=str+str_tmp3;+ c! `8 v' Z8 f( `# Q- ~1 t; E; \$ ~
str=str+"\'";
, C6 d5 n7 s) \5 a3 t5 l( z5 w
7 O' T! o; U$ j  e8 l if(m_DBCnt->State)
- Z7 W6 ?5 `1 a2 K$ n3 I {
: t9 Y7 O- s. b/ k0 o          m_pRecordset.CreateInstance(__uuidof(Recordset));' n! \. l6 {! U0 U5 v% k( q# g
         try" j. e& n3 `- B6 P* g% Z! N; C3 g  ?
{
$ O# Z5 J( O$ ~3 Q  ^9 q0 ? m_pRecordset->Open(str.GetBuffer(str.GetLength()),       6 j& C+ w8 }1 Q- O8 r
            m_DBCnt.GetInterfacePtr(),9 M2 T" q4 D4 ^
      adOpenDynamic,
! G& _4 t& n3 J+ ^, b& I/ V: B    adLockOptimistic,5 I6 w* u, D) g  W7 _6 Y
   adCmdText);0 a& p2 x6 Y* {* e; q3 X9 x
}
6 @1 T' C+ ^6 p* g5 e4 Z/ ] catch(_com_error *e). p8 G# G3 l- R1 ^9 i$ o
{& S* W7 e2 V2 }* c7 [
   AfxMessageBox(e->ErrorMessage());
& m/ r% @0 o/ W3 f8 v }
+ V1 {* y5 H  F1 M9 ]8 R// if(DbType=='2')
2 A" z0 X& O2 K% M% Q3 V* G {
/ p. s3 N$ z# \! j% N: U/ | str="DELETE FROM MATERIAL_INFO WHERE IID=";
4 Q0 E6 A7 }8 f str=str+str_tmp1;% T4 u8 ~" \8 o$ l+ i$ M$ o
try. M* z  E9 K% S0 R# E& p
{: k5 F& x6 E1 p5 {
m_DBCnt->Execute(str.GetBuffer(str.GetLength()),NULL,adCmdText);! o) ?; j( x0 `% Z1 D/ r- c
m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);4 X+ m' J: I) e
}. C2 I' I4 s3 j# {8 ]5 }
catch(_com_error& e)
+ R$ V8 C9 Y7 R* k2 Y* R3 q! e {0 M  n, g" B$ R: T, o
}5 U9 v$ }" M' H* w$ x4 d0 I
str="INSERT INTO MATERIAL_INFO VALUES(";
1 r# ]4 {9 H9 e7 J, G( n str=str+str_tmp1;
/ S  q% v5 Y" v  p: v# S( N str=str+",\'";$ F$ G8 P# l: z. S
str=str+temp1+"\',\'"+temp2+"\',\'"+temp3+"\',\'"+temp4+"\',\'"+temp5+"\')";
2 w4 }; @6 j& [7 ~: {8 _4 Z }# M; h9 A+ s: m( Z9 d' a7 u8 W( X4 R
try' g# b' L1 d9 O7 d, _# [* f6 H8 ~
{
+ G8 {: B9 z9 `! R' F m_DBCnt->Execute(str.GetBuffer(str.GetLength()),NULL,adCmdText);+ _% F' q1 W' |% c
m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);# K) T3 A: Z0 S% ^/ p
} ' ^# l; g/ w5 k
catch(_com_error &e)1 X1 i& E% E: R4 ~$ r
      {
7 x+ b2 l) X1 A5 g9 i6 W! s8 C // AfxMessageBox(e.ErrorMessage());1 x# o8 ]( B/ ?  [) u. ?
      }
0 K- f% p1 S) W: f* J* R. u) e3 N' L3 x/ b7 ~) [; @
AfxMessageBox("修改成功！");
4 J; e) R; u4 C; p! j }
$ x: P4 d' z3 O1 A6 K' A# A4 s( X3 K
if(m_DBCnt->State)
; d7 g1 a$ c6 t5 m {
; y5 K/ l* {! Y6 p    m_pRecordset.CreateInstance(__uuidof(Recordset));( o- J6 c8 q+ B0 G
      try9 V; w. `9 h# v9 \
{
5 R: h5 W2 d) d3 D+ ?7 G/ ]% p m_pRecordset->Open("SELECT * FROM MATERIAL_INFO ORDER BY IID ASC",! Z4 J7 ^$ w8 c- r1 @
            m_DBCnt.GetInterfacePtr(),; D5 W1 h) v& v4 ?4 o9 @
            adOpenDynamic,) Z( J5 }9 i6 g1 E% c& v- i  ^
            adLockOptimistic,
7 y9 l6 X2 z$ y# X8 n             adCmdText);; h- G9 g) A6 q0 K. X
}
  j0 o4 K' W4 K6 Q" M/ d9 _+ ?! A catch(_com_error *e)% B- s& c3 P9 |5 W  ]
{
9 S. U* x* i$ \- H# r; n    AfxMessageBox(e->ErrorMessage());
1 k% s0 L, h5 q }
% P: q3 @  ?2 `  F( ?' ] }% l. e% `, D8 b2 k0 F7 H. M6 k
}}! |8 f$ z8 t( F+ Q6 c
//点击过添加按钮，现在保存的是新添加的记录，保存完成后将添加标记add_mark=02 E/ g# H+ z1 M) i8 S/ g5 R! k
if (add_mark==1)
8 w& i3 @& y1 A/ o" [ {  i8 x: {. ]. R$ `/ \2 h) t
if(temp1[0]==NULL): {5 o6 c+ X# i
{
/ W+ J4 G$ O7 ~# W: W7 ^ uc1601("材料类别不能为空!",1);
$ v$ ^+ n; p% j1 K* I6 t return (UF_UI_CB_CONTINUE_DIALOG);
  {. H& F5 e2 B! ?& y) k }
* s* i4 R) \( L, X. d //确定当前表中的最大ID号: c% U- D+ A! z
//select MAX(IID) from MATERIAL_INFO
2 D% n% z2 I% ~ if(m_DBCnt->State)
' u: n2 G9 ~( X/ j8 H8 W' a, z {
5 z) A+ |6 E/ l9 ?4 r& ~  a5 D; R m_pRecordset.CreateInstance(__uuidof(Recordset));
5 @) Q7 t: z# b( ?9 F try# b4 Y) Q& R" U- Z( H2 A
{, M! w+ }1 P! k5 J/ U1 J/ f% c
m_pRecordset->Open("SELECT * FROM MATERIAL_INFO ORDER BY IID DESC",4 O* K# O9 y; J9 r" E- O
m_DBCnt.GetInterfacePtr(),, h) n$ ]( o; b( R( ]+ Y) M; Q
adOpenDynamic,# S: \  E3 G3 A3 G
adLockOptimistic,$ ?% n5 b; X; c' s  F+ T& m
adCmdText);3 I9 C+ }& P3 m5 |5 q! N0 B
}7 `% l) Z$ [2 `( w
catch(_com_error *e)6 `3 c+ l2 E6 _5 S; q
{
/ Y) w$ n# t6 N, j AfxMessageBox(e->ErrorMessage());5 |, [& H8 S3 ~6 ~  I! j
}# ?2 `8 k; J( M
}
4 _7 E" b1 d$ ] try
- k2 E- A# F. l1 Z) ?" V6 x4 Z {
' x" t% v5 h! D1 {# \: c* |  | if(!m_pRecordset->adoEOF)
% d9 {  A3 K; ] {9 K6 c0 t; k! x' ~) s4 V0 j) v8 ^
var = m_pRecordset->GetCollect("IID");
* b4 c; {( {1 P/ J if(var.vt != VT_NULL)- g$ N: H, u) c
str=(LPCSTR)_bstr_t(var);4 J3 [8 S4 [; l+ L
else: B. D# S3 B( Z' F* u
str="";
4 Q' s' f' C/ ~5 O& W }" A) \' a) x+ l$ f$ u1 d
}
6 h- h5 h& C& G- X catch(_com_error& e)9 R- V/ O2 Q  E" O' T6 ?6 W: H* ]
      {0 ^( X( j% {2 Y9 K: n8 S4 [
AfxMessageBox(e.ErrorMessage());" ^8 S, p: x6 e# R9 g+ d; H& d; q6 }
      }  `: A, Y. H- g. u1 u
6 N. T  v* g: |0 ~
str0="INSERT INTO MATERIAL_INFO VALUES(";
2 @: a4 ~9 H  K0 m  P, c str0=str0+str;  Q3 R$ ]7 L5 p
str0=str0+"+1,"; //在原有最大号上加1
. P3 P4 V* T9 L str0=str0+"\'";: @# m4 p$ i1 Y7 h: z
str0=str0+temp1;
) G! n+ S' C1 B" r str0=str0+"\',\'";( E7 G4 Q' r; t  q7 ^
str0=str0+temp2;
: X5 [' g5 L7 Y, Z* }* H6 P+ w str0=str0+"\',\'";
/ ^5 f( A+ p, d8 N3 N str0=str0+temp3;
3 l. t! e- q& g) o9 K* L- b2 q str0=str0+"\',\'";
  f& y& ~0 l# H+ M) Q str0=str0+temp4;
- e% j! ?% Y0 F1 r, m2 j# C str0=str0+"\',\'";
; }* ^, W9 b3 y3 p8 g2 ?1 c str0=str0+temp5;- p" |2 K+ x4 B+ j/ U
str0=str0+"\')";( I: C' @" c' C' d& i2 P) @& s6 E

' p  H9 I/ @4 [: H try5 I" A- p/ L6 o* Y
{# c8 q' f. }0 G! G
m_DBCnt->Execute(str0.GetBuffer(str0.GetLength()),NULL,adCmdText);8 q# f  J5 L" B/ H/ T/ o7 v. r
m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);
; H; j# t3 W" t6 U/ s9 x }
5 P% [& f' n( E) e0 b6 D! W7 d catch(_com_error& e)! [0 B4 ?4 u" P; q1 V' @; I; r
      {" i1 b8 x( H4 y: r" U
// AfxMessageBox(e.ErrorMessage());1 ^1 h3 P8 |0 x" M% j6 O( m. q
      }                6 A/ t7 X) ^, d, ~3 _
AfxMessageBox("新记录添加成功！");
) L( l: L6 z0 G3 K( ^5 H m_pRecordset->Close();
: [7 M4 W4 R! K( N
6 `5 U/ J( X0 F$ a3 | add_mark=0;7 A8 p0 M0 v1 O$ b
//添加或修改后的保存完成,并设置add_mark为"0",即未添加状态
; G* W5 Y' \. u, B& E' r; {6 `. ^5 K% p4 c
}
8 A- u! q0 y+ l  L, @$ ^/ U//下一步是刷新屏幕,将添加完后的信息重新显示在屏幕上
& d+ I" x7 ^! n1 m8 `//材料类型单选列表框4 t- Z( D$ D+ s0 q' U
item_data.item_id=MAO_MATERIAL;' s, R2 P/ ]6 i3 y& Z* B; v
item_data.item_attr=UF_STYLER_LIST_DELETE;
, H. x4 F. d$ ]/ @- J item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;3 h  y* e. B# H9 y6 I
item_data.count=0;
- N6 r3 K% O3 \. j) ]7 I. ^% J UF_STYLER_set_value(dialog_id, &item_data);  k$ t) e1 [& k$ D9 {( q# ^
! `5 |7 T4 ?9 s1 l% ~
item_data.item_id=MAO_MATERIAL;& u) j1 C" k8 E/ t4 v! r
item_data.item_attr=UF_STYLER_LIST_INSERT;
' b! ?4 C0 C  t; y; w item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
+ B7 t' t# j) Z7 ^8 W- Z0 @
" ^0 C' k( i8 y4 b8 d: X8 e" `//零件类列表框
0 A6 ]( q3 e8 g- N: c* T+ R4 _# B  b item_data1.item_id=MAO_PART;
, g1 Q: X/ d( R) ^+ i item_data1.item_attr=UF_STYLER_LIST_DELETE;
8 |; V2 d. f6 D! q8 _6 f item_data1.subitem_index=UF_STYLER_NO_SUB_INDEX;
; R2 h0 X% E; _7 }5 L item_data1.count=0;
, e( f  o. W7 ^. O+ c UF_STYLER_set_value(dialog_id, &item_data1);
" d0 I6 Z; p1 q8 {) a) o: |
; A. ]$ W6 r. l% f" H if(m_DBCnt->State)
' J$ `8 F( ~' P& g" O, T/ h {
' p$ C7 L9 M; D2 H) x       m_pRecordset.CreateInstance(__uuidof(Recordset));
1 S" `+ g  f* e8 u  E$ ~ try
$ G+ c! c* W2 M5 {4 t, f; R( l    {
# Z! M: V" T6 o! _; {, Q2 J5 _0 M m_pRecordset->Open("SELECT Distinct MATERIAL FROM MATERIAL_INFO",
2 ]+ r" ^5 R3 s  b5 Z# r2 X9 _             m_DBCnt.GetInterfacePtr(),
: p) X4 t- Z5 g% N; P4 @- ^             adOpenDynamic,
7 k2 N9 U5 i( v1 d  s8 I6 t3 F             adLockOptimistic,
  B" N3 d- ^& H- V: ^             adCmdText);
5 w# N2 x" a! A! n8 ^4 k try4 G! G( Z% }9 m+ H" ^& H& b& r1 r
{
- @+ g: n+ v! z8 V; c  C' B while(!m_pRecordset->adoEOF)1 z9 ?7 u" u; u/ `7 L* H1 ]
{
) U4 E% M- G4 x% z: U) [) V3 \7 O9 K if(!m_pRecordset->adoEOF)
% \. b6 f7 s0 ]0 h2 Q: t var=m_pRecordset->GetCollect("MATTYPE");
: g# A& Z$ p$ `1 } if(var.vt != VT_NULL)$ f  }( G+ H  a1 |, H) [
{
5 N  L) [3 L3 t& Y2 V3 q str=(LPCSTR)_bstr_t(var);$ h: E/ b- s6 g4 q2 M1 M
item_data.value.string=str.GetBuffer(str.GetLength());
9 J! x. U- Y* N/ ~5 s( { item_data.indicator=UF_STYLER_STRING_VALUE;
6 D* W$ E5 [) c1 |4 e UF_STYLER_set_value(dialog_id, &item_data);
" i+ Z! _* L3 K" R' u) K7 y }
/ }' G0 _) L2 O8 I( H2 B' T if(!m_pRecordset->adoEOF)! v( d$ D5 `- A. q; m, U
m_pRecordset->MoveNext();
! c# M/ x; X* s) } }
  G) ^) {/ I+ \9 S9 A( g m_pRecordset->Close();
# O9 @! P" s% Z" V }5 J9 I' A) o9 z. b  p1 f
catch(_com_error *e)
! q9 |4 Q  u, i {
, Y4 f9 w9 b1 G7 y& b& X" n             AfxMessageBox(e->ErrorMessage());
* {2 r( V- |# ? }' }( }* X7 c* l  o9 W
}
3 y- A+ f' f1 z$ }1 e2 u# I- S* C catch(_com_error *e)
: d0 g9 H6 H* g  E {
6 a8 z9 a7 K8 s% |) J* v             AfxMessageBox(e->ErrorMessage());
4 g) t# [& n- L6 B# }5 m' ?, n: ^ }* l) o" G* _4 U$ a- d
}
9 k: J1 y& }% _2 y& {//锁定按钮6 G. h0 Q; K( b+ P! ^# C% t% z% m
item_data.item_id=MAO_BTN;
% l+ c- }8 B8 \. d! y( Z item_data.item_attr=UF_STYLER_SENSITIVITY;
' u1 E7 q; r% J item_data.subitem_index=1;
$ n( U. b: W7 R9 O4 k# B3 W item_data.value.integer=FALSE;7 t: b" y/ V; Y# Z0 \
UF_STYLER_set_value(dialog_id, &item_data);6 B1 K3 m2 ]: n& C" X
) U! H) a( x  D/ s
item_data.item_id=MAO_BTN;
# T" x- R2 Q( o. m- O- D% n" v item_data.item_attr=UF_STYLER_SENSITIVITY;
9 c6 ]% j3 }9 I item_data.subitem_index=2;' F/ V9 x8 ]0 b' |0 v0 X7 V6 L
item_data.value.integer=FALSE;
  g/ }% W; L3 S2 x: w: U% h; r% ] UF_STYLER_set_value(dialog_id, &item_data);
, K5 I* @6 t  h: ]  y5 z1 V" j6 v
}- D/ p; t, F$ Y- n
& g" f5 }; Q  x
//删除材料信息$ m( q: D" H! b! T! f
if(BtnNdx==2)
$ t6 m' H3 i* _" M7 Q$ I, ] {
. U" h9 z3 n5 F+ Y% T str="DELETE FROM MATERIAL_INFO WHERE IID=";
( D1 `  ~# A5 c2 Y! O% m% _ str0="SELECT * FROM MATERIAL_INFO WHERE IID=";! ?+ R" i) n" a- ~$ ~6 F+ ~
str=str+str_tmp1;# d, ~  H; v" V% W0 a4 n/ O
str0=str0+str_tmp1;$ `5 ^; v% f; g8 ^% f$ A
7 g, g; |- Y8 u
int info=-1;
5 |) H2 O9 W  K0 I/ k$ C% P info=MessageBox(NULL,"您确实要删除选中的纪录吗？","信息提示",MB_YESNO);
0 l2 B. r0 l  e% ~7 \  C7 S if(info==7) //选择"否"
2 P, B* p4 w3 y$ P+ I7 r {$ c* A, p- R( ~8 P9 v5 d; o$ w7 e
return ( UF_UI_CB_CONTINUE_DIALOG );
; c' D9 q. f8 l }( `8 w; J  l' D3 H
else- _5 {, O9 q( a( S
{5 N( c' W2 y0 ]' x
if(m_DBCnt->State)
# t9 _) [' K* d( ~/ l* K. U {2 a4 C6 W: C7 c1 l( R
         m_pRecordset.CreateInstance(__uuidof(Recordset));$ F" n( t' w' R9 Z/ b# U1 P8 B: D
         try# P; r8 s1 L* M; g  E
{
4 G9 G% _: a" h: N1 X$ G m_pRecordset->Open(str0.GetBuffer(str0.GetLength()),
3 M% X) Q& V9 z& Q$ q) _# E! o4 q             m_DBCnt.GetInterfacePtr(),
! F/ |4 e$ T. d! C             adOpenDynamic,3 V  g/ O( j4 c% x  V- a6 ~# b
   adLockOptimistic,2 D- J, X$ }9 a% u
            adCmdText);
: h. L) O  F  c+ T8 {' o( k }
8 z! E' j+ V# ~$ ~# f; f( r/ s catch(_com_error *e)
( T& y" K- r7 I9 B3 t9 O+ G  G6 b {5 O% s1 S" L0 l4 D7 m+ C
//    AfxMessageBox(e->ErrorMessage());" w; _$ ?% h: S, u3 O) c
}1 Q, c  ~% P+ e: j+ j" P5 ~8 e
try
: |3 E% |" X4 d( p) k" u) w {
. U/ J/ ~8 x+ E4 G2 _7 r. a; I/ T m_DBCnt->Execute(str.GetBuffer(str.GetLength()),NULL,adCmdText);4 p1 Q; O3 R5 l4 Y
m_DBCnt->Execute(L"COMMIT",NULL,adCmdText);1 \3 i, T) O' {* w/ b
} 2 g) B! T0 t3 @
catch(_com_error& e)" F* r6 B( E5 D- d" g
      {) L, p! }7 l, I: B  `2 O" I( e2 i
// AfxMessageBox(e.ErrorMessage());
, A& X, u( a0 b3 O, u       }                " s0 b$ O' K1 r
AfxMessageBox("删除成功！");' l& O" Y( ~0 b& n8 M

! N- I! H. R, ]7 x' l m_pRecordset->Close();
$ j8 F, h, o+ s) m! h; {" ` }2 W. N% i8 e  |8 a- C
//删除成功后刷新记录显示
. W1 ~/ e  ?! b9 f//材料类型单选列表框+ W) x0 b  W, W# M  w; u: G
item_data.item_id=MAO_MATERIAL;
" T3 {* u3 |$ H! T2 c8 C) C+ m+ J item_data.item_attr=UF_STYLER_LIST_DELETE; . o( m  |. n; N4 F% e
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
+ }. I! A1 V5 g item_data.count=0;
: [2 R8 V8 }2 d1 [+ o9 Y UF_STYLER_set_value(dialog_id, &item_data);
8 p6 w! b' r. W
& C! @8 I9 a+ v+ d( c7 B+ R( f! k item_data.item_id=MAO_MATERIAL;! E4 d+ O- f( n8 b6 `' _
item_data.item_attr=UF_STYLER_LIST_INSERT;! m5 R( z! J- {9 g- l; i6 e
item_data.subitem_index=UF_STYLER_NO_SUB_INDEX;
. s" O6 Q# x0 ^3 i% x* Y: m& w# c* k* l( c
//零件类列表框+ S0 @8 z/ p: c+ g3 A* `2 W* V( |3 n
item_data1.item_id=MAO_PART;3 h) U8 L( l& }) Q" M% H+ x
item_data1.item_attr=UF_STYLER_LIST_DELETE;
) s% X3 _$ n9 [, t# D$ d" u item_data1.subitem_index=UF_STYLER_NO_SUB_INDEX;2 M8 `0 O! N- i+ V
item_data1.count=0;
  }: Y) j: n: j2 N8 U* s( R UF_STYLER_set_value(dialog_id, &item_data1);2 D3 ~! x' V8 z" }3 Q+ Y
1 c  m( c% R; A
if(m_DBCnt->State)* n% j, O6 e5 P3 h3 r- f
{2 T6 h7 n' N1 I
      m_pRecordset.CreateInstance(__uuidof(Recordset));: V0 w  ^! i' ?7 n/ Y  R
try
. {  A7 E( E  w& u    {
* m7 t# Q! ~: g. t: ?. S$ l m_pRecordset->Open("SELECT Distinct MATERIAL FROM MATERIAL_INFO",       ) ?4 s  e) P5 A+ Y! b& u! K0 ?
            m_DBCnt.GetInterfacePtr(),2 N8 @0 r  P0 u! `# D' w* E
            adOpenDynamic,9 S8 E5 L/ C- F- \& n/ }& T5 s" o& E
            adLockOptimistic,' f# V; H4 W/ d# z/ W4 g
            adCmdText);* T" j3 U6 o9 f+ ?% T, ~  V3 [4 ?
try
5 M6 c8 N! a" ?8 | {             , _- E# C9 L3 P) w, H/ Z3 P) V
while(!m_pRecordset->adoEOF)
9 J, L+ v8 ?8 q9 |' d  m2 c% x3 ` {$ M# e: [" V3 T3 P8 B
if(!m_pRecordset->adoEOF)) i6 n1 F/ |- U0 y
var=m_pRecordset->GetCollect("MATERIAL");
4 l" h; h: X1 t  l' ^4 u if(var.vt != VT_NULL)
+ \/ [* ?9 ?3 R {
% d) t9 ~1 {8 H2 l( f, O5 O& z9 R str=(LPCSTR)_bstr_t(var);/ l& M4 b. V) n' |: a) \2 T+ D% k" b
item_data.value.string=str.GetBuffer(str.GetLength());
9 ]7 @$ h0 e7 j" l) l8 V2 z item_data.indicator=UF_STYLER_STRING_VALUE;+ @* m1 e! R6 y" ]* L& F
UF_STYLER_set_value(dialog_id, &item_data);- w; E5 E8 L5 e# E- ^. W
}8 q3 {% O# @) L$ o$ r: L
if(!m_pRecordset->adoEOF)
% F$ k/ B6 [. L. i6 l m_pRecordset->MoveNext();
$ t; P: P7 h, b. i8 P, U1 { }8 `3 n" [* b9 R$ ^  T4 _/ ?
m_pRecordset->Close();; j# {5 |2 K" m/ z* }
}
# P( E# D* S2 A1 v catch(_com_error *e)
0 @% }4 E- {- @+ X {
" }) Z2 [, F* S, }/ w$ W  A* Q             AfxMessageBox(e->ErrorMessage());' y0 r. ~7 e  a: `& v# y
}) z0 A7 A* a% c4 Y. I! s
}
& H/ `% T8 E' E# M catch(_com_error *e)! D$ [, r) q! Y- q$ }
{ ! Q; J. [& ?! E+ ^
            AfxMessageBox(e->ErrorMessage());
9 ]6 N( }$ I1 l. A }( ~5 t( U( |4 c5 a) X
}3 y& N. r9 |$ H% i5 e! E
//锁定按钮) H3 P: s3 R9 R# b. J% i
item_data.item_id=MAO_BTN;
" c; C; l, U  Q/ A6 w9 b item_data.item_attr=UF_STYLER_SENSITIVITY;
" t. i* f1 M5 B; p# j; I  C item_data.subitem_index=1;' T3 V$ R! ]/ ^9 \/ p' [
item_data.value.integer=FALSE;% V* C# D- `7 ~( ?0 W' O
UF_STYLER_set_value(dialog_id, &item_data);/ `& d9 B( D, v; K  {

% Z' A( h, x) X* t7 p2 ~. i3 N item_data.item_id=MAO_BTN;
2 ^9 E$ V& E$ u% t item_data.item_attr=UF_STYLER_SENSITIVITY;
# i7 S9 H. @" g7 \ item_data.subitem_index=2;
3 P) y" l  k+ g* j item_data.value.integer=FALSE;9 M, |" M* I! d( |6 L. z& T
UF_STYLER_set_value(dialog_id, &item_data);
! @% t; |4 J8 \0 Q8 M( Y, r1 O3 o* g# e% e
}
; ?- W# l& w, o4 T }
7 l, t9 E# |+ ]! ]) T" w: V2 b6 n  r$ r) z( h; W
//帮助信息$ I9 ^  D% f( a1 m  ^' d
if(BtnNdx==3)
( B3 M7 G- V' v {! n: A9 g4 T/ x
char nc_env[100]="",hlp_path[100]="";
0 H* t- w* f6 { strcpy(nc_env,getenv("UGII_USER_DIR"));
: N; f% ?8 Q2 y" d; l& t  W0 I strcpy(hlp_path,nc_env);
$ n" i! W3 W9 F: \ strcat(nc_env,"\\Help\\iexplore.exe");3 M2 _( Q" f0 j( s
strcat(hlp_path,"\\Help\\MaterialInfo.htm");, }& _4 M/ v$ U  w
  Z2 W3 s1 n! S' \! L/ H6 S
spawnl(1,nc_env,nc_env,hlp_path,NULL);
0 I, [. }( k! q }
# f0 G7 P7 d, \4 G. o" {, ~' c# w6 @" y
//退出
) g) ~( \5 b$ J1 m/ ^ if(BtnNdx==4)
: K4 P) _/ R0 C' F9 R {& p$ [0 b; N2 {
return ( UF_UI_CB_EXIT_DIALOG );
' m$ E# L' Z" F+ w. v }5 M0 I  q, y4 Z5 b
6 ~+ ^* j" z  v
//IID,MATERIAL,NAME,BRAND,GB_CODE,NOTE;
% @( e, F% m$ M* G  Q1 {' M//MAT_NAME,MAT_PARTNAME,MAT_NO,MAT_STD_NO1,MAT_NOTE5 L- }3 G4 C/ ^
//按钮:添加,保存,删除,帮助,退出
1 S- [% M7 n' O; l- R6 _    UF_terminate ();3 \( R: @( c/ P; _' K0 S
3 W$ \9 N$ T/ n
/* Callback acknowledged, do not terminate dialog */! j( g% o* Z( t; \
return (UF_UI_CB_CONTINUE_DIALOG); 1 F/ b% b* N0 ]$ q$ b

+ v" C; ?8 V# d' \ /* or Callback acknowledged, terminate dialog. */- T! A7 F+ L, M; O# g
/* return ( UF_UI_CB_EXIT_DIALOG );             */
9 M2 a8 p1 ?( N3 r+ h5 w' c6 J4 J% n! R. @& @) k" X2 e1 v7 a
}, L6 d- f7 E$ ^
7 h1 J9 g8 W, X; T
) E) F% Q6 s' O

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

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

浏览过的版块