public bool Add(MRUserInfo m) { string cmdStr = "insert into userinfo_t(Name, Email, Phono, Office, MaxScore, Uid) values(@name,@email,@phono,@office,@maxscore,@uid)"; DbProviderFactory factory = DbProviderFactories.GetFactory(DbHelper.providerName); DbParameter pName = factory.CreateParameter(); pName.ParameterName = "@name"; pName.Value = m.MName; DbParameter pEmail = factory.CreateParameter(); pEmail.ParameterName = "@email"; pEmail.Value = m.MEmail; DbParameter pPhono = factory.CreateParameter(); pPhono.ParameterName = "@phono"; pPhono.Value = m.MPhono; DbParameter pOffice = factory.CreateParameter(); pOffice.ParameterName = "@office"; pOffice.Value = m.MOffice; DbParameter pMaxScore = factory.CreateParameter(); pMaxScore.ParameterName = "@maxscore"; pMaxScore.Value = m.MMaxScore; DbParameter pUid = factory.CreateParameter(); pUid.ParameterName = "@uid"; pUid.Value = m.MUid; if (new RUserInfoDAL().Add(cmdStr, pName, pEmail, pPhono, pOffice, pMaxScore, pUid) == 1) { return(true); } return(false); }
private void CreateUserInfo() //创建新用户信息 { ds = new LUserInfoDataSet(); DataRow row = ds.Tables["userinfo_t"].NewRow();//写入本地数据源 row["Id"] = DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss.ffffff"); row["Name"] = "用户名"; row["Email"] = "Email"; row["Phono"] = "Phono"; row["Office"] = "Office"; row["MaxScore"] = "0"; row["Flag"] = false; ds.Tables["userinfo_t"].Rows.Add(row); ds.WriteXml("UserInfo.xml"); MRUserInfo m = new MRUserInfo(); //写入远程数据源 m.MName = "用户名"; m.MEmail = "Email"; m.MPhono = "Phono"; m.MOffice = "Office"; m.MMaxScore = "0"; m.MUid = ds.Tables["userinfo_t"].Rows[0]["Id"].ToString(); new RUserInfoBLL().Add(m).ToString(); }
public bool Update(MRUserInfo m) { string cmdStr = "update userinfo_t set Name=@name, Email=@email, Phono=@phono, Office=@office, MaxScore=@maxscore where Uid=@uid"; DbProviderFactory factory = DbProviderFactories.GetFactory(DbHelper.providerName); DbParameter pName = factory.CreateParameter(); pName.ParameterName = "@name"; pName.Value = m.MName; DbParameter pEmail = factory.CreateParameter(); pEmail.ParameterName = "@email"; pEmail.Value = m.MEmail; DbParameter pPhono = factory.CreateParameter(); pPhono.ParameterName = "@phono"; pPhono.Value = m.MPhono; DbParameter pOffice = factory.CreateParameter(); pOffice.ParameterName = "@office"; pOffice.Value = m.MOffice; DbParameter pMaxScore = factory.CreateParameter(); pMaxScore.ParameterName = "@maxscore"; pMaxScore.Value = m.MMaxScore; DbParameter pUid = factory.CreateParameter(); pUid.ParameterName = "@uid"; pUid.Value = m.MUid; if (new RUserInfoDAL().Update(cmdStr, pName, pEmail, pPhono, pOffice, pMaxScore, pUid) == 1) { return(true); } return(false); }
private void ImageButton_Click(object sender, RoutedEventArgs e) { ImageButton btn = (ImageButton)sender; if (btn.Name == "ibnQuit") //退出 { DataRow row = ds.Tables["userinfo_t"].Rows[0]; if ((bool)row["Flag"]) { MRUserInfo m = new MRUserInfo(); m.MName = row["Name"].ToString(); m.MEmail = row["Email"].ToString(); m.MPhono = row["Phono"].ToString(); m.MOffice = row["Office"].ToString(); m.MMaxScore = row["MaxScore"].ToString(); m.MUid = row["Id"].ToString(); if (new RUserInfoBLL().Update(m)) //更新成功才修改Flag标示列,不然的话不修改,下次继续尝试修改 { row["Flag"] = false; } } this.Close(); } else if (btn.Name == "ibnMaxScore") //最高分 { MaxScore window = new MaxScore(Convert.ToInt32(ds.Tables["userinfo_t"].Rows[0]["MaxScore"])); window.Show(); this.Close(); } else if (btn.Name == "ibnStart") //开始游戏 { MainWindow window = new MainWindow(ds); window.Show(); this.Close(); } else if (btn.Name == "ibnUserinfo") //个人信息 { UserInfo window = new UserInfo(ds); window.Show(); this.Close(); } }