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); }