开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 查看源码
ReduceEquip.cpp
资源名称：Equipment.rar　[点击查看]
上传用户：latoyin
上传日期：2017-10-19
资源大小：2882k
文件大小：8k
源码类别：

数据库系统

开发平台：

Visual C++

ReduceEquip.cpp：源码内容
  1. // ReduceEquip.cpp : implementation file
  2. //
  4. #include "stdafx.h"
  5. #include "Equipment.h"
  6. #include "ReduceEquip.h"
  7. #include "NumberEdit.h"
  8. #ifdef _DEBUG
  9. #define new DEBUG_NEW
  10. #undef THIS_FILE
  11. static char THIS_FILE[] = __FILE__;
  12. #endif
  13. extern CEquipmentApp theApp;
  14. /////////////////////////////////////////////////////////////////////////////
  15. // CReduceEquip dialog
  18. CReduceEquip::CReduceEquip(CWnd* pParent /*=NULL*/)
  19. : CDialog(CReduceEquip::IDD, pParent)
  20. {
  21. m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINTITLE);
  22. }
  25. void CReduceEquip::DoDataExchange(CDataExchange* pDX)
  26. {
  27. CDialog::DoDataExchange(pDX);
  28. //{{AFX_DATA_MAP(CReduceEquip)
  29. DDX_Control(pDX, IDC_ID, equipid);
  30. DDX_Control(pDX, IDC_REDUCEMODE, reducemode);
  31. DDX_Control(pDX, IDC_QUERYCONDITION, querycondition);
  32. DDX_Control(pDX, IDC_QUERY, query);
  33. DDX_Control(pDX, IDC_NAME, clearname);
  34. DDX_Control(pDX, IDC_CLERAERNING, clearearning);
  35. DDX_Control(pDX, IDC_CLEARREASON, clearreason);
  36. DDX_Control(pDX, IDC_CLEARECHARGE, clearcharge);
  37. DDX_Control(pDX, IDC_CLEARDATE, cleardate);
  38. DDX_Control(pDX, IDC_LIST1, list);
  39. //}}AFX_DATA_MAP
  40. }
  43. BEGIN_MESSAGE_MAP(CReduceEquip, CDialog)
  44. //{{AFX_MSG_MAP(CReduceEquip)
  45. ON_COMMAND(ID_BUTTONREFRESH, OnButtonrefresh)
  46. ON_BN_CLICKED(IDC_QUERY, OnQuery)
  47. ON_NOTIFY(NM_CLICK, IDC_LIST1, OnClickList1)
  48. ON_COMMAND(ID_BUTTONDELETE, OnButtondelete)
  49. ON_COMMAND(ID_BUTTONCLOSE, OnButtonclose)
  50. //}}AFX_MSG_MAP
  51. END_MESSAGE_MAP()
  53. /////////////////////////////////////////////////////////////////////////////
  54. // CReduceEquip message handlers
  56. void CReduceEquip::OnOK() 
  57. {
  58. // TODO: Add extra validation here
  61. }
  63. void CReduceEquip::OnCancel() 
  64. {
  65. // TODO: Add extra cleanup here
  67. CDialog::OnCancel();
  68. }
  70. BOOL CReduceEquip::OnInitDialog() 
  71. {
  72. CDialog::OnInitDialog();
  73. SetIcon(m_hIcon,true);
  74. toolbar.Create(TBSTYLE_FLAT|CCS_TOP|WS_CHILD|WS_VISIBLE|WS_BORDER|CCS_ADJUSTABLE|TBSTYLE_WRAPABLE,CRect(0,0,0,0),this,IDR_TOOLBAR2);
  75. toolbar.SetBitmapSize(CSize(32,32));
  76. imagelist.Create(32,32,ILC_COLOR32|ILC_MASK,0,0);
  77. for (int n =0;n<5;n++)
  78. {
  79. imagelist.Add(theApp.LoadIcon(n+IDI_ICON1));
  80. }
  81. toolbar.SetImageList(&imagelist);
  82. TBBUTTON  buttons[4];
  83. for (int i =0; i<4;i++)
  84. {
  85. CString str;
  86. int strlength;
  87. CCHAR *temp;
  88. if (i<1)
  89. buttons[i].fsStyle =TBSTYLE_SEP;
  90. else
  91. {
  92. buttons[i].fsStyle =TBSTYLE_BUTTON;
  93. }
  94. buttons[i].fsState =TBSTATE_ENABLED;
  95. buttons[i].dwData =0;
  96. if ((i ==2)|(i==3))
  97. {
  98. buttons[i].idCommand = ID_BUTTONADD+i+1;
  99. buttons[i].iBitmap = i+1;
  100. str.LoadString(ID_BUTTONADD+i+1);
  101. }
  102. else
  103. {
  104. buttons[i].idCommand = ID_BUTTONADD+i+1;
  105. buttons[i].iBitmap = i+1;
  106. str.LoadString(IDS_redusemange);//第一个按钮为分隔条
  107. }
  108. strlength = str.GetLength()+1;
  109. temp = str.GetBufferSetLength(strlength);
  110. temp[strlength]= '';
  111. temp[strlength-1]= '';
  112. buttons[i].iString = toolbar.AddStrings(temp);
  113. str.ReleaseBuffer();
  114. }
  115. toolbar.AutoSize();
  116. toolbar.AddButtons(4,buttons);
  117. toolbar.ShowWindow(SW_SHOW);
  118. list.SetExtendedStyle(LVS_REPORT|LVS_EX_FULLROWSELECT|LVS_OWNERDRAWFIXED |LVS_EX_FLATSB|LVS_SHOWSELALWAYS|LVS_EX_HEADERDRAGDROP);
  119. list.InsertColumn(100,"资产编号");
  120. list.InsertColumn(100,"资产名称");
  121. list.InsertColumn(100,"类别");
  122. list.InsertColumn(100,"增加方式");
  123. list.InsertColumn(100,"入账原值");
  124. list.InsertColumn(100,"累计折旧");
  125. for (i =0 ;i<6;i++)
  126. list.SetColumnWidth(i,100);
  127. OnButtonrefresh();
  128. return TRUE;  // return TRUE unless you set the focus to a control
  129.               // EXCEPTION: OCX Property Pages should return FALSE
  130. }
  132. void CReduceEquip::AddEquipName()
  133. {
  134. _RecordsetPtr temp;
  135. temp =theApp.datamanage->Record1; 
  136. temp->raw_Close();
  137. temp->Open("select distinct name from tb_equipmentinfo where enabled = 0",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
  138. querycondition.ResetContent();
  139. while (!temp->ADOEOF)
  140. {
  141. CString str;
  142. str = temp->GetFields()->GetItem("name")->Value.bstrVal;
  143. querycondition.AddString(str);
  144. temp->MoveNext();
  145. }
  146. }
  148. void CReduceEquip::AddReduceMode()
  149. {
  150. _RecordsetPtr temp;
  151. temp =theApp.datamanage->Record1; 
  152. temp->raw_Close();
  153. temp->Open("select decreasekinds from tb_decreasekinds",theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
  154. reducemode.ResetContent();
  155. while (!temp->ADOEOF)
  156. {
  157. CString str;
  158. str = temp->GetFields()->GetItem("decreasekinds")->Value.bstrVal;
  159. reducemode.AddString(str);
  160. temp->MoveNext();
  161. }
  162. }
  164. void CReduceEquip::ClearText()
  165. {
  166. CWnd * temp;
  167. temp = this;
  168. for (int i= 0;i<8;i++)
  169. {
  170. temp = this->GetNextDlgTabItem(temp);
  171. temp->SetWindowText("");
  172. }
  173. //设置日期
  174. CTime t=CTime::GetCurrentTime();
  175. cleardate.SetTime(&t);
  176. list.DeleteAllItems();
  177. }
  179. bool CReduceEquip::InfoIsNull()
  180. {
  181. CWnd * temp;
  182. temp = this;
  183. for (int i= 2;i<8;i++)
  184. {
  185. temp = this->GetNextDlgTabItem(temp);
  186. CString str;
  187. temp->GetWindowText(str);
  188. if (str.IsEmpty())
  189. {
  190. return true;
  191. }
  192. }
  193. return false;
  194. }
  196. void CReduceEquip::OnButtonrefresh() 
  197. {
  198. AddEquipName();
  199. AddReduceMode();
  200. ClearText();
  202. }
  204. void CReduceEquip::OnQuery() 
  205. {
  206. CString str;
  207. querycondition.GetWindowText(str);
  208. if(!str.IsEmpty())
  209. {
  210. _RecordsetPtr temp;
  211. list.DeleteAllItems();
  212. temp =theApp.datamanage->Record1; 
  213. temp->raw_Close();
  214. CString sql;
  215. sql.Format("select * from tb_equipmentinfo where name = '%s' and enabled = 0 ",str);
  216. temp->Open((_bstr_t)sql,theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockPessimistic,adCmdText);
  217. if (temp->RecordCount>0)
  218. {
  219. int row = 0;
  220. while (!temp->ADOEOF)
  221. {
  222. list.InsertItem(row,"",0);
  223. for (int i= 0;i<6;i++)
  224. {
  225. CString str;
  226. _variant_t value;
  227. value = temp->GetFields()->GetItem((long)i)->Value;
  228. str = (TCHAR *)(_bstr_t)value;
  229. list.SetItemText(row,i,str);
  230. }
  231. row +=1;
  232. temp->MoveNext();
  233. }
  234. }
  235. else
  236. MessageBox("没有发现符合条件的数据","提示",64);
  237. }
  238. else
  239. MessageBox("请设置查询条件","提示",64);
  240. }
  242. void CReduceEquip::OnClickList1(NMHDR* pNMHDR, LRESULT* pResult) 
  243. {
  244. int row = list.GetSelectionMark();
  245. CString str;
  246. if (row !=-1)
  247. {
  248. str =list.GetItemText(row,0);
  249. equipid.SetWindowText(str);
  250. str =list.GetItemText(row,1);
  251. clearname.SetWindowText(str);
  252. }
  253. else
  254. {
  255. equipid.SetWindowText("");
  256. clearname.SetWindowText("");
  257. }
  258. *pResult = 0;
  259. }
  261. void CReduceEquip::OnButtondelete() 
  262. {
  263. if (!InfoIsNull())
  264. {
  265. try
  266. {
  267. theApp.datamanage->GetConn()->BeginTrans();//开始一个事务
  268. CString sql,str;
  269. equipid.GetWindowText(str);
  270. sql.Format("update tb_equipmentinfo set enabled = 1 where equipmentid = '%s'",str);
  271. theApp.datamanage->Record1->raw_Close();
  272. theApp.datamanage->Record1->Open((_variant_t)sql,theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
  273. CString c_id,c_mode,c_earning, c_charge,c_reason,c_date;
  274. equipid.GetWindowText(c_id);
  275. reducemode.GetWindowText(c_mode);
  276. clearearning.GetWindowText(c_earning);
  277. clearcharge.GetWindowText(c_charge);
  278. clearreason.GetWindowText(c_reason);
  279. cleardate.GetWindowText(c_date);
  280. float earning,charge;
  281. earning = atof(c_earning);
  282. charge = atof(c_charge);
  283. sql.Format("insert into tb_equipmentdecrease values ('%s','%s',%f,%f,'%s','%s')",c_id,c_mode,earning,charge,c_reason,c_date);
  284. theApp.datamanage->Record1->raw_Close();
  285. theApp.datamanage->Record1->Open((_variant_t)sql,theApp.datamanage->GetConn().GetInterfacePtr(),adOpenKeyset,adLockOptimistic,adCmdText);
  287. theApp.datamanage->GetConn()->CommitTrans();//提交事务
  288. MessageBox("操作成功.","提示",64);
  289. }
  290. catch(_com_error)
  291. {
  292. theApp.datamanage->GetConn()->RollbackTrans();//出现异常,回滚事务
  293. MessageBox("系统出错.","提示",64);
  294. }
  295. OnButtonrefresh();
  296. }
  297. else
  298. {
  299. MessageBox("基础信息不能为空.","提示",64);
  300. }
  301. }
  303. BOOL CReduceEquip::PreTranslateMessage(MSG* pMsg) 
  304. {
  305. if (pMsg->message ==WM_KEYDOWN)
  306. if (pMsg->wParam ==13)
  307. pMsg->wParam = 9;
  308. return CDialog::PreTranslateMessage(pMsg);
  309. }
  311. void CReduceEquip::OnButtonclose() 
  312. {
  313. EndDialog(0);
  314. }