public virtual void SMC_PackageExtInternalRelease(int pe_id)
{
SMC_PackageExtDao daoSMC_PackageExt = new SMC_PackageExtDao(AppConfig.statisticDBKey);
List <KeyValuePair <string, object> > pars = new List <KeyValuePair <string, object> >();
pars.Add(new KeyValuePair <string, object>("pe_id", pe_id));
SMC_PackageExt ext = daoSMC_PackageExt.Get(pars);
_SMC_PackageExtInternalRelease(ext);
}
public virtual DataSet GetTJPackageList(Common.Entities.Enum.PackageClientType packageClientType, string unitCode, int is_webapp)
{
SMC_PackageExtDao peDao = new SMC_PackageExtDao(AppConfig.statisticDBKey);
DataSet ds = peDao.GetTJPackageList(packageClientType, unitCode, is_webapp);
return ds;
//DataColumn clmn = ds.Tables[0].Columns.Add("id", typeof(string));
//clmn = ds.Tables[0].Columns.Add("name", typeof(string));
//clmn = ds.Tables[0].Columns.Add("displayname", typeof(string));
//clmn = ds.Tables[0].Columns.Add("description", typeof(string));
//clmn = ds.Tables[0].Columns.Add("version", typeof(string));
//clmn = ds.Tables[0].Columns.Add("buildver", typeof(string));
//clmn = ds.Tables[0].Columns.Add("downloaduri", typeof(string));
//foreach (DataRow dr in ds.Tables[0].Rows)
//{
// string tablename = dr["tablename"].ToString().ToLower();
// int tableid = Convert.ToInt32(dr["tableid"]);
// switch (tablename)
// {
// case "package4ai":
// Package4AIDao padao = new Package4AIDao(AppConfig.mainDbKey);
// Package4AI entity = padao.Get(tableid);
// dr["id"] = tableid;
// dr["name"] = entity.Name;
// dr["displayname"] = entity.DisplayName;
// dr["description"] = entity.Description;
// dr["version"] = entity.Version;
// dr["buildver"] = entity.BuildVer;
// dr["downloaduri"] = entity.DownloadUri;
// break;
// case "webapplication":
// WebApplicationDao wad = new WebApplicationDao(AppConfig.mainDbKey);
// WebApplication application = wad.Get(tableid);
// dr["id"] = tableid;
// dr["name"] = application.ShortName;
// dr["displayname"] = application.ShortName;
// dr["description"] = "";
// dr["version"] = "";
// dr["buildver"] = "";
// dr["downloaduri"] = application.Uri;
// break;
// case "smc_package4out":
// SMC_Package4OutDao poDao = new SMC_Package4OutDao(AppConfig.statisticDBKey);
// SMC_Package4Out outEntity = poDao.Get(tableid);
// dr["id"] = tableid;
// dr["name"] = outEntity.Name;
// dr["displayname"] = outEntity.DisplayName;
// dr["description"] = outEntity.Description;
// dr["version"] = outEntity.Version;
// dr["buildver"] = outEntity.BuildVer;
// dr["downloaduri"] = outEntity.DownloadUri;
// break;
// }
//}
//return ds;
}
public virtual SMC_PackageExt GetPackageExt(int packageId)
{
SMC_PackageExtDao peDao = new SMC_PackageExtDao(AppConfig.statisticDBKey);
SMC_PackageExt ext = peDao.Get(packageId);
return ext;
}
public virtual Hashtable GetPackage(int packageId)
{
SMC_PackageExtDao peDao = new SMC_PackageExtDao(AppConfig.statisticDBKey);
SMC_PackageExt ext = peDao.Get(packageId);
Hashtable hash = new Hashtable();
//hash["ItemName"] = ext.pe_Name;// dr["pe_Name"].ToString();// "PPS影音";
//hash["ItemVersion"] = "";// dr["version"].ToString();// "android手机版";
hash["Class"] = ext.pe_Category;//"办公/政务";
hash["Unit"] = ext.pe_UnitName;// "上海互联网软件";
hash["ItemDate"] = ext.pe_CreatedTime.ToString("yyyy-MM-dd");
hash["os"] = ext.pe_Firmware;
hash["DownloadCount"] = ext.pe_DownCount;
hash["size"] = ext.pe_Size / 1024 / 1024;
string pe_PictureUrl = ext.pe_PictureUrl;
if (String.IsNullOrEmpty(ext.pe_PictureUrl))
{
hash["appImage"] = this._ctroller.Url.Content("~/AppIcons/No.png");
}
else
{
hash["appImage"] = this._ctroller.Url.Content(ext.pe_PictureUrl);
}
int tableid = Convert.ToInt32(ext.TableID);
hash["id"] = tableid;
hash["name"] = ext.pe_Name;
hash["displayname"] = ext.pe_DisplayName;
hash["description"] = ext.pe_Description;
hash["version"] = ext.pe_Version;
hash["buildver"] = ext.pe_BuildVer;
hash["downloaduri"] = ext.pe_DownloadUri;
hash["pe_clienttype"] = ext.pe_ClientType == null ? "" : ext.pe_ClientType;
string tablename = ext.TableName;
switch (tablename.ToLower())
{
case "package4ai":
//Package4AIDao padao = new Package4AIDao(AppConfig.mainDbKey);
//Package4AI entity = padao.Get(tableid);
//hash["id"] = tableid;
//hash["name"] = entity.Name;
//hash["displayname"] = entity.DisplayName;
//hash["description"] = entity.Description;
//hash["version"] = entity.Version;
//hash["buildver"] = entity.BuildVer;
//hash["downloaduri"] = entity.DownloadUri;
break;
case "webapplication":
//WebApplicationDao wad = new WebApplicationDao(AppConfig.mainDbKey);
//WebApplication application = wad.Get(tableid);
//hash["id"] = tableid;
//hash["name"] = application.ShortName;
//hash["displayname"] = application.ShortName;
//hash["description"] = "";
//hash["version"] = "";
//hash["buildver"] = "";
//hash["downloaduri"] = application.Uri;
break;
case "smc_package4out":
//SMC_Package4OutDao poDao = new SMC_Package4OutDao(AppConfig.statisticDBKey);
//SMC_Package4Out outEntity = poDao.Get(tableid);
//hash["id"] = tableid;
//hash["name"] = outEntity.Name;
//hash["displayname"] = outEntity.DisplayName;
//hash["description"] = outEntity.Description;
//hash["version"] = outEntity.Version;
//hash["buildver"] = outEntity.BuildVer;
//hash["downloaduri"] = outEntity.DownloadUri;
break;
}
//string downUrl = "";//ext.downloaduri;
//hash["appUrl"] = Url.Content("~/Home/Detail?packageid=") + dr["id"].ToString();
hash["HelpUrl"] = "";
//hash["downUrl"] = this._ctroller.Url.Content(downUrl); //"~/Home/Detail?packageid=5"
return hash;
}
public virtual SMC_PackageExt GetPackage(string tableName, string tableId)
{
SMC_PackageExtDao peDao = new SMC_PackageExtDao(AppConfig.statisticDBKey);
return peDao.getPackage(tableName, tableId);
}
public virtual List<Hashtable> GetCommentAllAppList()
{
SMC_PackageExtDao peDao = new SMC_PackageExtDao(AppConfig.statisticDBKey);
//IList<SMC_PackageExt> packets = peDao.GetPackageList(SmartBox.Console.Common.Entities.Enum.PackageClientType.All, Common.Entities.Enum.PackageTrait.Tuijian);
List<Hashtable> result = new List<Hashtable>();
for (int i = 0; i < 7; ++i)
{
Hashtable hash = new Hashtable();
hash["appName"] = "PPS影音";
hash["appVersion"] = "android手机版";
hash["appClass"] = "办公/政务";
hash["appUnit"] = "上海互联网软件";
hash["appDate"] = "2014-3-10";
hash["appImage"] = "app"+(i+1)+".png";
hash["appUrl"] = _ctroller.Url.Content("~/Home/Detail?packageid=5");
result.Add(hash);
}
return result;
}
public virtual List<Hashtable> GetApplicationCategoryList(int maxCount)
{
SMC_PackageExtDao peDao = new SMC_PackageExtDao(AppConfig.mainDbKey);
DataSet ds = peDao.GetApplicationCategoryList(maxCount);
List<Hashtable> result = new List<Hashtable>();
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
Hashtable hash = new Hashtable();
hash["categoryCode"] = dr["id"].ToString();
hash["categoryName"] = dr["displayname"].ToString();
hash["url"] = this._ctroller.Url.Content("~/home/list?cat3=" + dr["id"].ToString());
result.Add(hash);
}
}
return result;
}
public virtual void SMC_PackageExtInternalRelease(int pe_id)
{
SMC_PackageExtDao daoSMC_PackageExt = new SMC_PackageExtDao(AppConfig.statisticDBKey);
List<KeyValuePair<string, object>> pars = new List<KeyValuePair<string, object>>();
pars.Add(new KeyValuePair<string, object>("pe_id", pe_id));
SMC_PackageExt ext = daoSMC_PackageExt.Get(pars);
_SMC_PackageExtInternalRelease(ext);
}
