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