public bool ChangeActive(ActiveOperationParam activeOperationParam)
{
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(ActiceSqls.UPDATE_ACTIVE_STATE_FROM_T_BUSS_ACTIVE, activeOperationParam.operation, activeOperationParam.activeId);
string select = selectBuilder.ToString();
if (DatabaseOperationWeb.ExecuteDML(select))
{
return(true);
}
else
{
return(false);
}
}
public List <string> CheckActive(ActiveOperationParam activeOperationParam)
{
List <string> list = new List <string>();
StringBuilder selectBuilder = new StringBuilder();
selectBuilder.AppendFormat(ActiceSqls.SELECT_ACTIVE_STATE_FROM_T_BUSS_ACTIVE, activeOperationParam.activeId);
string select = selectBuilder.ToString();
DataTable dt = DatabaseOperationWeb.ExecuteSelectDS(select, "T").Tables[0];
if (dt.Rows.Count > 0)
{
string state = dt.Rows[0]["ACTIVE_STATE"].ToString();
string time = dt.Rows[0]["ACTIVE_TIME_TO"].ToString();
list.Add(state);
list.Add(time);
}
return(list);
}
