private void m_lsvMedicineStore_Click(object sender, EventArgs e)
{
if (m_strMedStoreArr == null)
{
if (m_lsvMedicineStore.SelectedItems.Count == 1)
{
foreach (ListViewItem lvi in m_lsvMedicineName.CheckedItems)
{
lvi.Checked = false;
}
m_objCurrentRoomInfo = m_lsvMedicineStore.SelectedItems[0].Tag as clsMS_MedicineStoreroom_VO;
m_txtMedicineStoreRoom.Text = m_objCurrentRoomInfo.m_strMedicineRoomName_VCHR;
m_txtDept.Text = m_objCurrentRoomInfo.m_strDEPTNAME_CHR;
m_txtDept.Tag = m_objCurrentRoomInfo.m_strDEPTID_CHR;
//2008.5.14 wuchongkun
m_txtMedStoreShortName.Text = m_objCurrentRoomInfo.m_strMidicineRommShortName_CHR;
((clsCtl_MedicineStoreroomSet)objController).m_mthSetMedicineTypeCheck(m_objCurrentRoomInfo.m_strMedicineRoomID_VCHR);
}
}
else
{
if (m_lsvMedicineStore.SelectedItems.Count == 1)
{
foreach (ListViewItem lvi in m_lsvMedicineName.CheckedItems)
{
lvi.Checked = false;
}
m_txtMedicineStoreRoom.Text = this.m_lsvMedicineStore.SelectedItems[0].SubItems[1].Text;
m_txtMedStoreShortName.Text = this.m_lsvMedicineStore.SelectedItems[0].SubItems[2].Text;
((clsCtl_MedicineStoreroomSet)objController).m_mthSetMedicineTypeCheck(this.m_lsvMedicineStore.SelectedItems[0].Text);
}
}
}
/// <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();
}
/// <summary>
/// 添加库存记录.
/// </summary>
/// <param name="p_objMedicineStoreArr">新增库房记录.</param>
/// <returns></returns>
internal long m_lngInsertMedicineStoreInfo(ref clsMS_MedicineStoreroom_VO p_objMedicineStore)
{
long lngRes = 0;
com.digitalwave.iCare.middletier.MedicineStoreService.clsMedicineStoreroomSetSVC objSvc =
(com.digitalwave.iCare.middletier.MedicineStoreService.clsMedicineStoreroomSetSVC)com.digitalwave.iCare.common.clsObjectGenerator.objCreatorObjectByType(typeof(com.digitalwave.iCare.middletier.MedicineStoreService.clsMedicineStoreroomSetSVC));
lngRes = objSvc.m_lngAddNewMedicineStoreInfo(objPrincipal, ref p_objMedicineStore);
return(lngRes);
}
private void m_cmdDelete_Click(object sender, EventArgs e)
{
if (this.m_strMedStoreArr == null)
{
if (m_lsvMedicineStore.SelectedItems.Count == 0)
{
MessageBox.Show("请选择要删除的记录.", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DialogResult drResult = MessageBox.Show("确定删除选定仓库设置？", "药品仓库设置", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (drResult == DialogResult.No)
{
return;
}
if (m_lsvMedicineStore.SelectedItems.Count == 1)
{
m_objCurrentRoomInfo = m_lsvMedicineStore.SelectedItems[0].Tag as clsMS_MedicineStoreroom_VO;
string strStoreID = m_objCurrentRoomInfo.m_strMedicineRoomID_VCHR;
((clsCtl_MedicineStoreroomSet)objController).m_mthDeleteMedicineRoomInfo(strStoreID);
m_lstMedicineRoomInfo.Remove(m_objCurrentRoomInfo);
m_lsvMedicineStore.Items.Remove(m_lsvMedicineStore.SelectedItems[0]);
m_lsvMedicineStore.Refresh();
}
}
else
{
if (m_lsvMedicineStore.SelectedItems.Count == 0)
{
MessageBox.Show("请选择要删除的记录.", "药房对应药品类型设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
DialogResult drResult = MessageBox.Show("确定删除选定药房设置？", "药房对应药品类型设置", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (drResult == DialogResult.No)
{
return;
}
if (m_lsvMedicineStore.SelectedItems.Count == 1)
{
string strStoreID = m_lsvMedicineStore.SelectedItems[0].Text;
((clsCtl_MedicineStoreroomSet)objController).m_mthDeleteMedStoreSetInfo(strStoreID, true);
m_lsvMedicineStore.Refresh();
}
}
}
public long m_lngGetMedicineStoreroomInfo(System.Security.Principal.IPrincipal p_objPrincipal, out clsMS_MedicineStoreroom_VO[] p_objMedicineStoreroomInfoArr)
{
p_objMedicineStoreroomInfoArr = null;
DataTable m_dtbMedicineStoreroom = null;
long lngRes = 0;
try
{
//+shortname 2008.5.14 wuchongkun
string strSQL = @"select distinct t.medicineroomid medicineroomid,
t.medicineroomname medicineroomname,
t.deptid_chr,t.shortname_chr,s.deptname_vchr
from t_ms_medicinestoreroomset t
left join t_bse_deptdesc s on s.deptid_chr = t.deptid_chr
order by t.medicineroomid";
clsHRPTableService objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref m_dtbMedicineStoreroom);
objHRPServ.Dispose();
objHRPServ = null;
int index = 0;
if (m_dtbMedicineStoreroom.Rows.Count > 0)
{
p_objMedicineStoreroomInfoArr = new clsMS_MedicineStoreroom_VO[m_dtbMedicineStoreroom.Rows.Count];
for (; index < m_dtbMedicineStoreroom.Rows.Count; index++)
{
p_objMedicineStoreroomInfoArr[index] = new clsMS_MedicineStoreroom_VO();
p_objMedicineStoreroomInfoArr[index].m_strMedicineRoomID_VCHR = m_dtbMedicineStoreroom.Rows[index]["medicineroomid"] as string;
p_objMedicineStoreroomInfoArr[index].m_strMedicineRoomName_VCHR = m_dtbMedicineStoreroom.Rows[index]["medicineroomname"] as string;
//+2008.5.14wuchongkun
p_objMedicineStoreroomInfoArr[index].m_strMidicineRommShortName_CHR = m_dtbMedicineStoreroom.Rows[index]["shortname_chr"] as string;
p_objMedicineStoreroomInfoArr[index].m_strMedicineTypeID_CHR = null;
p_objMedicineStoreroomInfoArr[index].m_strDEPTID_CHR = m_dtbMedicineStoreroom.Rows[index]["deptid_chr"] as string;
p_objMedicineStoreroomInfoArr[index].m_strDEPTNAME_CHR = m_dtbMedicineStoreroom.Rows[index]["deptname_vchr"] as string;
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <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 long m_lngGetMedicineStoreroomInfo(System.Security.Principal.IPrincipal p_objPrincipal, out clsMS_MedicineStoreroom_VO[] p_objMedicineStoreroomInfoArr)
{
p_objMedicineStoreroomInfoArr = null;
DataTable m_dtbMedicineStoreroom = null;
long lngRes = 0;
try
{
string strSQL = @"select distinct t.medicineroomid MedicineRoomID,
t.medicineroomname MedicineRoomName
from t_ms_medicinestoreroomset t
order by t.medicineroomid";
clsHRPTableService objHRPServ = new clsHRPTableService();
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref m_dtbMedicineStoreroom);
objHRPServ.Dispose();
objHRPServ = null;
int index = 0;
if (m_dtbMedicineStoreroom.Rows.Count > 0)
{
p_objMedicineStoreroomInfoArr = new clsMS_MedicineStoreroom_VO[m_dtbMedicineStoreroom.Rows.Count];
for (; index < m_dtbMedicineStoreroom.Rows.Count; index++)
{
p_objMedicineStoreroomInfoArr[index] = new clsMS_MedicineStoreroom_VO();
p_objMedicineStoreroomInfoArr[index].m_strMedicineRoomID_VCHR = m_dtbMedicineStoreroom.Rows[index]["MedicineRoomID"] as string;
p_objMedicineStoreroomInfoArr[index].m_strMedicineRoomName_VCHR = m_dtbMedicineStoreroom.Rows[index]["MedicineRoomName"] as string;
p_objMedicineStoreroomInfoArr[index].m_strMedicineTypeID_CHR = null;
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
private void m_cmdSave_Click(object sender, EventArgs e)
{
if (this.m_strMedStoreArr == null)
{
if (m_txtMedicineStoreRoom.Text.Length == 0 || m_txtMedicineStoreRoom.Text.Length >= 50)
{
MessageBox.Show("仓库名称不能为空,且长度小于50个字符.", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
m_txtMedicineStoreRoom.Focus();
return;
}
if (m_lsvMedicineName.CheckedItems.Count == 0)
{
MessageBox.Show("药品类型不能为空", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
m_lsvMedicineName.Focus();
return;
}
if (m_txtMedStoreShortName.Text.Trim().Replace(" ", "").Length != 3)
{
MessageBox.Show("仓库简码必须为三位字母。", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
m_txtMedStoreShortName.Focus();
return;
}
if (this.m_txtDept.Text.Trim() == string.Empty)
{
MessageBox.Show("必须绑定该药库对应的部门！", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.m_txtDept.Focus();
return;
}
string strStoreName = m_txtMedicineStoreRoom.Text;
string strStoreID;
if (!m_blnIsSave)
{
strStoreID = m_objCurrentRoomInfo.m_strMedicineRoomID_VCHR;
}
else
{
strStoreID = string.Empty;
}
//if (this.m_objCurrentRoomInfo == null)
//{
foreach (ListViewItem lvi in this.m_lsvMedicineStore.Items)
{
if (((clsMS_MedicineStoreroom_VO)lvi.Tag).m_strDEPTID_CHR == this.m_txtDept.StrItemId.Trim() && this.m_txtDept.StrItemId.Trim() != "" && ((clsMS_MedicineStoreroom_VO)lvi.Tag).m_strMedicineRoomID_VCHR != strStoreID)
{
MessageBox.Show(((clsMS_MedicineStoreroom_VO)lvi.Tag).m_strMedicineRoomName_VCHR + "已对应到该部门， 一个部门只能对应一个药房！", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.m_txtDept.Clear();
this.m_txtDept.Focus();
return;
}
if (((clsMS_MedicineStoreroom_VO)lvi.Tag).m_strMidicineRommShortName_CHR == this.m_txtMedStoreShortName.Text && ((clsMS_MedicineStoreroom_VO)lvi.Tag).m_strMedicineRoomID_VCHR != strStoreID)
{
MessageBox.Show("\"" + this.m_txtMedStoreShortName.Text + "\"已被使用，请使用其他简码！", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.m_txtMedStoreShortName.Clear();
this.m_txtMedStoreShortName.Focus();
return;
}
}
//}
//else
//{
// foreach (ListViewItem lvi in this.m_lsvMedicineStore.Items)
// {
// if (((clsMS_MedicineStoreroom_VO)lvi.Tag).m_strDEPTID_CHR.Trim() == this.m_txtDept.StrItemId.Trim() && this.m_txtDept.StrItemId.Trim() != this.m_objCurrentRoomInfo.m_strDEPTID_CHR && this.m_txtDept.StrItemId.Trim() != "")
// {
// MessageBox.Show(((clsMS_MedicineStoreroom_VO)lvi.Tag).m_strMedicineRoomName_VCHR + "已对应到该部门， 一个部门只能对应一个药房！", "药品仓库设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
// this.m_txtDept.Clear();
// this.m_txtDept.Focus();
// blnResult = false;
// }
// }
//}
int iMedicineCount = m_lsvMedicineName.CheckedItems.Count;
m_objCurrentRoomInfo = new clsMS_MedicineStoreroom_VO();
int i = 0;
m_objCurrentRoomInfo.m_strMedicineTypeID_CHR = new string[m_lsvMedicineName.CheckedItems.Count];
foreach (ListViewItem lvi in m_lsvMedicineName.CheckedItems)
{
m_objCurrentRoomInfo.m_strMedicineRoomID_VCHR = strStoreID;
m_objCurrentRoomInfo.m_strMedicineRoomName_VCHR = strStoreName;
if (m_blnIsSave)
{
m_objCurrentRoomInfo.m_strDEPTID_CHR = m_txtDept.StrItemId.Trim();
}
else
{
m_objCurrentRoomInfo.m_strDEPTID_CHR = m_txtDept.Tag.ToString();
}
m_objCurrentRoomInfo.m_strDEPTNAME_CHR = m_txtDept.Text;
//+2008.5.14吴崇坤
m_objCurrentRoomInfo.m_strMidicineRommShortName_CHR = m_txtMedStoreShortName.Text.Trim();
m_objCurrentRoomInfo.m_strMedicineTypeID_CHR[i] = lvi.Tag as string;
i++;
}
if (m_blnIsSave)
{
((clsCtl_MedicineStoreroomSet)objController).m_mthInsertMedicineRoomInfo(ref m_objCurrentRoomInfo);
m_lstMedicineRoomInfo.Add(m_objCurrentRoomInfo);
}
else
{
((clsCtl_MedicineStoreroomSet)objController).m_mthDeleteMedicineRoomInfo(strStoreID);
((clsCtl_MedicineStoreroomSet)objController).m_mthInsertMedicineRoomInfo(ref m_objCurrentRoomInfo);
m_lstMedicineRoomInfo.Remove(m_objCurrentRoomInfoForUpdate);
m_lstMedicineRoomInfo.Add(m_objCurrentRoomInfo);
m_blnIsSave = true;
}
m_mthInitlsvMedicineStore();
m_txtMedicineStoreRoom.Text = "";
//2008.5.14 wuchongkun
m_txtMedStoreShortName.Text = "";
m_txtDept.Clear();
ListView.CheckedListViewItemCollection lvcCollection = m_lsvMedicineName.CheckedItems;
if (lvcCollection.Count == 0)
{
return;
}
foreach (ListViewItem lvi in lvcCollection)
{
lvi.Checked = false;
}
}
else
{
if (m_txtMedicineStoreRoom.Text.Length == 0 || m_txtMedicineStoreRoom.Text.Length >= 50)
{
MessageBox.Show("药房名称不能为空,且长度必须小于50个字符.", "药房对应药品类型设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
if (m_lsvMedicineName.CheckedItems.Count == 0)
{
MessageBox.Show("药品类型不能为空", "药房对应药品类型设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
string strStoreName = m_txtMedicineStoreRoom.Text;
string strStoreID;
strStoreID = this.m_lsvMedicineStore.SelectedItems[0].Text;
int iMedicineCount = m_lsvMedicineName.CheckedItems.Count;
m_objCurrentRoomInfo = new clsMS_MedicineStoreroom_VO();
int i = 0;
m_objCurrentRoomInfo.m_strMedicineTypeID_CHR = new string[m_lsvMedicineName.CheckedItems.Count];
foreach (ListViewItem lvi in m_lsvMedicineName.CheckedItems)
{
m_objCurrentRoomInfo.m_strMedicineRoomID_VCHR = strStoreID;
m_objCurrentRoomInfo.m_strMedicineRoomName_VCHR = strStoreName;
m_objCurrentRoomInfo.m_strMedicineTypeID_CHR[i] = lvi.Tag as string;
i++;
}
if (m_blnIsSave)
{
((clsCtl_MedicineStoreroomSet)objController).m_mthInsertMedStoreSetInfo(ref m_objCurrentRoomInfo);
}
else
{
((clsCtl_MedicineStoreroomSet)objController).m_mthDeleteMedStoreSetInfo(strStoreID, false);
((clsCtl_MedicineStoreroomSet)objController).m_mthInsertMedStoreSetInfo(ref m_objCurrentRoomInfo);
m_blnIsSave = true;
}
m_txtMedicineStoreRoom.Text = "";
m_txtMedStoreShortName.Text = "";
m_txtDept.Clear();
ListView.CheckedListViewItemCollection lvcCollection = m_lsvMedicineName.CheckedItems;
if (lvcCollection.Count == 0)
{
return;
}
foreach (ListViewItem lvi in lvcCollection)
{
lvi.Checked = false;
}
}
}
public long m_lngAddNewMedicineStoreInfo(System.Security.Principal.IPrincipal p_objPrincipal, ref clsMS_MedicineStoreroom_VO p_objMedicineStoreroom)
{
if (p_objMedicineStoreroom == null)
{
return(-1);
}
long lngRes = 0;
try
{
string strGetMax = @"select max(medicineroomid) maxid from t_ms_medicinestoreroomset";
//2008.5.14 wuchongkun+shortname_chr
string strSQL = @"insert into t_ms_medicinestoreroomset
(medicineroomid, medicineroomname, medicinetypeid_chr,deptid_chr,shortname_chr)
values
(?, ?, ?,?,?)";
clsHRPTableService objHRPServ = new clsHRPTableService();
long lngEff = -1;
if (string.IsNullOrEmpty(p_objMedicineStoreroom.m_strMedicineRoomID_VCHR))
{
DataTable dtbValue = null;
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strGetMax, ref dtbValue);
if (dtbValue == null || dtbValue.Rows.Count == 0)
{
p_objMedicineStoreroom.m_strMedicineRoomID_VCHR = "0001";
}
else
{
if (dtbValue.Rows[0][0] == DBNull.Value)
{
p_objMedicineStoreroom.m_strMedicineRoomID_VCHR = "0001";
}
else
{
p_objMedicineStoreroom.m_strMedicineRoomID_VCHR = (Convert.ToInt32(dtbValue.Rows[0][0]) + 1).ToString("0000");
}
}
}
if (clsHRPTableService.bytDatabase_Selector != (byte)clsHRPTableService.enumDatabase_Selector.bytOracle)
{
IDataParameter[] objDPArr = null;
for (int i = 0; i < p_objMedicineStoreroom.m_strMedicineTypeID_CHR.Length; i++)
{
objHRPServ.CreateDatabaseParameter(5, out objDPArr);
objDPArr[0].Value = p_objMedicineStoreroom.m_strMedicineRoomID_VCHR;
objDPArr[1].Value = p_objMedicineStoreroom.m_strMedicineRoomName_VCHR;
objDPArr[2].Value = p_objMedicineStoreroom.m_strMedicineTypeID_CHR[i];
objDPArr[3].Value = p_objMedicineStoreroom.m_strDEPTID_CHR;
//+m_strMidicineRommShortName_chr 2008.5.14 wuchongkun
objDPArr[4].Value = p_objMedicineStoreroom.m_strMidicineRommShortName_CHR;
lngRes = objHRPServ.lngExecuteParameterSQL(strSQL, ref lngEff, objDPArr);
}
}
else
{
DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String, DbType.String, DbType.String };
object[][] objValues = new object[5][];
int intItemCount = p_objMedicineStoreroom.m_strMedicineTypeID_CHR.Length;
for (int j = 0; j < objValues.Length; j++)
{
objValues[j] = new object[intItemCount];//初始化
}
for (int i = 0; i < intItemCount; i++)
{
objValues[0][i] = p_objMedicineStoreroom.m_strMedicineRoomID_VCHR;
objValues[1][i] = p_objMedicineStoreroom.m_strMedicineRoomName_VCHR;
objValues[2][i] = p_objMedicineStoreroom.m_strMedicineTypeID_CHR[i];
objValues[3][i] = p_objMedicineStoreroom.m_strDEPTID_CHR;
//+ wuchongkun.2008.5.14
objValues[4][i] = p_objMedicineStoreroom.m_strMidicineRommShortName_CHR;
}
lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes);
}
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
public long m_lngAddNewMedStoreSetInfo(System.Security.Principal.IPrincipal p_objPrincipal, ref clsMS_MedicineStoreroom_VO p_objMedicineStoreroom)
{
if (p_objMedicineStoreroom == null)
{
return(-1);
}
long lngRes = 0;
try
{
string strSQL = @" insert into t_ds_medstoreset
(medstoreid, medstorename, medicinetypeid_chr)
values
(?, ?, ?)";
clsHRPTableService objHRPServ = new clsHRPTableService();
DbType[] dbTypes = new DbType[] { DbType.String, DbType.String, DbType.String };
object[][] objValues = new object[3][];
int intItemCount = p_objMedicineStoreroom.m_strMedicineTypeID_CHR.Length;
for (int j = 0; j < objValues.Length; j++)
{
objValues[j] = new object[intItemCount];//初始化
}
for (int i = 0; i < intItemCount; i++)
{
objValues[0][i] = p_objMedicineStoreroom.m_strMedicineRoomID_VCHR;
objValues[1][i] = p_objMedicineStoreroom.m_strMedicineRoomName_VCHR;
objValues[2][i] = p_objMedicineStoreroom.m_strMedicineTypeID_CHR[i];
}
lngRes = objHRPServ.m_lngSaveArrayWithParameters(strSQL, objValues, dbTypes);
objHRPServ.Dispose();
objHRPServ = null;
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 添加库存记录.
/// </summary>
/// <param name="p_objMedicineStore">新增库房记录.</param>
public void m_mthInsertMedicineRoomInfo(ref clsMS_MedicineStoreroom_VO p_objMedicineStore)
{
m_objDomain.m_lngInsertMedicineStoreInfo(ref p_objMedicineStore);
}
/// <summary>
/// 添加库存记录.
/// </summary>
/// <param name="p_objMedicineStore">新增库房记录.</param>
public void m_mthInsertMedStoreSetInfo(ref clsMS_MedicineStoreroom_VO p_objMedicineStore)
{
m_objDomain.m_lngAddNewMedStoreSetInfo(ref p_objMedicineStore);
}
