private void BindingDsPlatformVersion()
{
string systemid = this.ddlPlatforms.SelectedValue;
//string sqlAndroid = string.Format(@"select id,PlatformID,[Version] from [sdk_PlatformVersion] where SystemID=" + systemid + " order by Version desc");
string sqlAndroid = string.Format(@"select id,PlatformID,[Version],[SystemID] from [sdk_PlatformVersion] order by Version desc");
ds = aideNativeWebFacade.GetDataSetBySql(sqlAndroid);
}
/// <summary>
/// 绑定Android版本
/// </summary>
private void BindingAndroidVersionList()
{
string sql = "SELECT ID,[MyVersion] FROM [sdk_TypeSdkVersion] WHERE [PlatFormID]=1 ORDER BY [MyVersion] DESC";
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sql);
this.ddlAndroidVersionList.DataSource = ds;
this.ddlAndroidVersionList.DataTextField = "MyVersion";
this.ddlAndroidVersionList.DataValueField = "ID";
this.ddlAndroidVersionList.DataBind();
}
private void BindingCache()
{
string sql = string.Format(@" select * from [AspNetUserRoles] r inner join AspNetUsers u on r.UserId=u.Id and u.UserName='******' and RoleId in (2,3)", Context.User.Identity.Name);
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sql);
if (ds.Tables[0].Rows.Count > 0)
{
Cache["Roleid"] = "0";
}
else
{
Cache["Roleid"] = "1";
}
}
private bool IsSendMail(int recid)
{
string sql = string.Format(@" select * from [AspNetUserRoles] r inner join AspNetUsers u on r.UserId=u.Id and u.UserName=(select CreateUser from sdk_NewPackageCreateTask where recid={0}) and RoleId in (2,3)", recid);
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sql);
if (ds.Tables[0].Rows.Count > 0)
{
return(false);
}
else
{
return(true);
}
}
public void BindingList()
{
string sqlQuery = "";
if (platform == "Android")
{
sqlQuery = string.Format(@"select npct.PackageTaskStatus,dpf.PlatformName,dpf.PlatformDisplayName,npct.PackageName,npct.RecID,npct.adid,npct.adname,npct.PlugInID from
sdk_NewPackageCreateTask npct
inner join sdk_DefaultPlatform dpf on npct.PlatFormID=dpf.Id and npct.CreateTaskID='{0}'", createtaskid);
}
else
{
sqlQuery = string.Format(@"select npct.PackageTaskStatus,dpf.PlatformName,dpf.PlatformDisplayName,npct.PackageName,npct.RecID,adname='',PlugInID=0 from
sdk_NewPackageCreateTask_IOS npct
inner join sdk_DefaultPlatform dpf on npct.PlatFormID=dpf.Id and npct.CreateTaskID='{0}'", createtaskid);
}
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sqlQuery);
this.GamePlaceList.DataSource = ds;
this.GamePlaceList.DataBind();
var p = ds.Tables[0].AsEnumerable().Where(r => r["PackageTaskStatus"].ToString() == "0" || r["PackageTaskStatus"].ToString() == "1" || r["PackageTaskStatus"].ToString() == "2").Select(d => d);
//if (p != null && p.Count() > 0)
//{
// this.Timer1.Enabled = true;
//}
//else
//{
// this.Timer1.Enabled = false;
//}
//this.GamePlaceList.DataSource = ClientIDSeparator;
}
private void BindingCache()
{
string sql = string.Format(@" select * from [AspNetUserRoles] r inner join AspNetUsers u on r.UserId=u.Id and u.UserName='******'", Context.User.Identity.Name);// and RoleId in (2,3)
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sql);
DataView dv = ds.Tables[0].DefaultView;
dv.RowFilter = "RoleId IN (2,3)";
DataTable newTable = dv.ToTable();
var roles = new HashSet <string>();
foreach (DataRow r in ds.Tables[0].Rows)
{
//var c = r["RoleId"];
roles.Add(r["RoleId"].ToString());
}
Cache["Roles"] = roles;
if (newTable.Rows.Count > 0)
{
Cache["Roleid"] = "0";
}
else
{
Cache["Roleid"] = "1";
}
}
private void Update()
{
string sql = string.Format("select gameid from sdk_gameInfo");
DataSet dsGame = aideNativeWebFacade.GetDataSetBySql(sql);
string sql2 = string.Format("select id,parentid from sdk_defaultplatform where platformname like '%_LeBian'");
DataSet dsPlatform = aideNativeWebFacade.GetDataSetBySql(sql2);
for (int i = 0; i < dsGame.Tables[0].Rows.Count; i++)
{
string gameid = dsGame.Tables[0].Rows[i]["gameid"].ToString();
for (int j = 0; j < dsPlatform.Tables[0].Rows.Count; j++)
{
string id = dsPlatform.Tables[0].Rows[j]["id"].ToString();
string pid = dsPlatform.Tables[0].Rows[j]["parentid"].ToString();
string sql3 = string.Format("select 1 from sdk_PlatformConfig where gamename='{0}' and platformname='{1}'", gameid, id);
if (aideNativeWebFacade.GetDataSetBySql(sql3).Tables[0].Rows.Count > 0)
{
string sql4 = string.Format(@"update sdk_PlatformConfig set platformname='{0}',PlugInID=1 where gamename='{1}' and platformname='{2}'", pid, gameid, id);
aideNativeWebFacade.ExecuteSql(sql4);
}
}
}
}
private void BindingDsAndroidPlatformVersion()
{
string sqlAndroid = string.Format(@"select id,PlatformID,[Version] from [sdk_PlatformVersion] where SystemID=1");
string sqlIos = string.Format(@"select id,PlatformID,[Version] from [sdk_PlatformVersion] where SystemID=2");
dsAndroidPlatformVersion = aideNativeWebFacade.GetDataSetBySql(sqlAndroid);
dsIosPlatformVersion = aideNativeWebFacade.GetDataSetBySql(sqlIos);
string sqlGPAndroid = string.Format(@"select
gi.GameID as GameID,
gpfi.VersionID as VersionID,
dpf.id as Platformid,
pv.[Version] as [Version]
from sdk_GamePlatFromInfo gpfi
inner join [sdk_GameInfo] gi on gpfi.GameID=gi.GameID and gi.GameID='{0}' and gpfi.SystemID='1'
inner join sdk_defaultPlatform dpf on gpfi.[VersionPlatFromID]=dpf.id
left join sdk_PlatformVersion pv on gpfi.VersionID=pv.ID" , gameid);
dsGP = aideNativeWebFacade.GetDataSetBySql(sqlGPAndroid);
}
private void BindingList()
{
string sqlQuery = string.Format(@"select npct.PackageTaskStatus,dpf.PlatformName,dpf.PlatformDisplayName,npct.PackageName from
sdk_NewPackageCreateTask npct
inner join sdk_DefaultPlatform dpf on npct.PlatFormID=dpf.Id and npct.CreateTaskID='{0}'", createtaskid);
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sqlQuery);
this.GamePlaceList.DataSource = ds;
this.GamePlaceList.DataBind();
var p = ds.Tables[0].AsEnumerable().Where(r => r["PackageTaskStatus"].ToString() == "0" || r["PackageTaskStatus"].ToString() == "1" || r["PackageTaskStatus"].ToString() == "2").Select(d => d);
if (p != null && p.Count() > 0)
{
this.Timer1.Enabled = true;
}
else
{
this.Timer1.Enabled = false;
}
}
public string GetPackgeStatus(string id, string systemname)
{
if (String.IsNullOrWhiteSpace(id))
{
id = "(0)";
}
else
{
id = "(" + id + ")";
}
string sql = string.Format(@"SELECT [RecID],[PackageTaskStatus] FROM {0} WHERE [RecID] in {1}", String.Equals(systemname, "Android") ? "sdk_NewPackageCreateTask" : "sdk_NewPackageCreateTask_IOS", id);
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sql);
var oData = ds.Tables[0].AsEnumerable();
var objJson = new { ret = 1, data = new List <object>() };
if (oData.Count() != 0)
{
var objtasklist = ds.Tables[0].AsEnumerable();
List <object> tasklist = new List <object>();
foreach (var item in objtasklist)
{
tasklist.Add(new
{
RecID = item["RecID"],
PackageTaskStatus = item["PackageTaskStatus"]
});
}
objJson = new { ret = 0, data = tasklist };
}
string strJson = "";
strJson = JsonConvert.SerializeObject(objJson);
return(strJson);
}
private void BindingData()
{
string SDKPackageDir = System.Configuration.ConfigurationManager.AppSettings["SDKAndroidPackageConfig"];
SDKPackageDir += gamename + "\\" + platformname + "\\replace_key.xml";
if (System.IO.File.Exists(SDKPackageDir))
{
LoadXml(SDKPackageDir);
}
else
{
LoadInitXml();
}
string sql = string.Format(@"select SDKKey from [sdk_PlatformConfig] where gamename='{0}' and PlatformName='{1}' and PlugInID={2} and isBuilding=1", gameid, platformid, pluginid);
DataSet ds = aideNativeWebFacade.GetDataSetBySql(sql);
this.CheckBoxListIsBinding.DataSource = ds;
this.CheckBoxListIsBinding.DataTextField = "SDKKey";
this.CheckBoxListIsBinding.DataValueField = "SDKKey";
this.CheckBoxListIsBinding.DataBind();
UpdateCheckBoxListSelected(true);
}
