private string SaveTypeRecord(int Ptid, int Psid, string Psnum, string Pip, int Pgrade, int Pterm, string TypeScore)
{
int Pscore = Int32.Parse(TypeScore.Trim());
DateTime Pdate = DateTime.Now;
LearnSite.Model.Ptyper pmodel = new LearnSite.Model.Ptyper();
pmodel.Pdate = Pdate;
pmodel.Pip = Pip;
pmodel.Pscore = Pscore;
pmodel.Psnum = Psnum;
pmodel.Ptid = Ptid;
pmodel.Ptype = 1;
pmodel.Pdegree = GetPdegree(Pscore);
pmodel.Pgrade = Pgrade;
pmodel.Pterm = Pterm;
pmodel.Psid = Psid;
LearnSite.BLL.Ptyper pt = new LearnSite.BLL.Ptyper();
int res = -1;
if (pt.ExistsPsnum(Psid))
{
res = pt.Update(pmodel);
}
else
{
res = pt.Add(pmodel);
}
if (res > 0)
{
pt.UpdateStscore(Psid, Pscore);
res = 1;
}
return(res.ToString());
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <LearnSite.Model.Ptyper> DataTableToList(DataTable dt)
{
List <LearnSite.Model.Ptyper> modelList = new List <LearnSite.Model.Ptyper>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LearnSite.Model.Ptyper model;
for (int n = 0; n < rowsCount; n++)
{
model = new LearnSite.Model.Ptyper();
if (dt.Rows[n]["Pid"].ToString() != "")
{
model.Pid = int.Parse(dt.Rows[n]["Pid"].ToString());
}
if (dt.Rows[n]["Ptid"].ToString() != "")
{
model.Ptid = int.Parse(dt.Rows[n]["Ptid"].ToString());
}
model.Psnum = dt.Rows[n]["Psnum"].ToString();
if (dt.Rows[n]["Pscore"].ToString() != "")
{
model.Pscore = int.Parse(dt.Rows[n]["Pscore"].ToString());
}
if (dt.Rows[n]["Pdate"].ToString() != "")
{
model.Pdate = DateTime.Parse(dt.Rows[n]["Pdate"].ToString());
}
model.Pip = dt.Rows[n]["Pip"].ToString();
if (dt.Rows[n]["Ptype"].ToString() != "")
{
model.Ptype = int.Parse(dt.Rows[n]["Ptype"].ToString());
}
if (dt.Rows[n]["Pdegree"].ToString() != "")
{
model.Ptype = int.Parse(dt.Rows[n]["Pdegree"].ToString());
}
if (dt.Rows[n]["Pgrade"].ToString() != "")
{
model.Pgrade = int.Parse(dt.Rows[n]["Pgrade"].ToString());
}
if (dt.Rows[n]["Pterm"].ToString() != "")
{
model.Pterm = int.Parse(dt.Rows[n]["Pterm"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// ��������б�
/// </summary>
public List<LearnSite.Model.Ptyper> DataTableToList(DataTable dt)
{
List<LearnSite.Model.Ptyper> modelList = new List<LearnSite.Model.Ptyper>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
LearnSite.Model.Ptyper model;
for (int n = 0; n < rowsCount; n++)
{
model = new LearnSite.Model.Ptyper();
if(dt.Rows[n]["Pid"].ToString()!="")
{
model.Pid=int.Parse(dt.Rows[n]["Pid"].ToString());
}
if(dt.Rows[n]["Ptid"].ToString()!="")
{
model.Ptid=int.Parse(dt.Rows[n]["Ptid"].ToString());
}
model.Psnum=dt.Rows[n]["Psnum"].ToString();
if(dt.Rows[n]["Pscore"].ToString()!="")
{
model.Pscore=int.Parse(dt.Rows[n]["Pscore"].ToString());
}
if(dt.Rows[n]["Pdate"].ToString()!="")
{
model.Pdate=DateTime.Parse(dt.Rows[n]["Pdate"].ToString());
}
model.Pip=dt.Rows[n]["Pip"].ToString();
if(dt.Rows[n]["Ptype"].ToString()!="")
{
model.Ptype=int.Parse(dt.Rows[n]["Ptype"].ToString());
}
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 更新一条数据，根据学号更新
/// </summary>
public int Update(LearnSite.Model.Ptyper model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(LearnSite.Model.Ptyper model)
{
return(dal.Add(model));
}
private void SaveTypeRecord(string Psnum,string Pip)
{
string TypeScore = Request.Form["Typeresult"].ToString();//
TypeScore = TypeScore.Replace("字/分", "");
string nowstr = Request.Form["TypeText7"].ToString();
string rightword = Request.Form["TypeText4"].ToString();
bool Timepass = false;
int nowtime = 0;
int uplen = ts.Length * 80 / 100;
if (nowstr != "")
{
nowtime = Int32.Parse(nowstr);
}
int Typetime = 1800 - nowtime;
if (Typetime > 10)
{
Timepass = true;
}
else
{
Timepass = false;
}
if (Timepass)
{
if (Int32.Parse(rightword) > uplen)
{
int Ptid = Int32.Parse(LTid.Text);
int Pscore = Int32.Parse(TypeScore.Trim());
DateTime Pdate = DateTime.Now;
LearnSite.Model.Ptyper pmodel = new LearnSite.Model.Ptyper();
pmodel.Pdate = Pdate;
pmodel.Pip = Pip;
pmodel.Pscore = Pscore;
pmodel.Psnum = Psnum;
pmodel.Ptid = Ptid;
pmodel.Ptype = 1;
LearnSite.BLL.Ptyper pt = new LearnSite.BLL.Ptyper();
if (pt.ExistsPsnum(Psnum))
{
pt.Update(pmodel);
}
else
{
pt.Add(pmodel);
}
Labelmsg.Text = "输入" + rightword + "个汉字" + " 用时" + Typetime.ToString() + "秒";
BtnType.Text = "成绩记录成功!";
BtnType.Enabled = false;
}
else
{
Labelmsg.Text = "字数太少不作记录" + " 用时" + Typetime.ToString() + "秒";
}
System.Threading.Thread.Sleep(500);
showtyper();
}
else
{
Labelmsg.Text = "打字时间太短不作记录" + " 用时" + Typetime.ToString() + "秒";
BtnType.Text = "成绩记录失败!";
}
}
