//绑定数据
private void BindData(int ID)
{
LabMS.BLL.PositionLog pLog = new LabMS.BLL.PositionLog();
LabMS.Model.PositionLog pLogInfo = new LabMS.Model.PositionLog();
pLogInfo = pLog.GetModel(ID);
PLogTeacherName.Text = pLogInfo.PLog_TeacherName;
PLogTime.Text = pLogInfo.PLog_Time.Value.ToShortDateString();
PLogEquipment.Text = pLogInfo.PLog_Equipment;
PLogLabIntro.Text = pLogInfo.PLog_LabIntro;
PLogOther.Text = pLogInfo.PLog_Other;
}
protected void Submit_OnClick(object sender, EventArgs e)
{
#region 验证
if (string.IsNullOrEmpty(PLogTeacherName.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "教师名称不能为空!");
return;
}
if (string.IsNullOrEmpty(PLogTime.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "时间不能为空!");
return;
}
if (string.IsNullOrEmpty(PLogLabIntro.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "实验教学情况不能为空!");
return;
}
if (string.IsNullOrEmpty(PLogEquipment.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(Page, "err", "仪器设备运行情况不能为空!");
return;
}
#endregion
LabMS.Model.PositionLog posLog = new LabMS.Model.PositionLog();
LabMS.BLL.PositionLog posLogInfo = new LabMS.BLL.PositionLog();
ExtendBLL.PositionLog positionLog = new ExtendBLL.PositionLog();
posLog.PLog_TeacherCode = UserCode;
posLog.PLog_TeacherName = PLogTeacherName.Text.Trim();
posLog.PLog_Time = Convert.ToDateTime(PLogTime.Text.Trim());
posLog.PLog_LabIntro = PLogLabIntro.Text.ToString().Trim();
posLog.PLog_Equipment = PLogEquipment.Text.Trim();
posLog.PLog_Other = PLogOther.Text.Trim();
posLog.PLog_RecodeTime = DateTime.Now;
posLogInfo.Add(posLog);
LabMS.Common.JShelper.JSAlertAndRedirect(Page,"AddSuccess","添加成功!","AddPositionLog.aspx");
}
/// <summary>
/// �õ�һ������ʵ��
/// </summary>
public LabMS.Model.PositionLog GetModel(int ID)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 ID,PLog_Time,PLog_TeacherCode,PLog_TeacherName,PLog_RecodeTime,PLog_LabIntro,PLog_Equipment,PLog_Other,PLog_IP from PositionLog ");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters = {
new SqlParameter("@ID", SqlDbType.Int,4)};
parameters[0].Value = ID;
LabMS.Model.PositionLog model=new LabMS.Model.PositionLog();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
if(ds.Tables[0].Rows[0]["ID"].ToString()!="")
{
model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if(ds.Tables[0].Rows[0]["PLog_Time"].ToString()!="")
{
model.PLog_Time=DateTime.Parse(ds.Tables[0].Rows[0]["PLog_Time"].ToString());
}
model.PLog_TeacherCode=ds.Tables[0].Rows[0]["PLog_TeacherCode"].ToString();
model.PLog_TeacherName=ds.Tables[0].Rows[0]["PLog_TeacherName"].ToString();
if(ds.Tables[0].Rows[0]["PLog_RecodeTime"].ToString()!="")
{
model.PLog_RecodeTime=DateTime.Parse(ds.Tables[0].Rows[0]["PLog_RecodeTime"].ToString());
}
model.PLog_LabIntro=ds.Tables[0].Rows[0]["PLog_LabIntro"].ToString();
model.PLog_Equipment=ds.Tables[0].Rows[0]["PLog_Equipment"].ToString();
model.PLog_Other=ds.Tables[0].Rows[0]["PLog_Other"].ToString();
model.PLog_IP=ds.Tables[0].Rows[0]["PLog_IP"].ToString();
return model;
}
else
{
return null;
}
}