protected void Page_Load(object sender, EventArgs e)
{
Student sid = new Student
{
Studentname = Request.Params["sname"],
Studentid = Convert.ToInt32(Request.Params["sid"])
};
string atime = Request.Params["atime"];
string adesc = Request.Params["adesc"];
int atag = Convert.ToInt32(Request.Params["atag"]);
AssignInfo aif = new AssignInfo
{
Assigndesc = adesc,
Assignid = 0,
Assigntime = atime,
Studentid = sid,
Assigntag = atag,
Studentname = ""
};
bool res = am.AddAssignInfo(aif);
new ExportResponse().ExportJson(new { result = res });
//private string _assigntime;
//private string _assigndesc;
//private int _assigntag;
//private string _studentname;
}
public bool AddAssignInfo(AssignInfo asg)
{
string sql = "insert into wxb_0604assigninfo values(seq_0604assign.nextval,:sd,to_date(:atime,'yyyy-mm-dd-hh24:mi'),:adc,:atg)";
List <OracleParameter> paras = new List <OracleParameter>();
paras.Add(new OracleParameter(":sd", asg.Studentid.Studentid));
paras.Add(new OracleParameter(":atime", asg.Assigntime));
paras.Add(new OracleParameter(":adc", asg.Assigndesc));
paras.Add(new OracleParameter(":atg", asg.Assigntag));
return(base.ExecuteNonSelect(sql, paras) > 0 ? true : false);
}
public List <AssignInfo> GetResultAssign(string sid, int cid, string start, string end)
{
string sql = @"select x.*,to_char(x.assigntime,'yyyy-mm-dd hh:mi:ss') atime from (select a.*,c.classid,s.studentname
from wxb_0604assigninfo a ,wxb_0604classinfo c, wxb_0604student s
where s.classid = c.classid and a.studentid = s.studentid) x
where(x.classid =:cid or 0 >=:isall)
and x.studentname like '%'||:sn||'%'
and x.assigntime > to_date(:st, 'yyyy-mm-dd-hh24:mi')
and x.assigntime < to_date(:en, 'yyyy-mm-dd-hh24:mi')";
List <OracleParameter> paras = new List <OracleParameter>();
paras.Add(new OracleParameter(":cid", cid));
paras.Add(new OracleParameter(":isall", Math.Sign(cid)));
paras.Add(new OracleParameter(":sn", sid));
paras.Add(new OracleParameter(":st", start));
paras.Add(new OracleParameter(":en", end));
OracleDataReader dr = base.ExecuteSelect(sql, paras);
List <AssignInfo> lista = new List <AssignInfo>();
ClassInfoService cs = new ClassInfoService();
while (dr.Read())
{
var a = new AssignInfo
{
Assignid = Convert.ToInt32(dr["assignid"]),
Assigntime = dr["atime"].ToString(),
Assigndesc = dr["assigndesc"].ToString(),
Assigntag = Convert.ToInt32(dr["assigntag"]),
Studentname = dr["studentname"].ToString(),
Classinfo = cs.GetClassInfoById(cid)
};
lista.Add(a);
}
dr.Close();
return(lista);
}
public bool AddAssignInfo(AssignInfo asg)
{
return(ais.AddAssignInfo(asg));
}
