public JsonResult GetRelation(long onlineMulu)
{
RelationModel model = new RelationModel();
var relList = new OnlineMuluRelationService().GetByOnlineMuluId(onlineMulu);
OnlineMuluRelation rel = null;
if (relList != null && relList.Count > 0)
{
rel = relList.FirstOrDefault();
}
if (rel != null)
{
model.ask120Relation = rel.Ask120Relation;
model.fhRelation = rel.FHRelation;
model.JJRelation = rel.JJRelation;
model.JKRelation = rel.JKRelation;
model.SJRelation = rel.SJRelation;
}
else
{
//model.ask120Relation = "";
//model.fhRelation = "";
//model.JJRelation = "";
//model.JKRelation = "";
//model.SJRelation = "";
}
return(Json(model));
}
public void Update(OnlineMuluRelation relation)
{
MySqlConnection con = GetConnection();
con.Execute(String.Format(@"update onlinemulurelation set Ask120Relation='{0}',
FHRelation='{1}',JJRelation='{2}',JKRelation='{3}',SJRelation='{4}'", relation.Ask120Relation, relation.FHRelation, relation.JJRelation, relation.JKRelation, relation.SJRelation));
}
public void Add(OnlineMuluRelation relation)
{
MySqlConnection con = GetConnection();
con.Execute(String.Format(@"insert into onlinemulurelation (OnlineMuluId,Ask120Relation,FHRelation,JJRelation,JKRelation,SJRelation)
values({0}, '{1}', '{2}', '{3}', '{4}', '{5}')",
relation.OnlineMuluId, relation.Ask120Relation, relation.FHRelation, relation.JJRelation, relation.JKRelation, relation.SJRelation));
}
public JsonResult EditRelation(long currentMuluId, string ask120Relation, string fhRelation, string JJRelation, string JKRelation, string SJRelation)
{
OnlineMuluRelation relation = new OnlineMuluRelation();
relation.OnlineMuluId = currentMuluId;
relation.Ask120Relation = ask120Relation;
relation.FHRelation = fhRelation;
relation.JJRelation = JJRelation;
relation.JKRelation = JKRelation;
relation.SJRelation = SJRelation;
new OnlineMuluRelationService().Save(relation);
return(Json("success"));
}
public void Save(OnlineMuluRelation relation)
{
var relationList = GetByOnlineMuluId(relation.OnlineMuluId);
if (relationList != null && relationList.Count > 0)
{
Update(relation);
}
else
{
Add(relation);
}
}
