//数据绑定
void Bind()
{
int gid = Str2Int(q("id"), 0);
Daiv_OA.Entity.StudentEntity model = new Daiv_OA.Entity.StudentEntity();
model = new Daiv_OA.BLL.StudentBLL().GetEntity(gid);
this.Snumber.Text = model.Snumber;
this.Sname.Text = model.Sname;
this.Sbirthday.Text = model.Sbirthday.ToString("yyyy-MM-dd");
//绑定家长联系电话
List <Daiv_OA.Entity.ContactEntity> cModels = new Daiv_OA.BLL.ContactBLL().GetEntitysBySid(model.Sid);
StringBuilder sbuilder = new StringBuilder();
sbuilder.AppendLine("<table id = \"contactTable\" class=\"ipt\" width=\"280px;\" >");
sbuilder.AppendLine("<thead><tr><td>名称</td><td>电话号码</td><td>操作<input type=\"button\" id =\"contactAdd\" value =\"添加\" /></td></tr></thead>");
int index = 0;
if (cModels != null && cModels.Count > 0)
{
foreach (var item in cModels)
{
sbuilder.AppendLine("<tr class=\"contactTr\">");
sbuilder.AppendLine("<td><input type = \"text\" name =\"contactName\" value =\"" + item.CPhoneName + "\" maxlength=\"32\" onkeyup =\"value = value.replace(/[^\\a-\\z\\-\\Z0-9\\u4E00-\\u9FA5]/g, '')\" onpaste =\"return false\" oncontextmenu =\"return false; \" /></td>");
sbuilder.AppendLine("<td ><input type = \"text\" name =\"contactPhone\" value =\"" + item.Cphone + "\" style =\"width:120px;\" onkeyup=\"value = value.replace(/[^0-9]/g,'')\" onpaste=\"return false\" oncontextmenu=\"return false; \" /></td>");
sbuilder.AppendLine("<td><input type = \"button\" class=\"contactDelete\" value =\"删除\" style =\"" + (index == 0? "display:none;" : "") + "\" /></td>");
sbuilder.AppendLine("</tr>");
index++;
}
}
else
{
sbuilder.AppendLine("<tr class=\"contactTr\">");
sbuilder.AppendLine("<td><input type = \"text\" name =\"contactName\" value =\"\" style =\"width:60px;\" /></td>");
sbuilder.AppendLine("<td ><input type = \"text\" name =\"contactPhone\" value =\"\" style =\"width:120px;\" /></td>");
sbuilder.AppendLine("<td><input type = \"button\" class=\"contactDelete\" value =\"删除\" style =\"display:none;\" /></td>");
sbuilder.AppendLine("</tr>");
}
sbuilder.AppendLine("</table>");
this.ltMasterSetting.Text = sbuilder.ToString();
//设置班级
SchClassId = model.Gid;
//设置年级
Entity.GradeEntity cmodel = new BLL.GradeBLL().GetEntity(SchClassId);
Entity.SchoolGradeEntity gmodel = null;
if (cmodel != null)
{
SchGradeId = cmodel.GgradeID;
//获取学校对象
gmodel = new BLL.SchoolGradeBLL().GetEntity(SchGradeId);
}
//设置学校
if (gmodel != null)
{
SchID = gmodel.SchoolID;
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Daiv_OA.Entity.StudentEntity model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [OA_Student] set ");
strSql.Append("Gname='" + model.Gname + "',");
strSql.Append("Snumber='" + model.Snumber + "',");
strSql.Append("Gid=" + model.Gid + ",");
strSql.Append("MechID=" + model.MechID + ",");
strSql.Append("Uid=" + model.Uid + ",");
strSql.Append("Sname='" + model.Sname + "',");
strSql.Append("Sbirthday='" + model.Sbirthday + "'");
strSql.Append(" where Sid=" + model.Sid + " ");
DbHelperSQL.ExecuteSql(strSql.ToString());
}
/// <summary>
/// 根据学号获取学生信息
/// </summary>
/// <param name="number"></param>
/// <returns></returns>
public Daiv_OA.Entity.StudentEntity GetEntityByNumber(string number)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ");
strSql.Append(" Sid ,Snumber ,Gid ,Uid ,Sbirthday ,IsDeleted,MechID ,Sname,Gname ");
strSql.Append(" FROM [OA_Student] ");
strSql.Append(" where Snumber='" + number + "' ");
Daiv_OA.Entity.StudentEntity model = new Daiv_OA.Entity.StudentEntity();
DataSet ds = DbHelperSQL.Query(strSql.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
return(ConvertModel(ds.Tables[0], 0));
}
else
{
return(null);
}
}
/// <summary>
/// 构造实体对象
/// </summary>
/// <param name="dt"></param>
/// <param name="rowindex"></param>
/// <returns></returns>
public Daiv_OA.Entity.StudentEntity ConvertModel(DataTable dt, int rowindex)
{
Daiv_OA.Entity.StudentEntity model = new Daiv_OA.Entity.StudentEntity();
try
{
if (dt.Rows[rowindex]["Sid"].ToString() != "")
{
model.Sid = int.Parse(dt.Rows[rowindex]["Sid"].ToString());
}
if (dt.Rows[rowindex]["Gid"].ToString() != "")
{
model.Gid = int.Parse(dt.Rows[rowindex]["Gid"].ToString());
}
if (dt.Rows[rowindex]["Uid"].ToString() != "")
{
model.Uid = int.Parse(dt.Rows[rowindex]["Uid"].ToString());
}
if (dt.Rows[rowindex]["MechID"].ToString() != "")
{
model.MechID = int.Parse(dt.Rows[rowindex]["MechID"].ToString());
}
if (dt.Rows[rowindex]["Sbirthday"].ToString() != "")
{
model.Sbirthday = DateTime.Parse(dt.Rows[rowindex]["Sbirthday"].ToString());
}
model.Snumber = dt.Rows[rowindex]["Snumber"].ToString();
model.Gname = dt.Rows[rowindex]["Gname"].ToString();
model.Sname = dt.Rows[rowindex]["Sname"].ToString();
if (dt.Rows[rowindex]["IsDeleted"].ToString() != "")
{
model.IsDeleted = int.Parse(dt.Rows[rowindex]["IsDeleted"].ToString());
}
}
catch (Exception ex)
{
log.Info("转换成用户对象失败！原因：" + ex.Message);
return(new Entity.StudentEntity());
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Daiv_OA.Entity.StudentEntity model)
{
if (Exists(model.Gname))//已经存在该用户
{
return(0);
}
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.Gname != null)
{
strSql1.Append("Gname,");
strSql2.Append("'" + model.Gname + "',");
}
if (model.Snumber != null)
{
strSql1.Append("Snumber,");
strSql2.Append("'" + model.Snumber + "',");
}
if (model.Gid > 0)
{
strSql1.Append("Gid,");
strSql2.Append("" + model.Gid + ",");
}
if (model.Uid > 0)
{
strSql1.Append("Uid,");
strSql2.Append("" + model.Uid + ",");
}
if (model.MechID > 0)
{
strSql1.Append("MechID,");
strSql2.Append("" + model.MechID + ",");
}
if (model.Sbirthday != null)
{
strSql1.Append("Sbirthday,");
strSql2.Append("'" + model.Sbirthday + "',");
}
if (model.Sname != null)
{
strSql1.Append("Sname,");
strSql2.Append("'" + model.Sname + "',");
}
if (model.IsDeleted >= 0)
{
strSql1.Append("IsDeleted,");
strSql2.Append("" + model.IsDeleted + ",");
}
strSql.Append("insert into [OA_Student](");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DbHelperSQL.GetSingle(strSql.ToString());
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
