public Model_StudentToParent DataRowToModel_AddBaby(DataRow row)
{
Model_StudentToParent parent = new Model_StudentToParent();
if (row != null)
{
if (row["StudentToParent_ID"] != null)
{
parent.StudentToParent_ID = row["StudentToParent_ID"].ToString();
}
if (row["Student_ID"] != null)
{
parent.Student_ID = row["Student_ID"].ToString();
}
if (row["Parent_ID"] != null)
{
parent.Parent_ID = row["Parent_ID"].ToString();
}
if ((row["CreateTime"] != null) && (row["CreateTime"].ToString() != ""))
{
parent.CreateTime = new DateTime?(DateTime.Parse(row["CreateTime"].ToString()));
}
if ((row["UserName"] != null) && (row["UserName"].ToString() != ""))
{
parent.UserName = row["UserName"].ToString();
}
if ((row["Email"] != null) && (row["Email"].ToString() != ""))
{
parent.Email = row["Email"].ToString();
}
}
return(parent);
}
public bool Add(Model_StudentToParent model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into StudentToParent(");
builder.Append("StudentToParent_ID,Student_ID,Parent_ID,CreateTime)");
builder.Append(" values (");
builder.Append("@StudentToParent_ID,@Student_ID,@Parent_ID,@CreateTime)");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@StudentToParent_ID", SqlDbType.Char, 0x24), new SqlParameter("@Student_ID", SqlDbType.Char, 0x24), new SqlParameter("@Parent_ID", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime) };
cmdParms[0].Value = model.StudentToParent_ID;
cmdParms[1].Value = model.Student_ID;
cmdParms[2].Value = model.Parent_ID;
cmdParms[3].Value = model.CreateTime;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public bool Update(Model_StudentToParent model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update StudentToParent set ");
builder.Append("Student_ID=@Student_ID,");
builder.Append("Parent_ID=@Parent_ID,");
builder.Append("CreateTime=@CreateTime");
builder.Append(" where StudentToParent_ID=@StudentToParent_ID ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@Student_ID", SqlDbType.Char, 0x24), new SqlParameter("@Parent_ID", SqlDbType.Char, 0x24), new SqlParameter("@CreateTime", SqlDbType.DateTime), new SqlParameter("@StudentToParent_ID", SqlDbType.Char, 0x24) };
cmdParms[0].Value = model.Student_ID;
cmdParms[1].Value = model.Parent_ID;
cmdParms[2].Value = model.CreateTime;
cmdParms[3].Value = model.StudentToParent_ID;
return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public List <Model_StudentToParent> DataTableToList(DataTable dt)
{
List <Model_StudentToParent> list = new List <Model_StudentToParent>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Model_StudentToParent item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
try
{
BLL_F_User bll = new BLL_F_User();
Model_F_User model = new Model_F_User();
string UserName = txtUserName.Text.Trim();
string PassWord = txtPassWord.Text.Trim();
model = bll.GetModel(UserName, Rc.Common.StrUtility.DESEncryptLogin.EncryptString(PassWord));
if (model == null)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('账号或密码不正确，请重新填写',{icon:4,time:2000,offset:'10px'})})</script>");
return;
}
else
{
BLL_StudentToParent Sbll = new BLL_StudentToParent();
Model_StudentToParent Smodel = new Model_StudentToParent();
DataTable dt = Sbll.GetList("Student_ID='" + model.UserId + "' and parent_id='" + FloginUser.UserId + "'").Tables[0];
if (model.UserIdentity == "S" && dt.Rows.Count == 0)
{
Smodel.StudentToParent_ID = Guid.NewGuid().ToString();
Smodel.Parent_ID = FloginUser.UserId;
Smodel.Student_ID = model.UserId;
Smodel.CreateTime = DateTime.Now;
if (Sbll.Add(Smodel))
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('添加成功',{icon:1,time:2000,offset:'10px'},function(){parent.window.location.reload()})})</script>");
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('账号不正确或此账号已绑定',{icon:4,time:2000,offset:'10px'})})</script>");
return;
}
}
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "Save", "<script type='text/javascript'>layer.ready(function(){layer.msg('" + ex.Message + "',{icon:4,time:2000,offset:'10px'})})</script>");
}
}
public bool Add(Model_StudentToParent model)
{
return(this.dal.Add(model));
}
public bool Update(Model_StudentToParent model)
{
return(this.dal.Update(model));
}
