public int ReplaceLianSai(string LianSai_a, string LianSai_b, int i)
{
string sql = null;
int iLianSaiID1 = Conf.GetLianSaiID(LianSai_a);
int iLianSaiID2 = Conf.GetLianSaiID(LianSai_b);
if (iLianSaiID1 == -1 && iLianSaiID2 == -1)
{
if (LianSai_a == LianSai_b)
{
Conf.LianSai.Add(LianSai_a, i);
sql += "INSERT INTO lst (ls,val) VALUES ('" + LianSai_a + "'," + i.ToString() + ")";
}
else
{
Conf.LianSai.Add(LianSai_a, i);
Conf.LianSai.Add(LianSai_b, i);
sql += "INSERT INTO lst (ls,val) VALUES ('" + LianSai_a + "'," + i.ToString() + ");";
sql += "INSERT INTO lst (ls,val) VALUES ('" + LianSai_b + "'," + i.ToString() + ")";
}
}
else
{
if (iLianSaiID1 > -1 && iLianSaiID2 == -1)
{
Conf.LianSai.Add(LianSai_b, iLianSaiID1);
sql += "INSERT INTO lst (ls,val) VALUES ('" + LianSai_b + "'," + iLianSaiID1.ToString() + ")";
}
else if (iLianSaiID1 == -1 && iLianSaiID2 > -1)
{
Conf.LianSai.Add(LianSai_a, iLianSaiID2);
sql += "INSERT INTO lst (ls,val) VALUES ('" + LianSai_a + "'," + iLianSaiID2.ToString() + ")";
}
}
if (sql != null)
{
database.ExecuteSQLiteTran(sql);
}
return(1);
}
