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);
}
