//private static List<HW_ZujuanNodes> TA68() //{ // List<HW_ZujuanNodes> models = new List<HW_ZujuanNodes>(); // string sql = $@"select * from HW_ZujuanNodes where ParentNodeID= {pId}; "; // SQLHelper.FindList(sql, (a) => // { // if (a.HasRows) // { // while (a.Read()) // { // HW_ZujuanNodes model = new HW_ZujuanNodes(); // model.ID = a.GetInt32(0); // model.NodeID = a.GetInt32(1); // model.NodeName = a.GetString(2); // model.ParentNodeID = a.GetInt32(3); // model.OrderNumber = a.IsDBNull(4) ? 0 : a.GetInt32(4); // model.TencentID = a.IsDBNull(5) ? "" : a.GetString(5); // models.Add(model); // } // } // }, null, CommandType.Text, DataBase.ZYTConnString); // return models; //} private static HW_ZujuanNodes T099(int NodeId) { HW_ZujuanNodes model = new HW_ZujuanNodes(); string sql = $@"select * from HW_ZujuanNodes where NodeID = {NodeId}; "; SQLHelper.FindList(sql, (a) => { if (a.HasRows) { while (a.Read()) { model.ID = a.GetInt32(0); model.NodeID = a.GetInt32(1); model.NodeName = a.GetString(2); model.ParentNodeID = a.GetInt32(3); model.OrderNumber = a.IsDBNull(4) ? 0 : a.GetInt32(4); model.TencentID = a.IsDBNull(5) ? "" : a.GetString(5); } } }, null, CommandType.Text, DataBase.ZYTConnString68); return model; }
private static bool T098(int NodeId, string TID) { HW_ZujuanNodes model = new HW_ZujuanNodes(); string sql = $@"update HW_ZujuanNodes set TencentID='{TID}' where NodeID = {NodeId};"; return Convert.ToInt32(SQLHelper.ExecuteScalar(sql, DataBase.ZYTConnString68)) > 0; }