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); }