protected void BindSinger()
{
DataTable dt = SingerManager.selectAll();
ListView1.DataSource = dt;
ListView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
UnobtrusiveValidationMode = UnobtrusiveValidationMode.None;
if (Session["adminname"] == null)
{
Response.Redirect("adminLogin.aspx");
}
if (!IsPostBack)
{
if (Request.QueryString["SingerID"] != null)
{
int id = int.Parse(Request.QueryString["SingerID"]);
DataTable dt = SingerManager.selectID(id);
ViewState["object"] = singer;//使用视图 ViewState 因为大量的session会增加服务器负担 将需要的保存在视图中
txtSingerid.Text = Convert.ToString(dt.Rows[0]["SingerID"]);
txtSingername.Text = Convert.ToString(dt.Rows[0]["SingerName"]);
txtType.Text = Convert.ToString(dt.Rows[0]["SingerType"]);
txtSiContent.Text = Convert.ToString(dt.Rows[0]["SingerInfo"]);
sinImage.ImageUrl = ResolveUrl(dt.Rows[0]["SingerImg"].ToString());
}
}
}
public SingerService()
{
_ctx = new JMDbContext();
_userManager = new UserManager(_ctx);
_musicManager = new MusicManager(_ctx, _userManager);
_albumManager = new AlbumManager(_ctx, _userManager, _musicManager);
_singerManager = new SingerManager(_ctx, _userManager, _albumManager, _musicManager);
}
public MainWindow()
{
InitializeComponent();
NoteLength.ItemsSource = Settings.Current.NotesLengths.Keys;
NoteLength.SelectedIndex = 2;
SingerManager = new SingerManager();
New();
}
private void BindHotSingers()
{
DataTable dt = SingerManager.selectTop12();
if (dt != null && dt.Rows.Count != 0)
{
DataList1.DataSource = dt;
DataList1.DataBind();
}
}
public void InitSingers(SingerManager singerManager)
{
SingersList.Items.Clear();
foreach (var sing in singerManager.SingerNames)
{
var item = new ListViewItem();
item.Content = sing;
SingersList.Items.Add(sing);
}
}
private void BindSinger()
{
DataTable dt = SingerManager.selectTop5();
if (dt != null && dt.Rows.Count != 0)
{
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
}
private void BindAllChGroupSi()//绑定华语组合/乐队
{
DataTable dt = SingerManager.selectAllCgroupsi();
if (dt != null && dt.Rows.Count != 0)
{
DataList5.DataSource = dt;
DataList5.DataBind();
}
}
private void BindAllHotSingers()//绑定热门歌手
{
DataTable dt = SingerManager.selectTop15();
if (dt != null && dt.Rows.Count != 0)
{
DataList2.DataSource = dt;
DataList2.DataBind();
}
}
private void BindAllChManSi()//绑定华语男歌手
{
DataTable dt = SingerManager.selectAllCMansi();
if (dt != null && dt.Rows.Count != 0)
{
DataList3.DataSource = dt;
DataList3.DataBind();
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
Button bt = (Button)sender;
int sinid = Convert.ToInt32(((HiddenField)(bt.Parent.FindControl("HiddenField2"))).Value);
if (SingerManager.deleteID(sinid) > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script language='javascript' >alert('删除成功！');</script>");
BindSinger();
}
}
private void load(SingerManager singerManager, OsuColour colour)
{
AddInternal(background = new Box
{
Name = "Background",
Depth = 1,
RelativeSizeAxes = Axes.X,
Height = timeline_height,
Anchor = Anchor.CentreLeft,
Origin = Anchor.CentreLeft,
Colour = colour.Gray3,
});
AddRange(new Drawable[]
{
mainContent = new Container
{
RelativeSizeAxes = Axes.X,
Height = timeline_height,
Anchor = Anchor.CentreLeft,
Origin = Anchor.CentreLeft,
Depth = float.MaxValue,
Children = new Drawable[]
{
new LyricBlueprintContainer(Singer),
}
},
});
// initialize scroll zone.
MaxZoom = getZoomLevelForVisibleMilliseconds(2000);
MinZoom = getZoomLevelForVisibleMilliseconds(20000);
Zoom = getZoomLevelForVisibleMilliseconds(5000);
bindableZoom = singerManager.BindableZoom.GetBoundCopy();
bindableCurrent = singerManager.BindableCurrent.GetBoundCopy();
bindableZoom.BindValueChanged(e =>
{
if (e.NewValue == Zoom)
{
return;
}
Zoom = e.NewValue;
}, true);
bindableCurrent.BindValueChanged(e =>
{
ScrollTo(e.NewValue);
}, true);
}
public KaraokeHitObjectComposer(Ruleset ruleset)
: base(ruleset)
{
// Duplicated registration because selection handler need to use it.
positionCalculator = new PositionCalculator(9);
editConfigManager = new KaraokeRulesetEditConfigManager();
generatorConfigManager = new KaraokeRulesetEditGeneratorConfigManager();
checkerConfigManager = new KaraokeRulesetEditCheckerConfigManager();
AddInternal(exportLyricManager = new ExportLyricManager());
AddInternal(noteManager = new NoteManager());
AddInternal(lyricManager = new LyricManager());
AddInternal(lyricCheckerManager = new LyricCheckerManager());
AddInternal(singerManager = new SingerManager());
LayerBelowRuleset.Add(languageSelectionDialog = new LanguageSelectionDialog());
}
protected void lbtnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
singer = new Singer();
singer.SingerId = Convert.ToInt32(txtSingerid.Text.Trim());
singer.SingerName = txtSingername.Text.Trim();
singer.SingerType = ddlsingerType.SelectedItem.Text;
singer.SingerInfo = txtSiContent.Text.Trim();
if (download.HasFile)
{
string filePath = download.PostedFile.FileName;
string filename = filePath.Substring(filePath.LastIndexOf("\\") + 1);
string serverpath = Server.MapPath(@"~\image\singer_img\") + filename;
string relativepath = @"~\image\singer_img\" + filename;
download.PostedFile.SaveAs(serverpath);
singer.SingerImg = relativepath;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('请先上传歌手图片！');</script>");
return;
}
try
{
if (ViewState["object"] == null)
{
if (SingerManager.updateId(singer) == 1)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>alert('保存成功！');</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "message", "<script>alert('保存失败！');</script>");
}
}
}
catch (Exception ex)
{
Response.Write("错误原因：" + ex.Message);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
int singerID;
if (Request.QueryString["ID"] != null)
{
singerID = Convert.ToInt32(Request.QueryString["ID"].ToString());
DataTable dt = SingerManager.selectID(singerID);
if (dt != null && dt.Rows.Count != 0)
{
lblSinName.Text = dt.Rows[0][1].ToString();
lblSinType.Text = dt.Rows[0][2].ToString();
txtinfo.Text = dt.Rows[0][3].ToString();
imgSin.ImageUrl = ResolveUrl(dt.Rows[0][4].ToString());
lblSinHits.Text = (Convert.ToUInt32(dt.Rows[0][5]) + SingerManager.updateClickNum(singerID)).ToString();
}
}
BindSinger();
BindSong();
}
protected void btnAddSinger_Click(object sender, EventArgs e)
{
Singer si = new Singer();
si.SingerName = txtSingerName.Text;
si.SingerType = ddlType.SelectedItem.Text;
si.SingerInfo = txtSiContent.Text;
try
{
if (uploadImg.HasFile)
{
string filePath = uploadImg.PostedFile.FileName;
string filename = filePath.Substring(filePath.LastIndexOf("\\") + 1);
string serverpath = Server.MapPath(@"~\image\singer_img\") + filename;
string relativepath = @"~\image\singer_img\" + filename;
uploadImg.PostedFile.SaveAs(serverpath);
si.SingerImg = relativepath;
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('请先上传歌手图片！');</script>");
return;
}
if (SingerManager.addSinger(si) == 1)
{
txtSingerName.Text = txtSiContent.Text = "";
Page.ClientScript.RegisterClientScriptBlock(typeof(Object), "alert", "<script>alert('添加成功！');</script>");
}
else
{
Page.ClientScript.RegisterClientScriptBlock(typeof(object), "alert", "<script>alert('添加失败！');</script>");
}
}
catch (Exception ex)
{
Response.Write("错误原因：" + ex.Message);
}
}
public SingerAppService(JMDbContext ctx, SingerManager singerManager)
{
_ctx = ctx;
_singerManager = singerManager;
}
public void Init(SingerManager singerManager, Project project)
{
InitSingers(singerManager);
InitTitle(project);
}
