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