/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int Delete(PowerLevelClass3 info)
{
string strSql = "";
if (this.Sql.GetSql("Manager.PowerLevelClass3ManagerImpl.DeletePowerLevelClass3", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.Class2Code, info.Class3Code);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
try
{
return(this.ExecNoQuery(strSql));
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
}
/// <summary>
///
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int UpdatePowerLevelClass3(PowerLevelClass3 info)
{
string strSql = "";
if (this.Sql.GetSql("Manager.PowerLevelClass3ManagerImpl.UpdatePowerLevelClass3", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.Class2Code, info.Class3Code, info.Class3Name, info.Class3MeaningCode, info.Class3MeaningName, info.FinFlag, info.DelFlag, info.GrantFlag, info.Class3JoinCode, info.JoinGroupCode, info.JoinGroupOrder, info.CheckFlag, info.Memo, this.Operator.ID);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
try
{
return(this.ExecNoQuery(strSql));
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(-1);
}
}
/// <summary>
/// 根据二级权限编码，取所有三级权限信息
/// </summary>
/// <returns></returns>
public ArrayList LoadLevel3ByLevel2(string class2)
{
ArrayList levels = new ArrayList();
//取sql语句
string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel3ByLevel2", class2);
if (sqlstring == string.Empty)
{
return(levels);
}
try {
//执行sql语句，取数据
this.ExecQuery(sqlstring);
PowerLevelClass3 level3 = null;
while (this.Reader.Read())
{
level3 = PrepareLevel3Data();
levels.Add(level3);
}
this.Reader.Close();
}
catch (Exception ex) {
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(null);
}
return(levels);
}
/// <summary>
/// 根据一级权限编码，取所有2、3级权限信息
/// </summary>
/// <returns></returns>
public ArrayList LoadLevel3ByLevel1(string class1)
{
ArrayList levels = new ArrayList();
//取sql语句
string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel3ByLevel1", class1);
if (sqlstring == string.Empty)
{
return(levels);
}
try {
//执行sql语句，取数据
this.ExecQuery(sqlstring);
PowerLevelClass3 level3 = null;
while (this.Reader.Read())
{
// PowerLevelClass3 level3 = new PowerLevelClass3();
// level3.Class2Code = this.Reader[0].ToString();
// level3.Class3Code = this.Reader[1].ToString();
// level3.Class3Name = this.Reader[2].ToString();
// level3.Class3MeaningCode = this.Reader[3].ToString();
// level3.Class3MeaningName = this.Reader[4].ToString();
// level3.FinFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[5].ToString());
// level3.DelFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString());
// level3.GrantFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[7].ToString());
// level3.Class3JoinCode = this.Reader[8].ToString();
// level3.JoinGroupCode = this.Reader[9].ToString();
// level3.JoinGroupOrder = FrameWork.Function.NConvert.ToInt32(this.Reader[10].ToString());
// level3.CheckFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[11].ToString());
// level3.Memo = this.Reader[12].ToString();
// level3.PowerLevelClass2.Class2Name = this.Reader[13].ToString();
// level3.PowerLevelClass2.Class1Code = this.Reader[14].ToString();
level3 = PrepareLevel3Data();
levels.Add(level3);
}
this.Reader.Close();
}
catch (Exception ex) {
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(null);
}
return(levels);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
///
public PowerLevelClass3 LoadLevel3ByPrimaryKey(string class2Code, string class3Code, bool lazy)
{
string sqlstring = PrepareSQL("Manager.PowerLevelManager.LoadLevel3ByPrimaryKey", new string[] { class2Code, class3Code });
if (sqlstring == string.Empty)
{
return(null);
}
try {
this.ExecQuery(sqlstring);
PowerLevelClass3 level3 = new PowerLevelClass3();
if (this.Reader.Read())
{
level3.Class2Code = this.Reader[0].ToString();
level3.Class3Code = this.Reader[1].ToString();
level3.Class3Name = this.Reader[2].ToString();
level3.Class3MeaningCode = this.Reader[3].ToString();
level3.Class3MeaningName = this.Reader[4].ToString();
level3.FinFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[5].ToString());
level3.DelFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString());
level3.GrantFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[7].ToString());
level3.Class3JoinCode = this.Reader[8].ToString();
level3.JoinGroupCode = this.Reader[9].ToString();
level3.JoinGroupOrder = FrameWork.Function.NConvert.ToInt32(this.Reader[10].ToString());
level3.CheckFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[11].ToString());
level3.Memo = this.Reader[12].ToString();
if (!lazy)
{
PowerLevel2Manager level2Mgr = new PowerLevel2Manager();
level3.PowerLevelClass2 = level2Mgr.LoadLevel2ByPrimaryKey(level3.Class2Code, lazy);
}
}
this.Reader.Close();
return(level3);
}
catch (Exception ex) {
this.ErrCode = ex.Message;
this.Err = ex.Message;
return(null);
}
}
/// <summary>
/// 根据项目类别、分类内容获取描述信息
/// </summary>
/// <param name="customType">分类</param>
/// <param name="typeItem">分类内容</param>
/// <returns></returns>
protected string GetDescriptionFromTypeItem(EnumMSCustomType customType, string typeItem, TransTypes trans)
{
switch (customType)
{
case Neusoft.HISFC.Models.Base.EnumMSCustomType.入库: //根据入库类型检索
case Neusoft.HISFC.Models.Base.EnumMSCustomType.出库: //根据出库类型检索
Neusoft.HISFC.BizLogic.Manager.PowerLevelManager powerManager = new Neusoft.HISFC.BizLogic.Manager.PowerLevelManager();
PowerLevelClass3 pIn3 = powerManager.LoadLevel3ByPrimaryKey(Neusoft.HISFC.Models.Base.EnumMSCustomTypeService.GetNameFromEnum(customType), typeItem);
return(customType.ToString() + " － " + pIn3.Name);
case Neusoft.HISFC.Models.Base.EnumMSCustomType.科室: //科室 根据入出库科室选择
Neusoft.HISFC.BizLogic.Manager.PrivInOutDept privInOutManager = new Neusoft.HISFC.BizLogic.Manager.PrivInOutDept();
return("科室 － " + this.deptHelper.GetName(typeItem));
case Neusoft.HISFC.Models.Base.EnumMSCustomType.调价:
if (typeItem == "00")
{
return(this.strAdjustCollection[0]);
}
else
{
return(this.strAdjustCollection[1]);
}
case Neusoft.HISFC.Models.Base.EnumMSCustomType.盘点: //根据盘点盈亏
if (typeItem == "00")
{
return(this.strCheckCollection[0]);
}
else
{
return(this.strCheckCollection[1]);
}
default:
return(customType.ToString());
}
}
/// <summary>
///
/// </summary>
/// <returns></returns>
private PowerLevelClass3 PrepareLevel3Data()
{
PowerLevelClass3 level3 = new PowerLevelClass3();
level3.Class2Code = this.Reader[0].ToString();
level3.Class3Code = this.Reader[1].ToString();
level3.Class3Name = this.Reader[2].ToString();
level3.Class3MeaningCode = this.Reader[3].ToString();
level3.Class3MeaningName = this.Reader[4].ToString();
level3.FinFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[5].ToString());
level3.DelFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[6].ToString());
level3.GrantFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[7].ToString());
level3.Class3JoinCode = this.Reader[8].ToString();
level3.JoinGroupCode = this.Reader[9].ToString();
level3.JoinGroupOrder = FrameWork.Function.NConvert.ToInt32(this.Reader[10].ToString());
level3.CheckFlag = FrameWork.Function.NConvert.ToBoolean(this.Reader[11].ToString());
level3.Memo = this.Reader[12].ToString();
level3.PowerLevelClass2.Class2Name = this.Reader[13].ToString();
level3.PowerLevelClass2.Class1Code = this.Reader[14].ToString();
return(level3);
}
