/// <summary>
/// 新添记录
/// </summary>
/// <returns></returns>
private long m_lngAddNew()
{
long lngRes = 0;
DataRow[] drNew = m_objViewer.m_dtbDataSource.Select("status = 0");
if (drNew != null && drNew.Length > 0)
{
clsMS_GrossProfitRateSet_VO[] objNewArr = new clsMS_GrossProfitRateSet_VO[drNew.Length];
for (int iRow = 0; iRow < drNew.Length; iRow++)
{
objNewArr[iRow] = new clsMS_GrossProfitRateSet_VO();
objNewArr[iRow].m_dblGROSSPROFITRATE = Convert.ToDouble(drNew[iRow]["Rate"]);
objNewArr[iRow].m_strMEDICINETYPEID_CHR = drNew[iRow]["ID"].ToString();
}
lngRes = m_objDomain.m_lngAddGrossProfitRateSet(objNewArr);
if (lngRes > 0)
{
for (int iRow = 0; iRow < drNew.Length; iRow++)
{
drNew[iRow]["Status"] = 1;
}
}
}
return(lngRes);
}
public long m_lngGetGrossProfitRateSet(System.Security.Principal.IPrincipal p_objPrincipal, out clsMS_GrossProfitRateSet_VO[] p_objRateArr)
{
p_objRateArr = null;
long lngRes = 0;
try
{
string strSQL = @"select b.medicinetypeid_chr, b.medicinetypename_vchr, a.grossprofitrate
from t_aid_medicinetype b
left outer join t_ms_grossprofitrateset a on a.medicinetypeid_chr =
b.medicinetypeid_chr
order by b.medicinetypeid_chr";
clsHRPTableService objHRPServ = new clsHRPTableService();
DataTable dtbValue = null;
lngRes = objHRPServ.lngGetDataTableWithoutParameters(strSQL, ref dtbValue);
if (lngRes > 0 && dtbValue != null)
{
int intRowsCount = dtbValue.Rows.Count;
if (intRowsCount <= 0)
{
return(-1);
}
p_objRateArr = new clsMS_GrossProfitRateSet_VO[intRowsCount];
DataRow drCurrent = null;
for (int iRow = 0; iRow < intRowsCount; iRow++)
{
p_objRateArr[iRow] = new clsMS_GrossProfitRateSet_VO();
drCurrent = dtbValue.Rows[iRow];
p_objRateArr[iRow].m_strMEDICINETYPEID_CHR = drCurrent["medicinetypeid_chr"].ToString();
p_objRateArr[iRow].m_strMEDICINETYPENAME = drCurrent["medicinetypename_vchr"].ToString();
if (drCurrent["grossprofitrate"] != DBNull.Value)
{
p_objRateArr[iRow].m_dblGROSSPROFITRATE = Convert.ToDouble(drCurrent["grossprofitrate"]);
p_objRateArr[iRow].m_blnIsInGrossProfitRateSet = true;
}
else
{
p_objRateArr[iRow].m_dblGROSSPROFITRATE = 15.00d;
p_objRateArr[iRow].m_blnIsInGrossProfitRateSet = false;
}
}
}
}
catch (Exception objEx)
{
com.digitalwave.Utility.clsLogText objLogger = new com.digitalwave.Utility.clsLogText();
bool blnRes = objLogger.LogError(objEx);
}
return(lngRes);
}
/// <summary>
/// 保存毛利率设置
/// </summary>
internal void m_mthSaveGrossProfitRateSet()
{
if (m_objViewer == null)
{
return;
}
int intRowsCount = m_objViewer.m_dtbDataSource.Rows.Count;
long lngRes = m_lngAddNew();
DataRow[] drOld = m_objViewer.m_dtbDataSource.Select("status = 1");
List <DataRow> drModift = new List <DataRow>();
foreach (DataRow dr in drOld)
{
if (dr.RowState == DataRowState.Modified)
{
drModift.Add(dr);
}
}
if (drModift.Count > 0)
{
clsMS_GrossProfitRateSet_VO[] objModifyArr = new clsMS_GrossProfitRateSet_VO[drModift.Count];
for (int iRow = 0; iRow < drModift.Count; iRow++)
{
objModifyArr[iRow] = new clsMS_GrossProfitRateSet_VO();
objModifyArr[iRow].m_dblGROSSPROFITRATE = Convert.ToDouble(drModift[iRow]["Rate"]);
objModifyArr[iRow].m_strMEDICINETYPEID_CHR = drModift[iRow]["ID"].ToString();
}
lngRes = m_objDomain.m_lngModifyGrossProfitRateSet(objModifyArr);
if (lngRes > 0)
{
m_objViewer.m_dtbDataSource.AcceptChanges();
MessageBox.Show("保存成功", "毛利率设置", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("保存失败", "毛利率设置", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
