private void Create(LevelExpandEnum levelExpand)
{
string strSQL = string.Empty;
DataSet ds = null;
if (levelExpand == LevelExpandEnum.AreaClass)
{
strSQL = "Select cDCCode as cCode, cDCName as 地区 from DistrictClass";
}
else if (levelExpand == LevelExpandEnum.CustClass)
{
strSQL = "select cCCCode as cCode , cCCName as 客户分类 from CustomerClass";
}
else if (levelExpand == LevelExpandEnum.DepLevel)
{
strSQL = "Select cDepCode as cCode, cDepName as cname from Department";
}
else if (levelExpand == LevelExpandEnum.DispLevel)
{
strSQL = "Select cRdCode as cCode,cRdName as cname from Rd_Style";
}
else if (levelExpand == LevelExpandEnum.GoodClass)
{
strSQL = "Select cInvCCode as cCode,cInvCname as cname from inventoryClass";
}
else if (levelExpand == LevelExpandEnum.GradeLevel)
{
strSQL = "Select cCode as cCode, cCode_name as cname from Code";
}
else if (levelExpand == LevelExpandEnum.PosLevel)
{
strSQL = "Select cPosCode as cCode, cPosName as cname from Position";
}
else if (levelExpand == LevelExpandEnum.ProvClass)
{
strSQL = "Select cVCCode as cCode, cVCName as cname from vendorClass";
}
else if (levelExpand == LevelExpandEnum.SettleLevel)
{
strSQL = "Select cSSCode as cCode, cSSName as cname from SettleStyle";
}
else if (levelExpand == LevelExpandEnum.fa_SourceClass)//资金构成分类
{
strSQL = "select sCCode as cCode,sCName as cname from fa_SourceClass";
}
else
{
_expandProgram = new ExpandProgram(U8LoginInfor);
strSQL = _expandProgram.RetriveDifinitionSQL(Convert.ToInt32(levelExpand));
}
ds = SqlHelper.ExecuteDataSet(this.U8LoginInfor.UfDataCnnString, strSQL);
LevelExpandDataTable leds = new LevelExpandDataTable(ds.Tables[0]);
dataSetObjects.Add(levelExpand, leds);
}
public string GetLevelItemCaption(LevelExpandEnum levelExpandType)
{
// string localeId = this.U8LoginInfor.LocaleID;
string caption = string.Empty;
if (levelExpandType == LevelExpandEnum.AreaClass)
{
caption = "U8.SO.ReportServer.clssetdataprovider.00086";
}
else if (levelExpandType == LevelExpandEnum.CustClass)
{
caption = "U8.GL.ZWSQL.CODEACC.00766";
}
else if (levelExpandType == LevelExpandEnum.DepLevel)
{
caption = "U8.BPM.DSS.U8GDP.SaleOrderLabDept001";
}
else if (levelExpandType == LevelExpandEnum.DispLevel)
{
caption = "U8.CW.GL.ZZTool.frmPzYr.MenuPop.menuSFLB.Caption";
}
else if (levelExpandType == LevelExpandEnum.GoodClass)
{
caption = "U8.AA.ARCHIVE.FIELD.cinvcls";
}
else if (levelExpandType == LevelExpandEnum.GradeLevel)
{
caption = "U8.AA.ARCHIVE.code";
}
else if (levelExpandType == LevelExpandEnum.PosLevel)
{
caption = "U8.AA.ARCHIVE.FIELD.ref_cposcode";
}
else if (levelExpandType == LevelExpandEnum.ProvClass)
{
caption = "U8.AA.ARCHIVE.FIELD.cvencls";
}
else if (levelExpandType == LevelExpandEnum.SettleLevel)
{
caption = "U8.AA.EAI.XML.Operation.Dir.0014";
}
else if (levelExpandType == LevelExpandEnum.fa_SourceClass)//资金构成分类
{
caption = "U8.UAP.Services.ReportExhibition.ReportExpandWindow.资金构成分类";
}
else
{
_expandProgram = new ExpandProgram(u8LoginInfor);
caption = _expandProgram.RetriveItemCaption(Convert.ToInt32(levelExpandType));
}
return(caption);
}
public string RetrieveCodeRule(U8LoginInfor login)
{
if (this._codeRule == string.Empty)
{
string strSQL = string.Empty;
DataSet ds = null;
if (this._expandType == LevelExpandEnum.AreaClass)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cAreaClass'";
}
else if (this._expandType == LevelExpandEnum.CustClass)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cCustClass'";
}
else if (this._expandType == LevelExpandEnum.DepLevel)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cDepLevel'";
}
else if (this._expandType == LevelExpandEnum.DispLevel)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cDispLevel'";
}
else if (this._expandType == LevelExpandEnum.GoodClass)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cGoodClass'";
}
else if (this._expandType == LevelExpandEnum.GradeLevel)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cGradeLevel'";
}
else if (this._expandType == LevelExpandEnum.PosLevel)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cPosLevel'";
}
else if (this._expandType == LevelExpandEnum.ProvClass)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cProvClass'";
}
else if (this._expandType == LevelExpandEnum.SettleLevel)
{
strSQL = "select cValue from accinformation where csysid ='aa' and cname ='cSettleLevel'";
}
else if (this._expandType == LevelExpandEnum.fa_SourceClass)//资金构成分类
{
strSQL = "select CODINGRULE cValue from GradeDef_base where keyword='fa_SourceClass'";
}
//string strConn = "user id=sa; password=1; database=UFDATA_777_2005; server=zblpwin;";
// ds = SqlHelper.ExecuteDataSet(strConn, strSQL);
else
{
_expandProgram = new ExpandProgram(login);
strSQL = _expandProgram.RetriveRuleSQL(Convert.ToInt32(_expandType));
if (string.IsNullOrEmpty(strSQL))
{
//throw new Exception("No Difinition!");
return("");
}
}
ds = SqlHelper.ExecuteDataSet(login.UfDataCnnString, strSQL);
if (ds.Tables[0].Rows.Count == 0)//资金构成分类
{
return("");
}
this._codeRule = ds.Tables[0].Rows[0][0].ToString();
}
return(this._codeRule);
}
