public long m_lngEditStoreInfo(clsMS_StorInfoVo m_Stor) { IDataParameter[] objDPArr = null; clsHRPTableService objHRPServ = new clsHRPTableService(); string strSQL = @"update t_ms_storagerackset set storagerackcode_vchr= ? , storageid_chr= ? , typeid_int= ? , storagerackname_vchr= ? , pycode_chr= ? , wbcode_chr= ? where storagerackid_chr = ?"; objHRPServ.CreateDatabaseParameter(7, out objDPArr); objDPArr[0].Value = m_Stor.m_storId; objDPArr[1].Value = m_Stor.m_ageID; objDPArr[2].Value = m_Stor.m_intTypeid; objDPArr[3].Value = m_Stor.m_storName; objDPArr[4].Value = m_Stor.m_pycode; objDPArr[5].Value = m_Stor.m_wbcode; objDPArr[6].Value = m_Stor.m_ID; long lngEff = -1; long lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); return(lngRes); }
/// <summary> /// 插入记录 /// </summary> public void m_mthInsert() { if (m_objDomain.m_lngFindId(this.m_objViewer.m_strStorageType, m_objViewer.m_txtStoragerackcode.Text.Trim())) { clsMS_StorInfoVo objVO = new clsMS_StorInfoVo(); clsMS_MedicineStoreroom_VO li = (clsMS_MedicineStoreroom_VO)m_objViewer.m_cboStorageid.SelectedItem; objVO.m_storId = m_objViewer.m_txtStoragerackcode.Text.Trim(); objVO.m_storName = m_objViewer.m_txtStoragerackname.Text.Trim(); objVO.m_ageID = li.m_strMedicineRoomID_VCHR; objVO.m_pycode = m_objViewer.m_txtPycode.Text.Trim(); objVO.m_wbcode = m_objViewer.m_txtWbcode.Text.Trim(); if (m_objViewer.m_strStorageType == "1") { objVO.m_intTypeid = 1; } else { objVO.m_intTypeid = 2; } m_objDomain.m_lngInsertStor(objVO); m_objViewer.m_btnNew.Enabled = true; MessageBox.Show("新建成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); m_newClick(); } else { MessageBox.Show("该货架编码已存在,请输入新的编码!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } this.m_mthGetStorInfo(); }
public long m_lngInsertStoreInfo(clsMS_StorInfoVo m_Stor) { IDataParameter[] objDPArr = null; clsHRPTableService objHRPServ = new clsHRPTableService(); string strSQL = @"insert into t_ms_storagerackset (storagerackid_chr, storagerackcode_vchr,storageid_chr ,typeid_int ,storagerackname_vchr, pycode_chr,wbcode_chr) values (?,?,?,?,?,?,?)"; objHRPServ.CreateDatabaseParameter(7, out objDPArr); objDPArr[0].Value = m_lngGetMaxId(); objDPArr[1].Value = m_Stor.m_storId; objDPArr[2].Value = m_Stor.m_ageID; objDPArr[3].Value = m_Stor.m_intTypeid; objDPArr[4].Value = m_Stor.m_storName; objDPArr[5].Value = m_Stor.m_pycode; objDPArr[6].Value = m_Stor.m_wbcode; long lngEff = -1; long lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr); return(lngRes); }
/// <summary> /// 列表的双击事件 /// </summary> public void m_mthVendorListDoubleClick() { if (m_objViewer.m_lsvMedicineTypeSet.SelectedItems.Count > 0) { clsMS_StorInfoVo objItem = (clsMS_StorInfoVo)m_objViewer.m_lsvMedicineTypeSet.SelectedItems[0].Tag; m_objViewer.m_txtStoragerackcode.Text = objItem.m_storId; strStorId = objItem.m_storId; m_objViewer.m_txtStoragerackname.Text = objItem.m_storName; m_objViewer.m_cboStorageid.Text = objItem.m_ageName; m_objViewer.m_txtPycode.Text = objItem.m_pycode; m_objViewer.m_txtWbcode.Text = objItem.m_wbcode; m_objViewer.m_btnNew.Enabled = true; } }
/// <summary> /// 删除记录 /// </summary> public void m_mthDel() { if (m_objViewer.m_lsvMedicineTypeSet.SelectedItems.Count == 0) { System.Windows.Forms.MessageBox.Show("请先选择要删除的作废原因", "作废原因设置", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Warning); return; } DialogResult result = MessageBox.Show("确定要删除当前记录吗?", "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { clsMS_StorInfoVo objItem = (clsMS_StorInfoVo)m_objViewer.m_lsvMedicineTypeSet.SelectedItems[0].Tag; m_objDomain.m_lngDelStore(objItem.m_ID); m_objViewer.m_btnNew.Enabled = true; MessageBox.Show("删除成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.m_mthGetStorInfo(); } }
/// <summary> /// 修改记录 /// </summary> public long m_mthEdit() { if (m_objViewer.m_lsvMedicineTypeSet.SelectedItems.Count <= 0) { DialogResult result = MessageBox.Show("当前没有选定记录!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(0); } clsMS_StorInfoVo objVO = new clsMS_StorInfoVo(); clsMS_MedicineStoreroom_VO li = (clsMS_MedicineStoreroom_VO)m_objViewer.m_cboStorageid.SelectedItem; clsMS_StorInfoVo objItem = (clsMS_StorInfoVo)m_objViewer.m_lsvMedicineTypeSet.SelectedItems[0].Tag; if (strStorId != m_objViewer.m_txtStoragerackcode.Text.Trim()) { if (m_objDomain.m_lngFindId(this.m_objViewer.m_strStorageType, m_objViewer.m_txtStoragerackcode.Text.Trim()) == false) { MessageBox.Show("该货架编码已存在,请输入新的编码!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(0); } } objVO.m_ID = objItem.m_ID; objVO.m_storId = m_objViewer.m_txtStoragerackcode.Text.Trim(); objVO.m_storName = m_objViewer.m_txtStoragerackname.Text.Trim(); objVO.m_ageID = li.m_strMedicineRoomID_VCHR; objVO.m_pycode = m_objViewer.m_txtPycode.Text.Trim(); objVO.m_wbcode = m_objViewer.m_txtWbcode.Text.Trim(); if (m_objViewer.m_strStorageType == "1") { objVO.m_intTypeid = 1; } else { objVO.m_intTypeid = 2; } m_objDomain.m_lngEditStor(objVO); m_objViewer.m_btnNew.Enabled = true; MessageBox.Show("修改成功!", "系统提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.m_mthGetStorInfo(); return(1); }
public void m_lngGetStor(string m_strType, out clsMS_StorInfoVo[] objSto_Vo) { DataTable m_dtb = new DataTable(); objSto_Vo = null; try { string strSql = @"select distinct a.storagerackid_chr, a.storagerackcode_vchr, a.storageid_chr, a.typeid_int, a.storagerackname_vchr, a.pycode_chr, a.wbcode_chr, b.medicineroomname from t_ms_storagerackset a, t_ms_medicinestoreroomset b where a.storageid_chr = b.medicineroomid and a.typeid_int = ? order by a.storagerackid_chr"; if (m_strType == "2") { strSql = @" select distinct a.storagerackid_chr, a.storagerackcode_vchr, a.storageid_chr, a.typeid_int, a.storagerackname_vchr, a.pycode_chr, a.wbcode_chr, b.medstorename_vchr as medicineroomname from t_ms_storagerackset a, t_bse_medstore b where a.storageid_chr = b.medstoreid_chr and a.typeid_int = ? order by a.storagerackid_chr"; } clsHRPTableService objHRPServ = new clsHRPTableService(); System.Data.IDataParameter[] DataParas = null; objHRPServ.CreateDatabaseParameter(1, out DataParas); DataParas[0].Value = m_strType; objHRPServ.lngGetDataTableWithParameters(strSql, ref m_dtb, DataParas); objSto_Vo = new clsMS_StorInfoVo[m_dtb.Rows.Count]; for (int i = 0; i < m_dtb.Rows.Count; i++) { objSto_Vo[i] = new clsMS_StorInfoVo(); objSto_Vo[i].m_ID = m_dtb.Rows[i]["storagerackid_chr"].ToString(); objSto_Vo[i].m_storId = m_dtb.Rows[i]["storagerackcode_vchr"].ToString(); objSto_Vo[i].m_ageID = m_dtb.Rows[i]["storageid_chr"].ToString(); objSto_Vo[i].m_intTypeid = Convert.ToInt32(m_dtb.Rows[i]["typeid_int"]); objSto_Vo[i].m_storName = m_dtb.Rows[i]["storagerackname_vchr"].ToString(); objSto_Vo[i].m_pycode = m_dtb.Rows[i]["pycode_chr"].ToString(); objSto_Vo[i].m_wbcode = m_dtb.Rows[i]["wbcode_chr"].ToString(); objSto_Vo[i].m_ageName = m_dtb.Rows[i]["medicineroomname"].ToString(); } } catch (Exception objEx) { com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText(); bool blnRes = objLogger.LogError(objEx); } }
/// <summary> /// 修改记录 /// </summary> /// <param name="objSto_Vo"></param> internal void m_lngEditStor(clsMS_StorInfoVo objSto_Vo) { com.digitalwave.iCare.middletier.MedicineStoreService.clsStorageRacksetSVC objSvc = (com.digitalwave.iCare.middletier.MedicineStoreService.clsStorageRacksetSVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.MedicineStoreService.clsStorageRacksetSVC)); objSvc.m_lngEditStoreInfo(objSto_Vo); }